68c137ef3d761: POST https://beta.jinchangxiao.com/v2/purchase-contract/list at 2025-09-10 04:33:51 pm by 114.246.239.150
Performance Profiling
Total processing time: 104 ms; Peak memory: 6.266 MB. Show Profiling Timeline
总计46条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:33:51.281 | 20.4 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031)) GROUP BY "object_id" |
| 16:33:51.323 | 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 (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031)) GROUP BY "object_id" |
| 16:33:51.264 | 6.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.* 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 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 ("c"."contract_type"='3') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 16:33:51.271 | 5.7 ms | yii\db\Command::query | SELECT c.* 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 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 ("c"."contract_type"='3') GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 16:33:51.304 | 4.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "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.created_at::timestamp without time zone 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"."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 (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) ORDER BY "id" DESC |
| 16:33:51.350 | 3.0 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") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/purchase-contract/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","PurchaseContractSearch":{"contract_type":"3","sales_rep":"","handler":""},"version_code":"266","page":"1","token":"6523372061a7c16f2af38ab2ba911c79","posttime":"1757493231"}', '{"code":200,"data":{"list":[{"id":4122,"supplier_id":90,"contract_type":3,"signed_at":"2025-08-26","amount":"19502","handler":1011,"description":"\u7ef4\u4fdd\uff1aSN 7159165872 \u5468\u671f\uff1a2025\/9\/9\u81f32026\/9\/8","contract_scan":null,"created_by":1011,"created_at":"2025-08-26 13:37:22","updated_at":"2025-09-05 11:13:55","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2025SBQ23652","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-26 13:37:59","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1","erp_un_settle_amount":"19501","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":4122,"comment":2},"purchaseClientRels":[{"id":3798,"contract_id":4122,"client_id":3286,"project_id":3927,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"12126","key":"12126","contract_id":4122,"value":"1","collected_date":"2025-09-04 10:33:10","created_at":"2025-09-04 10:33:10","created_by":1001,"description":"1","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.01}],"purchaseContractInvoices":[{"id":2434,"key":2434,"contract_id":4122,"amount":"19502","value":"19502","attachment_id":null,"from_date":"2025-08-28","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":49191,"object_type":103,"object_id":2434,"attachment_id":27891,"attachment":{"id":27891,"key":27891,"name":"d0b581f6-1d02-39b9-a006-163d7df89c02","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/d0b581f6-1d02-39b9-a006-163d7df89c02\/19502.pdf","orig_name":"19502.pdf"}}]}],"contractScans":[{"id":49449,"object_type":108,"object_id":4122,"attachment_id":27885,"attachment":{"id":27885,"key":27885,"name":"4b69a0e7-1929-371b-9c11-6b798a3b96a8","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/4b69a0e7-1929-371b-9c11-6b798a3b96a8\/19502.pdf","orig_name":"19502.pdf"}}],"receiptScans":[{"id":49450,"object_type":111,"object_id":4122,"attachment_id":27884,"attachment":{"id":27884,"key":27884,"name":"bc0ccc2e-afc0-32d1-b0cc-1eab468e60a6","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/bc0ccc2e-afc0-32d1-b0cc-1eab468e60a6\/19502.pdf","orig_name":"19502.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1465,"user_id":1011,"key":1011,"contract_id":4122,"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":1466,"user_id":5360,"key":5360,"contract_id":4122,"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":861,"key":861,"contract_id":4122,"name":"2026-10-28","value":"19502","overdue_days":null,"status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":84,"purchase_contract_id":4122,"erp_store_id":null,"erp_purchase_order_product_id":58,"product_id":1624,"description":"","number":"14","amount":"1393","total_amount":"19502","erpStore":null,"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"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":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":58,"erp_purchase_order_id":2038,"erp_store_id":null,"product_id":1624,"description":"","number":"14","into_inventory":"14","amount":"1393","total_amount":"19502","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2038,"serial_no":"CGDD-20250826-00001","from_date":null,"wrote_date":"2025-08-26","handler":1011,"supplier_id":90,"purchase_contract_id":4122,"erp_store_id":null,"status":2,"abstract":null,"description":"\u7ef4\u4fdd\uff1aSN 7159165872 \u5468\u671f\uff1a2025\/9\/9\u81f32026\/9\/8","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-26 13:54:26","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"14","amount":"19502","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-26 13:37:23","updated_at":"2025-08-26 13:54:26","erpPurchaseOrderVerifyRels":[{"id":44,"erp_purchase_order_id":2038,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-26 13:54:26"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":19502,"approve_amount":0,"un_approve_amount":19502,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"1","un_collected":19501,"collected_plan":19502,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":19502,"product_number":14,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4119,"supplier_id":724,"contract_type":3,"signed_at":"2025-08-22","amount":"2500.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-08-22 16:49:04","updated_at":"2025-08-22 16:49:35","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250822-ZHF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-22 16:49:35","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2500","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":724,"key":724,"name":"\u5317\u4eac\u56db\u901a\u642c\u5bb6\u6709\u9650\u516c\u53f8"},"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":4119,"comment":4},"purchaseClientRels":[{"id":3769,"contract_id":4119,"client_id":2182,"project_id":3883,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"clickable":1},"project":{"id":3883,"key":3883,"name":"\u673a\u623f\u642c\u8fc1-K-2025","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"12115","key":"12115","contract_id":4119,"value":"2500","collected_date":"2025-08-25 15:01:25","created_at":"2025-08-25 15:01:25","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u56db\u901a\u642c\u5bb6","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2422,"key":2422,"contract_id":4119,"amount":"2500","value":"2500","attachment_id":null,"from_date":"2025-08-22","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48843,"object_type":103,"object_id":2422,"attachment_id":27776,"attachment":{"id":27776,"key":27776,"name":"25406215-d2de-3c15-b0ba-fd5f1467e22a","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/25406215-d2de-3c15-b0ba-fd5f1467e22a\/dzfp_25112000000177219381_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822162118(1).pdf","orig_name":"dzfp_25112000000177219381_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822162118(1).pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1459,"user_id":1011,"key":1011,"contract_id":4119,"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":1460,"user_id":5360,"key":5360,"contract_id":4119,"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":858,"key":858,"contract_id":4119,"name":"2025-08-25","value":"2500","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2198,"client_id":2182,"project_id":3883,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u56db\u901a\u642c\u5bb6\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-08-25 14:49:42","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u5357\u65b9\u65af\u5948\u514b\u739b-\u673a\u623f\u642c\u5bb6\u670d\u52a1\u8d39\uff0c\u91d1\u989d2500\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u4ed8\u6b3e\u4fe1\u606f\uff1a\n\u540d\u79f0\uff1a \u5317\u4eac\u56db\u901a\u642c\u5bb6\u6709\u9650\u516c\u53f8 \n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7 91110102101390968H \n\u5730\u5740\u3001\u7535\u8bdd\uff1a \u5317\u4eac\u5e02\u897f\u57ce\u533a\u5fb7\u80dc\u91cc\u4e00\u533a11\u53f7\u697c3\u5c42006\u5ba4 51079383 \n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a \u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u671b\u4eac\u652f\u884c 11001070200059040026 \n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-08-25 11:14:04","updated_at":"2025-08-25 14:49:42","supplier_id":724,"purchase_contract_id":4119,"amount":"2500","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"2500","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":77,"purchase_contract_id":4119,"erp_store_id":null,"erp_purchase_order_product_id":56,"product_id":942,"description":"","number":"1","amount":"2500","total_amount":"2500","erpStore":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2025-08-25 16:06:57","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpPurchaseOrderProduct":{"id":56,"erp_purchase_order_id":2036,"erp_store_id":null,"product_id":942,"description":"","number":"1","into_inventory":"1","amount":"2500","total_amount":"2500","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2036,"serial_no":"CGDD-20250822-00007","from_date":null,"wrote_date":"2025-08-22","handler":5360,"supplier_id":724,"purchase_contract_id":4119,"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-08-22 17:39:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"2500","created_by":5360,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-22 16:49:05","updated_at":"2025-08-22 17:39:18","erpPurchaseOrderVerifyRels":[{"id":42,"erp_purchase_order_id":2036,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-22 17:39:18"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":2500,"approve_amount":2500,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"2500","un_collected":0,"collected_plan":2500,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":2500,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4108,"supplier_id":618,"contract_type":3,"signed_at":"2025-08-20","amount":"2000","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-08-20 15:58:14","updated_at":"2025-08-21 10:35:47","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250820-ZHF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-21 10:02:31","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":4108,"comment":1},"purchaseClientRels":[{"id":3734,"contract_id":4108,"client_id":2182,"project_id":3883,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"clickable":1},"project":{"id":3883,"key":3883,"name":"\u673a\u623f\u642c\u8fc1-K-2025","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2423,"key":2423,"contract_id":4108,"amount":"2000","value":"2000","attachment_id":null,"from_date":"2025-08-22","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48855,"object_type":103,"object_id":2423,"attachment_id":27787,"attachment":{"id":27787,"key":27787,"name":"eb355324-af1e-39c0-81b6-a02b520f3c8d","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/eb355324-af1e-39c0-81b6-a02b520f3c8d\/20250822_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25112000000177490235_2000.00.pdf","orig_name":"20250822_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25112000000177490235_2000.00.pdf"}}]}],"contractScans":[{"id":48708,"object_type":108,"object_id":4108,"attachment_id":27679,"attachment":{"id":27679,"key":27679,"name":"4d12d81c-0e7b-39cf-a6cb-3663a837c563","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/4d12d81c-0e7b-39cf-a6cb-3663a837c563\/\u62d3\u5b9e-\u6052\u6cf0\u6b63\u5b87\u79fb\u673a\u5408\u540c2000\u5143.pdf","orig_name":"\u62d3\u5b9e-\u6052\u6cf0\u6b63\u5b87\u79fb\u673a\u5408\u540c2000\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1437,"user_id":1011,"key":1011,"contract_id":4108,"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":1438,"user_id":5360,"key":5360,"contract_id":4108,"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":847,"key":847,"contract_id":4108,"name":"2025-09-18","value":"2000","overdue_days":null,"status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":66,"purchase_contract_id":4108,"erp_store_id":null,"erp_purchase_order_product_id":45,"product_id":942,"description":"","number":"1","amount":"2000","total_amount":"2000","erpStore":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2025-08-25 16:06:57","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpPurchaseOrderProduct":{"id":45,"erp_purchase_order_id":2028,"erp_store_id":null,"product_id":942,"description":"","number":"1","into_inventory":"1","amount":"2000","total_amount":"2000","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2028,"serial_no":"CGDD-20250820-00004","from_date":null,"wrote_date":"2025-08-20","handler":5360,"supplier_id":618,"purchase_contract_id":4108,"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-08-20 17:49:56","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"2000","created_by":5360,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-20 15:58:15","updated_at":"2025-08-20 17:49:56","erpPurchaseOrderVerifyRels":[{"id":33,"erp_purchase_order_id":2028,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-20 15:59:34"},{"id":34,"erp_purchase_order_id":2028,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 17:49:56"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":2000,"approve_amount":0,"un_approve_amount":2000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"0","un_collected":2000,"collected_plan":2000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":2000,"product_number":1,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4107,"supplier_id":293,"contract_type":3,"signed_at":"2025-08-20","amount":"3300","handler":1011,"description":"\u5e03\u7ebf\/\u95e8\u7981\u5b89\u88c5\u7b49\u5de5\u4f5c","contract_scan":null,"created_by":1011,"created_at":"2025-08-20 15:48:05","updated_at":"2025-08-20 15:48:24","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250820-HYF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-20 15:48:24","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"3300","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":293,"key":293,"name":"\u5317\u4eac\u798f\u9510\u7279\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"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":4107,"comment":4},"purchaseClientRels":[{"id":3733,"contract_id":4107,"client_id":2182,"project_id":3883,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"clickable":1},"project":{"id":3883,"key":3883,"name":"\u673a\u623f\u642c\u8fc1-K-2025","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"12116","key":"12116","contract_id":4107,"value":"3300","collected_date":"2025-08-26 15:26:43","created_at":"2025-08-26 15:26:43","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u5317\u4eac\u798f\u9510\u7279\u79d1\u6280","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2410,"key":2410,"contract_id":4107,"amount":"3300","value":"3300","attachment_id":null,"from_date":"2025-08-20","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48681,"object_type":103,"object_id":2410,"attachment_id":27660,"attachment":{"id":27660,"key":27660,"name":"ab336c6e-1919-3f59-af20-ca6f65b6d248","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/ab336c6e-1919-3f59-af20-ca6f65b6d248\/dzfp_25112000000175335731_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250820160319.pdf","orig_name":"dzfp_25112000000175335731_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250820160319.pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1433,"user_id":1011,"key":1011,"contract_id":4107,"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":1434,"user_id":5360,"key":5360,"contract_id":4107,"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":845,"key":845,"contract_id":4107,"name":"2025-08-25","value":"3300","overdue_days":1,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2195,"client_id":2182,"project_id":3883,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u798f\u9510\u7279\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-08-26 11:10:38","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u673a\u623f\u5e03\u7ebf\u4eba\u5de5\u670d\u52a1\u8d39\uff0c\u91d1\u989d\uff1a\uffe53300\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-26 10:47:42","updated_at":"2025-08-26 11:10:38","supplier_id":293,"purchase_contract_id":4107,"amount":"3300","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"3300","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":65,"purchase_contract_id":4107,"erp_store_id":null,"erp_purchase_order_product_id":44,"product_id":942,"description":"","number":"1","amount":"3300","total_amount":"3300","erpStore":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2025-08-25 16:06:57","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpPurchaseOrderProduct":{"id":44,"erp_purchase_order_id":2027,"erp_store_id":null,"product_id":942,"description":"","number":"1","into_inventory":"1","amount":"3300","total_amount":"3300","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2027,"serial_no":"CGDD-20250820-00003","from_date":null,"wrote_date":"2025-08-20","handler":1011,"supplier_id":293,"purchase_contract_id":4107,"erp_store_id":null,"status":2,"abstract":null,"description":"\u5e03\u7ebf\/\u95e8\u7981\u5b89\u88c5\u7b49\u5de5\u4f5c","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-20 17:49:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"3300","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-20 15:48:06","updated_at":"2025-08-20 17:49:59","erpPurchaseOrderVerifyRels":[{"id":31,"erp_purchase_order_id":2027,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-20 15:48:37"},{"id":32,"erp_purchase_order_id":2027,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 17:49:59"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":3300,"approve_amount":3300,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"3300","un_collected":0,"collected_plan":3300,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":3300,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4103,"supplier_id":90,"contract_type":3,"signed_at":"2025-08-19","amount":"14573","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-08-19 18:08:55","updated_at":"2025-08-22 09:56:57","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2025SBQ23003","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-22 09:56:57","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"14573","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":4103,"comment":1},"purchaseClientRels":[{"id":3765,"contract_id":4103,"client_id":2845,"project_id":3949,"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","sales_rep":1001,"clickable":1},"project":{"id":3949,"key":3949,"name":"PA1410\u4e00\u5e74\u670d\u52a1","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2420,"key":2420,"contract_id":4103,"amount":"14573","value":"14573","attachment_id":null,"from_date":"2025-08-22","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48808,"object_type":103,"object_id":2420,"attachment_id":27753,"attachment":{"id":27753,"key":27753,"name":"e7bcc1d5-d0c4-38e6-9b84-d59a73c847db","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e7bcc1d5-d0c4-38e6-9b84-d59a73c847db\/91120118MA06G1T23F_25082210223944315336.pdf","orig_name":"91120118MA06G1T23F_25082210223944315336.pdf"}}]}],"contractScans":[{"id":48736,"object_type":108,"object_id":4103,"attachment_id":27711,"attachment":{"id":27711,"key":27711,"name":"75308f1b-6234-3665-864a-eece2f379b79","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/75308f1b-6234-3665-864a-eece2f379b79\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":48735,"object_type":111,"object_id":4103,"attachment_id":27710,"attachment":{"id":27710,"key":27710,"name":"942140b4-102c-3971-9d6f-d3118eac6d76","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/942140b4-102c-3971-9d6f-d3118eac6d76\/14573.pdf","orig_name":"14573.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1443,"user_id":1011,"key":1011,"contract_id":4103,"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":1444,"user_id":5360,"key":5360,"contract_id":4103,"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":850,"key":850,"contract_id":4103,"name":"2025-10-16","value":"14573","overdue_days":null,"status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":63,"purchase_contract_id":4103,"erp_store_id":null,"erp_purchase_order_product_id":37,"product_id":2108,"description":"","number":"1","amount":"14573","total_amount":"14573","erpStore":null,"product":{"id":2108,"name":"PAN-SVC-BKLN-1410-R","product_type":5,"product_component":214,"product_brand":8,"product_serie":1694,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term, renewal.","created_by":1013,"created_at":"2025-08-19 16:53:04","updated_at":"2025-08-21 16:46:27","pinyin_shortcut":"PANSVCBKLN1410R","product_unit":2,"is_renew":true,"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":1694,"key":1694,"name":"PA1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":37,"erp_purchase_order_id":2024,"erp_store_id":null,"product_id":2108,"description":"","number":"1","into_inventory":"1","amount":"14573","total_amount":"14573","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2024,"serial_no":"CGDD-20250819-00006","from_date":null,"wrote_date":"2025-08-19","handler":1011,"supplier_id":90,"purchase_contract_id":4103,"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-08-20 14:58:45","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"14573","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 18:08:55","updated_at":"2025-08-20 14:58:45","erpPurchaseOrderVerifyRels":[{"id":25,"erp_purchase_order_id":2024,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-20 09:30:07"},{"id":26,"erp_purchase_order_id":2024,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:58:45"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":14573,"approve_amount":0,"un_approve_amount":14573,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"0","un_collected":14573,"collected_plan":14573,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":14573,"product_number":1,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4100,"supplier_id":163,"contract_type":3,"signed_at":"2025-08-18","amount":"11528","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-08-19 17:11:29","updated_at":"2025-08-25 09:24:42","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"2025WSCN-E-020-C0809-PAN","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-19 17:11:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"11528","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"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":4100,"comment":1},"purchaseClientRels":[{"id":3767,"contract_id":4100,"client_id":2182,"project_id":3849,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"clickable":1},"project":{"id":3849,"key":3849,"name":"PA440\u7ef4\u4fdd-K-2025","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2409,"key":2409,"contract_id":4100,"amount":"11528","value":"11528","attachment_id":null,"from_date":"2025-08-20","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48668,"object_type":103,"object_id":2409,"attachment_id":27647,"attachment":{"id":27647,"key":27647,"name":"b74f86ab-9b28-3d21-9a93-669e66dd0353","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/b74f86ab-9b28-3d21-9a93-669e66dd0353\/10488284_20250820_25312000000262895132_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(11528.00).pdf","orig_name":"10488284_20250820_25312000000262895132_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(11528.00).pdf"}}]}],"contractScans":[{"id":48853,"object_type":108,"object_id":4100,"attachment_id":27785,"attachment":{"id":27785,"key":27785,"name":"4b83ab0a-00e7-3953-af5d-29b9fc862f7a","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/4b83ab0a-00e7-3953-af5d-29b9fc862f7a\/2025_08_25_09_16_48.pdf","orig_name":"2025_08_25_09_16_48.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1421,"user_id":1011,"key":1011,"contract_id":4100,"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":1422,"user_id":5360,"key":5360,"contract_id":4100,"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":839,"key":839,"contract_id":4100,"name":"2025-10-17","value":"11528","overdue_days":null,"status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":57,"purchase_contract_id":4100,"erp_store_id":null,"erp_purchase_order_product_id":31,"product_id":1961,"description":"","number":"1","amount":"1997","total_amount":"1997","erpStore":null,"product":{"id":1961,"name":"PAN-SVC-BKLN-440-R","product_type":22,"product_component":200,"product_brand":8,"product_serie":1613,"product_misc":null,"product_qa":null,"pn":"","description":"\nPA-440, Partner enabled premium support, 1 year (12 months), term, renewal.","created_by":1013,"created_at":"2025-04-08 13:44:03","updated_at":"2025-08-21 09:20:52","pinyin_shortcut":"PANSVCBKLN440R","product_unit":8,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1613,"key":1613,"name":"PA-440\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpPurchaseOrderProduct":{"id":31,"erp_purchase_order_id":2021,"erp_store_id":null,"product_id":1961,"description":"","number":"1","into_inventory":"1","amount":"1997","total_amount":"1997","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":58,"purchase_contract_id":4100,"erp_store_id":null,"erp_purchase_order_product_id":32,"product_id":2101,"description":"","number":"1","amount":"3177","total_amount":"3177","erpStore":null,"product":{"id":2101,"name":"PAN-PA-440-ADVURL-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":618,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Advanced URL Filtering subscription, 1 year (12 months),term, renewal","created_by":1013,"created_at":"2025-08-15 15:19:23","updated_at":"2025-08-21 09:20:52","pinyin_shortcut":"PANPA440ADVURLR","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":618,"key":618,"name":"PA440\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":32,"erp_purchase_order_id":2021,"erp_store_id":null,"product_id":2101,"description":"","number":"1","into_inventory":"1","amount":"3177","total_amount":"3177","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":59,"purchase_contract_id":4100,"erp_store_id":null,"erp_purchase_order_product_id":33,"product_id":2104,"description":"","number":"1","amount":"3177","total_amount":"3177","erpStore":null,"product":{"id":2104,"name":"PAN-PA-440-ATP-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":618,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Threat prevention subscription, 1 year (12 months), term, renewal","created_by":1013,"created_at":"2025-08-15 15:28:33","updated_at":"2025-08-21 09:20:52","pinyin_shortcut":"PANPA440ATPR","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":618,"key":618,"name":"PA440\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":33,"erp_purchase_order_id":2021,"erp_store_id":null,"product_id":2104,"description":"","number":"1","into_inventory":"1","amount":"3177","total_amount":"3177","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":60,"purchase_contract_id":4100,"erp_store_id":null,"erp_purchase_order_product_id":34,"product_id":2103,"description":"","number":"1","amount":"3177","total_amount":"3177","erpStore":null,"product":{"id":2103,"name":"PAN-PA-440-AWF-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":618,"product_misc":null,"product_qa":null,"pn":"","description":"PA-440, Advanced WildFire subscription, 1 year (12 months), term,renewal","created_by":1013,"created_at":"2025-08-15 15:27:41","updated_at":"2025-08-21 09:20:52","pinyin_shortcut":"PANPA440AWFR","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":618,"key":618,"name":"PA440\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":34,"erp_purchase_order_id":2021,"erp_store_id":null,"product_id":2103,"description":"","number":"1","into_inventory":"1","amount":"3177","total_amount":"3177","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2021,"serial_no":"CGDD-20250819-00003","from_date":null,"wrote_date":"2025-08-18","handler":1011,"supplier_id":163,"purchase_contract_id":4100,"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-08-20 14:59:09","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"4","amount":"11528","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 17:11:29","updated_at":"2025-08-20 14:59:09","erpPurchaseOrderVerifyRels":[{"id":19,"erp_purchase_order_id":2021,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-19 17:12:01"},{"id":20,"erp_purchase_order_id":2021,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:59:09"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":11528,"approve_amount":0,"un_approve_amount":11528,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"0","un_collected":11528,"collected_plan":11528,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":11528,"product_number":4,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4093,"supplier_id":236,"contract_type":3,"signed_at":"2025-08-15","amount":"7304","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-08-15 11:39:12","updated_at":"2025-08-15 17:39:44","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250815-ZHF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-15 13:42:51","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7304","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"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":4093,"comment":5},"purchaseClientRels":[{"id":3768,"contract_id":4093,"client_id":2032,"project_id":3936,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":5295,"clickable":1},"project":{"id":3936,"key":3936,"name":"2025\u5e74\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"21","key":"21","contract_id":4093,"value":"2326.5","collected_date":"2025-08-22 16:57:21","created_at":"2025-08-22 16:57:21","created_by":5388,"description":"\u4eac\u897f\u5b66\u6821\u670d\u52a1\u4e2d\u6b62\u9000\u6b3e","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":31.85},{"id":"12077","key":"12077","contract_id":4093,"value":"4977.50","collected_date":"2025-08-15 15:28:23","created_at":"2025-08-15 15:28:23","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u5929\u4fe1\u5b8f\u8fbe\n","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":68.15}],"purchaseContractInvoices":[{"id":2411,"key":2411,"contract_id":4093,"amount":"7304","value":"7304","attachment_id":null,"from_date":"2025-08-20","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":48683,"object_type":103,"object_id":2411,"attachment_id":27661,"attachment":{"id":27661,"key":27661,"name":"de512b10-41e8-3c69-8dde-8591630d9c51","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/de512b10-41e8-3c69-8dde-8591630d9c51\/dzfp_25112000000175013667_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250820160704.pdf","orig_name":"dzfp_25112000000175013667_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250820160704.pdf"}}]}],"contractScans":[{"id":48502,"object_type":108,"object_id":4093,"attachment_id":27526,"attachment":{"id":27526,"key":27526,"name":"065c2302-4272-3af3-9a6f-78e8f94ee388","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/065c2302-4272-3af3-9a6f-78e8f94ee388\/\u5408\u540c(3).pdf","orig_name":"\u5408\u540c(3).pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1407,"user_id":1011,"key":1011,"contract_id":4093,"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":1408,"user_id":5360,"key":5360,"contract_id":4093,"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":832,"key":832,"contract_id":4093,"name":"2025-08-15","value":"7304","overdue_days":7,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2155,"client_id":2032,"project_id":3936,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-08-15 15:09:19","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u91cd\u5e86\u7075\u72d0\u2014\u6df1\u4fe1\u670dAC\u7eed\u4fdd\u8d27\u6b3e\uff0c\u91d1\u989d7304\u5143\uff0c\u4e0e\u603b\u4ee3\u62bc\u91d1\u62b5\u62632326.5\u5143\uff0c\u9700\u652f\u4ed8\u5269\u4f59\u8d27\u6b3e4977.5\u5143\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-08-15 11:55:34","updated_at":"2025-08-15 15:09:19","supplier_id":236,"purchase_contract_id":4093,"amount":"4977.5","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"4977.5","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":41,"purchase_contract_id":4093,"erp_store_id":null,"erp_purchase_order_product_id":21,"product_id":1722,"description":"","number":"1","amount":"4058","total_amount":"4058","erpStore":null,"product":{"id":1722,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1457,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:32","updated_at":"2025-08-20 11:08:18","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1400","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1457,"key":1457,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":21,"erp_purchase_order_id":2016,"erp_store_id":null,"product_id":1722,"description":"","number":"1","into_inventory":"1","amount":"4058","total_amount":"4058","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":42,"purchase_contract_id":4093,"erp_store_id":null,"erp_purchase_order_product_id":22,"product_id":1717,"description":"","number":"1","amount":"3246","total_amount":"3246","erpStore":null,"product":{"id":1717,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1455,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:18:36","updated_at":"2025-08-20 11:08:18","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1400","product_unit":2,"is_renew":true,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1455,"key":1455,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":22,"erp_purchase_order_id":2016,"erp_store_id":null,"product_id":1717,"description":"","number":"1","into_inventory":"1","amount":"3246","total_amount":"3246","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2016,"serial_no":"CGDD-20250815-00001","from_date":null,"wrote_date":"2025-08-15","handler":5360,"supplier_id":236,"purchase_contract_id":4093,"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-08-15 14:33:49","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"2","amount":"7304","created_by":5360,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-15 11:39:13","updated_at":"2025-08-15 14:33:49","erpPurchaseOrderVerifyRels":[{"id":9,"erp_purchase_order_id":2016,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-15 11:43:43"},{"id":10,"erp_purchase_order_id":2016,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-15 14:33:49"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":7304,"approve_amount":4977.5,"un_approve_amount":2326.5,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"7304","un_collected":0,"collected_plan":7304,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":7304,"product_number":2,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4063,"supplier_id":719,"contract_type":3,"signed_at":"2025-07-23","amount":"3000.00","handler":1011,"description":"PA\u914d\u7f6e\u7ffb\u8bd1\uff1b\n\u66ff\u6362\u8bbe\u5907\u5b9e\u65bd\uff08\u5468\u672b\uff09","contract_scan":null,"created_by":1011,"created_at":"2025-07-23 14:42:05","updated_at":"2025-08-08 13:55:14","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250807-HYF-002","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 14:42:15","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"3000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":719,"key":719,"name":"\u5317\u4eac\u5408\u529b\u521b\u535a\u4fe1\u606f\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8"},"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":4063,"comment":4},"purchaseClientRels":[{"id":3676,"contract_id":4063,"client_id":3343,"project_id":3841,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","sales_rep":1004,"clickable":1},"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"12074","key":"12074","contract_id":4063,"value":"3000","collected_date":"2025-08-12 10:34:41","created_at":"2025-08-12 10:34:41","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u5408\u529b\u521b\u535a","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2395,"key":2395,"contract_id":4063,"amount":"3000","value":"3000","attachment_id":null,"from_date":"2025-08-08","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":37601,"object_type":103,"object_id":2395,"attachment_id":27326,"attachment":{"id":27326,"key":27326,"name":"20804433-ded7-34eb-ac86-3d1b32b29bf0","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/20804433-ded7-34eb-ac86-3d1b32b29bf0\/dzfp_25112000000166065793_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250808131930.pdf","orig_name":"dzfp_25112000000166065793_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250808131930.pdf"}}]}],"contractScans":[{"id":37600,"object_type":108,"object_id":4063,"attachment_id":27327,"attachment":{"id":27327,"key":27327,"name":"ece15895-a861-39e4-bb66-ddac504e2994","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/ece15895-a861-39e4-bb66-ddac504e2994\/\u626b\u63cf\u5168\u80fd\u738b 2025-08-08 13.11.pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2025-08-08 13.11.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1354,"user_id":1011,"key":1011,"contract_id":4063,"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":1355,"user_id":5360,"key":5360,"contract_id":4063,"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":802,"key":802,"contract_id":4063,"name":"2025-07-28","value":"3000","overdue_days":15,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2135,"client_id":3343,"project_id":3841,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u5408\u529b\u521b\u535a\u4fe1\u606f\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-08-11 19:15:50","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u603b\u4ee3\u6280\u672f\u670d\u52a1\u8d39\uff08\u9879\u76ee\u5df2\u7ecf\u5b89\u88c5\u8c03\u8bd5\u5b8c\u6bd5\uff09\uff0c\u670d\u52a1\u8d39\u91d1\u989d3000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u8d26\u6237\uff1a\n\u5317\u4eac\u5408\u529b\u521b\u535a\u4fe1\u606f\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u767e\u65fa\u65b0\u57ce\u652f\u884c\n\u8d26\u53f7\uff1a0200186519200059482\n\n\u5907\u6ce8\uff1a\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-08-11 16:04:14","updated_at":"2025-08-11 19:15:50","supplier_id":719,"purchase_contract_id":4063,"amount":"3000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"3000","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1999,"serial_no":"CGDD-20250723-00002","from_date":null,"wrote_date":"2025-07-23","handler":1011,"supplier_id":719,"purchase_contract_id":4063,"erp_store_id":null,"status":2,"abstract":null,"description":"PA\u914d\u7f6e\u7ffb\u8bd1\uff1b\n\u66ff\u6362\u8bbe\u5907\u5b9e\u65bd\uff08\u5468\u672b\uff09","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-07-23 14:42:05","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"0","amount":"3000.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-07-23 14:42:05","updated_at":"2025-08-08 13:55:14","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":3000,"approve_amount":3000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"3000","un_collected":0,"collected_plan":3000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4051,"supplier_id":138,"contract_type":3,"signed_at":"2025-07-21","amount":"900.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-07-21 11:18:14","updated_at":"2025-07-25 09:02:47","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250721-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 11:18:58","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"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":4051,"comment":3},"purchaseClientRels":[{"id":3574,"contract_id":4051,"client_id":2094,"project_id":3704,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"clickable":1},"project":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"1459","key":"1459","contract_id":4051,"value":"900","collected_date":"2025-07-22 14:55:21","created_at":"2025-07-22 14:55:21","created_by":1013,"description":null,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2375,"key":2375,"contract_id":4051,"amount":"900","value":"900","attachment_id":null,"from_date":"2025-07-24","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":36041,"object_type":103,"object_id":2375,"attachment_id":27091,"attachment":{"id":27091,"key":27091,"name":"c28e6341-aa60-3de5-b71b-e307da93978b","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/c28e6341-aa60-3de5-b71b-e307da93978b\/202507225114_25952000000150599805.pdf","orig_name":"202507225114_25952000000150599805.pdf"}}]}],"contractScans":[{"id":36039,"object_type":108,"object_id":4051,"attachment_id":27090,"attachment":{"id":27090,"key":27090,"name":"aa11d1c4-bcb6-3be1-8d5c-23a2f43f8889","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/aa11d1c4-bcb6-3be1-8d5c-23a2f43f8889\/20250718_\u8bbe\u5907\u635f\u8017\u8d54\u507f\u534f\u8bae.pdf","orig_name":"20250718_\u8bbe\u5907\u635f\u8017\u8d54\u507f\u534f\u8bae.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1326,"user_id":1011,"key":1011,"contract_id":4051,"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":1327,"user_id":5360,"key":5360,"contract_id":4051,"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":788,"key":788,"contract_id":4051,"name":"2025-07-21","value":"900","overdue_days":1,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2074,"client_id":2094,"project_id":3704,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-07-21 11:28:51","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d 3\u4e2a\u6d4b\u8bd5Ukey\u635f\u8017\u8d39\uff0c\u91d1\u989d\uffe5900\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u9ad8\u65b0\u56ed\u79d1\u521b\u652f\u884c\n\u5e10\u6237\u540d\u79f0\uff1a\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u5e10\u53f7\uff1a811980479210001\n\n\u5907\u6ce8\uff1a\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-07-21 11:28:35","updated_at":"2025-07-21 11:28:51","supplier_id":138,"purchase_contract_id":4051,"amount":"900","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"900","erp_payment_un_settle_amount":"-900","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1990,"serial_no":"CGDD-20250721-00001","from_date":null,"wrote_date":"2025-07-21","handler":1011,"supplier_id":138,"purchase_contract_id":4051,"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 11:18:14","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"900.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-07-21 11:18:14","updated_at":"2025-07-25 09:02:47","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":900,"approve_amount":900,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"900","un_collected":0,"collected_plan":900,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"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},{"id":4031,"supplier_id":660,"contract_type":3,"signed_at":"2025-07-14","amount":"122524.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-07-14 16:17:55","updated_at":"2025-07-14 16:18:24","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"SLKX20250714001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-14 16:18:24","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"122524","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":660,"key":660,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"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":4031,"comment":4},"purchaseClientRels":[{"id":3563,"contract_id":4031,"client_id":3378,"project_id":3906,"client":{"id":3378,"key":3378,"name":"\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"clickable":1},"project":{"id":3906,"key":3906,"name":"\u601d\u79d1N9K\u7eed\u4fdd\u9879\u76ee","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":"12122","key":"12122","contract_id":4031,"value":"122524","collected_date":"2025-08-29 10:05:17","created_at":"2025-08-29 10:05:17","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u601d\u8054\u79d1\u8baf","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2390,"key":2390,"contract_id":4031,"amount":"122524","value":"122524","attachment_id":null,"from_date":"2025-08-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":37557,"object_type":103,"object_id":2390,"attachment_id":27292,"attachment":{"id":27292,"key":27292,"name":"518040d2-b9b1-3633-ad1a-35cea871ad91","extension":"pdf","path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/518040d2-b9b1-3633-ad1a-35cea871ad91\/dzfp_25112000000164332129_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250806134139.pdf","orig_name":"dzfp_25112000000164332129_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250806134139.pdf"}}]}],"contractScans":[{"id":35722,"object_type":108,"object_id":4031,"attachment_id":26828,"attachment":{"id":26828,"key":26828,"name":"693de6f6-14f5-3b06-a2ed-d5a12f33a718","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/693de6f6-14f5-3b06-a2ed-d5a12f33a718\/2025_07_14_16_12_08.pdf","orig_name":"2025_07_14_16_12_08.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1294,"user_id":1011,"key":1011,"contract_id":4031,"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":1295,"user_id":5360,"key":5360,"contract_id":4031,"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":771,"key":771,"contract_id":4031,"name":"2025-08-22","value":"122524","overdue_days":7,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2216,"client_id":3378,"project_id":3906,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-08-29 09:41:44","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\u601d\u8054\u79d1\u8baf\u601d\u79d1\u670d\u52a1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a122524\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\u601d\u8054\u548c\u82f1\u8fc8\u7684\u6b3e8-31\u65e5\u5230\u671f\u3002\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-29 09:41:29","updated_at":"2025-08-29 09:41:44","supplier_id":660,"purchase_contract_id":4031,"amount":"122524","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"122524","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1982,"serial_no":"CGDD-20250714-00002","from_date":null,"wrote_date":"2025-07-14","handler":1011,"supplier_id":660,"purchase_contract_id":4031,"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-14 16:17:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"0","amount":"122524.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-07-14 16:17:55","updated_at":"2025-07-14 16:18:24","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":122524,"approve_amount":122524,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"122524","un_collected":0,"collected_plan":122524,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true}],"pagenation":{"totalcount":483,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 16:33:51') RETURNING "id" |
| 16:33:51.255 | 2.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om' |
| 16:33:51.253 | 1.9 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:33:51.311 | 1.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2375, 2390, 2395, 2409, 2410, 2411, 2420, 2422, 2423, 2434)) |
| 16:33:51.314 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031)) |
| 16:33:51.309 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2375, 2390, 2395, 2409, 2410, 2411, 2420, 2422, 2423, 2434)) |
| 16:33:51.316 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031)) |
| 16:33:51.259 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:33:51.320 | 1.5 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 (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031)) GROUP BY "r"."id" |
| 16:33:51.345 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) |
| 16:33:51.308 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) ORDER BY "id" |
| 16:33:51.322 | 0.7 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 (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031)) ORDER BY "id" |
| 16:33:51.341 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (942, 1722, 1717, 1961, 2101, 2104, 2103, 2108, 1624) |
| 16:33:51.303 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3906, 3704, 3841, 3883, 3949, 3849, 3936, 3927) |
| 16:33:51.302 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) ORDER BY "id" |
| 16:33:51.347 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) |
| 16:33:51.340 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) |
| 16:33:51.319 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) ORDER BY "remind_date" |
| 16:33:51.313 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27091, 27292, 27326, 27647, 27660, 27661, 27753, 27776, 27787, 27891) |
| 16:33:51.344 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (44, 45, 21, 22, 31, 32, 33, 34, 37, 56, 58) |
| 16:33:51.318 | 0.4 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 (4122, 4119, 4108, 4107, 4103, 4100, 4093, 4063, 4051, 4031) |
| 16:33:51.279 | 0.4 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360)) |
| 16:33:51.346 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (2038, 2016, 2021, 2036, 2024, 2028, 2027, 1999, 1982, 1990) ORDER BY "id" |
| 16:33:51.280 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3 |
| 16:33:51.342 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (22, 5, 19) |
| 16:33:51.278 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 724, 618, 293, 163, 236, 719, 138, 660) |
| 16:33:51.343 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1457, 1694, 593, 618, 1613, 1455, 1382) |
| 16:33:51.302 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3378, 2094, 3343, 2182, 2845, 2032, 3286) |
| 16:33:51.346 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (2038, 2016, 2021, 2036, 2024, 2028, 2027, 1999, 1982, 1990) ORDER BY "id" |
| 16:33:51.343 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 8, 134) |
| 16:33:51.342 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (208, 214, 151, 35, 200, 189, 36) |
| 16:33:51.347 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (2038, 2016, 2021, 2036, 2024, 2028, 2027, 1999, 1982, 1990) ORDER BY "id" |
| 16:33:51.279 | 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) |
| 16:33:51.344 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 7, 8) |
| 16:33:51.316 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26828, 27090, 27327, 27526, 27679, 27711, 27785, 27885) |
| 16:33:51.308 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013, 1001) |
| 16:33:51.280 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360) |
| 16:33:51.319 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360) |
| 16:33:51.318 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27710, 27884) |
| 16:33:51.281 | 0.2 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, 5360)) |
| 16:33:51.319 | 0.2 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, 5360)) |