ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689990cb59160: POST https://beta.jinchangxiao.com/vue/purchase-contract/list at 2025-08-11 02:42:19 pm by 124.64.23.198

Performance Profiling

Total processing time: 239 ms; Peak memory: 7.059 MB. Show Profiling Timeline

总计43条数据
TimeDurationCategoryInfo
  
14:42:19.41831.7 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)) GROUP BY "object_id"
14:42:19.51931.5 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)) GROUP BY "object_id"
14:42:19.38122.4 msyii\db\Command::querySELECT 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
14:42:19.49619.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 (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)) GROUP BY "r"."id"
14:42:19.45817.8 msyii\db\Command::querySELECT "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"."status" IN (2, 5, 1)) 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, 1) ) 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, 1) ) 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, 1) )) "sub") "r" WHERE "contract_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253) ORDER BY "id" DESC
14:42:19.5706.4 msyii\db\Command::querySELECT SUM(amount) 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"."status" IN (2, 5, 1)) 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, 1) ) 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, 1) ) 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, 1) )) "sub" WHERE "contract_id" IN (SELECT "c"."id" 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)
14:42:19.4525.9 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3552, 3544, 3590, 3514, 3568, 3515, 3633, 3653, 3686, 3661, 3660, 3652, 3589, 3577, 3679, 3591, 3599, 3576, 3644)
14:42:19.5955.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/list', '{"PurchaseContractSearch":{"contract_type":"","handler":"","group":"1","invoice_status":"","payment_status":"","contract_scan":"","created_by":"","is_chargeback":"","collected_plan":"","is_draft":"","invoice_from_date_period":"","sales_rep":"1001"},"Filter":{"name":"signed_at","sort":"DESC"},"page":"2","from_project":"1","web_access_token":"HcPbdczjiT4Sp46OV0lNGsvc5AuI1uUw"}', '{"code":2000,"result":{"list":[{"id":3621,"supplier_id":511,"contract_type":1,"signed_at":"2024-10-23","amount":"155750.00","handler":1011,"description":"175000*0.95-10000-500","contract_scan":"","created_by":1011,"created_at":"2024-10-23 15:32:20","updated_at":"2024-12-18 11:26:09","client_id":"","project_id":"","sales_rep":"","serial_no":"KJS1X24211","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-23 15:32:37","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"155750","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":{},"project":{},"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3621,"comment":1},"purchaseClientRels":[{"id":2806,"contract_id":3621,"client_id":3301,"project_id":3679,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001},"project":{"id":3679,"key":3679,"name":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u670d\u52a1\u9879\u76ee\uff08\u8fc7\u5355\uff09","project_status":3}}],"purchaseContractPayments":[{"id":"1276","key":"1276","contract_id":3621,"value":"155750.00","collected_date":"2024-12-25 10:47:35","created_at":"2024-12-25 10:47:35","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2072,"key":2072,"contract_id":3621,"amount":"155750","value":"155750","attachment_id":"","from_date":"2024-12-18","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31182,"object_type":103,"object_id":2072,"attachment_id":23287,"attachment":{"id":23287,"key":23287,"name":"3791f00d-d6cb-3ad7-84eb-48f4816395c8","extension":"pdf","path":"\/vue\/attachment\/view\/3791f00d-d6cb-3ad7-84eb-48f4816395c8\/dzfp_24112000000214059681_\u00b1\u00b1\u00e6\u00a9\u201c\u201a\u2265\u00a9\u00f8\u2206\u00ba\u00ba\u03c0\u2026\u2211\u203a\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20241218104016.pdf","orig_name":"dzfp_24112000000214059681_\u00b1\u00b1\u00e6\u00a9\u201c\u201a\u2265\u00a9\u00f8\u2206\u00ba\u00ba\u03c0\u2026\u2211\u203a\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20241218104016.pdf"}}]}],"contractScans":[{"id":31186,"object_type":108,"object_id":3621,"attachment_id":23268,"attachment":{"id":23268,"key":23268,"name":"e68c43d0-362b-3275-afa0-44c4e278ae64","extension":"pdf","path":"\/vue\/attachment\/preview\/e68c43d0-362b-3275-afa0-44c4e278ae64\/2024_12_17_14_44_45.pdf","orig_name":"2024_12_17_14_44_45.pdf"}}],"receiptScans":[{"id":31187,"object_type":111,"object_id":3621,"attachment_id":23271,"attachment":{"id":23271,"key":23271,"name":"66fc3c8a-6cab-36c5-b8da-891fb789978a","extension":"pdf","path":"\/vue\/attachment\/preview\/66fc3c8a-6cab-36c5-b8da-891fb789978a\/2024_12_17_15_03_08.pdf","orig_name":"2024_12_17_15_03_08.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":657,"user_id":1011,"key":1011,"contract_id":3621,"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":658,"user_id":5360,"key":5360,"contract_id":3621,"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":419,"key":419,"contract_id":3621,"name":"2024-12-31","value":"155750","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1532,"client_id":3301,"project_id":3679,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-12-25 10:18:29","description":"\u8001\u5927\uff0c\u91d1\u878d\u65f6\u62a5\u793e-\u6df1\u4fe1\u670d\u8fc7\u5355\u9879\u76ee\uff0c\u9500\u552e\u6b3e\u9879\u5df2\u6536\u56de\uff0c\u7533\u8bf7\u652f\u4ed8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d155750\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-12-25 10:18:06","updated_at":"2024-12-25 10:18:29","supplier_id":511,"purchase_contract_id":3621,"amount":"155750","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"155750","erp_payment_un_settle_amount":"-155750","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":155750,"approve_amount":155750,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"155750","un_collected":0,"collected_plan":155750,"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},{"id":3617,"supplier_id":511,"contract_type":1,"signed_at":"2024-10-22","amount":"164065.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-22 12:53:19","updated_at":"2024-12-17 14:40:09","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241022-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-22 12:53:45","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"164065","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":{},"project":{},"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3617,"comment":3},"purchaseClientRels":[{"id":2500,"contract_id":3617,"client_id":3301,"project_id":3653,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001},"project":{"id":3653,"key":3653,"name":"\u6df1\u4fe1\u670dAD-1000-B1800-TP 2\u53f0\u91c7\u8d2d\u9879\u76ee\uff08\u8fc7\u5355\uff09","project_status":3}}],"purchaseContractPayments":[{"id":"1278","key":"1278","contract_id":3617,"value":"164065.00","collected_date":"2024-12-25 10:49:06","created_at":"2024-12-25 10:49:06","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1976,"key":1976,"contract_id":3617,"amount":"164065","value":"164065","attachment_id":"","from_date":"2024-10-22","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29522,"object_type":103,"object_id":1976,"attachment_id":22167,"attachment":{"id":22167,"key":22167,"name":"2bca828e-a5c9-3ca4-8cee-6aa05ca0a2cb","extension":"pdf","path":"\/vue\/attachment\/view\/2bca828e-a5c9-3ca4-8cee-6aa05ca0a2cb\/dzfp_24112000000159432337_\u00b1\u00b1\u00e6\u00a9\u201c\u201a\u2265\u00a9\u00f8\u2206\u00ba\u00ba\u03c0\u2026\u2211\u203a\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20241022155202.pdf","orig_name":"dzfp_24112000000159432337_\u00b1\u00b1\u00e6\u00a9\u201c\u201a\u2265\u00a9\u00f8\u2206\u00ba\u00ba\u03c0\u2026\u2211\u203a\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20241022155202.pdf"}}]}],"contractScans":[{"id":29518,"object_type":108,"object_id":3617,"attachment_id":22162,"attachment":{"id":22162,"key":22162,"name":"d420a96d-84dd-30a5-ad99-67f19cb393f4","extension":"pdf","path":"\/vue\/attachment\/preview\/d420a96d-84dd-30a5-ad99-67f19cb393f4\/2024_10_22_14_40_51.pdf","orig_name":"2024_10_22_14_40_51.pdf"}}],"receiptScans":[{"id":31163,"object_type":111,"object_id":3617,"attachment_id":23258,"attachment":{"id":23258,"key":23258,"name":"8758a4f9-8548-3eef-8988-8b7170946de1","extension":"pdf","path":"\/vue\/attachment\/preview\/8758a4f9-8548-3eef-8988-8b7170946de1\/2024_12_17_14_38_50.pdf","orig_name":"2024_12_17_14_38_50.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":649,"user_id":1011,"key":1011,"contract_id":3617,"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":650,"user_id":5360,"key":5360,"contract_id":3617,"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":415,"key":415,"contract_id":3617,"name":"2024-11-22","value":"164065","overdue_days":33,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1531,"client_id":3301,"project_id":3653,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-12-25 10:18:36","description":"\u8001\u5927\uff0c\u91d1\u878d\u65f6\u62a5\u793e-\u6df1\u4fe1\u670d\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d164065\u5143\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-12-25 09:37:01","updated_at":"2024-12-25 10:18:36","supplier_id":511,"purchase_contract_id":3617,"amount":"164065","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"164065","erp_payment_un_settle_amount":"-164065","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":164065,"approve_amount":164065,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"164065","un_collected":0,"collected_plan":164065,"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},{"id":3600,"supplier_id":68,"contract_type":1,"signed_at":"2024-10-16","amount":"55000.00","handler":1011,"description":"\u5408\u540c\u91d1\u989d75000\u5143\uff0c\u4f7f\u75282\u4e07\u7684\u8fd4\u5229\u62b5\u6263","contract_scan":"","created_by":1011,"created_at":"2024-10-16 11:15:48","updated_at":"2024-11-01 17:27:29","client_id":"","project_id":"","sales_rep":"","serial_no":"BJ7067IM20241016-01","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-11-01 17:27:29","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"55000","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":{},"project":{},"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3600,"comment":2},"purchaseClientRels":[{"id":2516,"contract_id":3600,"client_id":3311,"project_id":3686,"client":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3686,"key":3686,"name":"\u7fa4\u6656\u5b58\u50a8DS923+\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1254","key":"1254","contract_id":3600,"value":"55000.00","collected_date":"2024-11-29 13:54:07","created_at":"2024-11-29 13:54:07","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1972,"key":1972,"contract_id":3600,"amount":"55000","value":"55000","attachment_id":"","from_date":"2024-10-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29488,"object_type":103,"object_id":1972,"attachment_id":22140,"attachment":{"id":22140,"key":22140,"name":"078c125b-4df2-34f1-8185-f088554b575a","extension":"pdf","path":"\/vue\/attachment\/view\/078c125b-4df2-34f1-8185-f088554b575a\/20241021-24312000000322791620.pdf","orig_name":"20241021-24312000000322791620.pdf"}}]}],"contractScans":[{"id":29756,"object_type":108,"object_id":3600,"attachment_id":22039,"attachment":{"id":22039,"key":22039,"name":"1b0e7689-b33c-37dc-a87e-a9e338023ced","extension":"pdf","path":"\/vue\/attachment\/preview\/1b0e7689-b33c-37dc-a87e-a9e338023ced\/30-24952-11\u53cc\u7ae0.pdf","orig_name":"30-24952-11\u53cc\u7ae0.pdf"}},{"id":29757,"object_type":108,"object_id":3600,"attachment_id":22314,"attachment":{"id":22314,"key":22314,"name":"4e5af8f5-7a91-3408-bde4-d6106d07a78c","extension":"pdf","path":"\/vue\/attachment\/preview\/4e5af8f5-7a91-3408-bde4-d6106d07a78c\/20000\u5143\u6298\u6263\u5355.pdf","orig_name":"20000\u5143\u6298\u6263\u5355.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":709,"user_id":1011,"key":1011,"contract_id":3600,"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":710,"user_id":5360,"key":5360,"contract_id":3600,"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":446,"key":446,"contract_id":3600,"name":"2024-11-30","value":"55000","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1442,"client_id":3311,"project_id":3686,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-11-28 09:39:20","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u534e\u8fb0\u60a6\u79d1\u6280-\u7fa4\u6656\u91c7\u8d2d\u8d27\u6b3e\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u671f\u671b11\u670829\u65e5\uff08\u5468\u4e94\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-11-28 09:38:38","updated_at":"2024-11-28 09:39:20","supplier_id":68,"purchase_contract_id":3600,"amount":"55000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"55000","erp_payment_un_settle_amount":"-55000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":55000,"approve_amount":55000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"55000","un_collected":0,"collected_plan":55000,"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},{"id":3574,"supplier_id":531,"contract_type":1,"signed_at":"2024-10-09","amount":"1200.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-09 09:35:10","updated_at":"2024-10-10 11:26:34","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241009-HYF-002","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-09 09:35:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3574,"comment":2},"purchaseClientRels":[{"id":3104,"contract_id":3574,"client_id":2553,"project_id":3644,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1135","key":"1135","contract_id":3574,"value":"1200.00","collected_date":"2024-10-12 13:18:36","created_at":"2024-10-12 13:18:36","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1955,"key":1955,"contract_id":3574,"amount":"1200","value":"1200","attachment_id":"","from_date":"2024-10-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29182,"object_type":103,"object_id":1955,"attachment_id":21863,"attachment":{"id":21863,"key":21863,"name":"347c3a62-c8b7-3724-ac2d-8b2ee3c031f6","extension":"pdf","path":"\/vue\/attachment\/view\/347c3a62-c8b7-3724-ac2d-8b2ee3c031f6\/dzfp_24112000000149152238_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241011095437.pdf","orig_name":"dzfp_24112000000149152238_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20241011095437.pdf"}}]}],"contractScans":[{"id":29129,"object_type":108,"object_id":3574,"attachment_id":21825,"attachment":{"id":21825,"key":21825,"name":"3588a80e-00ef-386e-a79b-a3e84bac8190","extension":"pdf","path":"\/vue\/attachment\/preview\/3588a80e-00ef-386e-a79b-a3e84bac8190\/2024_10_10_09_45_59.pdf","orig_name":"2024_10_10_09_45_59.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":565,"user_id":1011,"key":1011,"contract_id":3574,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":566,"user_id":5360,"key":5360,"contract_id":3574,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":367,"key":367,"contract_id":3574,"name":"2024-10-10","value":"1200","overdue_days":2,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1263,"client_id":2553,"project_id":3644,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-10-10 15:56:39","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u8d27\u6b3e\u91d1\u989d\uffe51200\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-10-10 11:38:50","updated_at":"2024-10-10 15:56:39","supplier_id":531,"purchase_contract_id":3574,"amount":"1200","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"1200","erp_payment_un_settle_amount":"-1200","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":1200,"approve_amount":1200,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1200","un_collected":0,"collected_plan":1200,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3610,"supplier_id":46,"contract_type":1,"signed_at":"2024-09-20","amount":"132320.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-21 12:36:56","updated_at":"2024-10-23 15:59:34","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ202409201129580","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-21 12:37:31","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"132320","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":{},"project":{},"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3610,"comment":1},"purchaseClientRels":[{"id":2784,"contract_id":3610,"client_id":3304,"project_id":3661,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3661,"key":3661,"name":"4\u53f0 PA440\u5957\u5305\u4ea7\u54c1\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1167","key":"1167","contract_id":3610,"value":"132320.00","collected_date":"2024-10-21 15:00:23","created_at":"2024-10-21 15:00:23","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1977,"key":1977,"contract_id":3610,"amount":"132320","value":"132320","attachment_id":"","from_date":"2024-10-23","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29529,"object_type":103,"object_id":1977,"attachment_id":22173,"attachment":{"id":22173,"key":22173,"name":"c7a1d426-7190-352d-8e77-471023c1fbc9","extension":"pdf","path":"\/vue\/attachment\/view\/c7a1d426-7190-352d-8e77-471023c1fbc9\/24112000000160013203.pdf","orig_name":"24112000000160013203.pdf"}}]}],"contractScans":[{"id":29463,"object_type":108,"object_id":3610,"attachment_id":22123,"attachment":{"id":22123,"key":22123,"name":"fb714562-7db5-3c03-bbc9-b9b98dcd5507","extension":"pdf","path":"\/vue\/attachment\/preview\/fb714562-7db5-3c03-bbc9-b9b98dcd5507\/DZ202409201129580.pdf","orig_name":"DZ202409201129580.pdf"}}],"receiptScans":[{"id":29541,"object_type":111,"object_id":3610,"attachment_id":22180,"attachment":{"id":22180,"key":22180,"name":"c1a8debc-d57f-3ee2-9f76-9c87eebd280b","extension":"pdf","path":"\/vue\/attachment\/preview\/c1a8debc-d57f-3ee2-9f76-9c87eebd280b\/2024_10_23_15_56_50.pdf","orig_name":"2024_10_23_15_56_50.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":629,"user_id":1011,"key":1011,"contract_id":3610,"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":630,"user_id":5360,"key":5360,"contract_id":3610,"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":401,"key":401,"contract_id":3610,"name":"2024-12-16","value":"132320","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1312,"client_id":3304,"project_id":3661,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5f00\u5ef6\u652f-\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-10-21 13:03:12","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u5929\u5f00\u5177\u4e00\u5f2055\u5929\u7684\u5ef6\u652f\uff0c\u91d1\u989d\uff1a\uffe5132320\uff0c\u65e5\u671f\uff1a2024\u5e7412\u670816\u65e5\u3002\u7528\u4e8e\u63d0\u8d27\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-10-21 12:51:05","updated_at":"2024-10-21 13:03:12","supplier_id":46,"purchase_contract_id":3610,"amount":"132320","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"132320","erp_payment_un_settle_amount":"-132320","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":132320,"approve_amount":132320,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"132320","un_collected":0,"collected_plan":132320,"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},{"id":3582,"supplier_id":90,"contract_type":1,"signed_at":"2024-09-20","amount":"74757.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-10 15:30:52","updated_at":"2024-10-30 13:23:13","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ25477","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-29 13:45:38","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"74757","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3582,"comment":5},"purchaseClientRels":[{"id":2785,"contract_id":3582,"client_id":2845,"project_id":3660,"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},"project":{"id":3660,"key":3660,"name":"Panorama\u8bbe\u5907\u53ca\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1246","key":"1246","contract_id":3582,"value":"11757.00","collected_date":"2024-12-27 10:12:12","created_at":"2024-12-27 10:12:12","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":15.73},{"id":"1243","key":"1243","contract_id":3582,"value":"63000.00","collected_date":"2024-12-10 10:35:16","created_at":"2024-12-10 10:35:16","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":84.27}],"purchaseContractInvoices":[{"id":1958,"key":1958,"contract_id":3582,"amount":"63000","value":"63000","attachment_id":"","from_date":"2024-10-12","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29252,"object_type":103,"object_id":1958,"attachment_id":21928,"attachment":{"id":21928,"key":21928,"name":"d8bb396d-90fe-369e-bd47-df286a4e7a7b","extension":"pdf","path":"\/vue\/attachment\/view\/d8bb396d-90fe-369e-bd47-df286a4e7a7b\/63000.pdf","orig_name":"63000.pdf"}}]},{"id":1995,"key":1995,"contract_id":3582,"amount":"11757","value":"11757","attachment_id":"","from_date":"2024-10-30","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29803,"object_type":103,"object_id":1995,"attachment_id":22349,"attachment":{"id":22349,"key":22349,"name":"78980027-c5e8-3261-baf9-c1be7b1b0d02","extension":"pdf","path":"\/vue\/attachment\/view\/78980027-c5e8-3261-baf9-c1be7b1b0d02\/11757.pdf","orig_name":"11757.pdf"}}]}],"contractScans":[{"id":29745,"object_type":108,"object_id":3582,"attachment_id":22307,"attachment":{"id":22307,"key":22307,"name":"5e5b24e0-2336-370e-99bb-7b848694d9f4","extension":"pdf","path":"\/vue\/attachment\/preview\/5e5b24e0-2336-370e-99bb-7b848694d9f4\/document(4).pdf","orig_name":"document(4).pdf"}}],"receiptScans":[{"id":29805,"object_type":111,"object_id":3582,"attachment_id":22351,"attachment":{"id":22351,"key":22351,"name":"02bf2978-32d9-38db-9c67-27204cc1b444","extension":"pdf","path":"\/vue\/attachment\/preview\/02bf2978-32d9-38db-9c67-27204cc1b444\/document(5).pdf","orig_name":"document(5).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":673,"user_id":1011,"key":1011,"contract_id":3582,"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":674,"user_id":5360,"key":5360,"contract_id":3582,"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":427,"key":427,"contract_id":3582,"name":"2024-12-10","value":"63000","overdue_days":0,"status":1,"pct":84.27,"collect_status":"\u5df2\u5b8c\u6210"},{"id":428,"key":428,"contract_id":3582,"name":"2024-12-27","value":"11757","overdue_days":0,"status":1,"pct":15.73,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1473,"client_id":2845,"project_id":3660,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-12-09 09:57:46","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u6052\u6cf0\u901a\u529b-PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d63000\u5143\uff0c\u671f\u671b12\u670810\u65e5\uff08\u5468\u4e8c\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-12-09 09:55:02","updated_at":"2024-12-09 09:57:46","supplier_id":90,"purchase_contract_id":3582,"amount":"63000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"63000","erp_payment_un_settle_amount":"-63000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"},{"id":1530,"client_id":2845,"project_id":3660,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-12-25 10:18:39","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u6052\u6cf0\u901a\u529b-PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d11757\u5143\uff0c12\u670827\u65e5\uff08\u5468\u4e94\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-12-25 09:34:29","updated_at":"2024-12-25 10:18:39","supplier_id":90,"purchase_contract_id":3582,"amount":"11757","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"11757","erp_payment_un_settle_amount":"-11757","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":74757,"approve_amount":74757,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"74757","un_collected":0,"collected_plan":74757,"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},{"id":3526,"supplier_id":90,"contract_type":1,"signed_at":"2024-09-06","amount":"27850.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-09-06 17:14:03","updated_at":"2024-11-11 08:58:28","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ23808","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-11-11 08:58:28","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"27850","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3526,"comment":8},"purchaseClientRels":[{"id":2786,"contract_id":3526,"client_id":3286,"project_id":3652,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3652,"key":3652,"name":"PA \u8f6f\u4ef6\u9632\u706b\u5899","project_status":3}}],"purchaseContractPayments":[{"id":"1225","key":"1225","contract_id":3526,"value":"27850.00","collected_date":"2024-11-13 15:34:55","created_at":"2024-11-13 15:34:55","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1911,"key":1911,"contract_id":3526,"amount":"27850","value":"27850","attachment_id":"","from_date":"2024-09-19","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28838,"object_type":103,"object_id":1911,"attachment_id":21604,"attachment":{"id":21604,"key":21604,"name":"4066efc5-ffe5-3661-a755-8d0aea5977cc","extension":"pdf","path":"\/vue\/attachment\/view\/4066efc5-ffe5-3661-a755-8d0aea5977cc\/93123c52-7b2b-4d18-b213-eecbb6ff81ca.pdf","orig_name":"93123c52-7b2b-4d18-b213-eecbb6ff81ca.pdf"}}]}],"contractScans":[{"id":29022,"object_type":108,"object_id":3526,"attachment_id":21395,"attachment":{"id":21395,"key":21395,"name":"22b76ca5-bf38-399f-96c0-acdab820d2fe","extension":"pdf","path":"\/vue\/attachment\/preview\/22b76ca5-bf38-399f-96c0-acdab820d2fe\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":29023,"object_type":111,"object_id":3526,"attachment_id":21552,"attachment":{"id":21552,"key":21552,"name":"ad16acc2-f0be-3b6b-b37b-2096ee294ce0","extension":"pdf","path":"\/vue\/attachment\/preview\/ad16acc2-f0be-3b6b-b37b-2096ee294ce0\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":739,"user_id":1011,"key":1011,"contract_id":3526,"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":740,"user_id":5360,"key":5360,"contract_id":3526,"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"}}},{"id":741,"user_id":5016,"key":5016,"contract_id":3526,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}},{"id":742,"user_id":1000,"key":1000,"contract_id":3526,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":461,"key":461,"contract_id":3526,"name":"2024-11-13","value":"27850","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1391,"client_id":3286,"project_id":3652,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-11-12 09:22:54","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8PA\u8f6f\u4ef6\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe527850\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-11-12 09:13:24","updated_at":"2024-11-12 09:22:54","supplier_id":90,"purchase_contract_id":3526,"amount":"27850","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"27850","erp_payment_un_settle_amount":"-27850","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":27850,"approve_amount":27850,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"27850","un_collected":0,"collected_plan":27850,"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},{"id":3503,"supplier_id":90,"contract_type":1,"signed_at":"2024-08-28","amount":"103975.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-08-28 13:10:32","updated_at":"2024-10-08 14:31:24","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ22541","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-30 15:06:16","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"103975","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3503,"comment":3},"purchaseClientRels":[{"id":3103,"contract_id":3503,"client_id":2553,"project_id":3644,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1245","key":"1245","contract_id":3503,"value":"103975.00","collected_date":"2024-11-28 09:44:59","created_at":"2024-11-28 09:44:59","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1943,"key":1943,"contract_id":3503,"amount":"103975","value":"103975","attachment_id":"","from_date":"2024-09-30","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":29055,"object_type":103,"object_id":1943,"attachment_id":21774,"attachment":{"id":21774,"key":21774,"name":"7e1362c8-2d63-35cf-8d10-d3a11096e2be","extension":"pdf","path":"\/vue\/attachment\/view\/7e1362c8-2d63-35cf-8d10-d3a11096e2be\/24122000000060563936_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"24122000000060563936_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":29036,"object_type":108,"object_id":3503,"attachment_id":21757,"attachment":{"id":21757,"key":21757,"name":"f1fea02f-5740-3bdb-bce0-c36cb66142b0","extension":"pdf","path":"\/vue\/attachment\/preview\/f1fea02f-5740-3bdb-bce0-c36cb66142b0\/103975.pdf","orig_name":"103975.pdf"}}],"receiptScans":[{"id":29068,"object_type":111,"object_id":3503,"attachment_id":21784,"attachment":{"id":21784,"key":21784,"name":"642eb99f-1b0b-31b2-96b7-f950a43768d1","extension":"pdf","path":"\/vue\/attachment\/preview\/642eb99f-1b0b-31b2-96b7-f950a43768d1\/2024_10_08_13_19_53.pdf","orig_name":"2024_10_08_13_19_53.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":559,"user_id":1011,"key":1011,"contract_id":3503,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":560,"user_id":5360,"key":5360,"contract_id":3503,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":364,"key":364,"contract_id":3503,"name":"2024-11-28","value":"103975","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1441,"client_id":2553,"project_id":3644,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-11-28 09:36:22","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\u603b\u4ee3\uff1a\u7d2b\u5149\u6653\u901a\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5103975\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u7528\u6237\u8d27\u6b3e\u5c1a\u672a\u6536\u56de\uff0c\u6b64\u9879\u76ee\u6536\u53d6\u5230\u4e00\u5f20\u627f\u5151\u65e5\u671f\uff1a2025-1-24\u3002\u56e0\u57ab\u4ed8\u8d27\u6b3e\u5468\u671f2\u4e2a\u6708\uff0c\u4ece\u5218\u70b3\u5764\u8d39\u7528\u5185\u6263\u96642\u4e2a\u70b9\u8d44\u91d1\u5360\u7528\u8d39\uffe52104\u3002\u56e0\u539f\u8d39\u7528\u5355\u5df2\u5199\uff0c\u4eca\u5929\u548c\u8d22\u52a1\u786e\u8ba4\u597d\u5982\u4f55\u505a\u5355\u636e\uff0c\u8c03\u6574\u8d39\u7528\u6700\u7ec8\u4e3a6615\u5143\u3002\n\u6838\u7b97\u8fc7\u7a0b\uff0c\u8be6\u89c1\u9644\u4ef6\u56fe\u7247\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-11-28 09:16:09","updated_at":"2024-11-28 09:36:22","supplier_id":90,"purchase_contract_id":3503,"amount":"103975","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"103975","erp_payment_un_settle_amount":"-103975","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":103975,"approve_amount":103975,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"103975","un_collected":0,"collected_plan":103975,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3494,"supplier_id":90,"contract_type":1,"signed_at":"2024-08-26","amount":"5384842.10","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-08-26 17:20:47","updated_at":"2024-09-10 09:29:43","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ22400","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-10 09:29:43","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"5384842.1","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3494,"comment":3},"purchaseClientRels":[{"id":2478,"contract_id":3494,"client_id":3296,"project_id":3633,"client":{"id":3296,"key":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3633,"key":3633,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edf\u8f6f\u4ef6\u9879\u76ee\uff08\u8fc7\u5355\uff09","project_status":3}}],"purchaseContractPayments":[{"id":"1190","key":"1190","contract_id":3494,"value":"5384842.10","collected_date":"2024-10-30 11:31:02","created_at":"2024-10-30 11:31:02","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1857,"key":1857,"contract_id":3494,"amount":"5384842.1","value":"5384842.1","attachment_id":"","from_date":"2024-08-30","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28346,"object_type":103,"object_id":1857,"attachment_id":21193,"attachment":{"id":21193,"key":21193,"name":"4093221d-b1f2-3341-95a0-4793d94041ab","extension":"pdf","path":"\/vue\/attachment\/view\/4093221d-b1f2-3341-95a0-4793d94041ab\/538484.1.pdf","orig_name":"538484.1.pdf"}}]}],"contractScans":[{"id":28206,"object_type":108,"object_id":3494,"attachment_id":21146,"attachment":{"id":21146,"key":21146,"name":"9c5ef5ad-5335-34f8-a3ba-5b63cc0acb8b","extension":"pdf","path":"\/vue\/attachment\/preview\/9c5ef5ad-5335-34f8-a3ba-5b63cc0acb8b\/document (1)(2).pdf","orig_name":"document (1)(2).pdf"}}],"receiptScans":[{"id":28207,"object_type":111,"object_id":3494,"attachment_id":21144,"attachment":{"id":21144,"key":21144,"name":"fa5441f8-88f0-3c6a-b4af-e4233c4b5b46","extension":"pdf","path":"\/vue\/attachment\/preview\/fa5441f8-88f0-3c6a-b4af-e4233c4b5b46\/document(2).pdf","orig_name":"document(2).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":491,"user_id":1011,"key":1011,"contract_id":3494,"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":492,"user_id":5360,"key":5360,"contract_id":3494,"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":326,"key":326,"contract_id":3494,"name":"2024-10-26","value":"5384842.1","overdue_days":4,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1358,"client_id":3296,"project_id":3633,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-10-30 11:14:07","description":"Tristen\uff0c\u7528\u6237\u6b3e\u9879\u5df2\u56de\uff0c\u7533\u8bf7\u4ed8\u7d2b\u5149\u6653\u901a\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d\uff1a\uffe55384842.10\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-10-30 11:12:52","updated_at":"2024-10-30 11:14:07","supplier_id":90,"purchase_contract_id":3494,"amount":"5384842.10","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"5384842.1","erp_payment_un_settle_amount":"-5384842.1","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":5384842.1,"approve_amount":5384842.1,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"5384842.1","un_collected":0,"collected_plan":5384842.1,"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},{"id":3422,"supplier_id":678,"contract_type":1,"signed_at":"2024-07-18","amount":"22000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-07-23 09:45:39","updated_at":"2025-01-09 10:47:11","client_id":"","project_id":"","sales_rep":"","serial_no":"YTYG2024","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-23 09:46:00","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"22000","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":{},"project":{},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3422,"comment":3},"purchaseClientRels":[{"id":2917,"contract_id":3422,"client_id":2545,"project_id":3599,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3599,"key":3599,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u4e8c","project_status":3}}],"purchaseContractPayments":[{"id":"193","key":"193","contract_id":3422,"value":"22000.00","collected_date":"2024-08-21 14:48:30","created_at":"2024-08-21 14:48:30","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1840,"key":1840,"contract_id":3422,"amount":"22000","value":"22000","attachment_id":"","from_date":"2024-08-20","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28106,"object_type":103,"object_id":1840,"attachment_id":21023,"attachment":{"id":21023,"key":21023,"name":"7cfc921e-8801-3a1c-bcb9-a212add8e68d","extension":"pdf","path":"\/vue\/attachment\/view\/7cfc921e-8801-3a1c-bcb9-a212add8e68d\/dzfp_24112000000109712046_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240820093051(1).pdf","orig_name":"dzfp_24112000000109712046_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240820093051(1).pdf"}}]}],"contractScans":[{"id":31645,"object_type":108,"object_id":3422,"attachment_id":20491,"attachment":{"id":20491,"key":20491,"name":"f8f8a08a-1466-32c7-8927-bf1bbd5b0a2a","extension":"pdf","path":"\/vue\/attachment\/preview\/f8f8a08a-1466-32c7-8927-bf1bbd5b0a2a\/\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf22000\u5143.pdf","orig_name":"\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf22000\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":327,"user_id":1011,"key":1011,"contract_id":3422,"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":328,"user_id":5360,"key":5360,"contract_id":3422,"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":214,"key":214,"contract_id":3422,"name":"2024-08-19","value":"22000","overdue_days":2,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":22000,"approve_amount":0,"un_approve_amount":22000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"22000","un_collected":0,"collected_plan":22000,"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},{"id":3403,"supplier_id":531,"contract_type":1,"signed_at":"2024-07-08","amount":"6000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-07-12 11:11:18","updated_at":"2024-07-12 14:01:30","client_id":"","project_id":"","sales_rep":"","serial_no":"IONE-TSKJ-20240708","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-12 11:11:32","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"6000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":531,"key":531,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3403,"comment":3},"purchaseClientRels":[{"id":2867,"contract_id":3403,"client_id":2553,"project_id":3591,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3591,"key":3591,"name":"\u5149\u6a21\u5757\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"150","key":"150","contract_id":3403,"value":"6000.00","collected_date":"2024-07-18 14:18:29","created_at":"2024-07-18 14:18:29","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1791,"key":1791,"contract_id":3403,"amount":"6000.00","value":"6000.00","attachment_id":"","from_date":"2024-07-12","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":27025,"object_type":103,"object_id":1791,"attachment_id":20227,"attachment":{"id":20227,"key":20227,"name":"2429fd74-f767-33ca-bb5e-edbad157141a","extension":"pdf","path":"\/vue\/attachment\/view\/2429fd74-f767-33ca-bb5e-edbad157141a\/dzfp_24112000000082309249_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240712150023.pdf","orig_name":"dzfp_24112000000082309249_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240712150023.pdf"}}]}],"contractScans":[{"id":27024,"object_type":108,"object_id":3403,"attachment_id":20226,"attachment":{"id":20226,"key":20226,"name":"588e189c-3019-3ce6-acc4-aed922afc373","extension":"pdf","path":"\/vue\/attachment\/preview\/588e189c-3019-3ce6-acc4-aed922afc373\/\u62d3\u5b9e\u5408\u540c-\u626b\u63cf20240712.pdf","orig_name":"\u62d3\u5b9e\u5408\u540c-\u626b\u63cf20240712.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":305,"user_id":1011,"key":1011,"contract_id":3403,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":306,"user_id":5360,"key":5360,"contract_id":3403,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":202,"key":202,"contract_id":3403,"name":"2024-07-18","value":"6000","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1052,"client_id":2553,"project_id":3591,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u2014\uffe56000","status":2,"next_verify_user":"","verify_at":"2024-07-18 11:51:52","description":"\u8001\u5927\uff0c\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u5149\u6a21\u5757\u91c7\u8d2d\u9879\u76ee\uff0c\u91c7\u8d2d\u6210\u672c6000\u5143\uff0c\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u73b0\u7ed3\u652f\u4ed8\uff0c\u671b\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-07-18 11:48:09","updated_at":"2024-07-18 11:51:52","supplier_id":531,"purchase_contract_id":3403,"amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":6000,"approve_amount":0,"un_approve_amount":6000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"6000","un_collected":0,"collected_plan":6000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3389,"supplier_id":623,"contract_type":1,"signed_at":"2024-07-05","amount":"27000.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-07-05 14:02:47","updated_at":"2024-07-09 09:25:10","client_id":"","project_id":"","sales_rep":"","serial_no":"2024040705","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-09 09:25:10","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"27000","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":{},"project":{},"supplier":{"id":623,"key":623,"name":"\u5317\u4eac\u9f50\u4fe1\u5171\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3389,"comment":3},"purchaseClientRels":[{"id":2073,"contract_id":3389,"client_id":2545,"project_id":3590,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3590,"key":3590,"name":"\u8054\u60f3\u670d\u52a1\u5668\u4e0a\u7528\u4e07\u5146\u7f51\u53612\u5757\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"171","key":"171","contract_id":3389,"value":"27000.00","collected_date":"2024-08-12 14:29:04","created_at":"2024-08-12 14:29:04","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1815,"key":1815,"contract_id":3389,"amount":"27000","value":"27000","attachment_id":"","from_date":"2024-08-06","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28135,"object_type":103,"object_id":1815,"attachment_id":20727,"attachment":{"id":20727,"key":20727,"name":"14acb510-b65f-3682-81b0-e7bde06f4c62","extension":"pdf","path":"\/vue\/attachment\/view\/14acb510-b65f-3682-81b0-e7bde06f4c62\/dzfp_24112000000099922252_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240806104203(1).pdf","orig_name":"dzfp_24112000000099922252_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240806104203(1).pdf"}}]}],"contractScans":[{"id":26838,"object_type":108,"object_id":3389,"attachment_id":20077,"attachment":{"id":20077,"key":20077,"name":"833498b3-ce47-35be-aa31-0b54bd8cda9f","extension":"pdf","path":"\/vue\/attachment\/preview\/833498b3-ce47-35be-aa31-0b54bd8cda9f\/\u62d3\u5b9e-\u9f50\u4fe1\u5171\u8d62\u53cc\u7ae0\u5408\u540c27000\u5143.pdf","orig_name":"\u62d3\u5b9e-\u9f50\u4fe1\u5171\u8d62\u53cc\u7ae0\u5408\u540c27000\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":281,"user_id":1011,"key":1011,"contract_id":3389,"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":282,"user_id":5360,"key":5360,"contract_id":3389,"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":188,"key":188,"contract_id":3389,"name":"2024-08-08","value":"27000","overdue_days":4,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":27000,"approve_amount":0,"un_approve_amount":27000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"27000","un_collected":0,"collected_plan":27000,"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},{"id":3372,"supplier_id":678,"contract_type":1,"signed_at":"2024-06-27","amount":"22000.00","handler":1011,"description":"\u667a\u9886\u8d8b\u52bf\u7b7e\u7ea6","contract_scan":"","created_by":1011,"created_at":"2024-06-28 10:46:53","updated_at":"2025-01-09 10:47:21","client_id":"","project_id":"","sales_rep":"","serial_no":"20240627","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-06-28 10:47:06","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"22000","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":{},"project":{},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3372,"comment":3},"purchaseClientRels":[{"id":2918,"contract_id":3372,"client_id":2545,"project_id":3576,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3576,"key":3576,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"167","key":"167","contract_id":3372,"value":"22000.00","collected_date":"2024-08-01 15:27:19","created_at":"2024-08-01 15:27:19","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1803,"key":1803,"contract_id":3372,"amount":"22000.00","value":"22000.00","attachment_id":"","from_date":"2024-07-29","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":27458,"object_type":103,"object_id":1803,"attachment_id":20595,"attachment":{"id":20595,"key":20595,"name":"993d71f9-f511-3820-9f6f-57bdab28c1e0","extension":"pdf","path":"\/vue\/attachment\/view\/993d71f9-f511-3820-9f6f-57bdab28c1e0\/dzfp_24112000000094073987_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240729133357(1).pdf","orig_name":"dzfp_24112000000094073987_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240729133357(1).pdf"}}]}],"contractScans":[{"id":31646,"object_type":108,"object_id":3372,"attachment_id":20031,"attachment":{"id":20031,"key":20031,"name":"ffb4b03e-be23-31e0-8d7f-49e2867b6c63","extension":"pdf","path":"\/vue\/attachment\/preview\/ffb4b03e-be23-31e0-8d7f-49e2867b6c63\/\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf\u5408\u540c20240702.pdf","orig_name":"\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf\u5408\u540c20240702.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":271,"user_id":1011,"key":1011,"contract_id":3372,"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":272,"user_id":5360,"key":5360,"contract_id":3372,"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":183,"key":183,"contract_id":3372,"name":"2024-07-27","value":"22000","overdue_days":5,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":22000,"approve_amount":0,"un_approve_amount":22000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"22000","un_collected":0,"collected_plan":22000,"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},{"id":3367,"supplier_id":90,"contract_type":1,"signed_at":"2024-06-26","amount":"156899.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-06-26 15:27:49","updated_at":"2024-09-10 09:28:55","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ15882","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-10 09:28:55","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"156899","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3367,"comment":2},"purchaseClientRels":[{"id":2787,"contract_id":3367,"client_id":3286,"project_id":3589,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3589,"key":3589,"name":"PaloAlto PA1420\u9632\u706b\u5899\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1145","key":"1145","contract_id":3367,"value":"156899.00","collected_date":"2024-09-20 11:10:43","created_at":"2024-09-20 11:10:43","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1800,"key":1800,"contract_id":3367,"amount":"156899.00","value":"156899.00","attachment_id":"","from_date":"2024-07-24","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":27352,"object_type":103,"object_id":1800,"attachment_id":20522,"attachment":{"id":20522,"key":20522,"name":"dde091ef-228a-37a4-adf0-ec55a095f79d","extension":"pdf","path":"\/vue\/attachment\/view\/dde091ef-228a-37a4-adf0-ec55a095f79d\/24122000000043623906_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"24122000000043623906_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":27407,"object_type":108,"object_id":3367,"attachment_id":20230,"attachment":{"id":20230,"key":20230,"name":"20eb90ce-052a-38bf-8270-838cd10e8c7c","extension":"pdf","path":"\/vue\/attachment\/preview\/20eb90ce-052a-38bf-8270-838cd10e8c7c\/document (1)(1).pdf","orig_name":"document (1)(1).pdf"}}],"receiptScans":[{"id":27413,"object_type":111,"object_id":3367,"attachment_id":20569,"attachment":{"id":20569,"key":20569,"name":"908581eb-1cea-3104-b96a-d042cc074e06","extension":"jpg","path":"\/vue\/attachment\/preview\/908581eb-1cea-3104-b96a-d042cc074e06\/8101721974074_.pic_hd.jpg","orig_name":"8101721974074_.pic_hd.jpg"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":485,"user_id":1011,"key":1011,"contract_id":3367,"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":486,"user_id":5360,"key":5360,"contract_id":3367,"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":323,"key":323,"contract_id":3367,"name":"2024-09-21","value":"156899","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1225,"client_id":3286,"project_id":3589,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u2014\uffe5234605","status":2,"next_verify_user":"","verify_at":"2024-09-20 09:58:55","description":"\u8001\u5927\uff0c\u826f\u56fe-PA1420\u9632\u706b\u5899\u91c7\u8d2d\u9879\u76ee\uff0c\u91c7\u8d2d\u91d1\u989d156899\u5143\uff1b\u4e2d\u90fd-PA\u4ea7\u54c1\u7eed\u4fdd\u9879\u76ee\uff0c\u91c7\u8d2d\u91d1\u989d77706\u5143\uff1b\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u5408\u8ba1234605\u5143\uff0c\u7533\u8bf7\u73b0\u7ed3\u652f\u4ed8\uff0c\u671b\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2024-09-20 09:48:35","updated_at":"2024-09-20 09:58:55","supplier_id":90,"purchase_contract_id":3367,"amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":156899,"approve_amount":0,"un_approve_amount":156899,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"156899","un_collected":0,"collected_plan":156899,"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},{"id":3365,"supplier_id":90,"contract_type":1,"signed_at":"2024-06-26","amount":"160407.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-06-26 13:11:10","updated_at":"2024-09-10 09:29:14","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ15876","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-10 09:29:14","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"160407","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3365,"comment":1},"purchaseClientRels":[{"id":2789,"contract_id":3365,"client_id":3278,"project_id":3577,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3577,"key":3577,"name":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1216","key":"1216","contract_id":3365,"value":"160407.00","collected_date":"2024-09-24 13:30:28","created_at":"2024-09-24 13:30:28","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1808,"key":1808,"contract_id":3365,"amount":"160407","value":"160407","attachment_id":"","from_date":"2024-07-31","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28117,"object_type":103,"object_id":1808,"attachment_id":20640,"attachment":{"id":20640,"key":20640,"name":"e9336212-69d3-3555-a5fb-3a9e9d7556d5","extension":"pdf","path":"\/vue\/attachment\/view\/e9336212-69d3-3555-a5fb-3a9e9d7556d5\/8e45f8c9-573e-4940-83a9-4bf78850e31f.pdf","orig_name":"8e45f8c9-573e-4940-83a9-4bf78850e31f.pdf"}}]}],"contractScans":[{"id":27029,"object_type":108,"object_id":3365,"attachment_id":20231,"attachment":{"id":20231,"key":20231,"name":"82fa38a6-18c5-3c3a-b0c6-4f83ad68835f","extension":"pdf","path":"\/vue\/attachment\/preview\/82fa38a6-18c5-3c3a-b0c6-4f83ad68835f\/document(1).pdf","orig_name":"document(1).pdf"}}],"receiptScans":[{"id":27569,"object_type":111,"object_id":3365,"attachment_id":20691,"attachment":{"id":20691,"key":20691,"name":"9eff2ce9-90b5-3e7f-86ac-455875993461","extension":"pdf","path":"\/vue\/attachment\/preview\/9eff2ce9-90b5-3e7f-86ac-455875993461\/2024_08_05_15_42_53.pdf","orig_name":"2024_08_05_15_42_53.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":487,"user_id":1011,"key":1011,"contract_id":3365,"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":488,"user_id":5360,"key":5360,"contract_id":3365,"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":324,"key":324,"contract_id":3365,"name":"2024-09-29","value":"160407","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":160407,"approve_amount":0,"un_approve_amount":160407,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"160407","un_collected":0,"collected_plan":160407,"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},{"id":3359,"supplier_id":511,"contract_type":1,"signed_at":"2024-06-20","amount":"1841448.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-06-20 17:36:22","updated_at":"2025-01-20 16:37:45","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240620-HYF-002","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-04 16:28:44","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1841448","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":{},"project":{},"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3359,"comment":4},"purchaseClientRels":[{"id":2025,"contract_id":3359,"client_id":3009,"project_id":3544,"client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3544,"key":3544,"name":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u9879\u76ee","project_status":3}},{"id":2228,"contract_id":3359,"client_id":3009,"project_id":3568,"client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3568,"key":3568,"name":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1150","key":"1150","contract_id":3359,"value":"920724.00","collected_date":"2024-09-23 09:38:51","created_at":"2024-09-23 09:38:51","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50},{"id":"1149","key":"1149","contract_id":3359,"value":"920724.00","collected_date":"2024-09-05 15:41:26","created_at":"2024-09-05 15:41:26","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"purchaseContractInvoices":[{"id":1772,"key":1772,"contract_id":3359,"amount":"920724.00","value":"920724.00","attachment_id":"","from_date":"2024-06-26","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":26691,"object_type":103,"object_id":1772,"attachment_id":19931,"attachment":{"id":19931,"key":19931,"name":"f0b04ace-fc9c-366e-83b0-bf8c3c7f5ed0","extension":"pdf","path":"\/vue\/attachment\/view\/f0b04ace-fc9c-366e-83b0-bf8c3c7f5ed0\/dzfp_24112000000069640064_\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20240626105815.pdf","orig_name":"dzfp_24112000000069640064_\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20240626105815.pdf"}}]},{"id":1842,"key":1842,"contract_id":3359,"amount":"920724","value":"920724","attachment_id":"","from_date":"2024-08-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28103,"object_type":103,"object_id":1842,"attachment_id":21088,"attachment":{"id":21088,"key":21088,"name":"f602600b-dd9f-31f4-a19b-cd0002b93d75","extension":"pdf","path":"\/vue\/attachment\/view\/f602600b-dd9f-31f4-a19b-cd0002b93d75\/dzfp_24112000000110850482_\u00b1\u00b1\u00e6\u00a9\u201c\u201a\u2265\u00a9\u00f8\u2206\u00ba\u00ba\u03c0\u2026\u2211\u203a\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20240821114337.pdf","orig_name":"dzfp_24112000000110850482_\u00b1\u00b1\u00e6\u00a9\u201c\u201a\u2265\u00a9\u00f8\u2206\u00ba\u00ba\u03c0\u2026\u2211\u203a\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20240821114337.pdf"}}]}],"contractScans":[{"id":26636,"object_type":108,"object_id":3359,"attachment_id":19874,"attachment":{"id":19874,"key":19874,"name":"8ef8d67d-5294-3ff8-8c7a-52cefa63c2ab","extension":"pdf","path":"\/vue\/attachment\/preview\/8ef8d67d-5294-3ff8-8c7a-52cefa63c2ab\/2024_06_24_17_17_39.pdf","orig_name":"2024_06_24_17_17_39.pdf"}}],"receiptScans":[{"id":31981,"object_type":111,"object_id":3359,"attachment_id":23860,"attachment":{"id":23860,"key":23860,"name":"213d8ce0-bc45-37c8-aff9-3c05211fa884","extension":"pdf","path":"\/vue\/attachment\/preview\/213d8ce0-bc45-37c8-aff9-3c05211fa884\/2025_01_20_16_31_43.pdf","orig_name":"2025_01_20_16_31_43.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":471,"user_id":1011,"key":1011,"contract_id":3359,"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":472,"user_id":5360,"key":5360,"contract_id":3359,"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":315,"key":315,"contract_id":3359,"name":"2024-09-06","value":"920724","overdue_days":"","status":1,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":316,"key":316,"contract_id":3359,"name":"2024-09-20","value":"920724","overdue_days":3,"status":1,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1191,"client_id":3009,"project_id":3544,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-09-04 16:32:11","description":"Tristen\uff0c\u5df2\u6536\u5230\u7528\u6237\u56de\u6b3e\uff0c\u7533\u8bf7\u660e\u65e5\u4ed8\u610f\u7545\u91c7\u8d2d\u8d27\u6b3e\u91d1\u989d\uff1a\uffe5920724\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-09-04 16:31:58","updated_at":"2024-09-04 16:32:11","supplier_id":511,"purchase_contract_id":3359,"amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":1841448,"approve_amount":0,"un_approve_amount":1841448,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1841448","un_collected":0,"collected_plan":1841448,"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},{"id":3362,"supplier_id":617,"contract_type":1,"signed_at":"2024-06-04","amount":"8592.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-06-25 10:07:53","updated_at":"2024-06-25 11:13:05","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240604-HYF-002","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-06-25 11:13:05","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"8592","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":{},"project":{},"supplier":{"id":617,"key":617,"name":"\u5317\u4eac\u4e5d\u5f69\u661f\u7a7a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3362,"comment":2},"purchaseClientRels":[{"id":2019,"contract_id":3362,"client_id":2545,"project_id":3552,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3552,"key":3552,"name":"\u6df1\u4fe1\u670dAF1000\u9632\u706b\u5899\u548c\u9510\u6377\u7f51\u7edc\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"127","key":"127","contract_id":3362,"value":"8592.00","collected_date":"2024-06-26 11:02:02","created_at":"2024-06-26 11:02:02","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1770,"key":1770,"contract_id":3362,"amount":"8592.00","value":"8592.00","attachment_id":"","from_date":"2024-06-25","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":26643,"object_type":103,"object_id":1770,"attachment_id":19882,"attachment":{"id":19882,"key":19882,"name":"f20633f3-118a-3594-a80e-689e47952ffb","extension":"pdf","path":"\/vue\/attachment\/view\/f20633f3-118a-3594-a80e-689e47952ffb\/dzfp_24112000000068625284_%E5%8C%97%E4%BA%AC%E4%B9%9D%E5%BD%A9%E6%98%9F%E7%A9%BA%E7%A7%91%E6%8A%80%E6%9C%89%E9%99%90%E5%85%AC%E5%8F%B8_20240625105031.pdf","orig_name":"dzfp_24112000000068625284_%E5%8C%97%E4%BA%AC%E4%B9%9D%E5%BD%A9%E6%98%9F%E7%A9%BA%E7%A7%91%E6%8A%80%E6%9C%89%E9%99%90%E5%85%AC%E5%8F%B8_20240625105031.pdf"}}]}],"contractScans":[{"id":26642,"object_type":108,"object_id":3362,"attachment_id":19881,"attachment":{"id":19881,"key":19881,"name":"d56a614e-f4e0-3d28-a693-d2d07fe229af","extension":"pdf","path":"\/vue\/attachment\/preview\/d56a614e-f4e0-3d28-a693-d2d07fe229af\/2024_06_04_17_52_06.pdf","orig_name":"2024_06_04_17_52_06.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":259,"user_id":1011,"key":1011,"contract_id":3362,"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":260,"user_id":5360,"key":5360,"contract_id":3362,"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":177,"key":177,"contract_id":3362,"name":"2024-06-26","value":"8592","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":8592,"approve_amount":0,"un_approve_amount":8592,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"8592","un_collected":0,"collected_plan":8592,"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},{"id":3334,"supplier_id":236,"contract_type":1,"signed_at":"2024-06-04","amount":"16121.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-06-04 17:43:17","updated_at":"2024-06-19 09:03:41","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240604-HYF-001","payment_collection_remind_ahead":"","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":"16121","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":{},"project":{},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3334,"comment":1},"purchaseClientRels":[{"id":2018,"contract_id":3334,"client_id":2545,"project_id":3552,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3552,"key":3552,"name":"\u6df1\u4fe1\u670dAF1000\u9632\u706b\u5899\u548c\u9510\u6377\u7f51\u7edc\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"13","key":"13","contract_id":3334,"value":"16121.00","collected_date":"2024-06-07 15:29:05","created_at":"2024-06-07 15:29:05","created_by":5360,"description":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"pct":100}],"purchaseContractInvoices":[{"id":1765,"key":1765,"contract_id":3334,"amount":"16121.00","value":"16121.00","attachment_id":"","from_date":"2024-06-07","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":26582,"object_type":103,"object_id":1765,"attachment_id":19827,"attachment":{"id":19827,"key":19827,"name":"02266b17-63bc-3faa-b512-3e67b1c32e71","extension":"pdf","path":"\/vue\/attachment\/view\/02266b17-63bc-3faa-b512-3e67b1c32e71\/dzfp_24112000000056645276_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240607161817.pdf","orig_name":"dzfp_24112000000056645276_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20240607161817.pdf"}}]}],"contractScans":[{"id":26576,"object_type":108,"object_id":3334,"attachment_id":19821,"attachment":{"id":19821,"key":19821,"name":"0431bc85-e618-3d49-a70c-59386124612d","extension":"pdf","path":"\/vue\/attachment\/preview\/0431bc85-e618-3d49-a70c-59386124612d\/2024_06_19_09_00_59.pdf","orig_name":"2024_06_19_09_00_59.pdf"}}],"receiptScans":[{"id":26389,"object_type":111,"object_id":3334,"attachment_id":19656,"attachment":{"id":19656,"key":19656,"name":"4cfc3843-05a0-3ec2-8031-b8e5005177dc","extension":"jpg","path":"\/vue\/attachment\/preview\/4cfc3843-05a0-3ec2-8031-b8e5005177dc\/7141718083814_.pic_hd.jpg","orig_name":"7141718083814_.pic_hd.jpg"}}],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":16121,"approve_amount":0,"un_approve_amount":16121,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"16121","un_collected":0,"collected_plan":0,"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},{"id":3254,"supplier_id":90,"contract_type":1,"signed_at":"2024-04-26","amount":"408016.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-04-26 13:52:45","updated_at":"2024-07-10 17:31:37","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ09634","payment_collection_remind_ahead":"7 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-07-10 16:01:25","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"408016","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3254,"comment":4},"purchaseClientRels":[{"id":2257,"contract_id":3254,"client_id":2845,"project_id":3515,"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},"project":{"id":3515,"key":3515,"name":"PA1410&PA1420\u4e00\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"186","key":"186","contract_id":3254,"value":"408016.00","collected_date":"2024-08-16 10:22:06","created_at":"2024-08-16 10:22:06","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1768,"key":1768,"contract_id":3254,"amount":"408016","value":"408016","attachment_id":"","from_date":"2024-06-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28124,"object_type":103,"object_id":1768,"attachment_id":19847,"attachment":{"id":19847,"key":19847,"name":"2d01065c-e2dc-34eb-8ba2-3e89bca23b0f","extension":"pdf","path":"\/vue\/attachment\/view\/2d01065c-e2dc-34eb-8ba2-3e89bca23b0f\/408016.pdf","orig_name":"408016.pdf"}}]}],"contractScans":[{"id":26979,"object_type":108,"object_id":3254,"attachment_id":19256,"attachment":{"id":19256,"key":19256,"name":"ca00be3c-17e3-32e5-bad9-308cd3e74ee7","extension":"pdf","path":"\/vue\/attachment\/preview\/ca00be3c-17e3-32e5-bad9-308cd3e74ee7\/408016.pdf","orig_name":"408016.pdf"}}],"receiptScans":[{"id":26983,"object_type":111,"object_id":3254,"attachment_id":20191,"attachment":{"id":20191,"key":20191,"name":"692d9cf1-31c9-3dcc-993a-be4f122f368b","extension":"pdf","path":"\/vue\/attachment\/preview\/692d9cf1-31c9-3dcc-993a-be4f122f368b\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":293,"user_id":1011,"key":1011,"contract_id":3254,"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":294,"user_id":5360,"key":5360,"contract_id":3254,"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":194,"key":194,"contract_id":3254,"name":"2024-08-16","value":"408016","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":408016,"approve_amount":0,"un_approve_amount":408016,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"408016","un_collected":0,"collected_plan":408016,"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},{"id":3253,"supplier_id":90,"contract_type":1,"signed_at":"2024-04-26","amount":"486864.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-04-26 13:51:37","updated_at":"2024-05-20 17:16:59","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ09677","payment_collection_remind_ahead":"7 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-05-20 11:24:54","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"486864","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":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":3253,"comment":3},"purchaseClientRels":[{"id":2115,"contract_id":3253,"client_id":2836,"project_id":3514,"client":{"id":2836,"key":2836,"name":"\u5317\u4eac\u4e2d\u8bda\u7f51\u5b89\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3514,"key":3514,"name":"4\u53f0PA1410\u9632\u706b\u58993\u5e74\u670d\u52a1\u53cc\u7535 \u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"152","key":"152","contract_id":3253,"value":"486864.00","collected_date":"2024-07-22 14:13:18","created_at":"2024-07-22 14:13:18","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":1732,"key":1732,"contract_id":3253,"amount":"486864.00","value":"486864.00","attachment_id":"","from_date":"2024-05-24","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":26102,"object_type":103,"object_id":1732,"attachment_id":19435,"attachment":{"id":19435,"key":19435,"name":"2028c4c5-ef1f-325e-ae49-2185e2369de0","extension":"pdf","path":"\/vue\/attachment\/view\/2028c4c5-ef1f-325e-ae49-2185e2369de0\/f5fbc7ab-0981-4f7a-a511-65c4523f314e.pdf","orig_name":"f5fbc7ab-0981-4f7a-a511-65c4523f314e.pdf"}}]}],"contractScans":[{"id":25876,"object_type":108,"object_id":3253,"attachment_id":19255,"attachment":{"id":19255,"key":19255,"name":"e9e8d700-397a-35c9-94be-35a6f99e5e23","extension":"pdf","path":"\/vue\/attachment\/preview\/e9e8d700-397a-35c9-94be-35a6f99e5e23\/486864.pdf","orig_name":"486864.pdf"}}],"receiptScans":[{"id":25969,"object_type":111,"object_id":3253,"attachment_id":19323,"attachment":{"id":19323,"key":19323,"name":"ecc16160-b082-3fe3-be69-5739168de5d1","extension":"pdf","path":"\/vue\/attachment\/preview\/ecc16160-b082-3fe3-be69-5739168de5d1\/2024_05_20_15_35_11.pdf","orig_name":"2024_05_20_15_35_11.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":149,"user_id":1011,"key":1011,"contract_id":3253,"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":150,"user_id":5360,"key":5360,"contract_id":3253,"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":112,"key":112,"contract_id":3253,"name":"2024-07-16","value":"486864","overdue_days":6,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":486864,"approve_amount":0,"un_approve_amount":486864,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"486864","un_collected":0,"collected_plan":486864,"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}],"count":{"total":"29204487.94","collected":"28604933.76","un_collected":599554.18,"invoiced":"29162513.29","un_invoiced":26974.65},"can_create":true,"pagenation":{"totalcount":86,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-11 14:42:19') RETURNING "id"
14:42:19.4045.7 msyii\db\Command::querySELECT 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20 OFFSET 20
14:42:19.5875.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=13) AND ("visit_date"='2025-08-11')
14:42:19.5595.4 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (SELECT "c"."id" 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)
14:42:19.5534.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)
14:42:19.5814.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE))
14:42:19.4133.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
14:42:19.5653.9 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE)
14:42:19.4763.7 msyii\db\Command::querySELECT "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 (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253) ORDER BY "id"
14:42:19.5763.7 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (SELECT "c"."id" 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 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"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)
14:42:19.4912.8 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 (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)
14:42:19.4842.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21774, 21863, 21928, 22140, 22173, 22167, 22349, 19435, 19827, 19882, 19931, 20227, 20522, 20595, 21088, 21023, 20640, 19847, 20727, 21193, 21604, 23287)
14:42:19.3692.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5252
14:42:19.5502.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)
14:42:19.3722.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:42:19.5162.0 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 (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253)) ORDER BY "id"
14:42:19.3671.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:42:19.4801.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1732, 1765, 1768, 1770, 1772, 1791, 1800, 1803, 1808, 1815, 1840, 1842, 1857, 1911, 1943, 1955, 1958, 1972, 1976, 1977, 1995, 2072))
14:42:19.3751.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:42:19.4871.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253))
14:42:19.4821.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1732, 1765, 1768, 1770, 1772, 1791, 1800, 1803, 1808, 1815, 1840, 1842, 1857, 1911, 1943, 1955, 1958, 1972, 1976, 1977, 1995, 2072))
14:42:19.4891.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253))
14:42:19.4951.1 msyii\db\Command::querySELECT "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 (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253) ORDER BY "remind_date"
14:42:19.4111.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (511, 68, 531, 46, 90, 678, 623, 617, 236)
14:42:19.5930.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=20, "last_visit_at"='now()' WHERE "id"=55021
14:42:19.4510.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2545, 3009, 2836, 2845, 3296, 3301, 3311, 3304, 3286, 3278, 2553)
14:42:19.4120.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 (1011, 5360))
14:42:19.4500.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3422, 3403, 3389, 3372, 3367, 3365, 3359, 3362, 3334, 3254, 3253) ORDER BY "id"
14:42:19.4890.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21395, 21757, 21825, 22123, 22162, 22307, 22039, 22314, 19255, 19821, 19874, 19881, 20077, 19256, 20226, 20231, 20230, 21146, 23268, 20491, 20031)
14:42:19.4910.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21552, 21784, 22180, 22351, 19323, 19656, 20191, 20569, 20691, 21144, 23258, 23271, 23860)
14:42:19.4120.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
14:42:19.4760.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5360)
14:42:19.4950.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5016, 5360, 1000))
14:42:19.4940.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360, 5016, 1000)
14:42:19.4170.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
14:42:19.4170.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360))