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_pallet_auto_threshold.sql | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 44 insertions(+), 0 deletions(-) diff --git a/sql/mysql/mes_pro_pallet_auto_threshold.sql b/sql/mysql/mes_pro_pallet_auto_threshold.sql new file mode 100644 index 0000000..874007a --- /dev/null +++ b/sql/mysql/mes_pro_pallet_auto_threshold.sql @@ -0,0 +1,44 @@ +-- ============================================= +-- MES 鎵樼洏鐮佽嚜鍔ㄧ敓鎴愶紙鎸夋湁鏁堣鐮佺疮璁￠槇鍊硷級杩佺Щ鑴氭湰 +-- 1. mes_pro_batch 澧炲姞鍖呰琚嬪瀷 bag_type锛堝皬琚� 10 / 澶ц 20锛� +-- 2. mes_pro_pallet 澧炲姞 auto_generated 鑷姩鐢熸垚鏍囪瘑 +-- 3. 澧炲姞鍖呰琚嬪瀷瀛楀吀 +-- MySQL 8.4 閫傜敤锛屼笉鍖呭惈 tenant_id +-- ============================================= + +SET NAMES utf8mb4; + +-- ---------------------------- +-- 1. 鐢熶骇鎵规澧炲姞鍖呰琚嬪瀷 +-- ---------------------------- +SET @batch_bag_type_exists = (SELECT COUNT(*) FROM information_schema.columns + WHERE table_schema = DATABASE() AND table_name = 'mes_pro_batch' AND column_name = 'bag_type'); +SET @batch_bag_type_sql = IF(@batch_bag_type_exists = 0, + 'ALTER TABLE mes_pro_batch ADD COLUMN bag_type TINYINT DEFAULT NULL COMMENT ''鍖呰琚嬪瀷锛堝瓧鍏� mes_pro_bag_type锛�10 灏忚 20 澶ц锛夛紝鐢ㄤ簬鑷姩褰掗泦鎵樼洏'' AFTER item_id', + 'SELECT 1'); +PREPARE batch_bag_type_stmt FROM @batch_bag_type_sql; +EXECUTE batch_bag_type_stmt; +DEALLOCATE PREPARE batch_bag_type_stmt; + +-- ---------------------------- +-- 2. 鎵樼洏鐮佽〃澧炲姞鑷姩鐢熸垚鏍囪瘑 +-- ---------------------------- +SET @pallet_auto_generated_exists = (SELECT COUNT(*) FROM information_schema.columns + WHERE table_schema = DATABASE() AND table_name = 'mes_pro_pallet' AND column_name = 'auto_generated'); +SET @pallet_auto_generated_sql = IF(@pallet_auto_generated_exists = 0, + 'ALTER TABLE mes_pro_pallet ADD COLUMN auto_generated BIT(1) NOT NULL DEFAULT b''0'' COMMENT ''鏄惁鑷姩鐢熸垚锛堟寜鏈夋晥琚嬬爜绱闃堝�肩敓鎴愶紝瀹归噺鍥哄畾涓洪槇鍊硷級'' AFTER bag_count', + 'SELECT 1'); +PREPARE pallet_auto_generated_stmt FROM @pallet_auto_generated_sql; +EXECUTE pallet_auto_generated_stmt; +DEALLOCATE PREPARE pallet_auto_generated_stmt; + +-- ---------------------------- +-- 3. 鍖呰琚嬪瀷瀛楀吀 +-- ---------------------------- +INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) +SELECT 'MES 鍖呰琚嬪瀷', 'mes_pro_bag_type', 0, '鎵樼洏鑷姩褰掗泦闃堝�煎垽瀹�', '1', NOW(), '1', NOW(), b'0' FROM DUAL +WHERE NOT EXISTS (SELECT 1 FROM (SELECT id FROM system_dict_type WHERE `type` = 'mes_pro_bag_type' AND deleted = 0) t); + +INSERT INTO `system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES +(1065364, 1, '灏忚', '10', 'mes_pro_bag_type', 0, 'primary', '', '1', NOW(), '1', NOW(), b'0'), +(1065365, 2, '澶ц', '20', 'mes_pro_bag_type', 0, 'warning', '', '1', NOW(), '1', NOW(), b'0'); \ No newline at end of file -- Gitblit v1.9.3