From beaba1bf3a30053408a860479f9150b02169a7c8 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期一, 24 八月 2026 17:04:16 +0800 Subject: [PATCH] feat(mes): 添加种子质检功能模块 --- sql/mysql/mes_pro_scan_inbound_init.sql | 32 ++++++++++++++++++++++++++++++++ 1 files changed, 32 insertions(+), 0 deletions(-) diff --git a/sql/mysql/mes_pro_scan_inbound_init.sql b/sql/mysql/mes_pro_scan_inbound_init.sql new file mode 100644 index 0000000..7282738 --- /dev/null +++ b/sql/mysql/mes_pro_scan_inbound_init.sql @@ -0,0 +1,32 @@ +-- 鐢熶骇绾挎壂鐮佸叆搴撹彍鍗曚笌鎸夐挳鏉冮檺 +-- 鑿滃崟鎸傝浇鍒颁竴琚嬩竴鐮佺鐞嗭紙602630锛夛紝缁勪欢璺緞涓庡墠绔姩鎬佽矾鐢变竴鑷淬�� +UPDATE system_menu +SET parent_id = 602630, sort = 7, updater = '1', update_time = NOW() +WHERE id = 602650 AND deleted = 0; +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 602650, '鐢熶骇绾挎壂鐮佸叆搴�', '', 2, 7, 602630, 'scan-in', 'ep:camera', 'mes/pro/scan-in/index', 'MesProScanIn', + 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 = 602650 AND deleted = 0); + +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 602651, '鎵爜鍏ュ簱鏌ヨ', 'mes:pro-scan-in:query', 3, 1, 602650, '', '', '', '', + 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 = 602651 AND deleted = 0); + +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 602652, '鎵爜鍏ュ簱', 'mes:pro-scan-in:inbound', 3, 2, 602650, '', '', '', '', + 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 = 602652 AND deleted = 0); + +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 602653, '鎵爜鍏ュ簱鐪嬫澘', 'mes:pro-scan-in:dashboard', 3, 3, 602650, '', '', '', '', + 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 = 602653 AND deleted = 0); -- Gitblit v1.9.3