-- ============================================================ -- 2026-11-08 HRM 权限补充 -- 1. hrm:leave:import 请假申请 Excel 导入 / 模板下载 -- 2. hrm:overtime:manage 加班代申请:查看并操作全部人的加班单 -- 说明:项目不使用多租户,SQL 不包含 tenant_id。 -- ============================================================ -- 1. 菜单/权限 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 (1075663, '请假申请-导入', 'hrm:leave:import', 3, 91, 6003, '', '#', '', NULL, 0, 1, 0, 1, '1', NOW(), '1', NOW(), 0) ON DUPLICATE KEY UPDATE name = VALUES(name), permission = VALUES(permission), deleted = 0, update_time = NOW(); 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 (1075664, '加班代申请管理', 'hrm:overtime:manage', 3, 6, 1065211, '', '#', '', NULL, 0, 1, 0, 1, '1', NOW(), '1', NOW(), 0) ON DUPLICATE KEY UPDATE name = VALUES(name), permission = VALUES(permission), deleted = 0, update_time = NOW(); -- 2. 角色授权:请假导入授予 163-168;加班代申请管理授予 166 生产管理员、168 经理 INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT r.role_id, 1075663, '1', NOW(), '1', NOW(), 0 FROM (SELECT 163 AS role_id UNION ALL SELECT 164 UNION ALL SELECT 165 UNION ALL SELECT 166 UNION ALL SELECT 167 UNION ALL SELECT 168) r WHERE NOT EXISTS (SELECT 1 FROM system_role_menu rm WHERE rm.role_id = r.role_id AND rm.menu_id = 1075663 AND rm.deleted = 0); INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT r.role_id, 1075664, '1', NOW(), '1', NOW(), 0 FROM (SELECT 166 AS role_id UNION ALL SELECT 168) r WHERE NOT EXISTS (SELECT 1 FROM system_role_menu rm WHERE rm.role_id = r.role_id AND rm.menu_id = 1075664 AND rm.deleted = 0);