-- 在途管理 / 风险处置

CREATE TABLE IF NOT EXISTS `blade_risk_disposal` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `tenant_id` varchar(12) NOT NULL DEFAULT '000000' COMMENT '租户ID',
  `create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_dept` bigint(20) DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `status` int(11) DEFAULT '1' COMMENT '状态',
  `is_deleted` int(11) DEFAULT '0' COMMENT '是否已删除',
  `risk_no` varchar(100) DEFAULT NULL COMMENT '风险编号',
  `rule_name` varchar(100) DEFAULT NULL COMMENT '规则名称',
  `waybill_id` bigint(20) DEFAULT NULL COMMENT '运单ID',
  `waybill_no` varchar(100) DEFAULT NULL COMMENT '运单号',
  `project_name` varchar(100) DEFAULT NULL COMMENT '项目名称',
  `vehicle_no` varchar(100) DEFAULT NULL COMMENT '车牌号',
  `risk_level` varchar(30) DEFAULT NULL COMMENT '风险等级',
  `transport_type` varchar(50) DEFAULT NULL COMMENT '运输类型',
  `risk_description` varchar(500) DEFAULT NULL COMMENT '风险描述',
  `disposal_status` varchar(30) NOT NULL DEFAULT 'pending' COMMENT '处置状态',
  `disposal_method` varchar(30) DEFAULT NULL COMMENT '处理方式',
  `disposal_remark` varchar(500) DEFAULT NULL COMMENT '处置说明',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属组织ID',
  `dept_name` varchar(100) DEFAULT NULL COMMENT '所属组织',
  `trigger_time` datetime DEFAULT NULL COMMENT '触发时间',
  `dispose_time` datetime DEFAULT NULL COMMENT '处理时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_risk_disposal_waybill` (`waybill_id`, `waybill_no`) USING BTREE,
  KEY `idx_risk_disposal_status` (`disposal_status`) USING BTREE,
  KEY `idx_risk_disposal_trigger_time` (`trigger_time`) USING BTREE,
  KEY `idx_risk_disposal_create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='风险处置';

INSERT INTO `blade_menu` (`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `component`, `remark`, `is_deleted`)
VALUES
(2090000000000003000, 0, 'transit_manage', '在途管理', 'transit_manage', '/transit', 'iconfont icon-caidanguanli', 90, 1, 0, 1, NULL, '', 0),
(2090000000000003001, 2090000000000003000, 'risk_disposal', '风险处置', 'risk_disposal', '/transit/risk-disposal', 'iconfont icon-caidanguanli', 2, 1, 0, 1, NULL, '', 0),
(2090000000000003002, 2090000000000003001, 'risk_disposal_view', '查看', 'risk_disposal_view', '', '', 1, 2, 0, 1, NULL, '', 0),
(2090000000000003003, 2090000000000003001, 'risk_disposal_follow', '处理', 'risk_disposal_follow', '', '', 2, 2, 0, 1, NULL, '', 0),
(2090000000000003004, 2090000000000003001, 'risk_disposal_batch_dispose', '批量处理', 'risk_disposal_batch_dispose', '', '', 3, 2, 0, 1, NULL, '', 0)
ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `path` = VALUES(`path`), `is_deleted` = 0;