From e4de23725189ed120646916a674e228f84e46349 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期三, 30 九月 2026 16:08:24 +0800
Subject: [PATCH] docs(wxcp): 修正默认角色授权条数 14 → 15
---
docs/sql/wxcp_menu.sql | 26 +++++++++++++++++++++++++-
1 files changed, 25 insertions(+), 1 deletions(-)
diff --git a/docs/sql/wxcp_menu.sql b/docs/sql/wxcp_menu.sql
index 13c4a52..63d4cb6 100644
--- a/docs/sql/wxcp_menu.sql
+++ b/docs/sql/wxcp_menu.sql
@@ -103,7 +103,7 @@
-- 涓轰粈涔堢敤缂栫爜涓嶇敤瑙掕壊缂栧彿锛氳鑹茬紪鍙峰湪鏈湴/娴嬭瘯/鐢熶骇鍚勫簱涓嶄竴鑷达紝鍐欐鎹㈠簱灏卞け鏁堛��
--
-- 鎺堜簣鑼冨洿锛氫粎銆屼細鍛樼鐞嗐�嶆暣妫靛瓙鏍戯紙鏍硅彍鍗曠紪鍙� 1075490锛屽畾涔夎 ums_module.sql锛夈��
--- 鍏� 14 鏉� = 鏍圭洰褰� 1 + 鑿滃崟 3 + 鎸夐挳 10锛屼笁绾у叏缁欍��
+-- 鍏� 15 鏉� = 鏍圭洰褰� 1 + 鑿滃崟 3 + 鎸夐挳 11锛屼笁绾у叏缁欍��
-- 棣栭〉涓嶅湪杩欓噷锛屼篃涓嶉渶瑕佸湪杩欓噷锛氬畠鏄墠绔潤鎬佽矾鐢憋紙src/router/routes/modules/
-- dashboard.ts 閲岀殑 /analytics锛夛紝backend 妯″紡涓嬬敱 generateRoutesByBackend 鏈熬鐨�
-- return [...options.routes, ...routes] 濮嬬粓鍚堝苟杩涙潵锛屼换浣曠櫥褰曠敤鎴烽兘鍙銆�
@@ -158,3 +158,27 @@
WHERE `role_id` = @wxcp_role_id
AND `deleted` = b'0') `t`
WHERE `t`.`user_id` = `u`.`id`);
+
+-- 5) 棣栭〉鏁版嵁鏉冮檺
+--
+-- 棣栭〉锛�/analytics锛夋湰韬槸鍓嶇闈欐�佽矾鐢便�佷汉浜哄彲瑙侊紝浣嗗畠鍐呴儴浼氳皟 4 涓悗绔帴鍙ｆ媺鏁版嵁锛�
+-- 杩欎簺鎺ュ彛閮藉甫 @PreAuthorize锛岃鑹茬己鏉冮檺鏃朵竴杩涢椤靛氨鎶ャ�屾病鏈夋潈闄愩�嶏細
+-- bpm/task/todo-page 鈫� bpm:task:query
+-- finance/reimbursement/page 鈫� finance:reimbursement:query
+-- research/application/page 鈫� research:application:query
+-- research/guideline/page 鈫� research:guideline:query
+--
+-- 鎸� permission 涓叉煡銆佷笉鍐欐鑿滃崟缂栧彿锛氱紪鍙峰湪鍚勫簱涓嶄竴鑷达紝鍐欐鎹㈠簱灏卞け鏁堛��
+-- 鍙巿鎸夐挳锛坱ype=3锛夈�佷笉鎺堝叾涓婄骇鑿滃崟锛屾墍浠ヤ笉浼氬線渚ц竟鏍忓 BPM / 璐㈠姟 / 绉戠爺鐨勫叆鍙ｃ��
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `updater`)
+SELECT @wxcp_role_id, `m`.`id`, 'admin', 'admin'
+FROM `system_menu` `m`
+WHERE `m`.`deleted` = b'0'
+ AND `m`.`permission` IN ('bpm:task:query', 'finance:reimbursement:query',
+ 'research:application:query', 'research:guideline:query')
+ AND @wxcp_role_id IS NOT NULL
+ AND NOT EXISTS (
+ SELECT 1 FROM (SELECT `menu_id` FROM `system_role_menu`
+ WHERE `role_id` = @wxcp_role_id
+ AND `deleted` = b'0') `t`
+ WHERE `t`.`menu_id` = `m`.`id`);
--
Gitblit v1.9.3