ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a5481243fe7f: POST https://beta.jinchangxiao.com/v2/purchase-contract/of-client at 2026-07-13 02:09:40 pm by 39.156.194.178

Performance Profiling

Total processing time: 340 ms; Peak memory: 6.589 MB. Show Profiling Timeline

总计61条数据
TimeDurationCategoryInfo
  
14:09:40.32398.7 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)) GROUP BY "object_id"
14:09:40.47831.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)) GROUP BY "object_id"
14:09:40.28211.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 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"='48') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
14:09:40.5618.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3722) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5285.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (2084, 1563, 1633, 1640, 1713, 1817, 1845, 2156, 2060, 1970) ORDER BY "id"
14:09:40.3124.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "account_number" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (489, 116, 236, 174, 165, 90, 598)
14:09:40.5934.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/purchase-contract/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"48","page":"1","token":"7f1225232aa747f2b24a7cc20a912d28","posttime":"1783922980"}', '{"code":200,"data":{"list":[{"id":4361,"supplier_id":489,"contract_type":1,"signed_at":"2026-01-05","amount":"520","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2026-01-05 17:09:25","updated_at":"2026-02-05 16:43:20","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20260104-HYF-002","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2026-01-05 17:09:38","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","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":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\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":4361,"comment":3},"purchaseClientRels":[{"id":4424,"contract_id":4361,"client_id":48,"project_id":4090,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":4090,"key":4090,"name":"2016\u5b58\u50a8\u786c\u76d8","project_status":3,"budget":"2000","buildContract":{"id":4360,"from_project":4090,"serial_no":"TS-YJC-202601"},"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2724,"key":2724,"contract_id":4361,"amount":"520","value":"520","attachment_id":null,"from_date":"2026-02-05","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2995,"purchase_invoice_id":2724,"amount":"520","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":56289,"object_type":103,"object_id":2724,"attachment_id":31819,"attachment":{"id":31819,"key":31819,"name":"25bd7c43-01df-395f-9a0d-7b626f6ac859","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/25bd7c43-01df-395f-9a0d-7b626f6ac859\/dzfp_26112000000486029896_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20260205155831.pdf","orig_name":"dzfp_26112000000486029896_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20260205155831.pdf"}}]}],"contractScans":[{"id":56300,"object_type":108,"object_id":4361,"attachment_id":31822,"attachment":{"id":31822,"key":31822,"name":"80c90e38-77d2-3c8e-806a-497e1e0f3c59","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/80c90e38-77d2-3c8e-806a-497e1e0f3c59\/2026_02_05_16_40_03.pdf","orig_name":"2026_02_05_16_40_03.pdf"}}],"receiptScans":[{"id":56302,"object_type":111,"object_id":4361,"attachment_id":31824,"attachment":{"id":31824,"key":31824,"name":"9e3ec43f-7da1-3d11-899b-eb6911a1b283","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9e3ec43f-7da1-3d11-899b-eb6911a1b283\/2026_02_05_16_42_56.pdf","orig_name":"2026_02_05_16_42_56.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1806,"user_id":1011,"key":1011,"contract_id":4361,"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":1807,"user_id":5360,"key":5360,"contract_id":4361,"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":1057,"key":1057,"contract_id":4361,"name":"2026-02-04","value":"520","overdue_days":159,"status":0,"remind_date":"2026-02-04","pct":100,"overdue_display":"\u903e\u671f159\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":387,"purchase_contract_id":4361,"erp_store_id":null,"erp_purchase_order_product_id":325,"product_id":41,"description":"","number":"2","amount":"260","total_amount":"520.00","erpStore":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpPurchaseOrderProduct":{"id":325,"erp_purchase_order_id":2156,"erp_store_id":null,"product_id":41,"description":"","number":"2","into_inventory":"2","amount":"260","total_amount":"520.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2156,"serial_no":"CGDD-20260105-00001","from_date":null,"wrote_date":"2026-01-05","handler":1011,"supplier_id":489,"purchase_contract_id":4361,"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-05 17:09:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"2","amount":"520","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2026-01-05 17:09:26","updated_at":"2026-01-05 17:09:52","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":162,"erp_purchase_order_id":2156,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-05 17:09:52","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":"520","approve_amount":0,"un_approve_amount":520,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":520,"collected_plan":520,"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":520,"product_number":2,"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":520,"advance_purchase":false,"verifyList":[{"id":162,"erp_purchase_order_id":2156,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-05 17:09:52","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":4220,"supplier_id":116,"contract_type":1,"signed_at":"2025-10-28","amount":"7500.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-10-29 14:51:17","updated_at":"2025-12-23 10:01:43","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20251028001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-10-29 14:51:56","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7500","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":"7500","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":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\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":4220,"comment":4},"purchaseClientRels":[{"id":4549,"contract_id":4220,"client_id":48,"project_id":3873,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3873,"key":3873,"name":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","project_status":3,"budget":"62075.1","buildContract":{"id":3998,"from_project":3873,"serial_no":"TS-YJC-20250526-001"},"clickable":1}}],"purchaseContractPayments":[{"id":"12189","key":"12189","contract_id":4220,"amount":"7500","value":"7500","collected_date":"2025-10-30 00:00:00","created_at":"2025-10-30 11:17:24","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u957f\u8679\u4f73\u534e","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2548,"key":2548,"contract_id":4220,"amount":"7500","value":"7500","attachment_id":null,"from_date":"2025-11-19","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2190,"purchase_invoice_id":2548,"amount":"7500","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":52737,"object_type":103,"object_id":2548,"attachment_id":29886,"attachment":{"id":29886,"key":29886,"name":"0d6e5737-71bb-3515-8f86-45eb0bc8327a","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0d6e5737-71bb-3515-8f86-45eb0bc8327a\/25512000000277902102(1).pdf","orig_name":"25512000000277902102(1).pdf"}}]}],"contractScans":[{"id":54124,"object_type":108,"object_id":4220,"attachment_id":30766,"attachment":{"id":30766,"key":30766,"name":"6f6e1ef0-08ce-3f72-b5f5-cbd67c6973c7","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6f6e1ef0-08ce-3f72-b5f5-cbd67c6973c7\/2025_12_23_09_45_46.pdf","orig_name":"2025_12_23_09_45_46.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1616,"user_id":1011,"key":1011,"contract_id":4220,"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":1617,"user_id":5360,"key":5360,"contract_id":4220,"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":953,"key":953,"contract_id":4220,"name":"2025-10-30","value":"7500","overdue_days":0,"status":1,"remind_date":"2025-10-30","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":2192,"client_id":48,"project_id":3873,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-10-30 11:15:54","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u4e2d\u90fd\u6570\u79d1\u7eed\u4fdd\u5408\u540c\u51855\u53f0\u670d\u52a1\u5668\u8054\u60f3\u539f\u5382\u8d28\u4fdd\u670d\u52a1\u8d39\uff0c\u91d1\u989d\uff1a\uffe57500\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u4ed8\u6b3e\u4fe1\u606f\uff1a\n\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8\n\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u7ef5\u9633\u5e02\u5206\u884c\u8425\u4e1a\u90e8\n51001658636050348363\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-10-30 10:58:42","updated_at":"2025-10-30 11:15:54","supplier_id":116,"purchase_contract_id":4220,"amount":"7500","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"7500","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":"7500"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":193,"purchase_contract_id":4220,"erp_store_id":null,"erp_purchase_order_product_id":155,"product_id":1376,"description":"","number":"5","amount":"1500","total_amount":"7500.00","erpStore":null,"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e745*9\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e745*9\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpPurchaseOrderProduct":{"id":155,"erp_purchase_order_id":2084,"erp_store_id":null,"product_id":1376,"description":"","number":"5","into_inventory":"5","amount":"1500","total_amount":"7500.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2084,"serial_no":"CGDD-20251029-00005","from_date":null,"wrote_date":null,"handler":1011,"supplier_id":116,"purchase_contract_id":4220,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-10-29 14:52:37","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"5","amount":"7500","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-10-29 14:51:46","updated_at":"2025-10-29 14:52:37","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":90,"erp_purchase_order_id":2084,"user_id":1011,"status":1,"description":"","verify_at":"2025-10-29 14:52:37","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":"7500","approve_amount":7500,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"7500","un_collected":0,"collected_plan":7500,"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":7500,"product_number":5,"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,"verifyList":[{"id":90,"erp_purchase_order_id":2084,"user_id":1011,"status":1,"description":"","verify_at":"2025-10-29 14:52:37","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":4167,"supplier_id":489,"contract_type":1,"signed_at":"2025-09-18","amount":"520","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-09-18 09:39:15","updated_at":"2025-10-23 14:26:55","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250918-HYF-01","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-09-18 09:39:28","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"520","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":"520","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":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\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":4167,"comment":4},"purchaseClientRels":[{"id":4451,"contract_id":4167,"client_id":48,"project_id":3969,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3969,"key":3969,"name":"\u5b58\u50a8\u786c\u76d8\u914d\u4ef6","project_status":3,"budget":"2000","buildContract":{"id":4168,"from_project":3969,"serial_no":"TS-YJC-20250917-01"},"clickable":1}}],"purchaseContractPayments":[{"id":"12177","key":"12177","contract_id":4167,"amount":"520","value":"520","collected_date":"2025-10-24 00:00:00","created_at":"2025-10-24 09:25:18","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u6234\u68ee\u7279","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2507,"key":2507,"contract_id":4167,"amount":"520","value":"520","attachment_id":null,"from_date":"2025-10-23","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2140,"purchase_invoice_id":2507,"amount":"520","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":51488,"object_type":103,"object_id":2507,"attachment_id":29232,"attachment":{"id":29232,"key":29232,"name":"501af101-bc47-3f28-a961-7812fb7787c3","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/501af101-bc47-3f28-a961-7812fb7787c3\/dzfp_25112000000227432576_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20251023132029.pdf","orig_name":"dzfp_25112000000227432576_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20251023132029.pdf"}}]}],"contractScans":[{"id":51463,"object_type":108,"object_id":4167,"attachment_id":29215,"attachment":{"id":29215,"key":29215,"name":"dd4f92e9-f482-3c1b-a537-1050cef79569","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/dd4f92e9-f482-3c1b-a537-1050cef79569\/2025_10_23_14_21_51.pdf","orig_name":"2025_10_23_14_21_51.pdf"}}],"receiptScans":[{"id":51474,"object_type":111,"object_id":4167,"attachment_id":29227,"attachment":{"id":29227,"key":29227,"name":"ca94f935-a435-3adf-9b78-9ce6a7abc454","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/ca94f935-a435-3adf-9b78-9ce6a7abc454\/2025_10_23_14_21_51.pdf","orig_name":"2025_10_23_14_21_51.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1531,"user_id":1011,"key":1011,"contract_id":4167,"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":1532,"user_id":5360,"key":5360,"contract_id":4167,"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":904,"key":904,"contract_id":4167,"name":"2025-10-18","value":"520","overdue_days":6,"status":1,"remind_date":"2025-10-18","pct":100,"overdue_display":"\u903e\u671f6\u5929"}],"paymentApproves":[{"id":2348,"client_id":48,"project_id":3969,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-10-23 17:14:00","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u786c\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5520\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a8\u5f20\u4e0d\u540c\u65f6\u671f\u7684\u91c7\u8d2d\u5408\u540c\uff0c\u5408\u5e76\u4ed8\u6b3e\uff0c\u652f\u51fa\u51ed\u5355\u8be6\u89c1\u9644\u4ef6\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-10-23 16:31:36","updated_at":"2025-10-23 17:14:00","supplier_id":489,"purchase_contract_id":4167,"amount":"520","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"520","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":"520"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":141,"purchase_contract_id":4167,"erp_store_id":null,"erp_purchase_order_product_id":106,"product_id":41,"description":"","number":"2","amount":"260","total_amount":"520.00","erpStore":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpPurchaseOrderProduct":{"id":106,"erp_purchase_order_id":2060,"erp_store_id":null,"product_id":41,"description":"","number":"2","into_inventory":"2","amount":"260","total_amount":"520.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2060,"serial_no":"CGDD-20250918-00001","from_date":null,"wrote_date":"2025-09-18","handler":1011,"supplier_id":489,"purchase_contract_id":4167,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-18 09:39:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"2","amount":"520","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-09-18 09:39:15","updated_at":"2025-09-18 09:39:39","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":66,"erp_purchase_order_id":2060,"user_id":1011,"status":1,"description":"","verify_at":"2025-09-18 09:39:39","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":"520","approve_amount":520,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"520","un_collected":0,"collected_plan":520,"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":520,"product_number":2,"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,"verifyList":[{"id":66,"erp_purchase_order_id":2060,"user_id":1011,"status":1,"description":"","verify_at":"2025-09-18 09:39:39","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":4004,"supplier_id":236,"contract_type":3,"signed_at":"2025-06-30","amount":"9975.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-06-30 14:15:07","updated_at":"2025-06-30 14:15:21","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250630-HYF-002","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-06-30 14:15:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"9975","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":"9975","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":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\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":4004,"comment":3},"purchaseClientRels":[{"id":4548,"contract_id":4004,"client_id":48,"project_id":3873,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3873,"key":3873,"name":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","project_status":3,"budget":"62075.1","buildContract":{"id":3998,"from_project":3873,"serial_no":"TS-YJC-20250526-001"},"clickable":1}}],"purchaseContractPayments":[{"id":"1430","key":"1430","contract_id":4004,"amount":"9975","value":"9975","collected_date":"2025-06-30 00:00:00","created_at":"2025-07-02 10:31:29","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2344,"key":2344,"contract_id":4004,"amount":"9975","value":"9975","attachment_id":null,"from_date":"2025-07-03","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4840,"purchase_invoice_id":2344,"amount":"7261","tax_rate":"6"},{"id":4841,"purchase_invoice_id":2344,"amount":"2714","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":35587,"object_type":103,"object_id":2344,"attachment_id":26727,"attachment":{"id":26727,"key":26727,"name":"915a008b-b24f-30eb-b0b4-30464886fe40","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/915a008b-b24f-30eb-b0b4-30464886fe40\/dzfp_25112000000138146493_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250703152320.pdf","orig_name":"dzfp_25112000000138146493_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250703152320.pdf"}}]}],"contractScans":[{"id":35442,"object_type":108,"object_id":4004,"attachment_id":26616,"attachment":{"id":26616,"key":26616,"name":"9445aa4f-1996-3fe5-a841-0c0dbfbf01b4","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9445aa4f-1996-3fe5-a841-0c0dbfbf01b4\/\u62d3\u5b9e\u79d1\u6280-\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8\u7ef4\u4fdd\u5408\u540c2025.06.30.pdf","orig_name":"\u62d3\u5b9e\u79d1\u6280-\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8\u7ef4\u4fdd\u5408\u540c2025.06.30.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1265,"user_id":1011,"key":1011,"contract_id":4004,"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":1266,"user_id":5360,"key":5360,"contract_id":4004,"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":751,"key":751,"contract_id":4004,"name":"2025-06-30","value":"9975","overdue_days":2,"status":1,"remind_date":"2025-06-30","pct":100,"overdue_display":"\u903e\u671f2\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1970,"serial_no":"CGDD-20250630-00002","from_date":null,"wrote_date":"2025-06-30","handler":1011,"supplier_id":236,"purchase_contract_id":4004,"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-06-30 14:15:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"9975.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-06-30 14:15:07","updated_at":"2025-06-30 14:15:21","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"9975","approve_amount":0,"un_approve_amount":9975,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"9975","un_collected":0,"collected_plan":9975,"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,"verifyList":[]},{"id":3784,"supplier_id":174,"contract_type":1,"signed_at":"2025-02-12","amount":"2000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-02-13 09:43:52","updated_at":"2025-02-13 11:13:56","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250212-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-13 09:44:05","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2000","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":"2000","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":174,"key":174,"name":"\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\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":3784,"comment":4},"purchaseClientRels":[{"id":4645,"contract_id":3784,"client_id":48,"project_id":3776,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3776,"key":3776,"name":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","project_status":3,"budget":"3200","buildContract":{"id":3783,"from_project":3776,"serial_no":"TS-YJC-20250217001"},"clickable":1}}],"purchaseContractPayments":[{"id":"1306","key":"1306","contract_id":3784,"amount":"2000.00","value":"2000.00","collected_date":"2025-02-18 00:00:00","created_at":"2025-02-18 14:20:29","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2149,"key":2149,"contract_id":3784,"amount":"2000","value":"2000","attachment_id":null,"from_date":"2025-02-27","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":1310,"purchase_invoice_id":2149,"amount":"2000","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":32554,"object_type":103,"object_id":2149,"attachment_id":24310,"attachment":{"id":24310,"key":24310,"name":"0512c219-70f8-3834-88bb-fc8c2e36beba","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0512c219-70f8-3834-88bb-fc8c2e36beba\/dzfp_25112000000038797728_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250227150007.pdf","orig_name":"dzfp_25112000000038797728_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250227150007.pdf"}}]}],"contractScans":[{"id":32229,"object_type":108,"object_id":3784,"attachment_id":24055,"attachment":{"id":24055,"key":24055,"name":"2f4c9f74-f59c-3414-b354-6ea6f4d5bd05","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2f4c9f74-f59c-3414-b354-6ea6f4d5bd05\/4321739416337_.pic.jpg","orig_name":"4321739416337_.pic.jpg"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":939,"user_id":1011,"key":1011,"contract_id":3784,"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":940,"user_id":5360,"key":5360,"contract_id":3784,"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":576,"key":576,"contract_id":3784,"name":"2025-02-17","value":"2000","overdue_days":1,"status":1,"remind_date":"2025-02-17","pct":100,"overdue_display":"\u903e\u671f1\u5929"}],"paymentApproves":[{"id":1641,"client_id":48,"project_id":3776,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-02-17 15:36:22","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5b8f\u6749\u5b58\u50a8\u786c\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe52000\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u519c\u4e1a\u94f6\u884c\u6d77\u6dc0\u652f\u884c\u8425\u4e1a\u90e8\n\u5e10\u53f7\uff1a11050101040004892","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-02-17 11:51:46","updated_at":"2025-02-17 15:36:22","supplier_id":174,"purchase_contract_id":3784,"amount":"2000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"2000","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":"2000"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1845,"serial_no":"CGDD-20250213-00001","from_date":null,"wrote_date":"2025-02-12","handler":1011,"supplier_id":174,"purchase_contract_id":3784,"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-02-13 09:43:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"2000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-02-13 09:43:52","updated_at":"2025-02-13 11:13:56","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"2000","approve_amount":2000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"2000","un_collected":0,"collected_plan":2000,"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,"verifyList":[]},{"id":3722,"supplier_id":116,"contract_type":3,"signed_at":"2024-12-24","amount":"7500.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-12-24 16:57:32","updated_at":"2025-01-16 10:48:26","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20241224001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-24 16:57:40","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7500","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":"7500","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":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\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":3722,"comment":3},"purchaseClientRels":[{"id":2862,"contract_id":3722,"client_id":48,"project_id":3556,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3556,"key":3556,"name":"2024\u5e74\u670d\u52a1\u5668\u53ca\u5b58\u50a8\u8fd0\u7ef4\u670d\u52a1","project_status":3,"budget":"47204.1","buildContract":{"id":3366,"from_project":3556,"serial_no":"TS-YJC-2024061301"},"clickable":1}}],"purchaseContractPayments":[{"id":"1275","key":"1275","contract_id":3722,"amount":"7500.00","value":"7500.00","collected_date":"2024-12-25 00:00:00","created_at":"2024-12-25 09:50:39","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2092,"key":2092,"contract_id":3722,"amount":"7500","value":"7500","attachment_id":null,"from_date":"2025-01-02","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":1209,"purchase_invoice_id":2092,"amount":"7500","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":31503,"object_type":103,"object_id":2092,"attachment_id":23511,"attachment":{"id":23511,"key":23511,"name":"4a4dd17f-fca8-3aff-a239-457f4801b18d","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4a4dd17f-fca8-3aff-a239-457f4801b18d\/25512000000000546745.pdf","orig_name":"25512000000000546745.pdf"}}]}],"contractScans":[{"id":31879,"object_type":108,"object_id":3722,"attachment_id":23783,"attachment":{"id":23783,"key":23783,"name":"652dd7a8-7f91-39e3-9bbf-7c09591ff2fb","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/652dd7a8-7f91-39e3-9bbf-7c09591ff2fb\/2025_01_16_10_47_32.pdf","orig_name":"2025_01_16_10_47_32.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":849,"user_id":1011,"key":1011,"contract_id":3722,"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":850,"user_id":5360,"key":5360,"contract_id":3722,"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":528,"key":528,"contract_id":3722,"name":"2024-12-25","value":"7500","overdue_days":0,"status":1,"remind_date":"2024-12-25","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":1529,"client_id":48,"project_id":3556,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2024-12-24 17:04:36","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed85\u53f0\u670d\u52a1\u5668\u539f\u5382\u7eed\u4fdd\u670d\u52a1\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d\uff1a\uffe57500\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u540d\u79f0\uff1a\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8\n\u5f00 \u6237 \u884c: \u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u7ef5\u9633\u5e02\u5206\u884c\u8425\u4e1a\u90e8 \n\u8d26\u53f7\uff1a51001658636050348363\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002\u540d\u79f0\uff1a\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8\n\u5f00 \u6237 \u884c: \u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u7ef5\u9633\u5e02\u5206\u884c\u8425\u4e1a\u90e8 \n\u8d26\u53f7\uff1a51001658636050348363","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2024-12-24 17:04:10","updated_at":"2024-12-24 17:04:36","supplier_id":116,"purchase_contract_id":3722,"amount":"7500","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"7500","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":"7500"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1817,"serial_no":"CGDD-20241224-00003","from_date":null,"wrote_date":"2024-12-24","handler":1011,"supplier_id":116,"purchase_contract_id":3722,"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-24 16:57: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":"7500.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-12-24 16:57:32","updated_at":"2025-01-16 10:48:26","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"7500","approve_amount":7500,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"7500","un_collected":0,"collected_plan":7500,"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,"verifyList":[]},{"id":3561,"supplier_id":165,"contract_type":1,"signed_at":"2024-09-18","amount":"1600.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-09-26 10:12:53","updated_at":"2024-09-26 10:13:05","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20240918","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-26 10:13:05","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1600","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":"1600","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":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\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":3561,"comment":3},"purchaseClientRels":[{"id":2535,"contract_id":3561,"client_id":48,"project_id":3658,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3658,"key":3658,"name":"Netapp\u5b58\u50a8\u786c\u76d8","project_status":3,"budget":"7600","buildContract":{"id":3547,"from_project":3658,"serial_no":"TS-YJC-2024092301"},"clickable":1}}],"purchaseContractPayments":[{"id":"1193","key":"1193","contract_id":3561,"amount":"1600.00","value":"1600.00","collected_date":"2024-10-31 00:00:00","created_at":"2024-10-31 13:46:01","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1983,"key":1983,"contract_id":3561,"amount":"1600","value":"1600","attachment_id":null,"from_date":"2024-10-25","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":554,"purchase_invoice_id":1983,"amount":"1600","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":29638,"object_type":103,"object_id":1983,"attachment_id":22224,"attachment":{"id":22224,"key":22224,"name":"3019cfaf-8b36-35ae-8de0-224331cafd09","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/3019cfaf-8b36-35ae-8de0-224331cafd09\/dzfp_24112000000162606387_\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8_20241025155635.pdf","orig_name":"dzfp_24112000000162606387_\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8_20241025155635.pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":533,"user_id":1011,"key":1011,"contract_id":3561,"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":534,"user_id":5360,"key":5360,"contract_id":3561,"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":350,"key":350,"contract_id":3561,"name":"2024-10-18","value":"1600","overdue_days":13,"status":1,"remind_date":"2024-10-18","pct":100,"overdue_display":"\u903e\u671f13\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1713,"serial_no":"CGDD-20240926-00002","from_date":null,"wrote_date":"2024-09-18","handler":1011,"supplier_id":165,"purchase_contract_id":3561,"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-09-26 10:12: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":"1600.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-09-26 10:12:53","updated_at":"2024-09-26 10:13:05","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"1600","approve_amount":0,"un_approve_amount":1600,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1600","un_collected":0,"collected_plan":1600,"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,"verifyList":[]},{"id":3424,"supplier_id":90,"contract_type":3,"signed_at":"2024-07-23","amount":"77706.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2024-07-23 09:51:41","updated_at":"2024-09-10 09:27:58","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2024SBQ18387","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-10 09:27:58","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"77706","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":"77706","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":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":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"}},"commentCount":{"object_id":3424,"comment":3},"purchaseClientRels":[{"id":2179,"contract_id":3424,"client_id":48,"project_id":3581,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3581,"key":3581,"name":"2024PA\u4ea7\u54c1\u7eed\u4fdd","project_status":3,"budget":"110000","buildContract":{"id":3395,"from_project":3581,"serial_no":"TS-YJC-2024062601"},"clickable":1}}],"purchaseContractPayments":[{"id":"1214","key":"1214","contract_id":3424,"amount":"77706.00","value":"77706.00","collected_date":"2024-09-20 00:00:00","created_at":"2024-09-20 11:10:55","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1801,"key":1801,"contract_id":3424,"amount":"77706.00","value":"77706.00","attachment_id":null,"from_date":"2024-07-26","description":"","is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4729,"purchase_invoice_id":1801,"amount":"77706.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":27415,"object_type":103,"object_id":1801,"attachment_id":20571,"attachment":{"id":20571,"key":20571,"name":"a01561ea-27e9-3658-b952-a371bd530c58","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/a01561ea-27e9-3658-b952-a371bd530c58\/24122000000044144860_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"24122000000044144860_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":27356,"object_type":108,"object_id":3424,"attachment_id":20526,"attachment":{"id":20526,"key":20526,"name":"a1bb9bdf-960a-35a2-8408-0c662f50cfb9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/a1bb9bdf-960a-35a2-8408-0c662f50cfb9\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":27372,"object_type":111,"object_id":3424,"attachment_id":20539,"attachment":{"id":20539,"key":20539,"name":"2cbfbcf0-549a-3c7b-b31c-ab160d189d07","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2cbfbcf0-549a-3c7b-b31c-ab160d189d07\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":483,"user_id":1011,"key":1011,"contract_id":3424,"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":484,"user_id":5360,"key":5360,"contract_id":3424,"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":322,"key":322,"contract_id":3424,"name":"2024-09-20","value":"77706","overdue_days":0,"status":1,"remind_date":"2024-09-20","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1640,"serial_no":"CGDD-20240723-00003","from_date":null,"wrote_date":"2024-07-23","handler":5360,"supplier_id":90,"purchase_contract_id":3424,"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-23 09:51:41","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"77706.00","created_by":5360,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-07-23 09:51:41","updated_at":"2024-09-10 09:27:58","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"77706.00","approve_amount":0,"un_approve_amount":77706,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"77706","un_collected":0,"collected_plan":77706,"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,"verifyList":[]},{"id":3411,"supplier_id":236,"contract_type":3,"signed_at":"2024-07-15","amount":"14747.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-07-15 14:28:12","updated_at":"2024-08-07 10:39:07","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20240715-HYF-002","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-15 14:28:23","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"14747","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":"14747","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":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\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":3411,"comment":1},"purchaseClientRels":[{"id":2178,"contract_id":3411,"client_id":48,"project_id":3582,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3582,"key":3582,"name":"2024\u6df1\u4fe1\u670d\u4ea7\u54c1\u7eed\u4fdd","project_status":3,"budget":"23951","buildContract":{"id":3385,"from_project":3582,"serial_no":"TS-YJC-2024062602"},"clickable":1}}],"purchaseContractPayments":[{"id":"134","key":"134","contract_id":3411,"amount":"14747.00","value":"14747.00","collected_date":"2024-07-15 00:00:00","created_at":"2024-07-15 17:42:08","created_by":5360,"description":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1810,"key":1810,"contract_id":3411,"amount":"14747","value":"14747","attachment_id":null,"from_date":"2024-07-18","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4925,"purchase_invoice_id":1810,"amount":"2714","tax_rate":"13"},{"id":4926,"purchase_invoice_id":1810,"amount":"12033","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":28118,"object_type":103,"object_id":1810,"attachment_id":20652,"attachment":{"id":20652,"key":20652,"name":"403ff931-fe35-3a65-b545-e9eb1d0d5cf5","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/403ff931-fe35-3a65-b545-e9eb1d0d5cf5\/dzfp_24112000000086612236_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240718171448.pdf","orig_name":"dzfp_24112000000086612236_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240718171448.pdf"}}]}],"contractScans":[{"id":27666,"object_type":108,"object_id":3411,"attachment_id":20761,"attachment":{"id":20761,"key":20761,"name":"51b405ba-4e63-36ea-8a03-d6c97f7b0756","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/51b405ba-4e63-36ea-8a03-d6c97f7b0756\/14747.pdf","orig_name":"14747.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":315,"user_id":1011,"key":1011,"contract_id":3411,"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":316,"user_id":5360,"key":5360,"contract_id":3411,"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":208,"key":208,"contract_id":3411,"name":"2024-07-15","value":"14747","overdue_days":0,"status":1,"remind_date":"2024-07-15","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1633,"serial_no":"CGDD-20240715-00005","from_date":null,"wrote_date":"2024-07-15","handler":1011,"supplier_id":236,"purchase_contract_id":3411,"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-15 14:28:12","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"14747.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-07-15 14:28:12","updated_at":"2024-08-07 10:39:07","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"14747","approve_amount":0,"un_approve_amount":14747,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"14747","un_collected":0,"collected_plan":14747,"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,"verifyList":[]},{"id":3292,"supplier_id":598,"contract_type":1,"signed_at":"2024-05-14","amount":"75000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2024-05-14 14:38:26","updated_at":"2024-07-08 09:44:30","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"2024051401","payment_collection_remind_ahead":"7 days","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"75000","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":"75000","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":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\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":3292,"comment":3},"purchaseClientRels":[{"id":1996,"contract_id":3292,"client_id":48,"project_id":3543,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":{"id":3543,"key":3543,"name":"\u5b58\u50a8\u6269\u5bb9","project_status":3,"budget":"92000","buildContract":{"id":3299,"from_project":3543,"serial_no":"TS-YJC-2024043019"},"clickable":1}}],"purchaseContractPayments":[{"id":"128","key":"128","contract_id":3292,"amount":"75000.00","value":"75000.00","collected_date":"2024-06-26 00:00:00","created_at":"2024-06-26 11:06:46","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1759,"key":1759,"contract_id":3292,"amount":"75000.00","value":"75000.00","attachment_id":null,"from_date":"2024-06-17","description":"","is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4697,"purchase_invoice_id":1759,"amount":"75000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26540,"object_type":103,"object_id":1759,"attachment_id":19802,"attachment":{"id":19802,"key":19802,"name":"b63d922a-aa7a-3507-b0ed-6b3dbd581b62","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b63d922a-aa7a-3507-b0ed-6b3dbd581b62\/dzfp_24112000000062260862_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240617120912.pdf","orig_name":"dzfp_24112000000062260862_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240617120912.pdf"}}]}],"contractScans":[{"id":26887,"object_type":108,"object_id":3292,"attachment_id":20105,"attachment":{"id":20105,"key":20105,"name":"53748379-319f-3de1-ad62-2e04e67220ff","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/53748379-319f-3de1-ad62-2e04e67220ff\/2024_07_08_09_32_56.pdf","orig_name":"2024_07_08_09_32_56.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":135,"user_id":1011,"key":1011,"contract_id":3292,"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":136,"user_id":5360,"key":5360,"contract_id":3292,"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":105,"key":105,"contract_id":3292,"name":"2024-06-13","value":"75000","overdue_days":13,"status":1,"remind_date":"2024-06-13","pct":100,"overdue_display":"\u903e\u671f13\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1563,"serial_no":"CGDD-20240514-00003","from_date":null,"wrote_date":"2024-05-14","handler":1011,"supplier_id":598,"purchase_contract_id":3292,"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-05-14 14:38:26","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"75000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2024-05-14 14:38:26","updated_at":"2024-07-08 09:44:30","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"75000.00","approve_amount":0,"un_approve_amount":75000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"75000","un_collected":0,"collected_plan":75000,"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,"verifyList":[]}],"pagenation":{"totalcount":43,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 14:09:40', 330050816) RETURNING "id"
14:09:40.4734.3 msyii\db\Command::querySELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)) ORDER BY "id"
14:09:40.4384.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1759, 1801, 1810, 1983, 2092, 2149, 2344, 2507, 2548, 2724))
14:09:40.4534.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292))
14:09:40.4283.8 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5) )) "sub") "r" WHERE "contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292) ORDER BY "id" DESC
14:09:40.2983.7 msyii\db\Command::querySELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 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"='48') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
14:09:40.4433.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1759, 1801, 1810, 1983, 2092, 2149, 2344, 2507, 2548, 2724))
14:09:40.4483.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292))
14:09:40.5343.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (2084, 1563, 1633, 1640, 1713, 1817, 1845, 2156, 2060, 1970) ORDER BY "id"
14:09:40.5773.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3561) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5203.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)
14:09:40.4672.3 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)) GROUP BY "r"."id"
14:09:40.4331.7 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292) ORDER BY "id"
14:09:40.5391.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)
14:09:40.4611.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
14:09:40.4591.6 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)
14:09:40.4361.6 msyii\db\Command::querySELECT "id", "purchase_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_purchase_invoice_amounts" WHERE "purchase_invoice_id" IN (1759, 1801, 1810, 1983, 2092, 2149, 2344, 2507, 2548, 2724) ORDER BY "id"
14:09:40.4651.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292) ORDER BY "remind_date"
14:09:40.4581.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (20539, 29227, 31824)
14:09:40.5431.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4361) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5451.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4220) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5561.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3784) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.2691.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:09:40.5521.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4004) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5501.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4167) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.2661.1 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
14:09:40.5181.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (106, 155, 325)
14:09:40.5381.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)
14:09:40.5271.0 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
14:09:40.5150.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (6, 4)
14:09:40.5230.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (2084, 1563, 1633, 1640, 1713, 1817, 1845, 2156, 2060, 1970) ORDER BY "id"
14:09:40.4260.9 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3543, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873)
14:09:40.3190.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011))
14:09:40.4230.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292) ORDER BY "id"
14:09:40.4520.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (20105, 20526, 20761, 23783, 24055, 26616, 29215, 30766, 31822)
14:09:40.4470.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22224, 19802, 20571, 20652, 23511, 24310, 26727, 29232, 29886, 31819)
14:09:40.5100.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4361, 4220, 4167, 4004, 3784, 3722, 3561, 3424, 3411, 3292)
14:09:40.3210.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
14:09:40.4630.8 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011))
14:09:40.5110.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (41, 1376)
14:09:40.3180.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
14:09:40.5810.8 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3424) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.4250.8 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3543, 3582, 3581, 3658, 3556, 4090, 3969, 3873, 3776)
14:09:40.5250.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
14:09:40.3200.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
14:09:40.4320.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5360, 5388)
14:09:40.5130.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (3, 2)
14:09:40.3220.7 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011))
14:09:40.5160.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1015, 1052)
14:09:40.5830.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3292) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5820.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=3411) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
14:09:40.5140.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (15, 13)
14:09:40.5170.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 8)
14:09:40.2660.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:09:40.4240.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=48