-- ===================================================================== -- 安全生产模块 —— 六期:风险可视化看板 -- -- 定位:把风险、隐患、作业票、培训、证书五块数据集中呈现,供管理层一眼看全局。 -- 不新增业务表,只做数据聚合展示。 -- -- 内容:菜单「安全看板」,置于安全生产目录首位 -- -- 特性:可重复执行 -- ===================================================================== DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065961 AND 1065962; DELETE FROM system_menu WHERE id BETWEEN 1065961 AND 1065962; 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 (1065961, '安全看板', '', 2, 0, 1065910, 'dashboard', 'ep:data-analysis', 'safety/dashboard/index', 'SafetyDashboard', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065962, '看板查询', 'mes:safety-dashboard:query', 3, 1, 1065961, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); 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 1065961 AND 1065970; -- --------------------------------------------------------------------- -- 验证:安全生产目录下的全部菜单 -- --------------------------------------------------------------------- SELECT id, parent_id, name, path, component, permission, type, sort FROM system_menu WHERE id BETWEEN 1065910 AND 1065970 ORDER BY sort, id;