-- ============================================================
|
-- 给「普通角色」开放请假功能
|
-- 生成时间:2026-10-30
|
--
|
-- 背景:请假是员工自助功能,但菜单 6003「人事审批 → 请假申请」
|
-- 原先只授权给 超级管理员 / 测试数据权限12 / 咖啡操作师,
|
-- 而实际员工都在「普通角色」下(共 94 个账号),
|
-- 导致员工访问请假功能全部 403,只有管理员能代录。
|
--
|
-- 授权范围(只开请假,不开其它 HR 模块):
|
-- 6001 人力资源 (父级目录,不加则子菜单无法显示)
|
-- 6002 人事审批 (父级目录)
|
-- 6003 请假申请 (菜单本身)
|
-- 60031 请假申请查询 hrm:leave:query
|
-- 60032 请假申请新增 hrm:leave:create
|
-- 60033 请假申请修改 hrm:leave:update
|
-- 60034 请假申请删除 hrm:leave:delete
|
-- 60035 请假申请提交 hrm:leave:submit
|
-- 60242 撤销 hrm:leave:cancel
|
-- 1075444 导出 hrm:leave:export
|
--
|
-- 明确【不】开放(避免员工越权看到敏感数据):
|
-- 6006 员工管理 1063105 员工合同
|
-- 6010 考勤管理 6020 薪酬管理
|
-- 6004 调岗申请 6005 离职申请
|
-- 1065211 加班申请 (如需开放请另行确认)
|
--
|
-- 幂等:NOT EXISTS 判断,可重复执行
|
-- 回滚:DELETE FROM system_role_menu WHERE role_id=2 AND menu_id IN (6001,6002,6003,60031,60032,60033,60034,60035,60242,1075444);
|
-- ============================================================
|
|
-- ---------- 1. 授权前:普通角色已有的 HR 菜单 ----------
|
SELECT x.menu_id, m.name FROM system_role_menu x
|
JOIN system_menu m ON m.id = x.menu_id
|
WHERE x.role_id = 2 AND x.deleted = b'0'
|
AND (m.id = 6001 OR m.parent_id IN (6001, 6002) OR m.id = 6002)
|
ORDER BY x.menu_id;
|
|
-- ---------- 2. 插入授权 ----------
|
INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted)
|
SELECT 2, t.menu_id, '1', NOW(), '1', NOW(), b'0'
|
FROM (
|
SELECT 6001 AS menu_id UNION ALL
|
SELECT 6002 UNION ALL
|
SELECT 6003 UNION ALL
|
SELECT 60031 UNION ALL
|
SELECT 60032 UNION ALL
|
SELECT 60033 UNION ALL
|
SELECT 60034 UNION ALL
|
SELECT 60035 UNION ALL
|
SELECT 60242 UNION ALL
|
SELECT 1075444
|
) t
|
WHERE NOT EXISTS (
|
SELECT 1 FROM system_role_menu x
|
WHERE x.role_id = 2 AND x.menu_id = t.menu_id
|
);
|
|
-- ---------- 3. 授权后校验 ----------
|
SELECT x.menu_id, m.name, m.permission
|
FROM system_role_menu x
|
JOIN system_menu m ON m.id = x.menu_id
|
WHERE x.role_id = 2 AND x.deleted = b'0'
|
AND x.menu_id IN (6001,6002,6003,60031,60032,60033,60034,60035,60242,1075444)
|
ORDER BY x.menu_id;
|
|
-- ---------- 4. 确认没有误开其它 HR 模块 ----------
|
SELECT m.id, m.name FROM system_role_menu x
|
JOIN system_menu m ON m.id = x.menu_id
|
WHERE x.role_id = 2 AND x.deleted = b'0'
|
AND (m.id IN (6004,6005,6006,6010,6020,1063105,1065211)
|
OR m.parent_id IN (6004,6005,6006,6010,6020,1063105,1065211));
|