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