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
| 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 ('T202609004','DL-苹果酸来料检验',256,'河南华商食品添加剂有限公司','2606034',1044,10,10,10,0,1,'2026-08-14 00:00:00','2026-08-29 00:00:00',289,'生产单位：安徽雪郎生物科技股份有限公司；原产地：安徽；规格：2.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 27,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=256 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 ('T202609019','乳酸钙来料检验',258,'北京合众华远贸易有限公司','C260618P',1073,25,25,25,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 28,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=258 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 ('T202609002','乳酸链球菌素来料检验',259,'北京合一源科技发展有限公司','20260526-32',1046,1.5e0,1.5e0,1.5e0,0,1,'2026-08-14 00:00:00','2026-08-29 00:00:00',289,'生产单位：山东福瑞达生物科技有限公司；原产地：山东；规格：500g/袋',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 29,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=259 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 ('T202609030','山梨糖醇来料检验',260,'北京合众华远贸易有限公司','2026041548',1992,300,300,300,0,1,'2026-09-01 00:00:00','2026-09-16 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 30,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=260 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 ('T202609025','山梨糖醇液来料检验',260,'北京合众华远贸易有限公司','26260812249',1082,300,300,300,0,1,'2026-08-16 00:00:00','2026-08-31 00:00:00',289,'生产单位：山东天力药业有限公司；原产地：山东；规格：30kg/桶',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 31,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=260 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 ('T202608054','木糖醇来料检验',261,'北京合一源科技发展有限公司','M260317076',671,200,200,200,0,1,'2026-08-06 00:00:00','2026-08-21 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 32,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=261 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 ('T202609022','木糖醇来料检验',261,'北京合一源科技发展有限公司','M260719200',671,500,500,500,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 33,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=261 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 ('T202609014','柠檬酸钙来料检验',262,'北京合众华远贸易有限公司','20260618158 B',1071,50,50,50,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 34,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=262 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 ('T202609013','柠檬酸锌来料检验',263,'北京合众华远贸易有限公司','20260403118B',1085,25,25,25,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 35,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=263 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 ('T202609024','甘油来料检验',264,'北京合众华远贸易有限公司','D260602-12-1',1070,50,50,50,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 36,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=264 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 ('T202609016','甜菊糖苷来料检验',266,'北京合众华远贸易有限公司','20260602',1087,2,2,2,0,1,'2026-08-16 00:00:00','2026-08-31 00:00:00',289,'生产单位：山东圣香远生物科技股份有限公司；原产地：山东；规格：1kg/袋',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 37,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=266 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 ('T202609018','葡萄糖酸亚铁来料检验',269,'北京合众华远贸易有限公司','20260106117 B',1038,25,25,25,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 38,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=269 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 ('T202606009','赤藓糖醇来料检验',270,'山东国启堂生物科技有限公司','20260611',683,2500,2500,2500,0,1,'2026-06-08 00:00:00','2026-06-23 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 39,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=270 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 ('T202609021','黄原胶来料检验',271,'北京合众华远贸易有限公司','520260328117',754,25,25,25,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 40,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=271 AND ti.deleted=0;
| COMMIT;
|
|
