-- ===================================================================== -- 我的薪资(员工自助查看工资条)初始化脚本 -- -- 背景:系统原先只有「薪酬核算 / 薪资发放」两个管理端页面,且需 hrm:salary:query -- 权限才能访问,普通员工看不到自己的工资。本脚本新增一个对所有人可见的 -- 「我的薪资」菜单,后端对应 /hrm/salary/calculation/my-page 接口, -- 该接口不校验薪酬查询权限,由服务端强制按登录人过滤,只能看到本人记录。 -- -- 特性:可重复执行(先按主键删除再插入) -- ===================================================================== -- --------------------------------------------------------------------- -- 1. 菜单:我的薪资(顶级菜单,对所有登录用户可见) -- --------------------------------------------------------------------- DELETE FROM system_role_menu WHERE menu_id = 1065900; DELETE FROM system_menu WHERE id = 1065900; 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 (1065900, '我的薪资', '', 2, 60, 0, '/my-payslip', 'ep:money', 'hrm/salary/my-payslip/index', 'MyPayslip', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -- --------------------------------------------------------------------- -- 2. 授权给所有角色(含后续新增角色需手动授权,或在角色管理中勾选) -- --------------------------------------------------------------------- INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted) SELECT r.id, 1065900, '1', NOW(), '1', NOW(), b'0' FROM system_role r WHERE r.deleted = b'0'; -- --------------------------------------------------------------------- -- 3. 验证 -- --------------------------------------------------------------------- SELECT m.id, m.name, m.path, m.component, m.type FROM system_menu m WHERE m.id = 1065900; SELECT r.id AS role_id, r.name AS role_name FROM system_role r JOIN system_role_menu rm ON rm.role_id = r.id AND rm.menu_id = 1065900 WHERE r.deleted = b'0' ORDER BY r.id;