Performance Profiling

Total processing time: 147 ms; Peak memory: 6.707 MB. Show Profiling Timeline

总计61条数据

Time	Duration	Category	Info

20:46:47.035	23.0 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)) GROUP BY "object_id"
20:46:47.096	17.3 ms	yii\db\Command::query	SELECT "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 (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)) GROUP BY "object_id"
20:46:47.151	4.9 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/purchase-contract/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","id":"2553","page":"1","posttime":"1784205952","token":"863b2f91062ec2db0a3889ac192e0888","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":4376,"supplier_id":756,"contract_type":1,"signed_at":"2026-07-14","amount":"332380","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2026-01-12 16:20:20","updated_at":"2026-07-16 17:31:40","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20260112-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2026-01-12 16:24:10","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1","erp_un_settle_amount":"332379","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2","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":756,"key":756,"name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\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":4376,"comment":6},"purchaseClientRels":[{"id":4820,"contract_id":4376,"client_id":2553,"project_id":4096,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":4096,"key":4096,"name":"\u6a21\u5757\u91c7\u8d2d","project_status":3,"budget":"1400","buildContract":{"id":4373,"from_project":4096,"serial_no":"2026-01-12-001"},"clickable":1}}],"purchaseContractPayments":[{"id":"12387","key":"12387","contract_id":4376,"amount":"1","value":"1","collected_date":"2026-05-12 00:00:00","created_at":"2026-05-12 13:05:02","created_by":1001,"description":"\u6d4b\u8bd5","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0}],"purchaseContractInvoices":[],"contractScans":[{"id":57749,"object_type":108,"object_id":4376,"attachment_id":32848,"attachment":{"id":32848,"key":32848,"name":"7eeb1247-7834-31c4-a7f0-69928d48919e","extension":"png","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7eeb1247-7834-31c4-a7f0-69928d48919e\/file-read-5423.png","orig_name":"file-read-5423.png"}},{"id":57750,"object_type":108,"object_id":4376,"attachment_id":32849,"attachment":{"id":32849,"key":32849,"name":"2ce5bf31-14ac-3be4-8d6c-7e21d5caf7ca","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2ce5bf31-14ac-3be4-8d6c-7e21d5caf7ca\/\u62d3\u5b9e-\u4e2d\u521b\u6da6\u9526\u5408\u540c20260714.pdf","orig_name":"\u62d3\u5b9e-\u4e2d\u521b\u6da6\u9526\u5408\u540c20260714.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1822,"user_id":1011,"key":1011,"contract_id":4376,"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":1823,"user_id":5360,"key":5360,"contract_id":4376,"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":1066,"key":1066,"contract_id":4376,"name":"2026-02-12","value":"380","overdue_days":154,"status":0,"remind_date":"2026-02-12","pct":0.11,"overdue_display":"\u903e\u671f154\u5929"}],"paymentApproves":[{"id":2778,"client_id":null,"project_id":null,"title":"\u6d4b\u8bd5","status":2,"next_verify_user":null,"verify_at":"2026-06-18 09:36:56","description":"\u6d4b\u8bd5","refuse_description":null,"is_resubmited":false,"created_by":1001,"created_at":"2026-06-18 09:36:52","updated_at":"2026-06-18 09:36:56","supplier_id":756,"purchase_contract_id":4376,"amount":"1","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"1","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":[{"id":527,"purchase_contract_id":4376,"erp_store_id":null,"erp_purchase_order_product_id":337,"product_id":984,"description":"","number":"2","amount":"190","total_amount":"380.00","erpStore":null,"product":{"id":984,"name":"PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","product_type":4,"product_component":43,"product_brand":8,"product_serie":612,"product_misc":null,"product_qa":null,"pn":"","description":"SFP form factor, LX 1Gb optical transceiver, 10Km reach, SMF, duplex LC, IEEE 802.3ab 1000BASE-LX compliant","created_by":1013,"created_at":"2023-08-09 15:26:41","updated_at":"2026-01-12 16:41:06","pinyin_shortcut":"PANSFPLXdsfmk","product_unit":3,"is_renew":false,"in_out_at":"2026-01-12 16:41:06.766587+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":612,"key":612,"name":"PAN-SFP-LX"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":337,"erp_purchase_order_id":2164,"erp_store_id":null,"product_id":984,"description":"","number":"2","into_inventory":"2","amount":"190","total_amount":"380.00","last_number":"2","last_amount":"190","last_total_amount":"380.00"}},{"id":528,"purchase_contract_id":4376,"erp_store_id":null,"erp_purchase_order_product_id":452,"product_id":2195,"description":"\u914d\u7f6e\u5305\u62ec2\u6d77\u51497490(64c, 2.7GHz)\/832G\/14TSATA\/11.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/43000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002","number":"1","amount":"332000","total_amount":"332000.00","erpStore":null,"product":{"id":2195,"name":"CS5280H3","product_type":2,"product_component":2,"product_brand":24,"product_serie":1743,"product_misc":null,"product_qa":null,"pn":"","description":"\u914d\u7f6e2 \u9897\u6d77\u5149C86-4G\uff085480\uff09\u5904\u7406\u5668\uff0c\u6bcf\u9897 CPU \u6838\u5fc3\u6570\u4e3a32\u6838\uff0c\u4e3b\u98912.5GHz\uff0c\u4e09\u7ea7\u7f13\u5b5864MB\uff0cCPU(\u4e2d\u592e\u5904\u7406\u5668)\u652f\u6301\u590d\u6742\u6307\u4ee4\u96c6\uff0c\u5185\u7f6e\u5bc6\u7801\u8fd0\u7b97\u52a0\u901f\u6a21\u5757\uff0c\u652f\u6301\u56fd\u5bc6\u7b97\u6cd5\uff08SM2\u3001SM3\u3001SM4\uff09\u786c\u4ef6\u52a0\u901f","created_by":1013,"created_at":"2025-12-10 16:33:25","updated_at":"2025-12-30 14:48:11","pinyin_shortcut":"CS5280H3","product_unit":1,"is_renew":false,"in_out_at":"2025-12-30 14:48:11.900705+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":1743,"key":1743,"name":"CS5280H3\u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":452,"erp_purchase_order_id":2164,"erp_store_id":null,"product_id":2195,"description":"\u914d\u7f6e\u5305\u62ec2\u6d77\u51497490(64c, 2.7GHz)\/832G\/14TSATA\/11.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/43000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002","number":"1","into_inventory":"0","amount":"332000","total_amount":"332000.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2164,"serial_no":"CGDD-20260112-00003","from_date":null,"wrote_date":null,"handler":1011,"supplier_id":756,"purchase_contract_id":4376,"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":"2026-01-12 16:24:16","stop_at":"2026-07-16 17:31:40.509291+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"3","amount":"332380","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":false,"created_at":"2026-01-12 16:23:59","updated_at":"2026-07-16 17:31:40","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":170,"erp_purchase_order_id":2164,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-12 16:24:16","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"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":null,"approve_amount":1,"un_approve_amount":332379,"un_invoiced":332380,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1","un_collected":332379,"collected_plan":380,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":332380,"product_number":3,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_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":332378,"advance_purchase":false,"can_view_verify_list":true,"verifyList":[{"id":170,"erp_purchase_order_id":2164,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-12 16:24:16","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":4098,"supplier_id":608,"contract_type":1,"signed_at":"2025-08-19","amount":"365","handler":1011,"description":"\u82f1\u6807\u63d2\u5934\uff0c10A\u7535\u6e90\u7ebf","contract_scan":null,"created_by":1011,"created_at":"2025-08-19 15:53:43","updated_at":"2025-08-19 15:53:54","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u8ba2\u5355\u53f7: 4692052404660161702","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-19 15:53:54","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"365","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":"365","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":608,"key":608,"name":"\u6dd8\u5b9d\u7f51","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":4098,"comment":2},"purchaseClientRels":[{"id":4486,"contract_id":4098,"client_id":2553,"project_id":3751,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","project_status":3,"budget":"885300","buildContract":{"id":4055,"from_project":3751,"serial_no":"W-KJ-CG-KXMTYB-20250729-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"12101","key":"12101","contract_id":4098,"amount":"365","value":"365","collected_date":"2025-08-21 00:00:00","created_at":"2025-08-21 14:36:52","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u6dd8\u5b9d\u7f51","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2415,"key":2415,"contract_id":4098,"amount":"365","value":"365","attachment_id":null,"from_date":"2025-08-21","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":1940,"purchase_invoice_id":2415,"amount":"365","tax_rate":"1"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":48742,"object_type":103,"object_id":2415,"attachment_id":27715,"attachment":{"id":27715,"key":27715,"name":"0f4026ad-a3f9-398a-a8cd-676626f3813e","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0f4026ad-a3f9-398a-a8cd-676626f3813e\/\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_4692052404660161702.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_4692052404660161702.pdf"}}]}],"contractScans":[{"id":48628,"object_type":108,"object_id":4098,"attachment_id":27614,"attachment":{"id":27614,"key":27614,"name":"eec80693-f717-3681-bf24-86ebad5a5873","extension":"png","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/eec80693-f717-3681-bf24-86ebad5a5873\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1419,"user_id":1011,"key":1011,"contract_id":4098,"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":1420,"user_id":5360,"key":5360,"contract_id":4098,"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":838,"key":838,"contract_id":4098,"name":"2025-08-23","value":"365","overdue_days":null,"status":1,"remind_date":"2025-08-23","pct":100,"overdue_display":""}],"paymentApproves":[{"id":2168,"client_id":2553,"project_id":3751,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":null,"verify_at":"2025-08-20 13:11:53","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed820\u6761\u7535\u6e90\u7ebf\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5365\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-08-20 12:41:33","updated_at":"2025-08-20 13:11:53","supplier_id":608,"purchase_contract_id":4098,"amount":"365","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"365","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":"365"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":56,"purchase_contract_id":4098,"erp_store_id":null,"erp_purchase_order_product_id":30,"product_id":2010,"description":"","number":"20","amount":"18.25","total_amount":"365","erpStore":null,"product":{"id":2010,"name":"10A\u4e09\u63d2\u5934\u8f6c16A\u4e09\u5b54C19 \u670d\u52a1\u5668\u7535\u6e90\u7ebf","product_type":18,"product_component":201,"product_brand":249,"product_serie":1641,"product_misc":null,"product_qa":null,"pn":"","description":" 3*1.5\u5e73\u65b9 1.8\u7c73","created_by":1013,"created_at":"2025-06-19 14:23:37","updated_at":"2025-08-21 13:54:21","pinyin_shortcut":"10Asctz16AskC19fwqdyx","product_unit":6,"is_renew":false,"in_out_at":"2025-08-21 13:54:21+08","productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":201,"key":201,"name":"\u673a\u623f\u7406\u7ebf\u6750\u6599\u5de5\u5177"},"productBrand":{"id":249,"key":249,"name":"\u5e7f\u660c\u5174"},"productSerie":{"id":1641,"key":1641,"name":"\u7535\u6e90\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":30,"erp_purchase_order_id":2020,"erp_store_id":null,"product_id":2010,"description":"","number":"20","into_inventory":"20","amount":"18.25","total_amount":"365","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2020,"serial_no":"CGDD-20250819-00002","from_date":null,"wrote_date":"2025-08-19","handler":1011,"supplier_id":608,"purchase_contract_id":4098,"erp_store_id":null,"status":2,"abstract":null,"description":"\u82f1\u6807\u63d2\u5934\uff0c10A\u7535\u6e90\u7ebf","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-20 14:59:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":true,"number":"20","amount":"365","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 15:53:44","updated_at":"2025-08-20 14:59:46","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":17,"erp_purchase_order_id":2020,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-19 15:54:13","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":18,"erp_purchase_order_id":2020,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:59: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"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"365","approve_amount":365,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"365","un_collected":0,"collected_plan":365,"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":365,"product_number":20,"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,"can_view_verify_list":true,"verifyList":[{"id":17,"erp_purchase_order_id":2020,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-19 15:54:13","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":18,"erp_purchase_order_id":2020,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:59: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":4056,"supplier_id":90,"contract_type":1,"signed_at":"2025-07-04","amount":"384646","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-07-21 14:46:04","updated_at":"2025-08-22 09:55:11","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2025SBQ18249","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-22 09:55:11","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"384646","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":"384646","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":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\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":4056,"comment":6},"purchaseClientRels":[{"id":4485,"contract_id":4056,"client_id":2553,"project_id":3751,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","project_status":3,"budget":"885300","buildContract":{"id":4055,"from_project":3751,"serial_no":"W-KJ-CG-KXMTYB-20250729-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"12181","key":"12181","contract_id":4056,"amount":"384646","value":"384646","collected_date":"2025-10-24 00:00:00","created_at":"2025-10-24 11:53:56","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u7d2b\u5149\u6653\u901a","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2414,"key":2414,"contract_id":4056,"amount":"384646","value":"384646","attachment_id":null,"from_date":"2025-08-21","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4966,"purchase_invoice_id":2414,"amount":"384646","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":48734,"object_type":103,"object_id":2414,"attachment_id":27709,"attachment":{"id":27709,"key":27709,"name":"e0ee63de-8f88-3d88-8177-03c0b29c39e8","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e0ee63de-8f88-3d88-8177-03c0b29c39e8\/384646.pdf","orig_name":"384646.pdf"}}]}],"contractScans":[{"id":48394,"object_type":108,"object_id":4056,"attachment_id":26993,"attachment":{"id":26993,"key":26993,"name":"b231d6be-582a-39bf-a8da-c1874599343f","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b231d6be-582a-39bf-a8da-c1874599343f\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":48711,"object_type":111,"object_id":4056,"attachment_id":27681,"attachment":{"id":27681,"key":27681,"name":"e5d80de4-0f2a-3f50-88cf-67ee5ccf11a0","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e5d80de4-0f2a-3f50-88cf-67ee5ccf11a0\/document(7).pdf","orig_name":"document(7).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1441,"user_id":1011,"key":1011,"contract_id":4056,"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":1442,"user_id":5360,"key":5360,"contract_id":4056,"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":849,"key":849,"contract_id":4056,"name":"2025-10-12","value":"384646","overdue_days":12,"status":1,"remind_date":"2025-10-12","pct":100,"overdue_display":"\u903e\u671f12\u5929"}],"paymentApproves":[{"id":2354,"client_id":2553,"project_id":3751,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-10-24 11:51:45","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u2014PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d384646\u5143\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-10-24 11:48:51","updated_at":"2025-10-24 11:51:45","supplier_id":90,"purchase_contract_id":4056,"amount":"384646","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"384646","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":"384646"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":16,"purchase_contract_id":4056,"erp_store_id":null,"erp_purchase_order_product_id":8,"product_id":2055,"description":"","number":"10","amount":"13200.00","total_amount":"132000","erpStore":null,"product":{"id":2055,"name":"PAN-PA-445","product_type":5,"product_component":26,"product_brand":8,"product_serie":1663,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-445","created_by":1013,"created_at":"2025-07-21 14:49:47","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA445","product_unit":1,"is_renew":false,"in_out_at":"2025-08-15 11:54:21+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1663,"key":1663,"name":"PA-445\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":8,"erp_purchase_order_id":1993,"erp_store_id":null,"product_id":2055,"description":"","number":"10","into_inventory":"10","amount":"13200.00","total_amount":"132000","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":17,"purchase_contract_id":4056,"erp_store_id":null,"erp_purchase_order_product_id":9,"product_id":2058,"description":"","number":"10","amount":"16764.60","total_amount":"167646","erpStore":null,"product":{"id":2058,"name":"PAN-PA-445-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1664,"product_misc":null,"product_qa":null,"pn":"","description":"PA-445, Precision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, Advanced DNS Security and Advanced SD-WAN ), 3 years (36 months) term","created_by":1013,"created_at":"2025-07-21 14:53:01","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA445BNDCORESEC3YR","product_unit":3,"is_renew":false,"in_out_at":"2025-08-15 11:54:21+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1664,"key":1664,"name":"PA445\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":9,"erp_purchase_order_id":1993,"erp_store_id":null,"product_id":2058,"description":"","number":"10","into_inventory":"10","amount":"16764.60","total_amount":"167646","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":18,"purchase_contract_id":4056,"erp_store_id":null,"erp_purchase_order_product_id":10,"product_id":2056,"description":"","number":"10","amount":"800","total_amount":"8000","erpStore":null,"product":{"id":2056,"name":"PAN-PA-400-POE-PWR-150W","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":null,"product_qa":null,"pn":"","description":"150W Power Adaptor for PoE Enabled PA-415, PA-445, and PA-415-5G","created_by":1013,"created_at":"2025-07-21 14:50:36","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA400POEPWR150W","product_unit":3,"is_renew":false,"in_out_at":"2025-08-15 11:54:21+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":10,"erp_purchase_order_id":1993,"erp_store_id":null,"product_id":2056,"description":"","number":"10","into_inventory":"10","amount":"800","total_amount":"8000","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":19,"purchase_contract_id":4056,"erp_store_id":null,"erp_purchase_order_product_id":11,"product_id":2059,"description":"","number":"10","amount":"6900.00","total_amount":"69000","erpStore":null,"product":{"id":2059,"name":"PAN-SVC-PREM-445-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1665,"product_misc":null,"product_qa":null,"pn":"","description":"PA-445, Premium support, 3 years (36 months) term","created_by":1013,"created_at":"2025-07-21 14:55:55","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANSVCPREM4453YR","product_unit":3,"is_renew":false,"in_out_at":"2025-08-15 11:54:21+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1665,"key":1665,"name":"PA445\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":11,"erp_purchase_order_id":1993,"erp_store_id":null,"product_id":2059,"description":"","number":"10","into_inventory":"10","amount":"6900.00","total_amount":"69000","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":20,"purchase_contract_id":4056,"erp_store_id":null,"erp_purchase_order_product_id":12,"product_id":2057,"description":"","number":"10","amount":"800","total_amount":"8000","erpStore":null,"product":{"id":2057,"name":"PAN-PA-400-POE-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":null,"product_qa":null,"pn":"","description":"Rack-Mountable Tray for PoE enabled PA-415 and PA-445","created_by":1013,"created_at":"2025-07-21 14:51:17","updated_at":"2025-08-15 11:54:21","pinyin_shortcut":"PANPA400POERACKTRAY","product_unit":3,"is_renew":false,"in_out_at":"2025-08-15 11:54:21+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":12,"erp_purchase_order_id":1993,"erp_store_id":null,"product_id":2057,"description":"","number":"10","into_inventory":"10","amount":"800","total_amount":"8000","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":1993,"serial_no":"CGDD-20250721-00004","from_date":null,"wrote_date":"2025-07-04","handler":1011,"supplier_id":90,"purchase_contract_id":4056,"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-07-21 14:46:04","stop_at":"2025-08-12 16:27:51.584254+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":true,"number":"50","amount":"384646","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":true,"created_at":"2025-07-21 14:46:04","updated_at":"2025-08-12 16:27:51","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"384646","approve_amount":384646,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"384646","un_collected":0,"collected_plan":384646,"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":384646,"product_number":50,"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,"can_view_verify_list":true,"verifyList":[]},{"id":3726,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"51606.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-12-25 14:47:02","updated_at":"2025-01-07 11:07:51","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2024SBQ37023","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-07 11:07:51","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"51606","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":"51606","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":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\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":3726,"comment":4},"purchaseClientRels":[{"id":3108,"contract_id":3726,"client_id":2553,"project_id":3752,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3752,"key":3752,"name":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee","project_status":3,"budget":"87000","buildContract":{"id":3725,"from_project":3752,"serial_no":"W-KJ-CG-HS-20241224-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"1311","key":"1311","contract_id":3726,"amount":"51606.00","value":"51606.00","collected_date":"2025-02-25 00:00:00","created_at":"2025-02-25 16:42:47","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2085,"key":2085,"contract_id":3726,"amount":"51606","value":"51606","attachment_id":null,"from_date":"2024-12-30","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4999,"purchase_invoice_id":2085,"amount":"51606","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31406,"object_type":103,"object_id":2085,"attachment_id":23440,"attachment":{"id":23440,"key":23440,"name":"47a5a2ee-e149-3eac-afff-80b0f8a99c0e","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/47a5a2ee-e149-3eac-afff-80b0f8a99c0e\/51606.pdf","orig_name":"51606.pdf"}}]}],"contractScans":[{"id":31480,"object_type":108,"object_id":3726,"attachment_id":23490,"attachment":{"id":23490,"key":23490,"name":"0d710a9a-7c30-34f1-98dc-76357124c9fd","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0d710a9a-7c30-34f1-98dc-76357124c9fd\/document (2).pdf","orig_name":"document (2).pdf"}}],"receiptScans":[{"id":31476,"object_type":111,"object_id":3726,"attachment_id":23486,"attachment":{"id":23486,"key":23486,"name":"920446b3-3ba6-3967-803e-1460f2eb09cc","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/920446b3-3ba6-3967-803e-1460f2eb09cc\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":879,"user_id":1011,"key":1011,"contract_id":3726,"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":880,"user_id":5360,"key":5360,"contract_id":3726,"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":544,"key":544,"contract_id":3726,"name":"2025-02-25","value":"51606","overdue_days":0,"status":1,"remind_date":"2025-02-25","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":1659,"client_id":2553,"project_id":3752,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-02-25 10:54:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u9890\u6770\u9e3f\u5229-PA\u9879\u76ee\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d51606\u5143\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-25 10:23:18","updated_at":"2025-02-25 10:54:33","supplier_id":90,"purchase_contract_id":3726,"amount":"51606","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"51606","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":"51606"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1819,"serial_no":"CGDD-20241225-00002","from_date":null,"wrote_date":"2024-12-26","handler":1011,"supplier_id":90,"purchase_contract_id":3726,"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 14:47:02","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"51606.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-12-25 14:47:02","updated_at":"2025-01-07 11:07:51","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"51606","approve_amount":51606,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"51606","un_collected":0,"collected_plan":51606,"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,"can_view_verify_list":true,"verifyList":[]},{"id":3574,"supplier_id":531,"contract_type":1,"signed_at":"2024-10-09","amount":"1200.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-10-09 09:35:10","updated_at":"2024-10-10 11:26:34","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20241009-HYF-002","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-09 09:35:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1200","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":"1200","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":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","account_number":"\u94f6\u884c\u5e10\u53f7\uff1a11001070900056012320\n\u5f00 \u6237 \u884c\uff1a\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e7f\u6e20\u8def\u652f\u884c"},"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":3574,"comment":2},"purchaseClientRels":[{"id":3104,"contract_id":3574,"client_id":2553,"project_id":3644,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","project_status":3,"budget":"120000","buildContract":{"id":3502,"from_project":3644,"serial_no":"W-KJ-CG-ZBL-20240902-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"1135","key":"1135","contract_id":3574,"amount":"1200.00","value":"1200.00","collected_date":"2024-10-12 00:00:00","created_at":"2024-10-12 13:18:36","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1955,"key":1955,"contract_id":3574,"amount":"1200","value":"1200","attachment_id":null,"from_date":"2024-10-11","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":173,"purchase_invoice_id":1955,"amount":"1200","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":29182,"object_type":103,"object_id":1955,"attachment_id":21863,"attachment":{"id":21863,"key":21863,"name":"347c3a62-c8b7-3724-ac2d-8b2ee3c031f6","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/347c3a62-c8b7-3724-ac2d-8b2ee3c031f6\/dzfp_24112000000149152238_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241011095437.pdf","orig_name":"dzfp_24112000000149152238_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241011095437.pdf"}}]}],"contractScans":[{"id":29129,"object_type":108,"object_id":3574,"attachment_id":21825,"attachment":{"id":21825,"key":21825,"name":"3588a80e-00ef-386e-a79b-a3e84bac8190","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/3588a80e-00ef-386e-a79b-a3e84bac8190\/2024_10_10_09_45_59.pdf","orig_name":"2024_10_10_09_45_59.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":565,"user_id":1011,"key":1011,"contract_id":3574,"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":566,"user_id":5360,"key":5360,"contract_id":3574,"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":367,"key":367,"contract_id":3574,"name":"2024-10-10","value":"1200","overdue_days":2,"status":1,"remind_date":"2024-10-10","pct":100,"overdue_display":"\u903e\u671f2\u5929"}],"paymentApproves":[{"id":1263,"client_id":2553,"project_id":3644,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2024-10-10 15:56:39","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u8d27\u6b3e\u91d1\u989d\uffe51200\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2024-10-10 11:38:50","updated_at":"2024-10-10 15:56:39","supplier_id":531,"purchase_contract_id":3574,"amount":"1200","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"1200","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":"1200"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1723,"serial_no":"CGDD-20241009-00001","from_date":null,"wrote_date":"2024-10-09","handler":1011,"supplier_id":531,"purchase_contract_id":3574,"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-10-09 09:35:10","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"1200.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-10-09 09:35:10","updated_at":"2024-10-10 11:26:34","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"1200","approve_amount":1200,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1200","un_collected":0,"collected_plan":1200,"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,"can_view_verify_list":true,"verifyList":[]},{"id":3503,"supplier_id":90,"contract_type":1,"signed_at":"2024-08-28","amount":"103975.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-08-28 13:10:32","updated_at":"2024-10-08 14:31:24","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2024SBQ22541","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-30 15:06:16","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"103975","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":"103975","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":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\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":3503,"comment":3},"purchaseClientRels":[{"id":3103,"contract_id":3503,"client_id":2553,"project_id":3644,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","project_status":3,"budget":"120000","buildContract":{"id":3502,"from_project":3644,"serial_no":"W-KJ-CG-ZBL-20240902-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"1245","key":"1245","contract_id":3503,"amount":"103975.00","value":"103975.00","collected_date":"2024-11-28 00:00:00","created_at":"2024-11-28 09:44:59","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1943,"key":1943,"contract_id":3503,"amount":"103975","value":"103975","attachment_id":null,"from_date":"2024-09-30","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4813,"purchase_invoice_id":1943,"amount":"103975","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":29055,"object_type":103,"object_id":1943,"attachment_id":21774,"attachment":{"id":21774,"key":21774,"name":"7e1362c8-2d63-35cf-8d10-d3a11096e2be","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7e1362c8-2d63-35cf-8d10-d3a11096e2be\/24122000000060563936_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"24122000000060563936_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":29036,"object_type":108,"object_id":3503,"attachment_id":21757,"attachment":{"id":21757,"key":21757,"name":"f1fea02f-5740-3bdb-bce0-c36cb66142b0","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f1fea02f-5740-3bdb-bce0-c36cb66142b0\/103975.pdf","orig_name":"103975.pdf"}}],"receiptScans":[{"id":29068,"object_type":111,"object_id":3503,"attachment_id":21784,"attachment":{"id":21784,"key":21784,"name":"642eb99f-1b0b-31b2-96b7-f950a43768d1","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/642eb99f-1b0b-31b2-96b7-f950a43768d1\/2024_10_08_13_19_53.pdf","orig_name":"2024_10_08_13_19_53.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":559,"user_id":1011,"key":1011,"contract_id":3503,"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":560,"user_id":5360,"key":5360,"contract_id":3503,"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":364,"key":364,"contract_id":3503,"name":"2024-11-28","value":"103975","overdue_days":0,"status":1,"remind_date":"2024-11-28","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":1441,"client_id":2553,"project_id":3644,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2024-11-28 09:36:22","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\u603b\u4ee3\uff1a\u7d2b\u5149\u6653\u901a\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5103975\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u7528\u6237\u8d27\u6b3e\u5c1a\u672a\u6536\u56de\uff0c\u6b64\u9879\u76ee\u6536\u53d6\u5230\u4e00\u5f20\u627f\u5151\u65e5\u671f\uff1a2025-1-24\u3002\u56e0\u57ab\u4ed8\u8d27\u6b3e\u5468\u671f2\u4e2a\u6708\uff0c\u4ece\u5218\u70b3\u5764\u8d39\u7528\u5185\u6263\u96642\u4e2a\u70b9\u8d44\u91d1\u5360\u7528\u8d39\uffe52104\u3002\u56e0\u539f\u8d39\u7528\u5355\u5df2\u5199\uff0c\u4eca\u5929\u548c\u8d22\u52a1\u786e\u8ba4\u597d\u5982\u4f55\u505a\u5355\u636e\uff0c\u8c03\u6574\u8d39\u7528\u6700\u7ec8\u4e3a6615\u5143\u3002\n\u6838\u7b97\u8fc7\u7a0b\uff0c\u8be6\u89c1\u9644\u4ef6\u56fe\u7247\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2024-11-28 09:16:09","updated_at":"2024-11-28 09:36:22","supplier_id":90,"purchase_contract_id":3503,"amount":"103975","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"103975","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":"103975"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1680,"serial_no":"CGDD-20240828-00002","from_date":null,"wrote_date":"2024-08-28","handler":1011,"supplier_id":90,"purchase_contract_id":3503,"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-28 13:10:32","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"103975.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-08-28 13:10:32","updated_at":"2024-10-08 14:31:24","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"103975","approve_amount":103975,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"103975","un_collected":0,"collected_plan":103975,"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,"can_view_verify_list":true,"verifyList":[]},{"id":3403,"supplier_id":531,"contract_type":1,"signed_at":"2024-07-08","amount":"6000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-07-12 11:11:18","updated_at":"2024-07-12 14:01:30","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"IONE-TSKJ-20240708","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-12 11:11:32","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"6000","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":"6000","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":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","account_number":"\u94f6\u884c\u5e10\u53f7\uff1a11001070900056012320\n\u5f00 \u6237 \u884c\uff1a\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e7f\u6e20\u8def\u652f\u884c"},"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":3403,"comment":3},"purchaseClientRels":[{"id":2867,"contract_id":3403,"client_id":2553,"project_id":3591,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3591,"key":3591,"name":"\u5149\u6a21\u5757\u91c7\u8d2d\u9879\u76ee","project_status":3,"budget":"19800","buildContract":{"id":3392,"from_project":3591,"serial_no":"W-KJ-CG-ZBL-20240715-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"150","key":"150","contract_id":3403,"amount":"6000.00","value":"6000.00","collected_date":"2024-07-18 00:00:00","created_at":"2024-07-18 14:18:29","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1791,"key":1791,"contract_id":3403,"amount":"6000.00","value":"6000.00","attachment_id":null,"from_date":"2024-07-12","description":"","is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4721,"purchase_invoice_id":1791,"amount":"6000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":27025,"object_type":103,"object_id":1791,"attachment_id":20227,"attachment":{"id":20227,"key":20227,"name":"2429fd74-f767-33ca-bb5e-edbad157141a","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2429fd74-f767-33ca-bb5e-edbad157141a\/dzfp_24112000000082309249_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240712150023.pdf","orig_name":"dzfp_24112000000082309249_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240712150023.pdf"}}]}],"contractScans":[{"id":27024,"object_type":108,"object_id":3403,"attachment_id":20226,"attachment":{"id":20226,"key":20226,"name":"588e189c-3019-3ce6-acc4-aed922afc373","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/588e189c-3019-3ce6-acc4-aed922afc373\/\u62d3\u5b9e\u5408\u540c-\u626b\u63cf20240712.pdf","orig_name":"\u62d3\u5b9e\u5408\u540c-\u626b\u63cf20240712.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":305,"user_id":1011,"key":1011,"contract_id":3403,"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":306,"user_id":5360,"key":5360,"contract_id":3403,"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":202,"key":202,"contract_id":3403,"name":"2024-07-18","value":"6000","overdue_days":0,"status":1,"remind_date":"2024-07-18","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":1052,"client_id":2553,"project_id":3591,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u2014\uffe56000","status":2,"next_verify_user":null,"verify_at":"2024-07-18 11:51:52","description":"\u8001\u5927\uff0c\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u5149\u6a21\u5757\u91c7\u8d2d\u9879\u76ee\uff0c\u91c7\u8d2d\u6210\u672c6000\u5143\uff0c\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u73b0\u7ed3\u652f\u4ed8\uff0c\u671b\u8bf7\u5ba1\u6279\uff01","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2024-07-18 11:48:09","updated_at":"2024-07-18 11:51:52","supplier_id":531,"purchase_contract_id":3403,"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":1627,"serial_no":"CGDD-20240712-00002","from_date":null,"wrote_date":"2024-07-08","handler":1011,"supplier_id":531,"purchase_contract_id":3403,"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-07-12 11:11:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"6000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-07-12 11:11:18","updated_at":"2024-07-12 14:01:30","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"6000.00","approve_amount":0,"un_approve_amount":6000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"6000","un_collected":0,"collected_plan":6000,"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,"can_view_verify_list":true,"verifyList":[]},{"id":3157,"supplier_id":68,"contract_type":1,"signed_at":"2024-01-22","amount":"94500.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-03-01 16:48:53","updated_at":"2024-03-12 09:54:05","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BJ7067-PA-WXY-20240122","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"94500","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":"94500","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":3157,"comment":1},"purchaseClientRels":[{"id":1817,"contract_id":3157,"client_id":2553,"project_id":3424,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3424,"key":3424,"name":"\u4e2d\u56fd\u7535\u5efa\u5c71\u4e1c\u7535\u5efa\u4e09\u516c\u53f8\u9890\u6770\u9e3f\u5229\u516c\u53f8\u6c99\u7279\u6731\u62dc\u52d2\u4e09A\u9879\u76ee\u9632\u706b\u5899\u91c7\u8d2d\u9879\u76ee","project_status":3,"budget":"120431","buildContract":{"id":3101,"from_project":3424,"serial_no":"W-KJ-CG-ZBL-20240119-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"1794","key":"1794","contract_id":3157,"amount":"94500.00","value":"94500.00","collected_date":"2024-04-19 00:00:00","created_at":"2024-04-19 10:03:00","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1660,"key":1660,"contract_id":3157,"amount":"94500.00","value":"94500.00","attachment_id":null,"from_date":"2024-03-18","description":"","is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4608,"purchase_invoice_id":1660,"amount":"94500.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":24614,"object_type":103,"object_id":1660,"attachment_id":18173,"attachment":{"id":18173,"key":18173,"name":"60b36512-a2bc-3db6-bcb3-8f9610cd71a3","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/60b36512-a2bc-3db6-bcb3-8f9610cd71a3\/20240318-24312000000073527056.pdf","orig_name":"20240318-24312000000073527056.pdf"}}]}],"contractScans":[{"id":24373,"object_type":108,"object_id":3157,"attachment_id":17943,"attachment":{"id":17943,"key":17943,"name":"6976ecc2-246b-3386-9fc6-d75cbcfe98ed","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6976ecc2-246b-3386-9fc6-d75cbcfe98ed\/30-89237-11\u53cc\u7ae0.pdf","orig_name":"30-89237-11\u53cc\u7ae0.pdf"}}],"receiptScans":[{"id":24397,"object_type":111,"object_id":3157,"attachment_id":17959,"attachment":{"id":17959,"key":17959,"name":"8670ab6f-7251-3f7c-8346-bb8461e6a639","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8670ab6f-7251-3f7c-8346-bb8461e6a639\/2024_03_12_09_35_04.pdf","orig_name":"2024_03_12_09_35_04.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1478,"serial_no":"CGDD-20240301-00004","from_date":null,"wrote_date":"2024-01-22","handler":1011,"supplier_id":68,"purchase_contract_id":3157,"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-03-01 16:48:53","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"94500.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-03-01 16:48:53","updated_at":"2024-03-12 09:54:05","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"94500.00","approve_amount":0,"un_approve_amount":94500,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"94500","un_collected":0,"collected_plan":0,"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,"can_view_verify_list":true,"verifyList":[]},{"id":2839,"supplier_id":531,"contract_type":1,"signed_at":"2023-09-12","amount":"2200.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2023-09-12 13:53:03","updated_at":"2023-09-12 13:53:03","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"IONE-TSKJ-0809","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2200","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":"2200","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":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","account_number":"\u94f6\u884c\u5e10\u53f7\uff1a11001070900056012320\n\u5f00 \u6237 \u884c\uff1a\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e7f\u6e20\u8def\u652f\u884c"},"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":null,"purchaseClientRels":[{"id":1514,"contract_id":2839,"client_id":2553,"project_id":3251,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3251,"key":3251,"name":"\u6c99\u7279\u7ea2\u6d77\u516c\u7528\u4e8b\u4e1a\u57fa\u7840\u8bbe\u65bd\u9879\u76ee\u7f51\u7edc\u5b89\u5168\u7cfb\u7edfPA\u8bbe\u5907","project_status":3,"budget":"388462","buildContract":{"id":2742,"from_project":3251,"serial_no":"TSKJ20230707-006"},"clickable":1}}],"purchaseContractPayments":[{"id":"11369","key":"11369","contract_id":2839,"amount":"2200.00","value":"2200.00","collected_date":"2023-09-12 00:00:00","created_at":"2023-09-15 14:05:37","created_by":1001,"description":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":100}],"purchaseContractInvoices":[{"id":1436,"key":1436,"contract_id":2839,"amount":"2200","value":"2200","attachment_id":null,"from_date":"2023-09-11","description":null,"is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4388,"purchase_invoice_id":1436,"amount":"2200","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":20454,"object_type":103,"object_id":1436,"attachment_id":14918,"attachment":{"id":14918,"key":14918,"name":"7dad3581-28d3-3363-ad0e-fe6b3ab4bfea","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7dad3581-28d3-3363-ad0e-fe6b3ab4bfea\/2023_09_12_13_47_40.pdf","orig_name":"2023_09_12_13_47_40.pdf"}}]}],"contractScans":[{"id":20453,"object_type":108,"object_id":2839,"attachment_id":14917,"attachment":{"id":14917,"key":14917,"name":"e8aae984-bdd5-3734-9410-2287ee0dac81","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e8aae984-bdd5-3734-9410-2287ee0dac81\/2023_09_12_13_47_40 2.pdf","orig_name":"2023_09_12_13_47_40 2.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1280,"serial_no":"CGDD-20230912-00001","from_date":null,"wrote_date":"2023-09-12","handler":1011,"supplier_id":531,"purchase_contract_id":2839,"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":"2023-09-12 13:53:03","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"2200.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2023-09-12 13:53:03","updated_at":"2023-09-12 13:53:03","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"2200","approve_amount":0,"un_approve_amount":2200,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"2200","un_collected":0,"collected_plan":0,"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,"can_view_verify_list":true,"verifyList":[]},{"id":2793,"supplier_id":68,"contract_type":1,"signed_at":"2023-07-12","amount":"28318.00","handler":1011,"description":"\u5b9e\u9645\u6210\u672c\uff1a302388\uff0c\u5e2e\u738b\u5bb8\u5e73\u8861274070","contract_scan":null,"created_by":5360,"created_at":"2023-08-07 11:03:32","updated_at":"2023-09-13 15:44:56","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BJ7067-PA-MJ-20230711","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"28318","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":"28318","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":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":null,"purchaseClientRels":[{"id":1483,"contract_id":2793,"client_id":2553,"project_id":3251,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3251,"key":3251,"name":"\u6c99\u7279\u7ea2\u6d77\u516c\u7528\u4e8b\u4e1a\u57fa\u7840\u8bbe\u65bd\u9879\u76ee\u7f51\u7edc\u5b89\u5168\u7cfb\u7edfPA\u8bbe\u5907","project_status":3,"budget":"388462","buildContract":{"id":2742,"from_project":3251,"serial_no":"TSKJ20230707-006"},"clickable":1}}],"purchaseContractPayments":[{"id":"11841","key":"11841","contract_id":2793,"amount":"28318.00","value":"28318.00","collected_date":"2023-10-20 00:00:00","created_at":"2023-10-20 10:29:55","created_by":1014,"description":null,"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":1437,"key":1437,"contract_id":2793,"amount":"28318.00","value":"28318.00","attachment_id":null,"from_date":"2023-09-11","description":null,"is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4389,"purchase_invoice_id":1437,"amount":"28318.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":20484,"object_type":103,"object_id":1437,"attachment_id":14956,"attachment":{"id":14956,"key":14956,"name":"70172cf1-5815-3df6-b66f-97da5f82ff21","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/70172cf1-5815-3df6-b66f-97da5f82ff21\/\u5408\u5e76\u6587\u6863.pdf","orig_name":"\u5408\u5e76\u6587\u6863.pdf"}}]}],"contractScans":[{"id":20457,"object_type":108,"object_id":2793,"attachment_id":14921,"attachment":{"id":14921,"key":14921,"name":"4ec65cf0-d4de-333e-9dd6-1807ffc8ecc2","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4ec65cf0-d4de-333e-9dd6-1807ffc8ecc2\/30-63025-11\u53cc\u7ae0.pdf","orig_name":"30-63025-11\u53cc\u7ae0.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1255,"serial_no":"CGDD-20230807-00003","from_date":null,"wrote_date":"2023-07-12","handler":1011,"supplier_id":68,"purchase_contract_id":2793,"erp_store_id":null,"status":2,"abstract":null,"description":"\u5b9e\u9645\u6210\u672c\uff1a302388\uff0c\u5e2e\u738b\u5bb8\u5e73\u8861274070","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-08-07 11:03:32","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"28318.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2023-08-07 11:03:32","updated_at":"2023-09-13 15:44:56","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"28318.00","approve_amount":0,"un_approve_amount":28318,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"28318","un_collected":0,"collected_plan":0,"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,"can_view_verify_list":true,"verifyList":[]}],"pagenation":{"totalcount":10,"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-16 20:46:47', 138077952) RETURNING "id"
20:46:47.074	4.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1436, 1437, 1660, 1791, 1943, 1955, 2085, 2414, 2415))
20:46:47.070	4.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1436, 1437, 1660, 1791, 1943, 1955, 2085, 2414, 2415))
20:46:47.062	3.8 ms	yii\db\Command::query	SELECT "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 (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793) ORDER BY "id" DESC
20:46:47.080	3.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793))
20:46:47.084	3.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793))
20:46:47.024	2.5 ms	yii\db\Command::query	SELECT 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, 5500, 5301, 5499, 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"='2553') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
20:46:47.092	2.4 ms	yii\db\Command::query	SELECT "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 (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)) GROUP BY "r"."id"
20:46:47.027	2.1 ms	yii\db\Command::query	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, 5500, 5301, 5499, 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"='2553') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
20:46:47.067	1.5 ms	yii\db\Command::query	SELECT "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 (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793) ORDER BY "id"
20:46:47.068	1.2 ms	yii\db\Command::query	SELECT "id", "purchase_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_purchase_invoice_amounts" WHERE "purchase_invoice_id" IN (1436, 1437, 1660, 1791, 1943, 1955, 2085, 2414, 2415) ORDER BY "id"
20:46:47.119	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)
20:46:47.095	0.9 ms	yii\db\Command::query	SELECT "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 (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)) ORDER BY "id"
20:46:47.125	0.8 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4376) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.058	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793) ORDER BY "id"
20:46:47.131	0.8 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3503) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.089	0.8 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)
20:46:47.132	0.8 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3403) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.127	0.8 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4098) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.015	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
20:46:47.128	0.7 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4056) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.133	0.7 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3157) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.130	0.7 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3574) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.114	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)
20:46:47.129	0.7 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3726) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.134	0.7 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2839) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.135	0.7 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2793) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
20:46:47.118	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (8, 9, 10, 11, 12, 30, 337, 452)
20:46:47.091	0.6 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_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793) ORDER BY "remind_date"
20:46:47.124	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)
20:46:47.121	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (2020, 1723, 1993, 1255, 1280, 1478, 1627, 1680, 1819, 2164) ORDER BY "id"
20:46:47.061	0.5 ms	yii\db\Command::query	SELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3752, 3251, 3751, 3591, 3644, 3424, 4096)
20:46:47.032	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "account_number" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (756, 608, 90, 531, 68)
20:46:47.060	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3251, 3424, 3591, 3644, 3752, 3751, 4096)
20:46:47.017	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:46:47.079	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21774, 21863, 14918, 14956, 18173, 20227, 23440, 27709, 27715)
20:46:47.123	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (2020, 1723, 1993, 1255, 1280, 1478, 1627, 1680, 1819, 2164) ORDER BY "id"
20:46:47.084	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21757, 21825, 14917, 14921, 17943, 20226, 23490, 26993, 27614, 32848, 32849)
20:46:47.115	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2055, 2058, 2056, 2059, 2057, 2010, 984, 2195)
20:46:47.066	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001, 5388, 1014)
20:46:47.123	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (2020, 1723, 1993, 1255, 1280, 1478, 1627, 1680, 1819, 2164) ORDER BY "id"
20:46:47.125	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id" IN (4376, 4098, 4056, 3726, 3574, 3503, 3403, 3157, 2839, 2793)
20:46:47.059	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553
20:46:47.090	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 (5360, 1011))
20:46:47.117	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (249, 8, 24)
20:46:47.088	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21784, 17959, 23486, 27681)
20:46:47.117	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1641, 1012, 615, 1665, 1663, 1664, 1743, 612)
20:46:47.014	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:46:47.090	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
20:46:47.033	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 (5360, 1011))
20:46:47.032	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
20:46:47.122	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001)
20:46:47.116	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (18, 5, 2, 4)
20:46:47.116	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (201, 157, 214, 26, 36, 2, 43)
20:46:47.122	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 (1011, 1001))
20:46:47.118	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (6, 3, 1)
20:46:47.034	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"=1011)
20:46:47.034	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
20:46:47.033	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3