-- ===================================================================== -- 安全生产模块 —— 七期:安全数据统计分析 -- -- 定位:按时间段与车间筛选,输出隐患/作业票/培训/证书四个维度的分组统计, -- 并支持隐患明细导出 Excel。不新增业务表。 -- -- 与「安全看板」的区别: -- 看板 = 实时全局概览,不可筛选、不导出 -- 统计分析 = 可指定时间范围与车间,出分组报表,可导出 -- -- 内容:菜单「统计分析」 -- -- 特性:可重复执行 -- ===================================================================== DELETE FROM system_role_menu WHERE menu_id BETWEEN 1065963 AND 1065965; DELETE FROM system_menu WHERE id BETWEEN 1065963 AND 1065965; 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 (1065963, '统计分析', '', 2, 8, 1065910, 'statistics', 'ep:trend-charts', 'safety/statistics/index', 'SafetyStatistics', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065964, '统计查询', 'mes:safety-statistics:query', 3, 1, 1065963, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065965, '报表导出', 'mes:safety-statistics:export', 3, 2, 1065963, '', '', 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 1065963 AND 1065965; -- --------------------------------------------------------------------- -- 验证:安全生产目录下的完整菜单结构 -- --------------------------------------------------------------------- SELECT id, parent_id, name, path, component, permission, type, sort FROM system_menu WHERE id BETWEEN 1065910 AND 1065970 ORDER BY sort, id;