START TRANSACTION;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609020','复合果蔬粉来料检验',194,'南京泽朗生物科技有限公司','ZLSC2026082403',1088,80,80,80,0,1,'2026-08-16 00:00:00','2026-08-31 00:00:00',289,'生产单位：南京泽朗生物科技有限公司；原产地：南京；规格：10kg/箱',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 2,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=194 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609005','当归粉来料检验',121,'河南华商食品添加剂有限公司','XTY20260403',1035,12.5e0,12.5e0,12.5e0,0,1,'2026-08-14 00:00:00','2026-08-29 00:00:00',289,'生产单位：陕西新天域生物科技有限公司；原产地：陕西；规格：12.5kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 3,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=121 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609015','抗性糊精来料检验',195,'北京合众华远贸易有限公司','202604201D',1086,100,100,100,0,1,'2026-08-16 00:00:00','2026-08-31 00:00:00',289,'生产单位：山东百龙创园生物科技股份有限公司；原产地：山东；规格：25kg/箱',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 4,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=195 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609007','柠檬浓缩液来料检验',76,'辉县市红果生物科技有限公司','',672,50,50,50,0,1,'2026-08-17 00:00:00','2026-09-01 00:00:00',289,'生产单位：辉县市红果生物科技有限公司；原产地：/；规格：25kg/箱',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 5,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=76 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609008','桂圆粉来料检验',111,'河南华商食品添加剂有限公司','XTY20260420',1076,1,1,1,0,1,'2026-08-17 00:00:00','2026-09-01 00:00:00',289,'生产单位：陕西新天域生物科技有限公司；原产地：陕西；规格：1000g/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 6,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=111 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609001','猴头菇粉来料检验',159,'江西谷邑丰食品科技有限公司','20260612003',1098,425,425,425,0,1,'2026-08-12 00:00:00','2026-08-27 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 7,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=159 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609006','红枣粉来料检验',112,'河南华商食品添加剂有限公司','XTY20260203',1037,12.5e0,12.5e0,12.5e0,0,1,'2026-08-14 00:00:00','2026-08-29 00:00:00',289,'生产单位：陕西新天域生物科技有限公司；原产地：陕西；规格：12.5kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 8,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=112 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608056','菊粉来料检验',72,'北京合一源科技发展有限公司','C2054821',1039,100,100,100,0,1,'2026-08-09 00:00:00','2026-08-24 00:00:00',289,'生产单位：智利；原产地：智利；规格：25 kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 9,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=72 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202609009','蔓越莓浓缩汁来料检验',101,'杭州绿泉食品有限公司','20260423',1032,125,125,125,0,1,'2026-08-17 00:00:00','2026-09-01 00:00:00',289,'生产单位：福建绿泉食品有限公司；原产地：福建；规格：25kg/箱',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 10,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=101 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608004','低聚异麦芽糖来料检验',156,'北京合众华远贸易有限公司','20260320027',1074,650,650,650,0,1,'2026-07-15 00:00:00','2026-07-30 00:00:00',289,'生产单位：山东百龙创园生物科技股份有限公司；原产地：山东；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 11,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=156 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608005','低聚果糖来料检验',71,'北京合众华远贸易有限公司','2026032203D',675,200,200,200,0,1,'2026-07-15 00:00:00','2026-07-30 00:00:00',289,'生产单位：山东百龙创园生物科技股份有限公司；原产地：山东；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 12,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=71 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608015','大米粉来料检验',160,'江西谷邑丰食品科技有限公司','20260719',1095,3900,3900,3900,0,1,'2026-07-21 00:00:00','2026-08-05 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 13,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=160 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202607038','天麻粉来料检验',138,'安徽州和堂生物科技有限公司','',1014,525,525,525,0,1,'2026-06-22 00:00:00','2026-07-07 00:00:00',289,'生产单位：安徽州和堂生物科技有限公司；原产地：安徽；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 14,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=138 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608029','甘草提取物来料检验',197,'南京泽朗生物科技有限公司','ZLZT2026051304-1',1109,13,13,13,0,1,'2026-07-27 00:00:00','2026-08-11 00:00:00',289,'生产单位：南京泽朗生物科技有限公司；原产地：南京；规格：13kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 15,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=197 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608019','白扁豆粉来料检验',141,'江西谷邑丰食品科技有限公司','20260609',1078,375,375,375,0,1,'2026-07-21 00:00:00','2026-08-05 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 16,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=141 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608031','石榴果粉来料检验',109,'山西霖旭生物科技有限公司','2026071701',1030,500,500,500,0,1,'2026-07-31 00:00:00','2026-08-15 00:00:00',289,'生产单位：山西康辰生物科技有限公司；原产地：山西；规格：25kg/桶',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 17,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=109 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608011','红枣粉来料检验',112,'江西谷邑丰食品科技有限公司','20260618',1037,125,125,125,0,1,'2026-07-21 00:00:00','2026-08-05 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 18,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=112 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608035','红枣粉来料检验',112,'江西谷邑丰食品科技有限公司','20260730',1037,250,250,250,0,1,'2026-07-31 00:00:00','2026-08-15 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 19,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=112 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608012','红米粉来料检验',161,'江西谷邑丰食品科技有限公司','20260714',1100,550,550,550,0,1,'2026-07-21 00:00:00','2026-08-05 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 20,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=161 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608032','红豆粉来料检验',26,'江西谷邑丰食品科技有限公司','20260803',829,2250,2250,2250,0,1,'2026-07-31 00:00:00','2026-08-15 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 21,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=26 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608017','花生粉来料检验',163,'江西谷邑丰食品科技有限公司','20260522',1096,200,200,200,0,1,'2026-07-21 00:00:00','2026-08-05 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 22,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=163 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608009','菊粉来料检验',72,'北京合一源科技发展有限公司','C2054537',1039,25,25,25,0,1,'2026-07-19 00:00:00','2026-08-03 00:00:00',289,'生产单位：智利；原产地：智利；规格：25 kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 23,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=72 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608013','赤小豆粉来料检验',168,'江西谷邑丰食品科技有限公司','20260530',1099,75,75,75,0,1,'2026-07-21 00:00:00','2026-08-05 00:00:00',289,'生产单位：江西谷邑丰食品科技有限公司；原产地：江西；规格：25kg/袋',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 24,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=168 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202607013','金顶侧耳粉来料检验',108,'山西霖旭生物科技有限公司','2026042901',1045,12,12,0,12,2,'2026-06-22 00:00:00','2026-07-07 00:00:00',289,'生产单位：山西康辰生物科技有限公司；原产地：山西；规格：12kg/箱',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 25,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=108 AND ti.deleted=0;
INSERT INTO mes_qc_iqc (code,name,template_id,vendor_name,vendor_batch,item_id,received_quantity,check_quantity,qualified_quantity,unqualified_quantity,check_result,receive_date,inspect_date,inspector_user_id,remark,status,creator,updater) VALUES ('Y202608048','金顶侧耳粉来料检验',108,'山西霖旭生物科技有限公司','2026063001',1045,12.5e0,12.5e0,12.5e0,0,1,'2026-07-28 00:00:00','2026-08-12 00:00:00',289,'生产单位：山西康辰生物科技有限公司；原产地：山西；规格：12.5kg/箱',0,'1','1');
INSERT INTO mes_qc_iqc_line (iqc_id,indicator_id,tool,check_method,standard_value,unit_measure_id,max_threshold,min_threshold,critical_quantity,major_quantity,minor_quantity,creator,updater) SELECT 26,ti.indicator_id,i.tool,ti.check_method,ti.standard_value,ti.unit_measure_id,ti.threshold_max,ti.threshold_min,0,0,0,'1','1' FROM mes_qc_template_indicator ti LEFT JOIN mes_qc_indicator i ON i.id=ti.indicator_id AND i.deleted=0 WHERE ti.template_id=108 AND ti.deleted=0;
COMMIT;