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/config_export_all_20260929.sql | 93 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 93 insertions(+), 0 deletions(-)
diff --git a/docs/sql/config_export_all_20260929.sql b/docs/sql/config_export_all_20260929.sql
index 7f1cc1e..3c81419 100644
--- a/docs/sql/config_export_all_20260929.sql
+++ b/docs/sql/config_export_all_20260929.sql
@@ -11634,4 +11634,97 @@
-- WHERE `r`.`id` IN (1, 160, 2) -- 杩藉姞缁欍�屾櫘閫氳鑹层��
-- ============================================================
+-- ============================================================
+-- 浼佷笟寰俊鎵爜鑷姩娉ㄥ唽璐﹀彿鐨勯粯璁よ鑹诧細wxcp_user
+-- 锛堜笌 docs/sql/wxcp_menu.sql 鏈熬鍚屼竴娈碉紝淇濇寔鍚屾锛�
+--
+-- 蹇呴』鏀惧湪鏈枃浠堕樁娈典簩鐨� `DELETE FROM system_role` 涔嬪悗鎵ц锛�
+-- 鍚﹀垯瑙掕壊浼氳闃舵浜屼粠婧愬簱閲嶆嫹鏃舵竻鎺� 鈥斺�� 杩欎篃鏄畠钀藉湪闃舵涓夋湯灏剧殑鍘熷洜銆�
+--
+-- 鑳屾櫙锛氫紒涓氬井淇￠娆℃壂鐮佽蛋銆岃嚜鍔ㄦ敞鍐屻�嶅缓鍙凤紝寤哄畬鎸夈�岃鑹茬紪鐮併�嶆煡鏈寤哄嚭鏉ョ殑
+-- 杩欎釜瑙掕壊骞剁粦瀹氥�備唬鐮佸父閲忚 AdminAuthServiceImpl.WXCP_DEFAULT_ROLE_CODE銆�
+-- 瑙掕壊涓嶅瓨鍦ㄦ椂浠ｇ爜鍙墦 warn 鏃ュ織銆佷笉闃绘柇鐧诲綍 鈥斺�� 璐﹀彿鑳借繘浣嗕竴涓彍鍗曢兘娌℃湁锛�
+-- 灞炰簬銆岃兘鐧诲綍鍗翠粈涔堥兘鐪嬩笉鍒般�嶇殑闈欓粯鏁呴殰銆�
+--
+-- 鎺堜簣鑼冨洿锛氫粎銆屼細鍛樼鐞嗐�嶆暣妫靛瓙鏍戯紙鏍硅彍鍗曠紪鍙� 1075490锛屽畾涔夎 ums_module.sql锛夈��
+-- 鍏� 14 鏉� = 鏍圭洰褰� 1 + 鑿滃崟 3 + 鎸夐挳 10锛屼笁绾у叏缁欍��
+-- 棣栭〉涓嶅湪杩欓噷锛屼篃涓嶉渶瑕佸湪杩欓噷锛氬畠鏄墠绔潤鎬佽矾鐢憋紙src/router/routes/modules/
+-- dashboard.ts 閲岀殑 /analytics锛夛紝backend 妯″紡涓嬬敱 generateRoutesByBackend 鏈熬鐨�
+-- return [...options.routes, ...routes] 濮嬬粓鍚堝苟杩涙潵锛屼换浣曠櫥褰曠敤鎴烽兘鍙銆�
+-- 鎵�浠ャ�岃鑹茬鐞嗐�嶇殑鑿滃崟鏍戦噷鎵句笉鍒般�岄椤点�嶆槸姝ｅ父鐨勶紝涓嶆槸婕忛厤銆�
+--
+-- 骞傜瓑锛氳鑹插厛鏌ュ悗鎻掞紱瑙掕壊鑿滃崟鍏宠仈鍏堝垹鍚庢彃锛屽彲閲嶅鎵ц銆�
+-- ============================================================
+
+-- 1) 寤鸿鑹�
+INSERT INTO `system_role`
+ (`name`, `code`, `sort`, `data_scope`, `data_scope_dept_ids`, `status`, `type`, `remark`, `creator`, `updater`)
+SELECT '浼佷笟寰俊鎵爜鐢ㄦ埛', 'wxcp_user', 100, 1, '', 0, 2,
+ '浼佷笟寰俊棣栨鎵爜鑷姩娉ㄥ唽鐨勮处鍙烽粯璁よ鑹诧紝浠呮巿浜堛�屼細鍛樼鐞嗐�嶆ā鍧�',
+ 'admin', 'admin'
+FROM DUAL
+WHERE NOT EXISTS (
+ SELECT 1 FROM (SELECT `id` FROM `system_role`
+ WHERE `code` = 'wxcp_user' AND `deleted` = b'0') `t`);
+
+-- 2) 鍙栬鑹茬紪鍙凤紙鏂板缓鐨勪笌宸插瓨鍦ㄧ殑閮藉彇寰楀埌锛涘彇涓嶅埌鏃朵负 NULL锛屼笅闈袱鍙ヨ嚜鐒朵笉鐢熸晥锛�
+SET @wxcp_role_id = (SELECT `id` FROM `system_role`
+ WHERE `code` = 'wxcp_user' AND `deleted` = b'0' LIMIT 1);
+
+-- 3) 鎺堟潈锛氫細鍛樼鐞嗘牴鑿滃崟(1075490) + 瀛愯彍鍗� + 瀛欒彍鍗曪紝涓夌骇瑕嗙洊鏁存５瀛愭爲
+DELETE FROM `system_role_menu` WHERE `role_id` = @wxcp_role_id;
+
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `updater`)
+SELECT @wxcp_role_id, `m`.`id`, 'admin', 'admin'
+FROM `system_menu` `m`
+LEFT JOIN `system_menu` `p1` ON `p1`.`id` = `m`.`parent_id`
+LEFT JOIN `system_menu` `p2` ON `p2`.`id` = `p1`.`parent_id`
+WHERE `m`.`deleted` = b'0'
+ AND (`m`.`id` = 1075490 OR `p1`.`id` = 1075490 OR `p2`.`id` = 1075490)
+ AND @wxcp_role_id IS NOT NULL;
+
+-- 4) 鍥炲～锛氱粰鏈鎵ц鍓嶅氨宸插瓨鍦ㄧ殑鑷姩娉ㄥ唽璐﹀彿琛ヤ笂榛樿瑙掕壊
+--
+-- 涓轰粈涔堝繀椤绘湁杩欎竴姝ワ細璐﹀彿涓�鏃﹀啓杩� system_social_user_bind锛屽啀娆℃壂鐮佽蛋鐨勬槸
+-- 銆屽凡缁戝畾銆嶅垎鏀紝涓嶄細鍐嶈繘鑷姩娉ㄥ唽閫昏緫 鈥斺�� 涓嶈ˉ鐨勮瘽杩欐壒鑰佽处鍙锋案杩滄病鏈夎彍鍗曘��
+--
+-- 鍙鑷姩娉ㄥ唽鐨勭敤鎴峰悕鍓嶇紑锛坵x_ + 8 浣嶅崄鍏繘鍒讹紝涓� AdminAuthServiceImpl 鐢熸垚瑙勫垯涓�鑷达級锛�
+-- 鐢� ESCAPE 鏄惧紡澹版槑杞箟绗︼紝閬垮厤 `_` 琚� LIKE 褰撴垚鍗曞瓧绗﹂�氶厤銆�
+-- system_user_role 娌℃湁 (user_id, role_id) 鍞竴绾︽潫锛屾墍浠ョ敤 NOT EXISTS 鍏滃箓绛夈��
+INSERT INTO `system_user_role` (`user_id`, `role_id`, `creator`, `updater`)
+SELECT `u`.`id`, @wxcp_role_id, 'admin', 'admin'
+FROM `system_users` `u`
+WHERE `u`.`deleted` = b'0'
+ AND `u`.`username` LIKE 'wx!_%' ESCAPE '!'
+ AND @wxcp_role_id IS NOT NULL
+ AND NOT EXISTS (
+ SELECT 1 FROM (SELECT `user_id` FROM `system_user_role`
+ 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`);
+
SET FOREIGN_KEY_CHECKS = 1;
--
Gitblit v1.9.3