From ea15a94b09d6d6b0c62f64aa6cfa03b4636cf557 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期三, 02 九月 2026 18:02:36 +0800 Subject: [PATCH] fix(mes): 菜单脚本改为自包含，自动创建「统计分析」顶级目录 --- sql/mysql/mes_dashboard_module_init.sql | 18 ++++++++++++++++-- 1 files changed, 16 insertions(+), 2 deletions(-) diff --git a/sql/mysql/mes_dashboard_module_init.sql b/sql/mysql/mes_dashboard_module_init.sql index fa50112..d518109 100644 --- a/sql/mysql/mes_dashboard_module_init.sql +++ b/sql/mysql/mes_dashboard_module_init.sql @@ -1,7 +1,7 @@ -- ============================================= -- 绠＄悊椹鹃┒鑸变笌缁熻鍒嗘瀽妯″潡 鍒濆鍖栬剼鏈� --- 鍖呭惈锛氥�岀鐞嗛┚椹惰埍銆嶉〉闈㈠強鎸夐挳鏉冮檺锛堟煡璇�/瀵煎嚭锛� --- 璇存槑锛氶《绾х洰褰曘�岀粺璁″垎鏋愩��(id=602700) 宸插瓨鍦紝鏈剼鏈粎鍦ㄥ叾涓嬫寕杞介〉闈€�� +-- 鍖呭惈锛氶《绾х洰褰曘�岀粺璁″垎鏋愩�嶃�侀〉闈€�岀鐞嗛┚椹惰埍銆嶃�佹寜閽潈闄愶紙鏌ヨ/瀵煎嚭锛� +-- 鏈剼鏈嚜鍖呭惈锛屽彲鍦ㄥ叏鏂版暟鎹簱涓婂畬鏁村垱寤虹洰褰曚笌椤甸潰锛堝潎骞傜瓑锛屽彲閲嶅鎵ц锛� -- 閫傜敤搴擄細mom-thzy锛堢瀛愪笟鍔′富搴擄紝鍚敓浜�/璐ㄦ/搴撳瓨/鍑哄簱/杩芥函鍏ㄩ儴涓氬姟琛級 -- 娉ㄦ剰锛氳嫢鐩爣搴撶己灏戠瀛愪笟鍔¤〃锛岄渶鍏堟墽琛屼互涓嬭剼鏈細 -- mes_pro_batch_bag_code_init.sql 锛堢敓浜ф壒娆�/琚嬬爜/鎵樼洏锛� @@ -15,6 +15,20 @@ SET NAMES utf8mb4; -- ---------------------------- +-- 0. 椤剁骇鐩綍锛氱粺璁″垎鏋愶紙涓嶅瓨鍦ㄥ垯鍒涘缓锛� +-- 鎺掑簭 40锛氫綅浜庛�岃川閲忕鐞�(30)銆嶄箣鍚庛�併�屽喅绛朆I澶у睆(45)銆嶄箣鍓� +-- ---------------------------- +INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, + status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +SELECT 602700, '缁熻鍒嗘瀽', '', 1, 40, 0, '/statistics', 'ep:data-analysis', '', '', + 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' +FROM DUAL +WHERE NOT EXISTS ( + SELECT 1 FROM system_menu + WHERE (id = 602700 OR (parent_id = 0 AND name = '缁熻鍒嗘瀽' AND deleted = 0)) AND deleted = 0 +); + +-- ---------------------------- -- 1. 椤甸潰锛氱鐞嗛┚椹惰埍锛堟寕鍒般�岀粺璁″垎鏋愩�嶇洰褰� 602700 涓嬶級 -- ---------------------------- INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, -- Gitblit v1.9.3