Total processing time: 433 ms; Peak memory: 5.963 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
15:59:47.902 | 53.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
15:59:48.009 | 37.6 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3834, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) GROUP BY "object_id" |
15:59:48.160 | 21.1 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 5016 AND is_read = false) AND ("object_id" IN (3834, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) GROUP BY "object_id" |
15:59:48.205 | 19.7 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
15:59:47.956 | 18.8 ms | yii\db\Command::query | SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20 |
15:59:47.979 | 14.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 438, 669, 664, 262, 236, 685, 676, 608, 684, 534, 678, 489, 81, 59, 90, 668, 223, 618) |
15:59:48.103 | 12.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_approve_rels" WHERE "purchase_contract_payment_id" IN (2068, 2071, 2072, 2073, 2074, 2079, 2082, 2083, 2090, 2091, 2092) |
15:59:48.090 | 12.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24353, 24397, 24435, 24441, 24548, 24676) |
15:59:48.193 | 10.9 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) 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) |
15:59:48.077 | 9.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (2068, 2071, 2072, 2073, 2074, 2079, 2082, 2083, 2090, 2091, 2092)) |
15:59:48.228 | 9.5 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
15:59:48.182 | 9.5 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
15:59:48.239 | 8.8 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 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"=5016)) 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)) |
15:59:48.063 | 8.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5388, 5360, 1001) |
15:59:48.149 | 6.9 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, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) GROUP BY "r"."id" |
15:59:48.253 | 6.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=13) AND ("visit_date"='2025-07-04') |
15:59:48.119 | 6.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, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "id" |
15:59:48.260 | 6.1 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_visit_module_histories" ("user_id", "object_type", "visit_date", "num", "last_visit_at") VALUES (5016, 13, '2025-07-04', 1, 'now()') RETURNING "id" |
15:59:47.845 | 5.3 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
15:59:47.857 | 4.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
15:59:48.144 | 4.9 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, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "remind_date" |
15:59:48.056 | 4.7 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, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "id" |
15:59:47.996 | 3.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5016, 1011, 5360) |
15:59:48.051 | 3.9 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3270, 2546, 189, 93, 918, 3333, 20, 4, 518, 1301, 531, 12, 107, 2136, 3278, 3334) |
15:59:48.267 | 3.7 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', 5016, 5, 'vue/purchase-contract/list', '{"PurchaseContractSearch":{"contract_type":"","handler":"","group":"","invoice_status":"","payment_status":"","contract_scan":"","created_by":"","is_chargeback":"","collected_plan":"","invoice_from_date_period":"","sales_rep":""},"Filter":{"name":"signed_at","sort":"DESC"},"page":"1","from_project":"1","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"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-06-27 14:41:54","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,"cost_type":1,"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":[{"id":33155,"object_type":108,"object_id":3834,"attachment_id":24778,"attachment":{"id":24778,"key":24778,"name":"d934ac1b-3c49-3dbf-8b32-825f72be9bf5","extension":"pdf","path":"\/vue\/attachment\/preview\/d934ac1b-3c49-3dbf-8b32-825f72be9bf5\/InvSqrt.pdf","orig_name":"InvSqrt.pdf"}}],"receiptScans":[{"id":33156,"object_type":111,"object_id":3834,"attachment_id":24779,"attachment":{"id":24779,"key":24779,"name":"09bfd0bc-67cf-33fc-9f67-f2580c8cdb75","extension":"jpg","path":"\/vue\/attachment\/preview\/09bfd0bc-67cf-33fc-9f67-f2580c8cdb75\/WechatIMG54800.jpg","orig_name":"WechatIMG54800.jpg"}}],"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\u671f51\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":""}],"costContractAmounts":[],"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_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3832,"supplier_id":438,"contract_type":1,"signed_at":"2025-04-14","amount":"111.00","handler":1011,"description":"","contract_scan":"","created_by":5016,"created_at":"2025-04-14 14:24:27","updated_at":"2025-04-14 14:24:27","client_id":"","project_id":"","sales_rep":"","serial_no":"aqdqwe","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":438,"key":438,"name":"\u9752\u5c9b\u946b\u96f7\u97f3\u7535\u5b50\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":3832,"comment":1},"purchaseClientRels":[{"id":3113,"contract_id":3832,"client_id":2136,"project_id":3795,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","sales_rep":5087},"project":{"id":3795,"key":3795,"name":"Deepseek\u79c1\u6709\u5316\u90e8\u7f72","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":0,"un_approve_amount":111,"un_invoiced":111,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":111,"collected_plan":0,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3828,"supplier_id":669,"contract_type":3,"signed_at":"2025-03-12","amount":"15000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-12 15:32:14","updated_at":"2025-04-14 13:27:00","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250312-HYF-002","payment_collection_remind_ahead":"","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-03-12 15:32:23.850163+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":669,"key":669,"name":"\u5b8b\u56fd\u5efa"},"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":3828,"comment":1},"purchaseClientRels":[{"id":3111,"contract_id":3828,"client_id":12,"project_id":3784,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3784,"key":3784,"name":"\u6570\u636e\u6062\u590d-K-2025","project_status":2}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":33015,"object_type":108,"object_id":3828,"attachment_id":24538,"attachment":{"id":24538,"key":24538,"name":"29d21eaf-5869-3a49-ba4b-e58b184b2b2f","extension":"pdf","path":"\/vue\/attachment\/preview\/29d21eaf-5869-3a49-ba4b-e58b184b2b2f\/2025_03_13_17_27_38.pdf","orig_name":"2025_03_13_17_27_38.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1009,"user_id":1011,"key":1011,"contract_id":3828,"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":1010,"user_id":5360,"key":5360,"contract_id":3828,"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":619,"key":619,"contract_id":3828,"name":"2025-03-21","value":"15000","overdue_days":"","pct":100,"collect_status":"\u903e\u671f105\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":0,"un_approve_amount":15000,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":0,"un_collected":15000,"collected_plan":15000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3826,"supplier_id":664,"contract_type":3,"signed_at":"2025-03-12","amount":"1800.00","handler":1011,"description":"3AAA \u4fe1\u7528\u8bc1\u4e66\u7533\u8bf7","contract_scan":"","created_by":1011,"created_at":"2025-03-12 10:10:23","updated_at":"2025-03-13 09:55:26","client_id":"","project_id":"","sales_rep":"","serial_no":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250312-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 10:10:33.03161+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":664,"key":664,"name":"\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\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":3826,"comment":4},"purchaseClientRels":[],"purchaseContractPayments":[{"id":2079,"key":2079,"contract_id":3826,"value":"1800.00","collected_date":"2025-03-14","created_at":"2025-03-14 11:37:46","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32889,"object_type":110,"object_id":2079,"attachment_id":24548,"attachment":{"id":24548,"key":24548,"name":"cab4e287-2f58-3558-b941-f224f1b5b2e2","extension":"png","path":"\/vue\/attachment\/view\/cab4e287-2f58-3558-b941-f224f1b5b2e2\/image.png","orig_name":"image.png"}}],"approves":[{"id":1714,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-13 10:13:16","description":"Triten\uff0c\u7533\u8bf7\u672c\u5468\u5185\u652f\u4ed83AAA\u8bc1\u4e66\u7533\u529e\uff08\u539f\u8bc1\u4e663-14\u5230\u671f\uff0c3\u6708\u4efd\u4e2d\u7535\u79d1\u6295\u6807\u8981\u7528\uff09\u4e03\u8bc1\u4e00\u724c\u8d39\u7528\uff0c\u91d1\u989d\uff1a\uffe51800\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u8d26\u6237\u540d\u79f0:\t\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\t\n\u8d26\u6237\u53f7\u7801:\t110949915710701\t\n\u5f00\u6237\u94f6\u884c:\t\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e38\u8425\u652f\u884c\n\n\u5907\u6ce8\uff1a\u8d39\u7528\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-13 09:58:43","updated_at":"2025-03-13 10:13:16","supplier_id":664,"purchase_contract_id":3826,"amount":"1800","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2174,"key":2174,"contract_id":3826,"amount":"1800","value":"1800","attachment_id":"","from_date":"2025-03-13","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32876,"object_type":103,"object_id":2174,"attachment_id":24534,"attachment":{"id":24534,"key":24534,"name":"c7605d14-ceec-301e-a666-6ad053fd3142","extension":"pdf","path":"\/vue\/attachment\/view\/c7605d14-ceec-301e-a666-6ad053fd3142\/1800.pdf","orig_name":"1800.pdf"}}]}],"contractScans":[{"id":32877,"object_type":108,"object_id":3826,"attachment_id":24535,"attachment":{"id":24535,"key":24535,"name":"5ff034d1-2245-341a-8248-4317bd98701b","extension":"pdf","path":"\/vue\/attachment\/preview\/5ff034d1-2245-341a-8248-4317bd98701b\/2025_03_13_09_52_42.pdf","orig_name":"2025_03_13_09_52_42.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1005,"user_id":1011,"key":1011,"contract_id":3826,"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":1006,"user_id":5360,"key":5360,"contract_id":3826,"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":617,"key":617,"contract_id":3826,"name":"2025-03-14","value":"1800","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1714,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-13 10:13:16","description":"Triten\uff0c\u7533\u8bf7\u672c\u5468\u5185\u652f\u4ed83AAA\u8bc1\u4e66\u7533\u529e\uff08\u539f\u8bc1\u4e663-14\u5230\u671f\uff0c3\u6708\u4efd\u4e2d\u7535\u79d1\u6295\u6807\u8981\u7528\uff09\u4e03\u8bc1\u4e00\u724c\u8d39\u7528\uff0c\u91d1\u989d\uff1a\uffe51800\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u8d26\u6237\u540d\u79f0:\t\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\t\n\u8d26\u6237\u53f7\u7801:\t110949915710701\t\n\u5f00\u6237\u94f6\u884c:\t\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e38\u8425\u652f\u884c\n\n\u5907\u6ce8\uff1a\u8d39\u7528\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-13 09:58:43","updated_at":"2025-03-13 10:13:16","supplier_id":664,"purchase_contract_id":3826,"amount":"1800","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":1800,"approve_amount":1800,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":1800,"un_collected":0,"collected_plan":1800,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3825,"supplier_id":262,"contract_type":1,"signed_at":"2025-03-11","amount":"1000.00","handler":1011,"description":"\u79ef\u5206\u8f6c\u4eac\u4e1c\u5361","contract_scan":"","created_by":1011,"created_at":"2025-03-11 18:00:20","updated_at":"2025-03-12 13:41:32","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a310549989269","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-11 18:00:27.203813+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"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":3825,"comment":3},"purchaseClientRels":[{"id":3093,"contract_id":3825,"client_id":1301,"project_id":3603,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295},"project":{"id":3603,"key":3603,"name":"2024\u5e74\u6df1\u4fe1\u670d\u8bbe\u5907\u7eed\u4fdd-G","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2171,"key":2171,"contract_id":3825,"amount":"1000","value":"1000","attachment_id":"","from_date":"2025-03-12","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32841,"object_type":103,"object_id":2171,"attachment_id":24507,"attachment":{"id":24507,"key":24507,"name":"2d88fb0c-00b9-3895-a4e5-18044a5b8d8d","extension":"pdf","path":"\/vue\/attachment\/view\/2d88fb0c-00b9-3895-a4e5-18044a5b8d8d\/1000.pdf","orig_name":"1000.pdf"}}]}],"contractScans":[{"id":32853,"object_type":108,"object_id":3825,"attachment_id":24520,"attachment":{"id":24520,"key":24520,"name":"8e23544b-8a03-39a1-a3e2-c22b65c93772","extension":"png","path":"\/vue\/attachment\/preview\/8e23544b-8a03-39a1-a3e2-c22b65c93772\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1001,"user_id":1011,"key":1011,"contract_id":3825,"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":1002,"user_id":5360,"key":5360,"contract_id":3825,"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":615,"key":615,"contract_id":3825,"name":"2025-03-14","value":"1000","overdue_days":"","pct":100,"collect_status":"\u903e\u671f112\u5929"}],"paymentApproves":[{"id":1708,"client_id":1301,"project_id":3603,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-03-12 11:15:06","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u4eac\u4e1c\u793c\u54c1\u5361\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe51000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-12 10:31:49","updated_at":"2025-03-12 11:15:06","supplier_id":262,"purchase_contract_id":3825,"amount":"1000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":1000,"approve_amount":1000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":1000,"collected_plan":1000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3824,"supplier_id":262,"contract_type":1,"signed_at":"2025-03-11","amount":"5399.18","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-11 17:17:46","updated_at":"2025-03-11 17:17:57","client_id":"","project_id":"","sales_rep":"","serial_no":"311433509610","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-11 17:17:57.404527+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"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":3824,"comment":3},"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2166,"key":2166,"contract_id":3824,"amount":"898.83","value":"898.83","attachment_id":"","from_date":"2025-03-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32833,"object_type":103,"object_id":2166,"attachment_id":24500,"attachment":{"id":24500,"key":24500,"name":"baf1a33b-2781-3c87-b759-3631b1abf3c1","extension":"pdf","path":"\/vue\/attachment\/view\/baf1a33b-2781-3c87-b759-3631b1abf3c1\/digital_25137200000034847380.pdf","orig_name":"digital_25137200000034847380.pdf"}}]},{"id":2167,"key":2167,"contract_id":3824,"amount":"898.83","value":"898.83","attachment_id":"","from_date":"2025-03-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32832,"object_type":103,"object_id":2167,"attachment_id":24501,"attachment":{"id":24501,"key":24501,"name":"d2efe616-5108-378c-849e-9d59e3d0a381","extension":"pdf","path":"\/vue\/attachment\/view\/d2efe616-5108-378c-849e-9d59e3d0a381\/digital_25137200000034847381.pdf","orig_name":"digital_25137200000034847381.pdf"}}]},{"id":2168,"key":2168,"contract_id":3824,"amount":"898.83","value":"898.83","attachment_id":"","from_date":"2025-03-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32831,"object_type":103,"object_id":2168,"attachment_id":24502,"attachment":{"id":24502,"key":24502,"name":"df329806-f876-3c54-9170-6e2e5fd4fda1","extension":"pdf","path":"\/vue\/attachment\/view\/df329806-f876-3c54-9170-6e2e5fd4fda1\/digital_25137200000034847382.pdf","orig_name":"digital_25137200000034847382.pdf"}}]},{"id":2169,"key":2169,"contract_id":3824,"amount":"2702.69","value":"2702.69","attachment_id":"","from_date":"2025-03-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32830,"object_type":103,"object_id":2169,"attachment_id":24503,"attachment":{"id":24503,"key":24503,"name":"82c48b45-520f-3477-804b-008bf56a6dfd","extension":"pdf","path":"\/vue\/attachment\/view\/82c48b45-520f-3477-804b-008bf56a6dfd\/digital_25137200000034847383.pdf","orig_name":"digital_25137200000034847383.pdf"}}]}],"contractScans":[{"id":32824,"object_type":108,"object_id":3824,"attachment_id":24499,"attachment":{"id":24499,"key":24499,"name":"0b114868-3d35-37d8-a656-d20c3cc43cfb","extension":"png","path":"\/vue\/attachment\/preview\/0b114868-3d35-37d8-a656-d20c3cc43cfb\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":999,"user_id":1011,"key":1011,"contract_id":3824,"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":1000,"user_id":5360,"key":5360,"contract_id":3824,"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":614,"key":614,"contract_id":3824,"name":"2025-03-14","value":"5399.18","overdue_days":"","pct":100,"collect_status":"\u903e\u671f112\u5929"}],"paymentApproves":[{"id":1707,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-03-11 17:21:55","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed86\u74f6\u56fd\u7a961573\u767d\u9152\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe55399.18\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-11 17:21:48","updated_at":"2025-03-11 17:21:55","supplier_id":262,"purchase_contract_id":3824,"amount":"5399.18","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":5399.18,"approve_amount":5399.18,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":5399.18,"collected_plan":5399.18,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3823,"supplier_id":236,"contract_type":1,"signed_at":"2025-03-10","amount":"9378.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-10 17:24:05","updated_at":"2025-03-14 11:30:38","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250310-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-10 17:24:19.398219+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":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":3823,"comment":2},"purchaseClientRels":[{"id":3102,"contract_id":3823,"client_id":107,"project_id":3777,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","sales_rep":5295},"project":{"id":3777,"key":3777,"name":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K","project_status":3}}],"purchaseContractPayments":[{"id":2074,"key":2074,"contract_id":3823,"value":"9378.00","collected_date":"2025-03-10","created_at":"2025-03-10 17:24:37","created_by":5360,"description":"\u9884\u4ed8\u6b3e\u62b5\u6263","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"files":[],"approves":[],"pct":100}],"purchaseContractInvoices":[],"contractScans":[{"id":32888,"object_type":108,"object_id":3823,"attachment_id":24547,"attachment":{"id":24547,"key":24547,"name":"71856a62-e34d-3d92-bcdf-c7c6ce92e464","extension":"pdf","path":"\/vue\/attachment\/preview\/71856a62-e34d-3d92-bcdf-c7c6ce92e464\/\u5408\u540c(4).pdf","orig_name":"\u5408\u540c(4).pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":993,"user_id":1011,"key":1011,"contract_id":3823,"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":994,"user_id":5360,"key":5360,"contract_id":3823,"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":609,"key":609,"contract_id":3823,"name":"2025-03-10","value":"9378","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":0,"un_approve_amount":9378,"un_invoiced":9378,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":9378,"un_collected":0,"collected_plan":9378,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3821,"supplier_id":685,"contract_type":1,"signed_at":"2025-03-10","amount":"1835600.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-10 10:00:39","updated_at":"2025-03-12 09:12:31","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250305-ZHY-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-10 10:02:46.792734+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\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":3821,"comment":2},"purchaseClientRels":[{"id":3076,"contract_id":3821,"client_id":3333,"project_id":3783,"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":""},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":32838,"object_type":108,"object_id":3821,"attachment_id":24506,"attachment":{"id":24506,"key":24506,"name":"b7bb953f-b587-3868-a790-d288f3fe8caf","extension":"pdf","path":"\/vue\/attachment\/preview\/b7bb953f-b587-3868-a790-d288f3fe8caf\/2025_03_12_09_07_58.pdf","orig_name":"2025_03_12_09_07_58.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":991,"user_id":1011,"key":1011,"contract_id":3821,"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":992,"user_id":5360,"key":5360,"contract_id":3821,"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":606,"key":606,"contract_id":3821,"name":"2025-04-04","value":"550680","overdue_days":"","pct":30,"collect_status":"\u903e\u671f91\u5929"},{"id":607,"key":607,"contract_id":3821,"name":"2025-05-30","value":"1193140","overdue_days":"","pct":65,"collect_status":"\u903e\u671f35\u5929"},{"id":608,"key":608,"contract_id":3821,"name":"2025-06-30","value":"91780","overdue_days":"","pct":5,"collect_status":"\u903e\u671f4\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":0,"un_approve_amount":1835600,"un_invoiced":1835600,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":1835600,"collected_plan":1835600,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3820,"supplier_id":676,"contract_type":1,"signed_at":"2025-03-07","amount":"25000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-07 13:47:55","updated_at":"2025-03-11 09:17:42","client_id":"","project_id":"","sales_rep":"","serial_no":"ALX-Q20250310-0105","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 13:48:10.910116+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\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":3820,"comment":2},"purchaseClientRels":[{"id":3097,"contract_id":3820,"client_id":518,"project_id":3772,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K","project_status":3}}],"purchaseContractPayments":[{"id":2073,"key":2073,"contract_id":3820,"value":"25000.00","collected_date":"2025-03-07","created_at":"2025-03-07 14:49:25","created_by":5388,"description":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"files":[{"id":32735,"object_type":110,"object_id":2073,"attachment_id":24441,"attachment":{"id":24441,"key":24441,"name":"82e691b5-c455-3f7a-9dd6-b1829d1489e0","extension":"jpg","path":"\/vue\/attachment\/view\/82e691b5-c455-3f7a-9dd6-b1829d1489e0\/\u5b89\u8054\u901a\u4ed8\u6b3e\u5355-25000\u5143.jpg","orig_name":"\u5b89\u8054\u901a\u4ed8\u6b3e\u5355-25000\u5143.jpg"}}],"approves":[{"id":1694,"client_id":518,"project_id":3772,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-07 14:23:28","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u56fd\u79d1\u73af\u5b87-\u663e\u5361\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d25000\u5143\uff0c\u663e\u5361\u9700\u8981\u73b0\u7ed3\u624d\u80fd\u53d1\u8d27\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-03-07 14:10:17","updated_at":"2025-03-07 14:23:28","supplier_id":676,"purchase_contract_id":3820,"amount":"25000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2164,"key":2164,"contract_id":3820,"amount":"25000","value":"25000","attachment_id":"","from_date":"2025-03-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32817,"object_type":103,"object_id":2164,"attachment_id":24493,"attachment":{"id":24493,"key":24493,"name":"65e1c5d3-de95-3d27-ad81-9feb7132e760","extension":"pdf","path":"\/vue\/attachment\/view\/65e1c5d3-de95-3d27-ad81-9feb7132e760\/dzfp_25112000000048539295_\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8_20250311160622.pdf","orig_name":"dzfp_25112000000048539295_\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8_20250311160622.pdf"}}]}],"contractScans":[{"id":32799,"object_type":108,"object_id":3820,"attachment_id":24482,"attachment":{"id":24482,"key":24482,"name":"7fc110e4-d613-3b33-b60f-3a8ad7d46624","extension":"pdf","path":"\/vue\/attachment\/preview\/7fc110e4-d613-3b33-b60f-3a8ad7d46624\/2025_03_11_09_15_24.pdf","orig_name":"2025_03_11_09_15_24.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":987,"user_id":1011,"key":1011,"contract_id":3820,"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":988,"user_id":5360,"key":5360,"contract_id":3820,"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":603,"key":603,"contract_id":3820,"name":"2025-03-07","value":"25000","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1694,"client_id":518,"project_id":3772,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-07 14:23:28","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u56fd\u79d1\u73af\u5b87-\u663e\u5361\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d25000\u5143\uff0c\u663e\u5361\u9700\u8981\u73b0\u7ed3\u624d\u80fd\u53d1\u8d27\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-03-07 14:10:17","updated_at":"2025-03-07 14:23:28","supplier_id":676,"purchase_contract_id":3820,"amount":"25000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":25000,"approve_amount":25000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":25000,"un_collected":0,"collected_plan":25000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3819,"supplier_id":608,"contract_type":1,"signed_at":"2025-03-07","amount":"256.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-07 09:58:30","updated_at":"2025-03-12 16:07:16","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4256424362229592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 16:07:16.377674+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"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":3819,"comment":2},"purchaseClientRels":[{"id":3101,"contract_id":3819,"client_id":12,"project_id":3794,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2173,"key":2173,"contract_id":3819,"amount":"256","value":"256","attachment_id":"","from_date":"2025-03-12","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32864,"object_type":103,"object_id":2173,"attachment_id":24528,"attachment":{"id":24528,"key":24528,"name":"b2c14256-7869-3182-9e0f-100d4e15e625","extension":"pdf","path":"\/vue\/attachment\/view\/b2c14256-7869-3182-9e0f-100d4e15e625\/dzfp_25124000000000282974_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250312160223.pdf","orig_name":"dzfp_25124000000000282974_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250312160223.pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1011,"user_id":1011,"key":1011,"contract_id":3819,"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":1012,"user_id":5360,"key":5360,"contract_id":3819,"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":620,"key":620,"contract_id":3819,"name":"2025-03-28","value":"256","overdue_days":"","pct":100,"collect_status":"\u903e\u671f98\u5929"}],"paymentApproves":[{"id":1710,"client_id":12,"project_id":3794,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-03-12 23:29:13","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d256\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":"2025-03-12 13:38:22","updated_at":"2025-03-12 23:29:13","supplier_id":608,"purchase_contract_id":3819,"amount":"256","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":256,"approve_amount":256,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":256,"collected_plan":256,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3818,"supplier_id":684,"contract_type":3,"signed_at":"2025-03-07","amount":"3500.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-07 09:50:03","updated_at":"2025-03-07 11:01:34","client_id":"","project_id":"","sales_rep":"","serial_no":"SFSHFWH202503060228","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 09:50:11.494352+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\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":3818,"comment":2},"purchaseClientRels":[{"id":3071,"contract_id":3818,"client_id":918,"project_id":3666,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1005},"project":{"id":3666,"key":3666,"name":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":2072,"key":2072,"contract_id":3818,"value":"3500.00","collected_date":"2025-03-07","created_at":"2025-03-07 10:15:04","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32729,"object_type":110,"object_id":2072,"attachment_id":24435,"attachment":{"id":24435,"key":24435,"name":"0c68c2ed-6ad8-3125-9fee-cb090c58cb32","extension":"png","path":"\/vue\/attachment\/view\/0c68c2ed-6ad8-3125-9fee-cb090c58cb32\/image.png","orig_name":"image.png"}}],"approves":[{"id":1689,"client_id":918,"project_id":3666,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-07 09:58:39","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u571f\u6728\u9879\u76ee\u4e2d55\u53f0\u670d\u52a1\u5668\u7aefEDR\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe53500\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u957f\u6c99\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u9ad8\u65b0\u652f\u884c\n810000194191000001\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-07 09:58:32","updated_at":"2025-03-07 09:58:39","supplier_id":684,"purchase_contract_id":3818,"amount":"3500","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2160,"key":2160,"contract_id":3818,"amount":"3500","value":"3500","attachment_id":"","from_date":"2025-03-07","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32738,"object_type":103,"object_id":2160,"attachment_id":24443,"attachment":{"id":24443,"key":24443,"name":"7ca8de9b-9d89-33ac-be1e-2f4e0f9ba80e","extension":"pdf","path":"\/vue\/attachment\/view\/7ca8de9b-9d89-33ac-be1e-2f4e0f9ba80e\/202503070068_25432000000029796062.pdf","orig_name":"202503070068_25432000000029796062.pdf"}}]}],"contractScans":[{"id":32730,"object_type":108,"object_id":3818,"attachment_id":24436,"attachment":{"id":24436,"key":24436,"name":"3fed5de7-dbea-3b2f-b985-1773504f1261","extension":"pdf","path":"\/vue\/attachment\/preview\/3fed5de7-dbea-3b2f-b985-1773504f1261\/PO(8740)3335442943428841670.pdf","orig_name":"PO(8740)3335442943428841670.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":983,"user_id":1011,"key":1011,"contract_id":3818,"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":984,"user_id":5360,"key":5360,"contract_id":3818,"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":601,"key":601,"contract_id":3818,"name":"2025-03-07","value":"3500","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1689,"client_id":918,"project_id":3666,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-07 09:58:39","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u571f\u6728\u9879\u76ee\u4e2d55\u53f0\u670d\u52a1\u5668\u7aefEDR\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe53500\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u957f\u6c99\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u9ad8\u65b0\u652f\u884c\n810000194191000001\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-07 09:58:32","updated_at":"2025-03-07 09:58:39","supplier_id":684,"purchase_contract_id":3818,"amount":"3500","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":3500,"approve_amount":3500,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":3500,"un_collected":0,"collected_plan":3500,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3817,"supplier_id":534,"contract_type":3,"signed_at":"2025-03-06","amount":"31000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-07 09:42:23","updated_at":"2025-03-07 09:42:59","client_id":"","project_id":"","sales_rep":"","serial_no":"2025022801-TSZHY5","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 09:42:59.885037+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\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":3817,"comment":1},"purchaseClientRels":[{"id":3070,"contract_id":3817,"client_id":93,"project_id":3699,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":32722,"object_type":108,"object_id":3817,"attachment_id":24430,"attachment":{"id":24430,"key":24430,"name":"fec2c8b7-b47b-3bcd-a616-59c1beab1e82","extension":"pdf","path":"\/vue\/attachment\/preview\/fec2c8b7-b47b-3bcd-a616-59c1beab1e82\/\u62d3\u5b9e \u53cc\u7ae0 \u6280\u672f\u670d\u52a1\u5408\u540c20250228-TSZHY5.pdf","orig_name":"\u62d3\u5b9e \u53cc\u7ae0 \u6280\u672f\u670d\u52a1\u5408\u540c20250228-TSZHY5.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":981,"user_id":1011,"key":1011,"contract_id":3817,"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":982,"user_id":5360,"key":5360,"contract_id":3817,"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":600,"key":600,"contract_id":3817,"name":"2025-04-07","value":"31000","overdue_days":"","pct":100,"collect_status":"\u903e\u671f88\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":0,"un_approve_amount":31000,"un_invoiced":31000,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":0,"un_collected":31000,"collected_plan":31000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3814,"supplier_id":678,"contract_type":1,"signed_at":"2025-03-06","amount":"1300.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-06 11:37:44","updated_at":"2025-03-06 11:38:00","client_id":"","project_id":"","sales_rep":"","serial_no":"YTYG20250306","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-06 11:38:00.265795+08","is_chargeback":false,"cost_type":1,"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":3814,"comment":1},"purchaseClientRels":[{"id":3094,"contract_id":3814,"client_id":531,"project_id":3791,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2159,"key":2159,"contract_id":3814,"amount":"1300","value":"1300","attachment_id":"","from_date":"2025-03-07","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32724,"object_type":103,"object_id":2159,"attachment_id":24431,"attachment":{"id":24431,"key":24431,"name":"f04d687d-20c2-33ad-a621-60804da281e2","extension":"pdf","path":"\/vue\/attachment\/view\/f04d687d-20c2-33ad-a621-60804da281e2\/dzfp_25112000000045378206_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250307093845(1).pdf","orig_name":"dzfp_25112000000045378206_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250307093845(1).pdf"}}]}],"contractScans":[{"id":32704,"object_type":108,"object_id":3814,"attachment_id":24416,"attachment":{"id":24416,"key":24416,"name":"2db63238-2bf8-3e36-a32c-af27a28d3e9f","extension":"pdf","path":"\/vue\/attachment\/preview\/2db63238-2bf8-3e36-a32c-af27a28d3e9f\/\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf\u53cc\u7ae0\u5408\u540c1300\u5143.pdf","orig_name":"\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf\u53cc\u7ae0\u5408\u540c1300\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":977,"user_id":1011,"key":1011,"contract_id":3814,"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":978,"user_id":5360,"key":5360,"contract_id":3814,"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":598,"key":598,"contract_id":3814,"name":"2025-04-07","value":"1300","overdue_days":"","pct":100,"collect_status":"\u903e\u671f88\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":1300,"approve_amount":0,"un_approve_amount":1300,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":1300,"collected_plan":1300,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3810,"supplier_id":489,"contract_type":1,"signed_at":"2025-03-05","amount":"1000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-05 14:34:26","updated_at":"2025-03-05 14:34:39","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250305-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-05 14:34:39.512905+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\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":3810,"comment":1},"purchaseClientRels":[{"id":3079,"contract_id":3810,"client_id":4,"project_id":3789,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":973,"user_id":1011,"key":1011,"contract_id":3810,"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":974,"user_id":5360,"key":5360,"contract_id":3810,"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":596,"key":596,"contract_id":3810,"name":"2025-04-04","value":"1000","overdue_days":"","pct":100,"collect_status":"\u903e\u671f91\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":0,"un_approve_amount":1000,"un_invoiced":1000,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":1000,"collected_plan":1000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3813,"supplier_id":81,"contract_type":1,"signed_at":"2025-03-04","amount":"300.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-06 09:36:20","updated_at":"2025-03-06 09:36:35","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250304-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-06 09:36:35.475788+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"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":3813,"comment":1},"purchaseClientRels":[{"id":3077,"contract_id":3813,"client_id":20,"project_id":3792,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2156,"key":2156,"contract_id":3813,"amount":"300","value":"300","attachment_id":"","from_date":"2025-03-06","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32689,"object_type":103,"object_id":2156,"attachment_id":24407,"attachment":{"id":24407,"key":24407,"name":"898bc533-61b4-357b-95d5-c6dde7c83a26","extension":"pdf","path":"\/vue\/attachment\/view\/898bc533-61b4-357b-95d5-c6dde7c83a26\/dzfp_25112000000044427279_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250306092501(1).pdf","orig_name":"dzfp_25112000000044427279_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250306092501(1).pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":975,"user_id":1011,"key":1011,"contract_id":3813,"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":976,"user_id":5360,"key":5360,"contract_id":3813,"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":597,"key":597,"contract_id":3813,"name":"2025-04-04","value":"300","overdue_days":"","pct":100,"collect_status":"\u903e\u671f91\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":300,"approve_amount":0,"un_approve_amount":300,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":300,"collected_plan":300,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3806,"supplier_id":59,"contract_type":1,"signed_at":"2025-03-03","amount":"800.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-04 09:39:32","updated_at":"2025-03-11 13:25:18","client_id":"","project_id":"","sales_rep":"","serial_no":"TGXC20250303-1","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-04 09:39:45.167064+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\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":3806,"comment":1},"purchaseClientRels":[{"id":3089,"contract_id":3806,"client_id":518,"project_id":3788,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295},"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2170,"key":2170,"contract_id":3806,"amount":"800","value":"800","attachment_id":"","from_date":"2025-03-11","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32835,"object_type":103,"object_id":2170,"attachment_id":24504,"attachment":{"id":24504,"key":24504,"name":"29dcc02e-8721-31ae-81b2-c99cecfb677e","extension":"pdf","path":"\/vue\/attachment\/view\/29dcc02e-8721-31ae-81b2-c99cecfb677e\/\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.11\uff08800\u5143\uff09.pdf","orig_name":"\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.11\uff08800\u5143\uff09.pdf"}}]}],"contractScans":[{"id":32815,"object_type":108,"object_id":3806,"attachment_id":24492,"attachment":{"id":24492,"key":24492,"name":"8cc43939-d5a9-3d1a-ae3e-8f160be7dab0","extension":"pdf","path":"\/vue\/attachment\/preview\/8cc43939-d5a9-3d1a-ae3e-8f160be7dab0\/2025_03_11_13_23_30.pdf","orig_name":"2025_03_11_13_23_30.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":969,"user_id":1011,"key":1011,"contract_id":3806,"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":970,"user_id":5360,"key":5360,"contract_id":3806,"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":594,"key":594,"contract_id":3806,"name":"2025-04-03","value":"800","overdue_days":"","pct":100,"collect_status":"\u903e\u671f92\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":800,"approve_amount":0,"un_approve_amount":800,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":800,"collected_plan":800,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3804,"supplier_id":90,"contract_type":1,"signed_at":"2025-02-28","amount":"2987240.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-28 17:39:38","updated_at":"2025-03-04 14:06:13","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ03860","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 17:41:00.380205+08","is_chargeback":false,"cost_type":1,"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":3804,"comment":4},"purchaseClientRels":[],"purchaseContractPayments":[{"id":2082,"key":2082,"contract_id":3804,"value":"1.00","collected_date":"2025-04-29","created_at":"2025-04-29 15:51:15","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":0},{"id":2083,"key":2083,"contract_id":3804,"value":"1.00","collected_date":"2025-04-21","created_at":"2025-04-29 15:51:22","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":0},{"id":2092,"key":2092,"contract_id":3804,"value":"-2","collected_date":"2025-05-08","created_at":"2025-05-08 09:31:27","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[{"id":33032,"object_type":110,"object_id":2092,"attachment_id":24676,"attachment":{"id":24676,"key":24676,"name":"87486f5b-e5dd-368d-ba44-16a05a178b93","extension":"png","path":"\/vue\/attachment\/view\/87486f5b-e5dd-368d-ba44-16a05a178b93\/77.png","orig_name":"77.png"}}],"approves":[],"pct":-0}],"purchaseContractInvoices":[{"id":2153,"key":2153,"contract_id":3804,"amount":"2987240","value":"2987240","attachment_id":"","from_date":"2025-02-28","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32697,"object_type":103,"object_id":2153,"attachment_id":24350,"attachment":{"id":24350,"key":24350,"name":"ab60b7c3-d45c-3842-bec8-5e6487d01800","extension":"pdf","path":"\/vue\/attachment\/view\/ab60b7c3-d45c-3842-bec8-5e6487d01800\/25122000000012707968_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"25122000000012707968_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":32655,"object_type":108,"object_id":3804,"attachment_id":24374,"attachment":{"id":24374,"key":24374,"name":"185a770c-fb97-3bb1-ab6b-4aeeef74825c","extension":"pdf","path":"\/vue\/attachment\/preview\/185a770c-fb97-3bb1-ab6b-4aeeef74825c\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":32612,"object_type":111,"object_id":3804,"attachment_id":24352,"attachment":{"id":24352,"key":24352,"name":"6509fe1e-12a7-3d14-afeb-de851a1872c3","extension":"pdf","path":"\/vue\/attachment\/preview\/6509fe1e-12a7-3d14-afeb-de851a1872c3\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":967,"user_id":1011,"key":1011,"contract_id":3804,"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":968,"user_id":5360,"key":5360,"contract_id":3804,"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":593,"key":593,"contract_id":3804,"name":"2025-04-14","value":"2987240","overdue_days":"","pct":100,"collect_status":"\u903e\u671f81\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":2987240,"approve_amount":0,"un_approve_amount":2987240,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":2987240,"collected_plan":2987240,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3802,"supplier_id":668,"contract_type":3,"signed_at":"2025-02-28","amount":"3000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-28 10:50:02","updated_at":"2025-02-28 13:21:53","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250228-HYF-002","payment_collection_remind_ahead":"","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-02-28 10:50:11.824878+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":668,"key":668,"name":"\u9ec4\u5d58"},"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":3802,"comment":2},"purchaseClientRels":[{"id":3043,"contract_id":3802,"client_id":3270,"project_id":3583,"client":{"id":3270,"key":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":5087},"project":{"id":3583,"key":3583,"name":"\u670d\u52a1\u8d39-K","project_status":3}}],"purchaseContractPayments":[{"id":2071,"key":2071,"contract_id":3802,"value":"3000.00","collected_date":"2025-03-05","created_at":"2025-03-05 14:37:21","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32676,"object_type":110,"object_id":2071,"attachment_id":24397,"attachment":{"id":24397,"key":24397,"name":"220c1486-a268-376f-9d48-98c3bad1da6e","extension":"png","path":"\/vue\/attachment\/view\/220c1486-a268-376f-9d48-98c3bad1da6e\/image.png","orig_name":"image.png"}}],"approves":[{"id":1669,"client_id":3270,"project_id":3583,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u9ec4\u5d58","status":2,"next_verify_user":"","verify_at":"2025-03-03 15:33:07","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u670d\u52a1\u8d39\u91d1\u989d\uff1a\uffe53000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u62db\u5546\u94f6\u884c\u200b \u5361\u53f7\uff1a6226 0901 0518 1958 \u62db\u884c\u5317\u4eac\u5efa\u56fd\u8def\u652f\u884c \u9ec4\u5d58\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:49","updated_at":"2025-03-03 15:33:07","supplier_id":668,"purchase_contract_id":3802,"amount":"3000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[],"contractScans":[{"id":32569,"object_type":108,"object_id":3802,"attachment_id":24321,"attachment":{"id":24321,"key":24321,"name":"d4213b45-3b73-3479-8e37-d7c704b30d16","extension":"pdf","path":"\/vue\/attachment\/preview\/d4213b45-3b73-3479-8e37-d7c704b30d16\/\u6280\u672f\u670d\u52a1\u534f\u8bae-20250228-Scan.pdf","orig_name":"\u6280\u672f\u670d\u52a1\u534f\u8bae-20250228-Scan.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":963,"user_id":1011,"key":1011,"contract_id":3802,"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":964,"user_id":5360,"key":5360,"contract_id":3802,"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":590,"key":590,"contract_id":3802,"name":"2025-03-07","value":"3000","overdue_days":"","pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1669,"client_id":3270,"project_id":3583,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u9ec4\u5d58","status":2,"next_verify_user":"","verify_at":"2025-03-03 15:33:07","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u670d\u52a1\u8d39\u91d1\u989d\uff1a\uffe53000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u62db\u5546\u94f6\u884c\u200b \u5361\u53f7\uff1a6226 0901 0518 1958 \u62db\u884c\u5317\u4eac\u5efa\u56fd\u8def\u652f\u884c \u9ec4\u5d58\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:49","updated_at":"2025-03-03 15:33:07","supplier_id":668,"purchase_contract_id":3802,"amount":"3000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":0,"approve_amount":3000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":3000,"un_collected":0,"collected_plan":3000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3801,"supplier_id":223,"contract_type":1,"signed_at":"2025-02-28","amount":"12919.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-28 10:49:09","updated_at":"2025-03-05 09:15:46","client_id":"","project_id":"","sales_rep":"","serial_no":"WYY-ZC-2025022801-BJJX","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 10:49:24.601955+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\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":3801,"comment":2},"purchaseClientRels":[{"id":3058,"contract_id":3801,"client_id":189,"project_id":3770,"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","sales_rep":5295},"project":{"id":3770,"key":3770,"name":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6","project_status":3}}],"purchaseContractPayments":[{"id":2068,"key":2068,"contract_id":3801,"value":"12919.00","collected_date":"2025-03-03","created_at":"2025-03-03 16:11:48","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32613,"object_type":110,"object_id":2068,"attachment_id":24353,"attachment":{"id":24353,"key":24353,"name":"dcd13f21-9f6f-35f3-a204-2c6cb6bafa62","extension":"png","path":"\/vue\/attachment\/view\/dcd13f21-9f6f-35f3-a204-2c6cb6bafa62\/image.png","orig_name":"image.png"}}],"approves":[{"id":1668,"client_id":189,"project_id":3770,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-03 15:33:15","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5353\u8c6a\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe512919\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6536\u6b3e\u4eba\u540d\u79f0\uff1a\u5353\u8c6a\uff08\u4e2d\u56fd\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u94f6\u884c\u6d77\u6dc0\u533a\u652f\u884c\u8425\u4e1a\u90e8\n\u8d26\u53f7\uff1a329856019711\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:25","updated_at":"2025-03-03 15:33:15","supplier_id":223,"purchase_contract_id":3801,"amount":"12919","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100}],"purchaseContractInvoices":[{"id":2162,"key":2162,"contract_id":3801,"amount":"12919","value":"12919","attachment_id":"","from_date":"2025-03-05","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32798,"object_type":103,"object_id":2162,"attachment_id":24481,"attachment":{"id":24481,"key":24481,"name":"27a02320-99ea-34fe-b385-67e07cd7d347","extension":"pdf","path":"\/vue\/attachment\/view\/27a02320-99ea-34fe-b385-67e07cd7d347\/dzfp_25112000000044105879_\u25ca\u00f8\u222b\u00bf\u00a3\u00ae\u00f7\u2013\u03c0\u02d9\u00a3\u00a9\u00ba\u00ba\u00a0\u0131\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20250305163028.pdf","orig_name":"dzfp_25112000000044105879_\u25ca\u00f8\u222b\u00bf\u00a3\u00ae\u00f7\u2013\u03c0\u02d9\u00a3\u00a9\u00ba\u00ba\u00a0\u0131\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20250305163028.pdf"}}]}],"contractScans":[{"id":32663,"object_type":108,"object_id":3801,"attachment_id":24382,"attachment":{"id":24382,"key":24382,"name":"1afa7cb2-3c10-35c8-a6e9-d6c10386c484","extension":"pdf","path":"\/vue\/attachment\/preview\/1afa7cb2-3c10-35c8-a6e9-d6c10386c484\/2025_03_05_09_11_24.pdf","orig_name":"2025_03_05_09_11_24.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":961,"user_id":1011,"key":1011,"contract_id":3801,"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":962,"user_id":5360,"key":5360,"contract_id":3801,"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":589,"key":589,"contract_id":3801,"name":"2025-03-04","value":"12919","overdue_days":"","pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1668,"client_id":189,"project_id":3770,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-03 15:33:15","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5353\u8c6a\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe512919\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6536\u6b3e\u4eba\u540d\u79f0\uff1a\u5353\u8c6a\uff08\u4e2d\u56fd\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u94f6\u884c\u6d77\u6dc0\u533a\u652f\u884c\u8425\u4e1a\u90e8\n\u8d26\u53f7\uff1a329856019711\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:25","updated_at":"2025-03-03 15:33:15","supplier_id":223,"purchase_contract_id":3801,"amount":"12919","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":12919,"approve_amount":12919,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":12919,"un_collected":0,"collected_plan":12919,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3800,"supplier_id":618,"contract_type":1,"signed_at":"2025-02-28","amount":"9155.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-02-28 09:33:10","updated_at":"2025-02-28 09:35:29","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250228-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 09:33:22.643253+08","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\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":3800,"comment":1},"purchaseClientRels":[{"id":3052,"contract_id":3800,"client_id":2546,"project_id":3785,"client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295},"project":{"id":3785,"key":3785,"name":"2025\u65b0\u8d2dUPS","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2155,"key":2155,"contract_id":3800,"amount":"9155","value":"9155","attachment_id":"","from_date":"2025-03-05","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32685,"object_type":103,"object_id":2155,"attachment_id":24406,"attachment":{"id":24406,"key":24406,"name":"448ce081-ce73-34ec-885b-f40978493759","extension":"pdf","path":"\/vue\/attachment\/view\/448ce081-ce73-34ec-885b-f40978493759\/20250305_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25112000000044291569_9155.00\u526f\u672c.pdf","orig_name":"20250305_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25112000000044291569_9155.00\u526f\u672c.pdf"}}]}],"contractScans":[{"id":32561,"object_type":108,"object_id":3800,"attachment_id":24317,"attachment":{"id":24317,"key":24317,"name":"340f1ff3-6b24-3dd3-b110-040de46123ce","extension":"pdf","path":"\/vue\/attachment\/preview\/340f1ff3-6b24-3dd3-b110-040de46123ce\/\u62d3\u5b9e-\u6052\u6cf0\u6b63\u5b87UPS\u5408\u540c20250228.pdf","orig_name":"\u62d3\u5b9e-\u6052\u6cf0\u6b63\u5b87UPS\u5408\u540c20250228.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":959,"user_id":1011,"key":1011,"contract_id":3800,"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":960,"user_id":5360,"key":5360,"contract_id":3800,"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":588,"key":588,"contract_id":3800,"name":"2025-03-25","value":"9155","overdue_days":"","pct":100,"collect_status":"\u903e\u671f101\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":9155,"approve_amount":0,"un_approve_amount":9155,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":9155,"collected_plan":9155,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"}],"count":{"total":"218869828.67","collected":"210147043.93","un_collected":8722784.74,"invoiced":"214461002.58","un_invoiced":4301763.25},"can_create":true,"pagenation":{"totalcount":1874,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 15:59:48') RETURNING "id" |
15:59:47.850 | 3.2 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5016 |
15:59:48.157 | 3.1 ms | yii\db\Command::query | SELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id" IN (3834, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) ORDER BY "id" |
15:59:48.116 | 3.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id" IN (1668, 1669, 1689, 1694, 1714) |
15:59:48.133 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3834, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) |
15:59:48.129 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2153, 2155, 2156, 2159, 2160, 2162, 2164, 2166, 2167, 2168, 2169, 2170, 2171, 2173, 2174, 2175, 2176)) |
15:59:48.140 | 2.5 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, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) |
15:59:48.004 | 2.5 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, 5016, 5360)) |
15:59:48.126 | 2.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2153, 2155, 2156, 2159, 2160, 2162, 2164, 2166, 2167, 2168, 2169, 2170, 2171, 2173, 2174, 2175, 2176)) |
15:59:48.137 | 2.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3834, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) |
15:59:48.049 | 1.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3834, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "id" |
15:59:48.136 | 1.0 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24317, 24321, 24374, 24382, 24416, 24430, 24436, 24482, 24492, 24499, 24506, 24520, 24535, 24547, 24538, 24778) |
15:59:48.055 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3583, 3785, 3770, 3699, 3666, 3783, 3792, 3789, 3788, 3603, 3791, 3772, 3794, 3777, 3784, 3795, 3801, 3786) |
15:59:48.007 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3, 10) |
15:59:48.132 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24406, 24407, 24350, 24431, 24443, 24481, 24493, 24503, 24502, 24501, 24500, 24504, 24507, 24528, 24534, 24727, 24728, 24732, 24733) |
15:59:48.143 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360, 1001, 5329, 5332, 5420, 5087, 5300, 5295, 5404, 1004, 1005) |
15:59:48.129 | 0.3 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) |
15:59:48.008 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1011, 5360) |
15:59:48.143 | 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, 5329, 1005, 5087, 1004, 5360, 5300)) |
15:59:48.008 | 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)) |
15:59:48.139 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24352, 24779) |