From f6003438d54d49abccedbdd5d1c311e637798995 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期六, 07 十一月 2026 14:27:12 +0800
Subject: [PATCH] fix(sql): 修正退单受理父菜单匹配,补齐新菜单授权与采购菜单 ERP 停用
---
sql/mysql/srm_cost_analysis_menu_20261107.sql | 17 ++++++++
sql/mysql/new_menu_role_grant_20261107.sql | 24 ++++++++++++
sql/mysql/after_sale_cancellation_20261107.sql | 9 +++-
sql/mysql/purchase_menu_erp_off_20261107.sql | 23 +++++++++++
4 files changed, 71 insertions(+), 2 deletions(-)
diff --git a/sql/mysql/after_sale_cancellation_20261107.sql b/sql/mysql/after_sale_cancellation_20261107.sql
index 336e256..93008de 100644
--- a/sql/mysql/after_sale_cancellation_20261107.sql
+++ b/sql/mysql/after_sale_cancellation_20261107.sql
@@ -32,7 +32,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鍞悗缁熶竴閫�鍗�/鍙樻洿鍙楃悊';
-- 鑿滃崟锛氭寕鍦ㄥ敭鍚庢湇鍔′笅
-SET @as_parent := (SELECT id FROM system_menu WHERE name='鍞悗鏈嶅姟' AND parent_id=0 AND CAST(deleted AS UNSIGNED)=0 LIMIT 1);
+-- 鐖惰彍鍗曟寜 path 鍖归厤鏇寸ǔ濡ワ紙涓嶅悓椤圭洰鍚嶇О鍙兘鍙�屽敭鍚庣鐞嗐�嶆垨銆屽敭鍚庢湇鍔°�嶏級
+SET @as_parent := (SELECT id FROM system_menu
+ WHERE CAST(deleted AS UNSIGNED)=0 AND type=1 AND path='/aftersales' LIMIT 1);
+SET @as_parent := IFNULL(@as_parent,
+ (SELECT id FROM system_menu WHERE CAST(deleted AS UNSIGNED)=0 AND type=1
+ AND (name='鍞悗绠$悊' OR name='鍞悗鏈嶅姟') LIMIT 1));
INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater)
SELECT '閫�鍗曠鐞�','',2,90,@as_parent,'cancellation','lucide:undo-2','aftersales/cancellation/index','AfterSaleCancellation',0,b'1',b'1',b'1','1','1'
WHERE @as_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='aftersales/cancellation/index' AND CAST(deleted AS UNSIGNED)=0);
@@ -46,4 +51,4 @@
UNION ALL SELECT '瀹℃壒','aftersales:cancellation:approve',4
UNION ALL SELECT '鍙栨秷','aftersales:cancellation:cancel',5
UNION ALL SELECT '鍒犻櫎','aftersales:cancellation:delete',6) p
-WHERE @pg IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id=@pg AND m.permission=p.permission AND CAST(m.deleted AS UNSIGNED)=0);
+WHERE @pg IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id=@pg AND m.permission=p.permission AND CAST(m.deleted AS UNSIGNED)=0);
\ No newline at end of file
diff --git a/sql/mysql/new_menu_role_grant_20261107.sql b/sql/mysql/new_menu_role_grant_20261107.sql
new file mode 100644
index 0000000..c90cf65
--- /dev/null
+++ b/sql/mysql/new_menu_role_grant_20261107.sql
@@ -0,0 +1,24 @@
+-- 涓烘柊鑿滃崟琛ラ綈瑙掕壊鎺堟潈锛氬嚒鏄凡鎷ユ湁鐖惰彍鍗曠殑瑙掕壊锛屼竴骞舵巿浜堟柊鑿滃崟鍙婂叾鎸夐挳銆�
+-- 璇存槑锛氭柊澧炶彍鍗曞悗鑻ヤ笉鎺堟潈锛屾櫘閫氳鑹蹭笌绠$悊鍛橀兘鐪嬩笉鍒板叆鍙c��
+
+-- 1) 閲囪喘鎴愭湰鍒嗘瀽鑿滃崟
+INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted)
+SELECT rm.role_id, m.id, '1', NOW(), '1', NOW(), b'0'
+FROM (SELECT DISTINCT role_id FROM system_role_menu
+ WHERE menu_id = 602524 AND CAST(deleted AS UNSIGNED)=0) rm
+CROSS JOIN (SELECT id FROM system_menu
+ WHERE component='srm/statistics/cost-analysis' AND CAST(deleted AS UNSIGNED)=0) m
+WHERE NOT EXISTS (SELECT 1 FROM system_role_menu x
+ WHERE x.role_id=rm.role_id AND x.menu_id=m.id AND CAST(x.deleted AS UNSIGNED)=0);
+
+-- 2) 閫�鍗曠鐞嗚彍鍗曞強鍏舵寜閽�
+INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted)
+SELECT rm.role_id, m.id, '1', NOW(), '1', NOW(), b'0'
+FROM (SELECT DISTINCT role_id FROM system_role_menu
+ WHERE menu_id = 602587 AND CAST(deleted AS UNSIGNED)=0) rm
+CROSS JOIN (SELECT id FROM system_menu
+ WHERE CAST(deleted AS UNSIGNED)=0
+ AND (component='aftersales/cancellation/index'
+ OR permission LIKE 'aftersales:cancellation:%')) m
+WHERE NOT EXISTS (SELECT 1 FROM system_role_menu x
+ WHERE x.role_id=rm.role_id AND x.menu_id=m.id AND CAST(x.deleted AS UNSIGNED)=0);
diff --git a/sql/mysql/purchase_menu_erp_off_20261107.sql b/sql/mysql/purchase_menu_erp_off_20261107.sql
new file mode 100644
index 0000000..25c90e6
--- /dev/null
+++ b/sql/mysql/purchase_menu_erp_off_20261107.sql
@@ -0,0 +1,23 @@
+-- 閲囪喘绠$悊鑿滃崟鍒嗘敮璋冩暣锛欵RP 宸蹭粠鏋勫缓涓帓闄わ紝浣嗙埗鑿滃崟琚仠鐢ㄥ鑷� SRM 渚涘簲鍟嗙鐞嗘暣鏀笉鍙
+-- 锛堝惈鎷涙姇鏍� / 缁熻鍒嗘瀽 / 閲囪喘鎴愭湰鍒嗘瀽锛夈��
+-- 澶勭悊锛氬惎鐢ㄣ�岄噰璐鐞嗐�嶇埗鑿滃崟锛屽悓鏃跺仠鐢� ERP 涓撳睘瀛愰〉闈紝閬垮厤鐢ㄦ埛鐐瑰埌 404銆�
+
+-- 1) 鍚敤閲囪喘绠$悊鐖惰彍鍗�
+UPDATE system_menu SET status = 0
+WHERE CAST(deleted AS UNSIGNED)=0 AND id = 2602;
+
+-- 2) 鍋滅敤 ERP 涓撳睘瀛愯彍鍗曪紙component 浠� erp/ 寮�澶达級
+UPDATE system_menu SET status = 1
+WHERE CAST(deleted AS UNSIGNED)=0
+ AND parent_id = 2602
+ AND component LIKE 'erp/%';
+
+-- 3) 纭 SRM 鍒嗘敮涓哄惎鐢ㄧ姸鎬�
+UPDATE system_menu SET status = 0
+WHERE CAST(deleted AS UNSIGNED)=0
+ AND id = 602524;
+
+UPDATE system_menu SET status = 0
+WHERE CAST(deleted AS UNSIGNED)=0
+ AND parent_id = 602524
+ AND (component LIKE 'srm/%' OR component IS NULL);
diff --git a/sql/mysql/srm_cost_analysis_menu_20261107.sql b/sql/mysql/srm_cost_analysis_menu_20261107.sql
new file mode 100644
index 0000000..7365f61
--- /dev/null
+++ b/sql/mysql/srm_cost_analysis_menu_20261107.sql
@@ -0,0 +1,17 @@
+-- 閲囪喘鎴愭湰鍒嗘瀽鑿滃崟锛堝熀浜� SRM 鎷涙爣闇�姹備笌渚涘簲鍟嗘姤浠凤紝涓嶄緷璧� ERP锛�
+SET @srm_parent := (SELECT id FROM system_menu WHERE CAST(deleted AS UNSIGNED)=0 AND type=1
+ AND (name='渚涘簲鍟嗙鐞�' OR path LIKE '%srm%' OR path LIKE '%supplier%') LIMIT 1);
+-- 鑻ユ壘涓嶅埌 SRM 鐖惰彍鍗曪紝閫�鍖栦负鎸傚湪浠撳偍鐗╂祦涓�
+SET @srm_parent := IFNULL(@srm_parent,
+ (SELECT id FROM system_menu WHERE CAST(deleted AS UNSIGNED)=0 AND type=1 AND name='浠撳偍鐗╂祦' LIMIT 1));
+
+INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater)
+SELECT '閲囪喘鎴愭湰鍒嗘瀽','',2,95,@srm_parent,'cost-analysis','lucide:line-chart','srm/statistics/cost-analysis','SrmCostAnalysis',0,b'1',b'1',b'1','1','1'
+WHERE @srm_parent IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='srm/statistics/cost-analysis' AND CAST(deleted AS UNSIGNED)=0);
+
+SET @pg := (SELECT id FROM system_menu WHERE component='srm/statistics/cost-analysis' AND CAST(deleted AS UNSIGNED)=0 LIMIT 1);
+INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,status,visible,keep_alive,always_show,creator,updater)
+SELECT p.name,p.permission,3,p.sort_no,@pg,'','',0,b'1',b'1',b'1','1','1'
+FROM (SELECT '鏌ヨ' name,'srm:statistics:query' permission,1 sort_no) p
+WHERE @pg IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id=@pg AND m.permission=p.permission AND CAST(m.deleted AS UNSIGNED)=0);
--
Gitblit v1.9.3