ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a281b77cf90b: POST https://beta.jinchangxiao.com/v2/purchase-contract/of-client at 2026-06-09 09:56:07 pm by 117.176.186.63

Performance Profiling

Total processing time: 145 ms; Peak memory: 6.394 MB. Show Profiling Timeline

总计57条数据
TimeDurationCategoryInfo
  
21:56:07.87426.0 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)) GROUP BY "object_id"
21:56:07.93725.1 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)) GROUP BY "object_id"
21:56:07.9213.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340))
21:56:07.9163.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1775, 1781, 1834, 2091, 2093, 2108, 2183, 2462, 2546))
21:56:07.9123.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1775, 1781, 1834, 2091, 2093, 2108, 2183, 2462, 2546))
21:56:07.9893.6 msyii\db\Command::queryINSERT 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, 1159, 'v2/purchase-contract/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"93","page":"1","posttime":"1781013376","token":"c0b578783cda6157cfd63d0926468019","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":4174,"supplier_id":262,"contract_type":1,"signed_at":"2025-09-23","amount":"653","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-09-23 13:41:08","updated_at":"2025-09-23 13:41:19","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u8ba2\u5355\u53f7\uff1a 322893313491","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-09-23 13:41:19","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"653","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"653","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4174,"comment":4},"purchaseClientRels":[{"id":3906,"contract_id":4174,"client_id":93,"project_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":null}],"purchaseContractPayments":[{"id":"12145","key":"12145","contract_id":4174,"amount":"653","value":"653","collected_date":"2025-09-24 00:00:00","created_at":"2025-09-24 10:43:38","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u4eac\u4e1c\u5546\u57ce","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2462,"key":2462,"contract_id":4174,"amount":"653","value":"653","attachment_id":null,"from_date":"2025-09-24","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2108,"purchase_invoice_id":2462,"amount":"653","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":50587,"object_type":103,"object_id":2462,"attachment_id":28650,"attachment":{"id":28650,"key":28650,"name":"41a9dd60-fa17-3f72-866b-2f2d7da46314","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/41a9dd60-fa17-3f72-866b-2f2d7da46314\/653.pdf","orig_name":"653.pdf"}}]}],"contractScans":[{"id":50493,"object_type":108,"object_id":4174,"attachment_id":28568,"attachment":{"id":28568,"key":28568,"name":"2b92e7df-35a7-3496-8ab2-7d8f61e2871b","extension":"png","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/2b92e7df-35a7-3496-8ab2-7d8f61e2871b\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1545,"user_id":1011,"key":1011,"contract_id":4174,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1546,"user_id":5360,"key":5360,"contract_id":4174,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":911,"key":911,"contract_id":4174,"name":"2025-09-26","value":"653","overdue_days":null,"status":1,"remind_date":"2025-09-26","pct":100,"overdue_display":""}],"paymentApproves":[{"id":2281,"client_id":93,"project_id":null,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":null,"verify_at":"2025-09-24 09:45:22","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u4e2d\u79cb\u793c\u54c1\u6708\u997c3\u76d2\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5653\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-09-23 14:03:27","updated_at":"2025-09-24 09:45:22","supplier_id":262,"purchase_contract_id":4174,"amount":"653","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"653","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"653"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":144,"purchase_contract_id":4174,"erp_store_id":null,"erp_purchase_order_product_id":109,"product_id":2139,"description":"","number":"3","amount":"217.66","total_amount":"653","erpStore":null,"product":{"id":2139,"name":"\u7f8e\u5fc3\u91d1\u67ab\u79cb\u610f\u6708\u997c\u793c\u76d2395g","product_type":23,"product_component":195,"product_brand":264,"product_serie":1708,"product_misc":null,"product_qa":null,"pn":"","description":"\u86cb\u9ec4\u767d\u83b2\u84c9 \u6817\u5b50\u8c46\u6c99","created_by":1013,"created_at":"2025-09-22 15:26:10","updated_at":"2025-09-24 09:36:52","pinyin_shortcut":"mxjfqyyblh395g","product_unit":9,"is_renew":false,"in_out_at":"2025-09-24 09:36:52+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":264,"key":264,"name":"\u7f8e\u5fc3"},"productSerie":{"id":1708,"key":1708,"name":"\u91d1\u67ab\u79cb\u610f\u6708\u997c\u793c\u76d2"},"productUnit":{"id":9,"key":9,"name":"\u76d2"}},"erpPurchaseOrderProduct":{"id":109,"erp_purchase_order_id":2063,"erp_store_id":null,"product_id":2139,"description":"","number":"3","into_inventory":"3","amount":"217.66","total_amount":"653","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2063,"serial_no":"CGDD-20250923-00001","from_date":null,"wrote_date":"2025-09-23","handler":1011,"supplier_id":262,"purchase_contract_id":4174,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-23 13:41:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"3","amount":"652.98","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-09-23 13:41:08","updated_at":"2025-09-23 13:41:28","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":69,"erp_purchase_order_id":2063,"user_id":1011,"status":1,"description":"","verify_at":"2025-09-23 13:41:28"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"653","approve_amount":653,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"653","un_collected":0,"collected_plan":653,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":653,"product_number":3,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":4137,"supplier_id":729,"contract_type":1,"signed_at":"2025-09-03","amount":"340000","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-09-03 11:06:02","updated_at":"2025-09-04 10:05:39","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250903-HYF-01","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-09-03 11:06:23","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"340000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"340000","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":729,"key":729,"name":"\u5317\u4eac\u7f8e\u7f51\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":"\u5f00\u6237\u884c: \u6c11\u751f\u94f6\u884c\u5317\u4eac\u4e2d\u5173\u6751\u652f\u884c\n\u8d26\u53f7: 633042585"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4137,"comment":4},"purchaseClientRels":[{"id":4480,"contract_id":4137,"client_id":93,"project_id":3488,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3488,"key":3488,"name":"\u591a\u56e0\u7d20\u8ba4\u8bc1-\u5b81\u76fe5000\u70b9","project_status":3,"budget":"545000","buildContract":{"id":4074,"from_project":3488,"serial_no":"C202507230036"},"clickable":1}}],"purchaseContractPayments":[{"id":"12247","key":"12247","contract_id":4137,"amount":"340000","value":"340000","collected_date":"2025-12-15 00:00:00","created_at":"2025-12-15 13:29:35","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u7f8e\u7f51\u79d1\u6280","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2546,"key":2546,"contract_id":4137,"amount":"340000","value":"340000","attachment_id":null,"from_date":"2025-11-18","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2202,"purchase_invoice_id":2546,"amount":"340000","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":52712,"object_type":103,"object_id":2546,"attachment_id":29871,"attachment":{"id":29871,"key":29871,"name":"ebb9db55-4448-300b-9409-83ab5959cc56","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/ebb9db55-4448-300b-9409-83ab5959cc56\/dzfp_25112000000253495503_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20251118135313.pdf","orig_name":"dzfp_25112000000253495503_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20251118135313.pdf"}}]}],"contractScans":[{"id":49671,"object_type":108,"object_id":4137,"attachment_id":27993,"attachment":{"id":27993,"key":27993,"name":"7379c8ff-c27e-33a2-8036-64855addb22e","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/7379c8ff-c27e-33a2-8036-64855addb22e\/2025_09_04_10_05_27.pdf","orig_name":"2025_09_04_10_05_27.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1491,"user_id":1011,"key":1011,"contract_id":4137,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1492,"user_id":5360,"key":5360,"contract_id":4137,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":877,"key":877,"contract_id":4137,"name":"2025-11-04","value":"340000","overdue_days":41,"status":1,"remind_date":"2025-11-04","pct":100,"overdue_display":"\u903e\u671f41\u5929"}],"paymentApproves":[{"id":2510,"client_id":93,"project_id":3488,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u7f8e\u7f51\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-12-15 11:21:58","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5b81\u76fe\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5340000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u4ed8\u6b3e\u4fe1\u606f\u5982\u4e0b\uff1a\n\u4f01\u4e1a\u540d\u79f0\uff1a\u5317\u4eac\u7f8e\u7f51\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u6c11\u751f\u94f6\u884c\u5317\u4eac\u4e2d\u5173\u6751\u652f\u884c \n \u5e10\u53f7\uff1a633042585\n\n\u5907\u6ce8\uff1a\u4ea7\u54c1\u5df2\u5165\u5e93\u5b8c\u6210\uff0c\u5df2\u4ea4\u4ed8\u5b8c\u6bd5\uff0c\u5df2\u9a8c\u6536\u5b8c\u6bd5\uff0c\u7528\u6237\u5df2\u56de\u6b3e\u3002\n\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-12-15 11:08:12","updated_at":"2025-12-15 11:21:58","supplier_id":729,"purchase_contract_id":4137,"amount":"340000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"340000","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"340000"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":102,"purchase_contract_id":4137,"erp_store_id":null,"erp_purchase_order_product_id":76,"product_id":942,"description":"\u5b89\u88c5\u670d\u52a1","number":"3","amount":"3000","total_amount":"9000","erpStore":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpPurchaseOrderProduct":{"id":76,"erp_purchase_order_id":2046,"erp_store_id":null,"product_id":942,"description":"\u5b89\u88c5\u670d\u52a1","number":"3","into_inventory":"3","amount":"3000","total_amount":"9000","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":103,"purchase_contract_id":4137,"erp_store_id":null,"erp_purchase_order_product_id":77,"product_id":2127,"description":"","number":"1","amount":"24000","total_amount":"24000","erpStore":null,"product":{"id":2127,"name":"\u5b81\u76fe\u6280\u672f\u652f\u6301\u670d\u52a1","product_type":22,"product_component":189,"product_brand":137,"product_serie":1702,"product_misc":null,"product_qa":null,"pn":"","description":"\u514d\u8d39\u63d0\u4f9b\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u53ca\u63d0\u4f9b\u65e5\u5e38\u5de1\u68c0\u30015*8\u7684\u6280\u672f\u4fdd\u969c\uff0c\u5e38\u89c4\u4e8b\u4ef6\u54cd\u5e94\u65f6\u95f4\uff081\u5c0f\u65f6\u7684\u7535\u8bdd\u54cd\u5e94\uff0c2\u5c0f\u65f6\u5185\u627e\u51fa\u89e3\u51b3\u65b9\u6848\uff09\u3001\u7d27\u6025\u6545\u969c\u5e743\u6b21\u73b0\u573a\u670d\u52a1\u3002","created_by":1013,"created_at":"2025-09-03 11:04:41","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"ndjszcfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1702,"key":1702,"name":"\u539f\u5382\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpPurchaseOrderProduct":{"id":77,"erp_purchase_order_id":2046,"erp_store_id":null,"product_id":2127,"description":"","number":"1","into_inventory":"1","amount":"24000","total_amount":"24000","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":104,"purchase_contract_id":4137,"erp_store_id":null,"erp_purchase_order_product_id":78,"product_id":952,"description":"","number":"5000","amount":"40","total_amount":"200000","erpStore":null,"product":{"id":952,"name":"\u52a8\u6001\u4ee4\u724c","product_type":7,"product_component":153,"product_brand":137,"product_serie":598,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:34:36","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"dtlp","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":598,"key":598,"name":"\u52a8\u6001\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":78,"erp_purchase_order_id":2046,"erp_store_id":null,"product_id":952,"description":"","number":"5000","into_inventory":"5000","amount":"40","total_amount":"200000","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":105,"purchase_contract_id":4137,"erp_store_id":null,"erp_purchase_order_product_id":79,"product_id":2126,"description":"","number":"1","amount":"107000","total_amount":"107000","erpStore":null,"product":{"id":2126,"name":"\u53cc\u56e0\u5b50\u8ba4\u8bc1\u8f6f\u4ef6\uff0dPro","product_type":7,"product_component":153,"product_brand":137,"product_serie":1701,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e13\u4e1a\u7248\u5e73\u53f0\uff0c\u4e0d\u9650\u5236\u5e94\u7528\u6570\u4ee5\u53ca\u7528\u6237\u6570\u63a5\u5165\uff0cExchange\/Citrix\/SSL VPN\/VMWare View\/Web\/\u5821\u5792\u673a\/\u670d\u52a1\u5668\u7b49\u5728\u5e10\u53f7\u5bc6\u7801\u8ba4\u8bc1\u57fa\u7840\u4e0a\u589e\u52a0\u52a8\u6001\u5bc6\u7801\u4fdd\u62a4\u3002\u63d0\u4f9b\u6807\u51c6\u5f97API\u63a5\u53e3\uff1b","created_by":1013,"created_at":"2025-09-03 11:03:06","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"syzrzrjPro","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1701,"key":1701,"name":"\u53cc\u56e0\u5b50\u8ba4\u8bc1\u5e73\u53f0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":79,"erp_purchase_order_id":2046,"erp_store_id":null,"product_id":2126,"description":"","number":"1","into_inventory":"1","amount":"107000","total_amount":"107000","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2046,"serial_no":"CGDD-20250903-00001","from_date":null,"wrote_date":"2025-09-03","handler":1011,"supplier_id":729,"purchase_contract_id":4137,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-03 11:06:36","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"5005","amount":"340000","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-09-03 11:06:02","updated_at":"2025-09-03 11:06:36","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":52,"erp_purchase_order_id":2046,"user_id":1011,"status":1,"description":"","verify_at":"2025-09-03 11:06:36"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"340000","approve_amount":340000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"340000","un_collected":0,"collected_plan":340000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":340000,"product_number":5005,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":3817,"supplier_id":534,"contract_type":3,"signed_at":"2025-03-06","amount":"31000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-03-07 09:42:23","updated_at":"2025-03-21 16:12:02","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"2025022801-TSZHY5","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-21 16:12:02","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"31000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"31000","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3817,"comment":2},"purchaseClientRels":[{"id":3125,"contract_id":3817,"client_id":93,"project_id":3699,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","project_status":3,"budget":"458000","buildContract":{"id":3705,"from_project":3699,"serial_no":"C202411290020"},"clickable":1}}],"purchaseContractPayments":[{"id":"1346","key":"1346","contract_id":3817,"amount":"31000.00","value":"31000.00","collected_date":"2025-04-21 00:00:00","created_at":"2025-03-21 16:07:11","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2183,"key":2183,"contract_id":3817,"amount":"31000","value":"31000","attachment_id":null,"from_date":"2025-03-21","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":1346,"purchase_invoice_id":2183,"amount":"31000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":33102,"object_type":103,"object_id":2183,"attachment_id":24729,"attachment":{"id":24729,"key":24729,"name":"b77960ab-6f41-32ee-81fd-0aefea78cecc","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/b77960ab-6f41-32ee-81fd-0aefea78cecc\/dzfp_25112000000056531134_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250321115958(1).pdf","orig_name":"dzfp_25112000000056531134_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250321115958(1).pdf"}}]}],"contractScans":[{"id":33109,"object_type":108,"object_id":3817,"attachment_id":24430,"attachment":{"id":24430,"key":24430,"name":"fec2c8b7-b47b-3bcd-a616-59c1beab1e82","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/fec2c8b7-b47b-3bcd-a616-59c1beab1e82\/\u62d3\u5b9e \u53cc\u7ae0 \u6280\u672f\u670d\u52a1\u5408\u540c20250228-TSZHY5.pdf","orig_name":"\u62d3\u5b9e \u53cc\u7ae0 \u6280\u672f\u670d\u52a1\u5408\u540c20250228-TSZHY5.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1019,"user_id":1011,"key":1011,"contract_id":3817,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1020,"user_id":5360,"key":5360,"contract_id":3817,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":624,"key":624,"contract_id":3817,"name":"2025-04-21","value":"31000","overdue_days":null,"status":1,"remind_date":"2025-04-21","pct":100,"overdue_display":""}],"paymentApproves":[{"id":1734,"client_id":93,"project_id":3699,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5f00\u5ef6\u652f\uff09","status":2,"next_verify_user":null,"verify_at":"2025-03-21 12:01:38","description":"Tristen\uff0c\u7533\u8bf7\u5f00\u5177\u4e00\u5f2030\u5929\u7684\u5ef6\u671f\u652f\u7968\uff082025.4.21\uff09\u7528\u4e8e\u652f\u4ed8\u98de\u5854\u6280\u672f\u670d\u52a1\u7684\u6b3e\u9879\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-21 12:01:23","updated_at":"2025-03-21 12:01:38","supplier_id":534,"purchase_contract_id":3817,"amount":"31000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"31000","erp_payment_un_settle_amount":"-31000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"31000"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1862,"serial_no":"CGDD-20250307-00001","from_date":null,"wrote_date":"2025-03-06","handler":1011,"supplier_id":534,"purchase_contract_id":3817,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-03-07 09:42:23","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"31000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-03-07 09:42:23","updated_at":"2025-03-21 16:12:02","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"31000","approve_amount":31000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"31000","un_collected":0,"collected_plan":31000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":3723,"supplier_id":614,"contract_type":1,"signed_at":"2024-12-17","amount":"389392.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-12-25 10:25:07","updated_at":"2024-12-25 10:25:24","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BQ-S-2024-12-07-P","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-25 10:25:24","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"389392","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"389392","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":"\u516c\u53f8\u540d\u79f0\uff1a\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91310115690137599D\n\u5730\u5740\u7535\u8bdd\uff1a\u4e0a\u6d77\u5e02\u5f90\u6c47\u533a\u7530\u6797\u8def200\u53f7\u534e\u946b\u5929\u5730A8\u680b 501\u5ba4 021-64958293\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5357\u4eac\u94f6\u884c\u4e0a\u6d77\u5f20\u6c5f\u652f\u884c 0316 2900 0000 1125"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3723,"comment":2},"purchaseClientRels":[{"id":2893,"contract_id":3723,"client_id":93,"project_id":3699,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","project_status":3,"budget":"458000","buildContract":{"id":3705,"from_project":3699,"serial_no":"C202411290020"},"clickable":1}}],"purchaseContractPayments":[{"id":"1337","key":"1337","contract_id":3723,"amount":"389392.00","value":"389392.00","collected_date":"2025-01-06 00:00:00","created_at":"2025-03-13 11:50:52","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2108,"key":2108,"contract_id":3723,"amount":"389392","value":"389392","attachment_id":null,"from_date":"2025-01-15","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4882,"purchase_invoice_id":2108,"amount":"389392","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31864,"object_type":103,"object_id":2108,"attachment_id":23768,"attachment":{"id":23768,"key":23768,"name":"287e65d7-b68e-3ed7-a7d8-48ebc5416e97","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/287e65d7-b68e-3ed7-a7d8-48ebc5416e97\/dzfp_25312000000019454290_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250115172716.pdf","orig_name":"dzfp_25312000000019454290_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250115172716.pdf"}}]}],"contractScans":[{"id":31315,"object_type":108,"object_id":3723,"attachment_id":23382,"attachment":{"id":23382,"key":23382,"name":"564da100-044c-314a-821c-d983bd5502e7","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/564da100-044c-314a-821c-d983bd5502e7\/2024_12_25_10_18_58.pdf","orig_name":"2024_12_25_10_18_58.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":853,"user_id":1011,"key":1011,"contract_id":3723,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":854,"user_id":5360,"key":5360,"contract_id":3723,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":530,"key":530,"contract_id":3723,"name":"2025-02-28","value":"389392","overdue_days":13,"status":1,"remind_date":"2025-02-28","pct":100,"overdue_display":"\u903e\u671f13\u5929"}],"paymentApproves":[{"id":1553,"client_id":93,"project_id":3699,"title":"\u5f00\u5ef6\u652f\u7533\u8bf7-\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-01-03 17:04:26","description":"Tristen\uff0c\u5eb7\u9f99\u8bbe\u5907\u51c6\u5907\u63d0\u8d27\uff0c\u8ddf\u7528\u6237\u5546\u5b9a\u4e0b\u5468\u4e8c\u5b89\u6392\u9001\u8d27\u3002\u7533\u8bf7\u5f00\u5177\u4e00\u5f20\u81ea1\u67087\u65e5\u8d77\u7b9765\u5929\u7684\u5ef6\u671f\u652f\u7968\uff082025\u5e743\u670813\u65e5\uff09\uff0c\u91d1\u989d\uffe5389392\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u5fd8\uff1a\u7eb8\u8d28\u652f\u51fa\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-01-03 15:22:35","updated_at":"2025-01-03 17:04:26","supplier_id":614,"purchase_contract_id":3723,"amount":"389392","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"389392","erp_payment_un_settle_amount":"-389392","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"389392"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1818,"serial_no":"CGDD-20241225-00001","from_date":null,"wrote_date":"2024-12-17","handler":1011,"supplier_id":614,"purchase_contract_id":3723,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-12-25 10:25:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"389392.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-12-25 10:25:07","updated_at":"2024-12-25 10:25:24","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"389392","approve_amount":389392,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"389392","un_collected":0,"collected_plan":389392,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":3687,"supplier_id":68,"contract_type":1,"signed_at":"2024-12-03","amount":"377200.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-12-03 16:44:39","updated_at":"2025-01-21 09:21:54","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BJ7067IM202401203-01","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-21 09:21:54","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"377200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"377200","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3687,"comment":5},"purchaseClientRels":[{"id":3200,"contract_id":3687,"client_id":93,"project_id":3700,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3700,"key":3700,"name":"ADME \u5b9e\u9a8c\u5ba4\u5907\u4efd\u66ff\u6362","project_status":3,"budget":"550000","buildContract":{"id":3679,"from_project":3700,"serial_no":"TS-ZHY-2024112101"},"clickable":1}}],"purchaseContractPayments":[{"id":"1296","key":"1296","contract_id":3687,"amount":"377200.00","value":"377200.00","collected_date":"2025-02-10 00:00:00","created_at":"2025-02-10 16:26:22","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2091,"key":2091,"contract_id":3687,"amount":"376920","value":"376920","attachment_id":null,"from_date":"2024-12-30","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4854,"purchase_invoice_id":2091,"amount":"376920","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31475,"object_type":103,"object_id":2091,"attachment_id":23485,"attachment":{"id":23485,"key":23485,"name":"f3d4bf15-27c7-377c-9992-f5ea2fd2b715","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/f3d4bf15-27c7-377c-9992-f5ea2fd2b715\/20241230-24312000000417314601.pdf","orig_name":"20241230-24312000000417314601.pdf"}}]},{"id":2093,"key":2093,"contract_id":3687,"amount":"280","value":"280","attachment_id":null,"from_date":"2025-01-03","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":1207,"purchase_invoice_id":2093,"amount":"280","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31542,"object_type":103,"object_id":2093,"attachment_id":23533,"attachment":{"id":23533,"key":23533,"name":"11657c32-ede5-3458-9c53-5082eef1eee2","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/11657c32-ede5-3458-9c53-5082eef1eee2\/280.pdf","orig_name":"280.pdf"}}]}],"contractScans":[{"id":31654,"object_type":108,"object_id":3687,"attachment_id":23605,"attachment":{"id":23605,"key":23605,"name":"75f98c35-d1b9-35e9-a22e-258f1168b01e","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/75f98c35-d1b9-35e9-a22e-258f1168b01e\/BJ7607-377200(\u5df2\u7b7e\u7f72).pdf","orig_name":"BJ7607-377200(\u5df2\u7b7e\u7f72).pdf"}}],"receiptScans":[{"id":31521,"object_type":111,"object_id":3687,"attachment_id":23512,"attachment":{"id":23512,"key":23512,"name":"4298090f-1a28-3a63-9e43-b0b323df636d","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/4298090f-1a28-3a63-9e43-b0b323df636d\/2025_01_02_11_46_07.pdf","orig_name":"2025_01_02_11_46_07.pdf"}},{"id":31522,"object_type":111,"object_id":3687,"attachment_id":23513,"attachment":{"id":23513,"key":23513,"name":"6bd8fc8b-ab84-355b-955f-824d4da8b56b","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/6bd8fc8b-ab84-355b-955f-824d4da8b56b\/2024_12_30_12_57_52.pdf","orig_name":"2024_12_30_12_57_52.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":913,"user_id":1011,"key":1011,"contract_id":3687,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":914,"user_id":5360,"key":5360,"contract_id":3687,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":561,"key":561,"contract_id":3687,"name":"2025-02-10","value":"377200","overdue_days":0,"status":1,"remind_date":"2025-02-10","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":1618,"client_id":93,"project_id":3700,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u82f1\u8fc8","status":2,"next_verify_user":null,"verify_at":"2025-02-10 09:52:16","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u5eb7\u9f99\u5316\u6210-\u7fa4\u6656\u8bbe\u5907\u91c7\u8d2d\u8d27\u6b3e\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-02-10 09:41:45","updated_at":"2025-02-10 09:52:16","supplier_id":68,"purchase_contract_id":3687,"amount":"377200","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"377200","erp_payment_un_settle_amount":"-377200","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"377200"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1798,"serial_no":"CGDD-20241203-00001","from_date":null,"wrote_date":"2024-12-03","handler":1011,"supplier_id":68,"purchase_contract_id":3687,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-12-03 16:44:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"377200.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-12-03 16:44:39","updated_at":"2025-01-21 09:21:54","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"377200","approve_amount":377200,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"377200","un_collected":0,"collected_plan":377200,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":3461,"supplier_id":534,"contract_type":3,"signed_at":"2024-08-09","amount":"60000.00","handler":1011,"description":"","contract_scan":null,"created_by":5360,"created_at":"2024-08-09 17:36:37","updated_at":"2024-08-13 15:47:55","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20240809-TSZHY5","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-08-13 15:47:55","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"60000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"60000","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3461,"comment":3},"purchaseClientRels":[{"id":2412,"contract_id":3461,"client_id":93,"project_id":3417,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3417,"key":3417,"name":"\u8fb9\u754c\u9632\u706b\u5899\u66ff\u6362","project_status":3,"budget":"2630000","buildContract":{"id":3325,"from_project":3417,"serial_no":"C202405150012"},"clickable":1}}],"purchaseContractPayments":[{"id":"183","key":"183","contract_id":3461,"amount":"12000.00","value":"12000.00","collected_date":"2024-08-15 00:00:00","created_at":"2024-08-15 10:20:29","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":20},{"id":"176","key":"176","contract_id":3461,"amount":"48000.00","value":"48000.00","collected_date":"2024-08-15 00:00:00","created_at":"2024-08-15 10:04:58","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":80}],"purchaseContractInvoices":[{"id":1834,"key":1834,"contract_id":3461,"amount":"60000","value":"60000","attachment_id":null,"from_date":"2024-08-15","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":228,"purchase_invoice_id":1834,"amount":"60000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":28114,"object_type":103,"object_id":1834,"attachment_id":20946,"attachment":{"id":20946,"key":20946,"name":"01ff688e-0af9-3b96-b0af-60080ffa3519","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/01ff688e-0af9-3b96-b0af-60080ffa3519\/\u53d1\u7968 \u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"\u53d1\u7968 \u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":27752,"object_type":108,"object_id":3461,"attachment_id":20808,"attachment":{"id":20808,"key":20808,"name":"38f90eec-99eb-36a9-aa49-57384f804886","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/38f90eec-99eb-36a9-aa49-57384f804886\/\u62d3\u5b9e \u6280\u672f\u670d\u52a1\u5408\u540c20240809-TSZHY5.pdf","orig_name":"\u62d3\u5b9e \u6280\u672f\u670d\u52a1\u5408\u540c20240809-TSZHY5.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":393,"user_id":1011,"key":1011,"contract_id":3461,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":394,"user_id":5360,"key":5360,"contract_id":3461,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":264,"key":264,"contract_id":3461,"name":"2024-08-15","value":"48000","overdue_days":0,"status":1,"remind_date":"2024-08-15","pct":80,"overdue_display":"\u903e\u671f0\u5929"},{"id":265,"key":265,"contract_id":3461,"name":"2024-09-14","value":"12000","overdue_days":null,"status":1,"remind_date":"2024-09-14","pct":20,"overdue_display":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1659,"serial_no":"CGDD-20240809-00002","from_date":null,"wrote_date":"2024-08-09","handler":1011,"supplier_id":534,"purchase_contract_id":3461,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-08-09 17:36:37","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"60000.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-08-09 17:36:37","updated_at":"2024-08-13 15:47:55","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"60000","approve_amount":0,"un_approve_amount":60000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"60000","un_collected":0,"collected_plan":60000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":3387,"supplier_id":262,"contract_type":1,"signed_at":"2024-07-02","amount":"7909.16","handler":1011,"description":"\u8d60\u9001\u5f90\u8f89","contract_scan":null,"created_by":1011,"created_at":"2024-07-04 17:37:49","updated_at":"2024-07-04 17:38:02","client_id":null,"project_id":null,"sales_rep":null,"serial_no":" 294739496177","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-04 17:38:02","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7909.16","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"7909.16","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3387,"comment":1},"purchaseClientRels":[{"id":2411,"contract_id":3387,"client_id":93,"project_id":3417,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3417,"key":3417,"name":"\u8fb9\u754c\u9632\u706b\u5899\u66ff\u6362","project_status":3,"budget":"2630000","buildContract":{"id":3325,"from_project":3417,"serial_no":"C202405150012"},"clickable":1}}],"purchaseContractPayments":[{"id":"146","key":"146","contract_id":3387,"amount":"7909.16","value":"7909.16","collected_date":"2024-07-08 00:00:00","created_at":"2024-07-08 13:06:18","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1781,"key":1781,"contract_id":3387,"amount":"7909.16","value":"7909.16","attachment_id":null,"from_date":"2024-07-04","description":"","is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4713,"purchase_invoice_id":1781,"amount":"7909.16","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26834,"object_type":103,"object_id":1781,"attachment_id":20073,"attachment":{"id":20073,"key":20073,"name":"7fafc4d7-9f4a-37ec-a444-41d9b0a8a3f8","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/7fafc4d7-9f4a-37ec-a444-41d9b0a8a3f8\/1.pdf","orig_name":"1.pdf"}}]}],"contractScans":[{"id":26833,"object_type":108,"object_id":3387,"attachment_id":20072,"attachment":{"id":20072,"key":20072,"name":"3a96898c-f3fb-39f2-8d2b-707876395514","extension":"png","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/3a96898c-f3fb-39f2-8d2b-707876395514\/WeChat2bccc23e39be4ca93352ed5581ce1940.png","orig_name":"WeChat2bccc23e39be4ca93352ed5581ce1940.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":279,"user_id":1011,"key":1011,"contract_id":3387,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":280,"user_id":5360,"key":5360,"contract_id":3387,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":187,"key":187,"contract_id":3387,"name":"2024-07-11","value":"7909.16","overdue_days":null,"status":1,"remind_date":"2024-07-11","pct":100,"overdue_display":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1617,"serial_no":"CGDD-20240704-00001","from_date":null,"wrote_date":"2024-07-02","handler":1011,"supplier_id":262,"purchase_contract_id":3387,"erp_store_id":null,"status":2,"abstract":null,"description":"\u8d60\u9001\u5f90\u8f89","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-07-04 17:37:49","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"7909.16","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-07-04 17:37:49","updated_at":"2024-07-04 17:38:02","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"7909.16","approve_amount":0,"un_approve_amount":7909.16,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"7909.16","un_collected":0,"collected_plan":7909.16,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false},{"id":3340,"supplier_id":614,"contract_type":1,"signed_at":"2024-05-31","amount":"2009167.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-06-07 11:52:56","updated_at":"2024-11-22 11:10:08","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20240531-HYF-004","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-06-25 09:04:30","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2009167","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2009167","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":"\u516c\u53f8\u540d\u79f0\uff1a\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91310115690137599D\n\u5730\u5740\u7535\u8bdd\uff1a\u4e0a\u6d77\u5e02\u5f90\u6c47\u533a\u7530\u6797\u8def200\u53f7\u534e\u946b\u5929\u5730A8\u680b 501\u5ba4 021-64958293\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5357\u4eac\u94f6\u884c\u4e0a\u6d77\u5f20\u6c5f\u652f\u884c 0316 2900 0000 1125"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3340,"comment":1},"purchaseClientRels":[{"id":2705,"contract_id":3340,"client_id":93,"project_id":3417,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3417,"key":3417,"name":"\u8fb9\u754c\u9632\u706b\u5899\u66ff\u6362","project_status":3,"budget":"2630000","buildContract":{"id":3325,"from_project":3417,"serial_no":"C202405150012"},"clickable":1}}],"purchaseContractPayments":[{"id":"140","key":"140","contract_id":3340,"amount":"2009167.00","value":"2009167.00","collected_date":"2024-08-23 00:00:00","created_at":"2024-06-26 15:57:21","created_by":1011,"description":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1775,"key":1775,"contract_id":3340,"amount":"2009167.00","value":"2009167.00","attachment_id":null,"from_date":"2024-06-26","description":"","is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4709,"purchase_invoice_id":1775,"amount":"2009167.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26725,"object_type":103,"object_id":1775,"attachment_id":19970,"attachment":{"id":19970,"key":19970,"name":"ca4cd12b-4857-344f-a540-c4e657aec417","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/ca4cd12b-4857-344f-a540-c4e657aec417\/dzfp_24312000000189274340_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240626151933.pdf","orig_name":"dzfp_24312000000189274340_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240626151933.pdf"}}]}],"contractScans":[{"id":30605,"object_type":108,"object_id":3340,"attachment_id":22865,"attachment":{"id":22865,"key":22865,"name":"e2682458-136d-3cce-8337-eb3d56ffaeb4","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/e2682458-136d-3cce-8337-eb3d56ffaeb4\/2024_06_07_11_03_12.pdf","orig_name":"2024_06_07_11_03_12.pdf"}}],"receiptScans":[{"id":30606,"object_type":111,"object_id":3340,"attachment_id":19974,"attachment":{"id":19974,"key":19974,"name":"b9c46b69-d330-35d7-ae39-2b88df3c39ff","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/b9c46b69-d330-35d7-ae39-2b88df3c39ff\/2024_06_26_16_44_29.pdf","orig_name":"2024_06_26_16_44_29.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":255,"user_id":1011,"key":1011,"contract_id":3340,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":256,"user_id":5360,"key":5360,"contract_id":3340,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":175,"key":175,"contract_id":3340,"name":"2024-08-23","value":"2009167","overdue_days":null,"status":1,"remind_date":"2024-08-23","pct":100,"overdue_display":""}],"paymentApproves":[{"id":1001,"client_id":93,"project_id":3417,"title":"\u5f00\u5ef6\u652f-\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8 \uffe52009167","status":2,"next_verify_user":null,"verify_at":"2024-06-24 18:23:41","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u65e5\u5f00\u5177\u4e00\u5f2060\u5929\u5ef6\u671f\u652f\u7968\uff0c\u65e5\u671f\uff1a2024\u5e748\u670823\u65e5\u3002\u91d1\u989d\uffe52009167\uff0c\u63d0\u8d27\u660e\u5929\u7528\u4e8e\u7528\u6237\u73b0\u573a\u4ea4\u4ed8\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2024-06-24 17:51:20","updated_at":"2024-06-24 18:23:41","supplier_id":614,"purchase_contract_id":3340,"amount":null,"borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1592,"serial_no":"CGDD-20240607-00001","from_date":null,"wrote_date":"2024-05-31","handler":1011,"supplier_id":614,"purchase_contract_id":3340,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-06-07 11:52:56","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"2009167.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-06-07 11:52:56","updated_at":"2024-11-22 11:10:08","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"2009167.00","approve_amount":0,"un_approve_amount":2009167,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"2009167","un_collected":0,"collected_plan":2009167,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"117.176.186.63","ua":"jinchangxiao\/2.3.156 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-09 21:56:07', 137888000) RETURNING "id"
21:56:07.9253.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340))
21:56:07.8602.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='93') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
21:56:07.9042.7 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_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_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone 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 "t"."status" IN (2, 5) )) "sub") "r" WHERE "contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340) ORDER BY "id" DESC
21:56:07.8642.5 msyii\db\Command::querySELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000)) OR ("pcr"."id" IS NULL)) AND ("pcr"."client_id"='93') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
21:56:07.9321.8 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)) GROUP BY "r"."id"
21:56:07.9081.3 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340) ORDER BY "id"
21:56:07.9671.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)
21:56:07.8691.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "account_number" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (262, 729, 534, 614, 68)
21:56:07.9071.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1011, 5388)
21:56:07.8720.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
21:56:07.9720.9 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4174) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9100.9 msyii\db\Command::querySELECT "id", "purchase_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_purchase_invoice_amounts" WHERE "purchase_invoice_id" IN (1775, 1781, 1834, 2091, 2093, 2108, 2183, 2462, 2546) ORDER BY "id"
21:56:07.8520.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
21:56:07.9730.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4137) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9780.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3387) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9740.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3817) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9750.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3723) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9770.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3461) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9760.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3687) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9790.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3340) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
21:56:07.9000.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340) ORDER BY "id"
21:56:07.9020.7 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3700, 3699, 3488, 3417)
21:56:07.9360.7 msyii\db\Command::querySELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)) ORDER BY "id"
21:56:07.9700.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)
21:56:07.9290.6 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)
21:56:07.9620.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)
21:56:07.9660.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (76, 77, 78, 79, 109)
21:56:07.8540.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:56:07.9680.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (2046, 1617, 1592, 1659, 1798, 1818, 1862, 2063) ORDER BY "id"
21:56:07.9310.4 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340) ORDER BY "remind_date"
21:56:07.9630.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (942, 2127, 952, 2126, 2139)
21:56:07.9700.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (2046, 1617, 1592, 1659, 1798, 1818, 1862, 2063) ORDER BY "id"
21:56:07.9020.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3417, 3699, 3700, 3488)
21:56:07.9200.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19970, 20073, 20946, 23485, 23533, 23768, 24729, 28650, 29871)
21:56:07.9710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id" IN (4174, 4137, 3817, 3723, 3687, 3461, 3387, 3340)
21:56:07.9250.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22865, 20072, 20808, 23382, 23605, 24430, 27993, 28568)
21:56:07.9010.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
21:56:07.8520.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:56:07.8700.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
21:56:07.9300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
21:56:07.8710.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011))
21:56:07.9290.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19974, 23512, 23513)
21:56:07.9640.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 19, 22, 23)
21:56:07.9650.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1701, 593, 1702, 1708, 598)
21:56:07.8730.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
21:56:07.9650.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (137, 134, 264)
21:56:07.9690.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (2046, 1617, 1592, 1659, 1798, 1818, 1862, 2063) ORDER BY "id"
21:56:07.9650.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (153, 151, 189, 195)
21:56:07.9310.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011))
21:56:07.9660.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 7, 8, 9)
21:56:07.8710.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3