69438fa296f09: POST https://beta.jinchangxiao.com/vue/analysis/suppliers-purchase-contracts at 2025-12-18 01:22:42 pm by 223.72.15.22
Database Queries
总计26条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 13:22:42.623 | 3.1 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 13:22:42.627 | 2.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:22:42.633 | 10.5 ms | SELECT | SELECT "s".*, sum(pc.total_amount) as total_amount, sum(pc.collected) as collected, sum(pc.total_amount) - sum(pc.collected) as un_collected, sum(pc.invoiced) as invoiced, sum(pc.total_amount) - sum(pc.invoiced) as un_invoiced, sum(pcr.clients) as clients, sum(pcr2.projects) as projects FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN (SELECT pc.supplier_id, sum(pc.amount) as total_amount, sum(case when pcp.collected is not null then pcp.collected else 0 end) as collected, sum(case when pci.invoiced is not null then pci.invoiced else 0 end) as invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "pc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "pcp" ON pcp.contract_id = pc.id LEFT JOIN (SELECT "contract_id", sum(amount) as invoiced FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE (red_invoice_id is not null) OR ("is_cancel"=FALSE) GROUP BY "contract_id") "pci" ON pci.contract_id = pc.id GROUP BY "pc"."supplier_id") "pc" ON pc.supplier_id = s.id LEFT JOIN (SELECT "pc"."supplier_id", count(DISTINCT pcr.client_id) as clients FROM "a57be577deb434"."tbl_purchase_client_rels" "pcr" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pcr.contract_id = pc.id GROUP BY "pc"."supplier_id") "pcr" ON pcr.supplier_id = s.id LEFT JOIN (SELECT "pc"."supplier_id", count(DISTINCT pcr.project_id) as projects FROM "a57be577deb434"."tbl_purchase_client_rels" "pcr" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pcr.contract_id = pc.id GROUP BY "pc"."supplier_id") "pcr2" ON pcr2.supplier_id = s.id WHERE "s"."id"='46' GROUP BY "s"."id" |
| 13:22:42.644 | 7.1 ms | SELECT | SELECT COUNT(*) FROM (SELECT c.*, case when pcp.collected is not null then pcp.collected else 0 end as collected, case when pci.invoiced is not null then pci.invoiced else 0 end as invoiced, case when pcp.collected is not null then c.amount - pcp.collected else c.amount end as un_collected, case when pci.invoiced is not null then c.amount - pci.invoiced else c.amount end as un_invoiced 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 (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "pcp" ON pcp.contract_id = c.id LEFT JOIN (SELECT "contract_id", sum(amount) as invoiced FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE (red_invoice_id is not null) OR ("is_cancel"=FALSE) GROUP BY "contract_id") "pci" ON pci.contract_id = c.id WHERE "supplier"."id"='46' GROUP BY "c"."id", "pcp"."collected", "pci"."invoiced" ORDER BY amount DESC NULLS LAST) "c" |
| 13:22:42.652 | 7.7 ms | SELECT | SELECT c.*, case when pcp.collected is not null then pcp.collected else 0 end as collected, case when pci.invoiced is not null then pci.invoiced else 0 end as invoiced, case when pcp.collected is not null then c.amount - pcp.collected else c.amount end as un_collected, case when pci.invoiced is not null then c.amount - pci.invoiced else c.amount end as un_invoiced 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 (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "pcp" ON pcp.contract_id = c.id LEFT JOIN (SELECT "contract_id", sum(amount) as invoiced FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE (red_invoice_id is not null) OR ("is_cancel"=FALSE) GROUP BY "contract_id") "pci" ON pci.contract_id = c.id WHERE "supplier"."id"='46' GROUP BY "c"."id", "pcp"."collected", "pci"."invoiced" ORDER BY amount DESC NULLS LAST LIMIT 20 |
| 13:22:42.661 | 0.7 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=46 |
| 13:22:42.662 | 12.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (3606, 9565, 1715, 1267, 7594, 2749, 534, 364, 3023, 3286, 4353, 6696, 979, 6582, 1808) |
| 13:22:42.675 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5298, 5023, 5015) |
| 13:22:42.676 | 1.0 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5023, 1011, 5015, 5298)) |
| 13:22:42.677 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 9) |
| 13:22:42.678 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 13:22:42.678 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011) |
| 13:22:42.679 | 1.1 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (5, 876, 989, 2181, 287, 426, 2029, 39, 1111) |
| 13:22:42.680 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5311, 5300, 5295) |
| 13:22:42.681 | 2.7 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1077, 931, 730, 2434, 1001, 331, 269, 1571, 2076, 367, 2055, 898) |
| 13:22:42.684 | 6.5 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value" 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))) 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) ) 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"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) 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) )) "sub") "r" WHERE "contract_id" IN (1182, 2204, 755, 3640, 2218, 517, 1985, 2605, 2834, 1016, 247, 191, 1063, 1122, 1331, 1838, 432, 2383, 1825, 692) ORDER BY "id" DESC |
| 13:22:42.691 | 1.0 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (1182, 2204, 755, 3640, 2218, 517, 1985, 2605, 2834, 1016, 247, 191, 1063, 1122, 1331, 1838, 432, 2383, 1825, 692) ORDER BY "id" |
| 13:22:42.692 | 1.7 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5064, 7132, 7595) |
| 13:22:42.694 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (1182, 2204, 755, 3640, 2218, 517, 1985, 2605, 2834, 1016, 247, 191, 1063, 1122, 1331, 1838, 432, 2383, 1825, 692) ORDER BY "id" |
| 13:22:42.695 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (426, 2181, 2029, 5, 287, 989, 876, 1111, 39, 21, 2520, 2589) |
| 13:22:42.696 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (269, 2434, 331, 2076, 1571, 1001, 1077, 2055, 931, 898, 730, 367, 2730, 2849, 3157, 3309, 3694) |
| 13:22:42.696 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (1182, 2204, 755, 3640, 2218, 517, 1985, 2605, 2834, 1016, 247, 191, 1063, 1122, 1331, 1838, 432, 2383, 1825, 692)) |
| 13:22:42.699 | 3.6 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (364, 7594, 1267, 534, 6696, 4353, 1715, 2749, 3286, 3023, 3606, 6582, 1808, 979, 9668, 10844, 11083, 12523, 14808, 22353) |
| 13:22:42.706 | 3.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-18') |
| 13:22:42.710 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=59, "last_visit_at"='now()' WHERE "id"=59594 |
| 13:22:42.711 | 2.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/suppliers-purchase-contracts', '{"id":"46","page":"1"}', '{"code":2000,"result":{"list":[{"id":1182,"supplier_id":46,"contract_type":1,"signed_at":"2019-05-22","amount":"3252061","handler":1011,"description":"\u601d\u79d1\u8bbe\u5907","contract_scan":3606,"created_by":1011,"created_at":"2019-09-24 11:05:17","updated_at":"2020-05-27 11:44:39","client_id":5,"project_id":1077,"sales_rep":"","serial_no":"TSKJ-20190522-HYF-004","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"3252061","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3252061","collected":"3252061","invoiced":"3252061.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":3606,"key":3606,"name":"b6f8e254-ac3c-3444-80b9-eb28b2bfc2ac","extension":"pdf","path":"\/vue\/attachment\/preview\/b6f8e254-ac3c-3444-80b9-eb28b2bfc2ac\/2019_09_24_11_03_03.pdf","orig_name":"2019_09_24_11_03_03.pdf"},"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"}},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee"},"purchaseContractPayments":[{"id":"11023","key":"11023","contract_id":1182,"value":"3252061.00"}],"purchaseContractInvoices":[{"id":540,"key":540,"contract_id":1182,"value":"3252061.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":414,"contract_id":1182,"client_id":5,"project_id":1077,"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee"}}],"contractScans":[{"id":14080,"object_type":108,"object_id":1182,"attachment_id":3606,"attachment":{"id":3606,"key":3606,"name":"b6f8e254-ac3c-3444-80b9-eb28b2bfc2ac","extension":"pdf","path":"\/vue\/attachment\/preview\/b6f8e254-ac3c-3444-80b9-eb28b2bfc2ac\/2019_09_24_11_03_03.pdf","orig_name":"2019_09_24_11_03_03.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":2204,"supplier_id":46,"contract_type":1,"signed_at":"2022-02-14","amount":"2486400.00","handler":1011,"description":"\u5408\u540c\u5df2\u7ecf\u7ec8\u6b62\uff01\u7b7e\u7f72\u7ec8\u6b62\u534f\u8bae\uff01","contract_scan":9565,"created_by":5298,"created_at":"2022-02-14 15:38:39","updated_at":"2024-05-28 09:15:12","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ20220211158613","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":true,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","collected":"0","invoiced":"0","un_collected":"2486400.00","un_invoiced":"2486400.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9565,"key":9565,"name":"0f7d17a7-c0f5-3b14-84bd-0c8af75c6fd1","extension":"pdf","path":"\/vue\/attachment\/preview\/0f7d17a7-c0f5-3b14-84bd-0c8af75c6fd1\/DZ20220211158613.pdf","orig_name":"DZ20220211158613.pdf"},"createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3,"avatar":{"id":140,"user_id":5298,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3cd222c9-8884-3376-9440-91cc91755fcb.jpg"},"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"}},"client":{},"project":{},"purchaseContractPayments":[],"purchaseContractInvoices":[],"purchaseClientRels":[{"id":1120,"contract_id":2204,"client_id":21,"project_id":"","client":{"id":21,"key":21,"name":"\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u6709\u9650\u516c\u53f8(\u9f99\u82af\u4e2d\u79d1\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\u3001\u9f99\u82af\u4e2d\u79d1\u5357\u4eac\u6280\u672f\u6709\u9650\u516c\u53f8)\uff08EDA\uff09","sales_rep":5295},"project":{}}],"contractScans":[{"id":16162,"object_type":108,"object_id":2204,"attachment_id":11083,"attachment":{"id":11083,"key":11083,"name":"a482efcb-63bf-35a4-bf7e-5e2583546680","extension":"pdf","path":"\/vue\/attachment\/preview\/a482efcb-63bf-35a4-bf7e-5e2583546680\/preview\u526f\u672c.pdf","orig_name":"preview\u526f\u672c.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":755,"supplier_id":46,"contract_type":1,"signed_at":"2018-09-29","amount":"2474849.4","handler":1011,"description":"\u4eca\u65e5\u5934\u6761-\u8fc7\u5355","contract_scan":1715,"created_by":5023,"created_at":"2018-10-17 16:53:28","updated_at":"2021-11-09 16:00:54","client_id":876,"project_id":931,"sales_rep":"","serial_no":"zhanglhd180928","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2474849.4","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2474849.4","collected":"2474849.4","invoiced":"2474849.40","un_collected":"0.0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1715,"key":1715,"name":"02eb7083-00a2-3b9a-bc8e-e42ec871bfac","extension":"pdf","path":"\/vue\/attachment\/preview\/02eb7083-00a2-3b9a-bc8e-e42ec871bfac\/2018_10_17_16_23_13.pdf","orig_name":"2018_10_17_16_23_13.pdf"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.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"}},"client":{"id":876,"key":876,"name":"\u5317\u4eac\u6709\u7af9\u5c45\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8(\u4eca\u65e5\u5934\u6761)","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":931,"key":931,"name":"NGFW\u91c7\u8d2d\u9879\u76ee"},"purchaseContractPayments":[{"id":"11098","key":"11098","contract_id":755,"value":"2474849.40"}],"purchaseContractInvoices":[{"id":381,"key":381,"contract_id":755,"value":"2474849.40","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":894,"contract_id":755,"client_id":876,"project_id":931,"client":{"id":876,"key":876,"name":"\u5317\u4eac\u6709\u7af9\u5c45\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8(\u4eca\u65e5\u5934\u6761)","sales_rep":5311},"project":{"id":931,"key":931,"name":"NGFW\u91c7\u8d2d\u9879\u76ee"}}],"contractScans":[{"id":13909,"object_type":108,"object_id":755,"attachment_id":1715,"attachment":{"id":1715,"key":1715,"name":"02eb7083-00a2-3b9a-bc8e-e42ec871bfac","extension":"pdf","path":"\/vue\/attachment\/preview\/02eb7083-00a2-3b9a-bc8e-e42ec871bfac\/2018_10_17_16_23_13.pdf","orig_name":"2018_10_17_16_23_13.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":3640,"supplier_id":46,"contract_type":1,"signed_at":"2024-10-30","amount":"1868000.00","handler":1011,"description":"\u5317\u5954\u7684\u9879\u76ee\uff0c\u5e94\u8be5\u7b7e\u7684\u5408\u540c\u91d1\u989d\u662f\uff1a\uffe52,496,572.00\uff0c\u5e2e\u5fd9\u62b5\u6263628572\uff0c\u5b9e\u9645\u7b7e\u7ea6\u5408\u540c\u91d1\u989d\u662f\uff1a1868000","contract_scan":"","created_by":1011,"created_at":"2024-10-30 14:18:46","updated_at":"2025-01-21 09:47:24","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ202410291132612","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-30 14:19:18","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1868000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1868000","collected":"1868000","invoiced":"1868000","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"client":{},"project":{},"purchaseContractPayments":[{"id":"1290","key":"1290","contract_id":3640,"value":"1868000.00"}],"purchaseContractInvoices":[{"id":2114,"key":2114,"contract_id":3640,"value":"1868000","attachment_id":"","from_date":"2025-01-21","attachment":{}}],"purchaseClientRels":[{"id":2898,"contract_id":3640,"client_id":287,"project_id":3694,"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","sales_rep":5300},"project":{"id":3694,"key":3694,"name":"PA\u9632\u706b\u5899\u65b0\u8d2d-2024-C"}}],"contractScans":[{"id":29831,"object_type":108,"object_id":3640,"attachment_id":22353,"attachment":{"id":22353,"key":22353,"name":"09d2b486-7851-3d1a-bd06-1c624e6feb79","extension":"pdf","path":"\/vue\/attachment\/preview\/09d2b486-7851-3d1a-bd06-1c624e6feb79\/DZ202410291132612.pdf","orig_name":"DZ202410291132612.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":2218,"supplier_id":46,"contract_type":3,"signed_at":"2022-02-28","amount":"1602976.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2022-02-28 16:42:01","updated_at":"2022-02-28 16:53:23","client_id":"","project_id":"","sales_rep":"","serial_no":"202202281646037115808","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1602976","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1602976","collected":"1602976","invoiced":"1602976.00","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"client":{},"project":{},"purchaseContractPayments":[{"id":"11371","key":"11371","contract_id":2218,"value":"1602976.00"}],"purchaseContractInvoices":[{"id":1118,"key":1118,"contract_id":2218,"value":"1602976.00","attachment_id":"","from_date":"2022-03-15","attachment":{}}],"purchaseClientRels":[{"id":974,"contract_id":2218,"client_id":287,"project_id":2730,"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","sales_rep":5300},"project":{"id":2730,"key":2730,"name":"PA\u9632\u706b\u5899\u7eed\u4fdd\/1-3\u5e74"}}],"contractScans":[{"id":14566,"object_type":108,"object_id":2218,"attachment_id":9668,"attachment":{"id":9668,"key":9668,"name":"c04cb5bc-a604-385c-8885-21f3a4cb4f57","extension":"pdf","path":"\/vue\/attachment\/preview\/c04cb5bc-a604-385c-8885-21f3a4cb4f57\/202202281646037115808.pdf","orig_name":"202202281646037115808.pdf"}}],"contract_type_display":"\u670d\u52a1\u5408\u540c"},{"id":517,"supplier_id":46,"contract_type":1,"signed_at":"2018-05-17","amount":"1500168.56","handler":1011,"description":"PA5250\u4ea7\u54c1\uff1b\u4eac\u4e1c\u9879\u76ee\u4ea7\u54c1\u3002","contract_scan":1267,"created_by":5023,"created_at":"2018-05-25 16:34:57","updated_at":"2021-11-09 16:03:39","client_id":989,"project_id":730,"sales_rep":"","serial_no":"DZ2018051016549","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1500168.56","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1500168.56","collected":"1500168.56","invoiced":"1500168.56","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1267,"key":1267,"name":"4b06af77-40a7-3a5c-b892-2c27d22bd0ca","extension":"pdf","path":"\/vue\/attachment\/preview\/4b06af77-40a7-3a5c-b892-2c27d22bd0ca\/DZ2018051016549.pdf","orig_name":"DZ2018051016549.pdf"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.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"}},"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":730,"key":730,"name":"2018-Palo Alto PA-5250\u5e94\u7528\u4e0e\u5a01\u80c1\u68c0\u6d4b\u4e0e\u9632\u5fa1\u8f6f\u4ef6\u91c7\u8d2d\u9879\u76ee"},"purchaseContractPayments":[{"id":"11163","key":"11163","contract_id":517,"value":"1500168.56"}],"purchaseContractInvoices":[{"id":254,"key":254,"contract_id":517,"value":"1500168.56","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":901,"contract_id":517,"client_id":989,"project_id":730,"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","sales_rep":5311},"project":{"id":730,"key":730,"name":"2018-Palo Alto PA-5250\u5e94\u7528\u4e0e\u5a01\u80c1\u68c0\u6d4b\u4e0e\u9632\u5fa1\u8f6f\u4ef6\u91c7\u8d2d\u9879\u76ee"}}],"contractScans":[{"id":13714,"object_type":108,"object_id":517,"attachment_id":1267,"attachment":{"id":1267,"key":1267,"name":"4b06af77-40a7-3a5c-b892-2c27d22bd0ca","extension":"pdf","path":"\/vue\/attachment\/preview\/4b06af77-40a7-3a5c-b892-2c27d22bd0ca\/DZ2018051016549.pdf","orig_name":"DZ2018051016549.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":1985,"supplier_id":46,"contract_type":1,"signed_at":"2021-04-15","amount":"1363000","handler":1011,"description":"","contract_scan":7594,"created_by":1011,"created_at":"2021-05-28 16:35:06","updated_at":"2021-05-28 16:35:06","client_id":2181,"project_id":2434,"sales_rep":"","serial_no":"DCXZ202104151","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1363000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1363000","collected":"1363000","invoiced":"1363000.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":7594,"key":7594,"name":"00eb698e-9bb5-38d7-be5e-f168eb168975","extension":"pdf","path":"\/vue\/attachment\/preview\/00eb698e-9bb5-38d7-be5e-f168eb168975\/2021_05_28_16_31_10.pdf","orig_name":"2021_05_28_16_31_10.pdf"},"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"}},"client":{"id":2181,"key":2181,"name":"\u798f\u5efa\u548c\u745e\u57fa\u56e0\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":"","salesRep":{}},"project":{"id":2434,"key":2434,"name":"\u798f\u5efa\u548c\u745e\u5b58\u50a8\u65b0\u8d2d"},"purchaseContractPayments":[{"id":"11923","key":"11923","contract_id":1985,"value":"1363000.00"}],"purchaseContractInvoices":[{"id":977,"key":977,"contract_id":1985,"value":"1363000.00","attachment_id":7595,"from_date":"2021-05-21","attachment":{"id":7595,"key":7595,"name":"13e26bb3-77ff-324c-a61e-9925e50dcb7d","extension":"pdf","path":"\/vue\/attachment\/preview\/13e26bb3-77ff-324c-a61e-9925e50dcb7d\/2021_05_28_13_50_25.pdf","orig_name":"2021_05_28_13_50_25.pdf"}}],"purchaseClientRels":[{"id":36,"contract_id":1985,"client_id":2181,"project_id":2434,"client":{"id":2181,"key":2181,"name":"\u798f\u5efa\u548c\u745e\u57fa\u56e0\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":""},"project":{"id":2434,"key":2434,"name":"\u798f\u5efa\u548c\u745e\u5b58\u50a8\u65b0\u8d2d"}}],"contractScans":[{"id":13681,"object_type":108,"object_id":1985,"attachment_id":7594,"attachment":{"id":7594,"key":7594,"name":"00eb698e-9bb5-38d7-be5e-f168eb168975","extension":"pdf","path":"\/vue\/attachment\/preview\/00eb698e-9bb5-38d7-be5e-f168eb168975\/2021_05_28_16_31_10.pdf","orig_name":"2021_05_28_16_31_10.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":2605,"supplier_id":46,"contract_type":1,"signed_at":"2023-03-22","amount":"1301500.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2023-03-22 11:44:10","updated_at":"2023-03-22 11:44:10","client_id":"","project_id":"","sales_rep":"","serial_no":"SM-ZRX-20230321DMZR","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1301500","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1301500","collected":"1301500","invoiced":"1301500.00","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"client":{},"project":{},"purchaseContractPayments":[{"id":"1594","key":"1594","contract_id":2605,"value":"1301500.00"}],"purchaseContractInvoices":[{"id":1312,"key":1312,"contract_id":2605,"value":"1301500.00","attachment_id":"","from_date":"2023-03-27","attachment":{}}],"purchaseClientRels":[{"id":1300,"contract_id":2605,"client_id":2520,"project_id":3157,"client":{"id":2520,"key":2520,"name":"\u5317\u4eac\u5168\u65b0\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3157,"key":3157,"name":"\u5927\u9ea6\u79d1\u6280-\u8d85\u878d\u5408\u9879\u76ee"}}],"contractScans":[{"id":17829,"object_type":108,"object_id":2605,"attachment_id":12523,"attachment":{"id":12523,"key":12523,"name":"b8da8b8b-db10-36fc-ab5b-e26ad0917859","extension":"pdf","path":"\/vue\/attachment\/preview\/b8da8b8b-db10-36fc-ab5b-e26ad0917859\/2023_03_22_11_23_28.pdf","orig_name":"2023_03_22_11_23_28.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":2834,"supplier_id":46,"contract_type":1,"signed_at":"2023-09-07","amount":"1264282.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2023-09-07 10:33:28","updated_at":"2023-09-08 09:33:05","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ20230906372660","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1264282","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1264282","collected":"1264282","invoiced":"1264282.00","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"client":{},"project":{},"purchaseContractPayments":[{"id":"12008","key":"12008","contract_id":2834,"value":"1264282.00"}],"purchaseContractInvoices":[{"id":1441,"key":1441,"contract_id":2834,"value":"1264282.00","attachment_id":"","from_date":"2023-09-25","attachment":{}}],"purchaseClientRels":[{"id":1510,"contract_id":2834,"client_id":2589,"project_id":3309,"client":{"id":2589,"key":2589,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":3309,"key":3309,"name":"PAXDR-3500\u70b9\u65b0\u8d2d-2023\uff08\u8fc7\u5355\uff09"}}],"contractScans":[{"id":20340,"object_type":108,"object_id":2834,"attachment_id":14808,"attachment":{"id":14808,"key":14808,"name":"90dafca6-f5c7-3620-acec-8ffcf88aea3f","extension":"pdf","path":"\/vue\/attachment\/preview\/90dafca6-f5c7-3620-acec-8ffcf88aea3f\/DZ20230906372660.pdf","orig_name":"DZ20230906372660.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":1016,"supplier_id":46,"contract_type":1,"signed_at":"2019-03-27","amount":"1224176","handler":1011,"description":"2\u53f0PA3220\u548c2\u53f0PA5220","contract_scan":2749,"created_by":1011,"created_at":"2019-04-15 15:19:08","updated_at":"2020-05-27 11:41:56","client_id":287,"project_id":1001,"sales_rep":"","serial_no":"TS20190327-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1224176","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"1224176","collected":"1224176","invoiced":"1224176.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":2749,"key":2749,"name":"f608117d-9b40-361a-bd49-1a33a7042626","extension":"pdf","path":"\/vue\/attachment\/preview\/f608117d-9b40-361a-bd49-1a33a7042626\/2019_04_15_13_28_28.pdf","orig_name":"2019_04_15_13_28_28.pdf"},"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"}},"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"project":{"id":1001,"key":1001,"name":"PA\u9632\u706b\u5899"},"purchaseContractPayments":[{"id":"11483","key":"11483","contract_id":1016,"value":"1224176.00"}],"purchaseContractInvoices":[{"id":518,"key":518,"contract_id":1016,"value":"1224176.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":397,"contract_id":1016,"client_id":287,"project_id":1001,"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09","sales_rep":5300},"project":{"id":1001,"key":1001,"name":"PA\u9632\u706b\u5899"}}],"contractScans":[{"id":14057,"object_type":108,"object_id":1016,"attachment_id":2749,"attachment":{"id":2749,"key":2749,"name":"f608117d-9b40-361a-bd49-1a33a7042626","extension":"pdf","path":"\/vue\/attachment\/preview\/f608117d-9b40-361a-bd49-1a33a7042626\/2019_04_15_13_28_28.pdf","orig_name":"2019_04_15_13_28_28.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":247,"supplier_id":46,"contract_type":1,"signed_at":"2017-08-23","amount":"968490","handler":1011,"description":"\u5b89\u5168","contract_scan":534,"created_by":5015,"created_at":"2017-09-08 12:04:29","updated_at":"2020-05-27 09:50:50","client_id":426,"project_id":331,"sales_rep":"","serial_no":"-","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"968490","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"968490","collected":"968490","invoiced":"968490.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":534,"key":534,"name":"81e28e44-efdf-3348-82e4-5e48a47a5ca0","extension":"pdf","path":"\/vue\/attachment\/preview\/81e28e44-efdf-3348-82e4-5e48a47a5ca0\/\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170823\u2014968490.pdf","orig_name":"\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170823\u2014968490.pdf"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\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"}},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":331,"key":331,"name":"\u529e\u516c\u5b89\u5168"},"purchaseContractPayments":[{"id":"11017","key":"11017","contract_id":247,"value":"968490.00"}],"purchaseContractInvoices":[{"id":143,"key":143,"contract_id":247,"value":"968490.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":72,"contract_id":247,"client_id":426,"project_id":331,"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":5311},"project":{"id":331,"key":331,"name":"\u529e\u516c\u5b89\u5168"}}],"contractScans":[{"id":13723,"object_type":108,"object_id":247,"attachment_id":534,"attachment":{"id":534,"key":534,"name":"81e28e44-efdf-3348-82e4-5e48a47a5ca0","extension":"pdf","path":"\/vue\/attachment\/preview\/81e28e44-efdf-3348-82e4-5e48a47a5ca0\/\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170823\u2014968490.pdf","orig_name":"\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170823\u2014968490.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":191,"supplier_id":46,"contract_type":1,"signed_at":"2017-07-14","amount":"968490","handler":1011,"description":"\u5b89\u5168","contract_scan":364,"created_by":5015,"created_at":"2017-07-20 11:57:10","updated_at":"2020-05-27 09:36:07","client_id":426,"project_id":269,"sales_rep":"","serial_no":"-","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"968490","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"968490","collected":"968490","invoiced":"968490.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":364,"key":364,"name":"1d4e8408-0380-351d-a557-d1cd9f1e1c7d","extension":"pdf","path":"\/vue\/attachment\/preview\/1d4e8408-0380-351d-a557-d1cd9f1e1c7d\/\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170714\u2014968490.pdf","orig_name":"\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170714\u2014968490.pdf"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\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"}},"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":269,"key":269,"name":"\u5ba2\u670d\u5b89\u5168\u9632\u706b\u5899\u9879\u76ee"},"purchaseContractPayments":[{"id":"11650","key":"11650","contract_id":191,"value":"968490.00"}],"purchaseContractInvoices":[{"id":90,"key":90,"contract_id":191,"value":"968490.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":35,"contract_id":191,"client_id":426,"project_id":269,"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":5311},"project":{"id":269,"key":269,"name":"\u5ba2\u670d\u5b89\u5168\u9632\u706b\u5899\u9879\u76ee"}}],"contractScans":[{"id":13679,"object_type":108,"object_id":191,"attachment_id":364,"attachment":{"id":364,"key":364,"name":"1d4e8408-0380-351d-a557-d1cd9f1e1c7d","extension":"pdf","path":"\/vue\/attachment\/preview\/1d4e8408-0380-351d-a557-d1cd9f1e1c7d\/\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170714\u2014968490.pdf","orig_name":"\u795e\u5dde\u6570\u7801\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170714\u2014968490.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":1063,"supplier_id":46,"contract_type":1,"signed_at":"2019-06-05","amount":"806700","handler":1011,"description":"6C VSphere\uff1b12C SRM","contract_scan":3023,"created_by":1011,"created_at":"2019-06-05 17:15:03","updated_at":"2020-05-27 11:43:47","client_id":5,"project_id":1077,"sales_rep":"","serial_no":"DZ20190604121394","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"806700","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"806700","collected":"806700","invoiced":"806700.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":3023,"key":3023,"name":"3ae07836-55b2-3253-91d0-c78be55eecf5","extension":"pdf","path":"\/vue\/attachment\/preview\/3ae07836-55b2-3253-91d0-c78be55eecf5\/DZ20190604121394.pdf","orig_name":"DZ20190604121394.pdf"},"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"}},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee"},"purchaseContractPayments":[{"id":"1937","key":"1937","contract_id":1063,"value":"806700.00"}],"purchaseContractInvoices":[{"id":533,"key":533,"contract_id":1063,"value":"806700.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":412,"contract_id":1063,"client_id":5,"project_id":1077,"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee"}}],"contractScans":[{"id":14077,"object_type":108,"object_id":1063,"attachment_id":3023,"attachment":{"id":3023,"key":3023,"name":"3ae07836-55b2-3253-91d0-c78be55eecf5","extension":"pdf","path":"\/vue\/attachment\/preview\/3ae07836-55b2-3253-91d0-c78be55eecf5\/DZ20190604121394.pdf","orig_name":"DZ20190604121394.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":1122,"supplier_id":46,"contract_type":1,"signed_at":"2019-07-25","amount":"731104","handler":1011,"description":"VMware Sphere \u4f01\u4e1a\u589e\u5f3a\u7248\u672c*44C","contract_scan":3286,"created_by":1011,"created_at":"2019-07-25 11:08:00","updated_at":"2020-05-27 11:45:49","client_id":5,"project_id":1077,"sales_rep":"","serial_no":"DZ20190723123635","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"731104","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"731104","collected":"731104","invoiced":"731104.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":3286,"key":3286,"name":"c077b95a-894b-3ca3-9f20-260968833426","extension":"pdf","path":"\/vue\/attachment\/preview\/c077b95a-894b-3ca3-9f20-260968833426\/DZ20190723123635.pdf","orig_name":"DZ20190723123635.pdf"},"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"}},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee"},"purchaseContractPayments":[{"id":"11694","key":"11694","contract_id":1122,"value":"731104.00"}],"purchaseContractInvoices":[{"id":546,"key":546,"contract_id":1122,"value":"731104.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":403,"contract_id":1122,"client_id":5,"project_id":1077,"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee"}}],"contractScans":[{"id":14064,"object_type":108,"object_id":1122,"attachment_id":3286,"attachment":{"id":3286,"key":3286,"name":"c077b95a-894b-3ca3-9f20-260968833426","extension":"pdf","path":"\/vue\/attachment\/preview\/c077b95a-894b-3ca3-9f20-260968833426\/DZ20190723123635.pdf","orig_name":"DZ20190723123635.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":1331,"supplier_id":46,"contract_type":1,"signed_at":"2020-02-25","amount":"719030","handler":1011,"description":"Vmware\u5408\u540c","contract_scan":4353,"created_by":1011,"created_at":"2020-02-25 10:36:37","updated_at":"2020-06-19 14:56:51","client_id":5,"project_id":1571,"sales_rep":"","serial_no":"DZ2020022033625","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"719030","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"719030","collected":"719030","invoiced":"719030.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":4353,"key":4353,"name":"23d202a6-9e3a-36e5-87cf-7334aafab579","extension":"pdf","path":"\/vue\/attachment\/preview\/23d202a6-9e3a-36e5-87cf-7334aafab579\/DZ2020022033625.pdf","orig_name":"DZ2020022033625.pdf"},"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"}},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"project":{"id":1571,"key":1571,"name":"\u8ba1\u7b97\u5b58\u50a8\u6269\u5bb9"},"purchaseContractPayments":[{"id":"1482","key":"1482","contract_id":1331,"value":"719030.00"}],"purchaseContractInvoices":[{"id":117,"key":117,"contract_id":1331,"value":"719030.00","attachment_id":5064,"from_date":"2020-03-10","attachment":{"id":5064,"key":5064,"name":"1055f1d8-613c-38d8-ab04-4c87726bef03","extension":"pdf","path":"\/vue\/attachment\/preview\/1055f1d8-613c-38d8-ab04-4c87726bef03\/\u795e\u5dde\u6570\u7801-719030.pdf","orig_name":"\u795e\u5dde\u6570\u7801-719030.pdf"}}],"purchaseClientRels":[{"id":229,"contract_id":1331,"client_id":5,"project_id":1571,"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":1571,"key":1571,"name":"\u8ba1\u7b97\u5b58\u50a8\u6269\u5bb9"}}],"contractScans":[{"id":13885,"object_type":108,"object_id":1331,"attachment_id":4353,"attachment":{"id":4353,"key":4353,"name":"23d202a6-9e3a-36e5-87cf-7334aafab579","extension":"pdf","path":"\/vue\/attachment\/preview\/23d202a6-9e3a-36e5-87cf-7334aafab579\/DZ2020022033625.pdf","orig_name":"DZ2020022033625.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":1838,"supplier_id":46,"contract_type":1,"signed_at":"2020-03-25","amount":"606000","handler":1011,"description":"","contract_scan":6696,"created_by":1011,"created_at":"2021-01-15 10:02:51","updated_at":"2021-01-15 10:02:51","client_id":2029,"project_id":2076,"sales_rep":"","serial_no":"TSKJ20200324-GYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"606000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"606000","collected":"606000","invoiced":"606000.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":6696,"key":6696,"name":"616a06d7-bd15-3176-a424-ed80cbbe8da5","extension":"pdf","path":"\/vue\/attachment\/preview\/616a06d7-bd15-3176-a424-ed80cbbe8da5\/2021_01_15_09_59_51.pdf","orig_name":"2021_01_15_09_59_51.pdf"},"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"}},"client":{"id":2029,"key":2029,"name":"\u5317\u4eac\u7965\u4e91\u5929\u5730\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":"","salesRep":{}},"project":{"id":2076,"key":2076,"name":"\u957f\u57ce\u6c7d\u8f66\u706b\u773c\u9879\u76ee"},"purchaseContractPayments":[{"id":"11168","key":"11168","contract_id":1838,"value":"606000.00"}],"purchaseContractInvoices":[{"id":879,"key":879,"contract_id":1838,"value":"606000.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":227,"contract_id":1838,"client_id":2029,"project_id":2076,"client":{"id":2029,"key":2029,"name":"\u5317\u4eac\u7965\u4e91\u5929\u5730\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":""},"project":{"id":2076,"key":2076,"name":"\u957f\u57ce\u6c7d\u8f66\u706b\u773c\u9879\u76ee"}}],"contractScans":[{"id":13883,"object_type":108,"object_id":1838,"attachment_id":6696,"attachment":{"id":6696,"key":6696,"name":"616a06d7-bd15-3176-a424-ed80cbbe8da5","extension":"pdf","path":"\/vue\/attachment\/preview\/616a06d7-bd15-3176-a424-ed80cbbe8da5\/2021_01_15_09_59_51.pdf","orig_name":"2021_01_15_09_59_51.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":432,"supplier_id":46,"contract_type":3,"signed_at":"2018-01-24","amount":"579626","handler":1011,"description":"\u7cfb\u7edf\u8f6f\u4ef6","contract_scan":979,"created_by":5023,"created_at":"2018-01-24 10:29:01","updated_at":"2021-11-09 16:04:49","client_id":39,"project_id":367,"sales_rep":"","serial_no":"DZ2018012312994","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"579626","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"579626","collected":"579626","invoiced":"579626.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":979,"key":979,"name":"f72ab059-ce9d-36d9-a0fe-c8c5022ac605","extension":"pdf","path":"\/vue\/attachment\/preview\/f72ab059-ce9d-36d9-a0fe-c8c5022ac605\/\u795e\u5dde\u6570\u7801_\u4e2d\u4ea4\u8def\u6865_\u62d3\u5b9e\u5fae\u8f6f\u5408\u540c.pdf","orig_name":"\u795e\u5dde\u6570\u7801_\u4e2d\u4ea4\u8def\u6865_\u62d3\u5b9e\u5fae\u8f6f\u5408\u540c.pdf"},"createdBy":{"id":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","department_id":3,"avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.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"}},"client":{"id":39,"key":39,"name":"(\u7cfb\u7edf\u96c6\u6210\u5546)\u5317\u4eac\u745e\u62d3\u7535\u5b50\u6280\u672f\u53d1\u5c55\u6709\u9650\u516c\u53f8(\u4e2d\u4ea4\u8def\u6865\u5efa\u8bbe\u6709\u9650\u516c\u53f8)","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":367,"key":367,"name":"\u76ca\u9a6c\u9ad8\u901f\u516c\u8def\u5de5\u4f5c\u7ad9\u670d\u52a1\u5668"},"purchaseContractPayments":[{"id":"11976","key":"11976","contract_id":432,"value":"579626.00"}],"purchaseContractInvoices":[{"id":215,"key":215,"contract_id":432,"value":"579626.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":904,"contract_id":432,"client_id":39,"project_id":367,"client":{"id":39,"key":39,"name":"(\u7cfb\u7edf\u96c6\u6210\u5546)\u5317\u4eac\u745e\u62d3\u7535\u5b50\u6280\u672f\u53d1\u5c55\u6709\u9650\u516c\u53f8(\u4e2d\u4ea4\u8def\u6865\u5efa\u8bbe\u6709\u9650\u516c\u53f8)","sales_rep":5311},"project":{"id":367,"key":367,"name":"\u76ca\u9a6c\u9ad8\u901f\u516c\u8def\u5de5\u4f5c\u7ad9\u670d\u52a1\u5668"}}],"contractScans":[{"id":14529,"object_type":108,"object_id":432,"attachment_id":979,"attachment":{"id":979,"key":979,"name":"f72ab059-ce9d-36d9-a0fe-c8c5022ac605","extension":"pdf","path":"\/vue\/attachment\/preview\/f72ab059-ce9d-36d9-a0fe-c8c5022ac605\/\u795e\u5dde\u6570\u7801_\u4e2d\u4ea4\u8def\u6865_\u62d3\u5b9e\u5fae\u8f6f\u5408\u540c.pdf","orig_name":"\u795e\u5dde\u6570\u7801_\u4e2d\u4ea4\u8def\u6865_\u62d3\u5b9e\u5fae\u8f6f\u5408\u540c.pdf"}}],"contract_type_display":"\u670d\u52a1\u5408\u540c"},{"id":2383,"supplier_id":46,"contract_type":3,"signed_at":"2022-08-19","amount":"550000.00","handler":1011,"description":"","contract_scan":"","created_by":5298,"created_at":"2022-08-22 12:47:10","updated_at":"2022-09-09 15:00:28","client_id":"","project_id":"","sales_rep":"","serial_no":"DCLIANGXYF20220819-1","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"550000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"550000","collected":"550000","invoiced":"550000.00","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":"","createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3,"avatar":{"id":140,"user_id":5298,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3cd222c9-8884-3376-9440-91cc91755fcb.jpg"},"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"}},"client":{},"project":{},"purchaseContractPayments":[{"id":"11834","key":"11834","contract_id":2383,"value":"550000.00"}],"purchaseContractInvoices":[{"id":1204,"key":1204,"contract_id":2383,"value":"550000.00","attachment_id":"","from_date":"2022-09-19","attachment":{}}],"purchaseClientRels":[{"id":1102,"contract_id":2383,"client_id":5,"project_id":2849,"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":2849,"key":2849,"name":"\u601d\u79d1\u53caNetapp\u7eed\u4fdd\u9879\u76ee"}}],"contractScans":[{"id":16006,"object_type":108,"object_id":2383,"attachment_id":10844,"attachment":{"id":10844,"key":10844,"name":"3faa1758-89f1-3404-9595-848c2306b4ca","extension":"pdf","path":"\/vue\/attachment\/preview\/3faa1758-89f1-3404-9595-848c2306b4ca\/202208221661143209211.pdf","orig_name":"202208221661143209211.pdf"}}],"contract_type_display":"\u670d\u52a1\u5408\u540c"},{"id":1825,"supplier_id":46,"contract_type":1,"signed_at":"2020-12-30","amount":"538955.00","handler":1011,"description":"2021\u5e745\u670816\u65e5\u5ef6\u652f","contract_scan":6582,"created_by":1011,"created_at":"2020-12-30 09:18:56","updated_at":"2021-03-26 11:10:12","client_id":989,"project_id":2055,"sales_rep":"","serial_no":"DZ20201225314060","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"538955","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"538955","collected":"538955","invoiced":"538955.00","un_collected":"0.00","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":6582,"key":6582,"name":"e342085f-f2c3-3d32-93d2-9886b2e9c3e5","extension":"pdf","path":"\/vue\/attachment\/preview\/e342085f-f2c3-3d32-93d2-9886b2e9c3e5\/DZ20201225314060.pdf","orig_name":"DZ20201225314060.pdf"},"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"}},"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"}},"project":{"id":2055,"key":2055,"name":"\u4eac\u4e1c2020-CCO\u4f53\u7cfb\u4fe1\u606f\u5b89\u5168\u90e8-\u5bb9\u5668\u91c7\u8d2d\u9879\u76ee"},"purchaseContractPayments":[{"id":"11066","key":"11066","contract_id":1825,"value":"538955.00"}],"purchaseContractInvoices":[{"id":912,"key":912,"contract_id":1825,"value":"538955.00","attachment_id":7132,"from_date":"2021-03-25","attachment":{"id":7132,"key":7132,"name":"9f9e5edd-8d95-3037-b44a-4b2fcb2898ab","extension":"pdf","path":"\/vue\/attachment\/preview\/9f9e5edd-8d95-3037-b44a-4b2fcb2898ab\/\u795e\u7801.pdf","orig_name":"\u795e\u7801.pdf"}}],"purchaseClientRels":[{"id":597,"contract_id":1825,"client_id":989,"project_id":2055,"client":{"id":989,"key":989,"name":"\u5317\u4eac\u4eac\u4e1c\u5c1a\u79d1\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8[\u5317\u4eac\u6c83\u4e1c\u5929\u9a8f\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8]","sales_rep":5311},"project":{"id":2055,"key":2055,"name":"\u4eac\u4e1c2020-CCO\u4f53\u7cfb\u4fe1\u606f\u5b89\u5168\u90e8-\u5bb9\u5668\u91c7\u8d2d\u9879\u76ee"}}],"contractScans":[{"id":14266,"object_type":108,"object_id":1825,"attachment_id":6582,"attachment":{"id":6582,"key":6582,"name":"e342085f-f2c3-3d32-93d2-9886b2e9c3e5","extension":"pdf","path":"\/vue\/attachment\/preview\/e342085f-f2c3-3d32-93d2-9886b2e9c3e5\/DZ20201225314060.pdf","orig_name":"DZ20201225314060.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"},{"id":692,"supplier_id":46,"contract_type":1,"signed_at":"2018-09-13","amount":"510597","handler":1011,"description":"\u6731\u5bb8\u96e8-\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40-Hyperflex\u4ea7\u54c1\u5408\u540c","contract_scan":1808,"created_by":1011,"created_at":"2018-09-13 17:36:26","updated_at":"2021-11-09 16:01:26","client_id":1111,"project_id":898,"sales_rep":"","serial_no":"DZ20180913211931","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"510597","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"510597","collected":"510597","invoiced":"510597.00","un_collected":"0","un_invoiced":"0.00","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1808,"key":1808,"name":"6904f7ef-5729-3119-a364-69da7ef23424","extension":"pdf","path":"\/vue\/attachment\/preview\/6904f7ef-5729-3119-a364-69da7ef23424\/\u4fee\u6539\u5408\u540c\u7248\u672c.pdf","orig_name":"\u4fee\u6539\u5408\u540c\u7248\u672c.pdf"},"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"}},"client":{"id":1111,"key":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{"id":898,"key":898,"name":"\u4e2d\u79d1\u9662\u884c\u653f\u7ba1\u7406\u5c40\u673a\u623f\u65b0\u5efa"},"purchaseContractPayments":[{"id":"11960","key":"11960","contract_id":692,"value":"510597.00"}],"purchaseContractInvoices":[{"id":361,"key":361,"contract_id":692,"value":"510597.00","attachment_id":"","from_date":"","attachment":{}}],"purchaseClientRels":[{"id":896,"contract_id":692,"client_id":1111,"project_id":898,"client":{"id":1111,"key":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40","sales_rep":5295},"project":{"id":898,"key":898,"name":"\u4e2d\u79d1\u9662\u884c\u653f\u7ba1\u7406\u5c40\u673a\u623f\u65b0\u5efa"}}],"contractScans":[{"id":14295,"object_type":108,"object_id":692,"attachment_id":1808,"attachment":{"id":1808,"key":1808,"name":"6904f7ef-5729-3119-a364-69da7ef23424","extension":"pdf","path":"\/vue\/attachment\/preview\/6904f7ef-5729-3119-a364-69da7ef23424\/\u4fee\u6539\u5408\u540c\u7248\u672c.pdf","orig_name":"\u4fee\u6539\u5408\u540c\u7248\u672c.pdf"}}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c"}],"model":{"id":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"szsmzgyxgs","main_products":"HP\u670d\u52a1\u5668\/CISCO\u670d\u52a1\u5668\/Netapp\u5b58\u50a8 \u8054\u60f3\u51cc\u62d3\/Vmware\/Veeam\/\u4e2d\u5174\/PaloAlto\/\u6c5f\u5357\u79d1\u53cb\/Arista |McAfee\/Imperva | Infoblox\u7b49","company_nature":5,"website":"http:\/\/www.digitalchina.com\/","established_at":"2000-04-13","capital":100000,"corp_rep":"\u90ed\u4e3a","reg_address":83,"telephone":"010-82707777","fax":"010-82707776","description":"\u603b\u4ee3\uff0cEmc\u601d\u79d1\u90e8\u95e8\u8d26\u671f\uff1a30\u5929\uff0cNetapp\u5b58\u50a8\/vmware\/veeam\u90e8\u95e8\u8d26\u671f\uff1a55\u5929\uff1b\u5ef6\u671f\u652f\u7968\uff1b\n\u6b66\u6c49\u795e\u5dde\u6570\u7801\u4e91\u79d1\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8\t\n\n\u540d\u79f0\uff1a\u4e0a\u6d77\u795e\u5dde\u6570\u7801\u6709\u9650\u516c\u53f8\n\u7a0e\u53f7\uff1a 913100006074162219\n\u5355\u4f4d\u5730\u5740\uff1a\u4e0a\u6d77\u5e02\u957f\u5b81\u533a\u798f\u6cc9\u8def111\u53f7\n\u7535\u8bdd\u53f7\u7801\uff1a 021-22019999\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u4e0a\u6d77\u9a6c\u5f53\u8def\u652f\u884c\n\u94f6\u884c\u8d26\u6237\uff1a 021900320010515\t\t\t\t","main_contact":"","created_by":1011,"created_at":"2017-02-13 11:23:49","updated_at":"2023-08-22 14:42:24","working_address":84,"capital_currency":"rmb","payment_cycle":"55\u5929","account_number":"","total_amount":"38245647.45","collected":"35629293.45","un_collected":"2616354.00","invoiced":"35629293.45","un_invoiced":"2616354.00","clients":"56","projects":"97"},"can_create":true,"pagenation":{"totalcount":127,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 13:22:42') RETURNING "id" |