From caf56217dc2bf898b63b0e1f31a7098202c32825 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期六, 15 十一月 2025 16:50:17 +0800 Subject: [PATCH] Merge branch 'feature_gps' --- sql/vehicle_mileage_stats_menu.sql | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 56 insertions(+), 0 deletions(-) diff --git a/sql/vehicle_mileage_stats_menu.sql b/sql/vehicle_mileage_stats_menu.sql index e69de29..d2dd644 100644 --- a/sql/vehicle_mileage_stats_menu.sql +++ b/sql/vehicle_mileage_stats_menu.sql @@ -0,0 +1,56 @@ +-- 杞﹁締閲岀▼缁熻鑿滃崟鏉冮檺 +-- 鐖惰彍鍗旾D闇�瑕佹牴鎹疄闄呯郴缁熶腑鐨�"绯荤粺绠＄悊"鎴�"杞﹁締绠＄悊"鑿滃崟ID杩涜璋冩暣 + +-- 1. 娣诲姞杞﹁締閲岀▼缁熻鑿滃崟 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ( + (SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), + '杞﹁締閲岀▼缁熻', + 3, -- 绯荤粺宸ュ叿锛岃鏍规嵁瀹為檯鎯呭喌淇敼parent_id + 6, + 'mileageStats', + 'system/mileageStats/index', + 1, + 0, + 'C', + '0', + '0', + 'system:mileageStats:list', + 'chart', + 'admin', + NOW(), + '', + NULL, + '杞﹁締閲岀▼缁熻鑿滃崟' +); + +-- 鑾峰彇鍒氭彃鍏ョ殑鑿滃崟ID锛堢敤浜庡悗缁寜閽潈闄愶級 +SET @menuId = (SELECT MAX(menu_id) FROM sys_menu WHERE menu_name = '杞﹁締閲岀▼缁熻'); + +-- 2. 娣诲姞鏌ヨ鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻鏌ヨ', @menuId, 1, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:query', '#', 'admin', NOW(), '', NULL, ''); + +-- 3. 娣诲姞鏂板鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻鏂板', @menuId, 2, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:add', '#', 'admin', NOW(), '', NULL, ''); + +-- 4. 娣诲姞淇敼鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻淇敼', @menuId, 3, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:edit', '#', 'admin', NOW(), '', NULL, ''); + +-- 5. 娣诲姞鍒犻櫎鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻鍒犻櫎', @menuId, 4, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:remove', '#', 'admin', NOW(), '', NULL, ''); + +-- 6. 娣诲姞瀵煎嚭鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻瀵煎嚭', @menuId, 5, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:export', '#', 'admin', NOW(), '', NULL, ''); + +-- 7. 娣诲姞璁＄畻鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻璁＄畻', @menuId, 6, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:calculate', '#', 'admin', NOW(), '', NULL, ''); + +-- 8. 娣诲姞鎵归噺璁＄畻鎸夐挳 +INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) +VALUES ((SELECT IFNULL(MAX(menu_id), 0) + 1 FROM sys_menu t), '杞﹁締閲岀▼缁熻鎵归噺璁＄畻', @menuId, 7, '#', '', 1, 0, 'F', '0', '0', 'system:mileageStats:batch', '#', 'admin', NOW(), '', NULL, ''); -- Gitblit v1.9.1