From 4ca4444ad33a2a1a51f5c06e78ee9365dfb1eed6 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期四, 08 十月 2026 17:11:11 +0800 Subject: [PATCH] feat(mes): 种子二维码标签国标四要素合规改造 --- sql/mysql/wls_sales_outbound_menu_extract.sql | 25 +++++++++++++++++++++++++ 1 files changed, 25 insertions(+), 0 deletions(-) diff --git a/sql/mysql/wls_sales_outbound_menu_extract.sql b/sql/mysql/wls_sales_outbound_menu_extract.sql new file mode 100644 index 0000000..6df47c8 --- /dev/null +++ b/sql/mysql/wls_sales_outbound_menu_extract.sql @@ -0,0 +1,25 @@ +-- ============================================= +-- 鍑哄簱娴侀�氱鐞嗚彍鍗曟彁鍙栬剼鏈� +-- 灏�"閿�鍞粨搴�"(602479) 鎻愬彇涓轰竴绾ц彍鍗�"鍑哄簱娴侀�氱鐞�" +-- 鍘熺粨鏋勶細浠撳偍鐗╂祦(5780) -> 閿�鍞粨搴�(602479) -> 鍙戣揣閫氱煡/閿�鍞嚭搴�/閿�鍞��璐� +-- ============================================= + +-- 1. 鎻愬彇涓轰竴绾ц彍鍗� +-- 璇存槑锛氶《绾�"钀ラ攢绠＄悊"(2617) 宸插崰鐢� path=sale锛屾晠鏀圭敤 sales-outbound 閬垮厤璺敱鍐茬獊 +UPDATE system_menu SET + parent_id = 0, + name = '鍑哄簱娴侀�氱鐞�', + path = 'sales-outbound', + sort = 10 -- 鏀惧湪浠撳偍鐗╂祦(sort=9)涔嬪悗 +WHERE id = 602479 AND deleted = b'0'; + +-- ============================================= +-- 璇存槑锛� +-- 1. 瀛愯彍鍗�(鍙戣揣閫氱煡 5867 / 閿�鍞嚭搴� 5970 / 閿�鍞��璐� 5847) 鏃犻渶鏀瑰姩锛� +-- 鍓嶇鍔ㄦ�佽矾鐢变細鑷姩鎷兼帴涓� /sales-outbound/sales-notice 绛夎矾寰� +-- 2. 椤剁骇鐩綍鑿滃崟鐢卞墠绔嚜鍔ㄦ覆鏌撲负 BasicLayout锛宑omponent 瀛楁鏃犻渶濉啓 +-- 3. 濡傞渶鎭㈠锛屾墽琛屼互涓嬪弽鍚戣剼鏈細 +-- ============================================= + +-- 鍙嶅悜鑴氭湰锛堝闇�鎭㈠锛夛細 +-- UPDATE system_menu SET parent_id = 5780, name = '閿�鍞粨搴�', path = 'sale', sort = 5 WHERE id = 602479; -- Gitblit v1.9.3