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 ('Y202608020','燕麦粉来料检验',23,'江西谷邑丰食品科技有限公司','20260628',831,1700,1700,1700,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 1,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=23 AND ti.deleted=0;
COMMIT;