ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4ccb5a36ac8: POST https://beta.jinchangxiao.com/vue/erp-analysis/sales-product-list-all at 2026-07-07 05:48:10 pm by 114.244.130.20

Performance Profiling

Total processing time: 76 ms; Peak memory: 5.822 MB. Show Profiling Timeline

总计22条数据
TimeDurationCategoryInfo
  
17:48:10.24011.1 msyii\db\Command::querySELECT sum(total_amount) as budget, sum(total_cost) as cost, sum(total_amount - total_cost) as profits, CASE WHEN sum(total_amount) > 0 THEN sum(total_amount - total_cost) / sum(total_amount) * 100 ELSE 0 END as profit_pct FROM (SELECT COALESCE(sum(eipss.actual_total_amount), 0) as total_cost, avg(eipss.actual_amount) as cost, esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, esosps.amount - COALESCE(esosps.cancel_amount, 0) as amount, esosps.number - COALESCE(esosps.cancel_number, 0) as number, esosps.total_amount - COALESCE(esosps.cancel_total_amount, 0) as total_amount, project.bargain_date, (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) as total_profit, CASE WHEN sum(eipss.total_amount) > 0 THEN (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) / sum(eipss.total_amount) * 100 ELSE null END as total_profit_pct FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_products" "p" ON p.id = esosps.product_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (eipss.outbound > 0) AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "esosps"."id", "project"."id") "sub"
17:48:10.2619.9 msyii\db\Command::querySELECT COALESCE(sum(eipss.actual_total_amount), 0) as total_cost, avg(eipss.actual_amount) as cost, esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, esosps.amount - COALESCE(esosps.cancel_amount, 0) as amount, esosps.number - COALESCE(esosps.cancel_number, 0) as number, esosps.total_amount - COALESCE(esosps.cancel_total_amount, 0) as total_amount, project.bargain_date, (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) as total_profit, CASE WHEN sum(eipss.total_amount) > 0 THEN (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) / sum(eipss.total_amount) * 100 ELSE null END as total_profit_pct FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_products" "p" ON p.id = esosps.product_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (eipss.outbound > 0) AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "esosps"."id", "project"."id" ORDER BY "project"."bargain_date" DESC, "project"."updated_at" DESC LIMIT 20 OFFSET 40
17:48:10.2529.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT COALESCE(sum(eipss.actual_total_amount), 0) as total_cost, avg(eipss.actual_amount) as cost, esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, esosps.amount - COALESCE(esosps.cancel_amount, 0) as amount, esosps.number - COALESCE(esosps.cancel_number, 0) as number, esosps.total_amount - COALESCE(esosps.cancel_total_amount, 0) as total_amount, project.bargain_date, (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) as total_profit, CASE WHEN sum(eipss.total_amount) > 0 THEN (sum(eipss.total_amount) - sum(eipss.actual_total_amount)) / sum(eipss.total_amount) * 100 ELSE null END as total_profit_pct FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_products" "p" ON p.id = esosps.product_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (eipss.outbound > 0) AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "esosps"."id", "project"."id" ORDER BY "project"."bargain_date" DESC, "project"."updated_at" DESC) "c"
17:48:10.2893.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/sales-product-list-all', '{"page":"3","project_status":["3","-1"],"period":"currentfascalyear","web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":{"list":[{"total_cost":"3374.82","cost":"3374.8200000000000000","id":501,"erp_sales_outbound_id":135,"product_id":1528,"amount":"0","number":"1","total_amount":"0","bargain_date":"2026-01-27","total_profit":"-3374.82","total_profit_pct":"0.00","erpSalesOutbound":{"id":135,"serial_no":"XSCKD-20260205-00001","from_date":"","wrote_date":"2026-02-05","handler":5300,"erp_sales_order_id":1678,"client_id":12,"project_id":4094,"erp_store_id":1,"status":2,"erp_send_type_id":5,"abstract":"\u5229\u6da6\u7387\uff1a13.21%\uff1b\u6536\u8d27\u4eba\uff1a\u8bb8\u4e16\u5fe0\uff1b\u5168\u52c7\u7537\u79ef\u52067500\u5143\u3002","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-05 16:17:39","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"7","amount":"57000","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-02-05 15:58:32","updated_at":"2026-02-05 16:17:39","print_times":1,"is_sales_order_ready":true,"project":{"id":4094,"client_id":12,"project_status":3,"project_progress":9,"budget":"57000","profit_pct":"13.21","bargain_date":"2026-01-27","description":"","created_by":5300,"created_at":"2026-01-07 10:01:28","updated_at":"2026-03-05 22:58:45","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u6388\u6743\u65b0\u8d2dPOCN26018145-2026","collected":"57000","status_updated_at":"2026-01-27 10:12:49.184378+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 10:12:14.989444+08","forecast_updated_at":"2026-01-07 10:01:28.367137+08","end_at":"2026-03-12 17:01:51","pinyin_shortcut":"sxfxnhsqxgPOCN260181452026","creator":5300,"used_client":"","from_contact":"","total_contact_point":"7500","paid_contact_point":"","project_product_version_id":1320,"is_sales_order_ready":true,"collected_plan":"57000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4394,"from_project":4094,"serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN26018145"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":1528,"name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6V6.0","product_type":7,"product_component":29,"product_brand":12,"product_serie":525,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-03-26 15:30:32","updated_at":"2026-03-31 17:17:16","pinyin_shortcut":"sxfjsfwqxnhrjV60","product_unit":2,"is_renew":false,"in_out_at":"2026-03-31 17:17:16.259159+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":29,"key":29,"name":"\u865a\u62df\u5316\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":525,"key":525,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4094,"client_id":12,"project_status":3,"project_progress":9,"budget":"57000","profit_pct":"13.21","bargain_date":"2026-01-27","description":"","created_by":5300,"created_at":"2026-01-07 10:01:28","updated_at":"2026-03-05 22:58:45","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u6388\u6743\u65b0\u8d2dPOCN26018145-2026","collected":"57000","status_updated_at":"2026-01-27 10:12:49.184378+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 10:12:14.989444+08","forecast_updated_at":"2026-01-07 10:01:28.367137+08","end_at":"2026-03-12 17:01:51","pinyin_shortcut":"sxfxnhsqxgPOCN260181452026","creator":5300,"used_client":"","from_contact":"","total_contact_point":"7500","paid_contact_point":"","project_product_version_id":1320,"is_sales_order_ready":true,"collected_plan":"57000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4394,"from_project":4094,"serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN26018145"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"1706828","cost":"853414.000000000000","id":494,"erp_sales_outbound_id":133,"product_id":2238,"amount":"879808","number":"2","total_amount":"1759616","bargain_date":"2026-01-27","total_profit":"52788","total_profit_pct":"3.00","erpSalesOutbound":{"id":133,"serial_no":"XSCKD-20260203-00001","from_date":"","wrote_date":"2026-02-03","handler":1005,"erp_sales_order_id":1679,"client_id":3438,"project_id":4116,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u5229\u6da6\u7387\uff1a0.61%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u4e91\u98de","description":"\u987a\u4e30\u5feb\u9012\uff1aSF1532975839086","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-03 16:33:41","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"8","amount":"3837034","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-02-03 11:35:33","updated_at":"2026-02-03 16:33:41","print_times":1,"is_sales_order_ready":true,"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":2238,"name":"WS-S1-MD","product_type":19,"product_component":151,"product_brand":276,"product_serie":1765,"product_misc":"","product_qa":"","pn":"","description":"\u667a\u80fd\u6570\u5b57\u8d44\u4ea7\u7ba1\u7406\u7cfb\u7edf\u670d\u52a1","created_by":1013,"created_at":"2026-01-28 16:24:25","updated_at":"2026-02-03 16:33:41","pinyin_shortcut":"WSS1MD","product_unit":2,"is_renew":false,"in_out_at":"2026-02-03 16:33:41.58466+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":276,"key":276,"name":"\u4e2d\u535a\u6570\u667a"},"productSerie":{"id":1765,"key":1765,"name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"1183504","cost":"591752.000000000000","id":493,"erp_sales_outbound_id":133,"product_id":2237,"amount":"610054","number":"2","total_amount":"1220108","bargain_date":"2026-01-27","total_profit":"36604","total_profit_pct":"3.00","erpSalesOutbound":{"id":133,"serial_no":"XSCKD-20260203-00001","from_date":"","wrote_date":"2026-02-03","handler":1005,"erp_sales_order_id":1679,"client_id":3438,"project_id":4116,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u5229\u6da6\u7387\uff1a0.61%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u4e91\u98de","description":"\u987a\u4e30\u5feb\u9012\uff1aSF1532975839086","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-03 16:33:41","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"8","amount":"3837034","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-02-03 11:35:33","updated_at":"2026-02-03 16:33:41","print_times":1,"is_sales_order_ready":true,"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":2237,"name":"ZB-W8G40PXL","product_type":2,"product_component":226,"product_brand":276,"product_serie":1764,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-01-28 16:22:23","updated_at":"2026-02-03 16:33:41","pinyin_shortcut":"ZBW8G40PXL","product_unit":1,"is_renew":false,"in_out_at":"2026-02-03 16:33:41.58466+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":226,"key":226,"name":"\u667a\u7b97\u4e00\u4f53\u673a"},"productBrand":{"id":276,"key":276,"name":"\u4e2d\u535a\u6570\u667a"},"productSerie":{"id":1764,"key":1764,"name":"\u5168\u6db2\u51b7\u667a\u7b97\u4e00\u4f53\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"657704","cost":"328852.000000000000","id":496,"erp_sales_outbound_id":133,"product_id":2240,"amount":"339023","number":"2","total_amount":"678046","bargain_date":"2026-01-27","total_profit":"20342","total_profit_pct":"3.00","erpSalesOutbound":{"id":133,"serial_no":"XSCKD-20260203-00001","from_date":"","wrote_date":"2026-02-03","handler":1005,"erp_sales_order_id":1679,"client_id":3438,"project_id":4116,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u5229\u6da6\u7387\uff1a0.61%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u4e91\u98de","description":"\u987a\u4e30\u5feb\u9012\uff1aSF1532975839086","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-03 16:33:41","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"8","amount":"3837034","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-02-03 11:35:33","updated_at":"2026-02-03 16:33:41","print_times":1,"is_sales_order_ready":true,"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":2240,"name":"WS-S1-SNGIO","product_type":19,"product_component":151,"product_brand":276,"product_serie":1765,"product_misc":"","product_qa":"","pn":"","description":"\u4e09\u5e74\u539f\u5382\u4fdd\u4fee\uff0c\u5347\u7ea7,7*24\u5c0f\u65f6\u8fdc\u7a0b\u53caNBD\u7ea7\u4e0a\u95e8","created_by":1013,"created_at":"2026-01-28 16:25:51","updated_at":"2026-02-03 16:33:41","pinyin_shortcut":"WSS1SNGIO","product_unit":2,"is_renew":false,"in_out_at":"2026-02-03 16:33:41.58466+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":276,"key":276,"name":"\u4e2d\u535a\u6570\u667a"},"productSerie":{"id":1765,"key":1765,"name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"173886","cost":"86943.000000000000","id":495,"erp_sales_outbound_id":133,"product_id":2239,"amount":"89632","number":"2","total_amount":"179264","bargain_date":"2026-01-27","total_profit":"5378","total_profit_pct":"3.00","erpSalesOutbound":{"id":133,"serial_no":"XSCKD-20260203-00001","from_date":"","wrote_date":"2026-02-03","handler":1005,"erp_sales_order_id":1679,"client_id":3438,"project_id":4116,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u5229\u6da6\u7387\uff1a0.61%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u4e91\u98de","description":"\u987a\u4e30\u5feb\u9012\uff1aSF1532975839086","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-03 16:33:41","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"8","amount":"3837034","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-02-03 11:35:33","updated_at":"2026-02-03 16:33:41","print_times":1,"is_sales_order_ready":true,"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":2239,"name":"WS-S1-AIS","product_type":19,"product_component":151,"product_brand":276,"product_serie":1765,"product_misc":"","product_qa":"","pn":"","description":"\u7edf\u4e00\u5316\u6a21\u578b\u5b89\u88c5\u670d\u52a1\u5347\u7ea7","created_by":1013,"created_at":"2026-01-28 16:25:10","updated_at":"2026-02-03 16:33:41","pinyin_shortcut":"WSS1AIS","product_unit":2,"is_renew":false,"in_out_at":"2026-02-03 16:33:41.58466+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":276,"key":276,"name":"\u4e2d\u535a\u6570\u667a"},"productSerie":{"id":1765,"key":1765,"name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4116,"client_id":3438,"project_status":3,"project_progress":6,"budget":"3837034","profit_pct":"0.61","bargain_date":"2026-01-27","description":"","created_by":1005,"created_at":"2026-01-27 17:20:18","updated_at":"2026-02-06 17:15:32","engineer_id":"","project_title":"\u4e2d\u535a\u6570\u667a\u6db2\u51b7\u5de5\u4f5c\u7ad9-\u4e2d\u77f3\u5316","collected":"0","status_updated_at":"2026-01-27 17:22:47.009829+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-27 17:20:18.438458+08","forecast_updated_at":"2026-01-27 17:20:18.438458+08","end_at":"","pinyin_shortcut":"zbszylgzzzsh","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1318,"is_sales_order_ready":true,"collected_plan":"3837034","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3438,"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4396,"from_project":4116,"serial_no":"2026-01-27-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"32000","cost":"32000.000000000000","id":477,"erp_sales_outbound_id":130,"product_id":2236,"amount":"38900","number":"1","total_amount":"38900","bargain_date":"2026-01-26","total_profit":"6900","total_profit_pct":"17.74","erpSalesOutbound":{"id":130,"serial_no":"XSCKD-20260128-00003","from_date":"","wrote_date":"2026-01-28","handler":1005,"erp_sales_order_id":1677,"client_id":57,"project_id":4115,"erp_store_id":1,"status":2,"erp_send_type_id":2,"abstract":"\u5229\u6da6\u7387\uff1a24.46%\uff1b\u6536\u8d27\u4eba\uff1a\u5218\u5fd7\u534e","description":"\uff08\u7535\u6e90\u7ebf2\u6839+4\u6839SAS\u7ebf\uff09\u7ebf\u7f06\u7269\u6d41\uff1aSF1532975839031\n\u6269\u5c55\u67dc\u7269\u6d41\uff1aSF0255634788678","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-28 14:53:12","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"6","amount":"48000","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-28 13:46:48","updated_at":"2026-01-28 14:53:12","print_times":1,"is_sales_order_ready":true,"project":{"id":4115,"client_id":57,"project_status":3,"project_progress":6,"budget":"48000","profit_pct":"24.46","bargain_date":"2026-01-26","description":"","created_by":1005,"created_at":"2026-01-26 14:58:47","updated_at":"2026-03-18 13:21:42","engineer_id":"","project_title":"netapp\u5b58\u50a8\u6269\u5bb9","collected":"0","status_updated_at":"2026-01-26 15:00:05.050828+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-26 14:58:47.305685+08","forecast_updated_at":"2026-01-27 16:51:53.660487+08","end_at":"","pinyin_shortcut":"netappcckr","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1313,"is_sales_order_ready":true,"collected_plan":"48000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4393,"from_project":4115,"serial_no":"\u4fdd\u8bfa\u6c5f\u82cf\u8ba2\u5355CD2026012700012409"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":2236,"name":"DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","product_type":3,"product_component":17,"product_brand":6,"product_serie":1763,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-01-26 17:37:15","updated_at":"2026-01-28 14:53:12","pinyin_shortcut":"DS212C4TB6kyp","product_unit":1,"is_renew":false,"in_out_at":"2026-01-28 14:53:12.2659+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1763,"key":1763,"name":"Netapp DS212C\u6269\u5c55\u67dc"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"project":{"id":4115,"client_id":57,"project_status":3,"project_progress":6,"budget":"48000","profit_pct":"24.46","bargain_date":"2026-01-26","description":"","created_by":1005,"created_at":"2026-01-26 14:58:47","updated_at":"2026-03-18 13:21:42","engineer_id":"","project_title":"netapp\u5b58\u50a8\u6269\u5bb9","collected":"0","status_updated_at":"2026-01-26 15:00:05.050828+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-26 14:58:47.305685+08","forecast_updated_at":"2026-01-27 16:51:53.660487+08","end_at":"","pinyin_shortcut":"netappcckr","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1313,"is_sales_order_ready":true,"collected_plan":"48000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4393,"from_project":4115,"serial_no":"\u4fdd\u8bfa\u6c5f\u82cf\u8ba2\u5355CD2026012700012409"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"0","cost":"0.00000000000000000000","id":478,"erp_sales_outbound_id":130,"product_id":941,"amount":"7500","number":"1","total_amount":"7500","bargain_date":"2026-01-26","total_profit":"7500","total_profit_pct":"100.00","erpSalesOutbound":{"id":130,"serial_no":"XSCKD-20260128-00003","from_date":"","wrote_date":"2026-01-28","handler":1005,"erp_sales_order_id":1677,"client_id":57,"project_id":4115,"erp_store_id":1,"status":2,"erp_send_type_id":2,"abstract":"\u5229\u6da6\u7387\uff1a24.46%\uff1b\u6536\u8d27\u4eba\uff1a\u5218\u5fd7\u534e","description":"\uff08\u7535\u6e90\u7ebf2\u6839+4\u6839SAS\u7ebf\uff09\u7ebf\u7f06\u7269\u6d41\uff1aSF1532975839031\n\u6269\u5c55\u67dc\u7269\u6d41\uff1aSF0255634788678","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-28 14:53:12","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"6","amount":"48000","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-28 13:46:48","updated_at":"2026-01-28 14:53:12","print_times":1,"is_sales_order_ready":true,"project":{"id":4115,"client_id":57,"project_status":3,"project_progress":6,"budget":"48000","profit_pct":"24.46","bargain_date":"2026-01-26","description":"","created_by":1005,"created_at":"2026-01-26 14:58:47","updated_at":"2026-03-18 13:21:42","engineer_id":"","project_title":"netapp\u5b58\u50a8\u6269\u5bb9","collected":"0","status_updated_at":"2026-01-26 15:00:05.050828+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-26 14:58:47.305685+08","forecast_updated_at":"2026-01-27 16:51:53.660487+08","end_at":"","pinyin_shortcut":"netappcckr","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1313,"is_sales_order_ready":true,"collected_plan":"48000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4393,"from_project":4115,"serial_no":"\u4fdd\u8bfa\u6c5f\u82cf\u8ba2\u5355CD2026012700012409"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"project":{"id":4115,"client_id":57,"project_status":3,"project_progress":6,"budget":"48000","profit_pct":"24.46","bargain_date":"2026-01-26","description":"","created_by":1005,"created_at":"2026-01-26 14:58:47","updated_at":"2026-03-18 13:21:42","engineer_id":"","project_title":"netapp\u5b58\u50a8\u6269\u5bb9","collected":"0","status_updated_at":"2026-01-26 15:00:05.050828+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-26 14:58:47.305685+08","forecast_updated_at":"2026-01-27 16:51:53.660487+08","end_at":"","pinyin_shortcut":"netappcckr","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1313,"is_sales_order_ready":true,"collected_plan":"48000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4393,"from_project":4115,"serial_no":"\u4fdd\u8bfa\u6c5f\u82cf\u8ba2\u5355CD2026012700012409"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"1400","cost":"350.0000000000000000","id":476,"erp_sales_outbound_id":130,"product_id":2235,"amount":"400","number":"4","total_amount":"1600","bargain_date":"2026-01-26","total_profit":"200","total_profit_pct":"12.50","erpSalesOutbound":{"id":130,"serial_no":"XSCKD-20260128-00003","from_date":"","wrote_date":"2026-01-28","handler":1005,"erp_sales_order_id":1677,"client_id":57,"project_id":4115,"erp_store_id":1,"status":2,"erp_send_type_id":2,"abstract":"\u5229\u6da6\u7387\uff1a24.46%\uff1b\u6536\u8d27\u4eba\uff1a\u5218\u5fd7\u534e","description":"\uff08\u7535\u6e90\u7ebf2\u6839+4\u6839SAS\u7ebf\uff09\u7ebf\u7f06\u7269\u6d41\uff1aSF1532975839031\n\u6269\u5c55\u67dc\u7269\u6d41\uff1aSF0255634788678","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-28 14:53:12","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"6","amount":"48000","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-28 13:46:48","updated_at":"2026-01-28 14:53:12","print_times":1,"is_sales_order_ready":true,"project":{"id":4115,"client_id":57,"project_status":3,"project_progress":6,"budget":"48000","profit_pct":"24.46","bargain_date":"2026-01-26","description":"","created_by":1005,"created_at":"2026-01-26 14:58:47","updated_at":"2026-03-18 13:21:42","engineer_id":"","project_title":"netapp\u5b58\u50a8\u6269\u5bb9","collected":"0","status_updated_at":"2026-01-26 15:00:05.050828+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-26 14:58:47.305685+08","forecast_updated_at":"2026-01-27 16:51:53.660487+08","end_at":"","pinyin_shortcut":"netappcckr","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1313,"is_sales_order_ready":true,"collected_plan":"48000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4393,"from_project":4115,"serial_no":"\u4fdd\u8bfa\u6c5f\u82cf\u8ba2\u5355CD2026012700012409"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":2235,"name":"SAS Cable,12Gb,Mini SAS HD,2m,-C","product_type":3,"product_component":39,"product_brand":134,"product_serie":1762,"product_misc":"","product_qa":"","pn":"","description":"2M","created_by":1013,"created_at":"2026-01-26 17:34:09","updated_at":"2026-01-28 14:53:12","pinyin_shortcut":"SASCable12GbMiniSASHD2mC","product_unit":6,"is_renew":false,"in_out_at":"2026-01-28 14:53:12.2659+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1762,"key":1762,"name":"\u5b58\u50a8\u8fde\u63a5\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"project":{"id":4115,"client_id":57,"project_status":3,"project_progress":6,"budget":"48000","profit_pct":"24.46","bargain_date":"2026-01-26","description":"","created_by":1005,"created_at":"2026-01-26 14:58:47","updated_at":"2026-03-18 13:21:42","engineer_id":"","project_title":"netapp\u5b58\u50a8\u6269\u5bb9","collected":"0","status_updated_at":"2026-01-26 15:00:05.050828+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-26 14:58:47.305685+08","forecast_updated_at":"2026-01-27 16:51:53.660487+08","end_at":"","pinyin_shortcut":"netappcckr","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1313,"is_sales_order_ready":true,"collected_plan":"48000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"usedClient":"","buildContract":{"id":4393,"from_project":4115,"serial_no":"\u4fdd\u8bfa\u6c5f\u82cf\u8ba2\u5355CD2026012700012409"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"0","cost":"0.00000000000000000000","id":447,"erp_sales_outbound_id":124,"product_id":2171,"amount":"29800","number":"1","total_amount":"29800","bargain_date":"2026-01-22","total_profit":"29800","total_profit_pct":"100.00","erpSalesOutbound":{"id":124,"serial_no":"XSCKD-20260122-00001","from_date":"","wrote_date":"2026-01-22","handler":1001,"erp_sales_order_id":1675,"client_id":3435,"project_id":4111,"erp_store_id":1,"status":2,"erp_send_type_id":5,"abstract":"\u5229\u6da6\u7387\uff1a100%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u7389\u5c71","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-22 15:05:15","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"29800","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-22 13:34:43","updated_at":"2026-01-22 15:05:15","print_times":1,"is_sales_order_ready":true,"project":{"id":4111,"client_id":3435,"project_status":3,"project_progress":9,"budget":"29800","profit_pct":"93","bargain_date":"2026-01-22","description":"","created_by":1001,"created_at":"2026-01-22 11:53:00","updated_at":"2026-04-30 13:48:32","engineer_id":"","project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","collected":"29800","status_updated_at":"2026-01-22 12:17:04.022004+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-22 12:17:04.022004+08","forecast_updated_at":"2026-01-22 11:53:00.849244+08","end_at":"2026-04-01 10:09:20","pinyin_shortcut":"jcxERPrjytcgxm","creator":1011,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1307,"is_sales_order_ready":true,"collected_plan":"29800","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4388,"from_project":4111,"serial_no":"JCX-ZHY-2025110101"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_type":7,"product_component":159,"product_brand":270,"product_serie":1724,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-11-24 16:16:45","updated_at":"2026-06-23 13:48:49","pinyin_shortcut":"jcxCRMrjfw","product_unit":2,"is_renew":false,"in_out_at":"2026-06-23 13:48:49.894578+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":270,"key":270,"name":"\u91d1\u7545\u900d"},"productSerie":{"id":1724,"key":1724,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4111,"client_id":3435,"project_status":3,"project_progress":9,"budget":"29800","profit_pct":"93","bargain_date":"2026-01-22","description":"","created_by":1001,"created_at":"2026-01-22 11:53:00","updated_at":"2026-04-30 13:48:32","engineer_id":"","project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","collected":"29800","status_updated_at":"2026-01-22 12:17:04.022004+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-22 12:17:04.022004+08","forecast_updated_at":"2026-01-22 11:53:00.849244+08","end_at":"2026-04-01 10:09:20","pinyin_shortcut":"jcxERPrjytcgxm","creator":1011,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1307,"is_sales_order_ready":true,"collected_plan":"29800","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4388,"from_project":4111,"serial_no":"JCX-ZHY-2025110101"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"25138","cost":"12569.0000000000000000","id":461,"erp_sales_outbound_id":128,"product_id":1890,"amount":"13930","number":"2","total_amount":"27860","bargain_date":"2026-01-22","total_profit":"2722","total_profit_pct":"9.77","erpSalesOutbound":{"id":128,"serial_no":"XSCKD-20260128-00001","from_date":"","wrote_date":"2026-01-28","handler":1005,"erp_sales_order_id":1676,"client_id":3436,"project_id":4112,"erp_store_id":1,"status":2,"erp_send_type_id":5,"abstract":"\u5229\u6da6\u7387\uff1a6.5\uff05\uff1b\u6536\u8d27\u4eba\uff1a\u7406\u67cf\u6977","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-28 10:32:27","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"2","amount":"27860","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-28 09:41:19","updated_at":"2026-01-28 10:32:27","print_times":1,"is_sales_order_ready":true,"project":{"id":4112,"client_id":3436,"project_status":3,"project_progress":6,"budget":"201373.4","profit_pct":"15","bargain_date":"2026-01-22","description":"","created_by":1005,"created_at":"2026-01-22 17:29:05","updated_at":"2026-02-27 15:00:57","engineer_id":"","project_title":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","collected":"100686.7","status_updated_at":"2026-01-22 17:30:35.278042+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-22 17:29:05.896809+08","forecast_updated_at":"2026-01-22 17:29:05.896809+08","end_at":"","pinyin_shortcut":"hdjxxx26nxb","creator":1005,"used_client":"","from_contact":"","total_contact_point":"60000","paid_contact_point":"","project_product_version_id":1315,"is_sales_order_ready":false,"collected_plan":"201373.40","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4390,"from_project":4112,"serial_no":"TS-ZHY-20250122-01"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":1890,"name":"V-FDNVUL-0I-SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":61,"product_misc":"","product_qa":"","pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support.","created_by":1013,"created_at":"2024-12-10 11:30:30","updated_at":"2026-01-28 10:32:27","pinyin_shortcut":"VFDNVUL0ISU1YP00","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:27.441666+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":61,"key":61,"name":"Veeam \u865a\u62df\u5316\u5907\u4efd"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4112,"client_id":3436,"project_status":3,"project_progress":6,"budget":"201373.4","profit_pct":"15","bargain_date":"2026-01-22","description":"","created_by":1005,"created_at":"2026-01-22 17:29:05","updated_at":"2026-02-27 15:00:57","engineer_id":"","project_title":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u682126\u5e74\u7eed\u4fdd","collected":"100686.7","status_updated_at":"2026-01-22 17:30:35.278042+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-22 17:29:05.896809+08","forecast_updated_at":"2026-01-22 17:29:05.896809+08","end_at":"","pinyin_shortcut":"hdjxxx26nxb","creator":1005,"used_client":"","from_contact":"","total_contact_point":"60000","paid_contact_point":"","project_product_version_id":1315,"is_sales_order_ready":false,"collected_plan":"201373.40","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3436,"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"usedClient":"","buildContract":{"id":4390,"from_project":4112,"serial_no":"TS-ZHY-20250122-01"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"11827","cost":"11827.0000000000000000","id":479,"erp_sales_outbound_id":131,"product_id":1511,"amount":"29120.1","number":"1","total_amount":"29120.1","bargain_date":"2026-01-21","total_profit":"17293.1","total_profit_pct":"59.39","erpSalesOutbound":{"id":131,"serial_no":"XSCKD-20260130-00001","from_date":"","wrote_date":"2026-01-30","handler":5295,"erp_sales_order_id":1674,"client_id":107,"project_id":4101,"erp_store_id":1,"status":2,"erp_send_type_id":5,"abstract":"\u5229\u6da6\u7387\uff1a10.17\uff05\uff0c\u6536\u8d27\u4eba\uff1a\u9ec4\u5411\u8363\uff0c\u9ec4\u5411\u836320000\u79ef\u5206","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-30 13:24:39","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"2","amount":"58240.2","created_by":5360,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-30 09:15:26","updated_at":"2026-01-30 13:24:39","print_times":1,"is_sales_order_ready":true,"project":{"id":4101,"client_id":107,"project_status":3,"project_progress":9,"budget":"58240.2","profit_pct":"10.17","bargain_date":"2026-01-21","description":"","created_by":5295,"created_at":"2026-01-14 14:49:11","updated_at":"2026-02-27 15:01:39","engineer_id":"","project_title":"2026veeam\u7eed\u4fdd","collected":"58240.2","status_updated_at":"2026-01-21 16:41:15.92181+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 14:49:11.894549+08","forecast_updated_at":"2026-01-21 16:40:53.597536+08","end_at":"2026-02-03 09:32:56","pinyin_shortcut":"2026veeamxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"20000","paid_contact_point":"20000","project_product_version_id":1311,"is_sales_order_ready":true,"collected_plan":"58240.2","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4385,"from_project":4101,"serial_no":"TS-WZW-2026011601"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":"","product_qa":"","pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2026-01-30 13:24:39","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"in_out_at":"2026-01-30 13:24:39.260488+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4101,"client_id":107,"project_status":3,"project_progress":9,"budget":"58240.2","profit_pct":"10.17","bargain_date":"2026-01-21","description":"","created_by":5295,"created_at":"2026-01-14 14:49:11","updated_at":"2026-02-27 15:01:39","engineer_id":"","project_title":"2026veeam\u7eed\u4fdd","collected":"58240.2","status_updated_at":"2026-01-21 16:41:15.92181+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 14:49:11.894549+08","forecast_updated_at":"2026-01-21 16:40:53.597536+08","end_at":"2026-02-03 09:32:56","pinyin_shortcut":"2026veeamxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"20000","paid_contact_point":"20000","project_product_version_id":1311,"is_sales_order_ready":true,"collected_plan":"58240.2","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4385,"from_project":4101,"serial_no":"TS-WZW-2026011601"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"11827","cost":"11827.0000000000000000","id":480,"erp_sales_outbound_id":131,"product_id":1511,"amount":"29120.1","number":"1","total_amount":"29120.1","bargain_date":"2026-01-21","total_profit":"17293.1","total_profit_pct":"59.39","erpSalesOutbound":{"id":131,"serial_no":"XSCKD-20260130-00001","from_date":"","wrote_date":"2026-01-30","handler":5295,"erp_sales_order_id":1674,"client_id":107,"project_id":4101,"erp_store_id":1,"status":2,"erp_send_type_id":5,"abstract":"\u5229\u6da6\u7387\uff1a10.17\uff05\uff0c\u6536\u8d27\u4eba\uff1a\u9ec4\u5411\u8363\uff0c\u9ec4\u5411\u836320000\u79ef\u5206","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-30 13:24:39","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"2","amount":"58240.2","created_by":5360,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-30 09:15:26","updated_at":"2026-01-30 13:24:39","print_times":1,"is_sales_order_ready":true,"project":{"id":4101,"client_id":107,"project_status":3,"project_progress":9,"budget":"58240.2","profit_pct":"10.17","bargain_date":"2026-01-21","description":"","created_by":5295,"created_at":"2026-01-14 14:49:11","updated_at":"2026-02-27 15:01:39","engineer_id":"","project_title":"2026veeam\u7eed\u4fdd","collected":"58240.2","status_updated_at":"2026-01-21 16:41:15.92181+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 14:49:11.894549+08","forecast_updated_at":"2026-01-21 16:40:53.597536+08","end_at":"2026-02-03 09:32:56","pinyin_shortcut":"2026veeamxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"20000","paid_contact_point":"20000","project_product_version_id":1311,"is_sales_order_ready":true,"collected_plan":"58240.2","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4385,"from_project":4101,"serial_no":"TS-WZW-2026011601"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":"","product_qa":"","pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2026-01-30 13:24:39","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"in_out_at":"2026-01-30 13:24:39.260488+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4101,"client_id":107,"project_status":3,"project_progress":9,"budget":"58240.2","profit_pct":"10.17","bargain_date":"2026-01-21","description":"","created_by":5295,"created_at":"2026-01-14 14:49:11","updated_at":"2026-02-27 15:01:39","engineer_id":"","project_title":"2026veeam\u7eed\u4fdd","collected":"58240.2","status_updated_at":"2026-01-21 16:41:15.92181+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 14:49:11.894549+08","forecast_updated_at":"2026-01-21 16:40:53.597536+08","end_at":"2026-02-03 09:32:56","pinyin_shortcut":"2026veeamxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"20000","paid_contact_point":"20000","project_product_version_id":1311,"is_sales_order_ready":true,"collected_plan":"58240.2","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4385,"from_project":4101,"serial_no":"TS-WZW-2026011601"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"0","cost":"0.00000000000000000000","id":450,"erp_sales_outbound_id":126,"product_id":941,"amount":"30000","number":"1","total_amount":"30000","bargain_date":"2026-01-21","total_profit":"30000","total_profit_pct":"100.00","erpSalesOutbound":{"id":126,"serial_no":"XSCKD-20260123-00002","from_date":"","wrote_date":"2026-01-23","handler":5295,"erp_sales_order_id":1673,"client_id":107,"project_id":4100,"erp_store_id":1,"status":2,"erp_send_type_id":3,"abstract":"\u5229\u6da6\u7387\uff1a54.67%\uff1b\u6536\u8d27\u4eba\uff1a\u9ec4\u5411\u8363\uff1b\u9ec4\u5411\u8363\u79ef\u520610000","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-23 11:34:55","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"30000","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-23 11:04:25","updated_at":"2026-01-23 11:34:55","print_times":1,"is_sales_order_ready":true,"project":{"id":4100,"client_id":107,"project_status":3,"project_progress":9,"budget":"30000","profit_pct":"54.67","bargain_date":"2026-01-21","description":"","created_by":5295,"created_at":"2026-01-14 14:47:34","updated_at":"2026-02-11 08:56:42","engineer_id":"","project_title":"2026\u6280\u672f\u670d\u52a1","collected":"30000","status_updated_at":"2026-01-21 16:39:39.037258+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 14:47:34.419134+08","forecast_updated_at":"2026-01-19 14:17:00.865783+08","end_at":"2026-02-03 09:31:33","pinyin_shortcut":"2026jsfw","creator":5295,"used_client":"","from_contact":"","total_contact_point":"10000","paid_contact_point":"10000","project_product_version_id":1309,"is_sales_order_ready":true,"collected_plan":"30000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4386,"from_project":4100,"serial_no":"TS-WZW-2026011602"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"project":{"id":4100,"client_id":107,"project_status":3,"project_progress":9,"budget":"30000","profit_pct":"54.67","bargain_date":"2026-01-21","description":"","created_by":5295,"created_at":"2026-01-14 14:47:34","updated_at":"2026-02-11 08:56:42","engineer_id":"","project_title":"2026\u6280\u672f\u670d\u52a1","collected":"30000","status_updated_at":"2026-01-21 16:39:39.037258+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 14:47:34.419134+08","forecast_updated_at":"2026-01-19 14:17:00.865783+08","end_at":"2026-02-03 09:31:33","pinyin_shortcut":"2026jsfw","creator":5295,"used_client":"","from_contact":"","total_contact_point":"10000","paid_contact_point":"10000","project_product_version_id":1309,"is_sales_order_ready":true,"collected_plan":"30000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4386,"from_project":4100,"serial_no":"TS-WZW-2026011602"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"380","cost":"190.0000000000000000","id":445,"erp_sales_outbound_id":122,"product_id":984,"amount":"700","number":"2","total_amount":"1400","bargain_date":"2026-01-12","total_profit":"1020","total_profit_pct":"72.86","erpSalesOutbound":{"id":122,"serial_no":"XSCKD-20260112-00001","from_date":"","wrote_date":"2026-01-12","handler":1001,"erp_sales_order_id":1668,"client_id":2553,"project_id":4096,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u5229\u6da6\u7387\uff1a2%\uff1b\u6536\u8d27\u4eba\uff1a\u674e\u5b81\uff1bPA\u5382\u5546\u674e\u777f\u79ef\u5206723","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-12 16:41:06","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"2","amount":"1400","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-12 16:36:46","updated_at":"2026-01-12 16:41:06","print_times":1,"is_sales_order_ready":true,"project":{"id":4096,"client_id":2553,"project_status":3,"project_progress":9,"budget":"1400","profit_pct":"2","bargain_date":"2026-01-12","description":"","created_by":1001,"created_at":"2026-01-09 09:38:13","updated_at":"2026-01-19 14:25:54","engineer_id":"","project_title":"\u6a21\u5757\u91c7\u8d2d","collected":"0","status_updated_at":"2026-01-12 09:34:00.576713+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-09 09:38:13.359889+08","forecast_updated_at":"2026-01-09 09:38:13.359889+08","end_at":"","pinyin_shortcut":"mkcg","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"723","paid_contact_point":"","project_product_version_id":1182,"is_sales_order_ready":true,"collected_plan":"1400","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4373,"from_project":4096,"serial_no":"2026-01-12-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":984,"name":"PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","product_type":4,"product_component":43,"product_brand":8,"product_serie":612,"product_misc":"","product_qa":"","pn":"","description":"SFP form factor, LX 1Gb optical transceiver, 10Km reach, SMF, duplex LC, IEEE 802.3ab 1000BASE-LX compliant","created_by":1013,"created_at":"2023-08-09 15:26:41","updated_at":"2026-01-12 16:41:06","pinyin_shortcut":"PANSFPLXdsfmk","product_unit":3,"is_renew":false,"in_out_at":"2026-01-12 16:41:06.766587+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":612,"key":612,"name":"PAN-SFP-LX"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"project":{"id":4096,"client_id":2553,"project_status":3,"project_progress":9,"budget":"1400","profit_pct":"2","bargain_date":"2026-01-12","description":"","created_by":1001,"created_at":"2026-01-09 09:38:13","updated_at":"2026-01-19 14:25:54","engineer_id":"","project_title":"\u6a21\u5757\u91c7\u8d2d","collected":"0","status_updated_at":"2026-01-12 09:34:00.576713+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-09 09:38:13.359889+08","forecast_updated_at":"2026-01-09 09:38:13.359889+08","end_at":"","pinyin_shortcut":"mkcg","creator":1011,"used_client":"","from_contact":5957,"total_contact_point":"723","paid_contact_point":"","project_product_version_id":1182,"is_sales_order_ready":true,"collected_plan":"1400","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4373,"from_project":4096,"serial_no":"2026-01-12-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"0","cost":"0.00000000000000000000","id":446,"erp_sales_outbound_id":123,"product_id":941,"amount":"35800","number":"1","total_amount":"35800","bargain_date":"2026-01-08","total_profit":"35800","total_profit_pct":"100.00","erpSalesOutbound":{"id":123,"serial_no":"XSCKD-20260114-00001","from_date":"","wrote_date":"2026-01-14","handler":1005,"erp_sales_order_id":1669,"client_id":3336,"project_id":4102,"erp_store_id":1,"status":2,"erp_send_type_id":3,"abstract":"\u5229\u6da6\u7387\uff1a93%","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-14 17:51:55","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"35800","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-14 17:10:55","updated_at":"2026-01-14 17:51:55","print_times":1,"is_sales_order_ready":true,"project":{"id":4102,"client_id":3336,"project_status":3,"project_progress":6,"budget":"35800","profit_pct":"93","bargain_date":"2026-01-08","description":"","created_by":1005,"created_at":"2026-01-14 15:01:13","updated_at":"2026-01-19 14:27:30","engineer_id":"","project_title":"\u58f9\u8fdb\u523625\u5e74\u6280\u672f\u670d\u52a1\u8d39","collected":"35800","status_updated_at":"2026-01-14 15:02:03.286329+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 15:01:13.933531+08","forecast_updated_at":"2026-01-14 15:01:13.933531+08","end_at":"2026-02-06 13:39:15","pinyin_shortcut":"yjz25njsfwf","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1305,"is_sales_order_ready":true,"collected_plan":"35800","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3336,"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09"},"usedClient":"","buildContract":{"id":4377,"from_project":4102,"serial_no":"Unary-PO-2026010803"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"project":{"id":4102,"client_id":3336,"project_status":3,"project_progress":6,"budget":"35800","profit_pct":"93","bargain_date":"2026-01-08","description":"","created_by":1005,"created_at":"2026-01-14 15:01:13","updated_at":"2026-01-19 14:27:30","engineer_id":"","project_title":"\u58f9\u8fdb\u523625\u5e74\u6280\u672f\u670d\u52a1\u8d39","collected":"35800","status_updated_at":"2026-01-14 15:02:03.286329+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-14 15:01:13.933531+08","forecast_updated_at":"2026-01-14 15:01:13.933531+08","end_at":"2026-02-06 13:39:15","pinyin_shortcut":"yjz25njsfwf","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1305,"is_sales_order_ready":true,"collected_plan":"35800","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":3336,"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09"},"usedClient":"","buildContract":{"id":4377,"from_project":4102,"serial_no":"Unary-PO-2026010803"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"51526.61","cost":"51526.610000000000","id":507,"erp_sales_outbound_id":138,"product_id":1774,"amount":"63840","number":"1","total_amount":"63840","bargain_date":"2026-01-06","total_profit":"12313.39","total_profit_pct":"19.29","erpSalesOutbound":{"id":138,"serial_no":"XSCKD-20260209-00001","from_date":"","wrote_date":"2026-02-09","handler":5295,"erp_sales_order_id":1666,"client_id":3281,"project_id":4085,"erp_store_id":1,"status":2,"erp_send_type_id":5,"abstract":"\u5229\u6da6\u7387\uff1a14.78%\uff1b\u6536\u8d27\u4eba\uff1a\u9a86\u5609\u6728","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-02-09 10:24:03","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"63840","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-02-09 09:56:42","updated_at":"2026-02-09 10:24:03","print_times":1,"is_sales_order_ready":true,"project":{"id":4085,"client_id":3281,"project_status":3,"project_progress":9,"budget":"63840","profit_pct":"14.78","bargain_date":"2026-01-06","description":"","created_by":5295,"created_at":"2025-12-25 19:03:44","updated_at":"2026-03-03 21:15:31","engineer_id":"","project_title":"\u6269\u5bb9\u901f\u77f3\u5b58\u50a8\u8d44\u6e90","collected":"63840","status_updated_at":"2026-01-06 10:39:27.915498+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-12-25 19:03:44.102208+08","forecast_updated_at":"2025-12-25 19:03:44.102208+08","end_at":"2026-03-10 10:55:07","pinyin_shortcut":"krsscczy","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1157,"is_sales_order_ready":true,"collected_plan":"63840","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8(EDA)"},"usedClient":"","buildContract":{"id":4364,"from_project":4085,"serial_no":"TS-WZW-2025082602"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","product_type":22,"product_component":205,"product_brand":219,"product_serie":1500,"product_misc":"","product_qa":"","pn":"","description":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248\uff0cFastone Compute Cloud-Enterprise Edition (\u4ee5\u4e0b\u7b80\u79f0FCC-E)\u4e91\u670d\u52a1","created_by":1013,"created_at":"2024-09-02 15:13:25","updated_at":"2026-02-09 10:24:03","pinyin_shortcut":"ssjsyfwqyb","product_unit":2,"is_renew":false,"in_out_at":"2026-02-09 10:24:03.403451+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1500,"key":1500,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4085,"client_id":3281,"project_status":3,"project_progress":9,"budget":"63840","profit_pct":"14.78","bargain_date":"2026-01-06","description":"","created_by":5295,"created_at":"2025-12-25 19:03:44","updated_at":"2026-03-03 21:15:31","engineer_id":"","project_title":"\u6269\u5bb9\u901f\u77f3\u5b58\u50a8\u8d44\u6e90","collected":"63840","status_updated_at":"2026-01-06 10:39:27.915498+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-12-25 19:03:44.102208+08","forecast_updated_at":"2025-12-25 19:03:44.102208+08","end_at":"2026-03-10 10:55:07","pinyin_shortcut":"krsscczy","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1157,"is_sales_order_ready":true,"collected_plan":"63840","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"}},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8(EDA)"},"usedClient":"","buildContract":{"id":4364,"from_project":4085,"serial_no":"TS-WZW-2025082602"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"197","cost":"197.0000000000000000","id":442,"erp_sales_outbound_id":120,"product_id":2224,"amount":"300","number":"1","total_amount":"300","bargain_date":"2026-01-06","total_profit":"103","total_profit_pct":"34.33","erpSalesOutbound":{"id":120,"serial_no":"XSCKD-20260106-00003","from_date":"","wrote_date":"2026-01-06","handler":1005,"erp_sales_order_id":1667,"client_id":918,"project_id":4093,"erp_store_id":1,"status":2,"erp_send_type_id":3,"abstract":"\u5229\u6da6\u7387\uff1a27.87%\uff1b\u6536\u8d27\u4eba\uff1a\u6613\u65b0\u5e73","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-06 14:40:33","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"1","amount":"300","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-06 13:29:09","updated_at":"2026-01-06 14:40:33","print_times":1,"is_sales_order_ready":true,"project":{"id":4093,"client_id":918,"project_status":3,"project_progress":49,"budget":"300","profit_pct":"27.87","bargain_date":"2026-01-06","description":"","created_by":1005,"created_at":"2026-01-06 10:30:01","updated_at":"2026-01-29 14:15:21","engineer_id":"","project_title":"\u65b0\u8d2d\u53cd\u6e17\u900f\u819c","collected":"300","status_updated_at":"2026-01-21 16:29:03.090158+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-21 16:29:03.090158+08","forecast_updated_at":"2026-01-21 16:29:03.090158+08","end_at":"2026-03-20 15:20:58","pinyin_shortcut":"xgfstm","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1155,"is_sales_order_ready":true,"collected_plan":"300","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4366,"from_project":4093,"serial_no":"2026-01-06-003"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":2224,"name":"HID-600RO RO\u53cd\u6e17\u900f\u819c","product_type":18,"product_component":225,"product_brand":274,"product_serie":1753,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-01-04 09:49:03","updated_at":"2026-01-06 14:40:33","pinyin_shortcut":"HID600ROROfstm","product_unit":3,"is_renew":false,"in_out_at":"2026-01-06 14:40:33.633878+08","productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":225,"key":225,"name":"\u7eaf\u6c34\u673a"},"productBrand":{"id":274,"key":274,"name":"\u60e0\u7075\u987f"},"productSerie":{"id":1753,"key":1753,"name":"\u7eaf\u6c34\u673a\u914d\u4ef6"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"project":{"id":4093,"client_id":918,"project_status":3,"project_progress":49,"budget":"300","profit_pct":"27.87","bargain_date":"2026-01-06","description":"","created_by":1005,"created_at":"2026-01-06 10:30:01","updated_at":"2026-01-29 14:15:21","engineer_id":"","project_title":"\u65b0\u8d2d\u53cd\u6e17\u900f\u819c","collected":"300","status_updated_at":"2026-01-21 16:29:03.090158+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-21 16:29:03.090158+08","forecast_updated_at":"2026-01-21 16:29:03.090158+08","end_at":"2026-03-20 15:20:58","pinyin_shortcut":"xgfstm","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1155,"is_sales_order_ready":true,"collected_plan":"300","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4366,"from_project":4093,"serial_no":"2026-01-06-003"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},{"total_cost":"14400","cost":"120.0000000000000000","id":444,"erp_sales_outbound_id":121,"product_id":1007,"amount":"238","number":"120","total_amount":"28560","bargain_date":"2026-01-05","total_profit":"14160","total_profit_pct":"49.58","erpSalesOutbound":{"id":121,"serial_no":"XSCKD-20260106-00004","from_date":"","wrote_date":"2026-01-06","handler":5087,"erp_sales_order_id":1663,"client_id":2136,"project_id":4089,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u5229\u6da6\u7387\uff1a41.13%\uff1b\u6536\u8d27\u4eba\uff1a\u674e\u5b66\u6885","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-07 14:56:44","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"120","amount":"28560","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-06 13:34:44","updated_at":"2026-01-07 14:56:44","print_times":1,"is_sales_order_ready":true,"project":{"id":4089,"client_id":2136,"project_status":3,"project_progress":9,"budget":"28560","profit_pct":"41.13","bargain_date":"2026-01-05","description":"","created_by":5087,"created_at":"2026-01-05 00:33:38","updated_at":"2026-03-22 19:51:51","engineer_id":"","project_title":"\u6d89\u5bc6\u8ba1\u7b97\u673a\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\u5ba2\u6237\u7aef\u6388\u6743\u70b9-2026","collected":"0","status_updated_at":"2026-01-11 20:44:05.444982+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-11 20:44:05.444982+08","forecast_updated_at":"2026-01-11 20:44:05.444982+08","end_at":"","pinyin_shortcut":"smjsjbmglxtkhdsqd2026","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1153,"is_sales_order_ready":true,"collected_plan":"28560","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"usedClient":"","buildContract":{"id":4359,"from_project":4089,"serial_no":"2026-01-05-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},"product":{"id":1007,"name":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","product_type":7,"product_component":162,"product_brand":147,"product_serie":1263,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-22 17:00:21","updated_at":"2026-01-07 14:56:44","pinyin_shortcut":"zfsmjsjjydccjzbmglxt","product_unit":2,"is_renew":false,"in_out_at":"2026-01-07 14:56:44.699071+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":162,"key":162,"name":"\u6d89\u5bc6\u7cfb\u7edf\u8f6f\u4ef6"},"productBrand":{"id":147,"key":147,"name":"\u4e2d\u5b5a"},"productSerie":{"id":1263,"key":1263,"name":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"project":{"id":4089,"client_id":2136,"project_status":3,"project_progress":9,"budget":"28560","profit_pct":"41.13","bargain_date":"2026-01-05","description":"","created_by":5087,"created_at":"2026-01-05 00:33:38","updated_at":"2026-03-22 19:51:51","engineer_id":"","project_title":"\u6d89\u5bc6\u8ba1\u7b97\u673a\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\u5ba2\u6237\u7aef\u6388\u6743\u70b9-2026","collected":"0","status_updated_at":"2026-01-11 20:44:05.444982+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-11 20:44:05.444982+08","forecast_updated_at":"2026-01-11 20:44:05.444982+08","end_at":"","pinyin_shortcut":"smjsjbmglxtkhdsqd2026","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1153,"is_sales_order_ready":true,"collected_plan":"28560","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"usedClient":"","buildContract":{"id":4359,"from_project":4089,"serial_no":"2026-01-05-001"},"project_status_display":"\u5546\u673a\u6210\u4ea4"}},{"total_cost":"520","cost":"260.0000000000000000","id":440,"erp_sales_outbound_id":118,"product_id":41,"amount":"1000","number":"2","total_amount":"2000","bargain_date":"2026-01-05","total_profit":"1480","total_profit_pct":"74.00","erpSalesOutbound":{"id":118,"serial_no":"XSCKD-20260106-00001","from_date":"","wrote_date":"2026-01-06","handler":1004,"erp_sales_order_id":1664,"client_id":48,"project_id":4090,"erp_store_id":1,"status":2,"erp_send_type_id":3,"abstract":"\u5229\u6da6\u7387\uff1a62.38\uff05\uff1b\u6536\u8d27\u4eba\uff1a\u5434\u709c\u6770","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-01-06 11:47:31","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"2","amount":"2000","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2026-01-06 10:42:04","updated_at":"2026-01-06 11:47:31","print_times":1,"is_sales_order_ready":true,"project":{"id":4090,"client_id":48,"project_status":3,"project_progress":6,"budget":"2000","profit_pct":"62.38","bargain_date":"2026-01-05","description":"","created_by":1004,"created_at":"2026-01-05 09:50:46","updated_at":"2026-01-12 14:50:57","engineer_id":"","project_title":"2016\u5b58\u50a8\u786c\u76d8","collected":"2000","status_updated_at":"2026-01-05 15:32:06.287761+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-05 09:50:46.170745+08","forecast_updated_at":"2026-01-05 09:50:46.170745+08","end_at":"2026-01-22 16:25:03","pinyin_shortcut":"2016ccyp","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1152,"is_sales_order_ready":true,"collected_plan":"2000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4360,"from_project":4090,"serial_no":"TS-YJC-202601"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}},"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"project":{"id":4090,"client_id":48,"project_status":3,"project_progress":6,"budget":"2000","profit_pct":"62.38","bargain_date":"2026-01-05","description":"","created_by":1004,"created_at":"2026-01-05 09:50:46","updated_at":"2026-01-12 14:50:57","engineer_id":"","project_title":"2016\u5b58\u50a8\u786c\u76d8","collected":"2000","status_updated_at":"2026-01-05 15:32:06.287761+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2026-01-05 09:50:46.170745+08","forecast_updated_at":"2026-01-05 09:50:46.170745+08","end_at":"2026-01-22 16:25:03","pinyin_shortcut":"2016ccyp","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1152,"is_sales_order_ready":true,"collected_plan":"2000","change_status_to":"","is_verify":false,"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"salesGroup":{"id":80,"key":80,"name":"\u5408\u4f19\u4eba"}},"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"usedClient":"","buildContract":{"id":4360,"from_project":4090,"serial_no":"TS-YJC-202601"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210"}}],"countArr":{"budget":"196909766.2","cost":"5430960.235","profits":"191478805.965","profit_pct":"97.24"},"pagenation":{"totalcount":59,"thispage":3,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 17:48:10', 63572736) RETURNING "id"
17:48:10.2781.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (48, 3281, 2136, 3336, 12, 2553, 107, 918, 3438, 57, 3436, 3435)
17:48:10.2730.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4111, 4096, 4100, 4115, 4101, 4102, 4116, 4094, 4085, 4112, 4089, 4093, 4090)
17:48:10.2290.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:48:10.2720.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id" IN (135, 133, 130, 124, 128, 131, 126, 122, 123, 138, 120, 121, 118)
17:48:10.2790.7 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4090, 4085, 4089, 4102, 4094, 4096, 4101, 4100, 4093, 4116, 4115, 4112, 4111)
17:48:10.2310.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:48:10.2800.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1528, 2238, 2237, 2240, 2239, 2236, 941, 2235, 2171, 1890, 1511, 984, 1774, 2224, 1007, 41)
17:48:10.2750.5 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
17:48:10.2760.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5295, 5087, 1005, 5300, 1001)
17:48:10.2330.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:10.2770.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id" IN (5295, 5087, 1004, 1005, 5300, 1001)
17:48:10.2840.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 7, 2, 1, 3, 6)
17:48:10.2840.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1015, 592, 1500, 1763, 1753, 1764, 61, 1263, 1724, 1240, 612, 1762, 1765, 525)
17:48:10.2780.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id" IN (1, 80)
17:48:10.2820.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (3, 19, 22, 18, 2, 7, 4)
17:48:10.2820.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (15, 151, 205, 17, 225, 226, 30, 162, 159, 43, 39, 29)
17:48:10.2290.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:48:10.2830.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (6, 133, 219, 274, 276, 16, 147, 270, 8, 134, 12)