From 22cb0ddec260bb5c5868543e8fe27d67625e8951 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 27 十月 2026 11:34:14 +0800
Subject: [PATCH] feat(menu): 更新安全数据驾驶舱菜单挂载位置并完善库存记录字段

---
 doc/20261026_add_safety_dashboard_menu.sql |   17 +++++++----------
 1 files changed, 7 insertions(+), 10 deletions(-)

diff --git a/doc/20261026_add_safety_dashboard_menu.sql b/doc/20261026_add_safety_dashboard_menu.sql
index bade1ad..77ae12f 100644
--- a/doc/20261026_add_safety_dashboard_menu.sql
+++ b/doc/20261026_add_safety_dashboard_menu.sql
@@ -1,6 +1,6 @@
 -- ============================================================
 -- 瀹夊叏鏁版嵁椹鹃┒鑸� 鑿滃崟
--- 鎸傝浇浣嶇疆锛氭櫤鎱ч┚椹惰埍锛堢埗鑿滃崟锛変笅
+-- 鎸傝浇浣嶇疆锛氱鐞嗛┚椹惰埍锛坮eportAnalysis锛変笅锛屼笌銆屾櫤鎱ч┚椹惰埍銆嶅悓绾�
 -- 椤甸潰缁勪欢锛歳eportAnalysis/safetyDashboard/index
 -- 鍙噸澶嶆墽琛岋細鐖惰彍鍗曚笉瀛樺湪涓嶆彃鍏ワ紱鍚� path/name 宸插瓨鍦ㄤ笉閲嶅鎻掑叆
 -- 娉ㄦ剰锛氭墍鏈夎鍙ラ渶鍦ㄥ悓涓�涓暟鎹簱杩炴帴涓緷娆℃墽琛岋紝鐢ㄦ埛鍙橀噺鎵嶄細淇濈暀
@@ -8,11 +8,11 @@
 
 -- 鎵ц鍓嶅彲鍏堢‘璁ょ埗鑿滃崟涓庢槸鍚﹀凡瀛樺湪锛�
 -- SELECT menu_id, menu_name, parent_id, path, component, menu_type, visible, status
--- FROM sys_menu WHERE menu_name = '鏅烘収椹鹃┒鑸�';
+-- FROM sys_menu WHERE menu_name = '绠$悊椹鹃┒鑸�';
 
-SET @parent_name := '鏅烘収椹鹃┒鑸�';
+SET @parent_name := '绠$悊椹鹃┒鑸�';
 -- 濡傛灉鎸夊悕绉版壘涓嶅埌鐖惰彍鍗曪紝鍙妸鐖惰彍鍗曠殑璺敱鍦板潃濉湪杩欓噷浣滀负鍏滃簳锛堢暀 NULL 琛ㄧず涓嶅惎鐢級
-SET @parent_path := NULL;
+SET @parent_path := 'reportAnalysis';
 
 SET @menu_name  := '瀹夊叏鏁版嵁椹鹃┒鑸�';
 SET @menu_path  := 'safetyDashboard';
@@ -36,11 +36,8 @@
     LIMIT 1
 );
 
--- 3. 鎺掑簭鍙锋帓鍒扮埗鑿滃崟鏈�鍚�
-SET @order_num := COALESCE(
-    (SELECT MAX(order_num) FROM sys_menu WHERE parent_id = @parent_id),
-    0
-) + 1;
+-- 3. 鎺掑簭鍙风疆椤讹紙涓庡凡钀藉簱鏁版嵁涓�鑷达級
+SET @order_num := 1;
 
 -- 4. 鎻掑叆鑿滃崟锛堢埗鑿滃崟瀛樺湪涓旇彍鍗曚笉瀛樺湪鏃讹級
 INSERT INTO sys_menu (
@@ -86,7 +83,7 @@
 -- ============================================================
 -- 鍥炴粴锛堟寜闇�鎵ц锛�
 -- ============================================================
--- SET @parent_id := (SELECT menu_id FROM sys_menu WHERE menu_name = '鏅烘収椹鹃┒鑸�' ORDER BY menu_id LIMIT 1);
+-- SET @parent_id := (SELECT menu_id FROM sys_menu WHERE menu_name = '绠$悊椹鹃┒鑸�' ORDER BY menu_id LIMIT 1);
 -- SET @menu_id := (SELECT menu_id FROM sys_menu
 --                  WHERE parent_id = @parent_id AND path = 'safetyDashboard' LIMIT 1);
 -- DELETE FROM sys_role_menu WHERE menu_id = @menu_id;

--
Gitblit v1.9.3