From 7c03af0e4cabb12e27b2070c849758428a3600cc Mon Sep 17 00:00:00 2001 From: tuqin <tuqin@tuqin.cn> Date: 星期二, 03 十一月 2026 10:43:04 +0800 Subject: [PATCH] fix(hrm): 补齐薪酬模块缺失的 7 个权限项,修复非超管角色 403 --- sql/mysql/hrm_salary_fix_permission.sql | 64 ++++++++++++++++++++++++++++++++ 1 files changed, 64 insertions(+), 0 deletions(-) diff --git a/sql/mysql/hrm_salary_fix_permission.sql b/sql/mysql/hrm_salary_fix_permission.sql new file mode 100644 index 0000000..16ed521 --- /dev/null +++ b/sql/mysql/hrm_salary_fix_permission.sql @@ -0,0 +1,64 @@ +-- ===================================================================== +-- 淇钖叕妯″潡銆屾潈闄愮爜涓嶅尮閰嶃�嶉棶棰� +-- +-- 闂鐜拌薄锛� +-- 闈炶秴绾х鐞嗗憳瑙掕壊锛屽嵆浣胯鎺堜簣銆岃柂閰鐞嗐�嶈彍鍗曪紝鐐硅繘鍘讳篃鎶� +-- 銆屾病鏈夎鎿嶄綔鏉冮檺銆嶏紙HTTP 403锛夈�� +-- +-- 鏍瑰洜锛� +-- 鑿滃崟琛ㄩ噷鐨勬潈闄愮爜鏄� hrm:salary-calculation:* / hrm:salary-payment:*锛� +-- 浣嗗悗绔� Controller 鏍¢獙鐨勬槸 hrm:salary:query / :calculate / :pay 绛夛紝 +-- 涓ゅ缂栫爜瀹屽叏瀵逛笉涓娿�傝彍鍗曢噷鏍规湰娌℃湁鍚庣瑕佺殑閭d簺鏉冮檺椤癸紝 +-- 鎵�浠ュ湪銆岃鑹茬鐞嗐�嶉噷鏃犺鎬庝箞鍕鹃�夛紝瑙掕壊閮芥嬁涓嶅埌瀵瑰簲鏉冮檺鐮併�� +-- 瓒呯骇绠$悊鍛樺洜涓烘鏋剁洿鎺ユ斁琛岋紝鎵�浠ュ彧鏈� admin 鑳界敤銆� +-- +-- 淇鏂瑰紡锛� +-- 鎶婂悗绔疄闄呮牎楠岀殑 7 涓潈闄愮爜琛ユ垚鑿滃崟鏉冮檺椤癸紙type=3锛夛紝 +-- 鎸傚湪銆岃柂閰牳绠椼��(6021) 涓庛�岃柂璧勫彂鏀俱��(6022) 涓嬶紝 +-- 涔嬪悗鍦ㄣ�岃鑹茬鐞嗐�嶉噷灏辫兘姝e父鍕鹃�夈�� +-- +-- 鐗规�э細鍙噸澶嶆墽琛� +-- ===================================================================== + +-- 娓呯悊鏃х殑琛ヤ竵椤癸紙鎸� id 娈碉級 +DELETE FROM system_role_menu WHERE menu_id BETWEEN 60215 AND 60225; +DELETE FROM system_menu WHERE id BETWEEN 60215 AND 60225; + +-- --------------------------------------------------------------------- +-- 钖叕鏍哥畻锛�6021锛変笅琛ワ細鏌ョ湅 / 鏍哥畻 / 纭 / 鍒犻櫎 / 瀵煎嚭 +-- --------------------------------------------------------------------- +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 +(60215, '钖叕鏌ョ湅', 'hrm:salary:query', 3, 10, 6021, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(60216, '钖叕鏍哥畻鎵ц', 'hrm:salary:calculate', 3, 11, 6021, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(60217, '钖叕鏍哥畻纭', 'hrm:salary:confirm', 3, 12, 6021, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(60218, '钖叕鏍哥畻鍒犻櫎', 'hrm:salary:delete', 3, 13, 6021, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(60219, '钖叕鏍哥畻瀵煎嚭', 'hrm:salary:export', 3, 14, 6021, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); + +-- --------------------------------------------------------------------- +-- 钖祫鍙戞斁锛�6022锛変笅琛ワ細鐢熸垚 / 鍙戞斁 +-- --------------------------------------------------------------------- +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 +(60220, '鐢熸垚鍙戞斁鍙拌处', 'hrm:salary:generate', 3, 10, 6022, '', '', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(60221, '钖祫鍙戞斁', 'hrm:salary:pay', 3, 11, 6022, '', '', 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 60215 AND 60225; + +-- --------------------------------------------------------------------- +-- 楠岃瘉锛氳柂閰ā鍧椾笅鐨勫叏閮ㄦ潈闄愰」 +-- --------------------------------------------------------------------- +SELECT m.id, m.parent_id, m.name, m.permission, m.type +FROM system_menu m +WHERE m.id IN (6021, 6022) OR m.parent_id IN (6021, 6022) +ORDER BY m.parent_id, m.sort, m.id; -- Gitblit v1.9.3