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/after_sale_cancellation_20261107.sql |    9 +++++++--
 1 files changed, 7 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

--
Gitblit v1.9.3