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