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_seed_quality_init.sql | 25 +++++++++++++++++++++++++ 1 files changed, 25 insertions(+), 0 deletions(-) diff --git a/sql/mysql/mes_seed_quality_init.sql b/sql/mysql/mes_seed_quality_init.sql new file mode 100644 index 0000000..e6f5615 --- /dev/null +++ b/sql/mysql/mes_seed_quality_init.sql @@ -0,0 +1,25 @@ +-- 绉嶅瓙璐ㄦ鍒濆鍖栬剼鏈紙鏃犵鎴峰瓧娈碉紝鍙噸澶嶆墽琛岋級 +CREATE TABLE IF NOT EXISTS mes_qc_seed_quality ( + id bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', code varchar(64) NOT NULL COMMENT '琚嬬爜', item_id bigint NOT NULL COMMENT '鐗╂枡', batch_code varchar(64) DEFAULT NULL COMMENT '鎵规鍙�', result tinyint NOT NULL DEFAULT 0 COMMENT '0澶勭悊涓�1鍚堟牸2涓嶅悎鏍�', reason varchar(500) DEFAULT NULL COMMENT '鍘熷洜', inspector_id bigint DEFAULT NULL COMMENT '璐ㄦ鍛�', inspected_at datetime DEFAULT NULL COMMENT '璐ㄦ鏃堕棿', creator varchar(64) DEFAULT NULL, create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updater varchar(64) DEFAULT NULL, update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted bit NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY uk_code (code) +) ENGINE=InnoDB COMMENT='绉嶅瓙璐ㄦ涓昏〃'; +CREATE TABLE IF NOT EXISTS mes_qc_seed_quality_indicator ( + id bigint NOT NULL AUTO_INCREMENT, quality_id bigint NOT NULL, indicator_code varchar(32) NOT NULL, value decimal(18,6) NOT NULL, min_value decimal(18,6) NOT NULL, max_value decimal(18,6) NOT NULL, creator varchar(64) DEFAULT NULL, create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updater varchar(64) DEFAULT NULL, update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted bit NOT NULL DEFAULT 0, PRIMARY KEY(id), UNIQUE KEY uk_quality_indicator(quality_id,indicator_code) +) ENGINE=InnoDB COMMENT='绉嶅瓙璐ㄦ鎸囨爣缁撴灉'; +CREATE TABLE IF NOT EXISTS mes_qc_seed_quality_source ( + id bigint NOT NULL AUTO_INCREMENT, quality_id bigint NOT NULL, bag_code_id bigint DEFAULT NULL, bag_code varchar(64) NOT NULL, material_stock_id bigint DEFAULT NULL, quantity decimal(18,6) NOT NULL DEFAULT 0, source_warehouse_id bigint DEFAULT NULL, source_location_id bigint DEFAULT NULL, source_area_id bigint DEFAULT NULL, target_warehouse_id bigint DEFAULT NULL, target_location_id bigint DEFAULT NULL, target_area_id bigint DEFAULT NULL, creator varchar(64) DEFAULT NULL, create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updater varchar(64) DEFAULT NULL, update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted bit NOT NULL DEFAULT 0, PRIMARY KEY(id), UNIQUE KEY uk_quality_bag(quality_id,bag_code) +) ENGINE=InnoDB COMMENT='绉嶅瓙璐ㄦ搴撳瓨琚嬬爜鏉ユ簮鏄庣粏'; +INSERT INTO system_menu (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 '绉嶅瓙璐ㄦ', '', 2, 90, 5500, 'seed-quality', 'ep:checked', 'mes/qc/seedQuality/index', 'MesQcSeedQuality', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' +FROM DUAL +WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id = 5500 AND path = 'seed-quality' AND deleted = 0); + +INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +SELECT '鎻愪氦璐ㄦ', 'mes:qc-seed-quality:submit', 3, 1, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' +FROM system_menu +WHERE parent_id = 5500 AND path = 'seed-quality' AND deleted = 0 + AND NOT EXISTS ( + SELECT 1 FROM system_menu child + WHERE child.parent_id = system_menu.id + AND child.permission = 'mes:qc-seed-quality:submit' + AND child.deleted = 0 + ); -- Gitblit v1.9.3