Total processing time: 213 ms; Peak memory: 6.643 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
14:41:07.403 | 21.4 ms | yii\db\Command::query | SELECT "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 (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422)) GROUP BY "object_id" |
14:41:07.310 | 20.9 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422)) GROUP BY "object_id" |
14:41:07.366 | 9.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21774, 21863, 21928, 22140, 22173, 22167, 22349, 21023, 20721, 21193, 22843, 21604, 23287, 23440, 23639, 23741, 23908, 23920, 24077, 24231, 24299, 24727, 24728, 24732, 24733) |
14:41:07.379 | 9.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21395, 21757, 21825, 22123, 22889, 22162, 22307, 22039, 22314, 20598, 21146, 23268, 23490, 23371, 20491, 23644, 23899, 23742, 24521, 24522) |
14:41:07.290 | 8.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("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:41:07.349 | 8.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id" IN (1263, 1312, 1358, 1391, 1441, 1442, 1473, 1532, 1531, 1530, 1592, 1612, 1619, 1659, 1671, 1588) |
14:41:07.396 | 7.0 ms | yii\db\Command::query | SELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422)) GROUP BY "r"."id" |
14:41:07.450 | 6.3 ms | yii\db\Command::query | SELECT 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 ("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) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE)) |
14:41:07.461 | 5.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=13) AND ("visit_date"='2025-06-27') |
14:41:07.426 | 5.8 ms | yii\db\Command::query | SELECT 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 ("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) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
14:41:07.432 | 5.7 ms | yii\db\Command::query | SELECT 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 ("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) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE) |
14:41:07.439 | 5.4 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_payments" 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 ("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) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
14:41:07.445 | 5.4 ms | yii\db\Command::query | SELECT 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 ("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) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
14:41:07.342 | 5.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22666, 21920, 22131, 23112, 22946, 22343, 22344, 22347, 21080, 21419, 22969, 23386, 23387, 23409, 23802, 23906, 24059, 24290, 24371, 23763, 24531) |
14:41:07.470 | 4.4 ms | yii\db\Command::query | INSERT 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":"","invoice_from_date_period":"","sales_rep":"1001"},"Filter":{"name":"signed_at","sort":"DESC"},"page":"1","from_project":"1","web_access_token":"SXPCUp7Z_YgHJ45TnvuyG1o7l8nwuHKC"}', '{"code":2000,"result":{"list":[{"id":3834,"supplier_id":431,"contract_type":1,"signed_at":"2025-04-14","amount":"900000000.00","handler":1013,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-04-14 14:27:28","updated_at":"2025-05-16 15:57:04","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u5173\u8054\u91c7\u8d2d\u5408\u540c\u95ee\u9898","payment_collection_remind_ahead":"7 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-16 15:57:04.1243+08","is_chargeback":true,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"commentCount":{"object_id":3834,"comment":4},"purchaseClientRels":[{"id":3128,"contract_id":3834,"client_id":3278,"project_id":3801,"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":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898","project_status":3}},{"id":3131,"contract_id":3834,"client_id":3334,"project_id":3786,"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","project_status":3}}],"purchaseContractPayments":[{"id":2090,"key":2090,"contract_id":3834,"value":"800000000","collected_date":"2025-05-07","created_at":"2025-05-07 16:21:45","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":88.89},{"id":2091,"key":2091,"contract_id":3834,"value":"-800000000","collected_date":"2025-05-07","created_at":"2025-05-07 16:25:37","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":-88.89}],"purchaseContractInvoices":[{"id":2175,"key":2175,"contract_id":3834,"amount":"1.00","value":"1.00","attachment_id":"","from_date":"2025-05-07","description":"asdf asdf ads fasd f \nasdf \nasdf \nasd f\nasdf \nasdf asdf asdf asdf ","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":33098,"object_type":21,"object_id":2175,"attachment_id":24726,"attachment":{"id":24726,"key":24726,"name":"a9a2f5eb-4847-37ff-9e9d-fdb4f8acedfd","extension":"jpg","path":"\/vue\/attachment\/view\/a9a2f5eb-4847-37ff-9e9d-fdb4f8acedfd\/WechatIMG33643.jpg","orig_name":"WechatIMG33643.jpg"}},{"id":33099,"object_type":21,"object_id":2175,"attachment_id":24729,"attachment":{"id":24729,"key":24729,"name":"46708d1b-9853-3b65-89a6-111540022d2c","extension":"jpg","path":"\/vue\/attachment\/view\/46708d1b-9853-3b65-89a6-111540022d2c\/WechatIMG33760.jpg","orig_name":"WechatIMG33760.jpg"}}],"files":[{"id":33100,"object_type":103,"object_id":2175,"attachment_id":24727,"attachment":{"id":24727,"key":24727,"name":"1ac3e1e9-4c90-3de0-b77d-b9f81ccac462","extension":"docx","path":"\/vue\/attachment\/view\/1ac3e1e9-4c90-3de0-b77d-b9f81ccac462\/08-22\u5f85\u5f00\u53d1.docx","orig_name":"08-22\u5f85\u5f00\u53d1.docx"}},{"id":33101,"object_type":103,"object_id":2175,"attachment_id":24728,"attachment":{"id":24728,"key":24728,"name":"95b56d42-9345-326b-b42d-36244d30f767","extension":"docx","path":"\/vue\/attachment\/view\/95b56d42-9345-326b-b42d-36244d30f767\/05-22\u5f85\u5f00\u53d1.docx","orig_name":"05-22\u5f85\u5f00\u53d1.docx"}}]},{"id":2176,"key":2176,"contract_id":3834,"amount":"22.00","value":"22.00","attachment_id":"","from_date":"2025-05-21","description":"asdf \u963f\u65af\u8482\u82ac\u963f\u8428\u5fb7\u53d1\u5927\u6c34\n\u963f\u65af\u8482\u82acasd \u53d1\u65af\u8482\u82ac\u5965\u5fb7\u8d5b\u53d1\u591a\u5c11\u53d1\u751f\u7684\n\u963f\u662f\u5927\u6cd5\u5e08\u5927\u6cd5\u5e08\u7684\u53d1\u751f\u7684\n\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u662f\n\u963f\u65af\u987f\u53d1\u7b2c\u4e09\u65b9\u554a\u662f\u5426\u963f\u662f","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":33102,"object_type":21,"object_id":2176,"attachment_id":24730,"attachment":{"id":24730,"key":24730,"name":"0f714f0b-8ae7-3041-b7cb-b8db33fe4935","extension":"jpg","path":"\/vue\/attachment\/view\/0f714f0b-8ae7-3041-b7cb-b8db33fe4935\/WechatIMG73.jpg","orig_name":"WechatIMG73.jpg"}},{"id":33103,"object_type":21,"object_id":2176,"attachment_id":24731,"attachment":{"id":24731,"key":24731,"name":"61553183-d59e-317b-9a6c-f7ca606a9226","extension":"jpg","path":"\/vue\/attachment\/view\/61553183-d59e-317b-9a6c-f7ca606a9226\/WechatIMG33643.jpg","orig_name":"WechatIMG33643.jpg"}}],"files":[{"id":33104,"object_type":103,"object_id":2176,"attachment_id":24732,"attachment":{"id":24732,"key":24732,"name":"5ab8c55f-c12f-3461-9ecf-89a3b77abec0","extension":"docx","path":"\/vue\/attachment\/view\/5ab8c55f-c12f-3461-9ecf-89a3b77abec0\/05-05\u5f85\u5f00\u53d1.docx","orig_name":"05-05\u5f85\u5f00\u53d1.docx"}},{"id":33105,"object_type":103,"object_id":2176,"attachment_id":24733,"attachment":{"id":24733,"key":24733,"name":"2fb1d383-e0db-303c-8691-57fe1aca0108","extension":"docx","path":"\/vue\/attachment\/view\/2fb1d383-e0db-303c-8691-57fe1aca0108\/05-16\u5f85\u5f00\u53d1.docx","orig_name":"05-16\u5f85\u5f00\u53d1.docx"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1013,"user_id":1001,"key":1001,"contract_id":3834,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":1014,"user_id":5329,"key":5329,"contract_id":3834,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},{"id":1015,"user_id":5332,"key":5332,"contract_id":3834,"user":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}},{"id":1016,"user_id":5420,"key":5420,"contract_id":3834,"user":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"id":1017,"user_id":5087,"key":5087,"contract_id":3834,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"id":1018,"user_id":5300,"key":5300,"contract_id":3834,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":1019,"user_id":5295,"key":5295,"contract_id":3834,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":1020,"user_id":5404,"key":5404,"contract_id":3834,"user":{"id":5404,"key":5404,"name":"\u6b66\u51ef","sex":"M","avatar":{}}},{"id":1021,"user_id":1004,"key":1004,"contract_id":3834,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"id":1022,"user_id":1005,"key":1005,"contract_id":3834,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":621,"key":621,"contract_id":3834,"name":"2025-05-14","value":"1","overdue_days":"","pct":0,"collect_status":"\u903e\u671f44\u5929"}],"paymentApproves":[{"id":1725,"client_id":"","project_id":"","title":"asd","status":2,"next_verify_user":"","verify_at":"2025-05-22 13:40:55","description":"asd","refuse_description":"","is_resubmited":false,"created_by":5016,"created_at":"2025-05-22 13:40:51","updated_at":"2025-05-22 13:40:55","supplier_id":431,"purchase_contract_id":3834,"amount":"123213","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""},{"id":1726,"client_id":"","project_id":"","title":"123123","status":2,"next_verify_user":"","verify_at":"2025-05-22 13:41:08","description":"231123312","refuse_description":"","is_resubmited":false,"created_by":5016,"created_at":"2025-05-22 13:41:04","updated_at":"2025-05-22 13:41:08","supplier_id":431,"purchase_contract_id":3834,"amount":"123","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":23,"approve_amount":123336,"un_approve_amount":899876664,"un_invoiced":899999977,"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":0,"collected_plan":1,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3769,"supplier_id":90,"contract_type":1,"signed_at":"2025-01-20","amount":"64665.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-21 15:26:45","updated_at":"2025-03-12 13:48:25","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ01556","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-21 15:27:04.316481+08","is_chargeback":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":3769,"comment":1},"purchaseClientRels":[{"id":3107,"contract_id":3769,"client_id":3327,"project_id":3767,"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2144,"key":2144,"contract_id":3769,"amount":"64665","value":"64665","attachment_id":"","from_date":"2025-02-27","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32540,"object_type":103,"object_id":2144,"attachment_id":24299,"attachment":{"id":24299,"key":24299,"name":"59d57bcb-e2ac-3543-ae5f-c2b2c7d4c38d","extension":"pdf","path":"\/vue\/attachment\/view\/59d57bcb-e2ac-3543-ae5f-c2b2c7d4c38d\/64665.pdf","orig_name":"64665.pdf"}}]}],"contractScans":[{"id":32855,"object_type":108,"object_id":3769,"attachment_id":24521,"attachment":{"id":24521,"key":24521,"name":"da56e70e-ee3c-3d98-a533-e27d3b75ae4b","extension":"pdf","path":"\/vue\/attachment\/preview\/da56e70e-ee3c-3d98-a533-e27d3b75ae4b\/64665.pdf","orig_name":"64665.pdf"}}],"receiptScans":[{"id":32654,"object_type":111,"object_id":3769,"attachment_id":24373,"attachment":{"id":24373,"key":24373,"name":"6bd047f3-11d3-31a0-a1f4-da3a20d70824","extension":"pdf","path":"\/vue\/attachment\/preview\/6bd047f3-11d3-31a0-a1f4-da3a20d70824\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":915,"user_id":1011,"key":1011,"contract_id":3769,"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":916,"user_id":5360,"key":5360,"contract_id":3769,"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":562,"key":562,"contract_id":3769,"name":"2025-04-15","value":"64665","overdue_days":"","pct":100,"collect_status":"\u903e\u671f73\u5929"}],"paymentApproves":[],"unreadComments":{},"invoiced":64665,"approve_amount":0,"un_approve_amount":64665,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":64665,"collected_plan":64665,"is_collected":false,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3756,"supplier_id":46,"contract_type":1,"signed_at":"2025-01-14","amount":"119272.06","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-14 10:25:12","updated_at":"2025-02-19 15:39:38","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ202501133114542","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-14 17:33:23.909327+08","is_chargeback":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":3756,"comment":2},"purchaseClientRels":[{"id":2990,"contract_id":3756,"client_id":2616,"project_id":3764,"client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001},"project":{"id":3764,"key":3764,"name":"PA1410 \u4e24\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2034,"key":2034,"contract_id":3756,"value":"119272.06","collected_date":"2025-03-10","created_at":"2025-03-12 17:20:30","created_by":1013,"description":"2025\u5e743\u670810\u65e5\u6263\u6b3e\u6210\u529f\u3002","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32871,"object_type":110,"object_id":2034,"attachment_id":23763,"attachment":{"id":23763,"key":23763,"name":"e432ad52-6467-3ff6-9c69-a830d0dea568","extension":"jpg","path":"\/vue\/attachment\/view\/e432ad52-6467-3ff6-9c69-a830d0dea568\/51736922462_.pic.jpg","orig_name":"51736922462_.pic.jpg"}},{"id":32872,"object_type":110,"object_id":2034,"attachment_id":24531,"attachment":{"id":24531,"key":24531,"name":"0f6cb637-6f61-3c1a-983e-9da075113bdf","extension":"png","path":"\/vue\/attachment\/view\/0f6cb637-6f61-3c1a-983e-9da075113bdf\/image.png","orig_name":"image.png"}}],"approves":[{"id":1588,"client_id":2616,"project_id":3764,"title":"\u5f00\u5ef6\u652f-\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-15 10:30:48","description":"Tristen\uff0c\u7533\u8bf7\u5f00\u5177\u4e00\u5f2055\u5929\u7684\u5ef6\u671f\u652f\u7968\uff082025\u5e743\u670810\u65e5\uff09\u7528\u4e8e\u652f\u4ed8PA1410 2\u5957\u8bbe\u5907\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\u00a5119272.06\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":"2025-01-15 09:53:09","updated_at":"2025-01-15 10:30:48","supplier_id":46,"purchase_contract_id":3756,"amount":"119272.06","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2122,"key":2122,"contract_id":3756,"amount":"74114.04","value":"74114.04","attachment_id":"","from_date":"2025-01-15","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32065,"object_type":103,"object_id":2122,"attachment_id":23920,"attachment":{"id":23920,"key":23920,"name":"2980173d-22ee-3b22-9f1c-16a301c025b1","extension":"pdf","path":"\/vue\/attachment\/view\/2980173d-22ee-3b22-9f1c-16a301c025b1\/25112000000011507101.pdf","orig_name":"25112000000011507101.pdf"}}]},{"id":2137,"key":2137,"contract_id":3756,"amount":"45158.02","value":"45158.02","attachment_id":"","from_date":"2025-02-20","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32443,"object_type":103,"object_id":2137,"attachment_id":24231,"attachment":{"id":24231,"key":24231,"name":"855eadd4-7ac6-33ea-ad2c-c0a7b1d53b9c","extension":"pdf","path":"\/vue\/attachment\/view\/855eadd4-7ac6-33ea-ad2c-c0a7b1d53b9c\/25112000000032709267.pdf","orig_name":"25112000000032709267.pdf"}}]}],"contractScans":[{"id":32064,"object_type":108,"object_id":3756,"attachment_id":23742,"attachment":{"id":23742,"key":23742,"name":"0a59d5cb-6646-325f-8bf0-878529d4d16b","extension":"pdf","path":"\/vue\/attachment\/preview\/0a59d5cb-6646-325f-8bf0-878529d4d16b\/DZ202501133114542.pdf","orig_name":"DZ202501133114542.pdf"}}],"receiptScans":[{"id":32411,"object_type":111,"object_id":3756,"attachment_id":24203,"attachment":{"id":24203,"key":24203,"name":"62909f9b-c901-3353-afa0-113c6a0aa038","extension":"pdf","path":"\/vue\/attachment\/preview\/62909f9b-c901-3353-afa0-113c6a0aa038\/\u8d27\u7269\u7b7e\u6536\u8bc1\u660e.pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u8bc1\u660e.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":903,"user_id":1011,"key":1011,"contract_id":3756,"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":904,"user_id":5360,"key":5360,"contract_id":3756,"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":556,"key":556,"contract_id":3756,"name":"2025-03-10","value":"119272.06","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1588,"client_id":2616,"project_id":3764,"title":"\u5f00\u5ef6\u652f-\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-15 10:30:48","description":"Tristen\uff0c\u7533\u8bf7\u5f00\u5177\u4e00\u5f2055\u5929\u7684\u5ef6\u671f\u652f\u7968\uff082025\u5e743\u670810\u65e5\uff09\u7528\u4e8e\u652f\u4ed8PA1410 2\u5957\u8bbe\u5907\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\u00a5119272.06\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":"2025-01-15 09:53:09","updated_at":"2025-01-15 10:30:48","supplier_id":46,"purchase_contract_id":3756,"amount":"119272.06","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":119272.06,"approve_amount":119272.06,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":119272.06,"un_collected":0,"collected_plan":119272.06,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3773,"supplier_id":38,"contract_type":1,"signed_at":"2025-01-10","amount":"5520.00","handler":1013,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-22 14:28:57","updated_at":"2025-01-22 15:03:04","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250110-WJC-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-22 14:29:07.675259+08","is_chargeback":false,"client":{},"project":{},"supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\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":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"commentCount":{"object_id":3773,"comment":2},"purchaseClientRels":[{"id":2979,"contract_id":3773,"client_id":2545,"project_id":3760,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2044,"key":2044,"contract_id":3773,"value":"5520.00","collected_date":"2025-01-22","created_at":"2025-01-22 15:51:44","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32041,"object_type":110,"object_id":2044,"attachment_id":23906,"attachment":{"id":23906,"key":23906,"name":"9c822eb2-df6d-3b59-b116-bbad69b883d1","extension":"png","path":"\/vue\/attachment\/view\/9c822eb2-df6d-3b59-b116-bbad69b883d1\/image.png","orig_name":"image.png"}}],"approves":[{"id":1612,"client_id":2545,"project_id":3760,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4e91\u9526\u975e\u51e1","status":2,"next_verify_user":"","verify_at":"2025-01-22 14:46:44","description":"\u7533\u8bf7\u4ed8\u4e09\u661f\u5185\u5b5824\u6761\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d5520\u5143\u3002\u8bf7\u5ba1\u6279\uff0c\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1013,"created_at":"2025-01-22 14:35:06","updated_at":"2025-01-22 14:46:44","supplier_id":38,"purchase_contract_id":3773,"amount":"5520","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2120,"key":2120,"contract_id":3773,"amount":"5520","value":"5520","attachment_id":"","from_date":"2025-01-22","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32044,"object_type":103,"object_id":2120,"attachment_id":23908,"attachment":{"id":23908,"key":23908,"name":"f1ed5f76-c399-3b69-9f04-77a45eb263ae","extension":"pdf","path":"\/vue\/attachment\/view\/f1ed5f76-c399-3b69-9f04-77a45eb263ae\/dzfp_25112000000018516389_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250122154822(1).pdf","orig_name":"dzfp_25112000000018516389_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250122154822(1).pdf"}}]}],"contractScans":[{"id":32034,"object_type":108,"object_id":3773,"attachment_id":23899,"attachment":{"id":23899,"key":23899,"name":"9488621c-762c-3bee-9f8d-1c8f77c850bd","extension":"pdf","path":"\/vue\/attachment\/preview\/9488621c-762c-3bee-9f8d-1c8f77c850bd\/\u626b\u63cf\u5168\u80fd\u738b 2025-01-22 14.36(1).pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2025-01-22 14.36(1).pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":921,"user_id":1011,"key":1011,"contract_id":3773,"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":922,"user_id":5360,"key":5360,"contract_id":3773,"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":565,"key":565,"contract_id":3773,"name":"2025-01-24","value":"5520","overdue_days":"","pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1612,"client_id":2545,"project_id":3760,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4e91\u9526\u975e\u51e1","status":2,"next_verify_user":"","verify_at":"2025-01-22 14:46:44","description":"\u7533\u8bf7\u4ed8\u4e09\u661f\u5185\u5b5824\u6761\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d5520\u5143\u3002\u8bf7\u5ba1\u6279\uff0c\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1013,"created_at":"2025-01-22 14:35:06","updated_at":"2025-01-22 14:46:44","supplier_id":38,"purchase_contract_id":3773,"amount":"5520","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":5520,"approve_amount":5520,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":5520,"un_collected":0,"collected_plan":5520,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3747,"supplier_id":678,"contract_type":1,"signed_at":"2025-01-09","amount":"43800.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-09 10:18:12","updated_at":"2025-01-10 17:45:20","client_id":"","project_id":"","sales_rep":"","serial_no":"YTYG2025","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-09 10:18:26.215208+08","is_chargeback":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":3747,"comment":4},"purchaseClientRels":[{"id":2968,"contract_id":3747,"client_id":2545,"project_id":3760,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2055,"key":2055,"contract_id":3747,"value":"43800.00","collected_date":"2025-02-13","created_at":"2025-02-13 13:39:28","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32235,"object_type":110,"object_id":2055,"attachment_id":24059,"attachment":{"id":24059,"key":24059,"name":"44f2ad34-d192-344a-9f68-8264c0e3b2c5","extension":"png","path":"\/vue\/attachment\/view\/44f2ad34-d192-344a-9f68-8264c0e3b2c5\/image.png","orig_name":"image.png"}}],"approves":[{"id":1619,"client_id":2545,"project_id":3760,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-02-10 09:52:08","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u8d44\u821f-\u670d\u52a1\u5668\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d43800\u5143\uff0c\u4ed8\u6b3e\u65e5\u671f2\u670813\u65e5\uff08\u5468\u56db\uff09\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-02-10 09:45:10","updated_at":"2025-02-10 09:52:08","supplier_id":678,"purchase_contract_id":3747,"amount":"43800","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2105,"key":2105,"contract_id":3747,"amount":"43800","value":"43800","attachment_id":"","from_date":"2025-01-14","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31836,"object_type":103,"object_id":2105,"attachment_id":23741,"attachment":{"id":23741,"key":23741,"name":"2818f37d-a9a1-3d4b-bbc3-0a24fe1a366c","extension":"pdf","path":"\/vue\/attachment\/view\/2818f37d-a9a1-3d4b-bbc3-0a24fe1a366c\/dzfp_25112000000011073126_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250114145654(1).pdf","orig_name":"dzfp_25112000000011073126_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250114145654(1).pdf"}}]}],"contractScans":[{"id":31716,"object_type":108,"object_id":3747,"attachment_id":23644,"attachment":{"id":23644,"key":23644,"name":"2d855be1-25b6-3be4-b68b-71a758a4fbc3","extension":"pdf","path":"\/vue\/attachment\/preview\/2d855be1-25b6-3be4-b68b-71a758a4fbc3\/2025_01_10_17_43_26.pdf","orig_name":"2025_01_10_17_43_26.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":883,"user_id":1011,"key":1011,"contract_id":3747,"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":884,"user_id":5360,"key":5360,"contract_id":3747,"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":546,"key":546,"contract_id":3747,"name":"2025-02-10","value":"43800","overdue_days":3,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1619,"client_id":2545,"project_id":3760,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-02-10 09:52:08","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u8d44\u821f-\u670d\u52a1\u5668\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d43800\u5143\uff0c\u4ed8\u6b3e\u65e5\u671f2\u670813\u65e5\uff08\u5468\u56db\uff09\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-02-10 09:45:10","updated_at":"2025-02-10 09:52:08","supplier_id":678,"purchase_contract_id":3747,"amount":"43800","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":43800,"approve_amount":43800,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":43800,"un_collected":0,"collected_plan":43800,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3727,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"67594.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 14:48:04","updated_at":"2025-03-12 13:48:33","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ36962","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-25 14:48:18.417249+08","is_chargeback":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":3727,"comment":1},"purchaseClientRels":[{"id":3109,"contract_id":3727,"client_id":3327,"project_id":3744,"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2133,"key":2133,"contract_id":3727,"amount":"67594","value":"67594","attachment_id":"","from_date":"2025-02-14","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32260,"object_type":103,"object_id":2133,"attachment_id":24077,"attachment":{"id":24077,"key":24077,"name":"5c283bd9-2f9f-3766-aa0d-5995263ebc75","extension":"pdf","path":"\/vue\/attachment\/view\/5c283bd9-2f9f-3766-aa0d-5995263ebc75\/4216b6c4-9db4-4939-9f6b-02420a3616a1.pdf","orig_name":"4216b6c4-9db4-4939-9f6b-02420a3616a1.pdf"}}]}],"contractScans":[{"id":32856,"object_type":108,"object_id":3727,"attachment_id":24522,"attachment":{"id":24522,"key":24522,"name":"337f3561-44b4-37f4-800a-eb3b1497a778","extension":"pdf","path":"\/vue\/attachment\/preview\/337f3561-44b4-37f4-800a-eb3b1497a778\/67594.pdf","orig_name":"67594.pdf"}}],"receiptScans":[{"id":32653,"object_type":111,"object_id":3727,"attachment_id":24372,"attachment":{"id":24372,"key":24372,"name":"4d0c19b3-7261-3038-9cb8-42240499cfda","extension":"pdf","path":"\/vue\/attachment\/preview\/4d0c19b3-7261-3038-9cb8-42240499cfda\/\u7b7e\u6536\u8bc1\u660e.pdf","orig_name":"\u7b7e\u6536\u8bc1\u660e.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":857,"user_id":1011,"key":1011,"contract_id":3727,"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":858,"user_id":5360,"key":5360,"contract_id":3727,"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":532,"key":532,"contract_id":3727,"name":"2025-03-28","value":"67594","overdue_days":"","pct":100,"collect_status":"\u903e\u671f91\u5929"}],"paymentApproves":[],"unreadComments":{},"invoiced":67594,"approve_amount":0,"un_approve_amount":67594,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":67594,"collected_plan":67594,"is_collected":false,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3726,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"51606.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 14:47:02","updated_at":"2025-01-07 11:07:51","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ37023","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-07 11:07:51.356049+08","is_chargeback":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":3726,"comment":4},"purchaseClientRels":[{"id":3108,"contract_id":3726,"client_id":2553,"project_id":3752,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3752,"key":3752,"name":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2064,"key":2064,"contract_id":3726,"value":"51606.00","collected_date":"2025-02-25","created_at":"2025-02-25 16:42:47","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32522,"object_type":110,"object_id":2064,"attachment_id":24290,"attachment":{"id":24290,"key":24290,"name":"1d08be7b-6179-33b4-8b4e-34cacdb66678","extension":"png","path":"\/vue\/attachment\/view\/1d08be7b-6179-33b4-8b4e-34cacdb66678\/image.png","orig_name":"image.png"}}],"approves":[{"id":1659,"client_id":2553,"project_id":3752,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-02-25 10:54:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u9890\u6770\u9e3f\u5229-PA\u9879\u76ee\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d51606\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-02-25 10:23:18","updated_at":"2025-02-25 10:54:33","supplier_id":90,"purchase_contract_id":3726,"amount":"51606","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2085,"key":2085,"contract_id":3726,"amount":"51606","value":"51606","attachment_id":"","from_date":"2024-12-30","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31406,"object_type":103,"object_id":2085,"attachment_id":23440,"attachment":{"id":23440,"key":23440,"name":"47a5a2ee-e149-3eac-afff-80b0f8a99c0e","extension":"pdf","path":"\/vue\/attachment\/view\/47a5a2ee-e149-3eac-afff-80b0f8a99c0e\/51606.pdf","orig_name":"51606.pdf"}}]}],"contractScans":[{"id":31480,"object_type":108,"object_id":3726,"attachment_id":23490,"attachment":{"id":23490,"key":23490,"name":"0d710a9a-7c30-34f1-98dc-76357124c9fd","extension":"pdf","path":"\/vue\/attachment\/preview\/0d710a9a-7c30-34f1-98dc-76357124c9fd\/document (2).pdf","orig_name":"document (2).pdf"}}],"receiptScans":[{"id":31476,"object_type":111,"object_id":3726,"attachment_id":23486,"attachment":{"id":23486,"key":23486,"name":"920446b3-3ba6-3967-803e-1460f2eb09cc","extension":"pdf","path":"\/vue\/attachment\/preview\/920446b3-3ba6-3967-803e-1460f2eb09cc\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":879,"user_id":1011,"key":1011,"contract_id":3726,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":880,"user_id":5360,"key":5360,"contract_id":3726,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":544,"key":544,"contract_id":3726,"name":"2025-02-25","value":"51606","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1659,"client_id":2553,"project_id":3752,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-02-25 10:54:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u9890\u6770\u9e3f\u5229-PA\u9879\u76ee\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d51606\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-02-25 10:23:18","updated_at":"2025-02-25 10:54:33","supplier_id":90,"purchase_contract_id":3726,"amount":"51606","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":51606,"approve_amount":51606,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":51606,"un_collected":0,"collected_plan":51606,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3704,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-11","amount":"291807.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-11 14:48:33","updated_at":"2025-01-07 10:53:54","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ32972","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-06 15:04:10.946509+08","is_chargeback":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":3704,"comment":4},"purchaseClientRels":[{"id":3106,"contract_id":3704,"client_id":3304,"project_id":3723,"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":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2069,"key":2069,"contract_id":3704,"value":"291807.00","collected_date":"2025-03-04","created_at":"2025-03-04 10:05:19","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32651,"object_type":110,"object_id":2069,"attachment_id":24371,"attachment":{"id":24371,"key":24371,"name":"260df9a1-a6f6-3fe4-946a-8eb941e80f63","extension":"png","path":"\/vue\/attachment\/view\/260df9a1-a6f6-3fe4-946a-8eb941e80f63\/image.png","orig_name":"image.png"}}],"approves":[{"id":1671,"client_id":3304,"project_id":3723,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-03 10:24:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u6708\u521d\u79d1\u6280\u2014PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d291807\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf73\u67084\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":"2025-03-03 09:20:51","updated_at":"2025-03-03 10:24:33","supplier_id":90,"purchase_contract_id":3704,"amount":"291807","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2101,"key":2101,"contract_id":3704,"amount":"291807","value":"291807","attachment_id":"","from_date":"2025-01-10","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31711,"object_type":103,"object_id":2101,"attachment_id":23639,"attachment":{"id":23639,"key":23639,"name":"bf2cfe4e-5f6b-3a34-880d-3123bffeaf87","extension":"pdf","path":"\/vue\/attachment\/view\/bf2cfe4e-5f6b-3a34-880d-3123bffeaf87\/291807.pdf","orig_name":"291807.pdf"}}]}],"contractScans":[{"id":31585,"object_type":108,"object_id":3704,"attachment_id":23371,"attachment":{"id":23371,"key":23371,"name":"98386bab-8fd7-3341-a383-b51954964145","extension":"pdf","path":"\/vue\/attachment\/preview\/98386bab-8fd7-3341-a383-b51954964145\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":31609,"object_type":111,"object_id":3704,"attachment_id":23559,"attachment":{"id":23559,"key":23559,"name":"1b4a676d-1a41-3bd0-9d53-15e355ef0f0c","extension":"pdf","path":"\/vue\/attachment\/preview\/1b4a676d-1a41-3bd0-9d53-15e355ef0f0c\/2025_01_06_14_06_33.pdf","orig_name":"2025_01_06_14_06_33.pdf"}},{"id":31610,"object_type":111,"object_id":3704,"attachment_id":23575,"attachment":{"id":23575,"key":23575,"name":"b1945f22-5a09-39fd-afa7-3c7de5ad39e7","extension":"pdf","path":"\/vue\/attachment\/preview\/b1945f22-5a09-39fd-afa7-3c7de5ad39e7\/document(6).pdf","orig_name":"document(6).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":875,"user_id":1011,"key":1011,"contract_id":3704,"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":876,"user_id":5360,"key":5360,"contract_id":3704,"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":542,"key":542,"contract_id":3704,"name":"2025-03-04","value":"291807","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1671,"client_id":3304,"project_id":3723,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-03 10:24:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u6708\u521d\u79d1\u6280\u2014PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d291807\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf73\u67084\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":"2025-03-03 09:20:51","updated_at":"2025-03-03 10:24:33","supplier_id":90,"purchase_contract_id":3704,"amount":"291807","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":291807,"approve_amount":291807,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":291807,"un_collected":0,"collected_plan":291807,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3663,"supplier_id":163,"contract_type":1,"signed_at":"2024-11-14","amount":"117490.80","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-11-14 10:35:57","updated_at":"2025-01-08 16:04:24","client_id":"","project_id":"","sales_rep":"","serial_no":"2024WSCN-J-020-C2837-PAN","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-08 16:04:24.447538+08","is_chargeback":false,"client":{},"project":{},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\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":3663,"comment":3},"purchaseClientRels":[{"id":2783,"contract_id":3663,"client_id":2538,"project_id":3714,"client":{"id":2538,"key":2538,"name":"\uff08\u8fc7\u5355\uff09\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3714,"key":3714,"name":"PA VM\u865a\u62df\u5899(\u897f\u4e91\u6570\u636e)\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2036,"key":2036,"contract_id":3663,"value":"117490.80","collected_date":"2025-01-17","created_at":"2025-01-17 16:32:08","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":31914,"object_type":110,"object_id":2036,"attachment_id":23802,"attachment":{"id":23802,"key":23802,"name":"9f76f319-1f4a-34b8-bba7-1ece998cdaa6","extension":"png","path":"\/vue\/attachment\/view\/9f76f319-1f4a-34b8-bba7-1ece998cdaa6\/image.png","orig_name":"image.png"}}],"approves":[{"id":1592,"client_id":2538,"project_id":3714,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-17 10:09:06","description":"\u8001\u5927\uff0c\u6606\u4ed1\u8054\u901aPA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d117490.8\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-01-17 09:14:56","updated_at":"2025-01-17 10:09:06","supplier_id":163,"purchase_contract_id":3663,"amount":"117490.8","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2040,"key":2040,"contract_id":3663,"amount":"117490.8","value":"117490.8","attachment_id":"","from_date":"2024-11-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":30577,"object_type":103,"object_id":2040,"attachment_id":22843,"attachment":{"id":22843,"key":22843,"name":"59526898-2339-36fd-ab07-04b4f35e8470","extension":"pdf","path":"\/vue\/attachment\/view\/59526898-2339-36fd-ab07-04b4f35e8470\/10030345_20241121_24312000000363343492_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(117490.80).pdf","orig_name":"10030345_20241121_24312000000363343492_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(117490.80).pdf"}}]}],"contractScans":[{"id":30637,"object_type":108,"object_id":3663,"attachment_id":22889,"attachment":{"id":22889,"key":22889,"name":"a3c001dd-1b0c-34ab-9de7-ad269426006a","extension":"pdf","path":"\/vue\/attachment\/preview\/a3c001dd-1b0c-34ab-9de7-ad269426006a\/2024_11_25_09_29_11.pdf","orig_name":"2024_11_25_09_29_11.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":881,"user_id":1011,"key":1011,"contract_id":3663,"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":882,"user_id":5360,"key":5360,"contract_id":3663,"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":545,"key":545,"contract_id":3663,"name":"2025-01-19","value":"117490.8","overdue_days":"","pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1592,"client_id":2538,"project_id":3714,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-17 10:09:06","description":"\u8001\u5927\uff0c\u6606\u4ed1\u8054\u901aPA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d117490.8\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-01-17 09:14:56","updated_at":"2025-01-17 10:09:06","supplier_id":163,"purchase_contract_id":3663,"amount":"117490.8","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"unreadComments":{},"invoiced":117490.8,"approve_amount":117490.8,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":117490.8,"un_collected":0,"collected_plan":117490.8,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.038957+08","is_chargeback":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":2018,"key":2018,"contract_id":3621,"value":"155750.00","collected_date":"2024-12-25","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},"files":[{"id":31319,"object_type":110,"object_id":2018,"attachment_id":23386,"attachment":{"id":23386,"key":23386,"name":"c6c5d4ed-71e5-33a5-9153-1edf66b8ae03","extension":"png","path":"\/vue\/attachment\/view\/c6c5d4ed-71e5-33a5-9153-1edf66b8ae03\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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":"","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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.010155+08","is_chargeback":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":2019,"key":2019,"contract_id":3617,"value":"164065.00","collected_date":"2024-12-25","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},"files":[{"id":31320,"object_type":110,"object_id":2019,"attachment_id":23387,"attachment":{"id":23387,"key":23387,"name":"c84eb330-774a-3eb1-9b38-ac9216681cb7","extension":"png","path":"\/vue\/attachment\/view\/c84eb330-774a-3eb1-9b38-ac9216681cb7\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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,"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.669977+08","is_chargeback":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":1990,"key":1990,"contract_id":3600,"value":"55000.00","collected_date":"2024-11-29","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},"files":[{"id":30737,"object_type":110,"object_id":1990,"attachment_id":22969,"attachment":{"id":22969,"key":22969,"name":"34c309d8-57cc-3e1f-b2d9-5c42ab5d2d62","extension":"png","path":"\/vue\/attachment\/view\/34c309d8-57cc-3e1f-b2d9-5c42ab5d2d62\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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":"","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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.039877+08","is_chargeback":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":1921,"key":1921,"contract_id":3574,"value":"1200.00","collected_date":"2024-10-12","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},"files":[{"id":29241,"object_type":110,"object_id":1921,"attachment_id":21920,"attachment":{"id":21920,"key":21920,"name":"7b0f61c4-671e-3803-8425-e14577d6d7f1","extension":"png","path":"\/vue\/attachment\/view\/7b0f61c4-671e-3803-8425-e14577d6d7f1\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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,"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.863273+08","is_chargeback":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":1933,"key":1933,"contract_id":3610,"value":"132320.00","collected_date":"2024-12-16","created_at":"2024-10-21 15:00:23","created_by":1013,"description":"\u5ef6\u671f\u652f\u7968\uff1a2024\u5e7412\u670816\u65e5","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":29471,"object_type":110,"object_id":1933,"attachment_id":22131,"attachment":{"id":22131,"key":22131,"name":"c8f580de-9cc8-3fe2-a43c-bfd84fe15881","extension":"png","path":"\/vue\/attachment\/view\/c8f580de-9cc8-3fe2-a43c-bfd84fe15881\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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,"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.207737+08","is_chargeback":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":2003,"key":2003,"contract_id":3582,"value":"63000.00","collected_date":"2024-12-10","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},"files":[{"id":30987,"object_type":110,"object_id":2003,"attachment_id":23112,"attachment":{"id":23112,"key":23112,"name":"409987b5-52c5-31e4-9892-2730f26d324b","extension":"png","path":"\/vue\/attachment\/view\/409987b5-52c5-31e4-9892-2730f26d324b\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"pct":84.27},{"id":2022,"key":2022,"contract_id":3582,"value":"11757.00","collected_date":"2024-12-27","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},"files":[{"id":31365,"object_type":110,"object_id":2022,"attachment_id":23409,"attachment":{"id":23409,"key":23409,"name":"d5257981-68cf-3ea3-bb2a-9c1bb7ae377c","extension":"png","path":"\/vue\/attachment\/view\/d5257981-68cf-3ea3-bb2a-9c1bb7ae377c\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"pct":15.73}],"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,"pct":84.27,"collect_status":"\u5df2\u5b8c\u6210"},{"id":428,"key":428,"contract_id":3582,"name":"2024-12-27","value":"11757","overdue_days":0,"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":""},{"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.010114+08","is_chargeback":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":1970,"key":1970,"contract_id":3526,"value":"27850.00","collected_date":"2024-11-13","created_at":"2024-11-13 15:34:55","created_by":1013,"description":"\u7d2b\u5149\u6653\u901a\u6c47\u6b3e\u5e95\u5355","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":30368,"object_type":110,"object_id":1970,"attachment_id":22666,"attachment":{"id":22666,"key":22666,"name":"b2deef39-16a2-37ad-8099-23b9dbaeada0","extension":"png","path":"\/vue\/attachment\/view\/b2deef39-16a2-37ad-8099-23b9dbaeada0\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":461,"key":461,"contract_id":3526,"name":"2024-11-13","value":"27850","overdue_days":0,"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.939632+08","is_chargeback":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":1984,"key":1984,"contract_id":3503,"value":"103975.00","collected_date":"2024-11-28","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},"files":[{"id":30699,"object_type":110,"object_id":1984,"attachment_id":22946,"attachment":{"id":22946,"key":22946,"name":"1300ee18-440b-3f91-8c73-7507f8bca20a","extension":"png","path":"\/vue\/attachment\/view\/1300ee18-440b-3f91-8c73-7507f8bca20a\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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,"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.831611+08","is_chargeback":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":1946,"key":1946,"contract_id":3494,"value":"5384842.10","collected_date":"2024-10-30","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},"files":[{"id":29798,"object_type":110,"object_id":1946,"attachment_id":22343,"attachment":{"id":22343,"key":22343,"name":"0eebd7ce-b55f-3dbc-89a4-a61e3f302b94","extension":"png","path":"\/vue\/attachment\/view\/0eebd7ce-b55f-3dbc-89a4-a61e3f302b94\/image.png","orig_name":"image.png"}},{"id":29799,"object_type":110,"object_id":1946,"attachment_id":22344,"attachment":{"id":22344,"key":22344,"name":"7b4bd376-51cb-3a49-8847-df4a0355c1f2","extension":"png","path":"\/vue\/attachment\/view\/7b4bd376-51cb-3a49-8847-df4a0355c1f2\/image.png","orig_name":"image.png"}},{"id":29800,"object_type":110,"object_id":1946,"attachment_id":22347,"attachment":{"id":22347,"key":22347,"name":"5aa6427c-489c-3265-bff4-fe2e8ed24a51","extension":"png","path":"\/vue\/attachment\/view\/5aa6427c-489c-3265-bff4-fe2e8ed24a51\/image.png","orig_name":"image.png"}}],"approves":[{"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":""}],"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,"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":""}],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3430,"supplier_id":68,"contract_type":3,"signed_at":"2024-07-23","amount":"113368.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-07-24 13:25:49","updated_at":"2024-09-03 14:16:21","client_id":"","project_id":"","sales_rep":"","serial_no":"PA20240723SSS","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-03 14:16:21.782668+08","is_chargeback":false,"client":{},"project":{},"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\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":3430,"comment":3},"purchaseClientRels":[{"id":2140,"contract_id":3430,"client_id":2205,"project_id":3553,"client":{"id":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3553,"key":3553,"name":"PA3220\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u670d\u52a1-2024\u5e74","project_status":3}}],"purchaseContractPayments":[{"id":1877,"key":1877,"contract_id":3430,"value":"113368.00","collected_date":"2024-09-10","created_at":"2024-09-10 15:06:10","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":28595,"object_type":110,"object_id":1877,"attachment_id":21419,"attachment":{"id":21419,"key":21419,"name":"1e9c22c7-5dbb-34e8-b8ab-d8e5cdf8de6c","extension":"png","path":"\/vue\/attachment\/view\/1e9c22c7-5dbb-34e8-b8ab-d8e5cdf8de6c\/image.png","orig_name":"image.png"}}],"approves":[],"pct":100}],"purchaseContractInvoices":[{"id":1814,"key":1814,"contract_id":3430,"amount":"113368","value":"113368","attachment_id":"","from_date":"2024-08-05","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":28129,"object_type":103,"object_id":1814,"attachment_id":20721,"attachment":{"id":20721,"key":20721,"name":"8172b1b8-8c45-3988-9831-c07479cbe33c","extension":"pdf","path":"\/vue\/attachment\/view\/8172b1b8-8c45-3988-9831-c07479cbe33c\/20240805-24312000000234954230.pdf","orig_name":"20240805-24312000000234954230.pdf"}}]}],"contractScans":[{"id":27460,"object_type":108,"object_id":3430,"attachment_id":20598,"attachment":{"id":20598,"key":20598,"name":"6d325eab-aeec-3c97-a3c0-4a9d9d590b28","extension":"pdf","path":"\/vue\/attachment\/preview\/6d325eab-aeec-3c97-a3c0-4a9d9d590b28\/30-13962-11\u53cc\u7ae0.pdf","orig_name":"30-13962-11\u53cc\u7ae0.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":465,"user_id":1011,"key":1011,"contract_id":3430,"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":466,"user_id":5360,"key":5360,"contract_id":3430,"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":312,"key":312,"contract_id":3430,"name":"2024-09-08","value":"113368","overdue_days":2,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"unreadComments":{},"invoiced":113368,"approve_amount":0,"un_approve_amount":113368,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":113368,"un_collected":0,"collected_plan":113368,"is_collected":true,"can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"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.004488+08","is_chargeback":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":1852,"key":1852,"contract_id":3422,"value":"22000.00","collected_date":"2024-08-21","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},"files":[{"id":28052,"object_type":110,"object_id":1852,"attachment_id":21080,"attachment":{"id":21080,"key":21080,"name":"0d26de29-a272-3d17-a657-b83c6c3b872e","extension":"png","path":"\/vue\/attachment\/view\/0d26de29-a272-3d17-a657-b83c6c3b872e\/image.png","orig_name":"image.png"}}],"approves":[],"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,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"unreadComments":{},"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_delete":true,"unread":0,"bgcolor":"#89c541"}],"count":{"total":"25834450.32","collected":"25677187.16","un_collected":157263.16,"invoiced":"25794445.67","un_invoiced":25004.65},"can_create":true,"pagenation":{"totalcount":78,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-06-27 14:41:07') RETURNING "id" |
14:41:07.300 | 4.0 ms | yii\db\Command::query | SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("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 |
14:41:07.333 | 3.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3553, 3633, 3653, 3686, 3714, 3661, 3660, 3652, 3679, 3599, 3760, 3764, 3644, 3723, 3767, 3752, 3744, 3801, 3786) |
14:41:07.273 | 3.3 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
14:41:07.270 | 2.7 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
14:41:07.376 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422)) |
14:41:07.388 | 2.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422)) |
14:41:07.340 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (1852, 1877, 1921, 1933, 1946, 1970, 1984, 1990, 2003, 2018, 2019, 2022, 2034, 2036, 2044, 2055, 2064, 2069, 2090, 2091)) |
14:41:07.359 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1814, 1840, 1857, 1911, 1943, 1955, 1958, 1972, 1976, 1977, 1995, 2040, 2072, 2085, 2101, 2105, 2120, 2122, 2133, 2137, 2144, 2175, 2176)) |
14:41:07.278 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
14:41:07.391 | 1.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21552, 21784, 22180, 22351, 21144, 23258, 23271, 23486, 23559, 23575, 24203, 24372, 24373) |
14:41:07.363 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1814, 1840, 1857, 1911, 1943, 1955, 1958, 1972, 1976, 1977, 1995, 2040, 2072, 2085, 2101, 2105, 2120, 2122, 2133, 2137, 2144, 2175, 2176)) |
14:41:07.468 | 1.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_visit_module_histories" ("user_id", "object_type", "visit_date", "num", "last_visit_at") VALUES (1001, 13, '2025-06-27', 1, 'now()') RETURNING "id" |
14:41:07.357 | 1.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422) ORDER BY "id" |
14:41:07.332 | 1.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2205, 3296, 3301, 3311, 2538, 3304, 2845, 3286, 2545, 2616, 2553, 3327, 3278, 3334) |
14:41:07.338 | 1.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422) ORDER BY "id" |
14:41:07.307 | 0.9 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1011, 5360)) |
14:41:07.331 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422) ORDER BY "id" |
14:41:07.393 | 0.8 ms | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422) |
14:41:07.362 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24726, 24729, 24730, 24731) |
14:41:07.395 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3834, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663, 3621, 3617, 3600, 3574, 3610, 3582, 3526, 3503, 3494, 3430, 3422) ORDER BY "remind_date" |
14:41:07.306 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 90, 46, 38, 678, 163, 511, 68, 531) |
14:41:07.348 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_approve_rels" WHERE "purchase_contract_payment_id" IN (1852, 1877, 1921, 1933, 1946, 1970, 1984, 1990, 2003, 2018, 2019, 2022, 2034, 2036, 2044, 2055, 2064, 2069, 2090, 2091) |
14:41:07.308 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3) |
14:41:07.394 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360, 5016, 1000, 1001, 5329, 5332, 5420, 5087, 5300, 5295, 5404, 1004, 1005) |
14:41:07.306 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 5360) |
14:41:07.339 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001) |
14:41:07.394 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5420, 5404, 5332, 1011, 5295, 1005, 5016, 5329, 5087, 1004, 5360, 5300, 1000)) |
14:41:07.309 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1011, 5360) |
14:41:07.309 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1013, 5360)) |