68c1384774d2b: POST https://beta.jinchangxiao.com/v2/purchase-contract/list at 2025-09-10 04:35:19 pm by 114.246.239.150
Database Queries
总计43条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:35:19.483 | 3.6 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om' |
| 16:35:19.488 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:35:19.495 | 9.3 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" IN (1, 2)) 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, 5409, 5412, 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"."amount") "c" |
| 16:35:19.505 | 11.6 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" IN (1, 2)) 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, 5409, 5412, 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"."amount" LIMIT 10 |
| 16:35:19.518 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=918 |
| 16:35:19.518 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005 |
| 16:35:19.519 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=1010 |
| 16:35:19.519 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (222, 236, 251, 163, 117, 268, 354, 479, 431, 661) |
| 16:35:19.520 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (4702, 1573, 2807, 369, 3625, 4901) |
| 16:35:19.520 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5023, 1010, 1001) |
| 16:35:19.521 | 0.4 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, 5023, 1010)) |
| 16:35:19.521 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4, 9) |
| 16:35:19.522 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5023) |
| 16:35:19.522 | 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, 5023)) |
| 16:35:19.523 | 21.2 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799)) GROUP BY "object_id" |
| 16:35:19.544 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) ORDER BY "id" |
| 16:35:19.545 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 3278) |
| 16:35:19.545 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1010, 3577) |
| 16:35:19.546 | 3.5 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"."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"."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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) ORDER BY "id" DESC |
| 16:35:19.549 | 0.7 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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) ORDER BY "id" |
| 16:35:19.550 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id"=18) |
| 16:35:19.552 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id"=18) |
| 16:35:19.554 | 2.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799)) |
| 16:35:19.557 | 0.9 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (369, 1573, 2807, 3625, 4702, 4901, 10730, 13567, 24686) |
| 16:35:19.558 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799)) |
| 16:35:19.560 | 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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) |
| 16:35:19.560 | 0.5 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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) ORDER BY "remind_date" |
| 16:35:19.561 | 1.5 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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799)) GROUP BY "r"."id" |
| 16:35:19.563 | 1.0 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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799)) ORDER BY "id" |
| 16:35:19.564 | 17.4 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 (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799)) GROUP BY "object_id" |
| 16:35:19.582 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) |
| 16:35:19.582 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1624 |
| 16:35:19.583 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 16:35:19.584 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=36 |
| 16:35:19.584 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=8 |
| 16:35:19.585 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1382 |
| 16:35:19.585 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 16:35:19.586 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) |
| 16:35:19.587 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (7, 222, 388, 442, 560, 585, 1029, 1206, 1852) ORDER BY "id" |
| 16:35:19.587 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (7, 222, 388, 442, 560, 585, 1029, 1206, 1852) ORDER BY "id" |
| 16:35:19.588 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (7, 222, 388, 442, 560, 585, 1029, 1206, 1852) ORDER BY "id" |
| 16:35:19.588 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (1487, 677, 1021, 2365, 51, 1188, 1523, 2700, 4133, 3799) |
| 16:35:19.591 | 2.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/purchase-contract/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","Filter":{"sort":"ASC","name":"amount"},"device_type":"0","version_code":"266","page":"1","token":"51dc785c303ffe46ceed79173e1707ba","posttime":"1757493319"}', '{"code":200,"data":{"list":[{"id":1487,"supplier_id":222,"contract_type":3,"signed_at":"2020-04-29","amount":"0","handler":1011,"description":"\u4ee3\u7406\u534f\u8bae","contract_scan":4702,"created_by":1011,"created_at":"2020-04-29 13:54:11","updated_at":"2020-04-29 13:54:11","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":222,"key":222,"name":"\u4e0a\u6d77\u5b81\u76fe\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{"id":4702,"key":4702,"name":"\/files\/protected\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e5840693-c168-3a1f-a653-8103efad8612\/\u5b81\u76fe-\u534f\u8bae.pdfe5840693-c168-3a1f-a653-8103efad8612.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e5840693-c168-3a1f-a653-8103efad8612\/\u5b81\u76fe-\u534f\u8bae.pdf","orig_name":"\u5b81\u76fe-\u534f\u8bae.pdf","download":"\/vue\/attachment\/download?name=e5840693-c168-3a1f-a653-8103efad8612"},"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":null,"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":14194,"object_type":108,"object_id":1487,"attachment_id":4702,"attachment":{"id":4702,"key":4702,"name":"e5840693-c168-3a1f-a653-8103efad8612","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e5840693-c168-3a1f-a653-8103efad8612\/\u5b81\u76fe-\u534f\u8bae.pdf","orig_name":"\u5b81\u76fe-\u534f\u8bae.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":560,"serial_no":"CGDD-20200429-00001","from_date":null,"wrote_date":"2020-04-29","handler":1011,"supplier_id":222,"purchase_contract_id":1487,"erp_store_id":null,"status":2,"abstract":null,"description":"\u4ee3\u7406\u534f\u8bae","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2020-04-29 13:54:11","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2020-04-29 13:54:11","updated_at":"2020-04-29 13:54:11","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":677,"supplier_id":236,"contract_type":3,"signed_at":"2018-07-24","amount":"0","handler":5023,"description":"\u4fe1\u9510\u6280\u672f\u4e09\u65b9\u534f\u8bae","contract_scan":1573,"created_by":5023,"created_at":"2018-09-04 14:12:46","updated_at":"2018-09-04 14:12:46","client_id":null,"project_id":null,"sales_rep":null,"serial_no":null,"payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{"id":1573,"key":1573,"name":"\/files\/protected\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/472ae34b-1218-3aef-afbe-c229ce47ddc7\/2018_08_14_11_39_38.pdf472ae34b-1218-3aef-afbe-c229ce47ddc7.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/472ae34b-1218-3aef-afbe-c229ce47ddc7\/2018_08_14_11_39_38.pdf","orig_name":"2018_08_14_11_39_38.pdf","download":"\/vue\/attachment\/download?name=472ae34b-1218-3aef-afbe-c229ce47ddc7"},"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":5023,"key":5023,"name":"\u5f90\u4eac\u5357","sex":"F","avatar":{"id":33,"user_id":5023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e77516c8-4c47-3e32-acbb-7c25718f4d57.png"}},"commentCount":null,"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":13828,"object_type":108,"object_id":677,"attachment_id":1573,"attachment":{"id":1573,"key":1573,"name":"472ae34b-1218-3aef-afbe-c229ce47ddc7","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/472ae34b-1218-3aef-afbe-c229ce47ddc7\/2018_08_14_11_39_38.pdf","orig_name":"2018_08_14_11_39_38.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":222,"serial_no":"CGDD-20180904-00002","from_date":null,"wrote_date":"2018-07-24","handler":5023,"supplier_id":236,"purchase_contract_id":677,"erp_store_id":null,"status":2,"abstract":null,"description":"\u4fe1\u9510\u6280\u672f\u4e09\u65b9\u534f\u8bae","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2018-09-04 14:12:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":5023,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2018-09-04 14:12:46","updated_at":"2018-09-04 14:12:46","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":1021,"supplier_id":251,"contract_type":3,"signed_at":"2019-04-04","amount":"0","handler":1011,"description":"\u4ebf\u8054\u3001\u601d\u8bfa\u6587\u3001\u62d3\u5b9e\u4e09\u65b9\u5408\u4f5c\u4f19\u4f34\u534f\u8bae\uff1b","contract_scan":2807,"created_by":1011,"created_at":"2019-04-26 10:15:36","updated_at":"2019-04-26 10:15:36","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"SVDACD19041117\u6807","payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":251,"key":251,"name":"\u53a6\u95e8\u4ebf\u8054\u7f51\u7edc\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":{"id":2807,"key":2807,"name":"\/files\/protected\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a6fbec84-e9d9-35ef-a289-69caac19985a\/2019_04_26_10_02_16.pdfa6fbec84-e9d9-35ef-a289-69caac19985a.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a6fbec84-e9d9-35ef-a289-69caac19985a\/2019_04_26_10_02_16.pdf","orig_name":"2019_04_26_10_02_16.pdf","download":"\/vue\/attachment\/download?name=a6fbec84-e9d9-35ef-a289-69caac19985a"},"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":null,"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":14008,"object_type":108,"object_id":1021,"attachment_id":2807,"attachment":{"id":2807,"key":2807,"name":"a6fbec84-e9d9-35ef-a289-69caac19985a","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/a6fbec84-e9d9-35ef-a289-69caac19985a\/2019_04_26_10_02_16.pdf","orig_name":"2019_04_26_10_02_16.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":388,"serial_no":"CGDD-20190426-00001","from_date":null,"wrote_date":"2019-04-04","handler":1011,"supplier_id":251,"purchase_contract_id":1021,"erp_store_id":null,"status":2,"abstract":null,"description":"\u4ebf\u8054\u3001\u601d\u8bfa\u6587\u3001\u62d3\u5b9e\u4e09\u65b9\u5408\u4f5c\u4f19\u4f34\u534f\u8bae\uff1b","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-04-26 10:15:36","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2019-04-26 10:15:36","updated_at":"2019-04-26 10:15:36","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":2365,"supplier_id":163,"contract_type":3,"signed_at":"2022-07-15","amount":"0.00","handler":1011,"description":"\u6838\u5fc3\u6e20\u9053\u5408\u4f5c\u4f19\u4f34\u8fd4\u5229\u8ba1\u5212","contract_scan":null,"created_by":1011,"created_at":"2022-08-03 14:52:24","updated_at":"2022-11-18 10:54:42","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"20220715","payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contractScan":null,"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":null,"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":16643,"object_type":108,"object_id":2365,"attachment_id":10730,"attachment":{"id":10730,"key":10730,"name":"e8ca98ca-a305-3244-8da8-6bc3247b1e8c","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e8ca98ca-a305-3244-8da8-6bc3247b1e8c\/\u536b\u5b9e\u5eb7&\u62d3\u5b9e\u6e20\u9053\u8fd4\u5229\u8ba1\u5212\u534f\u8bae.pdf","orig_name":"\u536b\u5b9e\u5eb7&\u62d3\u5b9e\u6e20\u9053\u8fd4\u5229\u8ba1\u5212\u534f\u8bae.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1029,"serial_no":"CGDD-20220803-00002","from_date":null,"wrote_date":"2022-07-15","handler":1011,"supplier_id":163,"purchase_contract_id":2365,"erp_store_id":null,"status":2,"abstract":null,"description":"\u6838\u5fc3\u6e20\u9053\u5408\u4f5c\u4f19\u4f34\u8fd4\u5229\u8ba1\u5212","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-08-03 14:52:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2022-08-03 14:52:24","updated_at":"2022-11-18 10:54:42","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":51,"supplier_id":117,"contract_type":1,"signed_at":"2017-03-24","amount":"0","handler":1011,"description":"\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae","contract_scan":369,"created_by":1010,"created_at":"2017-03-24 19:24:11","updated_at":"2020-05-27 09:17:08","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"-","payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":117,"key":117,"name":"\u5e7f\u5dde\u79d1\u5929\u89c6\u7545\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{"id":369,"key":369,"name":"\/files\/protected\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e5dffb8e-396f-3e0e-bf6b-8440de11cf5b\/\u5e7f\u5dde\u79d1\u5929\u89c6\u7545\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\u2014\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae\u201420170306.pdfe5dffb8e-396f-3e0e-bf6b-8440de11cf5b.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e5dffb8e-396f-3e0e-bf6b-8440de11cf5b\/\u5e7f\u5dde\u79d1\u5929\u89c6\u7545\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\u2014\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae\u201420170306.pdf","orig_name":"\u5e7f\u5dde\u79d1\u5929\u89c6\u7545\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\u2014\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae\u201420170306.pdf","download":"\/vue\/attachment\/download?name=e5dffb8e-396f-3e0e-bf6b-8440de11cf5b"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"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"}},"commentCount":null,"purchaseClientRels":[],"purchaseContractPayments":[{"id":"179","key":"179","contract_id":51,"value":"0.00","collected_date":"2017-03-24 19:24:11","created_at":"2017-03-24 19:24:11","created_by":null,"description":null,"createdBy":null,"pct":""}],"purchaseContractInvoices":[{"id":18,"key":18,"contract_id":51,"amount":"0.00","value":"0.00","attachment_id":null,"from_date":null,"description":null,"is_draft":true,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":13648,"object_type":108,"object_id":51,"attachment_id":369,"attachment":{"id":369,"key":369,"name":"e5dffb8e-396f-3e0e-bf6b-8440de11cf5b","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e5dffb8e-396f-3e0e-bf6b-8440de11cf5b\/\u5e7f\u5dde\u79d1\u5929\u89c6\u7545\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\u2014\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae\u201420170306.pdf","orig_name":"\u5e7f\u5dde\u79d1\u5929\u89c6\u7545\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\u2014\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae\u201420170306.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":7,"serial_no":"CGDD-20170324-00005","from_date":null,"wrote_date":"2017-03-24","handler":1011,"supplier_id":117,"purchase_contract_id":51,"erp_store_id":null,"status":2,"abstract":null,"description":"\u9500\u552e\u4ee3\u7406\u5408\u4f5c\u534f\u8bae","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2017-03-24 19:24:11","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":1010,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2017-03-24 19:24:11","updated_at":"2020-05-27 09:17:08","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":1188,"supplier_id":268,"contract_type":1,"signed_at":"2019-09-25","amount":"0","handler":1011,"description":"\u9e3f\u5408\u5927\u5c4f-\u5408\u4f5c\u534f\u8bae","contract_scan":3625,"created_by":1011,"created_at":"2019-09-29 11:38:50","updated_at":"2019-09-29 11:38:50","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20190925-HYF-008","payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":268,"key":268,"name":"\u5e38\u9752\u6cf0\u8fbe(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{"id":3625,"key":3625,"name":"\/files\/protected\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1926c720-171f-3ce4-8e22-5df1643d6a5d\/2019_09_29_11_33_40.pdf1926c720-171f-3ce4-8e22-5df1643d6a5d.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1926c720-171f-3ce4-8e22-5df1643d6a5d\/2019_09_29_11_33_40.pdf","orig_name":"2019_09_29_11_33_40.pdf","download":"\/vue\/attachment\/download?name=1926c720-171f-3ce4-8e22-5df1643d6a5d"},"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":null,"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":14071,"object_type":108,"object_id":1188,"attachment_id":3625,"attachment":{"id":3625,"key":3625,"name":"1926c720-171f-3ce4-8e22-5df1643d6a5d","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1926c720-171f-3ce4-8e22-5df1643d6a5d\/2019_09_29_11_33_40.pdf","orig_name":"2019_09_29_11_33_40.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":442,"serial_no":"CGDD-20190929-00002","from_date":null,"wrote_date":"2019-09-25","handler":1011,"supplier_id":268,"purchase_contract_id":1188,"erp_store_id":null,"status":2,"abstract":null,"description":"\u9e3f\u5408\u5927\u5c4f-\u5408\u4f5c\u534f\u8bae","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-09-29 11:38:50","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2019-09-29 11:38:50","updated_at":"2019-09-29 11:38:50","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":1523,"supplier_id":354,"contract_type":3,"signed_at":"2020-06-01","amount":"0","handler":1011,"description":"\u8865\u5145\u534f\u8bae","contract_scan":4901,"created_by":1011,"created_at":"2020-06-02 11:40:37","updated_at":"2020-06-02 11:40:37","client_id":918,"project_id":1010,"sales_rep":null,"serial_no":"TJT-S-202002003","payment_collection_remind_ahead":null,"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":"0","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":null,"project":null,"supplier":{"id":354,"key":354,"name":"\u5317\u4eac\u5929\u6770\u817e\u79d1\u8d38\u6709\u9650\u516c\u53f8"},"contractScan":{"id":4901,"key":4901,"name":"\/files\/protected\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e7e98053-a21b-3698-8d02-22814e8d8244\/2020_06_02_11_23_19.pdfe7e98053-a21b-3698-8d02-22814e8d8244.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e7e98053-a21b-3698-8d02-22814e8d8244\/2020_06_02_11_23_19.pdf","orig_name":"2020_06_02_11_23_19.pdf","download":"\/vue\/attachment\/download?name=e7e98053-a21b-3698-8d02-22814e8d8244"},"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":null,"purchaseClientRels":[{"id":609,"contract_id":1523,"client_id":918,"project_id":1010,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":1010,"key":1010,"name":"\u5b89\u5168,\u7f51\u76d8,\u79c1\u6709\u4e91\u8fc1\u79fb,\u8fd0\u7ef4","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":14278,"object_type":108,"object_id":1523,"attachment_id":4901,"attachment":{"id":4901,"key":4901,"name":"e7e98053-a21b-3698-8d02-22814e8d8244","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/e7e98053-a21b-3698-8d02-22814e8d8244\/2020_06_02_11_23_19.pdf","orig_name":"2020_06_02_11_23_19.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":585,"serial_no":"CGDD-20200602-00002","from_date":null,"wrote_date":"2020-06-01","handler":1011,"supplier_id":354,"purchase_contract_id":1523,"erp_store_id":null,"status":2,"abstract":null,"description":"\u8865\u5145\u534f\u8bae","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2020-06-02 11:40:37","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2020-06-02 11:40:37","updated_at":"2020-06-02 11:40:37","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":2700,"supplier_id":479,"contract_type":3,"signed_at":"2023-06-01","amount":"0","handler":1011,"description":"2023.5.30-2024.5.29 MSP\u5408\u4f5c\u534f\u8bae","contract_scan":null,"created_by":1011,"created_at":"2023-06-15 09:24:46","updated_at":"2023-06-15 09:25:16","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"CG20230101202","payment_collection_remind_ahead":"","including_tax":false,"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":"0","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":null,"project":null,"supplier":{"id":479,"key":479,"name":"\u4e0a\u6d77\u4e91\u8f74\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contractScan":null,"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":null,"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":18966,"object_type":108,"object_id":2700,"attachment_id":13567,"attachment":{"id":13567,"key":13567,"name":"115c3e4a-e982-3a6c-ba39-234b972c7749","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/115c3e4a-e982-3a6c-ba39-234b972c7749\/ZStack MSP\u534f\u8bae.pdf","orig_name":"ZStack MSP\u534f\u8bae.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1206,"serial_no":"CGDD-20230615-00001","from_date":null,"wrote_date":"2023-06-01","handler":1011,"supplier_id":479,"purchase_contract_id":2700,"erp_store_id":null,"status":2,"abstract":null,"description":"2023.5.30-2024.5.29 MSP\u5408\u4f5c\u534f\u8bae","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-06-15 09:24:46","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2023-06-15 09:24:46","updated_at":"2023-06-15 09:25:16","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4133,"supplier_id":431,"contract_type":1,"signed_at":"2025-09-05","amount":"0","handler":null,"description":"","contract_scan":null,"created_by":1001,"created_at":"2025-09-05 11:14:06","updated_at":"2025-09-05 11:16:23","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u65b9\u5f0f\u5730\u65b9\u662f","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":null,"erp_cash_cost_ticket_is_verify":false,"client":null,"project":null,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":null,"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":null,"commentCount":null,"purchaseClientRels":[{"id":3801,"contract_id":4133,"client_id":3278,"project_id":3577,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":3577,"key":3577,"name":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":95,"purchase_contract_id":4133,"erp_store_id":null,"erp_purchase_order_product_id":null,"product_id":1624,"description":"","number":"1","amount":"3434","total_amount":"3434","erpStore":null,"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":null}],"erpPurchaseOrder":null,"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","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":3434,"product_number":1,"is_done":false,"cost_done_display":false,"cost_un_done_display":false},{"id":3799,"supplier_id":661,"contract_type":3,"signed_at":"2025-02-27","amount":"0.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-02-27 10:28:28","updated_at":"2025-03-19 09:48:18","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250101-ZHY-001","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":"0","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":null,"project":null,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"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":3799,"comment":1},"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":33049,"object_type":108,"object_id":3799,"attachment_id":24686,"attachment":{"id":24686,"key":24686,"name":"b46e08b4-4a3e-36f7-b6cc-6587c1b72825","extension":"pdf","path":"\/v2\/attachment\/preview\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/b46e08b4-4a3e-36f7-b6cc-6587c1b72825\/\u6838\u5fc3\u91d1\u724c\u5408\u4f5c\u4f19\u4f34\u534f\u8bae.pdf","orig_name":"\u6838\u5fc3\u91d1\u724c\u5408\u4f5c\u4f19\u4f34\u534f\u8bae.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":1852,"serial_no":"CGDD-20250227-00002","from_date":null,"wrote_date":"2025-02-27","handler":1011,"supplier_id":661,"purchase_contract_id":3799,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-02-27 10:28:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"0.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-02-27 10:28:28","updated_at":"2025-03-19 09:48:18","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"invoiced":0,"approve_amount":0,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","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":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true}],"pagenation":{"totalcount":2049,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 16:35:19') RETURNING "id" |