From 5072520172e8f45e3ccb8afc26cf0c8186ba4cdd Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期一, 19 十月 2026 16:31:42 +0800 Subject: [PATCH] refactor(mes): 重构质量管理和批次绑定功能 --- sql/mysql/mes_seed_quality_workflow_20261019.sql | 47 ++++------------------------------------------- 1 files changed, 4 insertions(+), 43 deletions(-) diff --git a/sql/mysql/mes_seed_quality_workflow_20261019.sql b/sql/mysql/mes_seed_quality_workflow_20261019.sql index d639fcb..8fe07d0 100644 --- a/sql/mysql/mes_seed_quality_workflow_20261019.sql +++ b/sql/mysql/mes_seed_quality_workflow_20261019.sql @@ -1,7 +1,7 @@ --- 鐢熶骇璐ㄦ锛氬垵妫�銆佸妫�銆佸姞宸ラ儴瀹℃壒銆佸叕鍙歌川妫�瀹℃壒鍚庢墠鏀捐搴撳瓨銆� +-- 鐢熶骇璐ㄦ锛氬垵妫�瀹℃牳銆佸妫�銆佸妫�瀹℃牳鍚庢墠鏀捐鎴栧缃簱瀛樸�� -- 鍏堥儴缃叉暟鎹簱鍙樻洿锛屽啀閮ㄧ讲瀵瑰簲鍚庣涓庡墠绔紱鍘嗗彶鍚堟牸璁板綍宸插畬鎴愬簱瀛樻祦杞�� ALTER TABLE mes_qc_seed_quality - ADD COLUMN workflow_status tinyint NOT NULL DEFAULT 40 COMMENT '10寰呭妫� 20寰呭姞宸ラ儴瀹℃壒 30寰呭叕鍙歌川妫�瀹℃壒 40宸叉斁琛� 50寰呭姞宸ラ儴涓嶅悎鏍艰瘎瀹� 60寰呭叕鍙镐笉鍚堟牸瀹℃壒 70宸叉姤搴�', + ADD COLUMN workflow_status tinyint NOT NULL DEFAULT 40 COMMENT '10寰呭妫� 20寰呭垵妫�瀹℃牳 25寰呭垵妫�涓嶅悎鏍煎鐞� 30寰呭妫�瀹℃牳 40宸叉斁琛� 50鍒濇椹冲洖寰呴噸妫� 60寰呭妫�涓嶅悎鏍煎鐞� 70宸叉姤搴�', ADD COLUMN qualified_warehouse_id bigint DEFAULT NULL COMMENT '瀹℃壒閫氳繃鍚庣殑鐩爣鍚堟牸搴�', ADD COLUMN retest_result tinyint DEFAULT NULL COMMENT '澶嶆缁撴灉 1鍚堟牸 2涓嶅悎鏍�', ADD COLUMN retested_at datetime DEFAULT NULL COMMENT '澶嶆鏃堕棿', @@ -30,49 +30,10 @@ FROM system_menu WHERE parent_id = 5500 AND path = 'seed-quality' AND deleted = b'0' AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-seed-quality:retest' AND m.deleted = b'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:process-approve', 3, 4, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' +SELECT '鍒濇瀹℃牳', 'mes:qc-seed-quality:process-approve', 3, 4, 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 = b'0' AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-seed-quality:process-approve' AND m.deleted = b'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:company-approve', 3, 5, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' +SELECT '澶嶆瀹℃牳', 'mes:qc-seed-quality:company-approve', 3, 5, 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 = b'0' AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-seed-quality:company-approve' AND m.deleted = b'0'); - --- 鐙珛閿�鍞川妫�鍏ュ彛锛涗繚鐣欏師鈥滃嚭璐ф楠屸�濊彍鍗曪紝澶嶇敤鍏跺凡瀹炵幇鐨勯攢鍞嚭搴撳崟妫�楠岃兘鍔涖�� -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, 8, 5500, 'sales-quality', 'ep:document-checked', 'mes/qc/salesQuality/index', 'MesQcSalesQuality', 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 = 'sales-quality' AND deleted = b'0'); - --- 閿�鍞川妫�澶嶆鍙婁袱绾у鎵癸紱鍘嗗彶宸插畬鎴愬嚭璐ф楠屽崟缁存寔鏃㈡湁鏀捐缁撴灉銆� -ALTER TABLE mes_qc_oqc - ADD COLUMN workflow_status tinyint NOT NULL DEFAULT 0 COMMENT '0鑽夌 10寰呭妫� 20寰呴攢鍞儴瀹℃壒 30寰呭叕鍙歌川妫�瀹℃壒 40宸叉斁琛� 50寰呴攢鍞儴涓嶅悎鏍艰瘎瀹� 60寰呭叕鍙镐笉鍚堟牸瀹℃壒 70宸叉嫆缁濆嚭璐�'; -CREATE INDEX idx_mes_oqc_workflow ON mes_qc_oqc (workflow_status, id); -UPDATE mes_qc_oqc SET workflow_status = CASE - WHEN status = 0 THEN 0 - WHEN check_result = 1 THEN 40 - ELSE 70 END; -CREATE TABLE IF NOT EXISTS mes_qc_oqc_action ( - id bigint NOT NULL AUTO_INCREMENT, - oqc_id bigint NOT NULL, - action varchar(32) NOT NULL, - result tinyint DEFAULT NULL, - opinion varchar(500) DEFAULT NULL, - quantities_json text DEFAULT NULL, - operator_id bigint DEFAULT NULL, - create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (id), - KEY idx_oqc_time (oqc_id, create_time) -) ENGINE=InnoDB COMMENT='閿�鍞川妫�澶嶆鍜屽鎵圭暀鐥�'; - -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-oqc:retest', 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 = 'sales-quality' AND deleted = b'0' - AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-oqc:retest' AND m.deleted = b'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-oqc:sales-approve', 3, 2, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' -FROM system_menu WHERE parent_id = 5500 AND path = 'sales-quality' AND deleted = b'0' - AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-oqc:sales-approve' AND m.deleted = b'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-oqc:company-approve', 3, 3, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' -FROM system_menu WHERE parent_id = 5500 AND path = 'sales-quality' AND deleted = b'0' - AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-oqc:company-approve' AND m.deleted = b'0'); -- Gitblit v1.9.3