-- ===================================================================== -- 安全生产模块 —— 一期:应急处置预案 -- -- 背景:蓝羽此前没有任何安全生产相关功能。经全仓库(22 个后端分支 + 21 个前端分支) -- 排查确认,仅「新高电力」分支存在应急处置预案(MesProEmergencyPlan), -- 作为安全生产模块的第一个能力点先落地,其余能力点(风险分级管控、 -- 隐患排查治理、特种作业票证、安全教育培训、可视化看板、统计分析)后续分期补充。 -- -- 内容: -- 1. 建表 mes_pro_emergency_plan -- 2. 新建一级菜单「安全生产」(/safety),便于后续能力点归入 -- 3. 挂入「应急处置预案」菜单及其按钮权限 -- 4. 授权给超级管理员 -- -- 特性:可重复执行 -- ===================================================================== -- --------------------------------------------------------------------- -- 1. 建表 -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `mes_pro_emergency_plan` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `code` varchar(64) NOT NULL COMMENT '预案编码', `name` varchar(200) DEFAULT NULL COMMENT '预案名称', `plan_type` tinyint DEFAULT NULL COMMENT '预案类型(1=停电,2=设备故障,3=火灾,4=自然灾害,5=其他)', `content` text COMMENT '处置内容', `org_unit` varchar(200) DEFAULT NULL COMMENT '责任单位/部门', `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态(0=草稿,10=已发布)', `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='MES 应急处置预案'; -- --------------------------------------------------------------------- -- 2. 菜单:安全生产(一级目录) -- --------------------------------------------------------------------- DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065910 AND 1065919; DELETE FROM system_menu WHERE id BETWEEN 1065910 AND 1065919; 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 (1065910, '安全生产', '', 1, 65, 0, '/safety', 'ep:warning', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -- --------------------------------------------------------------------- -- 3. 菜单:应急处置预案 + 按钮权限 -- --------------------------------------------------------------------- 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 (1065911, '应急处置预案', '', 2, 1, 1065910, 'emergency-plan', 'ep:document', 'mes/pro/emergencyplan/index', 'EmergencyPlan', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065912, '应急预案查询', 'mes:pro-emergency-plan:query', 3, 1, 1065911, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065913, '应急预案创建', 'mes:pro-emergency-plan:create', 3, 2, 1065911, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065914, '应急预案更新', 'mes:pro-emergency-plan:update', 3, 3, 1065911, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065915, '应急预案删除', 'mes:pro-emergency-plan:delete', 3, 4, 1065911, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065916, '应急预案导入', 'mes:pro-emergency-plan:import', 3, 5, 1065911, '', '', 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 1065910 AND 1065919; -- --------------------------------------------------------------------- -- 5. 字典:应急处置预案类型 -- --------------------------------------------------------------------- DELETE FROM system_dict_data WHERE dict_type = 'mes_pro_emergency_plan_type'; DELETE FROM system_dict_type WHERE type = 'mes_pro_emergency_plan_type'; INSERT INTO system_dict_type (name, type, status, remark, creator, create_time, updater, update_time, deleted) VALUES ('MES 应急处置预案类型', 'mes_pro_emergency_plan_type', 0, 'MES 应急处置预案类型(1=停电,2=设备故障,3=火灾,4=自然灾害,5=其他)', '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_pro_emergency_plan_type', 0, 'danger', '1', NOW(), '1', NOW(), b'0'), (2, '设备故障', '2', 'mes_pro_emergency_plan_type', 0, 'warning', '1', NOW(), '1', NOW(), b'0'), (3, '火灾', '3', 'mes_pro_emergency_plan_type', 0, 'error', '1', NOW(), '1', NOW(), b'0'), (4, '自然灾害', '4', 'mes_pro_emergency_plan_type', 0, 'processing', '1', NOW(), '1', NOW(), b'0'), (5, '其他', '5', 'mes_pro_emergency_plan_type', 0, 'default', '1', NOW(), '1', NOW(), b'0'); -- --------------------------------------------------------------------- -- 6. 验证 -- --------------------------------------------------------------------- SELECT id, parent_id, name, path, component, permission, type FROM system_menu WHERE id BETWEEN 1065910 AND 1065919 ORDER BY id; SELECT dict_type, label, value FROM system_dict_data WHERE dict_type = 'mes_pro_emergency_plan_type' ORDER BY sort;