START TRANSACTION;
insert into `mdm_item` (`id`,`code`,`name`,`specification`,`category_id`,`unit_measure_id`,`item_type`,`status`,`is_batch_managed`,`is_serial_managed`,`high_value`,`warehouse_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1998,'12100271','黑果枸杞','90克',13,8,3,0,1,0,0,18,'来源10月15日电商未缴库计划；配方及投料BOM待工艺维护，不套用其他规格配方。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_item` (`id`,`mdm_item_id`,`code`,`name`,`specification`,`unit_measure_id`,`status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1998,1998,'12100271','黑果枸杞','90克',8,0,'来源10月15日电商未缴库计划','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mdm_item` (`id`,`code`,`name`,`specification`,`category_id`,`unit_measure_id`,`item_type`,`status`,`is_batch_managed`,`is_serial_managed`,`high_value`,`warehouse_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1999,'UC000017','雪菊','50g',6,8,3,0,1,0,0,18,'来源10月15日电商未缴库计划；配方及投料BOM待工艺维护，不套用其他规格配方。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_item` (`id`,`mdm_item_id`,`code`,`name`,`specification`,`unit_measure_id`,`status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1999,1999,'UC000017','雪菊','50g',8,0,'来源10月15日电商未缴库计划','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mdm_item` (`id`,`code`,`name`,`specification`,`category_id`,`unit_measure_id`,`item_type`,`status`,`is_batch_managed`,`is_serial_managed`,`high_value`,`warehouse_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2000,'U2100282','桑椹原浆','500ml（50ml×10）',9,9,3,0,1,0,0,18,'来源10月15日电商未缴库计划；配方及投料BOM待工艺维护，不套用其他规格配方。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_item` (`id`,`mdm_item_id`,`code`,`name`,`specification`,`unit_measure_id`,`status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2000,2000,'U2100282','桑椹原浆','500ml（50ml×10）',9,0,'来源10月15日电商未缴库计划','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route` (`code`,`name`,`status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('RT-FLOWER-BOTTLE-PACK','花类瓶装分装包装工艺路线',0,'用于50g雪菊分装包装；工序沿用现有基础工序，不新增配方参数。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,0.980000,NULL,60,1,10,2,3,0,0,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,0.980000,NULL,60,2,20,3,3,0,0,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,0.980000,NULL,60,3,30,10,3,0,0,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,0.980000,NULL,60,10,40,11,3,1,0,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,0.980000,NULL,60,11,50,12,3,0,0,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,0.980000,NULL,60,12,60,13,3,0,1,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_process` (`param_template_id`,`yield_rate`,`color_code`,`route_id`,`process_id`,`sort`,`next_process_id`,`link_type`,`key_flag`,`check_flag`,`backflush_flag`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,0.980000,NULL,60,13,70,NULL,3,0,0,0,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
update `mdm_item` set `unit_measure_id`=9 where id=517;
update `mes_md_item` set `unit_measure_id`=9 where id=517;
update `mdm_item` set `name`='γ-氨基丁酸营养素饮品（蜜桃味）',`specification`='350ml(35ml×10)' where id=517;
update `mes_md_item` set `name`='γ-氨基丁酸营养素饮品（蜜桃味）',`specification`='350ml(35ml×10)' where id=517;
update `mdm_item` set `unit_measure_id`=9 where id=512;
update `mes_md_item` set `unit_measure_id`=9 where id=512;
update `mdm_item` set `name`='γ-氨基丁酸酸枣仁饮品（桃子味）',`specification`='350ml(35ml×10)' where id=512;
update `mes_md_item` set `name`='γ-氨基丁酸酸枣仁饮品（桃子味）',`specification`='350ml(35ml×10)' where id=512;
update `mdm_item` set `name`='血蛋白营养素饮',`specification`='500ml（50ml*10)' where id=1541;
update `mes_md_item` set `name`='血蛋白营养素饮',`specification`='500ml（50ml*10)' where id=1541;
update `mdm_item` set `unit_measure_id`=9 where id=502;
update `mes_md_item` set `unit_measure_id`=9 where id=502;
update `mdm_item` set `name`='红黑枸杞原浆礼盒-1800ml(30ml*60袋)',`specification`='1800ml' where id=502;
update `mes_md_item` set `name`='红黑枸杞原浆礼盒-1800ml(30ml*60袋)',`specification`='1800ml' where id=502;
insert into `mes_pro_route_product` (`route_id`,`item_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(57,502,'按10月15日计划产品配置；配方及投料沿用产品自身BOM，不套用其他规格。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
update `mdm_item` set `unit_measure_id`=9 where id=485;
update `mes_md_item` set `unit_measure_id`=9 where id=485;
update `mdm_item` set `name`='黑枸杞250克（50克*5）',`specification`='250克（50克*5）' where id=485;
update `mes_md_item` set `name`='黑枸杞250克（50克*5）',`specification`='250克（50克*5）' where id=485;
update `mdm_item` set `name`='黑红枸杞原浆-30ml',`specification`='30ml' where id=1510;
update `mes_md_item` set `name`='黑红枸杞原浆-30ml',`specification`='30ml' where id=1510;
insert into `mes_pro_route_product` (`route_id`,`item_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(18,1510,'按10月15日计划产品配置；配方及投料沿用产品自身BOM，不套用其他规格。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
update `mdm_item` set `unit_measure_id`=64 where id=487;
update `mes_md_item` set `unit_measure_id`=64 where id=487;
update `mdm_item` set `name`='黑枸杞 大果 500克（250克*2）特优级',`specification`='500克（250克*2)' where id=487;
update `mes_md_item` set `name`='黑枸杞 大果 500克（250克*2）特优级',`specification`='500克（250克*2)' where id=487;
update `mdm_item` set `unit_measure_id`=9 where id=497;
update `mes_md_item` set `unit_measure_id`=9 where id=497;
update `mdm_item` set `name`='枸杞原浆-300ml',`specification`='300ml' where id=497;
update `mes_md_item` set `name`='枸杞原浆-300ml',`specification`='300ml' where id=497;
update `mdm_item` set `unit_measure_id`=8 where id=486;
update `mes_md_item` set `unit_measure_id`=8 where id=486;
update `mdm_item` set `name`='黑果枸杞-250克甲级',`specification`='250克' where id=486;
update `mes_md_item` set `name`='黑果枸杞-250克甲级',`specification`='250克' where id=486;
update `mdm_item` set `name`='黑果枸杞-90克',`specification`='90克' where id=1998;
update `mes_md_item` set `name`='黑果枸杞-90克',`specification`='90克' where id=1998;
insert into `mes_pro_route_product` (`route_id`,`item_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,1998,'按10月15日计划产品配置；配方及投料沿用产品自身BOM，不套用其他规格。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_route_product` (`route_id`,`item_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(60,1999,'按10月15日计划产品配置；配方及投料沿用产品自身BOM，不套用其他规格。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
update `mdm_item` set `name`='桑椹原浆',`specification`='500ml（50ml*10）' where id=2000;
update `mes_md_item` set `name`='桑椹原浆',`specification`='500ml（50ml*10）' where id=2000;
insert into `mes_pro_route_product` (`route_id`,`item_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(17,2000,'按10月15日计划产品配置；配方及投料沿用产品自身BOM，不套用其他规格。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation` (`no`,`name`,`customer_id`,`owner_user_id`,`status`,`quotation_time`,`valid_until`,`total_product_price`,`discount_percent`,`discount_price`,`total_price`,`tax_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('QT20261015000001','总公司10月营养保健供货报价',1613,291,10,'2026-10-15 08:05:00','2026-10-30 18:00:00',1475658.40,0,0,1475658.40,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。','291','291','2026-10-15 08:05:00','2026-10-15 08:05:00',0,0);
insert into `crm_contract` (`no`,`name`,`customer_id`,`owner_user_id`,`audit_status`,`order_date`,`start_time`,`end_time`,`total_product_price`,`total_price`,`discount_percent`,`deposit_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('HT20261015000001','总公司10月营养保健供货合同',1613,291,20,'2026-10-15 08:20:00','2026-10-15 08:20:00','2026-11-30 18:00:00',1475658.40,1475658.40,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 月结，2026年11月30日回款；未录实际收款。','291','291','2026-10-15 08:20:00','2026-10-15 08:20:00',0);
insert into `erp_sale_order` (`no`,`status`,`customer_id`,`contract_id`,`contract_no`,`sale_user_id`,`order_time`,`total_count`,`total_product_price`,`total_tax_price`,`total_price`,`discount_percent`,`discount_price`,`deposit_price`,`out_count`,`out_status`,`production_status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('XSDD20261015000001',20,1613,558,'HT20261015000001',291,'2026-10-15 08:40:00',67208,1475658.40,0,1475658.40,0,0,0,0,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 未缴库、未发货。','291','291','2026-10-15 08:40:00','2026-10-15 08:40:00',0);
update `crm_contract` set `order_id`=1071,`order_no`='XSDD20261015000001' where id=558;
update `crm_sale_quotation` set `contract_id`=558,`contract_no`='HT20261015000001' where id=558;
insert into `crm_receivable_plan` (`period`,`customer_id`,`contract_id`,`owner_user_id`,`return_time`,`return_type`,`price`,`remind_days`,`remind_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1613,558,291,'2026-11-30 16:00:00',8,1475658.40,3,'2026-11-27 09:00:00','总公司10月供货月结，11月30日一次回款；仅建计划，尚未收款。','291','291','2026-10-15 08:25:00','2026-10-15 08:25:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,558,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,558,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,59,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(558,517,9,15.4,19216,295926.40,15.4,0,'291','291','2026-10-15 08:10:00','2026-10-15 08:10:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(558,517,9,15.4,19216,295926.40,15.4,'291','291','2026-10-15 08:20:00','2026-10-15 08:20:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1071,517,9,15.4,19216,295926.40,0,0,1,'原项目号：Q2100202；半成品已生产完毕等通知发货','291','291','2026-10-15 08:40:00','2026-10-15 08:40:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015004',4,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015004','γ-氨基丁酸营养素饮品（蜜桃味）生产工单',1,1,'XSDD20261015000001',517,19216,0,0,0,1613,23,'2026-10-20 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月15日；半成品已生产完毕等通知发货','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015001',1,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015001',1,1071,'XSDD20261015000001',4213,517,19216,0,9,1613,'2026-10-20 18:00:00','2026-10-15 09:10:00',131,'WO_20261015004',0,'来源：营养保健第3行；计划开工10月15日；原项目号：Q2100202；半成品已生产完毕等通知发货','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3532 where id=4213;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,131,10,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,131,20,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,131,30,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,667,538.048000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,668,1076.096000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,672,1.095312,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,675,7.340512,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,676,29.323616,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,677,1.460416,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,680,15.372800,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,681,3.670256,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,683,219927.120000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,701,1320.139200,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,702,73.020800,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,703,19216.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,704,1095312.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,705,7330.904000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,706,16862.040000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,707,13927.756800,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,708,4250.579200,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,709,3666.412800,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,710,1466.180800,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,711,586.088000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,712,659.108800,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(558,512,9,14.9,30000,447000.00,14.9,0,'291','291','2026-10-15 08:10:00','2026-10-15 08:10:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(558,512,9,14.9,30000,447000.00,14.9,'291','291','2026-10-15 08:20:00','2026-10-15 08:20:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1071,512,9,14.9,30000,447000.00,0,0,1,'原项目号：Q2100201；','291','291','2026-10-15 08:40:00','2026-10-15 08:40:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015005',5,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015005','γ-氨基丁酸酸枣仁饮品（桃子味）生产工单',1,1,'XSDD20261015000001',512,30000,0,0,0,1613,20,'2026-10-23 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月20日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015002',2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015002',1,1071,'XSDD20261015000001',4214,512,30000,0,9,1613,'2026-10-23 18:00:00','2026-10-15 09:10:00',132,'WO_20261015005',0,'来源：营养保健第4行；计划开工10月20日；原项目号：Q2100201；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3533 where id=4214;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,30,3,36,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(36,44,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,40,3,42,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(42,55,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,50,3,43,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(43,56,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,60,3,21,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(21,22,0.980000,NULL,0,1,0,NULL,NULL,NULL,132,70,3,22,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(22,23,0.980000,NULL,0,1,0,NULL,NULL,NULL,132,80,3,23,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(23,24,0.980000,NULL,0,1,0,NULL,NULL,NULL,132,90,3,24,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(24,57,0.980000,NULL,0,1,0,NULL,NULL,NULL,132,100,3,25,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(25,58,0.980000,NULL,0,1,0,NULL,NULL,NULL,132,110,3,26,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(26,27,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,120,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,132,130,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,132,140,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,132,150,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,610,30000.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,667,834.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,668,1680.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,670,1515.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,671,462.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,672,6.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,673,6.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,674,12.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,675,48.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,676,99.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,677,6.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,678,6.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,679,6.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,680,36.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,681,24.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,682,30000.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,683,346500.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(132,684,12.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(558,1541,9,46.5,10000,465000.00,46.5,0,'291','291','2026-10-15 08:10:00','2026-10-15 08:10:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(558,1541,9,46.5,10000,465000.00,46.5,'291','291','2026-10-15 08:20:00','2026-10-15 08:20:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1071,1541,9,46.5,10000,465000.00,0,0,1,'原项目号：U2100335；','291','291','2026-10-15 08:40:00','2026-10-15 08:40:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015006',6,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015006','血蛋白营养素饮生产工单',1,1,'XSDD20261015000001',1541,10000,0,0,0,1613,56,'2026-10-27 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月22日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015003',3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015003',1,1071,'XSDD20261015000001',4215,1541,10000,0,9,1613,'2026-10-27 18:00:00','2026-10-15 09:10:00',133,'WO_20261015006',0,'来源：营养保健第5行；计划开工10月22日；原项目号：U2100335；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3534 where id=4215;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,30,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,40,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,133,50,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,133,60,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,70,3,23,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(23,23,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,80,3,24,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(24,24,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,90,3,25,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(25,25,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,100,3,30,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,30,0.980000,NULL,0,0,0,NULL,NULL,NULL,133,110,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(558,1542,9,33.5,7992,267732.00,33.5,0,'291','291','2026-10-15 08:10:00','2026-10-15 08:10:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(558,1542,9,33.5,7992,267732.00,33.5,'291','291','2026-10-15 08:20:00','2026-10-15 08:20:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1071,1542,9,33.5,7992,267732.00,0,0,1,'原项目号：U2100336；半成品已生产完毕等通知发货','291','291','2026-10-15 08:40:00','2026-10-15 08:40:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015007',7,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015007','血红素铁红枣饮生产工单',1,1,'XSDD20261015000001',1542,7992,0,0,0,1613,56,'2026-10-21 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月19日；半成品已生产完毕等通知发货','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015004',4,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015004',1,1071,'XSDD20261015000001',4216,1542,7992,0,9,1613,'2026-10-21 18:00:00','2026-10-15 09:10:00',134,'WO_20261015007',0,'来源：营养保健第6行；计划开工10月19日；原项目号：U2100336；半成品已生产完毕等通知发货','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3535 where id=4216;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,134,10,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,134,20,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,134,30,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation` (`no`,`name`,`customer_id`,`owner_user_id`,`status`,`quotation_time`,`valid_until`,`total_product_price`,`discount_percent`,`discount_price`,`total_price`,`tax_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('QT20261015000002','总公司10月原浆供货供货报价',1613,291,10,'2026-10-15 08:06:00','2026-10-30 18:00:00',424723.00,0,0,424723.00,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。','291','291','2026-10-15 08:06:00','2026-10-15 08:06:00',0,0);
insert into `crm_contract` (`no`,`name`,`customer_id`,`owner_user_id`,`audit_status`,`order_date`,`start_time`,`end_time`,`total_product_price`,`total_price`,`discount_percent`,`deposit_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('HT20261015000002','总公司10月原浆供货供货合同',1613,291,20,'2026-10-15 08:21:00','2026-10-15 08:21:00','2026-11-30 18:00:00',424723.00,424723.00,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 月结，2026年11月30日回款；未录实际收款。','291','291','2026-10-15 08:21:00','2026-10-15 08:21:00',0);
insert into `erp_sale_order` (`no`,`status`,`customer_id`,`contract_id`,`contract_no`,`sale_user_id`,`order_time`,`total_count`,`total_product_price`,`total_tax_price`,`total_price`,`discount_percent`,`discount_price`,`deposit_price`,`out_count`,`out_status`,`production_status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('XSDD20261015000002',20,1613,559,'HT20261015000002',291,'2026-10-15 08:41:00',104433,424723.00,0,424723.00,0,0,0,0,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 未缴库、未发货。','291','291','2026-10-15 08:41:00','2026-10-15 08:41:00',0);
update `crm_contract` set `order_id`=1072,`order_no`='XSDD20261015000002' where id=559;
update `crm_sale_quotation` set `contract_id`=559,`contract_no`='HT20261015000002' where id=559;
insert into `crm_receivable_plan` (`period`,`customer_id`,`contract_id`,`owner_user_id`,`return_time`,`return_type`,`price`,`remind_days`,`remind_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1613,559,291,'2026-11-30 16:00:00',8,424723.00,3,'2026-11-27 09:00:00','总公司10月供货月结，11月30日一次回款；仅建计划，尚未收款。','291','291','2026-10-15 08:26:00','2026-10-15 08:26:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,559,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,559,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,60,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(559,502,9,63,3033,191079.00,63,0,'291','291','2026-10-15 08:11:00','2026-10-15 08:11:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(559,502,9,63,3033,191079.00,63,'291','291','2026-10-15 08:21:00','2026-10-15 08:21:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1072,502,9,63,3033,191079.00,0,0,1,'原项目号：Q2100197、Q2100196、81013526；','291','291','2026-10-15 08:41:00','2026-10-15 08:41:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015008',8,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015008','红黑枸杞原浆礼盒-1800ml(30ml*60袋)生产工单',1,1,'XSDD20261015000002',502,3033,0,0,0,1613,57,'2026-10-22 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月20日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015005',5,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015005',1,1072,'XSDD20261015000002',4217,502,3033,0,9,1613,'2026-10-22 18:00:00','2026-10-15 09:10:00',135,'WO_20261015008',0,'来源：电商已下单10月份缴库产品第3行；计划开工10月20日；原项目号：Q2100197、Q2100196、81013526；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3536 where id=4217;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,135,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,135,20,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,0,0,0,NULL,NULL,NULL,135,30,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,135,40,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,135,50,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,135,60,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(135,628,90990.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(135,630,3033.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(135,631,758.250000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(135,632,379.125000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(135,642,3033.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(135,643,90990.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(559,1510,3,2.12,100000,212000.00,2.12,0,'291','291','2026-10-15 08:11:00','2026-10-15 08:11:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(559,1510,3,2.12,100000,212000.00,2.12,'291','291','2026-10-15 08:21:00','2026-10-15 08:21:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1072,1510,3,2.12,100000,212000.00,0,0,1,'原项目号：Q2100314；','291','291','2026-10-15 08:41:00','2026-10-15 08:41:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015009',9,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015009','黑红枸杞原浆-30ml生产工单',1,1,'XSDD20261015000002',1510,100000,0,0,0,1613,18,'2026-10-30 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月21日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015006',6,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015006',1,1072,'XSDD20261015000002',4218,1510,100000,0,3,1613,'2026-10-30 18:00:00','2026-10-15 09:10:00',136,'WO_20261015009',0,'来源：电商已下单10月份缴库产品第5行；计划开工10月21日；原项目号：Q2100314；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3537 where id=4218;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,30,3,40,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(40,53,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,40,3,41,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(41,54,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,50,3,20,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(20,21,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,60,3,21,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(21,22,0.980000,NULL,0,1,0,NULL,NULL,NULL,136,70,3,22,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(22,23,0.980000,NULL,0,1,0,NULL,NULL,NULL,136,80,3,23,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(23,24,0.980000,NULL,0,1,0,NULL,NULL,NULL,136,90,3,24,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(24,25,0.980000,NULL,0,1,0,NULL,NULL,NULL,136,100,3,25,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(25,26,0.980000,NULL,0,1,0,NULL,NULL,NULL,136,110,3,26,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(26,27,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,120,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,136,130,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,136,140,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,136,150,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(559,497,9,15.46,1400,21644.00,15.46,0,'291','291','2026-10-15 08:11:00','2026-10-15 08:11:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(559,497,9,15.46,1400,21644.00,15.46,'291','291','2026-10-15 08:21:00','2026-10-15 08:21:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1072,497,9,15.46,1400,21644.00,0,0,1,'原项目号：Q2100080；','291','291','2026-10-15 08:41:00','2026-10-15 08:41:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015010',10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015010','枸杞原浆-300ml生产工单',1,1,'XSDD20261015000002',497,1400,0,0,0,1613,36,'2026-10-19 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月16日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015007',7,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015007',1,1072,'XSDD20261015000002',4219,497,1400,0,9,1613,'2026-10-19 18:00:00','2026-10-15 09:10:00',137,'WO_20261015010',0,'来源：电商已下单10月份缴库产品第7行；计划开工10月16日；原项目号：Q2100080；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3538 where id=4219;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,137,10,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,137,20,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,137,30,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(137,610,1400.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(137,625,1400.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(137,626,39.200000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(137,627,78.400000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(137,628,14000.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation` (`no`,`name`,`customer_id`,`owner_user_id`,`status`,`quotation_time`,`valid_until`,`total_product_price`,`discount_percent`,`discount_price`,`total_price`,`tax_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('QT20261015000003','总公司10月枸杞及雪菊供货报价',1613,291,10,'2026-10-15 08:07:00','2026-10-30 18:00:00',133911.78,0,0,133911.78,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。','291','291','2026-10-15 08:07:00','2026-10-15 08:07:00',0,0);
insert into `crm_contract` (`no`,`name`,`customer_id`,`owner_user_id`,`audit_status`,`order_date`,`start_time`,`end_time`,`total_product_price`,`total_price`,`discount_percent`,`deposit_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('HT20261015000003','总公司10月枸杞及雪菊供货合同',1613,291,20,'2026-10-15 08:22:00','2026-10-15 08:22:00','2026-11-30 18:00:00',133911.78,133911.78,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 月结，2026年11月30日回款；未录实际收款。','291','291','2026-10-15 08:22:00','2026-10-15 08:22:00',0);
insert into `erp_sale_order` (`no`,`status`,`customer_id`,`contract_id`,`contract_no`,`sale_user_id`,`order_time`,`total_count`,`total_product_price`,`total_tax_price`,`total_price`,`discount_percent`,`discount_price`,`deposit_price`,`out_count`,`out_status`,`production_status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('XSDD20261015000003',20,1613,560,'HT20261015000003',291,'2026-10-15 08:42:00',2904,133911.78,0,133911.78,0,0,0,0,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 未缴库、未发货。','291','291','2026-10-15 08:42:00','2026-10-15 08:42:00',0);
update `crm_contract` set `order_id`=1073,`order_no`='XSDD20261015000003' where id=560;
update `crm_sale_quotation` set `contract_id`=560,`contract_no`='HT20261015000003' where id=560;
insert into `crm_receivable_plan` (`period`,`customer_id`,`contract_id`,`owner_user_id`,`return_time`,`return_type`,`price`,`remind_days`,`remind_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1613,560,291,'2026-11-30 16:00:00',8,133911.78,3,'2026-11-27 09:00:00','总公司10月供货月结，11月30日一次回款；仅建计划，尚未收款。','291','291','2026-10-15 08:27:00','2026-10-15 08:27:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,560,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,560,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,61,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(560,485,9,122.74,168,20620.32,122.74,0,'291','291','2026-10-15 08:12:00','2026-10-15 08:12:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(560,485,9,122.74,168,20620.32,122.74,'291','291','2026-10-15 08:22:00','2026-10-15 08:22:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1073,485,9,122.74,168,20620.32,0,0,1,'原项目号：Q2100073；','291','291','2026-10-15 08:42:00','2026-10-15 08:42:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015011',11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015011','黑枸杞250克（50克*5）生产工单',1,1,'XSDD20261015000003',485,168,0,0,0,1613,13,'2026-10-21 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月19日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015008',8,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015008',1,1073,'XSDD20261015000003',4220,485,168,0,9,1613,'2026-10-21 18:00:00','2026-10-15 09:10:00',138,'WO_20261015011',0,'来源：电商已下单10月份缴库产品第4行；计划开工10月19日；原项目号：Q2100073；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3539 where id=4220;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,30,3,4,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(4,4,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,40,3,5,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,5,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,50,3,6,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(6,6,0.980000,NULL,0,1,0,NULL,NULL,NULL,138,60,3,7,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(7,7,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,70,3,8,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,8,0.980000,NULL,0,1,0,NULL,NULL,NULL,138,80,3,9,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,9,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,90,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,100,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,138,110,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,138,120,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,138,130,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,560,42.336000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,568,840.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,569,840.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,570,168.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,571,168.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,572,21.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,573,42.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(138,574,840.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(560,487,64,75.81,666,50489.46,75.81,0,'291','291','2026-10-15 08:12:00','2026-10-15 08:12:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(560,487,64,75.81,666,50489.46,75.81,'291','291','2026-10-15 08:22:00','2026-10-15 08:22:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1073,487,64,75.81,666,50489.46,0,0,1,'原项目号：Q2100077；','291','291','2026-10-15 08:42:00','2026-10-15 08:42:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015012',12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015012','黑枸杞 大果 500克（250克*2）特优级生产工单',1,1,'XSDD20261015000003',487,666,0,0,0,1613,13,'2026-10-26 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月22日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015009',9,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015009',1,1073,'XSDD20261015000003',4221,487,666,0,64,1613,'2026-10-26 18:00:00','2026-10-15 09:10:00',139,'WO_20261015012',0,'来源：电商已下单10月份缴库产品第6行；计划开工10月22日；原项目号：Q2100077；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3540 where id=4221;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,30,3,4,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(4,4,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,40,3,5,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,5,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,50,3,6,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(6,6,0.980000,NULL,0,1,0,NULL,NULL,NULL,139,60,3,7,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(7,7,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,70,3,8,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,8,0.980000,NULL,0,1,0,NULL,NULL,NULL,139,80,3,9,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,9,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,90,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,100,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,139,110,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,139,120,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,139,130,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,574,1332.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,576,1332.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,577,1332.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,582,335.664000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,583,1332.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,584,1332.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,585,666.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,586,55.944000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,587,111.222000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(139,588,666.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(560,486,8,21.48,1800,38664.00,21.48,0,'291','291','2026-10-15 08:12:00','2026-10-15 08:12:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(560,486,8,21.48,1800,38664.00,21.48,'291','291','2026-10-15 08:22:00','2026-10-15 08:22:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1073,486,8,21.48,1800,38664.00,0,0,1,'原项目号：Q2100078；','291','291','2026-10-15 08:42:00','2026-10-15 08:42:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015013',13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015013','黑果枸杞-250克甲级生产工单',1,1,'XSDD20261015000003',486,1800,0,0,0,1613,13,'2026-10-28 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月26日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015010',10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015010',1,1073,'XSDD20261015000003',4222,486,1800,0,8,1613,'2026-10-28 18:00:00','2026-10-15 09:10:00',140,'WO_20261015013',0,'来源：电商已下单10月份缴库产品第8行；计划开工10月26日；原项目号：Q2100078；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3541 where id=4222;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,30,3,4,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(4,4,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,40,3,5,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,5,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,50,3,6,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(6,6,0.980000,NULL,0,1,0,NULL,NULL,NULL,140,60,3,7,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(7,7,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,70,3,8,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,8,0.980000,NULL,0,1,0,NULL,NULL,NULL,140,80,3,9,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,9,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,90,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,100,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,140,110,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,140,120,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,140,130,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,574,1800.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,575,453.600000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,576,1800.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,577,1800.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,578,1800.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,579,1800.000000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,580,75.600000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_bom` (`work_order_id`,`item_id`,`quantity`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(140,581,151.200000,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(560,1998,8,179.1,90,16119.00,179.1,0,'291','291','2026-10-15 08:12:00','2026-10-15 08:12:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(560,1998,8,179.1,90,16119.00,179.1,'291','291','2026-10-15 08:22:00','2026-10-15 08:22:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1073,1998,8,179.1,90,16119.00,0,0,1,'原项目号：12100271；','291','291','2026-10-15 08:42:00','2026-10-15 08:42:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015014',14,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015014','黑果枸杞-90克生产工单',1,1,'XSDD20261015000003',1998,90,0,0,0,1613,13,'2026-10-29 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月27日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015011',11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015011',1,1073,'XSDD20261015000003',4223,1998,90,0,8,1613,'2026-10-29 18:00:00','2026-10-15 09:10:00',141,'WO_20261015014',0,'来源：电商已下单10月份缴库产品第9行；计划开工10月27日；原项目号：12100271；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3542 where id=4223;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,30,3,4,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(4,4,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,40,3,5,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,5,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,50,3,6,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(6,6,0.980000,NULL,0,1,0,NULL,NULL,NULL,141,60,3,7,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(7,7,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,70,3,8,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,8,0.980000,NULL,0,1,0,NULL,NULL,NULL,141,80,3,9,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,9,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,90,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,100,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,1,0,0,NULL,NULL,NULL,141,110,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,141,120,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,141,130,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(560,1999,8,44.55,180,8019.00,44.55,0,'291','291','2026-10-15 08:12:00','2026-10-15 08:12:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(560,1999,8,44.55,180,8019.00,44.55,'291','291','2026-10-15 08:22:00','2026-10-15 08:22:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1073,1999,8,44.55,180,8019.00,0,0,1,'原项目号：UC000017；','291','291','2026-10-15 08:42:00','2026-10-15 08:42:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015015',15,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015015','雪菊生产工单',1,1,'XSDD20261015000003',1999,180,0,0,0,1613,60,'2026-10-30 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月28日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015012',12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015012',1,1073,'XSDD20261015000003',4224,1999,180,0,8,1613,'2026-10-30 18:00:00','2026-10-15 09:10:00',142,'WO_20261015015',0,'来源：电商已下单10月份缴库产品第10行；计划开工10月28日；原项目号：UC000017；','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3543 where id=4224;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,142,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,142,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,142,30,3,10,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(10,10,0.980000,NULL,1,0,0,NULL,NULL,NULL,142,40,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,0,0,0,NULL,NULL,NULL,142,50,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,142,60,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,142,70,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation` (`no`,`name`,`customer_id`,`owner_user_id`,`status`,`quotation_time`,`valid_until`,`total_product_price`,`discount_percent`,`discount_price`,`total_price`,`tax_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('QT20261015000004','总公司10月桑椹原浆供货报价',1613,291,10,'2026-10-15 08:08:00','2026-10-30 18:00:00',28060.00,0,0,28060.00,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。','291','291','2026-10-15 08:08:00','2026-10-15 08:08:00',0,0);
insert into `crm_contract` (`no`,`name`,`customer_id`,`owner_user_id`,`audit_status`,`order_date`,`start_time`,`end_time`,`total_product_price`,`total_price`,`discount_percent`,`deposit_price`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('HT20261015000004','总公司10月桑椹原浆供货合同',1613,291,20,'2026-10-15 08:23:00','2026-10-15 08:23:00','2026-11-30 18:00:00',28060.00,28060.00,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 月结，2026年11月30日回款；未录实际收款。','291','291','2026-10-15 08:23:00','2026-10-15 08:23:00',0);
insert into `erp_sale_order` (`no`,`status`,`customer_id`,`contract_id`,`contract_no`,`sale_user_id`,`order_time`,`total_count`,`total_product_price`,`total_tax_price`,`total_price`,`discount_percent`,`discount_price`,`deposit_price`,`out_count`,`out_status`,`production_status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('XSDD20261015000004',20,1613,561,'HT20261015000004',291,'2026-10-15 08:43:00',1000,28060.00,0,28060.00,0,0,0,0,0,0,'来源：10月15日电商未缴库计划；按表列订单数量及结算单价执行，未另加税额。 未缴库、未发货。','291','291','2026-10-15 08:43:00','2026-10-15 08:43:00',0);
update `crm_contract` set `order_id`=1074,`order_no`='XSDD20261015000004' where id=561;
update `crm_sale_quotation` set `contract_id`=561,`contract_no`='HT20261015000004' where id=561;
insert into `crm_receivable_plan` (`period`,`customer_id`,`contract_id`,`owner_user_id`,`return_time`,`return_type`,`price`,`remind_days`,`remind_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1613,561,291,'2026-11-30 16:00:00',8,28060.00,3,'2026-11-27 09:00:00','总公司10月供货月结，11月30日一次回款；仅建计划，尚未收款。','291','291','2026-10-15 08:28:00','2026-10-15 08:28:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(9,561,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(5,561,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_permission` (`biz_type`,`biz_id`,`user_id`,`level`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(8,62,291,1,'291','291','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `crm_sale_quotation_product` (`quotation_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`quotation_price`,`tax_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values(561,2000,9,28.06,1000,28060.00,28.06,0,'291','291','2026-10-15 08:13:00','2026-10-15 08:13:00',0,0);
insert into `crm_contract_product` (`contract_id`,`item_id`,`item_unit_id`,`item_price`,`count`,`total_price`,`contract_price`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(561,2000,9,28.06,1000,28060.00,28.06,'291','291','2026-10-15 08:23:00','2026-10-15 08:23:00',0);
insert into `erp_sale_order_items` (`order_id`,`product_id`,`product_unit_id`,`product_price`,`count`,`total_price`,`tax_price`,`out_count`,`need_production`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1074,2000,9,28.06,1000,28060.00,0,0,1,'原项目号：U2100282；；原进度：10月15号左右发货','291','291','2026-10-15 08:43:00','2026-10-15 08:43:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(30,'WO_20261015016',16,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order` (`code`,`name`,`type`,`order_source_type`,`order_source_code`,`product_id`,`quantity`,`quantity_produced`,`quantity_scheduled`,`quantity_changed`,`client_id`,`route_id`,`request_date`,`parent_id`,`status`,`auto_finish_flag`,`is_feedback_approve`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('WO_20261015016','桑椹原浆生产工单',1,1,'XSDD20261015000004',2000,1000,0,0,0,1613,17,'2026-10-16 18:00:00',0,1,1,0,'来源10月15日未缴库计划；计划开工10月16日；待排产；未提前报工','244','244','2026-10-15 09:10:00','2026-10-15 09:10:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(65,'MPS20261015013',13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_mps` (`code`,`status`,`sale_order_id`,`sale_order_no`,`sale_order_item_id`,`product_id`,`quantity`,`quantity_produced`,`unit_measure_id`,`client_id`,`request_date`,`issue_date`,`work_order_id`,`work_order_code`,`merge_flag`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`,`tenant_id`) values('MPS20261015013',1,1074,'XSDD20261015000004',4225,2000,1000,0,9,1613,'2026-10-16 18:00:00','2026-10-15 09:10:00',143,'WO_20261015016',0,'来源：电商已下单10月份缴库产品第11行；计划开工10月16日；原项目号：U2100282；；原进度：10月15号左右发货','244','244','2026-10-15 09:00:00','2026-10-15 09:00:00',0,0);
update `erp_sale_order_items` set `mps_id`=3544 where id=4225;
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1,1,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,10,3,2,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(2,2,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,20,3,3,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(3,3,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,30,3,20,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(20,21,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,40,3,21,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(21,31,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,50,3,22,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(22,32,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,60,3,23,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(23,33,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,70,3,24,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(24,52,0.980000,NULL,1,0,0,NULL,NULL,NULL,143,80,3,25,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(25,51,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,90,3,27,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(27,28,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,100,3,11,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(11,11,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,110,3,12,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(12,12,0.980000,NULL,0,1,0,NULL,NULL,NULL,143,120,3,13,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_process` (`process_id`,`param_template_id`,`yield_rate`,`color_code`,`key_flag`,`check_flag`,`backflush_flag`,`output_item_id`,`prepare_time`,`wait_time`,`work_order_id`,`sort`,`link_type`,`next_process_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(13,13,0.980000,NULL,0,0,0,NULL,NULL,NULL,143,130,3,NULL,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(31,'TK_20261015015',15,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_task` (`code`,`name`,`work_order_id`,`workstation_id`,`route_id`,`process_id`,`param_template_id`,`item_id`,`quantity`,`produced_quantity`,`qualify_quantity`,`unqualify_quantity`,`changed_quantity`,`client_id`,`start_time`,`end_time`,`duration`,`status`,`first_feedback_time`,`last_feedback_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('TK_20261015015','γ-氨基丁酸营养素饮品（蜜桃味）-11',131,11,23,11,11,517,20009,800,800,0,0,1613,'2026-10-15 13:43:00','2026-10-15 16:43:00',3,2,'2026-10-15 14:39:38','2026-10-15 14:39:38','半成品已生产完毕；本次仅排剩余包装、检验及缴库，尚未成品入库。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_task_assignee` (`task_id`,`user_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1061,244,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(33,'FB_20261015001',1,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_feedback` (`code`,`type`,`feedback_time`,`workstation_id`,`route_id`,`process_id`,`work_order_id`,`task_id`,`item_id`,`scheduled_quantity`,`feedback_quantity`,`qualified_quantity`,`unqualified_quantity`,`uncheck_quantity`,`labor_scrap_quantity`,`material_scrap_quantity`,`other_scrap_quantity`,`feedback_user_id`,`approve_user_id`,`status`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('FB_20261015001',1,'2026-10-15 14:39:38',11,23,11,131,1061,517,20009,800,800,0,0,0,0,0,244,244,4,'按本次录入要求记录今日包装部分完成800盒；非末道工序，不增加成品库存。','244','244','2026-10-15 14:39:38','2026-10-15 14:39:38',0);
insert into `mes_pro_work_order_param_record` (`work_order_id`,`task_id`,`template_id`,`template_code`,`template_name`,`record_no`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,1061,11,'PT-STP-011','外包装参数模板-011','TASK-1061','排产生成参数快照；实际参数待现场填写。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_param_record_detail` (`record_id`,`template_detail_id`,`param_code`,`param_name`,`param_type`,`required`,`unit_measure_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(207,16,'PP-STP-COUNT','包装数量',1,0,24,'要求：原文未指定统一数值，记录实际值；不得套用其他产品标准。；；来源：STP-SG-003-01、STP-DY-007-00、STP-SG-002-04、STP-GT-015-04、STP-GT-016-04、STP-GY-001-06、STP-DY-001-02、STP-GT-009-07、STP-GY-002-05、STP-SG-001-09、STP-GT-010-05、STP-FB-005-00、STP-YL-006-00、STP-YL-016-00、STP-YL-008-00、STP-YL-010-00、STP-YL-015-00、STP-YL-018-00、STP-YL-009-00、STP-YL-012-00、STP-YL-017-00、STP-YL-011-00、STP-YL-007-00、STP-YL-013-00；实际值由现场录入。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(31,'TK_20261015016',16,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_task` (`code`,`name`,`work_order_id`,`workstation_id`,`route_id`,`process_id`,`param_template_id`,`item_id`,`quantity`,`produced_quantity`,`qualify_quantity`,`unqualify_quantity`,`changed_quantity`,`client_id`,`start_time`,`end_time`,`duration`,`status`,`first_feedback_time`,`last_feedback_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('TK_20261015016','γ-氨基丁酸营养素饮品（蜜桃味）-12',131,12,23,12,12,517,19609,0,0,0,0,1613,'2026-10-15 16:43:00','2026-10-19 15:43:00',17,0,NULL,NULL,'半成品已生产完毕；本次仅排剩余包装、检验及缴库，尚未成品入库。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_task_assignee` (`task_id`,`user_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1062,244,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_param_record` (`work_order_id`,`task_id`,`template_id`,`template_code`,`template_name`,`record_no`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,1062,12,'PT-STP-012','成品检验参数模板-012','TASK-1062','排产生成参数快照；实际参数待现场填写。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_param_record_detail` (`record_id`,`template_detail_id`,`param_code`,`param_name`,`param_type`,`required`,`unit_measure_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(208,17,'PP-STP-SAMPLE','检验抽样数量',1,0,24,'要求：原文未指定统一数值，记录实际值；不得套用其他产品标准。；；来源：STP-SG-003-01、STP-DY-007-00、STP-SG-002-04、STP-GT-015-04、STP-GT-016-04、STP-GY-001-06、STP-DY-001-02、STP-GT-009-07、STP-GY-002-05、STP-SG-001-09、STP-GT-010-05、STP-FB-005-00、STP-YL-006-00、STP-YL-016-00、STP-YL-008-00、STP-YL-010-00、STP-YL-015-00、STP-YL-018-00、STP-YL-009-00、STP-YL-012-00、STP-YL-017-00、STP-YL-011-00、STP-YL-007-00、STP-YL-013-00；实际值由现场录入。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_md_auto_code_record` (`rule_id`,`result`,`serial_no`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(31,'TK_20261015017',17,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_task` (`code`,`name`,`work_order_id`,`workstation_id`,`route_id`,`process_id`,`param_template_id`,`item_id`,`quantity`,`produced_quantity`,`qualify_quantity`,`unqualify_quantity`,`changed_quantity`,`client_id`,`start_time`,`end_time`,`duration`,`status`,`first_feedback_time`,`last_feedback_time`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values('TK_20261015017','γ-氨基丁酸营养素饮品（蜜桃味）-13',131,13,23,13,13,517,19216,0,0,0,0,1613,'2026-10-19 15:43:00','2026-10-23 09:43:00',30,0,NULL,NULL,'半成品已生产完毕；本次仅排剩余包装、检验及缴库，尚未成品入库。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_task_assignee` (`task_id`,`user_id`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(1063,244,'244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_param_record` (`work_order_id`,`task_id`,`template_id`,`template_code`,`template_name`,`record_no`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(131,1063,13,'PT-STP-013','成品入库参数模板-013','TASK-1063','排产生成参数快照；实际参数待现场填写。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
insert into `mes_pro_work_order_param_record_detail` (`record_id`,`template_detail_id`,`param_code`,`param_name`,`param_type`,`required`,`unit_measure_id`,`remark`,`creator`,`updater`,`create_time`,`update_time`,`deleted`) values(209,18,'PP-STP-COUNT','包装数量',1,0,24,'要求：原文未指定统一数值，记录实际值；不得套用其他产品标准。；；来源：STP-SG-003-01、STP-DY-007-00、STP-SG-002-04、STP-GT-015-04、STP-GT-016-04、STP-GY-001-06、STP-DY-001-02、STP-GT-009-07、STP-GY-002-05、STP-SG-001-09、STP-GT-010-05、STP-FB-005-00、STP-YL-006-00、STP-YL-016-00、STP-YL-008-00、STP-YL-010-00、STP-YL-015-00、STP-YL-018-00、STP-YL-009-00、STP-YL-012-00、STP-YL-017-00、STP-YL-011-00、STP-YL-007-00、STP-YL-013-00；实际值由现场录入。','244','244','2026-10-15 08:00:00','2026-10-15 08:00:00',0);
update `mes_pro_work_order` set `quantity_scheduled`=19216 where id=131;
update `mes_pro_work_order` set `request_date`='2026-10-23 18:00:00' where id=131;
update `mes_pro_mps` set `request_date`='2026-10-23 18:00:00' where id=3532;
COMMIT;