1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
| -- =====================================================================
| -- MES 质检报告演示数据：IQC/IPQC/OQC/RQC 各 3 条已完成单据
| -- 含分组检验项(水分/酸含量/正丁醇含量平铺) + 平行测量(顿号合并) + 空值占位("/")
| -- 签字：检验=张三(231) 复核=张静波(232) 批准=超级管理员(1)
| -- 仅本地演示库执行；重复执行安全（先按固定编码清理）
| -- =====================================================================
|
| -- ---------- 清理上次演示数据 ----------
| DELETE FROM mes_qc_indicator_result_detail WHERE result_id IN (SELECT id FROM (SELECT id FROM mes_qc_indicator_result WHERE code LIKE 'MIR-DEMO%') t);
| DELETE FROM mes_qc_indicator_result WHERE code LIKE 'MIR-DEMO%';
| DELETE FROM mes_qc_iqc_line WHERE iqc_id IN (SELECT id FROM (SELECT id FROM mes_qc_iqc WHERE code LIKE 'IQC-DEMO%') t);
| DELETE FROM mes_qc_iqc WHERE code LIKE 'IQC-DEMO%';
| DELETE FROM mes_qc_ipqc_line WHERE ipqc_id IN (SELECT id FROM (SELECT id FROM mes_qc_ipqc WHERE code LIKE 'IPQC-DEMO%') t);
| DELETE FROM mes_qc_ipqc WHERE code LIKE 'IPQC-DEMO%';
| DELETE FROM mes_qc_oqc_line WHERE oqc_id IN (SELECT id FROM (SELECT id FROM mes_qc_oqc WHERE code LIKE 'OQC-DEMO%') t);
| DELETE FROM mes_qc_oqc WHERE code LIKE 'OQC-DEMO%';
| DELETE FROM mes_qc_rqc_line WHERE rqc_id IN (SELECT id FROM (SELECT id FROM mes_qc_rqc WHERE code LIKE 'RQC-DEMO%') t);
| DELETE FROM mes_qc_rqc WHERE code LIKE 'RQC-DEMO%';
|
| -- ---------- IQC 来料检验单（qc_type=1） ----------
| INSERT INTO mes_qc_iqc (id,code,name,template_id,source_doc_type,source_doc_id,source_line_id,source_doc_code,vendor_id,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,status,sampling_location,certificate_no,execute_standard,audit_user_id,approve_user_id,remark,creator,create_time,updater,update_time,deleted)
| VALUES
| (9001,'IQC-DEMO-01','精萘来料检验-01',NULL,NULL,NULL,NULL,NULL,NULL,'JN-20260918-A01',2,2000,200,198,2,1,'2026-09-17 08:00:00','2026-09-18 09:30:00',231,4,'原料库取样口','CERT-A001','GB/T 6027',232,1,'演示数据','1','2026-09-18 09:00:00','1','2026-09-18 09:30:00',0),
| (9002,'IQC-DEMO-02','精萘来料检验-02',NULL,NULL,NULL,NULL,NULL,NULL,'JN-20260918-A02',2,1500,150,150,0,1,'2026-09-17 08:00:00','2026-09-18 10:15:00',231,4,'精馏塔取样口','CERT-A002','GB/T 6027',232,1,NULL,'1','2026-09-18 10:00:00','1','2026-09-18 10:15:00',0),
| (9003,'IQC-DEMO-03','壬烯来料检验-03',NULL,NULL,NULL,NULL,NULL,NULL,'JN-20260918-A03',4,800,80,76,4,3,'2026-09-17 08:00:00','2026-09-18 11:00:00',231,4,'车间取样口 A-3','CERT-A003','GB/T 6028',232,1,'不合格批次，已走退货流程。','1','2026-09-18 11:00:00','1','2026-09-18 11:00:00',0);
|
| -- ---------- IPQC 过程检验单（qc_type=2） ----------
| INSERT INTO mes_qc_ipqc (id,code,name,type,template_id,source_doc_id,source_doc_code,work_order_id,item_id,check_quantity,qualified_quantity,unqualified_quantity,check_result,inspect_date,inspector_user_id,status,sampling_location,certificate_no,execute_standard,audit_user_id,approve_user_id,remark,creator,create_time,updater,update_time,deleted)
| VALUES
| (9011,'IPQC-DEMO-01','磺化中控检验-01',NULL,NULL,NULL,'GD-20260918-01',NULL,4,300,298,2,1,'2026-09-18 13:00:00',231,4,'磺化工序取样阀','CERT-P001','Q/JH 02-2026',232,1,'演示数据','1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0),
| (9012,'IPQC-DEMO-02','中和中控检验-02',NULL,NULL,NULL,'GD-20260918-02',NULL,6,260,260,0,1,'2026-09-18 14:00:00',231,4,'中和釜取样阀','CERT-P002','Q/JH 02-2026',232,1,'演示数据（密度/酸结果未测）','1','2026-09-18 14:00:00','1','2026-09-18 14:00:00',0),
| (9013,'IPQC-DEMO-03','离心中控检验-03',NULL,NULL,NULL,'GD-20260918-03',NULL,2,120,120,0,1,'2026-09-18 15:30:00',231,4,'离心工序取样口','CERT-P003','Q/JH 02-2026',232,1,'演示数据','1','2026-09-18 15:30:00','1','2026-09-18 15:30:00',0);
|
| -- ---------- OQC 出货检验单（qc_type=3） ----------
| INSERT INTO mes_qc_oqc (id,code,name,template_id,source_doc_code,client_id,batch_code,item_id,out_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,out_date,inspect_date,inspector_user_id,status,sampling_location,certificate_no,execute_standard,audit_user_id,approve_user_id,remark,creator,create_time,updater,update_time,deleted)
| VALUES
| (9021,'OQC-DEMO-01','精萘出货检验-01',NULL,'CH-20260918-01',NULL,'JH-CH0918-01',2,1000,100,99,1,1,'2026-09-18 16:00:00','2026-09-18 16:30:00',231,4,'成品库发货区','CERT-O001','GB/T 6027',232,1,'演示数据','1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0),
| (9022,'OQC-DEMO-02','壬烯出货检验-02',NULL,'CH-20260918-02',NULL,'JH-CH0918-02',4,500,50,50,0,1,'2026-09-18 17:00:00','2026-09-18 17:30:00',231,4,'成品库发货区','CERT-O002','GB/T 6028',232,1,'客户指定复检批次。','1','2026-09-18 17:30:00','1','2026-09-18 17:30:00',0),
| (9023,'OQC-DEMO-03','精萘出货检验-03',NULL,'CH-20260918-03',NULL,'JH-CH0918-03',2,300,30,30,0,1,'2026-09-18 18:00:00','2026-09-18 18:30:00',231,4,'成品库发货区','CERT-O003','GB/T 6027',232,1,NULL,'1','2026-09-18 18:30:00','1','2026-09-18 18:30:00',0);
|
| -- ---------- RQC 退货检验单（qc_type=4） ----------
| INSERT INTO mes_qc_rqc (id,code,name,type,template_id,source_doc_code,item_id,batch_code,check_quantity,qualified_quantity,unqualified_quantity,check_result,inspect_date,inspector_user_id,status,sampling_location,certificate_no,execute_standard,audit_user_id,approve_user_id,remark,creator,create_time,updater,update_time,deleted)
| VALUES
| (9031,'RQC-DEMO-01','精萘退货检验-01',NULL,NULL,'TH-20260918-01',2,'JH-TH0918-01',50,40,10,3,'2026-09-18 19:00:00',231,4,'退货暂存区','CERT-R001','GB/T 6027',232,1,'演示数据','1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0),
| (9032,'RQC-DEMO-02','壬烯退货检验-02',NULL,NULL,'TH-20260918-02',4,'JH-TH0918-02',30,30,0,1,'2026-09-18 19:30:00',231,4,'退货暂存区','CERT-R002','GB/T 6028',232,1,'退货原因：运输污染，全批复检。','1','2026-09-18 19:30:00','1','2026-09-18 19:30:00',0),
| (9033,'RQC-DEMO-03','液碱退货检验-03',NULL,NULL,'TH-20260918-03',6,'JH-TH0918-03',20,18,2,2,'2026-09-18 20:00:00',231,4,'退货暂存区','CERT-R003','GB/T 1119',232,1,NULL,'1','2026-09-18 20:00:00','1','2026-09-18 20:00:00',0);
|
| -- ---------- 检验单行（指标含分组：21 水分 / 26 酸含量 / 31 正丁醇含量；子项自动补全） ----------
| INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,creator,create_time,updater,update_time,deleted)
| SELECT d.id, i.indicator_id, i.tool, i.check_method, i.standard_value, '1','2026-09-18 09:00:00','1','2026-09-18 09:00:00',0
| FROM (SELECT 9001 id UNION ALL SELECT 9002 UNION ALL SELECT 9003) d
| CROSS JOIN (
| SELECT 19 AS indicator_id,'目测' AS tool,'应澄清透明，无机械杂质' AS check_method,NULL AS standard_value
| UNION ALL SELECT 20,'铂钴比色仪','色度 Hazen ≤ 10',10.000000
| UNION ALL SELECT 21,'卡尔费休水分仪','水分测定分组',NULL
| UNION ALL SELECT 22,'分析天平','称量',NULL
| UNION ALL SELECT 23,'分析天平','称量',NULL
| UNION ALL SELECT 24,'分析天平','称量',NULL
| UNION ALL SELECT 25,NULL,'按公式计算',NULL
| UNION ALL SELECT 26,'电位滴定仪','酸含量测定分组',NULL
| UNION ALL SELECT 27,'自动电位滴定仪','标定',NULL
| UNION ALL SELECT 28,'自动电位滴定仪','滴定',NULL
| UNION ALL SELECT 29,'分析天平','称量',NULL
| UNION ALL SELECT 30,NULL,'按公式计算',NULL
| UNION ALL SELECT 31,'气相色谱仪','正丁醇含量测定分组',NULL
| UNION ALL SELECT 32,'气相色谱仪','外标法',NULL
| UNION ALL SELECT 33,'密度计','密度 (20℃) 809~812',810.000000
| UNION ALL SELECT 34,'阿贝折光仪','折光率 n²⁰D',1.399000
| ) i;
|
| INSERT INTO mes_qc_ipqc_line (ipqc_id,indicator_id,tool,check_method,standard_value,creator,create_time,updater,update_time,deleted)
| SELECT d.id, i.indicator_id, i.tool, i.check_method, i.standard_value, '1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0
| FROM (SELECT 9011 id UNION ALL SELECT 9012 UNION ALL SELECT 9013) d
| CROSS JOIN (
| SELECT 19 AS indicator_id,'目测' AS tool,'应澄清透明，无机械杂质' AS check_method,NULL AS standard_value
| UNION ALL SELECT 20,'铂钴比色仪','色度 Hazen ≤ 10',10.000000
| UNION ALL SELECT 21,'卡尔费休水分仪','水分测定分组',NULL
| UNION ALL SELECT 22,'分析天平','称量',NULL
| UNION ALL SELECT 23,'分析天平','称量',NULL
| UNION ALL SELECT 24,'分析天平','称量',NULL
| UNION ALL SELECT 25,NULL,'按公式计算',NULL
| UNION ALL SELECT 26,'电位滴定仪','酸含量测定分组',NULL
| UNION ALL SELECT 27,'自动电位滴定仪','标定',NULL
| UNION ALL SELECT 28,'自动电位滴定仪','滴定',NULL
| UNION ALL SELECT 29,'分析天平','称量',NULL
| UNION ALL SELECT 30,NULL,'按公式计算',NULL
| UNION ALL SELECT 31,'气相色谱仪','正丁醇含量测定分组',NULL
| UNION ALL SELECT 32,'气相色谱仪','外标法',NULL
| UNION ALL SELECT 33,'密度计','密度 (20℃) 809~812',810.000000
| UNION ALL SELECT 34,'阿贝折光仪','折光率 n²⁰D',1.399000
| ) i;
|
| INSERT INTO mes_qc_oqc_line (oqc_id,indicator_id,tool,check_method,standard_value,creator,create_time,updater,update_time,deleted)
| SELECT d.id, i.indicator_id, i.tool, i.check_method, i.standard_value, '1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0
| FROM (SELECT 9021 id UNION ALL SELECT 9022 UNION ALL SELECT 9023) d
| CROSS JOIN (
| SELECT 19 AS indicator_id,'目测' AS tool,'应澄清透明，无机械杂质' AS check_method,NULL AS standard_value
| UNION ALL SELECT 20,'铂钴比色仪','色度 Hazen ≤ 10',10.000000
| UNION ALL SELECT 21,'卡尔费休水分仪','水分测定分组',NULL
| UNION ALL SELECT 22,'分析天平','称量',NULL
| UNION ALL SELECT 23,'分析天平','称量',NULL
| UNION ALL SELECT 24,'分析天平','称量',NULL
| UNION ALL SELECT 25,NULL,'按公式计算',NULL
| UNION ALL SELECT 26,'电位滴定仪','酸含量测定分组',NULL
| UNION ALL SELECT 27,'自动电位滴定仪','标定',NULL
| UNION ALL SELECT 28,'自动电位滴定仪','滴定',NULL
| UNION ALL SELECT 29,'分析天平','称量',NULL
| UNION ALL SELECT 30,NULL,'按公式计算',NULL
| UNION ALL SELECT 31,'气相色谱仪','正丁醇含量测定分组',NULL
| UNION ALL SELECT 32,'气相色谱仪','外标法',NULL
| UNION ALL SELECT 33,'密度计','密度 (20℃) 809~812',810.000000
| UNION ALL SELECT 34,'阿贝折光仪','折光率 n²⁰D',1.399000
| ) i;
|
| INSERT INTO mes_qc_rqc_line (rqc_id,indicator_id,tool,check_method,standard_value,creator,create_time,updater,update_time,deleted)
| SELECT d.id, i.indicator_id, i.tool, i.check_method, i.standard_value, '1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0
| FROM (SELECT 9031 id UNION ALL SELECT 9032 UNION ALL SELECT 9033) d
| CROSS JOIN (
| SELECT 19 AS indicator_id,'目测' AS tool,'应澄清透明，无机械杂质' AS check_method,NULL AS standard_value
| UNION ALL SELECT 20,'铂钴比色仪','色度 Hazen ≤ 10',10.000000
| UNION ALL SELECT 21,'卡尔费休水分仪','水分测定分组',NULL
| UNION ALL SELECT 22,'分析天平','称量',NULL
| UNION ALL SELECT 23,'分析天平','称量',NULL
| UNION ALL SELECT 24,'分析天平','称量',NULL
| UNION ALL SELECT 25,NULL,'按公式计算',NULL
| UNION ALL SELECT 26,'电位滴定仪','酸含量测定分组',NULL
| UNION ALL SELECT 27,'自动电位滴定仪','标定',NULL
| UNION ALL SELECT 28,'自动电位滴定仪','滴定',NULL
| UNION ALL SELECT 29,'分析天平','称量',NULL
| UNION ALL SELECT 30,NULL,'按公式计算',NULL
| UNION ALL SELECT 31,'气相色谱仪','正丁醇含量测定分组',NULL
| UNION ALL SELECT 32,'气相色谱仪','外标法',NULL
| UNION ALL SELECT 33,'密度计','密度 (20℃) 809~812',810.000000
| UNION ALL SELECT 34,'阿贝折光仪','折光率 n²⁰D',1.399000
| ) i;
|
| -- ---------- 检验结果主表（每单据 1 个样品） ----------
| INSERT INTO mes_qc_indicator_result (id,code,qc_id,qc_type,item_id,sn,remark,creator,create_time,updater,update_time,deleted)
| VALUES
| (9001,'MIR-DEMO-01',9001,1,2,'YP-A001',NULL,'1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9002,'MIR-DEMO-02',9002,1,2,'YP-A002',NULL,'1','2026-09-18 10:15:00','1','2026-09-18 10:15:00',0),
| (9003,'MIR-DEMO-03',9003,1,4,'YP-A003',NULL,'1','2026-09-18 11:00:00','1','2026-09-18 11:00:00',0),
| (9004,'MIR-DEMO-04',9011,2,4,'YP-P001',NULL,'1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0),
| (9005,'MIR-DEMO-05',9012,2,6,'YP-P002',NULL,'1','2026-09-18 14:00:00','1','2026-09-18 14:00:00',0),
| (9006,'MIR-DEMO-06',9013,2,2,'YP-P003',NULL,'1','2026-09-18 15:30:00','1','2026-09-18 15:30:00',0),
| (9007,'MIR-DEMO-07',9021,3,2,'YP-O001',NULL,'1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0),
| (9008,'MIR-DEMO-08',9022,3,4,'YP-O002',NULL,'1','2026-09-18 17:30:00','1','2026-09-18 17:30:00',0),
| (9009,'MIR-DEMO-09',9023,3,2,'YP-O003',NULL,'1','2026-09-18 18:30:00','1','2026-09-18 18:30:00',0),
| (9010,'MIR-DEMO-10',9031,4,2,'YP-R001',NULL,'1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0),
| (9011,'MIR-DEMO-11',9032,4,4,'YP-R002',NULL,'1','2026-09-18 19:30:00','1','2026-09-18 19:30:00',0),
| (9012,'MIR-DEMO-12',9033,4,6,'YP-R003',NULL,'1','2026-09-18 20:00:00','1','2026-09-18 20:00:00',0);
|
| -- ---------- 检验结果明细：独立项 ----------
| -- 9002 不录 密度33/折光率34；9005 不录 正丁醇32；9008 不录 酸结果30 —— 报告中显示 "/"
| INSERT INTO mes_qc_indicator_result_detail (result_id,indicator_id,measure_no,`value`,creator,create_time,updater,update_time,deleted)
| VALUES
| (9001,19,1,'澄清透明液体，无机械杂质','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,20,1,'5','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,33,1,'810','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,34,1,'1.3993','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9002,19,1,'淡黄色透明液体','1','2026-09-18 10:15:00','1','2026-09-18 10:15:00',0),
| (9002,20,1,'8','1','2026-09-18 10:15:00','1','2026-09-18 10:15:00',0),
| (9003,19,1,'透明液体，无悬浮物','1','2026-09-18 11:00:00','1','2026-09-18 11:00:00',0),
| (9003,20,1,'3','1','2026-09-18 11:00:00','1','2026-09-18 11:00:00',0),
| (9003,33,1,'795','1','2026-09-18 11:00:00','1','2026-09-18 11:00:00',0),
| (9003,34,1,'1.3985','1','2026-09-18 11:00:00','1','2026-09-18 11:00:00',0),
| (9004,19,1,'微浊','1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0),
| (9004,20,1,'12','1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0),
| (9004,33,1,'812','1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0),
| (9004,34,1,'1.4001','1','2026-09-18 13:00:00','1','2026-09-18 13:00:00',0),
| (9005,19,1,'澄清透明液体','1','2026-09-18 14:00:00','1','2026-09-18 14:00:00',0),
| (9005,20,1,'6','1','2026-09-18 14:00:00','1','2026-09-18 14:00:00',0),
| (9006,19,1,'无色液体','1','2026-09-18 15:30:00','1','2026-09-18 15:30:00',0),
| (9006,20,1,'4','1','2026-09-18 15:30:00','1','2026-09-18 15:30:00',0),
| (9006,33,1,'809','1','2026-09-18 15:30:00','1','2026-09-18 15:30:00',0),
| (9006,34,1,'1.3990','1','2026-09-18 15:30:00','1','2026-09-18 15:30:00',0),
| (9007,19,1,'澄清透明液体，无机械杂质','1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0),
| (9007,20,1,'5','1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0),
| (9007,33,1,'811','1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0),
| (9007,34,1,'1.3992','1','2026-09-18 16:30:00','1','2026-09-18 16:30:00',0),
| (9008,19,1,'透明液体','1','2026-09-18 17:30:00','1','2026-09-18 17:30:00',0),
| (9008,33,1,'808','1','2026-09-18 17:30:00','1','2026-09-18 17:30:00',0),
| (9008,34,1,'1.3988','1','2026-09-18 17:30:00','1','2026-09-18 17:30:00',0),
| (9009,19,1,'澄清透明液体','1','2026-09-18 18:30:00','1','2026-09-18 18:30:00',0),
| (9009,20,1,'7','1','2026-09-18 18:30:00','1','2026-09-18 18:30:00',0),
| (9009,33,1,'810','1','2026-09-18 18:30:00','1','2026-09-18 18:30:00',0),
| (9009,34,1,'1.3995','1','2026-09-18 18:30:00','1','2026-09-18 18:30:00',0),
| (9010,19,1,'浑浊，底部沉淀','1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0),
| (9010,20,1,'18','1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0),
| (9010,33,1,'815','1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0),
| (9010,34,1,'1.4005','1','2026-09-18 19:00:00','1','2026-09-18 19:00:00',0),
| (9011,19,1,'透明液体','1','2026-09-18 19:30:00','1','2026-09-18 19:30:00',0),
| (9011,20,1,'6','1','2026-09-18 19:30:00','1','2026-09-18 19:30:00',0),
| (9011,34,1,'1.3991','1','2026-09-18 19:30:00','1','2026-09-18 19:30:00',0),
| (9012,19,1,'淡黄色液体','1','2026-09-18 20:00:00','1','2026-09-18 20:00:00',0),
| (9012,20,1,'9','1','2026-09-18 20:00:00','1','2026-09-18 20:00:00',0),
| (9012,33,1,'810','1','2026-09-18 20:00:00','1','2026-09-18 20:00:00',0),
| (9012,34,1,'1.3993','1','2026-09-18 20:00:00','1','2026-09-18 20:00:00',0);
|
| -- ---------- 分组子项明细：9001 含平行测量（酸结果2批、正丁醇含量3批顿号合并） ----------
| INSERT INTO mes_qc_indicator_result_detail (result_id,indicator_id,measure_no,`value`,creator,create_time,updater,update_time,deleted)
| VALUES
| (9001,22,1,'10.52','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,23,1,'12.35','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,24,1,'1.83','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,25,1,'0.048','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,27,1,'0.1005','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,28,1,'0.15','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,29,1,'10.02','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,30,1,'0.090','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,30,2,'0.095','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,32,1,'99.82','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,32,2,'99.85','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0),
| (9001,32,3,'99.87','1','2026-09-18 09:30:00','1','2026-09-18 09:30:00',0);
|
| -- ---------- 分组子项明细：其余样品（单批），并按注释故意缺项 ----------
| INSERT INTO mes_qc_indicator_result_detail (result_id,indicator_id,measure_no,`value`,creator,create_time,updater,update_time,deleted)
| SELECT r.id, m.indicator_id, 1, m.val, '1','2026-09-18 12:00:00','1','2026-09-18 12:00:00',0
| FROM (
| SELECT 9002 AS id UNION ALL SELECT 9003 UNION ALL SELECT 9004 UNION ALL SELECT 9005 UNION ALL
| SELECT 9006 UNION ALL SELECT 9007 UNION ALL SELECT 9008 UNION ALL SELECT 9009 UNION ALL
| SELECT 9010 UNION ALL SELECT 9011 UNION ALL SELECT 9012
| ) r
| CROSS JOIN (
| SELECT 22 AS indicator_id,'10.50' AS val
| UNION ALL SELECT 23,'12.30'
| UNION ALL SELECT 24,'1.80'
| UNION ALL SELECT 25,'0.052'
| UNION ALL SELECT 27,'0.1005'
| UNION ALL SELECT 28,'0.14'
| UNION ALL SELECT 29,'10.00'
| UNION ALL SELECT 30,'0.095'
| UNION ALL SELECT 32,'99.78'
| ) m
| WHERE NOT (r.id=9005 AND m.indicator_id=32)
| AND NOT (r.id=9008 AND m.indicator_id=30)
| AND NOT (r.id=9011 AND m.indicator_id=22);
|
|
