68989a2d1727f: POST https://beta.jinchangxiao.com/vue/purchase-contract/list at 2025-08-10 09:10:05 pm by 223.72.35.219
Performance Profiling
Total processing time: 269 ms; Peak memory: 7.274 MB. Show Profiling Timeline
总计52条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 21:10:05.215 | 29.8 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663)) GROUP BY "object_id" |
| 21:10:05.097 | 28.3 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 21:10:05.293 | 17.5 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663)) GROUP BY "object_id" |
| 21:10:05.175 | 12.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 ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20 |
| 21:10:05.160 | 12.5 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 ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 21:10:05.125 | 10.9 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 21:10:05.139 | 9.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:10:05.260 | 9.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) )) "sub") "r" WHERE "contract_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) ORDER BY "id" DESC |
| 21:10:05.248 | 8.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) ORDER BY "id" |
| 21:10:05.193 | 8.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 236, 708, 678, 163, 478, 38, 46) |
| 21:10:05.321 | 6.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 ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
| 21:10:05.205 | 6.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 21:10:05.334 | 6.2 ms | yii\db\Command::query | SELECT SUM(amount) FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) )) "sub" WHERE "contract_id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
| 21:10:05.328 | 5.8 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE) |
| 21:10:05.345 | 4.1 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 ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE)) |
| 21:10:05.341 | 3.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 ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
| 21:10:05.351 | 3.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=13) AND ("visit_date"='2025-08-10') |
| 21:10:05.357 | 3.4 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/list', '{"PurchaseContractSearch":{"contract_type":"","handler":"","group":"1","invoice_status":"","payment_status":"","contract_scan":"","created_by":"","is_chargeback":"","collected_plan":"","is_draft":"","invoice_from_date_period":"","sales_rep":"1001"},"Filter":{"name":"signed_at","sort":"DESC"},"page":"1","from_project":"1"}', '{"code":2000,"result":{"list":[{"id":4056,"supplier_id":90,"contract_type":1,"signed_at":"2025-07-04","amount":"254601121","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":"","created_by":1011,"created_at":"2025-07-21 14:46:04","updated_at":"2025-08-07 12:11:41","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ18249","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-07 12:11:41","is_chargeback":true,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4056,"comment":1},"purchaseClientRels":[{"id":3662,"contract_id":4056,"client_id":2553,"project_id":3751,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":37378,"object_type":108,"object_id":4056,"attachment_id":26993,"attachment":{"id":26993,"key":26993,"name":"b231d6be-582a-39bf-a8da-c1874599343f","extension":"pdf","path":"\/vue\/attachment\/preview\/b231d6be-582a-39bf-a8da-c1874599343f\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1368,"user_id":1011,"key":1011,"contract_id":4056,"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":1369,"user_id":5360,"key":5360,"contract_id":4056,"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":809,"key":809,"contract_id":4056,"name":"2025-10-16","value":"254601121","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":7,"purchase_contract_id":4056,"erp_store_id":"","erp_purchase_order_product_id":3,"product_id":947,"description":"\u4eba\u5473\u513f","number":"1","amount":"4242","total_amount":"4242","erpStore":"","product":{"id":947,"name":"PAN-SVC-BKLN-3260","product_type":5,"product_component":35,"product_brand":8,"product_serie":806,"product_misc":"","product_qa":"","pn":"","description":"Partner enabled premium support year 1, PA-3260","created_by":1013,"created_at":"2023-08-03 16:07:54","updated_at":"2025-08-08 16:53:18","pinyin_shortcut":"PANSVCBKLN3260","product_unit":8,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":806,"key":806,"name":"PA-3260\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpPurchaseOrderProduct":{"id":3,"erp_purchase_order_id":3,"erp_store_id":"","product_id":947,"description":"\u4eba\u5473\u513f","number":"1","into_inventory":"0","amount":"4242","total_amount":"4242","last_number":"1","last_amount":"4242","last_total_amount":"4242"}},{"id":8,"purchase_contract_id":4056,"erp_store_id":"","erp_purchase_order_product_id":4,"product_id":2067,"description":"\u8ba9\u6211","number":"1","amount":"254543345","total_amount":"254543345","erpStore":"","product":{"id":2067,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0(\u9002\u7528\u4e8eAC-1000-B1100-4D)","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0","created_by":1013,"created_at":"2025-07-28 14:45:38","updated_at":"2025-07-28 14:50:11","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":4,"erp_purchase_order_id":3,"erp_store_id":"","product_id":2067,"description":"\u8ba9\u6211","number":"1","into_inventory":"0","amount":"254543345","total_amount":"254543345","last_number":"1","last_amount":"254543345","last_total_amount":"254543345"}},{"id":9,"purchase_contract_id":4056,"erp_store_id":"","erp_purchase_order_product_id":5,"product_id":2068,"description":"","number":"1","amount":"53534","total_amount":"53534","erpStore":"","product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-07-28 14:49:58","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":5,"erp_purchase_order_id":3,"erp_store_id":"","product_id":2068,"description":"","number":"1","into_inventory":"0","amount":"53534","total_amount":"53534","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":3,"serial_no":"CGDD-20250807-00002","from_date":"","wrote_date":"","handler":1011,"supplier_id":90,"purchase_contract_id":4056,"erp_store_id":"","status":8,"abstract":"","description":"\u6d4b\u8bd5","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-07 12:09:28","stop_at":"2025-08-07 12:09:55.094176+08","cancel_at":"2025-08-07 12:11:23.127957+08","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"3","amount":"254601121","created_by":1001,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":false,"created_at":"2025-08-07 12:09:28","updated_at":"2025-08-07 12:11:23","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"invoiced":0,"approve_amount":0,"un_approve_amount":254601121,"un_invoiced":254601121,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":0,"collected_plan":254601121,"is_collected":true,"can_update":false,"can_update_cost":false,"can_update_file":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","product_amount":254601121,"product_number":3,"is_done":false},{"id":4000,"supplier_id":236,"contract_type":3,"signed_at":"2025-06-25","amount":"2385.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-06-25 15:00:31","updated_at":"2025-06-25 15:02:26","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250625-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-06-25 15:00:43","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2385","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":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":4000,"comment":4},"purchaseClientRels":[{"id":3500,"contract_id":4000,"client_id":2545,"project_id":3899,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3899,"key":3899,"name":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1411","key":"1411","contract_id":4000,"value":"2385","collected_date":"2025-06-26 16:52:36","created_at":"2025-06-26 16:52:36","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2342,"key":2342,"contract_id":4000,"amount":"2385","value":"2385","attachment_id":"","from_date":"2025-07-03","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35525,"object_type":103,"object_id":2342,"attachment_id":26686,"attachment":{"id":26686,"key":26686,"name":"db97bf81-0dcb-3dd6-9877-b14c0cfab4dd","extension":"pdf","path":"\/vue\/attachment\/view\/db97bf81-0dcb-3dd6-9877-b14c0cfab4dd\/dzfp_25112000000137730102_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250702172433.pdf","orig_name":"dzfp_25112000000137730102_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250702172433.pdf"}}]}],"contractScans":[{"id":35379,"object_type":108,"object_id":4000,"attachment_id":26551,"attachment":{"id":26551,"key":26551,"name":"7e592363-e7e5-3afa-9a04-8d91f5f6b4c3","extension":"pdf","path":"\/vue\/attachment\/preview\/7e592363-e7e5-3afa-9a04-8d91f5f6b4c3\/\u62d3\u5b9e\u79d1\u6280-\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406\uff08\u6df1\u5733\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8\u7ef4\u4fdd\u5408\u540c2025.06.24.pdf","orig_name":"\u62d3\u5b9e\u79d1\u6280-\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406\uff08\u6df1\u5733\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8\u7ef4\u4fdd\u5408\u540c2025.06.24.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1257,"user_id":1011,"key":1011,"contract_id":4000,"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":1258,"user_id":5360,"key":5360,"contract_id":4000,"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":744,"key":744,"contract_id":4000,"name":"2025-06-26","value":"2385","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2002,"client_id":2545,"project_id":3899,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-06-26 16:44:52","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u7eed\u4fdd\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe52385\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-06-26 16:44:41","updated_at":"2025-06-26 16:44:52","supplier_id":236,"purchase_contract_id":4000,"amount":"2385","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"2385","erp_payment_un_settle_amount":"-2385","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":2385,"approve_amount":2385,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"2385","un_collected":0,"collected_plan":2385,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3987,"supplier_id":708,"contract_type":1,"signed_at":"2025-06-18","amount":"8792.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-06-18 15:34:11","updated_at":"2025-07-04 14:58:40","client_id":"","project_id":"","sales_rep":"","serial_no":"HHMT-BJ-BJTS-0088-20250618","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-04 14:58:40","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"8792","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":708,"key":708,"name":"\u5317\u4eac\u701a\u6d77\u660e\u5929\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":3987,"comment":4},"purchaseClientRels":[{"id":3499,"contract_id":3987,"client_id":3372,"project_id":3890,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1450","key":"1450","contract_id":3987,"value":"8792","collected_date":"2025-07-18 12:43:26","created_at":"2025-07-18 12:43:26","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2331,"key":2331,"contract_id":3987,"amount":"8792","value":"8792","attachment_id":"","from_date":"2025-06-25","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35366,"object_type":103,"object_id":2331,"attachment_id":26543,"attachment":{"id":26543,"key":26543,"name":"417c9c69-c748-3668-922f-eeaf9b0bd5a0","extension":"pdf","path":"\/vue\/attachment\/view\/417c9c69-c748-3668-922f-eeaf9b0bd5a0\/8792_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250625094033.pdf","orig_name":"8792_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250625094033.pdf"}}]}],"contractScans":[{"id":35156,"object_type":108,"object_id":3987,"attachment_id":26367,"attachment":{"id":26367,"key":26367,"name":"8da1688a-67f7-3e90-9bb1-99a9d17ef677","extension":"pdf","path":"\/vue\/attachment\/preview\/8da1688a-67f7-3e90-9bb1-99a9d17ef677\/2025-06-18_005.pdf","orig_name":"2025-06-18_005.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1282,"user_id":1011,"key":1011,"contract_id":3987,"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":1283,"user_id":5360,"key":5360,"contract_id":3987,"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":764,"key":764,"contract_id":3987,"name":"2025-07-10","value":"8792","overdue_days":8,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2056,"client_id":3372,"project_id":3890,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-17 09:53:58","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u2014\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d8792\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u4ed8\u6b3e\u4fe1\u606f\uff1a\n\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u701a\u6d77\u660e\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7a0e \u53f7\uff1a91110111MA01J88Y2Y\n\u5730 \u5740\uff1a\u5317\u4eac\u5e02\u623f\u5c71\u533a\u897f\u6f5e\u8857\u9053\u957f\u8679\u897f\u8def73\u53f71\u5e621\u5c42B64\n\u7535 \u8bdd\uff1a15601117288\n\u5f00 \u6237 \u884c\uff1a\u4e0a\u6d77\u6d66\u4e1c\u53d1\u5c55\u94f6\u884c\u5317\u4eac\u4e2d\u5173\u6751\u652f\u884c\n\u8d26 \u53f7\uff1a91050078801100000824\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-07-17 09:44:07","updated_at":"2025-07-17 09:53:58","supplier_id":708,"purchase_contract_id":3987,"amount":"8792","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"8792","erp_payment_un_settle_amount":"-8792","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":8792,"approve_amount":8792,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"8792","un_collected":0,"collected_plan":8792,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3982,"supplier_id":236,"contract_type":1,"signed_at":"2025-06-16","amount":"17590.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-06-16 17:41:48","updated_at":"2025-06-20 17:13:18","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250616-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-06-16 17:42:04","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"17590","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":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":3982,"comment":4},"purchaseClientRels":[{"id":3498,"contract_id":3982,"client_id":3372,"project_id":3890,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":1001},"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1398","key":"1398","contract_id":3982,"value":"17590","collected_date":"2025-06-17 11:13:10","created_at":"2025-06-17 11:13:10","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2311,"key":2311,"contract_id":3982,"amount":"17590","value":"17590","attachment_id":"","from_date":"2025-06-18","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35187,"object_type":103,"object_id":2311,"attachment_id":26395,"attachment":{"id":26395,"key":26395,"name":"a77a8c36-c774-3e0b-a058-c670d059a883","extension":"pdf","path":"\/vue\/attachment\/view\/a77a8c36-c774-3e0b-a058-c670d059a883\/dzfp_25112000000125575794_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250618165309.pdf","orig_name":"dzfp_25112000000125575794_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250618165309.pdf"}}]}],"contractScans":[{"id":35260,"object_type":108,"object_id":3982,"attachment_id":26454,"attachment":{"id":26454,"key":26454,"name":"b4ab099e-22c3-3fd0-9bb3-3dd4eca4ab28","extension":"pdf","path":"\/vue\/attachment\/preview\/b4ab099e-22c3-3fd0-9bb3-3dd4eca4ab28\/2025_06_16_17_43_33.pdf","orig_name":"2025_06_16_17_43_33.pdf"}}],"receiptScans":[{"id":35259,"object_type":111,"object_id":3982,"attachment_id":26453,"attachment":{"id":26453,"key":26453,"name":"b7e536a2-5919-384a-aab6-54cf97693828","extension":"pdf","path":"\/vue\/attachment\/preview\/b7e536a2-5919-384a-aab6-54cf97693828\/JVQ8EHNZ7-DIC-JVQ8EHNZ7-SXFKK-20250618-2257329-shouhuo_after.pdf","orig_name":"JVQ8EHNZ7-DIC-JVQ8EHNZ7-SXFKK-20250618-2257329-shouhuo_after.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1231,"user_id":1011,"key":1011,"contract_id":3982,"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":1232,"user_id":5360,"key":5360,"contract_id":3982,"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":731,"key":731,"contract_id":3982,"name":"2025-06-17","value":"17590","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1971,"client_id":3372,"project_id":3890,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-06-17 10:58:16","description":"Tristen\uff0c\u7528\u623750%\u9884\u4ed8\u6b3e\u5df2\u4ed8\uff0c\u5e0c\u671b\u672c\u5468\u4e94\u5230\u673a\u623f\uff08\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u56db\u73af\u897f\u8def65\u53f7\u6d77\u6dc0\u65b0\u6280\u672f\u5927\u53a6\u5317\u95e8\u6570\u636e\u4e2d\u5fc3\uff0c\u503c\u73ed010-82888393\uff09\u3002\u7279\u6b64\u7533\u8bf7\u8ba2\u8d27\u652f\u4ed8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe517590\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u4ed8\u6b3e\u4fe1\u606f\uff1a\n\u540d \u79f0\uff1a\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u4fe1\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u4ea4\u5927\u652f\u884c \n\u8d26 \u53f7\uff1a8110701013502212583 \n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01\n","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-06-17 10:53:15","updated_at":"2025-06-17 10:58:16","supplier_id":236,"purchase_contract_id":3982,"amount":"17590","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"17590","erp_payment_un_settle_amount":"-17590","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":17590,"approve_amount":17590,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"17590","un_collected":0,"collected_plan":17590,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3969,"supplier_id":678,"contract_type":1,"signed_at":"2025-06-10","amount":"16300.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-06-10 10:35:55","updated_at":"2025-06-12 11:07:08","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250610-HYF-002","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-06-12 11:05:03","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"16300","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3969,"comment":4},"purchaseClientRels":[{"id":3497,"contract_id":3969,"client_id":2545,"project_id":3886,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3886,"key":3886,"name":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1449","key":"1449","contract_id":3969,"value":"16300","collected_date":"2025-07-18 12:40:58","created_at":"2025-07-18 12:40:58","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2323,"key":2323,"contract_id":3969,"amount":"16300","value":"16300","attachment_id":"","from_date":"2025-06-20","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35249,"object_type":103,"object_id":2323,"attachment_id":26443,"attachment":{"id":26443,"key":26443,"name":"00766162-924c-3893-9bb2-82a6c3ded23a","extension":"pdf","path":"\/vue\/attachment\/view\/00766162-924c-3893-9bb2-82a6c3ded23a\/dzfp_25112000000127315008_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250620134149.pdf","orig_name":"dzfp_25112000000127315008_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250620134149.pdf"}}]}],"contractScans":[{"id":34896,"object_type":108,"object_id":3969,"attachment_id":26174,"attachment":{"id":26174,"key":26174,"name":"7390d9d6-1130-303f-b79a-5e7fbf30d311","extension":"pdf","path":"\/vue\/attachment\/preview\/7390d9d6-1130-303f-b79a-5e7fbf30d311\/2025_06_12_11_06_11.pdf","orig_name":"2025_06_12_11_06_11.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1217,"user_id":1011,"key":1011,"contract_id":3969,"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":1218,"user_id":5360,"key":5360,"contract_id":3969,"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":724,"key":724,"contract_id":3969,"name":"2025-07-10","value":"16300","overdue_days":8,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2058,"client_id":2545,"project_id":3886,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-17 09:53:46","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u8d44\u821f\u2014\u8054\u60f3\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d16300\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-07-17 09:47:53","updated_at":"2025-07-17 09:53:46","supplier_id":678,"purchase_contract_id":3969,"amount":"16300","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"16300","erp_payment_un_settle_amount":"-16300","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":16300,"approve_amount":16300,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"16300","un_collected":0,"collected_plan":16300,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3936,"supplier_id":90,"contract_type":1,"signed_at":"2025-05-28","amount":"31580.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-05-29 10:29:07","updated_at":"2025-06-05 11:16:12","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ13446","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-06-05 11:16:12","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"31580","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3936,"comment":1},"purchaseClientRels":[{"id":3392,"contract_id":3936,"client_id":2845,"project_id":3872,"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3872,"key":3872,"name":"PA1410 Bundle Lic\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2297,"key":2297,"contract_id":3936,"amount":"31580","value":"31580","attachment_id":"","from_date":"2025-06-06","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":34776,"object_type":103,"object_id":2297,"attachment_id":26063,"attachment":{"id":26063,"key":26063,"name":"ec378aa3-95e6-30ff-8c82-a6f47bb0a93d","extension":"pdf","path":"\/vue\/attachment\/view\/ec378aa3-95e6-30ff-8c82-a6f47bb0a93d\/31580.pdf","orig_name":"31580.pdf"}}]}],"contractScans":[{"id":34689,"object_type":108,"object_id":3936,"attachment_id":25934,"attachment":{"id":25934,"key":25934,"name":"95cbfaf3-a3de-35ae-9026-17a0c39873f6","extension":"pdf","path":"\/vue\/attachment\/preview\/95cbfaf3-a3de-35ae-9026-17a0c39873f6\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":34690,"object_type":111,"object_id":3936,"attachment_id":25935,"attachment":{"id":25935,"key":25935,"name":"6234daec-394a-353b-85a9-49f3807705e3","extension":"pdf","path":"\/vue\/attachment\/preview\/6234daec-394a-353b-85a9-49f3807705e3\/document (1).pdf","orig_name":"document (1).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1195,"user_id":1011,"key":1011,"contract_id":3936,"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":1196,"user_id":5360,"key":5360,"contract_id":3936,"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":713,"key":713,"contract_id":3936,"name":"2025-08-04","value":"31580","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f6\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":31580,"approve_amount":0,"un_approve_amount":31580,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":31580,"collected_plan":31580,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3917,"supplier_id":163,"contract_type":1,"signed_at":"2025-05-20","amount":"541000.02","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-05-20 09:30:09","updated_at":"2025-06-16 09:54:29","client_id":"","project_id":"","sales_rep":"","serial_no":"2025WSCN-L-020-C3436-PAN","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-20 09:30:34","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"541000.02","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3917,"comment":1},"purchaseClientRels":[{"id":3432,"contract_id":3917,"client_id":3364,"project_id":3857,"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2308,"key":2308,"contract_id":3917,"amount":"541000.02","value":"541000.02","attachment_id":"","from_date":"2025-06-16","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35110,"object_type":103,"object_id":2308,"attachment_id":26327,"attachment":{"id":26327,"key":26327,"name":"6a676206-f926-354e-9f52-0256b9e74de2","extension":"pdf","path":"\/vue\/attachment\/view\/6a676206-f926-354e-9f52-0256b9e74de2\/10374298_20250616_25312000000185328183_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(541000.02).pdf","orig_name":"10374298_20250616_25312000000185328183_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(541000.02).pdf"}}]}],"contractScans":[{"id":34389,"object_type":108,"object_id":3917,"attachment_id":25807,"attachment":{"id":25807,"key":25807,"name":"b1b0ddf2-5c6b-3e38-b051-2e62d01e99db","extension":"pdf","path":"\/vue\/attachment\/preview\/b1b0ddf2-5c6b-3e38-b051-2e62d01e99db\/2025_05_26_09_39_06.pdf","orig_name":"2025_05_26_09_39_06.pdf"}}],"receiptScans":[{"id":34987,"object_type":111,"object_id":3917,"attachment_id":26240,"attachment":{"id":26240,"key":26240,"name":"c448ee5d-70a1-3593-b782-4ce4039a592e","extension":"pdf","path":"\/vue\/attachment\/preview\/c448ee5d-70a1-3593-b782-4ce4039a592e\/2025_06_16_09_45_54.pdf","orig_name":"2025_06_16_09_45_54.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1127,"user_id":1011,"key":1011,"contract_id":3917,"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":1128,"user_id":5360,"key":5360,"contract_id":3917,"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":679,"key":679,"contract_id":3917,"name":"2025-09-30","value":"541000.02","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":541000.02,"approve_amount":0,"un_approve_amount":541000.02,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":541000.02,"collected_plan":541000.02,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3903,"supplier_id":478,"contract_type":1,"signed_at":"2025-05-13","amount":"50.00","handler":1011,"description":"2\u6839LC-LC 5M \u5149\u7ea4\u7ebf","contract_scan":"","created_by":1011,"created_at":"2025-05-13 16:25:22","updated_at":"2025-05-13 16:25:32","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ-WJC-20250513001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-13 16:25:32","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"50","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\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":3903,"comment":3},"purchaseClientRels":[{"id":3310,"contract_id":3903,"client_id":2545,"project_id":3855,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1107,"user_id":1011,"key":1011,"contract_id":3903,"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":1108,"user_id":5360,"key":5360,"contract_id":3903,"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":669,"key":669,"contract_id":3903,"name":"2025-06-13","value":"50","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f58\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":50,"un_invoiced":50,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":50,"collected_plan":50,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3902,"supplier_id":38,"contract_type":1,"signed_at":"2025-05-13","amount":"1920.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-05-13 16:24:19","updated_at":"2025-05-16 09:42:29","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-16 09:42:29","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"1920","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":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":3902,"comment":3},"purchaseClientRels":[{"id":3312,"contract_id":3902,"client_id":2545,"project_id":3855,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1121,"user_id":1011,"key":1011,"contract_id":3902,"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":1122,"user_id":5360,"key":5360,"contract_id":3902,"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":676,"key":676,"contract_id":3902,"name":"2025-06-13","value":"1920","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f58\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":1920,"un_invoiced":1920,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":1920,"collected_plan":1920,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3901,"supplier_id":678,"contract_type":1,"signed_at":"2025-05-13","amount":"15200.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-05-13 16:23:37","updated_at":"2025-05-14 16:10:43","client_id":"","project_id":"","sales_rep":"","serial_no":"YTY2025","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-13 16:23:48","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"15200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3901,"comment":4},"purchaseClientRels":[{"id":3311,"contract_id":3901,"client_id":2545,"project_id":3855,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","project_status":3}}],"purchaseContractPayments":[{"id":"1413","key":"1413","contract_id":3901,"value":"15200","collected_date":"2025-06-26 16:55:19","created_at":"2025-06-26 16:55:19","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2237,"key":2237,"contract_id":3901,"amount":"15200","value":"15200","attachment_id":"","from_date":"2025-05-22","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":34360,"object_type":103,"object_id":2237,"attachment_id":25784,"attachment":{"id":25784,"key":25784,"name":"dbc54674-826e-33cc-ad17-26f5c3bf39ff","extension":"pdf","path":"\/vue\/attachment\/view\/dbc54674-826e-33cc-ad17-26f5c3bf39ff\/15200(1).pdf","orig_name":"15200(1).pdf"}}]}],"contractScans":[{"id":34139,"object_type":108,"object_id":3901,"attachment_id":25568,"attachment":{"id":25568,"key":25568,"name":"6e534fc8-0fcd-3592-a20a-af708464c022","extension":"pdf","path":"\/vue\/attachment\/preview\/6e534fc8-0fcd-3592-a20a-af708464c022\/2025_05_14_16_04_58.pdf","orig_name":"2025_05_14_16_04_58.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1103,"user_id":1011,"key":1011,"contract_id":3901,"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":1104,"user_id":5360,"key":5360,"contract_id":3901,"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":667,"key":667,"contract_id":3901,"name":"2025-06-13","value":"15200","overdue_days":13,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1984,"client_id":2545,"project_id":3855,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-06-24 10:41:08","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u8054\u60f3\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe515200\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-06-23 10:04:20","updated_at":"2025-06-24 10:41:08","supplier_id":678,"purchase_contract_id":3901,"amount":"15200","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"15200","erp_payment_un_settle_amount":"-15200","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":15200,"approve_amount":15200,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"15200","un_collected":0,"collected_plan":15200,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3863,"supplier_id":90,"contract_type":3,"signed_at":"2025-04-08","amount":"3594.60","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-04-09 10:24:53","updated_at":"2025-04-09 10:25:05","client_id":"","project_id":"","sales_rep":"","serial_no":" X_2025SBQ08150","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-04-09 10:25:05","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"3594.6","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3863,"comment":3},"purchaseClientRels":[{"id":3186,"contract_id":3863,"client_id":2117,"project_id":3816,"client":{"id":2117,"key":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3816,"key":3816,"name":"\u5357\u975e\u7ea2\u77f3\u9879\u76ee\u6570\u636e\u7f51PA440\u8bbe\u5907\u7eed\u4fdd","project_status":3}}],"purchaseContractPayments":[{"id":"1380","key":"1380","contract_id":3863,"value":"3594.6","collected_date":"2025-06-06 12:49:55","created_at":"2025-06-06 12:49:55","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2212,"key":2212,"contract_id":3863,"amount":"3594.6","value":"3594.6","attachment_id":"","from_date":"2025-04-10","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":33470,"object_type":103,"object_id":2212,"attachment_id":25035,"attachment":{"id":25035,"key":25035,"name":"386750e7-5e73-3ee0-ac90-3c553925c4a1","extension":"pdf","path":"\/vue\/attachment\/view\/386750e7-5e73-3ee0-ac90-3c553925c4a1\/3594.6.pdf","orig_name":"3594.6.pdf"}}]}],"contractScans":[{"id":33436,"object_type":108,"object_id":3863,"attachment_id":25013,"attachment":{"id":25013,"key":25013,"name":"4ec279ac-097f-37ab-93ad-acebf8f260fd","extension":"pdf","path":"\/vue\/attachment\/preview\/4ec279ac-097f-37ab-93ad-acebf8f260fd\/3596.2.pdf","orig_name":"3596.2.pdf"}}],"receiptScans":[{"id":33437,"object_type":111,"object_id":3863,"attachment_id":25014,"attachment":{"id":25014,"key":25014,"name":"872705b8-25fd-35ee-ac07-560a3b904d61","extension":"pdf","path":"\/vue\/attachment\/preview\/872705b8-25fd-35ee-ac07-560a3b904d61\/2.pdf","orig_name":"2.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1061,"user_id":1011,"key":1011,"contract_id":3863,"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":1062,"user_id":5360,"key":5360,"contract_id":3863,"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":646,"key":646,"contract_id":3863,"name":"2025-06-08","value":"3594.6","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1938,"client_id":2117,"project_id":3816,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-06-06 10:28:52","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u2014PA\u7eed\u4fdd\u9879\u76ee\uff0c\u91c7\u8d2d\u91d1\u989d3594.60\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-06-06 09:59:00","updated_at":"2025-06-06 10:28:52","supplier_id":90,"purchase_contract_id":3863,"amount":"3594.60","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"3594.6","erp_payment_un_settle_amount":"-3594.6","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":3594.6,"approve_amount":3594.6,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"3594.6","un_collected":0,"collected_plan":3594.6,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":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","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2987240","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3804,"comment":3},"purchaseClientRels":[{"id":3053,"contract_id":3804,"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":"1324","key":"1324","contract_id":3804,"value":"987240.00","collected_date":"2025-03-31 14:08:10","created_at":"2025-03-31 14:08:10","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":33.05},{"id":"1322","key":"1322","contract_id":3804,"value":"2000000.00","collected_date":"2025-03-31 14:06:58","created_at":"2025-03-31 14:06:58","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":66.95}],"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":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1753,"client_id":3334,"project_id":3786,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-31 11:32:40","description":"Tristen\uff0c\u7528\u6237\u8d27\u6b3e\u5df2\u56de\uff0c\u7533\u8bf7\u65e9\u4e8e\u5408\u540c\u652f\u4ed8\u65e5\u671f\u652f\u4ed8\u91c7\u8d2d\u6b3e\u3010\u539f\u56e0\uff1a\u7d2b\u5149\u6653\u901a\u6768\u603b\u56e0\u6709\u8f83\u5927\u56de\u6b3e\u538b\u529b\uff0c\u8fdc\u9274\u7684\u8ba2\u5355\u62c6\u5206\u6210\u51e0\u4e2a\u8ba2\u5355\uff0c\u6709\u5176\u4ed6\u4ee3\u7406\u5546\u8fd8\u6ca1\u6536\u5230\u7528\u6237\u56de\u6b3e\u60f3\u8ba9\u4eca\u5929\u54b1\u4eec\u5148\u652f\u4ed8\u3011\uff0c\u91d1\u989d\uff1a\uffe52987240\uff0c\u662f\u5426\u53ef\u4ee5\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-31 10:49:31","updated_at":"2025-03-31 11:32:40","supplier_id":90,"purchase_contract_id":3804,"amount":"2987240","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"5974480","erp_payment_un_settle_amount":"-5974480","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":2987240,"approve_amount":2987240,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"2987240","un_collected":0,"collected_plan":2987240,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3769,"supplier_id":90,"contract_type":1,"signed_at":"2025-01-20","amount":"64665.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-21 15:26:45","updated_at":"2025-03-27 09:20:50","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ01556","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-27 09:20:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"64665","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3769,"comment":3},"purchaseClientRels":[{"id":3107,"contract_id":3769,"client_id":3327,"project_id":3767,"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","project_status":3}}],"purchaseContractPayments":[{"id":"1419","key":"1419","contract_id":3769,"value":"64665.00","collected_date":"2025-04-24 10:28:37","created_at":"2025-04-24 10:28:37","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2144,"key":2144,"contract_id":3769,"amount":"64665","value":"64665","attachment_id":"","from_date":"2025-02-27","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32540,"object_type":103,"object_id":2144,"attachment_id":24299,"attachment":{"id":24299,"key":24299,"name":"59d57bcb-e2ac-3543-ae5f-c2b2c7d4c38d","extension":"pdf","path":"\/vue\/attachment\/view\/59d57bcb-e2ac-3543-ae5f-c2b2c7d4c38d\/64665.pdf","orig_name":"64665.pdf"}}]}],"contractScans":[{"id":32855,"object_type":108,"object_id":3769,"attachment_id":24521,"attachment":{"id":24521,"key":24521,"name":"da56e70e-ee3c-3d98-a533-e27d3b75ae4b","extension":"pdf","path":"\/vue\/attachment\/preview\/da56e70e-ee3c-3d98-a533-e27d3b75ae4b\/64665.pdf","orig_name":"64665.pdf"}}],"receiptScans":[{"id":32654,"object_type":111,"object_id":3769,"attachment_id":24373,"attachment":{"id":24373,"key":24373,"name":"6bd047f3-11d3-31a0-a1f4-da3a20d70824","extension":"pdf","path":"\/vue\/attachment\/preview\/6bd047f3-11d3-31a0-a1f4-da3a20d70824\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1029,"user_id":1011,"key":1011,"contract_id":3769,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1030,"user_id":5360,"key":5360,"contract_id":3769,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":629,"key":629,"contract_id":3769,"name":"2025-04-25","value":"64665","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1819,"client_id":3327,"project_id":3767,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-04-22 12:20:17","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u4fe1\u8054\u6cfd\u90a6\uff08\u8fc7\u5355\uff09\u2014PA440\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d64665\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf74\u670825\u65e5\uff08\u5468\u4e94\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-04-22 11:45:26","updated_at":"2025-04-22 12:20:17","supplier_id":90,"purchase_contract_id":3769,"amount":"64665","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"64665","erp_payment_un_settle_amount":"-64665","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":64665,"approve_amount":64665,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"64665","un_collected":0,"collected_plan":64665,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3756,"supplier_id":46,"contract_type":1,"signed_at":"2025-01-14","amount":"119272.06","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-14 10:25:12","updated_at":"2025-02-19 15:39:38","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ202501133114542","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-14 17:33:23","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"119272.06","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3756,"comment":2},"purchaseClientRels":[{"id":2990,"contract_id":3756,"client_id":2616,"project_id":3764,"client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001},"project":{"id":3764,"key":3764,"name":"PA1410 \u4e24\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1313","key":"1313","contract_id":3756,"value":"119272.06","collected_date":"2025-03-12 17:20:30","created_at":"2025-03-12 17:20:30","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2122,"key":2122,"contract_id":3756,"amount":"74114.04","value":"74114.04","attachment_id":"","from_date":"2025-01-15","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32065,"object_type":103,"object_id":2122,"attachment_id":23920,"attachment":{"id":23920,"key":23920,"name":"2980173d-22ee-3b22-9f1c-16a301c025b1","extension":"pdf","path":"\/vue\/attachment\/view\/2980173d-22ee-3b22-9f1c-16a301c025b1\/25112000000011507101.pdf","orig_name":"25112000000011507101.pdf"}}]},{"id":2137,"key":2137,"contract_id":3756,"amount":"45158.02","value":"45158.02","attachment_id":"","from_date":"2025-02-20","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32443,"object_type":103,"object_id":2137,"attachment_id":24231,"attachment":{"id":24231,"key":24231,"name":"855eadd4-7ac6-33ea-ad2c-c0a7b1d53b9c","extension":"pdf","path":"\/vue\/attachment\/view\/855eadd4-7ac6-33ea-ad2c-c0a7b1d53b9c\/25112000000032709267.pdf","orig_name":"25112000000032709267.pdf"}}]}],"contractScans":[{"id":32064,"object_type":108,"object_id":3756,"attachment_id":23742,"attachment":{"id":23742,"key":23742,"name":"0a59d5cb-6646-325f-8bf0-878529d4d16b","extension":"pdf","path":"\/vue\/attachment\/preview\/0a59d5cb-6646-325f-8bf0-878529d4d16b\/DZ202501133114542.pdf","orig_name":"DZ202501133114542.pdf"}}],"receiptScans":[{"id":32411,"object_type":111,"object_id":3756,"attachment_id":24203,"attachment":{"id":24203,"key":24203,"name":"62909f9b-c901-3353-afa0-113c6a0aa038","extension":"pdf","path":"\/vue\/attachment\/preview\/62909f9b-c901-3353-afa0-113c6a0aa038\/\u8d27\u7269\u7b7e\u6536\u8bc1\u660e.pdf","orig_name":"\u8d27\u7269\u7b7e\u6536\u8bc1\u660e.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":903,"user_id":1011,"key":1011,"contract_id":3756,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":904,"user_id":5360,"key":5360,"contract_id":3756,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":556,"key":556,"contract_id":3756,"name":"2025-03-10","value":"119272.06","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1588,"client_id":2616,"project_id":3764,"title":"\u5f00\u5ef6\u652f-\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-15 10:30:48","description":"Tristen\uff0c\u7533\u8bf7\u5f00\u5177\u4e00\u5f2055\u5929\u7684\u5ef6\u671f\u652f\u7968\uff082025\u5e743\u670810\u65e5\uff09\u7528\u4e8e\u652f\u4ed8PA1410 2\u5957\u8bbe\u5907\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\u00a5119272.06\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-01-15 09:53:09","updated_at":"2025-01-15 10:30:48","supplier_id":46,"purchase_contract_id":3756,"amount":"119272.06","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"119272.06","erp_payment_un_settle_amount":"-119272.06","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":119272.06,"approve_amount":119272.06,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"119272.06","un_collected":0,"collected_plan":119272.06,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3773,"supplier_id":38,"contract_type":1,"signed_at":"2025-01-10","amount":"5520.00","handler":1013,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-22 14:28:57","updated_at":"2025-01-22 15:03:04","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250110-WJC-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-22 14:29:07","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"5520","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"commentCount":{"object_id":3773,"comment":2},"purchaseClientRels":[{"id":2979,"contract_id":3773,"client_id":2545,"project_id":3760,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1294","key":"1294","contract_id":3773,"value":"5520.00","collected_date":"2025-01-22 15:51:44","created_at":"2025-01-22 15:51:44","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2120,"key":2120,"contract_id":3773,"amount":"5520","value":"5520","attachment_id":"","from_date":"2025-01-22","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32044,"object_type":103,"object_id":2120,"attachment_id":23908,"attachment":{"id":23908,"key":23908,"name":"f1ed5f76-c399-3b69-9f04-77a45eb263ae","extension":"pdf","path":"\/vue\/attachment\/view\/f1ed5f76-c399-3b69-9f04-77a45eb263ae\/dzfp_25112000000018516389_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250122154822(1).pdf","orig_name":"dzfp_25112000000018516389_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250122154822(1).pdf"}}]}],"contractScans":[{"id":32034,"object_type":108,"object_id":3773,"attachment_id":23899,"attachment":{"id":23899,"key":23899,"name":"9488621c-762c-3bee-9f8d-1c8f77c850bd","extension":"pdf","path":"\/vue\/attachment\/preview\/9488621c-762c-3bee-9f8d-1c8f77c850bd\/\u626b\u63cf\u5168\u80fd\u738b 2025-01-22 14.36(1).pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2025-01-22 14.36(1).pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":921,"user_id":1011,"key":1011,"contract_id":3773,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":922,"user_id":5360,"key":5360,"contract_id":3773,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":565,"key":565,"contract_id":3773,"name":"2025-01-24","value":"5520","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1612,"client_id":2545,"project_id":3760,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4e91\u9526\u975e\u51e1","status":2,"next_verify_user":"","verify_at":"2025-01-22 14:46:44","description":"\u7533\u8bf7\u4ed8\u4e09\u661f\u5185\u5b5824\u6761\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d5520\u5143\u3002\u8bf7\u5ba1\u6279\uff0c\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":"","is_resubmited":false,"created_by":1013,"created_at":"2025-01-22 14:35:06","updated_at":"2025-01-22 14:46:44","supplier_id":38,"purchase_contract_id":3773,"amount":"5520","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"5520","erp_payment_un_settle_amount":"-5520","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":5520,"approve_amount":5520,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"5520","un_collected":0,"collected_plan":5520,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3747,"supplier_id":678,"contract_type":1,"signed_at":"2025-01-09","amount":"43800.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-09 10:18:12","updated_at":"2025-01-10 17:45:20","client_id":"","project_id":"","sales_rep":"","serial_no":"YTYG2025","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-09 10:18:26","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"43800","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3747,"comment":4},"purchaseClientRels":[{"id":2968,"contract_id":3747,"client_id":2545,"project_id":3760,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1303","key":"1303","contract_id":3747,"value":"43800.00","collected_date":"2025-02-13 13:39:28","created_at":"2025-02-13 13:39:28","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2105,"key":2105,"contract_id":3747,"amount":"43800","value":"43800","attachment_id":"","from_date":"2025-01-14","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31836,"object_type":103,"object_id":2105,"attachment_id":23741,"attachment":{"id":23741,"key":23741,"name":"2818f37d-a9a1-3d4b-bbc3-0a24fe1a366c","extension":"pdf","path":"\/vue\/attachment\/view\/2818f37d-a9a1-3d4b-bbc3-0a24fe1a366c\/dzfp_25112000000011073126_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250114145654(1).pdf","orig_name":"dzfp_25112000000011073126_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250114145654(1).pdf"}}]}],"contractScans":[{"id":31716,"object_type":108,"object_id":3747,"attachment_id":23644,"attachment":{"id":23644,"key":23644,"name":"2d855be1-25b6-3be4-b68b-71a758a4fbc3","extension":"pdf","path":"\/vue\/attachment\/preview\/2d855be1-25b6-3be4-b68b-71a758a4fbc3\/2025_01_10_17_43_26.pdf","orig_name":"2025_01_10_17_43_26.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":883,"user_id":1011,"key":1011,"contract_id":3747,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":884,"user_id":5360,"key":5360,"contract_id":3747,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":546,"key":546,"contract_id":3747,"name":"2025-02-10","value":"43800","overdue_days":3,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1619,"client_id":2545,"project_id":3760,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-02-10 09:52:08","description":"\u8001\u5927\uff0c\u7533\u8bf7\u652f\u4ed8\u8d44\u821f-\u670d\u52a1\u5668\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d43800\u5143\uff0c\u4ed8\u6b3e\u65e5\u671f2\u670813\u65e5\uff08\u5468\u56db\uff09\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-02-10 09:45:10","updated_at":"2025-02-10 09:52:08","supplier_id":678,"purchase_contract_id":3747,"amount":"43800","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"43800","erp_payment_un_settle_amount":"-43800","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":43800,"approve_amount":43800,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"43800","un_collected":0,"collected_plan":43800,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3727,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"67594.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 14:48:04","updated_at":"2025-03-27 09:20:20","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ36962","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-27 09:20:20","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"67594","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3727,"comment":5},"purchaseClientRels":[{"id":3109,"contract_id":3727,"client_id":3327,"project_id":3744,"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1365","key":"1365","contract_id":3727,"value":"67594.00","collected_date":"2025-04-14 11:38:12","created_at":"2025-04-14 11:38:12","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2133,"key":2133,"contract_id":3727,"amount":"67594","value":"67594","attachment_id":"","from_date":"2025-02-14","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":32260,"object_type":103,"object_id":2133,"attachment_id":24077,"attachment":{"id":24077,"key":24077,"name":"5c283bd9-2f9f-3766-aa0d-5995263ebc75","extension":"pdf","path":"\/vue\/attachment\/view\/5c283bd9-2f9f-3766-aa0d-5995263ebc75\/4216b6c4-9db4-4939-9f6b-02420a3616a1.pdf","orig_name":"4216b6c4-9db4-4939-9f6b-02420a3616a1.pdf"}}]}],"contractScans":[{"id":32856,"object_type":108,"object_id":3727,"attachment_id":24522,"attachment":{"id":24522,"key":24522,"name":"337f3561-44b4-37f4-800a-eb3b1497a778","extension":"pdf","path":"\/vue\/attachment\/preview\/337f3561-44b4-37f4-800a-eb3b1497a778\/67594.pdf","orig_name":"67594.pdf"}}],"receiptScans":[{"id":32653,"object_type":111,"object_id":3727,"attachment_id":24372,"attachment":{"id":24372,"key":24372,"name":"4d0c19b3-7261-3038-9cb8-42240499cfda","extension":"pdf","path":"\/vue\/attachment\/preview\/4d0c19b3-7261-3038-9cb8-42240499cfda\/\u7b7e\u6536\u8bc1\u660e.pdf","orig_name":"\u7b7e\u6536\u8bc1\u660e.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1027,"user_id":1011,"key":1011,"contract_id":3727,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1028,"user_id":5360,"key":5360,"contract_id":3727,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":628,"key":628,"contract_id":3727,"name":"2025-04-14","value":"67594","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1798,"client_id":3327,"project_id":3744,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-04-14 09:52:21","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u4fe1\u8054\u6cfd\u90a6\u2014PA440\u9879\u76ee\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d67594\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-04-14 09:31:55","updated_at":"2025-04-14 09:52:21","supplier_id":90,"purchase_contract_id":3727,"amount":"67594","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"67594","erp_payment_un_settle_amount":"-67594","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":67594,"approve_amount":67594,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"67594","un_collected":0,"collected_plan":67594,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3726,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"51606.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 14:47:02","updated_at":"2025-01-07 11:07:51","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ37023","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-07 11:07:51","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"51606","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3726,"comment":4},"purchaseClientRels":[{"id":3108,"contract_id":3726,"client_id":2553,"project_id":3752,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3752,"key":3752,"name":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1311","key":"1311","contract_id":3726,"value":"51606.00","collected_date":"2025-02-25 16:42:47","created_at":"2025-02-25 16:42:47","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2085,"key":2085,"contract_id":3726,"amount":"51606","value":"51606","attachment_id":"","from_date":"2024-12-30","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31406,"object_type":103,"object_id":2085,"attachment_id":23440,"attachment":{"id":23440,"key":23440,"name":"47a5a2ee-e149-3eac-afff-80b0f8a99c0e","extension":"pdf","path":"\/vue\/attachment\/view\/47a5a2ee-e149-3eac-afff-80b0f8a99c0e\/51606.pdf","orig_name":"51606.pdf"}}]}],"contractScans":[{"id":31480,"object_type":108,"object_id":3726,"attachment_id":23490,"attachment":{"id":23490,"key":23490,"name":"0d710a9a-7c30-34f1-98dc-76357124c9fd","extension":"pdf","path":"\/vue\/attachment\/preview\/0d710a9a-7c30-34f1-98dc-76357124c9fd\/document (2).pdf","orig_name":"document (2).pdf"}}],"receiptScans":[{"id":31476,"object_type":111,"object_id":3726,"attachment_id":23486,"attachment":{"id":23486,"key":23486,"name":"920446b3-3ba6-3967-803e-1460f2eb09cc","extension":"pdf","path":"\/vue\/attachment\/preview\/920446b3-3ba6-3967-803e-1460f2eb09cc\/document.pdf","orig_name":"document.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":879,"user_id":1011,"key":1011,"contract_id":3726,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":880,"user_id":5360,"key":5360,"contract_id":3726,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":544,"key":544,"contract_id":3726,"name":"2025-02-25","value":"51606","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1659,"client_id":2553,"project_id":3752,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-02-25 10:54:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u9890\u6770\u9e3f\u5229-PA\u9879\u76ee\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d51606\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-02-25 10:23:18","updated_at":"2025-02-25 10:54:33","supplier_id":90,"purchase_contract_id":3726,"amount":"51606","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"51606","erp_payment_un_settle_amount":"-51606","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":51606,"approve_amount":51606,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"51606","un_collected":0,"collected_plan":51606,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3704,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-11","amount":"291807.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-11 14:48:33","updated_at":"2025-01-07 10:53:54","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ32972","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-06 15:04:10","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"291807","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3704,"comment":4},"purchaseClientRels":[{"id":3106,"contract_id":3704,"client_id":3304,"project_id":3723,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1320","key":"1320","contract_id":3704,"value":"291807.00","collected_date":"2025-03-04 10:05:19","created_at":"2025-03-04 10:05:19","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2101,"key":2101,"contract_id":3704,"amount":"291807","value":"291807","attachment_id":"","from_date":"2025-01-10","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":31711,"object_type":103,"object_id":2101,"attachment_id":23639,"attachment":{"id":23639,"key":23639,"name":"bf2cfe4e-5f6b-3a34-880d-3123bffeaf87","extension":"pdf","path":"\/vue\/attachment\/view\/bf2cfe4e-5f6b-3a34-880d-3123bffeaf87\/291807.pdf","orig_name":"291807.pdf"}}]}],"contractScans":[{"id":31585,"object_type":108,"object_id":3704,"attachment_id":23371,"attachment":{"id":23371,"key":23371,"name":"98386bab-8fd7-3341-a383-b51954964145","extension":"pdf","path":"\/vue\/attachment\/preview\/98386bab-8fd7-3341-a383-b51954964145\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":31609,"object_type":111,"object_id":3704,"attachment_id":23559,"attachment":{"id":23559,"key":23559,"name":"1b4a676d-1a41-3bd0-9d53-15e355ef0f0c","extension":"pdf","path":"\/vue\/attachment\/preview\/1b4a676d-1a41-3bd0-9d53-15e355ef0f0c\/2025_01_06_14_06_33.pdf","orig_name":"2025_01_06_14_06_33.pdf"}},{"id":31610,"object_type":111,"object_id":3704,"attachment_id":23575,"attachment":{"id":23575,"key":23575,"name":"b1945f22-5a09-39fd-afa7-3c7de5ad39e7","extension":"pdf","path":"\/vue\/attachment\/preview\/b1945f22-5a09-39fd-afa7-3c7de5ad39e7\/document(6).pdf","orig_name":"document(6).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":875,"user_id":1011,"key":1011,"contract_id":3704,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":876,"user_id":5360,"key":5360,"contract_id":3704,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":542,"key":542,"contract_id":3704,"name":"2025-03-04","value":"291807","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1671,"client_id":3304,"project_id":3723,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-03 10:24:33","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u6708\u521d\u79d1\u6280\u2014PA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d291807\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf73\u67084\u65e5\uff08\u5468\u4e8c\uff09\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-03-03 09:20:51","updated_at":"2025-03-03 10:24:33","supplier_id":90,"purchase_contract_id":3704,"amount":"291807","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"291807","erp_payment_un_settle_amount":"-291807","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":291807,"approve_amount":291807,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"291807","un_collected":0,"collected_plan":291807,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":3663,"supplier_id":163,"contract_type":1,"signed_at":"2024-11-14","amount":"117490.80","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-11-14 10:35:57","updated_at":"2025-01-08 16:04:24","client_id":"","project_id":"","sales_rep":"","serial_no":"2024WSCN-J-020-C2837-PAN","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-08 16:04:24","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"117490.8","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3663,"comment":3},"purchaseClientRels":[{"id":2783,"contract_id":3663,"client_id":2538,"project_id":3714,"client":{"id":2538,"key":2538,"name":"\uff08\u8fc7\u5355\uff09\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3714,"key":3714,"name":"PA VM\u865a\u62df\u5899(\u897f\u4e91\u6570\u636e)\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1283","key":"1283","contract_id":3663,"value":"117490.80","collected_date":"2025-01-17 16:32:08","created_at":"2025-01-17 16:32:08","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2040,"key":2040,"contract_id":3663,"amount":"117490.8","value":"117490.8","attachment_id":"","from_date":"2024-11-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":30577,"object_type":103,"object_id":2040,"attachment_id":22843,"attachment":{"id":22843,"key":22843,"name":"59526898-2339-36fd-ab07-04b4f35e8470","extension":"pdf","path":"\/vue\/attachment\/view\/59526898-2339-36fd-ab07-04b4f35e8470\/10030345_20241121_24312000000363343492_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(117490.80).pdf","orig_name":"10030345_20241121_24312000000363343492_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(117490.80).pdf"}}]}],"contractScans":[{"id":30637,"object_type":108,"object_id":3663,"attachment_id":22889,"attachment":{"id":22889,"key":22889,"name":"a3c001dd-1b0c-34ab-9de7-ad269426006a","extension":"pdf","path":"\/vue\/attachment\/preview\/a3c001dd-1b0c-34ab-9de7-ad269426006a\/2024_11_25_09_29_11.pdf","orig_name":"2024_11_25_09_29_11.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":881,"user_id":1011,"key":1011,"contract_id":3663,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":882,"user_id":5360,"key":5360,"contract_id":3663,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":545,"key":545,"contract_id":3663,"name":"2025-01-19","value":"117490.8","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1592,"client_id":2538,"project_id":3714,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-01-17 10:09:06","description":"\u8001\u5927\uff0c\u6606\u4ed1\u8054\u901aPA\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d117490.8\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-01-17 09:14:56","updated_at":"2025-01-17 10:09:06","supplier_id":163,"purchase_contract_id":3663,"amount":"117490.8","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"117490.8","erp_payment_un_settle_amount":"-117490.8","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":117490.8,"approve_amount":117490.8,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"117490.8","un_collected":0,"collected_plan":117490.8,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false}],"count":{"total":"29204487.94","collected":"28604933.76","un_collected":599554.18,"invoiced":"29162513.29","un_invoiced":26974.65},"can_create":true,"pagenation":{"totalcount":86,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-10 21:10:05') RETURNING "id" |
| 21:10:05.288 | 3.1 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 (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663)) GROUP BY "r"."id" |
| 21:10:05.275 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2040, 2085, 2101, 2105, 2120, 2122, 2133, 2137, 2144, 2153, 2212, 2237, 2297, 2308, 2311, 2323, 2331, 2342)) |
| 21:10:05.282 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663)) |
| 21:10:05.279 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663)) |
| 21:10:05.272 | 2.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2040, 2085, 2101, 2105, 2120, 2122, 2133, 2137, 2144, 2153, 2212, 2237, 2297, 2308, 2311, 2323, 2331, 2342)) |
| 21:10:05.271 | 1.2 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 (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) ORDER BY "id" |
| 21:10:05.292 | 1.0 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 (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663)) ORDER BY "id" |
| 21:10:05.212 | 1.0 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"=1011) |
| 21:10:05.312 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (947, 2067, 2068) |
| 21:10:05.355 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=22, "last_visit_at"='now()' WHERE "id"=55017 |
| 21:10:05.259 | 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 (3714, 3760, 3764, 3786, 3723, 3767, 3752, 3744, 3816, 3855, 3872, 3857, 3886, 3890, 3899, 3751) |
| 21:10:05.278 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22843, 23440, 23639, 23741, 23908, 23920, 24077, 24231, 24299, 24350, 25035, 25784, 26063, 26327, 26395, 26443, 26543, 26686) |
| 21:10:05.286 | 0.7 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 (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) |
| 21:10:05.317 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) |
| 21:10:05.287 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) ORDER BY "remind_date" |
| 21:10:05.313 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 5) |
| 21:10:05.258 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2538, 2545, 2616, 3334, 3304, 3327, 2553, 2117, 2845, 3364, 3372) |
| 21:10:05.317 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (3, 4, 5) |
| 21:10:05.311 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4056, 4000, 3987, 3982, 3969, 3936, 3917, 3903, 3902, 3901, 3863, 3804, 3769, 3756, 3773, 3747, 3727, 3726, 3704, 3663) |
| 21:10:05.213 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3 |
| 21:10:05.315 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (231, 806) |
| 21:10:05.314 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (51, 35) |
| 21:10:05.315 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 8) |
| 21:10:05.318 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id"=3 ORDER BY "id" |
| 21:10:05.319 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id"=3 ORDER BY "id" |
| 21:10:05.282 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22889, 23490, 23371, 23644, 23899, 23742, 24374, 24521, 24522, 25013, 25568, 25807, 25934, 26174, 26367, 26454, 26551, 26993) |
| 21:10:05.319 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id"=3 ORDER BY "id" |
| 21:10:05.214 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1013) |
| 21:10:05.316 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8) |
| 21:10:05.285 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23486, 23559, 23575, 24203, 24352, 24372, 24373, 25014, 25935, 26240, 26453) |
| 21:10:05.270 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 |
| 21:10:05.287 | 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, 5360)) |
| 21:10:05.286 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360) |
| 21:10:05.215 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1013)) |