-- ===================================================================== -- 安全生产模块 —— 三期:隐患排查治理 -- -- 定位:双重预防机制的第二重。与一期「风险分级管控」配套使用: -- 隐患可关联到具体风险点,形成「风险识别 → 隐患排查 → 整改闭环」的完整链路。 -- -- 状态流转: -- 0 待整改 ──提交整改──> 20 待验收 ──验收通过──> 30 已闭环 -- │ -- └──验收驳回──> 10 整改中(重新整改) -- -- 内容: -- 1. 建表 mes_safety_hazard(隐患台账) -- 2. 字典:隐患来源 / 隐患等级 / 隐患状态 -- 3. 菜单:挂在「安全生产」目录下 -- 4. 授权超级管理员 -- -- 特性:可重复执行 -- ===================================================================== -- --------------------------------------------------------------------- -- 1. 隐患台账 -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `mes_safety_hazard` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `code` varchar(64) NOT NULL COMMENT '隐患编码', `name` varchar(200) NOT NULL COMMENT '隐患名称/简述', `source` tinyint DEFAULT NULL COMMENT '隐患来源(字典 mes_safety_hazard_source)', `hazard_level` tinyint DEFAULT NULL COMMENT '隐患等级(字典 mes_safety_hazard_level:1一般 2重大)', `category` tinyint DEFAULT NULL COMMENT '隐患类别(复用 mes_safety_risk_category)', `unit_id` bigint DEFAULT NULL COMMENT '关联风险单元编号', `risk_id` bigint DEFAULT NULL COMMENT '关联风险清单编号', `workshop_id` bigint DEFAULT NULL COMMENT '所属车间编号', `location` varchar(255) DEFAULT NULL COMMENT '具体位置', `description` varchar(1000) DEFAULT NULL COMMENT '隐患描述', `found_date` date DEFAULT NULL COMMENT '发现日期', `founder_user_id` bigint DEFAULT NULL COMMENT '发现人编号', `charge_user_id` bigint DEFAULT NULL COMMENT '整改责任人编号', `deadline` date DEFAULT NULL COMMENT '整改期限', `rectify_requirement` varchar(1000) DEFAULT NULL COMMENT '整改要求', `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态:0待整改 10整改中 20待验收 30已闭环', `measure` varchar(1000) DEFAULT NULL COMMENT '整改措施', `finish_date` date DEFAULT NULL COMMENT '整改完成日期', `check_user_id` bigint DEFAULT NULL COMMENT '验收人编号', `check_time` datetime DEFAULT NULL COMMENT '验收时间', `check_result` varchar(500) DEFAULT NULL COMMENT '验收意见/结论', `reject_reason` varchar(500) DEFAULT NULL COMMENT '验收驳回原因', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_code` (`code`) USING BTREE, KEY `idx_status` (`status`) USING BTREE, KEY `idx_workshop` (`workshop_id`) USING BTREE, KEY `idx_risk` (`risk_id`) USING BTREE, KEY `idx_deadline` (`deadline`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='安全生产-隐患排查台账'; -- --------------------------------------------------------------------- -- 2. 字典 -- --------------------------------------------------------------------- DELETE FROM system_dict_data WHERE dict_type IN ('mes_safety_hazard_source', 'mes_safety_hazard_level', 'mes_safety_hazard_status'); DELETE FROM system_dict_type WHERE type IN ('mes_safety_hazard_source', 'mes_safety_hazard_level', 'mes_safety_hazard_status'); INSERT INTO system_dict_type (name, type, status, remark, creator, create_time, updater, update_time, deleted) VALUES ('安全生产-隐患来源', 'mes_safety_hazard_source', 0, '隐患发现的途径', '1', NOW(), '1', NOW(), b'0'), ('安全生产-隐患等级', 'mes_safety_hazard_level', 0, '1一般隐患 2重大隐患', '1', NOW(), '1', NOW(), b'0'), ('安全生产-隐患状态', 'mes_safety_hazard_status', 0, '整改闭环状态', '1', NOW(), '1', NOW(), b'0'); INSERT INTO system_dict_data (sort, label, value, dict_type, status, color_type, creator, create_time, updater, update_time, deleted) VALUES -- 隐患来源 (1, '日常排查', '1', 'mes_safety_hazard_source', 0, 'default', '1', NOW(), '1', NOW(), b'0'), (2, '专项检查', '2', 'mes_safety_hazard_source', 0, 'processing', '1', NOW(), '1', NOW(), b'0'), (3, '上级检查', '3', 'mes_safety_hazard_source', 0, 'warning', '1', NOW(), '1', NOW(), b'0'), (4, '员工上报', '4', 'mes_safety_hazard_source', 0, 'default', '1', NOW(), '1', NOW(), b'0'), (5, '其他', '5', 'mes_safety_hazard_source', 0, 'default', '1', NOW(), '1', NOW(), b'0'), -- 隐患等级 (1, '一般隐患', '1', 'mes_safety_hazard_level', 0, 'warning', '1', NOW(), '1', NOW(), b'0'), (2, '重大隐患', '2', 'mes_safety_hazard_level', 0, 'error', '1', NOW(), '1', NOW(), b'0'), -- 隐患状态 (1, '待整改', '0', 'mes_safety_hazard_status', 0, 'error', '1', NOW(), '1', NOW(), b'0'), (2, '整改中', '10', 'mes_safety_hazard_status', 0, 'processing', '1', NOW(), '1', NOW(), b'0'), (3, '待验收', '20', 'mes_safety_hazard_status', 0, 'warning', '1', NOW(), '1', NOW(), b'0'), (4, '已闭环', '30', 'mes_safety_hazard_status', 0, 'success', '1', NOW(), '1', NOW(), b'0'); -- --------------------------------------------------------------------- -- 3. 菜单(挂在 1065910 安全生产下) -- --------------------------------------------------------------------- DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065927 AND 1065940; DELETE FROM system_menu WHERE id BETWEEN 1065927 AND 1065940; INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (1065927, '隐患排查治理', '', 2, 4, 1065910, 'hazard', 'ep:search', 'safety/hazard/index', 'SafetyHazard', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065928, '隐患查询', 'mes:safety-hazard:query', 3, 1, 1065927, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065929, '隐患登记', 'mes:safety-hazard:create', 3, 2, 1065927, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065930, '隐患更新', 'mes:safety-hazard:update', 3, 3, 1065927, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065931, '隐患删除', 'mes:safety-hazard:delete', 3, 4, 1065927, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065932, '提交整改', 'mes:safety-hazard:rectify', 3, 5, 1065927, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065933, '整改验收', 'mes:safety-hazard:check', 3, 6, 1065927, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -- --------------------------------------------------------------------- -- 4. 授权超级管理员 -- --------------------------------------------------------------------- INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT 1, m.id, '1', NOW(), '1', NOW(), b'0' FROM system_menu m WHERE m.id BETWEEN 1065927 AND 1065940; -- --------------------------------------------------------------------- -- 5. 验证 -- --------------------------------------------------------------------- SELECT id, parent_id, name, path, component, permission, type FROM system_menu WHERE id BETWEEN 1065910 AND 1065940 ORDER BY id; SELECT dict_type, label, value FROM system_dict_data WHERE dict_type LIKE 'mes_safety_hazard%' ORDER BY dict_type, sort;