From 125ce27a5f4f85800c0564b515be153b88adeaca Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期三, 30 九月 2026 15:57:32 +0800
Subject: [PATCH] feat(wxcp): 默认角色补首页数据权限，修一进首页就报没有权限
---
docs/sql/wxcp_menu.sql | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/docs/sql/wxcp_menu.sql b/docs/sql/wxcp_menu.sql
index 13c4a52..451d084 100644
--- a/docs/sql/wxcp_menu.sql
+++ b/docs/sql/wxcp_menu.sql
@@ -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