6891a7e648540: POST https://beta.jinchangxiao.com/vue/purchase-contract/list at 2025-08-05 02:42:46 pm by 124.64.23.198
Database Queries
总计50条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:42:46.438 | 3.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1000 |
| 14:42:46.443 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:42:46.452 | 8.5 ms | SELECT | SELECT COUNT(*) FROM (SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 14:42:46.461 | 8.7 ms | SELECT | SELECT c.* FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20 |
| 14:42:46.471 | 2.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 138, 608, 262, 236, 505, 478, 626, 280, 715, 712) |
| 14:42:46.473 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5252, 1011, 5360) |
| 14:42:46.474 | 0.7 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5252, 5360)) |
| 14:42:46.474 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4, 6) |
| 14:42:46.475 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360) |
| 14:42:46.475 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360)) |
| 14:42:46.476 | 23.2 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034)) GROUP BY "object_id" |
| 14:42:46.499 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) ORDER BY "id" |
| 14:42:46.500 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 2094, 2177, 1492, 2136, 3383, 2182, 2526, 3343, 1301, 3387) |
| 14:42:46.500 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3918, 3704, 3865, 3810, 3922, 3929, 3928, 3926, 3925, 3919, 3930, 3920, 3911, 3924, 3882, 3841, 3835, 3934) |
| 14:42:46.501 | 7.8 ms | SELECT | 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 (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) ORDER BY "id" DESC |
| 14:42:46.509 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1013, 1001) |
| 14:42:46.510 | 0.8 ms | SELECT | 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 (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) ORDER BY "id" |
| 14:42:46.511 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2357, 2360, 2363, 2368, 2372, 2373, 2374, 2375, 2376, 2377, 2378, 2379, 2380, 2381)) |
| 14:42:46.512 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27144, 27146) |
| 14:42:46.513 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2357, 2360, 2363, 2368, 2372, 2373, 2374, 2375, 2376, 2377, 2378, 2379, 2380, 2381)) |
| 14:42:46.514 | 1.9 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26845, 26863, 26892, 27003, 27036, 27039, 27083, 27091, 27095, 27129, 27145, 27147) |
| 14:42:46.516 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034)) |
| 14:42:46.518 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26843, 26850, 26860, 26885, 26979, 26986, 27001, 27007, 27033, 27081, 27082, 27090, 27102, 27107) |
| 14:42:46.518 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034)) |
| 14:42:46.520 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26899, 26926, 27034) |
| 14:42:46.520 | 0.4 ms | SELECT | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) |
| 14:42:46.521 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360) |
| 14:42:46.521 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360)) |
| 14:42:46.521 | 0.4 ms | SELECT | 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 (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) ORDER BY "remind_date" |
| 14:42:46.522 | 2.6 ms | SELECT | 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 (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034)) GROUP BY "r"."id" |
| 14:42:46.525 | 0.7 ms | SELECT | 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 (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034)) ORDER BY "id" |
| 14:42:46.526 | 17.2 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034)) GROUP BY "object_id" |
| 14:42:46.543 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) |
| 14:42:46.544 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2067 |
| 14:42:46.545 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 14:42:46.545 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=51 |
| 14:42:46.546 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=12 |
| 14:42:46.546 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=231 |
| 14:42:46.547 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 14:42:46.547 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4074, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4040, 4038, 4037, 4034) |
| 14:42:46.548 | 7.5 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
| 14:42:46.556 | 7.1 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE) |
| 14:42:46.564 | 10.0 ms | SELECT | 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 (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
| 14:42:46.574 | 6.8 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) |
| 14:42:46.581 | 7.5 ms | SELECT | SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 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"=1000)) OR ("pcr"."id" IS NULL)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE)) |
| 14:42:46.591 | 3.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1000) AND ("object_type"=13) AND ("visit_date"='2025-08-05') |
| 14:42:46.595 | 4.3 ms | SELECT | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_visit_module_histories' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:42:46.599 | 9.3 ms | SELECT | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_visit_module_histories' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:42:46.609 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=54935 |
| 14:42:46.611 | 3.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 5, 'vue/purchase-contract/list', '{"PurchaseContractSearch":{"contract_type":"","handler":"","group":"","invoice_status":"","payment_status":"","contract_scan":"","created_by":"","is_chargeback":"","collected_plan":"","is_draft":"","invoice_from_date_period":"","sales_rep":""},"Filter":{"name":"signed_at","sort":"DESC"},"page":"1","from_project":"1","web_access_token":"DkSM59AGtfUwbJa1Lr7tT74KmdPG8nsg"}', '{"code":2000,"result":{"list":[{"id":4074,"supplier_id":"","contract_type":"","signed_at":"2025-08-04","amount":"0","handler":"","description":"","contract_scan":"","created_by":1001,"created_at":"2025-08-04 14:23:03","updated_at":"2025-08-04 14:23:03","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":true,"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":{},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{},"commentCount":{},"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","collected":"0","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":4072,"supplier_id":431,"contract_type":1,"signed_at":"2025-08-04","amount":"53400","handler":1011,"description":"","contract_scan":"","created_by":5252,"created_at":"2025-08-04 11:00:32","updated_at":"2025-08-04 12:35:51","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u8c01\u662f\u8c01","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7292","erp_un_settle_amount":"46108","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\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":4072,"comment":6},"purchaseClientRels":[{"id":3652,"contract_id":4072,"client_id":3387,"project_id":3934,"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1005},"project":{"id":3934,"key":3934,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","project_status":3}}],"purchaseContractPayments":[{"id":"41990","key":"41990","contract_id":4072,"value":"-1","collected_date":"2025-08-04 11:48:26","created_at":"2025-08-04 11:48:26","created_by":5252,"description":"\u5c0f\u6d4b\u8bd5","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":-0},{"id":"12068","key":"12068","contract_id":4072,"value":"1","collected_date":"2025-08-04 13:23:42","created_at":"2025-08-04 13:23:42","created_by":1001,"description":"111","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0},{"id":"12062","key":"12062","contract_id":4072,"value":"1","collected_date":"2025-08-04 11:45:20","created_at":"2025-08-04 11:45:20","created_by":5252,"description":"\u6d4b\u8bd5","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":0},{"id":"12061","key":"12061","contract_id":4072,"value":"1","collected_date":"2025-08-04 11:43:16","created_at":"2025-08-04 11:43:16","created_by":5252,"description":"\u8ba2\u5355","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":0},{"id":"12060","key":"12060","contract_id":4072,"value":"4000","collected_date":"2025-08-04 11:42:32","created_at":"2025-08-04 11:42:32","created_by":5252,"description":"","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":7.49},{"id":"12059","key":"12059","contract_id":4072,"value":"2222","collected_date":"2025-08-04 11:38:18","created_at":"2025-08-04 11:38:18","created_by":5252,"description":"","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":4.16},{"id":"12058","key":"12058","contract_id":4072,"value":"534","collected_date":"2025-08-04 11:32:25","created_at":"2025-08-04 11:32:25","created_by":5252,"description":"54345","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":1},{"id":"12056","key":"12056","contract_id":4072,"value":"534","collected_date":"2025-08-04 11:30:28","created_at":"2025-08-04 11:30:28","created_by":5252,"description":"54345","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":1}],"purchaseContractInvoices":[{"id":2378,"key":2378,"contract_id":4072,"amount":"61409.86","value":"61409.86","attachment_id":"","from_date":"2025-08-04","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[{"id":37348,"object_type":21,"object_id":2378,"attachment_id":27146,"attachment":{"id":27146,"key":27146,"name":"054f080d-f9b8-387d-ad44-94a61fb28a09","extension":"png","path":"\/vue\/attachment\/view\/054f080d-f9b8-387d-ad44-94a61fb28a09\/\u622a\u5c4f2025-07-28 09.00.49.png","orig_name":"\u622a\u5c4f2025-07-28 09.00.49.png"}}],"files":[{"id":37349,"object_type":103,"object_id":2378,"attachment_id":27147,"attachment":{"id":27147,"key":27147,"name":"237f7037-9c3b-3086-8db1-39366c24b124","extension":"png","path":"\/vue\/attachment\/view\/237f7037-9c3b-3086-8db1-39366c24b124\/\u622a\u5c4f2025-08-04 10.34.45.png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}]},{"id":2379,"key":2379,"contract_id":4072,"amount":"3.00","value":"3.00","attachment_id":"","from_date":"2025-08-04","description":"3","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":37327,"object_type":21,"object_id":2379,"attachment_id":27144,"attachment":{"id":27144,"key":27144,"name":"3577ee26-80ae-3b63-a82c-cd21dca7813f","extension":"png","path":"\/vue\/attachment\/view\/3577ee26-80ae-3b63-a82c-cd21dca7813f\/\u622a\u5c4f2025-08-04 10.34.45.png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}],"files":[{"id":37328,"object_type":103,"object_id":2379,"attachment_id":27145,"attachment":{"id":27145,"key":27145,"name":"7e14b400-bba0-36e3-a958-0d9bcda02929","extension":"png","path":"\/vue\/attachment\/view\/7e14b400-bba0-36e3-a958-0d9bcda02929\/\u622a\u5c4f2025-07-28 09.00.49.png","orig_name":"\u622a\u5c4f2025-07-28 09.00.49.png"}}]},{"id":2380,"key":2380,"contract_id":4072,"amount":"1.00","value":"1.00","attachment_id":"","from_date":"2025-08-04","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[]},{"id":2381,"key":2381,"contract_id":4072,"amount":"-61409.86","value":"-61409.86","attachment_id":"","from_date":"","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[{"id":2103,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:30:10","description":"\u5403","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:03:30","updated_at":"2025-08-04 11:30:10","supplier_id":431,"purchase_contract_id":4072,"amount":"4000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"5068","erp_payment_un_settle_amount":"-1068","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"},{"id":2105,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:34:31","description":"\u6d4b\u8bd5","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:32:56","updated_at":"2025-08-04 11:34:31","supplier_id":431,"purchase_contract_id":4072,"amount":"2222","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"2222","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"},{"id":2106,"client_id":"","project_id":"","title":"v\u4eba\u7684","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:45:49","description":"v\u7684\u98ce\u683c","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:45:46","updated_at":"2025-08-04 11:45:49","supplier_id":431,"purchase_contract_id":4072,"amount":"1","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"1","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"},{"id":2107,"client_id":"","project_id":"","title":"\u975e\u5730\u65b9","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:48:47","description":"f\u5f85\u53d1","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:48:44","updated_at":"2025-08-04 11:48:47","supplier_id":431,"purchase_contract_id":4072,"amount":"1","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"1","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":1,"purchase_contract_id":4072,"erp_store_id":"","erp_purchase_order_product_id":"","product_id":2067,"description":"","number":"1","amount":"53400","total_amount":"53400","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":""}],"erpPurchaseOrder":"","invoiced":4,"approve_amount":6224,"un_approve_amount":47176,"un_invoiced":53396,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"7292","un_collected":46108,"collected_plan":0,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":53400,"product_number":1,"is_done":false},{"id":4070,"supplier_id":138,"contract_type":1,"signed_at":"2025-07-25","amount":"18000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 17:04:56","updated_at":"2025-07-28 10:08:54","client_id":"","project_id":"","sales_rep":"","serial_no":"H202507255159","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 17:05:06","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"18000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4070,"comment":3},"purchaseClientRels":[{"id":3622,"contract_id":4070,"client_id":2136,"project_id":3922,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","sales_rep":5087},"project":{"id":3922,"key":3922,"name":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":36062,"object_type":108,"object_id":4070,"attachment_id":27107,"attachment":{"id":27107,"key":27107,"name":"89946cfa-ebc3-33b5-a6ef-db1f1967a247","extension":"pdf","path":"\/vue\/attachment\/preview\/89946cfa-ebc3-33b5-a6ef-db1f1967a247\/(H202507255159-001)\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240.pdf","orig_name":"(H202507255159-001)\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1364,"user_id":1011,"key":1011,"contract_id":4070,"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":1365,"user_id":5360,"key":5360,"contract_id":4070,"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":807,"key":807,"contract_id":4070,"name":"2025-07-28","value":"18000","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f8\u5929"}],"paymentApproves":[{"id":2101,"client_id":2136,"project_id":3922,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-28 11:40:00","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u8bbe\u5907AC-1000-B1100-4D\u91c7\u8d2d\u6b3e\u7528\u4e8e\u8ba2\u8d27\uff0c\u91d1\u989d\uff1a\uffe518000\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-07-28 10:36:44","updated_at":"2025-07-28 11:40:00","supplier_id":138,"purchase_contract_id":4070,"amount":"18000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":18000,"un_approve_amount":0,"un_invoiced":18000,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":18000,"collected_plan":18000,"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":4069,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-25","amount":"130.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 16:45:53","updated_at":"2025-07-25 16:46:01","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4651203278745161702\t","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 16:46:01","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"130","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"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":4069,"comment":1},"purchaseClientRels":[{"id":3633,"contract_id":4069,"client_id":12,"project_id":3930,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3930,"key":3930,"name":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2377,"key":2377,"contract_id":4069,"amount":"130","value":"130","attachment_id":"","from_date":"2025-07-28","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":36095,"object_type":103,"object_id":2377,"attachment_id":27129,"attachment":{"id":27129,"key":27129,"name":"6954d457-1be4-3ae8-9044-9df87e4fb5c7","extension":"pdf","path":"\/vue\/attachment\/view\/6954d457-1be4-3ae8-9044-9df87e4fb5c7\/dzfp_25124000000001390299_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250728165907.pdf","orig_name":"dzfp_25124000000001390299_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250728165907.pdf"}}]}],"contractScans":[{"id":36055,"object_type":108,"object_id":4069,"attachment_id":27102,"attachment":{"id":27102,"key":27102,"name":"f31d5e66-a200-3574-8d75-c75ab3188e53","extension":"png","path":"\/vue\/attachment\/preview\/f31d5e66-a200-3574-8d75-c75ab3188e53\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1362,"user_id":1011,"key":1011,"contract_id":4069,"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":1363,"user_id":5360,"key":5360,"contract_id":4069,"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":806,"key":806,"contract_id":4069,"name":"2025-07-31","value":"130","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f5\u5929"}],"paymentApproves":[{"id":2097,"client_id":12,"project_id":3930,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-28 17:55:50","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u56fa\u6001\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5130\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-07-28 17:55:34","updated_at":"2025-07-28 17:55:50","supplier_id":608,"purchase_contract_id":4069,"amount":"130","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":130,"approve_amount":130,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":130,"collected_plan":130,"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":4067,"supplier_id":262,"contract_type":1,"signed_at":"2025-07-24","amount":"397.01","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-24 14:55:07","updated_at":"2025-07-24 14:55:19","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a327559652672","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-24 14:55:19","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"397.01","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4067,"comment":3},"purchaseClientRels":[{"id":3616,"contract_id":4067,"client_id":1492,"project_id":3810,"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":3810,"key":3810,"name":"NETAPP\u5b58\u50a8\u7eed\u4fdd\u670d\u52a1-2025\u5e74","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2374,"key":2374,"contract_id":4067,"amount":"397.01","value":"397.01","attachment_id":"","from_date":"2025-07-23","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":36033,"object_type":103,"object_id":2374,"attachment_id":27083,"attachment":{"id":27083,"key":27083,"name":"2feed15b-c073-3b8c-bf15-220ff392985c","extension":"pdf","path":"\/vue\/attachment\/view\/2feed15b-c073-3b8c-bf15-220ff392985c\/digital_25447000000804086634.pdf","orig_name":"digital_25447000000804086634.pdf"}}]}],"contractScans":[{"id":36031,"object_type":108,"object_id":4067,"attachment_id":27082,"attachment":{"id":27082,"key":27082,"name":"e7ac774d-a1e2-3308-a402-ad67c554d3c5","extension":"jpg","path":"\/vue\/attachment\/preview\/e7ac774d-a1e2-3308-a402-ad67c554d3c5\/64021753340004_.pic.jpg","orig_name":"64021753340004_.pic.jpg"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1360,"user_id":1011,"key":1011,"contract_id":4067,"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":1361,"user_id":5360,"key":5360,"contract_id":4067,"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":805,"key":805,"contract_id":4067,"name":"2025-07-25","value":"397.01","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f11\u5929"}],"paymentApproves":[{"id":2093,"client_id":1492,"project_id":3810,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-24 15:40:33","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u8d1d\u745e\u6536\u8d27\u7ef4\u4fdd\u5185\u9700\u6c42\u4e00\u4e2a40G\u6a21\u5757\uff0c\u91c7\u8d2d\u91d1\u989d\uff1a\uffe5397.01\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-24 15:38:07","updated_at":"2025-07-24 15:40:33","supplier_id":262,"purchase_contract_id":4067,"amount":"397.01","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":397.01,"approve_amount":397.01,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":397.01,"collected_plan":397.01,"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":4066,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-24","amount":"520.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-24 13:51:17","updated_at":"2025-07-24 13:51:34","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4649415087350592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-24 13:51:34","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4066,"comment":1},"purchaseClientRels":[{"id":3623,"contract_id":4066,"client_id":12,"project_id":3929,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3929,"key":3929,"name":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","project_status":3}},{"id":3624,"contract_id":4066,"client_id":12,"project_id":3928,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3928,"key":3928,"name":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2376,"key":2376,"contract_id":4066,"amount":"520","value":"520","attachment_id":"","from_date":"2025-07-25","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":36046,"object_type":103,"object_id":2376,"attachment_id":27095,"attachment":{"id":27095,"key":27095,"name":"1cac0db2-1a48-3d1e-8527-efe25c5d455a","extension":"pdf","path":"\/vue\/attachment\/view\/1cac0db2-1a48-3d1e-8527-efe25c5d455a\/dzfp_25124000000001378160_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250725134445.pdf","orig_name":"dzfp_25124000000001378160_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250725134445.pdf"}}]}],"contractScans":[{"id":36030,"object_type":108,"object_id":4066,"attachment_id":27081,"attachment":{"id":27081,"key":27081,"name":"aa07ef1f-42b3-38d5-9c4e-c04d8767e3a4","extension":"png","path":"\/vue\/attachment\/preview\/aa07ef1f-42b3-38d5-9c4e-c04d8767e3a4\/WX20250724-135105@2x.png","orig_name":"WX20250724-135105@2x.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1358,"user_id":1011,"key":1011,"contract_id":4066,"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":1359,"user_id":5360,"key":5360,"contract_id":4066,"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":804,"key":804,"contract_id":4066,"name":"2025-08-08","value":"520","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[{"id":2094,"client_id":12,"project_id":3929,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-28 09:43:41","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u20144\u5757\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d520\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-25 13:49:16","updated_at":"2025-07-28 09:43:41","supplier_id":608,"purchase_contract_id":4066,"amount":"520","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":520,"approve_amount":520,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":520,"collected_plan":520,"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":4063,"supplier_id":236,"contract_type":3,"signed_at":"2025-07-23","amount":"3000.00","handler":1011,"description":"PA\u914d\u7f6e\u7ffb\u8bd1\uff1b\n\u66ff\u6362\u8bbe\u5907\u5b9e\u65bd\uff08\u5468\u672b\uff09","contract_scan":"","created_by":1011,"created_at":"2025-07-23 14:42:05","updated_at":"2025-07-23 14:42:15","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 14:42:15","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"3000","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":4063,"comment":3},"purchaseClientRels":[{"id":3645,"contract_id":4063,"client_id":3343,"project_id":3841,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","sales_rep":1004},"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1354,"user_id":1011,"key":1011,"contract_id":4063,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1355,"user_id":5360,"key":5360,"contract_id":4063,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":802,"key":802,"contract_id":4063,"name":"2025-07-28","value":"3000","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f8\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":3000,"un_invoiced":3000,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"0","un_collected":3000,"collected_plan":3000,"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":4062,"supplier_id":262,"contract_type":1,"signed_at":"2025-07-22","amount":"2000.00","handler":1011,"description":"\u5151\u4ed8\u79ef\u5206\u8f6c\u793c\u54c1\u5361\u91c7\u8d2d\u5408\u540c","contract_scan":"","created_by":1011,"created_at":"2025-07-23 10:52:39","updated_at":"2025-07-23 10:52:50","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 327609705325","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 10:52:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4062,"comment":3},"purchaseClientRels":[{"id":3612,"contract_id":4062,"client_id":2177,"project_id":3865,"client":{"id":2177,"key":2177,"name":"\u4e2d\u79cd\u56fd\u9645\u79cd\u5b50\u6709\u9650\u516c\u53f8","sales_rep":5295},"project":{"id":3865,"key":3865,"name":"2025\u5353\u8c6a\u8fd0\u7ef4\u8f6f\u4ef6\u65b0\u8d2d\u548c\u7eed\u4fdd","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2373,"key":2373,"contract_id":4062,"amount":"2000","value":"2000","attachment_id":"","from_date":"2025-07-23","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35984,"object_type":103,"object_id":2373,"attachment_id":27039,"attachment":{"id":27039,"key":27039,"name":"89eebafd-e35b-35e8-9f09-2af61a820b74","extension":"pdf","path":"\/vue\/attachment\/view\/89eebafd-e35b-35e8-9f09-2af61a820b74\/2000.pdf","orig_name":"2000.pdf"}}]}],"contractScans":[{"id":35973,"object_type":108,"object_id":4062,"attachment_id":27033,"attachment":{"id":27033,"key":27033,"name":"ee5f9c66-c714-32e0-a56e-6f3fb6dd580e","extension":"png","path":"\/vue\/attachment\/preview\/ee5f9c66-c714-32e0-a56e-6f3fb6dd580e\/image.png","orig_name":"image.png"}}],"receiptScans":[{"id":35974,"object_type":111,"object_id":4062,"attachment_id":27034,"attachment":{"id":27034,"key":27034,"name":"728ece4d-9a8a-33e1-8469-b6ef72d29ef5","extension":"png","path":"\/vue\/attachment\/preview\/728ece4d-9a8a-33e1-8469-b6ef72d29ef5\/image.png","orig_name":"image.png"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1352,"user_id":1011,"key":1011,"contract_id":4062,"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":1353,"user_id":5360,"key":5360,"contract_id":4062,"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":801,"key":801,"contract_id":4062,"name":"2025-07-25","value":"2000","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f11\u5929"}],"paymentApproves":[{"id":2086,"client_id":2177,"project_id":3865,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-23 10:55:24","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u4eac\u4e1c\u5361\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe52000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-23 10:53:57","updated_at":"2025-07-23 10:55:24","supplier_id":262,"purchase_contract_id":4062,"amount":"2000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":2000,"approve_amount":2000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":2000,"collected_plan":2000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false},{"id":4060,"supplier_id":505,"contract_type":1,"signed_at":"2025-07-21","amount":"49848.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-22 09:19:29","updated_at":"2025-07-22 09:19:50","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-ZHF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 09:19:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"49848","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4060,"comment":1},"purchaseClientRels":[{"id":3631,"contract_id":4060,"client_id":2182,"project_id":3919,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3919,"key":3919,"name":"\u8054\u60f3\u7b14\u8bb0\u672c\u7535\u8111-K-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":35944,"object_type":108,"object_id":4060,"attachment_id":27007,"attachment":{"id":27007,"key":27007,"name":"5e06b3f2-7656-39e1-9362-3449b947ad8e","extension":"pdf","path":"\/vue\/attachment\/preview\/5e06b3f2-7656-39e1-9362-3449b947ad8e\/\u62d3\u5b9e-\u7b14\u8bb0\u672c\u5408\u540c49848\u5143-20250721.pdf","orig_name":"\u62d3\u5b9e-\u7b14\u8bb0\u672c\u5408\u540c49848\u5143-20250721.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1344,"user_id":1011,"key":1011,"contract_id":4060,"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":1345,"user_id":5360,"key":5360,"contract_id":4060,"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":797,"key":797,"contract_id":4060,"name":"2025-08-22","value":"49848","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":49848,"un_invoiced":49848,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":49848,"collected_plan":49848,"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":4059,"supplier_id":236,"contract_type":1,"signed_at":"2025-07-21","amount":"47000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 17:15:57","updated_at":"2025-07-21 17:16:08","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-ZHF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 17:16:08","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"47000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4059,"comment":2},"purchaseClientRels":[{"id":3646,"contract_id":4059,"client_id":1301,"project_id":3835,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295},"project":{"id":3835,"key":3835,"name":"2025\u6df1\u4fe1\u670d\u8bbe\u5907\u7eed\u4fdd","project_status":3}}],"purchaseContractPayments":[{"id":"1454","key":"1454","contract_id":4059,"value":"47000","collected_date":"2025-07-21 17:51:38","created_at":"2025-07-21 17:51:38","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[],"contractScans":[{"id":35935,"object_type":108,"object_id":4059,"attachment_id":27001,"attachment":{"id":27001,"key":27001,"name":"fc0ffc49-dcf5-3178-a8e3-24bfd3414c81","extension":"pdf","path":"\/vue\/attachment\/preview\/fc0ffc49-dcf5-3178-a8e3-24bfd3414c81\/\u62d3\u5b9e-\u591a\u7ef4\u8054\u5408\u7ef4\u4fdd\u5408\u540c20250721 (1).pdf","orig_name":"\u62d3\u5b9e-\u591a\u7ef4\u8054\u5408\u7ef4\u4fdd\u5408\u540c20250721 (1).pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1342,"user_id":1011,"key":1011,"contract_id":4059,"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":1343,"user_id":5360,"key":5360,"contract_id":4059,"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":796,"key":796,"contract_id":4059,"name":"2025-07-22","value":"47000","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2080,"client_id":1301,"project_id":3835,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-21 17:35:36","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u591a\u7ef4\u8054\u5408\u2014\u6df1\u4fe1\u670d\u8bbe\u5907\u7eed\u4fdd\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d47000\u5143\uff0c\u7533\u8bf7\u73b0\u7ed3\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-07-21 17:17:43","updated_at":"2025-07-21 17:35:36","supplier_id":236,"purchase_contract_id":4059,"amount":"47000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"47000","erp_payment_un_settle_amount":"-47000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":47000,"un_approve_amount":0,"un_invoiced":47000,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"47000","un_collected":0,"collected_plan":47000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true},{"id":4058,"supplier_id":478,"contract_type":1,"signed_at":"2025-07-21","amount":"250.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 16:32:24","updated_at":"2025-07-22 10:53:23","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-003","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 10:53:23","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"250","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":4058,"comment":1},"purchaseClientRels":[{"id":3625,"contract_id":4058,"client_id":3383,"project_id":3926,"client":{"id":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09","sales_rep":5295},"project":{"id":3926,"key":3926,"name":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1348,"user_id":1011,"key":1011,"contract_id":4058,"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":1349,"user_id":5360,"key":5360,"contract_id":4058,"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":799,"key":799,"contract_id":4058,"name":"2025-08-21","value":"250","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":250,"un_invoiced":250,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":250,"collected_plan":250,"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":4057,"supplier_id":626,"contract_type":1,"signed_at":"2025-07-21","amount":"520.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 16:31:30","updated_at":"2025-07-22 13:26:17","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 13:26:17","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\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":4057,"comment":1},"purchaseClientRels":[{"id":3626,"contract_id":4057,"client_id":3383,"project_id":3926,"client":{"id":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09","sales_rep":5295},"project":{"id":3926,"key":3926,"name":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1350,"user_id":1011,"key":1011,"contract_id":4057,"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":1351,"user_id":5360,"key":5360,"contract_id":4057,"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":800,"key":800,"contract_id":4057,"name":"2025-08-21","value":"520","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":520,"un_invoiced":520,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":520,"collected_plan":520,"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":4053,"supplier_id":280,"contract_type":1,"signed_at":"2025-07-21","amount":"8000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 13:22:15","updated_at":"2025-07-21 13:22:30","client_id":"","project_id":"","sales_rep":"","serial_no":"A20250721","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 13:22:30","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"8000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4053,"comment":1},"purchaseClientRels":[{"id":3643,"contract_id":4053,"client_id":2182,"project_id":3882,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3882,"key":3882,"name":"\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-K-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":35924,"object_type":108,"object_id":4053,"attachment_id":26986,"attachment":{"id":26986,"key":26986,"name":"bc2edcc6-c036-3a8d-9fbd-dc7cbcf93c11","extension":"pdf","path":"\/vue\/attachment\/preview\/bc2edcc6-c036-3a8d-9fbd-dc7cbcf93c11\/\u62d3\u5b9e-\u6210\u6d77\u661f\u6cb3\u5408\u540c8000\u5143.pdf","orig_name":"\u62d3\u5b9e-\u6210\u6d77\u661f\u6cb3\u5408\u540c8000\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1332,"user_id":1011,"key":1011,"contract_id":4053,"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":1333,"user_id":5360,"key":5360,"contract_id":4053,"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":791,"key":791,"contract_id":4053,"name":"2025-08-21","value":"8000","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":0,"un_approve_amount":8000,"un_invoiced":8000,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":8000,"collected_plan":8000,"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":4052,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-21","amount":"658.63","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 11:21:01","updated_at":"2025-07-21 11:21:21","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 11:21:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"658.63","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4052,"comment":1},"purchaseClientRels":[{"id":3627,"contract_id":4052,"client_id":12,"project_id":3925,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","project_status":3}},{"id":3642,"contract_id":4052,"client_id":12,"project_id":3924,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2372,"key":2372,"contract_id":4052,"amount":"260","value":"260","attachment_id":"","from_date":"2025-07-23","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35977,"object_type":103,"object_id":2372,"attachment_id":27036,"attachment":{"id":27036,"key":27036,"name":"08f251c0-fa8e-30f1-a53b-9b03b261603a","extension":"pdf","path":"\/vue\/attachment\/view\/08f251c0-fa8e-30f1-a53b-9b03b261603a\/dzfp_25124000000001306529_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250723110049.pdf","orig_name":"dzfp_25124000000001306529_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250723110049.pdf"}}]}],"contractScans":[{"id":35915,"object_type":108,"object_id":4052,"attachment_id":26979,"attachment":{"id":26979,"key":26979,"name":"a2620c57-4a20-3365-936d-f9e5f981929d","extension":"png","path":"\/vue\/attachment\/preview\/a2620c57-4a20-3365-936d-f9e5f981929d\/WX20250721-112032@2x.png","orig_name":"WX20250721-112032@2x.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1330,"user_id":1011,"key":1011,"contract_id":4052,"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":1331,"user_id":5360,"key":5360,"contract_id":4052,"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":790,"key":790,"contract_id":4052,"name":"2025-07-31","value":"658.63","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f5\u5929"}],"paymentApproves":[{"id":2088,"client_id":12,"project_id":3924,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-25 11:32:13","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u786c\u76d8\u3001\u5185\u5b58\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d658.63\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-23 11:06:21","updated_at":"2025-07-25 11:32:13","supplier_id":608,"purchase_contract_id":4052,"amount":"658.63","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":260,"approve_amount":658.63,"un_approve_amount":0,"un_invoiced":398.63,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":658.63,"collected_plan":658.63,"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":4051,"supplier_id":138,"contract_type":3,"signed_at":"2025-07-21","amount":"900.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 11:18:14","updated_at":"2025-07-25 09:02:47","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 11:18:58","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4051,"comment":3},"purchaseClientRels":[{"id":3574,"contract_id":4051,"client_id":2094,"project_id":3704,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","project_status":3}}],"purchaseContractPayments":[{"id":"1455","key":"1455","contract_id":4051,"value":"900","collected_date":"2025-07-22 14:55:21","created_at":"2025-07-22 14:55:21","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2375,"key":2375,"contract_id":4051,"amount":"900","value":"900","attachment_id":"","from_date":"2025-07-24","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":36041,"object_type":103,"object_id":2375,"attachment_id":27091,"attachment":{"id":27091,"key":27091,"name":"c28e6341-aa60-3de5-b71b-e307da93978b","extension":"pdf","path":"\/vue\/attachment\/view\/c28e6341-aa60-3de5-b71b-e307da93978b\/202507225114_25952000000150599805.pdf","orig_name":"202507225114_25952000000150599805.pdf"}}]}],"contractScans":[{"id":36039,"object_type":108,"object_id":4051,"attachment_id":27090,"attachment":{"id":27090,"key":27090,"name":"aa11d1c4-bcb6-3be1-8d5c-23a2f43f8889","extension":"pdf","path":"\/vue\/attachment\/preview\/aa11d1c4-bcb6-3be1-8d5c-23a2f43f8889\/20250718_\u8bbe\u5907\u635f\u8017\u8d54\u507f\u534f\u8bae.pdf","orig_name":"20250718_\u8bbe\u5907\u635f\u8017\u8d54\u507f\u534f\u8bae.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1326,"user_id":1011,"key":1011,"contract_id":4051,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1327,"user_id":5360,"key":5360,"contract_id":4051,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":788,"key":788,"contract_id":4051,"name":"2025-07-21","value":"900","overdue_days":1,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2074,"client_id":2094,"project_id":3704,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-21 11:28:51","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d 3\u4e2a\u6d4b\u8bd5Ukey\u635f\u8017\u8d39\uff0c\u91d1\u989d\uffe5900\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u9ad8\u65b0\u56ed\u79d1\u521b\u652f\u884c\n\u5e10\u6237\u540d\u79f0\uff1a\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u5e10\u53f7\uff1a811980479210001\n\n\u5907\u6ce8\uff1a\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-21 11:28:35","updated_at":"2025-07-21 11:28:51","supplier_id":138,"purchase_contract_id":4051,"amount":"900","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"900","erp_payment_un_settle_amount":"-900","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":900,"approve_amount":900,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"900","un_collected":0,"collected_plan":900,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true},{"id":4045,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-17","amount":"197.75","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-17 13:18:04","updated_at":"2025-07-17 13:18:21","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-17 13:18:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"197.75","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4045,"comment":3},"purchaseClientRels":[{"id":3634,"contract_id":4045,"client_id":12,"project_id":3920,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":35816,"object_type":108,"object_id":4045,"attachment_id":26885,"attachment":{"id":26885,"key":26885,"name":"fd06f90c-5930-38de-b848-eda7ea416352","extension":"png","path":"\/vue\/attachment\/preview\/fd06f90c-5930-38de-b848-eda7ea416352\/WX20250717-131714@2x.png","orig_name":"WX20250717-131714@2x.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1322,"user_id":1011,"key":1011,"contract_id":4045,"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":1323,"user_id":5360,"key":5360,"contract_id":4045,"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":786,"key":786,"contract_id":4045,"name":"2025-07-25","value":"197.75","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f11\u5929"}],"paymentApproves":[{"id":2087,"client_id":12,"project_id":3920,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-23 12:23:59","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u5185\u5b58\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d197.75\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-23 11:04:56","updated_at":"2025-07-23 12:23:59","supplier_id":608,"purchase_contract_id":4045,"amount":"197.75","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":0,"approve_amount":197.75,"un_approve_amount":0,"un_invoiced":197.75,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":197.75,"collected_plan":197.75,"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":4040,"supplier_id":715,"contract_type":1,"signed_at":"2025-07-16","amount":"9000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-16 10:18:43","updated_at":"2025-07-16 10:18:50","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250716-HYF-002","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-16 10:18:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"9000","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":715,"key":715,"name":"\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\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":4040,"comment":2},"purchaseClientRels":[],"purchaseContractPayments":[{"id":"1446","key":"1446","contract_id":4040,"value":"9000","collected_date":"2025-07-16 11:27:26","created_at":"2025-07-16 11:27:26","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2360,"key":2360,"contract_id":4040,"amount":"9000","value":"9000","attachment_id":"","from_date":"2025-07-15","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35791,"object_type":103,"object_id":2360,"attachment_id":26863,"attachment":{"id":26863,"key":26863,"name":"de6211aa-f0f3-32b1-8e2d-3dc2318456af","extension":"pdf","path":"\/vue\/attachment\/view\/de6211aa-f0f3-32b1-8e2d-3dc2318456af\/dzfp_25112000000147428991_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250715181252(1).pdf","orig_name":"dzfp_25112000000147428991_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250715181252(1).pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1314,"user_id":1011,"key":1011,"contract_id":4040,"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":1315,"user_id":5360,"key":5360,"contract_id":4040,"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":782,"key":782,"contract_id":4040,"name":"2025-07-16","value":"9000","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2052,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-16 10:28:10","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u9152\u6c34\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe59000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u540d\u79f0\uff1a\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u6c5f\u82cf\u94f6\u884c\u5317\u4eac\u5e7f\u6e20\u95e8\u652f\u884c\n\u5e10\u53f7\uff1a32400188000008023\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-16 10:23:10","updated_at":"2025-07-16 10:28:10","supplier_id":715,"purchase_contract_id":4040,"amount":"9000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"9000","erp_payment_un_settle_amount":"-9000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":9000,"approve_amount":9000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"9000","un_collected":0,"collected_plan":9000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true},{"id":4038,"supplier_id":236,"contract_type":1,"signed_at":"2025-07-16","amount":"145000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-16 09:19:18","updated_at":"2025-07-21 10:18:26","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250716-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-16 09:19:30","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"145000","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":4038,"comment":2},"purchaseClientRels":[{"id":3644,"contract_id":4038,"client_id":3343,"project_id":3841,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","sales_rep":1004},"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362","project_status":3}}],"purchaseContractPayments":[{"id":"1445","key":"1445","contract_id":4038,"value":"145000","collected_date":"2025-07-16 10:36:14","created_at":"2025-07-16 10:36:14","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2368,"key":2368,"contract_id":4038,"amount":"145000","value":"145000","attachment_id":"","from_date":"2025-07-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35938,"object_type":103,"object_id":2368,"attachment_id":27003,"attachment":{"id":27003,"key":27003,"name":"ef7869a6-e47c-3cf1-95fd-b920e7e091e5","extension":"pdf","path":"\/vue\/attachment\/view\/ef7869a6-e47c-3cf1-95fd-b920e7e091e5\/dzfp_25112000000151444555_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250721155737.pdf","orig_name":"dzfp_25112000000151444555_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250721155737.pdf"}}]}],"contractScans":[{"id":35785,"object_type":108,"object_id":4038,"attachment_id":26860,"attachment":{"id":26860,"key":26860,"name":"7a51b94b-f950-38e5-9a56-2944ec9a2d29","extension":"pdf","path":"\/vue\/attachment\/preview\/7a51b94b-f950-38e5-9a56-2944ec9a2d29\/\u4e2d\u90fd-\u5408\u540c (1).pdf","orig_name":"\u4e2d\u90fd-\u5408\u540c (1).pdf"}}],"receiptScans":[{"id":35859,"object_type":111,"object_id":4038,"attachment_id":26926,"attachment":{"id":26926,"key":26926,"name":"fff0e954-f563-3d62-9a8e-326abcc7b5cd","extension":"pdf","path":"\/vue\/attachment\/preview\/fff0e954-f563-3d62-9a8e-326abcc7b5cd\/MNGpEq6SVqTp_OUT_FILE_shouhuo_after.PDF","orig_name":"MNGpEq6SVqTp_OUT_FILE_shouhuo_after.PDF"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1310,"user_id":1011,"key":1011,"contract_id":4038,"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":1311,"user_id":5360,"key":5360,"contract_id":4038,"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":780,"key":780,"contract_id":4038,"name":"2025-07-16","value":"145000","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2051,"client_id":3343,"project_id":3841,"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-07-16 09:36:59","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u8bbe\u5907\u91c7\u8d2d\u6b3e\uffe5145000\u5143\uff0c\u548c\u5929\u4fe1\u5b8f\u8fbe\u8d26\u4e0a\u4f59\u989d\uffe578025\uff0c\u9700\u8865\u5dee\u989d\uff1a\uffe566975\u5143\uff0c\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-07-16 09:32:49","updated_at":"2025-07-16 09:36:59","supplier_id":236,"purchase_contract_id":4038,"amount":"66975","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"66975","erp_payment_un_settle_amount":"-66975","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":145000,"approve_amount":66975,"un_approve_amount":78025,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"145000","un_collected":0,"collected_plan":145000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true},{"id":4037,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-15","amount":"260.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-15 15:57:37","updated_at":"2025-07-15 15:57:47","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4632992211529592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-15 15:57:47","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"260","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":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":4037,"comment":2},"purchaseClientRels":[{"id":3569,"contract_id":4037,"client_id":12,"project_id":3918,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3918,"key":3918,"name":"POTJ25074907-\u56fa\u6001\u786c\u76d8-2025","project_status":3}}],"purchaseContractPayments":[{"id":"1447","key":"1447","contract_id":4037,"value":"260","collected_date":"2025-07-18 12:25:56","created_at":"2025-07-18 12:25:56","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2363,"key":2363,"contract_id":4037,"amount":"260","value":"260","attachment_id":"","from_date":"2025-07-17","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35821,"object_type":103,"object_id":2363,"attachment_id":26892,"attachment":{"id":26892,"key":26892,"name":"d0797a4d-df43-374d-a694-13e7b97f63c0","extension":"pdf","path":"\/vue\/attachment\/view\/d0797a4d-df43-374d-a694-13e7b97f63c0\/dzfp_25124000000001342354_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250717143802.pdf","orig_name":"dzfp_25124000000001342354_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250717143802.pdf"}}]}],"contractScans":[{"id":35770,"object_type":108,"object_id":4037,"attachment_id":26850,"attachment":{"id":26850,"key":26850,"name":"ca8eae39-ce9e-37fe-acff-393009fb991a","extension":"png","path":"\/vue\/attachment\/preview\/ca8eae39-ce9e-37fe-acff-393009fb991a\/WX20250715-155701@2x.png","orig_name":"WX20250715-155701@2x.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1308,"user_id":1011,"key":1011,"contract_id":4037,"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":1309,"user_id":5360,"key":5360,"contract_id":4037,"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":779,"key":779,"contract_id":4037,"name":"2025-07-25","value":"260","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2059,"client_id":12,"project_id":3918,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-17 09:53:40","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8SMC\u2014\u786c\u76d8\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d260\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:49:10","updated_at":"2025-07-17 09:53:40","supplier_id":608,"purchase_contract_id":4037,"amount":"260","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"260","erp_payment_un_settle_amount":"-260","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":260,"approve_amount":260,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"260","un_collected":0,"collected_plan":260,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true},{"id":4034,"supplier_id":712,"contract_type":1,"signed_at":"2025-07-15","amount":"15000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-15 11:34:17","updated_at":"2025-07-18 09:51:14","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250715-HYF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-15 11:34:42","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7500","erp_un_settle_amount":"7500","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":712,"key":712,"name":"\u5317\u4eac\u793a\u76ee\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":4034,"comment":2},"purchaseClientRels":[{"id":3637,"contract_id":4034,"client_id":2526,"project_id":3911,"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5087},"project":{"id":3911,"key":3911,"name":"\u8d22\u52a1\u7528\u9632\u706b\u5899","project_status":3}}],"purchaseContractPayments":[{"id":"1444","key":"1444","contract_id":4034,"value":"7500","collected_date":"2025-07-15 17:19:41","created_at":"2025-07-15 17:19:41","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":50}],"purchaseContractInvoices":[{"id":2357,"key":2357,"contract_id":4034,"amount":"7500","value":"7500","attachment_id":"","from_date":"2025-07-15","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":35765,"object_type":103,"object_id":2357,"attachment_id":26845,"attachment":{"id":26845,"key":26845,"name":"6ccc2930-db11-31d6-84c7-ed3857397d16","extension":"pdf","path":"\/vue\/attachment\/view\/6ccc2930-db11-31d6-84c7-ed3857397d16\/dzfp_25112000000147114651_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250715141103.pdf","orig_name":"dzfp_25112000000147114651_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250715141103.pdf"}}]}],"contractScans":[{"id":35761,"object_type":108,"object_id":4034,"attachment_id":26843,"attachment":{"id":26843,"key":26843,"name":"2dad1c15-8723-31a1-ba52-e5496b36821d","extension":"pdf","path":"\/vue\/attachment\/preview\/2dad1c15-8723-31a1-ba52-e5496b36821d\/20250715\u5408\u540c.pdf","orig_name":"20250715\u5408\u540c.pdf"}}],"receiptScans":[{"id":35829,"object_type":111,"object_id":4034,"attachment_id":26899,"attachment":{"id":26899,"key":26899,"name":"6a373c9f-a7f0-33dc-82e9-c50b245f9a6d","extension":"pdf","path":"\/vue\/attachment\/preview\/6a373c9f-a7f0-33dc-82e9-c50b245f9a6d\/2025_07_18_09_51_03.pdf","orig_name":"2025_07_18_09_51_03.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1304,"user_id":1011,"key":1011,"contract_id":4034,"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":1305,"user_id":5360,"key":5360,"contract_id":4034,"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":776,"key":776,"contract_id":4034,"name":"2025-07-16","value":"7500","overdue_days":"","status":1,"pct":50,"collect_status":"\u5df2\u5b8c\u6210"},{"id":777,"key":777,"contract_id":4034,"name":"2025-08-16","value":"7500","overdue_days":"","status":0,"pct":50,"collect_status":""}],"paymentApproves":[{"id":2048,"client_id":2526,"project_id":3911,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u793a\u76ee\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-15 17:12:12","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5929\u878d\u4fe1\u4e0a\u7f51\u884c\u4e3a\u8bbe\u5907\u7684\u9884\u4ed8\u6b3e\uff0c\u91d1\u989d\uff1a\uffe57500\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5317\u4eac\u793a\u76ee\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u897f\u4e09\u73af\u652f\u884c\n110957447210001\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-07-15 14:22:48","updated_at":"2025-07-15 17:12:12","supplier_id":712,"purchase_contract_id":4034,"amount":"7500","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"7500","erp_payment_un_settle_amount":"-7500","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":"","invoiced":7500,"approve_amount":7500,"un_approve_amount":7500,"un_invoiced":7500,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"7500","un_collected":7500,"collected_plan":15000,"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}],"count":{"total":"224240165.64","collected":"218637620.69","un_collected":5602544.95,"invoiced":"220271626.61","un_invoiced":3758316.19},"can_create":true,"pagenation":{"totalcount":2006,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-05 14:42:46') RETURNING "id" |