Performance Profiling

Total processing time: 166 ms; Peak memory: 7.298 MB. Show Profiling Timeline

总计77条数据

Time	Duration	Category	Info

10:14:59.427	19.4 ms	yii\db\Command::query	SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)) GROUP BY "object_id"
10:14:59.508	17.8 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)) GROUP BY "object_id"
10:14:59.411	10.8 ms	yii\db\Command::query	SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND ("client"."sales_rep"='5087') AND ("client"."sales_rep"='5087') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
10:14:59.401	10.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT c., abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND ("client"."sales_rep"='5087') AND ("client"."sales_rep"='5087') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
10:14:59.544	4.6 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1161, 'v2/sales-contract/list', '{"Filter":{"name":"","sort":""},"SalesContractSearch":{"contract_type":"","handler":"5087"},"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","page":"1","posttime":"1784081664","token":"24f67e8d6ade1192451ee9516e4a9a2d","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":4496,"client_id":2130,"signed_at":"2026-06-05","amount":"20000000","handler":5087,"description":"","created_by":5087,"created_at":"2026-06-05 11:14:46","updated_at":"2026-06-05 11:14:46","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3957,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-006","payment_collection_remind_ahead":"1 day","from_project":3957,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2026-06-05 11:20:29","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"20000000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":true,"b_date":null,"passed":1,"client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":null,"project":{"id":3957,"key":3957,"name":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","erpSalesOrder":null},"erpSalesOrder":{"id":1717,"serial_no":"XSDD-20260605-00006","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2130,"purchase_contract_id":null,"project_id":3957,"sales_contract_id":4496,"erp_store_id":null,"status":7,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":1001,"verify_at":"2026-06-05 11:14:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"20000000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:14:07","updated_at":"2026-06-05 11:20:29","print_times":null,"erpSalesOrderVerifyRels":[{"id":146,"erp_sales_order_id":1717,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-05 11:14:46","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[{"id":5,"erp_sales_order_id":1717,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},"fromProject":{"id":3957,"key":3957,"name":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","description":null,"total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":null,"bargain_date":"2026-06-05","collected":"0","profit_pct":"20","budget":"20000000","erpSalesOrder":null,"projectProductTypes":[{"id":8633,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"20000000","pct":"20","project_id":3957,"profit":"4000000"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":4000000,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10163,"user_id":1001,"key":1001,"contract_id":4496,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":10164,"user_id":5087,"key":5087,"contract_id":4496,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":null,"un_invoiced":20000000,"collected":"0","un_collected":20000000,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":20000000,"can_view_verify_list":true,"verifyList":[{"id":5,"erp_sales_order_id":1717,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4492,"client_id":2125,"signed_at":"2026-06-05","amount":"790000","handler":5087,"description":"","created_by":5087,"created_at":"2026-06-05 11:12:45","updated_at":"2026-07-10 09:27:30","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3796,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-002","payment_collection_remind_ahead":"1 day","from_project":3796,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2026-06-05 11:12:45","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"790000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4492,"comment":1},"project":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","erpSalesOrder":{"id":1716,"serial_no":"XSDD-20260605-00005","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2125,"purchase_contract_id":null,"project_id":3796,"sales_contract_id":4492,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-06-05 11:12:45","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"790000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:11:50","updated_at":"2026-06-05 11:12:45","print_times":null,"erpSalesOrderVerifyRels":[{"id":145,"erp_sales_order_id":1716,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-05 11:12:45"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1716,"serial_no":"XSDD-20260605-00005","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2125,"purchase_contract_id":null,"project_id":3796,"sales_contract_id":4492,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-06-05 11:12:45","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"790000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:11:50","updated_at":"2026-06-05 11:12:45","print_times":null,"erpSalesOrderVerifyRels":[{"id":145,"erp_sales_order_id":1716,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-05 11:12:45","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","description":null,"total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":null,"bargain_date":"2026-06-05","collected":"0","profit_pct":"25","budget":"790000","erpSalesOrder":{"id":1716,"serial_no":"XSDD-20260605-00005","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2125,"purchase_contract_id":null,"project_id":3796,"sales_contract_id":4492,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-06-05 11:12:45","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"790000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:11:50","updated_at":"2026-06-05 11:12:45","print_times":null},"projectProductTypes":[{"id":8629,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"790000.00","pct":"25","project_id":3796,"profit":"197500"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3796,"sum":"215.95"},"profit":197500,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10154,"user_id":5087,"key":5087,"contract_id":4492,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":57728,"object_type":105,"object_id":4492,"attachment_id":32759,"attachment":{"id":32759,"key":32759,"name":"47d5d9af-2d3a-35f1-bb66-c62eb041bac5","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/47d5d9af-2d3a-35f1-bb66-c62eb041bac5\/9988.pdf","orig_name":"9988.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":null,"un_invoiced":790000,"collected":"0","un_collected":790000,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":790000,"can_view_verify_list":true,"verifyList":[{"id":145,"erp_sales_order_id":1716,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-05 11:12:45","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4491,"client_id":2128,"signed_at":"2026-06-05","amount":"977642823","handler":5087,"description":"","created_by":5087,"created_at":"2026-06-05 11:10:13","updated_at":"2026-07-10 09:28:21","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3854,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"2026-06-05-001","payment_collection_remind_ahead":"1 day","from_project":3854,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2026-06-05 11:10:13","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"977642823","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4491,"comment":1},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","erpSalesOrder":{"id":1715,"serial_no":"XSDD-20260605-00004","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3854,"sales_contract_id":4491,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-06-05 11:10:13","stop_at":"2026-07-04 21:37:36.455893+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"26","amount":"977642823","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:10:13","updated_at":"2026-07-04 21:37:36","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1715,"serial_no":"XSDD-20260605-00004","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3854,"sales_contract_id":4491,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-06-05 11:10:13","stop_at":"2026-07-04 21:37:36.455893+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"26","amount":"977642823","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:10:13","updated_at":"2026-07-04 21:37:36","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":1381,"bargain_date":"2026-06-05","collected":"0","profit_pct":"25","budget":"977642823","erpSalesOrder":{"id":1715,"serial_no":"XSDD-20260605-00004","from_date":null,"wrote_date":"2026-06-05","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3854,"sales_contract_id":4491,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-06-05 11:10:13","stop_at":"2026-07-04 21:37:36.455893+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"26","amount":"977642823","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 11:10:13","updated_at":"2026-07-04 21:37:36","print_times":null},"projectProductTypes":[{"id":8647,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"977589191","pct":"25","project_id":3854,"profit":"244397297.75"},{"id":8648,"product_type_id":23,"key":23,"name":"\u793c\u54c1","budget":"53588","pct":"25","project_id":3854,"profit":"13397"},{"id":8649,"product_type_id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907","budget":"44","pct":"25","project_id":3854,"profit":"11"}],"projectProductRels":[{"id":12150,"project_id":3854,"product_id":2261,"amount":"44433443","number":22,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"977535746","total_cost":null,"erp_sales_order_product_id":2251,"supplier":null,"product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":null,"product_qa":null,"pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-10 11:35:44","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-10 11:35:44.60456+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2251,"erp_sales_order_id":1715,"erp_store_id":null,"product_id":2261,"description":"","number":"22","outbound":"4","amount":"44433443","total_amount":"977535746","last_number":"22","last_amount":"44433443","last_total_amount":"977535746","cost":"45","total_cost":"45","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12151,"project_id":3854,"product_id":1372,"amount":"53445","number":1,"cost":"25","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"53445","total_cost":"25","erp_sales_order_product_id":2252,"supplier":null,"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-13 17:48:11","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-13 17:48:11.473057+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":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":2252,"erp_sales_order_id":1715,"erp_store_id":null,"product_id":1372,"description":"","number":"1","outbound":"1","amount":"53445","total_amount":"53445","last_number":"1","last_amount":"53445","last_total_amount":"53445","cost":"25","total_cost":"25","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12152,"project_id":3854,"product_id":2265,"amount":"53534","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"53534","total_cost":null,"erp_sales_order_product_id":2253,"supplier":null,"product":{"id":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:34:40","updated_at":"2026-07-10 11:34:39","pinyin_shortcut":"olwlOlivoilagly500MLx2jxlh","product_unit":9,"is_renew":false,"in_out_at":"2026-07-10 11:34:39.019714+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":284,"key":284,"name":"\u6b27\u4e3d\u8587\u5170"},"productSerie":{"id":1775,"key":1775,"name":"\u98df\u7528\u6cb9"},"productUnit":{"id":9,"key":9,"name":"\u76d2"}},"erpSalesOrderProduct":{"id":2253,"erp_sales_order_id":1715,"erp_store_id":null,"product_id":2265,"description":"","number":"1","outbound":"0","amount":"53534","total_amount":"53534","last_number":"1","last_amount":"53534","last_total_amount":"53534","cost":null,"total_cost":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12153,"project_id":3854,"product_id":2263,"amount":"44","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"44","total_cost":null,"erp_sales_order_product_id":2254,"supplier":null,"product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2254,"erp_sales_order_id":1715,"erp_store_id":null,"product_id":2263,"description":"","number":"1","outbound":"0","amount":"44","total_amount":"44","last_number":"1","last_amount":"44","last_total_amount":"44","cost":null,"total_cost":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12154,"project_id":3854,"product_id":2266,"amount":"54","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"54","total_cost":null,"erp_sales_order_product_id":2255,"supplier":null,"product":{"id":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_type":23,"product_component":221,"product_brand":286,"product_serie":1783,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:38:56","updated_at":"2026-06-08 18:13:58","pinyin_shortcut":"sxddtxdxfhminibxkCM20","product_unit":3,"is_renew":false,"in_out_at":"2026-06-08 18:13:58.834274+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":286,"key":286,"name":"\u677e\u4e0b"},"productSerie":{"id":1783,"key":1783,"name":"\u7535\u52a8\u5243\u987b\u5200"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2255,"erp_sales_order_id":1715,"erp_store_id":null,"product_id":2266,"description":"","number":"1","outbound":"0","amount":"54","total_amount":"54","last_number":"1","last_amount":"54","last_total_amount":"54","cost":null,"total_cost":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3854,"sum":"194.66"},"profit":244410705.75,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4218,"contract_id":4491,"supplier_id":431,"purchase_id":4502,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchase":{"id":4502,"key":4502,"serial_no":"\u6d4b\u8bd5\u9500\u552e\u8ba2\u5355\u51fa\u5e93\u7edf\u8ba1"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10175,"user_id":5087,"key":5087,"contract_id":4491,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":57729,"object_type":105,"object_id":4491,"attachment_id":32760,"attachment":{"id":32760,"key":32760,"name":"e1b414b3-f111-30e4-ac51-435400efd14a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e1b414b3-f111-30e4-ac51-435400efd14a\/9988.pdf","orig_name":"9988.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":977642823,"projectProductAllAmount":true,"projectProductTotalCost":25,"projectProductAllCost":false,"projectProductTotalCount":26,"invoiced":null,"un_invoiced":977642823,"collected":"0","un_collected":977642823,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":977642823,"can_view_verify_list":true,"verifyList":[]},{"id":4483,"client_id":2128,"signed_at":"2026-05-27","amount":"0","handler":5087,"description":"","created_by":5250,"created_at":"2026-05-27 19:24:26","updated_at":"2026-05-27 19:24:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":null,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":null,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":false,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":null,"project":null,"erpSalesOrder":null,"fromProject":null,"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":null,"un_invoiced":0,"collected":"0","un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"can_view_verify_list":true,"verifyList":[]},{"id":4414,"client_id":3443,"signed_at":"2026-02-05","amount":"10000","handler":5087,"description":"","created_by":5087,"created_at":"2026-02-05 15:59:00","updated_at":"2026-02-06 17:14:46","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4119,"valid_date":null,"expire_date":"2026-02-05","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TSC-LW-20260205","payment_collection_remind_ahead":"1 day","from_project":4119,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2026-02-05 15:59:00","is_verify":false,"is_draft":true,"erp_settle_amount":"10000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"10000","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":160,"passed":2,"client":{"id":3443,"key":3443,"name":"\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4414,"comment":6},"project":{"id":4119,"key":4119,"name":"\u7532\u9aa8\u6587\u6570\u636e\u5e93\u4fee\u590d","erpSalesOrder":{"id":1683,"serial_no":"XSDD-20260205-00001","from_date":null,"wrote_date":"2026-02-05","handler":5087,"client_id":3443,"purchase_contract_id":null,"project_id":4119,"sales_contract_id":4414,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-02-05 15:58:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"10000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-02-28\",\"amount\":\"10000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-02-05 15:51:22","updated_at":"2026-02-05 15:58:59","print_times":null,"erpSalesOrderVerifyRels":[{"id":121,"erp_sales_order_id":1683,"user_id":1001,"status":1,"description":null,"verify_at":"2026-02-05 15:58:59"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1683,"serial_no":"XSDD-20260205-00001","from_date":null,"wrote_date":"2026-02-05","handler":5087,"client_id":3443,"purchase_contract_id":null,"project_id":4119,"sales_contract_id":4414,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-02-05 15:58:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"10000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-02-28\",\"amount\":\"10000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-02-05 15:51:22","updated_at":"2026-02-05 15:58:59","print_times":null,"erpSalesOrderVerifyRels":[{"id":121,"erp_sales_order_id":1683,"user_id":1001,"status":1,"description":null,"verify_at":"2026-02-05 15:58:59","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4119,"key":4119,"name":"\u7532\u9aa8\u6587\u6570\u636e\u5e93\u4fee\u590d","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1322,"bargain_date":"2026-02-05","collected":"10000","profit_pct":"93","budget":"10000","erpSalesOrder":{"id":1683,"serial_no":"XSDD-20260205-00001","from_date":null,"wrote_date":"2026-02-05","handler":5087,"client_id":3443,"purchase_contract_id":null,"project_id":4119,"sales_contract_id":4414,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-02-05 15:58:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"10000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-02-28\",\"amount\":\"10000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-02-05 15:51:22","updated_at":"2026-02-05 15:58:59","print_times":null},"projectProductTypes":[{"id":8395,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"10000","pct":"93","project_id":4119,"profit":"9300"}],"projectProductRels":[{"id":11980,"project_id":4119,"product_id":941,"amount":"10000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"10000","total_cost":"0","erp_sales_order_product_id":2191,"supplier":null,"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":null,"product_qa":null,"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"}},"erpSalesOrderProduct":{"id":2191,"erp_sales_order_id":1683,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"1","amount":"10000","total_amount":"10000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13921,"project_id":4119}],"reimbursementAmountSum":null,"profit":9300,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8822,"user_id":5087,"key":5087,"contract_id":4414,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10039,"user_id":5087,"key":5087,"contract_id":4414,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2750,"key":2750,"contract_id":4414,"name":"2026-02-28","value":"10000","overdue_days":null,"status":1,"remind_date":"2026-02-28","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"12174","key":"12174","contract_id":4414,"value":"10000","created_by":1013,"created_at":"2026-02-09 14:44:06","description":null,"collected_date":"2026-02-09 00:00:00","amount":"10000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2306,"key":2306,"contract_id":4414,"value":"10000","attachment_id":null,"from_date":"2026-02-06","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":1188,"sales_invoice_id":2306,"amount":"10000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":56371,"object_type":102,"object_id":2306,"attachment_id":31862,"attachment":{"id":31862,"key":31862,"name":"f4592333-b42b-3717-9681-9af0887d266f","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f4592333-b42b-3717-9681-9af0887d266f\/dzfp_26112000000505025521_\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8_20260206172451.pdf","orig_name":"dzfp_26112000000505025521_\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8_20260206172451.pdf"}}]}],"contractScans":[{"id":56364,"object_type":105,"object_id":4414,"attachment_id":31833,"attachment":{"id":31833,"key":31833,"name":"b01239fd-3b14-32c9-855d-8ac3e2e22e3f","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b01239fd-3b14-32c9-855d-8ac3e2e22e3f\/2026_02_06_09_30_29.pdf","orig_name":"2026_02_06_09_30_29.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":10000,"projectProductTotalAmount":10000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":"10000","un_invoiced":0,"collected":"10000","un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"can_view_verify_list":true,"verifyList":[{"id":121,"erp_sales_order_id":1683,"user_id":1001,"status":1,"description":null,"verify_at":"2026-02-05 15:58:59","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4408,"client_id":2526,"signed_at":"2026-02-02","amount":"3000","handler":5087,"description":"","created_by":5087,"created_at":"2026-02-02 16:25:57","updated_at":"2026-02-06 17:15:04","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4118,"valid_date":null,"expire_date":"2029-02-05","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"2026-02-02-001","payment_collection_remind_ahead":"30 days","from_project":4118,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2026-02-02 16:25:58","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"3000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":936,"passed":2,"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4408,"comment":2},"project":{"id":4118,"key":4118,"name":"\u4e2d\u5b5a\u591a\u529f\u80fd\u5012\u5165\u88c5\u7f6e\u91c7\u8d2d","erpSalesOrder":{"id":1682,"serial_no":"XSDD-20260202-00001","from_date":null,"wrote_date":"2026-02-02","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4118,"sales_contract_id":4408,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-02-02 16:25:57","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"3000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"30 days\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"3000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-02-02 16:25:34","updated_at":"2026-02-02 16:25:57","print_times":null,"erpSalesOrderVerifyRels":[{"id":120,"erp_sales_order_id":1682,"user_id":1001,"status":1,"description":null,"verify_at":"2026-02-02 16:25:57"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1682,"serial_no":"XSDD-20260202-00001","from_date":null,"wrote_date":"2026-02-02","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4118,"sales_contract_id":4408,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-02-02 16:25:57","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"3000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"30 days\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"3000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-02-02 16:25:34","updated_at":"2026-02-02 16:25:57","print_times":null,"erpSalesOrderVerifyRels":[{"id":120,"erp_sales_order_id":1682,"user_id":1001,"status":1,"description":null,"verify_at":"2026-02-02 16:25:57","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4118,"key":4118,"name":"\u4e2d\u5b5a\u591a\u529f\u80fd\u5012\u5165\u88c5\u7f6e\u91c7\u8d2d","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1319,"bargain_date":"2026-02-02","collected":"0","profit_pct":"12.5","budget":"3000","erpSalesOrder":{"id":1682,"serial_no":"XSDD-20260202-00001","from_date":null,"wrote_date":"2026-02-02","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4118,"sales_contract_id":4408,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-02-02 16:25:57","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"3000","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"30 days\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"3000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-02-02 16:25:34","updated_at":"2026-02-02 16:25:57","print_times":null},"projectProductTypes":[{"id":8396,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"3000","pct":"12.5","project_id":4118,"profit":"375"}],"projectProductRels":[{"id":11966,"project_id":4118,"product_id":2253,"amount":"3000","number":1,"cost":"2500","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"3000","total_cost":"2500","erp_sales_order_product_id":2186,"supplier":null,"product":{"id":2253,"name":"DRZ32-W3 V1.0","product_type":4,"product_component":228,"product_brand":147,"product_serie":1774,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-02-02 16:56:53","updated_at":"2026-02-06 15:54:37","pinyin_shortcut":"DRZ32W3V10","product_unit":1,"is_renew":false,"in_out_at":"2026-02-06 15:54:37.560278+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":228,"key":228,"name":"\u591a\u529f\u80fd\u5bfc\u5165\u88c5\u7f6e"},"productBrand":{"id":147,"key":147,"name":"\u4e2d\u5b5a"},"productSerie":{"id":1774,"key":1774,"name":"\u9ad8\u6027\u80fd\u684c\u9762\u578b"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":2186,"erp_sales_order_id":1682,"erp_store_id":null,"product_id":2253,"description":"","number":"1","outbound":"1","amount":"3000","total_amount":"3000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2500","total_cost":"2500","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13922,"project_id":4118}],"reimbursementAmountSum":null,"profit":375,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4136,"contract_id":4408,"supplier_id":733,"purchase_id":4413,"supplier":{"id":733,"key":733,"name":"\u4e2d\u5b5a\u5b89\u5168\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4413,"key":4413,"serial_no":"ZFAQ-HT-20260202001350"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8823,"user_id":5087,"key":5087,"contract_id":4408,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10040,"user_id":5087,"key":5087,"contract_id":4408,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2746,"key":2746,"contract_id":4408,"name":"2026-06-30","value":"3000","overdue_days":15,"status":0,"remind_date":"2026-06-30","pct":100,"overdue_display":"\u903e\u671f15\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":3000,"projectProductTotalAmount":3000,"projectProductAllAmount":true,"projectProductTotalCost":2500,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":null,"un_invoiced":3000,"collected":"0","un_collected":3000,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d30\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":3000,"can_view_verify_list":true,"verifyList":[{"id":120,"erp_sales_order_id":1682,"user_id":1001,"status":1,"description":null,"verify_at":"2026-02-02 16:25:57","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4400,"client_id":2125,"signed_at":"2026-01-28","amount":"378880","handler":5087,"description":"","created_by":5087,"created_at":"2026-01-28 16:36:41","updated_at":"2026-02-06 11:45:15","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4113,"valid_date":null,"expire_date":"2027-01-28","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"G0159WL2026F0196","payment_collection_remind_ahead":"30 days","from_project":4113,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2026-02-04 09:42:41","is_verify":false,"is_draft":true,"erp_settle_amount":"227328","erp_un_settle_amount":"151552","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"227328","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":197,"passed":2,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4400,"comment":1},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","erpSalesOrder":{"id":1681,"serial_no":"XSDD-20260128-00002","from_date":null,"wrote_date":"2026-01-28","handler":5087,"client_id":2125,"purchase_contract_id":null,"project_id":4113,"sales_contract_id":4400,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-28 16:36:41","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"31","amount":"378880","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-28 16:25:20","updated_at":"2026-01-28 16:36:41","print_times":null,"erpSalesOrderVerifyRels":[{"id":119,"erp_sales_order_id":1681,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-28 16:36:41"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1681,"serial_no":"XSDD-20260128-00002","from_date":null,"wrote_date":"2026-01-28","handler":5087,"client_id":2125,"purchase_contract_id":null,"project_id":4113,"sales_contract_id":4400,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-28 16:36:41","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"31","amount":"378880","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-28 16:25:20","updated_at":"2026-01-28 16:36:41","print_times":null,"erpSalesOrderVerifyRels":[{"id":119,"erp_sales_order_id":1681,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-28 16:36:41","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":1321,"bargain_date":"2026-01-28","collected":"227328","profit_pct":"41","budget":"378880","erpSalesOrder":{"id":1681,"serial_no":"XSDD-20260128-00002","from_date":null,"wrote_date":"2026-01-28","handler":5087,"client_id":2125,"purchase_contract_id":null,"project_id":4113,"sales_contract_id":4400,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-28 16:36:41","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"31","amount":"378880","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-28 16:25:20","updated_at":"2026-01-28 16:36:41","print_times":null},"projectProductTypes":[{"id":8389,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"0","pct":"0","project_id":4113,"profit":"0"},{"id":8390,"product_type_id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907","budget":"45000","pct":"41","project_id":4113,"profit":"18450"},{"id":8391,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"333880","pct":"41","project_id":4113,"profit":"136890.8"}],"projectProductRels":[{"id":11973,"project_id":4113,"product_id":2241,"amount":"312000","number":1,"cost":"264300","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"312000","total_cost":"264300","erp_sales_order_product_id":2178,"supplier":null,"product":{"id":2241,"name":"XMS1000","product_type":4,"product_component":52,"product_brand":277,"product_serie":1766,"product_misc":null,"product_qa":null,"pn":"","description":"1\u3001XMS1000\u4e3b\u673a1\uff1b\n2\u3001\u5168\u56fd\u4ea7\u5316\u8f6f\u786c\u4ef6\u4e00\u4f53\u8bbe\u8ba1\u548c\u4ea4\u4ed8\uff0c\u96c6\u4f1a\u7ba1\u3001MCU\u548c\u5f55\u64ad\u7b49\u670d\u52a1\u4e8e\u4e00\u4f53\n3\u3001\u63d0\u4f9b\u4f1a\u8bae\u7ba1\u7406\u3001\u901a\u8baf\u5f55\u7ba1\u7406\u3001\u8bbe\u5907\u7ba1\u7406\u3001\u8fd0\u7ef4\u7ba1\u7406\n4\u3001\u652f\u6301SVC\u548cH.323\/SIP\u7ec8\u7aef\u6ce8\u518c\u63a5\u5165\n5\u3001\u652f\u63014K\u30011080P\u3001720P\u9ad8\u6e05\u89c6\u9891\u5904\u7406\n6\u3001\u652f\u6301\u4f1a\u8bae\u3001\u4f1a\u5546\u5f55\u5236\u70b9\u64ad\n7\u3001\u542b\u4e09\u5e74\u5347\u7ea7\u53ca\u8fdc\u7a0b\u670d\u52a1\u8d39\u7528\uff0c\u4e09\u5e74\u786c\u4ef6\u8d28\u4fdd\n8\u3001\u542b14\u65b9\u5e76\u53d1\u8bb8\u53ef","created_by":1013,"created_at":"2026-01-29 14:21:26","updated_at":"2026-02-10 15:28:51","pinyin_shortcut":"XMS1000","product_unit":2,"is_renew":false,"in_out_at":"2026-02-10 15:28:51.229248+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":277,"key":277,"name":"\u5c0f\u9c7c\u6613\u8fde"},"productSerie":{"id":1766,"key":1766,"name":"\u89c6\u9891\u4f1a\u8bae\u5e73\u53f0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2178,"erp_sales_order_id":1681,"erp_store_id":null,"product_id":2241,"description":"","number":"1","outbound":"1","amount":"312000","total_amount":"312000","last_number":"1","last_amount":"312000","last_total_amount":"312000","cost":"264300","total_cost":"264300","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11974,"project_id":4113,"product_id":2242,"amount":"7500","number":6,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"45000","total_cost":null,"erp_sales_order_product_id":2179,"supplier":null,"product":{"id":2242,"name":"CB-992F","product_type":21,"product_component":227,"product_brand":278,"product_serie":1767,"product_misc":null,"product_qa":null,"pn":"","description":"\u9ad8\u6e05\u5206\u8fa8\u738719201080\u3001\u5bf9\u6bd4\u5ea616000:1\u30014000\u6d41\u660e\uff0c\u767d\u5929\u76f4\u6295","created_by":1013,"created_at":"2026-01-29 14:25:19","updated_at":"2026-03-31 17:15:49","pinyin_shortcut":"CB992F","product_unit":1,"is_renew":false,"in_out_at":"2026-03-31 17:15:49.970866+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":227,"key":227,"name":"\u6295\u5f71\u673a"},"productBrand":{"id":278,"key":278,"name":"\u7231\u666e\u751f"},"productSerie":{"id":1767,"key":1767,"name":"\u9ad8\u4eae\u5546\u6559\u6295\u5f71\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":2179,"erp_sales_order_id":1681,"erp_store_id":null,"product_id":2242,"description":"","number":"6","outbound":"0","amount":"7500","total_amount":"45000","last_number":"6","last_amount":"7500","last_total_amount":"45000","cost":null,"total_cost":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11975,"project_id":4113,"product_id":2243,"amount":"1249","number":10,"cost":"925.5","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"12490","total_cost":"9255","erp_sales_order_product_id":2180,"supplier":null,"product":{"id":2243,"name":"Q100","product_type":4,"product_component":52,"product_brand":279,"product_serie":1768,"product_misc":null,"product_qa":null,"pn":"","description":"\u8d85\u9ad8\u6e054K\uff0c\u81ea\u52a8\u5bf9\u7126\uff0c\u652f\u6301USB\/HDMI\/WIN7","created_by":1013,"created_at":"2026-01-29 14:32:02","updated_at":"2026-02-04 13:29:12","pinyin_shortcut":"Q100","product_unit":1,"is_renew":false,"in_out_at":"2026-02-04 13:29:12.573935+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":279,"key":279,"name":"\u6c47\u535a\u58eb"},"productSerie":{"id":1768,"key":1768,"name":"4K\u9ad8\u6e05HDMI\u6444\u50cf\u5934"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":2180,"erp_sales_order_id":1681,"erp_store_id":null,"product_id":2243,"description":"","number":"10","outbound":"10","amount":"1249","total_amount":"12490","last_number":"10","last_amount":"1249","last_total_amount":"12490","cost":"925.5","total_cost":"9255","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11976,"project_id":4113,"product_id":2244,"amount":"939","number":10,"cost":"1297","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"9390","total_cost":"12970","erp_sales_order_product_id":2181,"supplier":null,"product":{"id":2244,"name":"Thinkplus MK-MC500+","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":null,"product_qa":null,"pn":"","description":"6\u7c73\u5185\u5168\u5411\u62fe\u97f3\uff0c\u667a\u80fd\u964d\u566a\uff0c\u652f\u6301USB\u6709\u7ebf\uff0c\u9ea6\u514b\u548c\u97f3\u54cd\u4e00\u4f53\u5f0f","created_by":1013,"created_at":"2026-01-29 14:34:55","updated_at":"2026-02-04 13:29:12","pinyin_shortcut":"ThinkplusMKMC500","product_unit":3,"is_renew":false,"in_out_at":"2026-02-04 13:29:12.573935+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2181,"erp_sales_order_id":1681,"erp_store_id":null,"product_id":2244,"description":"","number":"10","outbound":"10","amount":"939","total_amount":"9390","last_number":"10","last_amount":"939","last_total_amount":"9390","cost":"1297","total_cost":"12970","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11977,"project_id":4113,"product_id":2255,"amount":"0","number":3,"cost":null,"description":"1\u7c73\u540a\u67b6\u300110\u7c73\u7535\u6e90\u7ebf\u300115\u7c73\u9ad8\u6e05\u7ebf","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":null,"erp_sales_order_product_id":2189,"supplier":null,"product":{"id":2255,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6\u8f85\u6599","product_type":21,"product_component":229,"product_brand":134,"product_serie":1776,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-02-04 16:29:24","updated_at":"2026-03-20 15:12:53","pinyin_shortcut":"tyyazpjfl","product_unit":2,"is_renew":false,"in_out_at":"2026-03-20 15:12:53.544213+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1776,"key":1776,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2189,"erp_sales_order_id":1681,"erp_store_id":null,"product_id":2255,"description":"1\u7c73\u540a\u67b6\u300110\u7c73\u7535\u6e90\u7ebf\u300115\u7c73\u9ad8\u6e05\u7ebf","number":"3","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":null,"total_cost":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11978,"project_id":4113,"product_id":2256,"amount":"0","number":1,"cost":null,"description":"\u7231\u666e\u751f\u6295\u5f71\u4eea\u5b89\u88c5","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":null,"erp_sales_order_product_id":2190,"supplier":null,"product":{"id":2256,"name":"\u6295\u5f71\u673a\u5b89\u88c5\u670d\u52a1","product_type":22,"product_component":205,"product_brand":134,"product_serie":1777,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-02-04 16:30:38","updated_at":"2026-02-04 16:30:38","pinyin_shortcut":"tyjazfw","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1777,"key":1777,"name":"\u8bbe\u5907\u5b89\u88c5\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2190,"erp_sales_order_id":1681,"erp_store_id":null,"product_id":2256,"description":"\u7231\u666e\u751f\u6295\u5f71\u4eea\u5b89\u88c5","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":null,"total_cost":null,"supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13918,"project_id":4113},{"id":13916,"project_id":4113},{"id":13915,"project_id":4113},{"id":13914,"project_id":4113},{"id":13912,"project_id":4113},{"id":13911,"project_id":4113},{"id":13909,"project_id":4113},{"id":13908,"project_id":4113},{"id":13917,"project_id":4113},{"id":13913,"project_id":4113},{"id":13910,"project_id":4113},{"id":13924,"project_id":4113}],"reimbursementAmountSum":{"project_id":4113,"sum":"174.60"},"profit":155340.8,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4143,"contract_id":4400,"supplier_id":660,"purchase_id":4416,"supplier":{"id":660,"key":660,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4416,"key":4416,"serial_no":"SLKX20260210"}},{"id":4177,"contract_id":4400,"supplier_id":262,"purchase_id":4438,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4438,"key":4438,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3437475000857790"}},{"id":4188,"contract_id":4400,"supplier_id":608,"purchase_id":4412,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4412,"key":4412,"serial_no":"\u8ba2\u5355\u53f7: 5053305530461592710"}},{"id":4189,"contract_id":4400,"supplier_id":262,"purchase_id":4440,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410"}},{"id":4129,"contract_id":4400,"supplier_id":316,"purchase_id":4391,"supplier":{"id":316,"key":316,"name":"\u5317\u4eac\u6c38\u8d8a\u660c\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4391,"key":4391,"serial_no":"TSKJ20260126-HYF-01"}},{"id":4130,"contract_id":4400,"supplier_id":262,"purchase_id":4402,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4402,"key":4402,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3386275004811263"}},{"id":4131,"contract_id":4400,"supplier_id":262,"purchase_id":4405,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4405,"key":4405,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3394275014663107"}},{"id":4132,"contract_id":4400,"supplier_id":760,"purchase_id":4410,"supplier":{"id":760,"key":760,"name":"\u5317\u4eac\u6c47\u6d77\u667a\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4410,"key":4410,"serial_no":"HHZD20260203"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8818,"user_id":5087,"key":5087,"contract_id":4400,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10035,"user_id":5087,"key":5087,"contract_id":4400,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2747,"key":2747,"contract_id":4400,"name":"2026-04-30","value":"227328","overdue_days":null,"status":1,"remind_date":"2026-04-30","pct":60,"overdue_display":""},{"id":2748,"key":2748,"contract_id":4400,"name":"2026-06-30","value":"113664","overdue_days":15,"status":0,"remind_date":"2026-06-30","pct":30,"overdue_display":"\u903e\u671f15\u5929"},{"id":2749,"key":2749,"contract_id":4400,"name":"2027-05-31","value":"37888","overdue_days":null,"status":0,"remind_date":"2027-05-31","pct":10,"overdue_display":""}],"salesContractPayments":[{"id":"12175","key":"12175","contract_id":4400,"value":"227328","created_by":1013,"created_at":"2026-02-26 11:37:56","description":null,"collected_date":"2026-02-26 00:00:00","amount":"227328","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":60}],"salesContractInvoices":[],"contractScans":[{"id":56355,"object_type":105,"object_id":4400,"attachment_id":31856,"attachment":{"id":31856,"key":31856,"name":"f49dfaa5-4c8a-32a8-aca2-c59e19230aa3","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f49dfaa5-4c8a-32a8-aca2-c59e19230aa3\/2026_02_06_11_43_44.pdf","orig_name":"2026_02_06_11_43_44.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":378880,"projectProductTotalAmount":378880,"projectProductAllAmount":true,"projectProductTotalCost":286525,"projectProductAllCost":false,"projectProductTotalCount":31,"invoiced":null,"un_invoiced":378880,"collected":"227328","un_collected":151552,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d30\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":151552,"can_view_verify_list":true,"verifyList":[{"id":119,"erp_sales_order_id":1681,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-28 16:36:41","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4359,"client_id":2136,"signed_at":"2026-01-05","amount":"28560","handler":5087,"description":"","created_by":5087,"created_at":"2026-01-05 09:19:46","updated_at":"2026-01-07 18:32:21","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4089,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"2026-01-05-001","payment_collection_remind_ahead":"30 days","from_project":4089,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2026-01-07 09:51:50","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"28560","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4359,"comment":2},"project":{"id":4089,"key":4089,"name":"\u6d89\u5bc6\u8ba1\u7b97\u673a\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\u5ba2\u6237\u7aef\u6388\u6743\u70b9-2026","erpSalesOrder":{"id":1663,"serial_no":"XSDD-20260105-00001","from_date":null,"wrote_date":"2026-01-05","handler":5087,"client_id":2136,"purchase_contract_id":null,"project_id":4089,"sales_contract_id":4359,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-05 09:19:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"120","amount":"28560","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 09:14:04","updated_at":"2026-01-05 09:19:46","print_times":null,"erpSalesOrderVerifyRels":[{"id":101,"erp_sales_order_id":1663,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 09:19:46"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1663,"serial_no":"XSDD-20260105-00001","from_date":null,"wrote_date":"2026-01-05","handler":5087,"client_id":2136,"purchase_contract_id":null,"project_id":4089,"sales_contract_id":4359,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-05 09:19:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"120","amount":"28560","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 09:14:04","updated_at":"2026-01-05 09:19:46","print_times":null,"erpSalesOrderVerifyRels":[{"id":101,"erp_sales_order_id":1663,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 09:19:46","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4089,"key":4089,"name":"\u6d89\u5bc6\u8ba1\u7b97\u673a\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\u5ba2\u6237\u7aef\u6388\u6743\u70b9-2026","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1153,"bargain_date":"2026-01-05","collected":"0","profit_pct":"41.13","budget":"28560","erpSalesOrder":{"id":1663,"serial_no":"XSDD-20260105-00001","from_date":null,"wrote_date":"2026-01-05","handler":5087,"client_id":2136,"purchase_contract_id":null,"project_id":4089,"sales_contract_id":4359,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-05 09:19:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"120","amount":"28560","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 09:14:04","updated_at":"2026-01-05 09:19:46","print_times":null},"projectProductTypes":[{"id":8061,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"28560","pct":"41.13","project_id":4089,"profit":"11746.72"}],"projectProductRels":[{"id":11454,"project_id":4089,"product_id":1007,"amount":"238","number":120,"cost":"120","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"28560","total_cost":"14400","erp_sales_order_product_id":2122,"supplier":null,"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":null,"product_qa":null,"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"}},"erpSalesOrderProduct":{"id":2122,"erp_sales_order_id":1663,"erp_store_id":null,"product_id":1007,"description":"","number":"120","outbound":"120","amount":"238","total_amount":"28560","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"120","total_cost":"14400","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13835,"project_id":4089}],"reimbursementAmountSum":null,"profit":11746.728,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3829,"contract_id":4359,"supplier_id":733,"purchase_id":4362,"supplier":{"id":733,"key":733,"name":"\u4e2d\u5b5a\u5b89\u5168\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4362,"key":4362,"serial_no":"ZFAQ-HT-20260104000086"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9691,"user_id":5087,"key":5087,"contract_id":4359,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2714,"key":2714,"contract_id":4359,"name":"2026-10-31","value":"28560","overdue_days":null,"status":0,"remind_date":"2026-10-31","pct":100,"overdue_display":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":28560,"projectProductTotalAmount":28560,"projectProductAllAmount":true,"projectProductTotalCost":14400,"projectProductAllCost":true,"projectProductTotalCount":120,"invoiced":null,"un_invoiced":28560,"collected":"0","un_collected":28560,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d30\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":28560,"can_view_verify_list":true,"verifyList":[{"id":101,"erp_sales_order_id":1663,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 09:19:46","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4325,"client_id":2526,"signed_at":"2025-12-18","amount":"7200","handler":5087,"description":"","created_by":5087,"created_at":"2025-12-19 13:53:29","updated_at":"2026-01-07 09:37:31","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4072,"valid_date":null,"expire_date":"2025-12-31","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"CK012025-FK0910","payment_collection_remind_ahead":"1 day","from_project":4072,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-12-19 13:53:29","is_verify":false,"is_draft":true,"erp_settle_amount":"7200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"7200","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":196,"passed":2,"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4325,"comment":6},"project":{"id":4072,"key":4072,"name":"\u6253\u5370\u673a\u7ef4\u4fee-\u80cc\u9760\u80cc\u9879\u76ee","erpSalesOrder":{"id":1651,"serial_no":"XSDD-20251219-00001","from_date":null,"wrote_date":"2025-12-18","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4072,"sales_contract_id":4325,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:29","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"7200","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"7200\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 11:51:27","updated_at":"2025-12-19 13:53:29","print_times":null,"erpSalesOrderVerifyRels":[{"id":89,"erp_sales_order_id":1651,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:29"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1651,"serial_no":"XSDD-20251219-00001","from_date":null,"wrote_date":"2025-12-18","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4072,"sales_contract_id":4325,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:29","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"7200","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"7200\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 11:51:27","updated_at":"2025-12-19 13:53:29","print_times":null,"erpSalesOrderVerifyRels":[{"id":89,"erp_sales_order_id":1651,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:29","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4072,"key":4072,"name":"\u6253\u5370\u673a\u7ef4\u4fee-\u80cc\u9760\u80cc\u9879\u76ee","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1146,"bargain_date":"2025-12-18","collected":"7200","profit_pct":"7.3","budget":"7200","erpSalesOrder":{"id":1651,"serial_no":"XSDD-20251219-00001","from_date":null,"wrote_date":"2025-12-18","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4072,"sales_contract_id":4325,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:29","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"7200","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"7200\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 11:51:27","updated_at":"2025-12-19 13:53:29","print_times":null},"projectProductTypes":[{"id":7962,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"7200","pct":"7.3","project_id":4072,"profit":"525.6"}],"projectProductRels":[{"id":11441,"project_id":4072,"product_id":2221,"amount":"7200","number":1,"cost":"6430","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7200","total_cost":"6430","erp_sales_order_product_id":2117,"supplier":null,"product":{"id":2221,"name":"\u6253\u5370\u673a\u7ef4\u4fee\u670d\u52a1","product_type":22,"product_component":224,"product_brand":134,"product_serie":1751,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-12-29 13:59:14","updated_at":"2025-12-30 14:00:16","pinyin_shortcut":"dyjwxfw","product_unit":7,"is_renew":false,"in_out_at":"2025-12-30 14:00:16.490397+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":224,"key":224,"name":"\u7ef4\u4fee\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1751,"key":1751,"name":"\u6253\u5370\u673a\u7ef4\u4fee"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":2117,"erp_sales_order_id":1651,"erp_store_id":null,"product_id":2221,"description":"","number":"1","outbound":"1","amount":"7200","total_amount":"7200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6430","total_cost":"6430","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13780,"project_id":4072}],"reimbursementAmountSum":null,"profit":525.6,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3751,"contract_id":4325,"supplier_id":752,"purchase_id":4352,"supplier":{"id":752,"key":752,"name":"\u5317\u4eac\u5fd7\u8bda\u6cf0\u548c\u4fe1\u606f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchase":{"id":4352,"key":4352,"serial_no":"TSKJ20251224-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8561,"user_id":5087,"key":5087,"contract_id":4325,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9586,"user_id":5087,"key":5087,"contract_id":4325,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2681,"key":2681,"contract_id":4325,"name":"2026-06-30","value":"7200","overdue_days":null,"status":1,"remind_date":"2026-06-30","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"12129","key":"12129","contract_id":4325,"value":"7200","created_by":1013,"created_at":"2025-12-25 16:39:31","description":null,"collected_date":"2025-12-25 00:00:00","amount":"7200","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2252,"key":2252,"contract_id":4325,"value":"7200.00","attachment_id":null,"from_date":"2025-12-19","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":1104,"sales_invoice_id":2252,"amount":"7200","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54899,"object_type":102,"object_id":2252,"attachment_id":30691,"attachment":{"id":30691,"key":30691,"name":"ebea3b79-8c5d-3ea3-94fd-bcd3c50965f9","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/ebea3b79-8c5d-3ea3-94fd-bcd3c50965f9\/dzfp_25112000000288164653_\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8_20251219143826.pdf","orig_name":"dzfp_25112000000288164653_\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8_20251219143826.pdf"}}]}],"contractScans":[{"id":55046,"object_type":105,"object_id":4325,"attachment_id":30785,"attachment":{"id":30785,"key":30785,"name":"cd6fcf87-8e9e-35a9-b3aa-f4c54b522ea7","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/cd6fcf87-8e9e-35a9-b3aa-f4c54b522ea7\/2025_12_23_16_39_22.pdf","orig_name":"2025_12_23_16_39_22.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":7200,"projectProductTotalAmount":7200,"projectProductAllAmount":true,"projectProductTotalCost":6430,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":"7200.00","un_invoiced":0,"collected":"7200","un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"can_view_verify_list":true,"verifyList":[{"id":89,"erp_sales_order_id":1651,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:29","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4316,"client_id":2526,"signed_at":"2025-12-16","amount":"8500","handler":5087,"description":"","created_by":5087,"created_at":"2025-12-16 16:51:01","updated_at":"2026-01-07 09:52:49","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4075,"valid_date":null,"expire_date":"2028-12-15","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"2025-12-16-003","payment_collection_remind_ahead":"1 day","from_project":4075,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-12-16 16:51:01","is_verify":false,"is_draft":true,"erp_settle_amount":"0","erp_un_settle_amount":"8500","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":884,"passed":2,"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4316,"comment":2},"project":{"id":4075,"key":4075,"name":"\u89c6\u9891\u5e72\u6270\u4eea\u91c7\u8d2d","erpSalesOrder":{"id":1645,"serial_no":"XSDD-20251216-00003","from_date":null,"wrote_date":"2025-12-16","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4075,"sales_contract_id":4316,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-16 16:51:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"10","amount":"8500","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"8500\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-16 15:19:04","updated_at":"2025-12-16 16:51:01","print_times":null,"erpSalesOrderVerifyRels":[{"id":83,"erp_sales_order_id":1645,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-16 16:51:01"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1645,"serial_no":"XSDD-20251216-00003","from_date":null,"wrote_date":"2025-12-16","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4075,"sales_contract_id":4316,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-16 16:51:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"10","amount":"8500","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"8500\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-16 15:19:04","updated_at":"2025-12-16 16:51:01","print_times":null,"erpSalesOrderVerifyRels":[{"id":83,"erp_sales_order_id":1645,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-16 16:51:01","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4075,"key":4075,"name":"\u89c6\u9891\u5e72\u6270\u4eea\u91c7\u8d2d","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1119,"bargain_date":"2025-12-16","collected":"0","profit_pct":"44.06","budget":"8500","erpSalesOrder":{"id":1645,"serial_no":"XSDD-20251216-00003","from_date":null,"wrote_date":"2025-12-16","handler":5087,"client_id":2526,"purchase_contract_id":null,"project_id":4075,"sales_contract_id":4316,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-16 16:51:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"10","amount":"8500","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-06-30\",\"amount\":\"8500\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-16 15:19:04","updated_at":"2025-12-16 16:51:01","print_times":null},"projectProductTypes":[{"id":7968,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"8500","pct":"44.06","project_id":4075,"profit":"3745.1"}],"projectProductRels":[{"id":11274,"project_id":4075,"product_id":2198,"amount":"850","number":10,"cost":"400","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"8500","total_cost":"4000","erp_sales_order_product_id":2058,"supplier":null,"product":{"id":2198,"name":"SPD-2","product_type":4,"product_component":223,"product_brand":273,"product_serie":1746,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-12-17 09:29:34","updated_at":"2025-12-17 16:01:31","pinyin_shortcut":"SPD2","product_unit":1,"is_renew":false,"in_out_at":"2025-12-17 16:01:31.12051+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":223,"key":223,"name":"\u5fae\u673a\u89c6\u9891\u4fe1\u606f\u4fdd\u62a4\u7cfb\u7edf"},"productBrand":{"id":273,"key":273,"name":"\u6c38\u76fe"},"productSerie":{"id":1746,"key":1746,"name":"\u6c38\u76fe\u5fae\u673a\u89c6\u9891\u4fe1\u606f\u4fdd\u62a4\u7cfb\u7edf"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":2058,"erp_sales_order_id":1645,"erp_store_id":null,"product_id":2198,"description":"","number":"10","outbound":"10","amount":"850","total_amount":"8500","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"400","total_cost":"4000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13685,"project_id":4075},{"id":13684,"project_id":4075},{"id":13692,"project_id":4075},{"id":13691,"project_id":4075},{"id":13690,"project_id":4075},{"id":13689,"project_id":4075},{"id":13688,"project_id":4075},{"id":13687,"project_id":4075},{"id":13686,"project_id":4075},{"id":13683,"project_id":4075}],"reimbursementAmountSum":null,"profit":3745.1,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3755,"contract_id":4316,"supplier_id":748,"purchase_id":4317,"supplier":{"id":748,"key":748,"name":"\u5317\u4eac\u6c38\u76fe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4317,"key":4317,"serial_no":"TSKJ20251216-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8567,"user_id":5087,"key":5087,"contract_id":4316,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9591,"user_id":5087,"key":5087,"contract_id":4316,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2673,"key":2673,"contract_id":4316,"name":"2026-06-30","value":"8500","overdue_days":15,"status":0,"remind_date":"2026-06-30","pct":100,"overdue_display":"\u903e\u671f15\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":8500,"projectProductTotalAmount":8500,"projectProductAllAmount":true,"projectProductTotalCost":4000,"projectProductAllCost":true,"projectProductTotalCount":10,"invoiced":null,"un_invoiced":8500,"collected":"0","un_collected":8500,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":8500,"can_view_verify_list":true,"verifyList":[{"id":83,"erp_sales_order_id":1645,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-16 16:51:01","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]}],"pagenation":{"totalcount":83,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 10:14:59', 156195840) RETURNING "id"
10:14:59.486	3.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (2252, 2306))
10:14:59.490	3.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (2252, 2306))
10:14:59.504	3.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316))
10:14:59.465	3.4 ms	yii\db\Command::query	SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854))
10:14:59.501	3.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316))
10:14:59.495	3.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316))
10:14:59.469	2.3 ms	yii\db\Command::query	SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854)) GROUP BY "project_id"
10:14:59.482	1.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' \|\| r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' \|\| r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' \|\| r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316) ORDER BY "id" DESC
10:14:59.498	1.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30785, 31856, 31833, 32759, 32760)
10:14:59.480	1.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316) ORDER BY "remind_date"
10:14:59.457	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854))
10:14:59.451	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316) ORDER BY "id" DESC
10:14:59.448	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854))
10:14:59.485	0.9 ms	yii\db\Command::query	SELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (2252, 2306) ORDER BY "id"
10:14:59.458	0.8 ms	yii\db\Command::query	SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854)
10:14:59.389	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
10:14:59.459	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854) ORDER BY "id"
10:14:59.530	0.6 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4408
10:14:59.476	0.6 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)
10:14:59.472	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)
10:14:59.391	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:14:59.447	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3957, 3796, 3854, 4119, 4118, 4113, 4089, 4072, 4075)
10:14:59.461	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2198, 2221, 1007, 2253, 2241, 2242, 2243, 2244, 2255, 2256, 941, 2261, 1372, 2265, 2263, 2266)
10:14:59.478	0.5 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)
10:14:59.453	0.5 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:14:59.424	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2130, 2125, 2128, 3443, 2526, 2136)
10:14:59.464	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (2058, 2117, 2122, 2186, 2178, 2179, 2180, 2181, 2189, 2190, 2191, 2251, 2252, 2253, 2254, 2255)
10:14:59.527	0.4 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4496
10:14:59.473	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (660, 262, 608, 733, 752, 748, 316, 760, 431)
10:14:59.463	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (592, 1751, 1263, 1746, 1768, 1777, 1774, 1776, 1782, 1769, 1766, 1767, 1775, 1047, 1783)
10:14:59.456	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3957, 3796, 3854, 4119, 4118, 4113, 4089, 4072, 4075)
10:14:59.484	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316) ORDER BY "id"
10:14:59.450	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1716, 1663, 1683, 1682, 1681, 1645, 1651, 1715) ORDER BY "id"
10:14:59.473	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4416, 4438, 4412, 4440, 4362, 4352, 4317, 4391, 4402, 4405, 4410, 4413, 4502)
10:14:59.455	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:14:59.452	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1717, 1716, 1715, 1683, 1682, 1681, 1663, 1651, 1645) ORDER BY "id"
10:14:59.475	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)) ORDER BY "remind_date"
10:14:59.531	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4359
10:14:59.426	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5087))
10:14:59.494	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30691, 31862)
10:14:59.533	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4316
10:14:59.532	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4325
10:14:59.425	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
10:14:59.528	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4492
10:14:59.463	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (133, 134, 147, 273, 279, 285, 4, 277, 278, 284, 286)
10:14:59.531	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4400
10:14:59.462	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (19, 22, 7, 4, 21, 23)
10:14:59.476	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)
10:14:59.479	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1001)
10:14:59.425	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
10:14:59.389	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:14:59.426	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 5250)
10:14:59.455	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:14:59.462	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (151, 224, 162, 223, 52, 205, 228, 229, 227, 195, 43, 221)
10:14:59.454	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1717, 1716, 1715, 1683, 1682, 1681, 1663, 1651, 1645) ORDER BY "id"
10:14:59.477	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
10:14:59.465	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (4072, 4075, 4089, 4119, 4118, 4113, 3957, 3796, 3854)
10:14:59.453	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:14:59.450	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1716, 1663, 1683, 1682, 1681, 1645, 1651, 1715) ORDER BY "id"
10:14:59.484	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
10:14:59.454	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1717, 1716, 1715, 1683, 1682, 1681, 1663, 1651, 1645) ORDER BY "id"
10:14:59.480	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5087, 1001))
10:14:59.475	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
10:14:59.528	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4491
10:14:59.474	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
10:14:59.529	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4483
10:14:59.477	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
10:14:59.529	0.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4414
10:14:59.427	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 1)
10:14:59.464	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (7, 2, 1, 3, 9, 6)
10:14:59.478	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4496, 4492, 4491, 4483, 4414, 4408, 4400, 4359, 4325, 4316)
10:14:59.474	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1