From b630f868ae5cb4bc2e92c48d275341d36d260499 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 22 九月 2026 12:58:07 +0800
Subject: [PATCH] feat(qc): 新增OQC出货检验功能及优化质量流程

---
 docs/sql/config_export_all_20260904.sql |   67 +++++++++++++++++----------------
 1 files changed, 34 insertions(+), 33 deletions(-)

diff --git a/docs/sql/config_export_all_20260904.sql b/docs/sql/config_export_all_20260904.sql
index 4d9788a..754c734 100644
--- a/docs/sql/config_export_all_20260904.sql
+++ b/docs/sql/config_export_all_20260904.sql
@@ -988,6 +988,7 @@
 ('2046', 'MES 缁翠慨宸ュ崟鐘舵��', 'mes_dv_repair_status', '0', 'MES 璁惧绠＄悊 - 缁翠慨宸ュ崟鐘舵�侊紙10=寰呯淮淇紝20=缁翠慨涓紝30=宸插畬鎴愶紝40=宸查獙鏀讹級', '1', '2026-02-20 10:56:24', '1', '2026-02-20 10:56:24', X'00', NULL),
 ('2047', 'MES 缁翠慨缁撴灉', 'mes_dv_repair_result', '0', 'MES 璁惧绠＄悊 - 缁翠慨缁撴灉锛�1=淇鎴愬姛锛�2=鎶ュ簾锛�', '1', '2026-02-20 10:56:24', '1', '2026-02-20 10:56:24', X'00', NULL),
 ('2049', 'MES 妫�娴嬬粨鏋�', 'mes_qc_check_result', '0', '鏉ユ枡妫�楠岀殑鏈�缁堢粨鏋滃垽瀹�', '1', '2026-02-20 11:23:35', '1', '2026-02-20 11:23:35', X'00', NULL),
+('1065400', 'MES 鍑鸿揣妫�楠屾娴嬬粨鏋�', 'mes_oqc_check_result', '0', '鍑鸿揣妫�楠屽崟(OQC)鍒ゅ畾缁撴灉锛�1鍨�/2鍨嬩负鍙彂璐х瓑绾э紝搴熷搧涓嶆斁琛�', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00', NULL),
 ('2050', 'MES 鏉ユ簮鍗曟嵁绫诲瀷', 'mes_qc_source_doc_type', '0', 'IQC 鏉ユ枡妫�楠岀殑鏉ユ簮鍗曟嵁绫诲瀷', '1', '2026-02-20 11:23:35', '1', '2026-02-20 11:23:35', X'00', NULL),
 ('2051', 'MES 瀹夌伅澶勭疆鐘舵��', 'mes_pro_andon_status', '0', 'MES 鐢熶骇绠＄悊 - 瀹夌伅澶勭疆鐘舵�侊紙0=鏈缃紝1=宸插缃級', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00', NULL),
 ('2052', 'MES 瀹夌伅绾у埆', 'mes_pro_andon_level', '0', 'MES 鐢熶骇绠＄悊 - 瀹夌伅绾у埆锛�1=涓�绾э紝2=浜岀骇锛�3=涓夌骇锛�', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00', NULL),
@@ -1822,6 +1823,9 @@
 ('3158', '2', '鎶ュ簾', '2', 'mes_dv_repair_result', '0', 'danger', '', '', '1', '2026-02-20 10:56:24', '1', '2026-02-20 10:56:24', X'00'),
 ('3161', '1', '鏍￠獙閫氳繃', '1', 'mes_qc_check_result', '0', 'success', '', '', '1', '2026-02-20 11:23:35', '1', '2026-02-20 16:15:54', X'00'),
 ('3162', '2', '鏍￠獙涓嶉�氳繃', '2', 'mes_qc_check_result', '0', 'danger', '', '', '1', '2026-02-20 11:23:35', '1', '2026-02-20 16:15:52', X'00'),
+('1065401', '1', '1鍨�', '1', 'mes_oqc_check_result', '0', 'success', '', '', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00'),
+('1065402', '2', '2鍨�', '2', 'mes_oqc_check_result', '0', 'primary', '', '', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00'),
+('1065403', '3', '搴熷搧', '3', 'mes_oqc_check_result', '0', 'danger', '', '', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00'),
 ('3166', '0', '鏈缃�', '0', 'mes_pro_andon_status', '0', 'danger', '', '', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00'),
 ('3167', '1', '宸插缃�', '1', 'mes_pro_andon_status', '0', 'success', '', '', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00'),
 ('3168', '1', '涓�绾�', '1', 'mes_pro_andon_level', '0', 'danger', '', '', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00'),
@@ -7928,11 +7932,11 @@
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
   `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬮」缂栫爜',
   `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬮」鍚嶇О',
-  `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '莽藛露忙艗鈥∶β犫�∶尖�撁ヂ徛访妓�0=茅隆露莽潞搂茂录鈥�',
-  `item_type` tinyint NOT NULL DEFAULT '1' COMMENT '忙聺隆莽鈥郝甭幻ヅ锯�姑寂�1=氓陆鈥⒚モ�βッ┞÷姑寂�2=氓藛鈥犆烩�灻┞÷�',
-  `formula_text` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '氓鈥βヂ悸徝ヂ扁�⒚ぢ好︹�撯�∶ε撀妓喢︹�扳�溍ヂ嵚懊ε犅ッモ�樑犆р�澛寂捗ぢ嘎嵜ヂ忊�毭ぢ概矫∶�斆尖��',
-  `unit_text` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '氓聧鈥⒚ぢ铰嵜︹�撯�∶ε撀妓喢ヂ︹�� kg/m脗鲁茫鈧�/%茂录艗忙鈥扳�溍ヂ嵚懊ヂ扁�⒚ぢ好р�澛尖��',
-  `sort_order` int NOT NULL DEFAULT '0' COMMENT '氓聬艗莽潞搂忙沤鈥櫭ヂ郝徝ヂ徛�',
+  `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '鐖舵寚鏍囩紪鍙凤紙0=椤剁骇锛�',
+  `item_type` tinyint NOT NULL DEFAULT '1' COMMENT '鏉＄洰绫诲瀷锛�1=褰曞叆椤癸紝2=鍒嗙粍椤�',
+  `formula_text` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍏紡灞曠ず鏂囨湰锛堟墦鍗版姤鍛婄敤锛屼笉鍙備笌璁＄畻锛�',
+  `unit_text` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍗曚綅鏂囨湰锛堝 kg/m鲁銆�/%锛屾墦鍗板睍绀虹敤锛�',
+  `sort_order` int NOT NULL DEFAULT '0' COMMENT '鍚岀骇鎺掑簭鍙�',
   `type` int DEFAULT NULL COMMENT '妫�娴嬮」绫诲瀷',
   `tool` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬪伐鍏�',
   `result_type` int DEFAULT NULL COMMENT '缁撴灉鍊肩被鍨�',
@@ -7971,7 +7975,7 @@
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
   `result_id` bigint DEFAULT NULL COMMENT '鍏宠仈妫�楠岀粨鏋滅紪鍙�',
   `indicator_id` bigint DEFAULT NULL COMMENT '妫�娴嬫寚鏍囩紪鍙�',
-  `measure_no` int NOT NULL DEFAULT '1' COMMENT '忙碌鈥姑┾�÷徝︹�奥姑β∶ヂ徛访妓喢ぢ慌� 1 氓录鈧ヂр�姑寂捗┞凰溍� 1茂录鈥�',
+  `measure_no` int NOT NULL DEFAULT '1' COMMENT '娴嬮噺鎵规鍙凤紙浠� 1 寮�濮嬶紝榛樿 1锛�',
   `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬪��',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
@@ -7995,10 +7999,7 @@
   `source_doc_id` bigint DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁缂栧彿',
   `source_line_id` bigint DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁琛岀紪鍙�',
   `source_doc_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁缂栧彿',
-  `work_order_id` bigint DEFAULT NULL COMMENT '鐢熶骇宸ュ崟缂栧彿',
-  `task_id` bigint DEFAULT NULL COMMENT '鐢熶骇浠诲姟缂栧彿',
-  `workstation_id` bigint DEFAULT NULL COMMENT '宸ヤ綅缂栧彿',
-  `process_id` bigint DEFAULT NULL COMMENT '宸ュ簭缂栧彿',
+  `batch_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵瑰彿',
   `item_id` bigint DEFAULT NULL COMMENT '浜у搧鐗╂枡缂栧彿',
   `check_quantity` decimal(24,6) DEFAULT NULL COMMENT '妫�娴嬫暟閲�',
   `qualified_quantity` decimal(24,6) DEFAULT NULL COMMENT '鍚堟牸鍝佹暟閲�',
@@ -8016,11 +8017,11 @@
   `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�',
   `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�',
   `status` int DEFAULT NULL COMMENT '鐘舵��',
-  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�',
-  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路',
-  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��',
-  `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
-  `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
+  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣',
+  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿',
+  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯',
+  `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�',
+  `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
@@ -8083,11 +8084,11 @@
   `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�',
   `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�',
   `status` int DEFAULT NULL COMMENT '鐘舵��',
-  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�',
-  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路',
-  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��',
-  `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
-  `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
+  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣',
+  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿',
+  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯',
+  `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�',
+  `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
@@ -8193,11 +8194,11 @@
   `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�',
   `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�',
   `status` int DEFAULT NULL COMMENT '鐘舵��',
-  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�',
-  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路',
-  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��',
-  `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
-  `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
+  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣',
+  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿',
+  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯',
+  `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�',
+  `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
@@ -8258,11 +8259,11 @@
   `inspect_date` datetime DEFAULT NULL COMMENT '妫�娴嬫棩鏈�',
   `inspector_user_id` bigint DEFAULT NULL COMMENT '妫�娴嬩汉鍛樼敤鎴风紪鍙�',
   `status` int DEFAULT NULL COMMENT '鐘舵��',
-  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅鈥♀�∶β犅访ヅ撀懊р�毬�',
-  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '猫炉聛盲鹿娄莽录鈥撁ヂ徛�/氓聬藛忙聽录猫炉聛氓聫路',
-  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '忙鈥奥∨捗β犫�∶モ�♀��',
-  `audit_user_id` bigint DEFAULT NULL COMMENT '氓陇聧忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
-  `approve_user_id` bigint DEFAULT NULL COMMENT '氓庐隆忙聽赂盲潞潞莽鈥澛λ喡访尖�撁ヂ徛�',
+  `sampling_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '閲囨牱鍦扮偣',
+  `certificate_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇佷功缂栧彿/鍚堟牸璇佸彿',
+  `execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵ц鏍囧噯',
+  `audit_user_id` bigint DEFAULT NULL COMMENT '澶嶆牳浜虹敤鎴风紪鍙�',
+  `approve_user_id` bigint DEFAULT NULL COMMENT '瀹℃牳浜虹敤鎴风紪鍙�',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
@@ -8303,7 +8304,7 @@
   `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏂规缂栧彿',
   `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏂规鍚嶇О',
   `types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬬绫�',
-  `default_execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '茅禄藴猫庐陇忙鈥奥∨捗β犫�∶モ�♀�犆妓喢ヂ︹�� GB/T6027茂录鈥�',
+  `default_execute_standard` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '榛樿鎵ц鏍囧噯锛堝 GB/T6027锛�',
   `status` int DEFAULT NULL COMMENT '鐘舵��',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
   `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
@@ -8320,8 +8321,8 @@
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
   `template_id` bigint DEFAULT NULL COMMENT '璐ㄦ鏂规缂栧彿',
   `indicator_id` bigint DEFAULT NULL COMMENT '璐ㄦ鎸囨爣缂栧彿',
-  `sort_order` int NOT NULL DEFAULT '0' COMMENT '氓卤鈥⒚ぢ好ε解�櫭ヂ郝徝ヂ徛�',
-  `judge_flag` tinyint NOT NULL DEFAULT '1' COMMENT '忙藴炉氓聬娄氓聫鈥毭ぢ概矫ヂ愃喢β犅济ニ喡っヂ∶寂�1=忙藴炉茂录艗0=氓聬娄',
+  `sort_order` int NOT NULL DEFAULT '0' COMMENT '灞曠ず鎺掑簭鍙�',
+  `judge_flag` tinyint NOT NULL DEFAULT '1' COMMENT '鏄惁鍙備笌鍚堟牸鍒ゅ畾锛�1=鏄紝0=鍚�',
   `check_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '妫�娴嬫柟娉�',
   `standard_value` decimal(24,6) DEFAULT NULL COMMENT '鏍囧噯鍊�',
   `unit_measure_id` bigint DEFAULT NULL COMMENT '璁￠噺鍗曚綅缂栧彿',

--
Gitblit v1.9.3