68662865ece38: POST https://beta.jinchangxiao.com/vue/purchase-contract/of-supplier at 2025-07-03 02:51:17 pm by 114.254.1.137
Database Queries
总计42条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:51:17.982 | 2.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:51:17.986 | 0.6 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:51:17.987 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:51:17.994 | 7.0 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 "supplier"."id"='431' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 14:51:18.002 | 5.0 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 "supplier"."id"='431' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20 |
| 14:51:18.008 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 14:51:18.008 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9660, 9531, 8747) |
| 14:51:18.009 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 5298) |
| 14:51:18.010 | 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 (1001, 1011, 5298)) |
| 14:51:18.011 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3) |
| 14:51:18.011 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1013) |
| 14:51:18.012 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1013)) |
| 14:51:18.012 | 23.8 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114)) GROUP BY "object_id" |
| 14:51:18.036 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114) ORDER BY "id" |
| 14:51:18.037 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (14, 2120, 3278, 3334, 2133) |
| 14:51:18.038 | 0.6 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2706, 3801, 3786) |
| 14:51:18.039 | 0.9 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114) ORDER BY "id" |
| 14:51:18.040 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5298, 1001) |
| 14:51:18.040 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (1053, 1057, 1097, 1105, 1162, 2090, 2091, 2094, 2095, 2096, 2097)) |
| 14:51:18.043 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24790, 24795, 24797) |
| 14:51:18.043 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_approve_rels" WHERE "purchase_contract_payment_id" IN (1053, 1057, 1097, 1105, 1162, 2090, 2091, 2094, 2095, 2096, 2097) |
| 14:51:18.044 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id" IN (1732, 1733) |
| 14:51:18.045 | 1.0 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 (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114) ORDER BY "id" |
| 14:51:18.046 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8748, 9564) |
| 14:51:18.046 | 2.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1064, 1108, 1112, 1179, 2175, 2176, 2177, 2178)) |
| 14:51:18.049 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24726, 24729, 24730, 24731, 24793, 24800) |
| 14:51:18.049 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1064, 1108, 1112, 1179, 2175, 2176, 2177, 2178)) |
| 14:51:18.052 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8748, 9564, 9667, 10727, 24727, 24728, 24732, 24733, 24794, 24801) |
| 14:51:18.052 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114)) |
| 14:51:18.055 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8747, 9531, 9660, 10726, 24778, 24789, 24792) |
| 14:51:18.055 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114)) |
| 14:51:18.058 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24779, 24788) |
| 14:51:18.058 | 0.5 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 (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114) |
| 14:51:18.059 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5329, 5332, 5420, 5087, 5300, 5295, 5404, 1004, 1005) |
| 14:51:18.060 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5420, 5404, 5332, 5295, 1005, 5329, 5087, 1004, 5300)) |
| 14:51:18.060 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114) ORDER BY "remind_date" |
| 14:51:18.061 | 1.6 ms | SELECT | SELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114)) GROUP BY "r"."id" |
| 14:51:18.063 | 0.8 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 (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114)) ORDER BY "id" |
| 14:51:18.064 | 0.4 ms | SELECT | SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (349, 369, 348) |
| 14:51:18.065 | 0.3 ms | SELECT | SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (185, 184) |
| 14:51:18.065 | 17.8 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (3849, 3848, 3847, 3834, 2364, 2216, 2198, 2114)) GROUP BY "object_id" |
| 14:51:18.086 | 3.4 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/purchase-contract/of-supplier', '{"page":"1","id":"431","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"list":[{"id":3849,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"5353453","handler":1011,"description":"\u7279\u5c14\u7279\u4eba\u542c","contract_scan":"","created_by":1001,"created_at":"2025-07-03 14:33:27","updated_at":"2025-07-03 14:50:22","client_id":"","project_id":"","sales_rep":"","serial_no":"teeth7","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":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":3849,"comment":1},"purchaseClientRels":[],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2178,"key":2178,"contract_id":3849,"amount":"535.00","value":"535.00","attachment_id":"","from_date":"2025-07-03","description":"53534","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":33186,"object_type":21,"object_id":2178,"attachment_id":24800,"attachment":{"id":24800,"key":24800,"name":"c32d712a-aa14-3cba-ba6e-4d91ce437248","extension":"png","path":"\/vue\/attachment\/view\/c32d712a-aa14-3cba-ba6e-4d91ce437248\/\u622a\u5c4f2025-07-01 17.28.08.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.08.png"}}],"files":[{"id":33187,"object_type":103,"object_id":2178,"attachment_id":24801,"attachment":{"id":24801,"key":24801,"name":"aa5e039d-1423-3338-80d0-bdb8e7969885","extension":"xls","path":"\/vue\/attachment\/view\/aa5e039d-1423-3338-80d0-bdb8e7969885\/\u526f\u672c\u4e13\u9879\u9644\u52a0\u6263\u9664\u4fe1\u606f\u5bfc\u5165\u6a21\u677f.xls","orig_name":"\u526f\u672c\u4e13\u9879\u9644\u52a0\u6263\u9664\u4fe1\u606f\u5bfc\u5165\u6a21\u677f.xls"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[{"id":118081,"object_id":3849,"taxonomy_id":348,"term_id":18,"value":"","object_type":8,"extra_int":"185","in_amount":"","out_amount":"5353453","key":348,"name":"\u793c\u54c1\u8d39","amount":"5353453","description":"","parent_id":"185","serial_no":"","taxonomy":{"id":348,"name":"\u793c\u54c1\u8d39","parent_id":185,"parent":{"id":185,"name":"\u62db\u5f85\u8d39","parent_id":""}}}],"unreadComments":{},"invoiced":535,"approve_amount":0,"un_approve_amount":5353453,"un_invoiced":5352918,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":0,"un_collected":5353453,"collected_plan":0,"is_collected":false,"can_update":false,"can_update_cost":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3848,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"50000000","handler":1011,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-07-03 14:21:31","updated_at":"2025-07-03 14:37:34","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8d39\u7528\u5408\u540c","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":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":3848,"comment":5},"purchaseClientRels":[],"purchaseContractPayments":[{"id":2096,"key":2096,"contract_id":3848,"value":"50000000","collected_date":"2025-07-03","created_at":"2025-07-03 14:44:44","created_by":1001,"description":"v","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[{"id":33183,"object_type":110,"object_id":2096,"attachment_id":24797,"attachment":{"id":24797,"key":24797,"name":"585fb836-3574-3b4e-bb7a-9a7f1ce61f24","extension":"png","path":"\/vue\/attachment\/view\/585fb836-3574-3b4e-bb7a-9a7f1ce61f24\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}}],"approves":[{"id":1733,"client_id":"","project_id":"","title":"34234 ","status":2,"next_verify_user":"","verify_at":"2025-07-03 14:25:23","description":"42342","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-07-03 14:25:17","updated_at":"2025-07-03 14:25:23","supplier_id":431,"purchase_contract_id":3848,"amount":"4000000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":100},{"id":2097,"key":2097,"contract_id":3848,"value":"1","collected_date":"2025-07-03","created_at":"2025-07-03 14:49:53","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":0}],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[{"id":1733,"client_id":"","project_id":"","title":"34234 ","status":2,"next_verify_user":"","verify_at":"2025-07-03 14:25:23","description":"42342","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-07-03 14:25:17","updated_at":"2025-07-03 14:25:23","supplier_id":431,"purchase_contract_id":3848,"amount":"4000000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""},{"id":1734,"client_id":"","project_id":"","title":"\u65e0\u4eba","status":2,"next_verify_user":"","verify_at":"2025-07-03 14:45:44","description":"wrewer","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-07-03 14:27:56","updated_at":"2025-07-03 14:45:44","supplier_id":431,"purchase_contract_id":3848,"amount":"66","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[{"id":118078,"object_id":3848,"taxonomy_id":369,"term_id":18,"value":"","object_type":8,"extra_int":"185","in_amount":"","out_amount":"50000000","key":369,"name":"\u9910\u996e\u8d39","amount":"50000000","description":"","parent_id":"185","serial_no":"","taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","parent_id":185,"parent":{"id":185,"name":"\u62db\u5f85\u8d39","parent_id":""}}}],"unreadComments":{},"invoiced":0,"approve_amount":4000066,"un_approve_amount":45999934,"un_invoiced":50000000,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":50000001,"un_collected":-1,"collected_plan":0,"is_collected":true,"can_update":false,"can_update_cost":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3847,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"16644","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":"","created_by":1001,"created_at":"2025-07-03 14:01:32","updated_at":"2025-07-03 14:18:36","client_id":"","project_id":"","sales_rep":"","serial_no":"646456456","payment_collection_remind_ahead":"1 day","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-07-03 14:11:28.860815+08","is_chargeback":true,"cost_type":2,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":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":3847,"comment":1},"purchaseClientRels":[{"id":3135,"contract_id":3847,"client_id":2133,"project_id":"","client":{"id":2133,"key":2133,"name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5311},"project":{}}],"purchaseContractPayments":[{"id":2094,"key":2094,"contract_id":3847,"value":"766","collected_date":"2025-07-03","created_at":"2025-07-03 14:03:29","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[{"id":33168,"object_type":110,"object_id":2094,"attachment_id":24790,"attachment":{"id":24790,"key":24790,"name":"d21ec530-d3a7-32b9-a745-4dd2fbe89397","extension":"png","path":"\/vue\/attachment\/view\/d21ec530-d3a7-32b9-a745-4dd2fbe89397\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}}],"approves":[],"pct":4.6},{"id":2095,"key":2095,"contract_id":3847,"value":"6546","collected_date":"2025-07-03","created_at":"2025-07-03 14:16:28","created_by":1001,"description":"\u7ed9\u5bf9\u65b9\u8fc7\u5206\u5927\u59d1","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[{"id":33181,"object_type":110,"object_id":2095,"attachment_id":24795,"attachment":{"id":24795,"key":24795,"name":"b5c6d520-a6d9-370c-ba01-9c7ebedfc6d8","extension":"png","path":"\/vue\/attachment\/view\/b5c6d520-a6d9-370c-ba01-9c7ebedfc6d8\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}}],"approves":[{"id":1732,"client_id":3334,"project_id":3786,"title":"retort","status":2,"next_verify_user":"","verify_at":"2025-07-03 14:15:00","description":"t\u513f\u7ae5","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-07-03 14:14:56","updated_at":"2025-07-03 14:15:00","supplier_id":431,"purchase_contract_id":3847,"amount":"34234","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"pct":39.33}],"purchaseContractInvoices":[{"id":2177,"key":2177,"contract_id":3847,"amount":"1.00","value":"1.00","attachment_id":"","from_date":"2025-07-03","description":"\u6d4b\u8bd5","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":33173,"object_type":21,"object_id":2177,"attachment_id":24793,"attachment":{"id":24793,"key":24793,"name":"9dbeb961-c758-3a0c-9c12-1d00b78ee7d0","extension":"png","path":"\/vue\/attachment\/view\/9dbeb961-c758-3a0c-9c12-1d00b78ee7d0\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}}],"files":[{"id":33174,"object_type":103,"object_id":2177,"attachment_id":24794,"attachment":{"id":24794,"key":24794,"name":"dece5bc7-2249-3f1d-b824-b1383bcdffbe","extension":"xlsx","path":"\/vue\/attachment\/view\/dece5bc7-2249-3f1d-b824-b1383bcdffbe\/\u5355\u636e\u5173\u8054.xlsx","orig_name":"\u5355\u636e\u5173\u8054.xlsx"}}]}],"contractScans":[{"id":33178,"object_type":108,"object_id":3847,"attachment_id":24789,"attachment":{"id":24789,"key":24789,"name":"9e67beee-a720-32cb-96ee-490ad52c6820","extension":"png","path":"\/vue\/attachment\/preview\/9e67beee-a720-32cb-96ee-490ad52c6820\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}},{"id":33179,"object_type":108,"object_id":3847,"attachment_id":24792,"attachment":{"id":24792,"key":24792,"name":"d3a45c58-4e49-3086-a7bc-5bbc9863b86e","extension":"txt","path":"\/vue\/attachment\/preview\/d3a45c58-4e49-3086-a7bc-5bbc9863b86e\/2024-01-16.txt","orig_name":"2024-01-16.txt"}}],"receiptScans":[{"id":33180,"object_type":111,"object_id":3847,"attachment_id":24788,"attachment":{"id":24788,"key":24788,"name":"318e78e3-2a6c-31e2-b77b-4f864c411617","extension":"png","path":"\/vue\/attachment\/preview\/318e78e3-2a6c-31e2-b77b-4f864c411617\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1024,"user_id":1001,"key":1001,"contract_id":3847,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":623,"key":623,"contract_id":3847,"name":"2025-07-03","value":"6400","overdue_days":0,"pct":38.45,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1732,"client_id":3334,"project_id":3786,"title":"retort","status":2,"next_verify_user":"","verify_at":"2025-07-03 14:15:00","description":"t\u513f\u7ae5","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-07-03 14:14:56","updated_at":"2025-07-03 14:15:00","supplier_id":431,"purchase_contract_id":3847,"amount":"34234","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[{"id":118066,"object_id":3847,"taxonomy_id":349,"term_id":18,"value":"\u89c9\u5f97\u5f88\u70e6\u7684\u5f88\u5927\u59d1\u56de\u590d\u5bf9\u65b9\u597d\u5730\u65b9","object_type":8,"extra_int":"184","in_amount":"","out_amount":"8768","key":349,"name":"\u7684\u58eb\u8d39","amount":"8768","description":"\u89c9\u5f97\u5f88\u70e6\u7684\u5f88\u5927\u59d1\u56de\u590d\u5bf9\u65b9\u597d\u5730\u65b9","parent_id":"184","serial_no":"","taxonomy":{"id":349,"name":"\u7684\u58eb\u8d39","parent_id":184,"parent":{"id":184,"name":"\u4ea4\u901a\u8d39","parent_id":""}}},{"id":118067,"object_id":3847,"taxonomy_id":369,"term_id":18,"value":"","object_type":8,"extra_int":"185","in_amount":"","out_amount":"7876","key":369,"name":"\u9910\u996e\u8d39","amount":"7876","description":"","parent_id":"185","serial_no":"","taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","parent_id":185,"parent":{"id":185,"name":"\u62db\u5f85\u8d39","parent_id":""}}}],"unreadComments":{},"invoiced":1,"approve_amount":34234,"un_approve_amount":-17590,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":7312,"un_collected":-7312,"collected_plan":6400,"is_collected":false,"can_update":false,"can_update_cost":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3834,"supplier_id":431,"contract_type":1,"signed_at":"2025-04-14","amount":"900000000.00","handler":1013,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-04-14 14:27:28","updated_at":"2025-06-27 14:41:54","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u5173\u8054\u91c7\u8d2d\u5408\u540c\u95ee\u9898","payment_collection_remind_ahead":"7 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-05-16 15:57:04.1243+08","is_chargeback":true,"cost_type":1,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"commentCount":{"object_id":3834,"comment":4},"purchaseClientRels":[{"id":3128,"contract_id":3834,"client_id":3278,"project_id":3801,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898","project_status":3}},{"id":3131,"contract_id":3834,"client_id":3334,"project_id":3786,"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","project_status":3}}],"purchaseContractPayments":[{"id":2090,"key":2090,"contract_id":3834,"value":"800000000","collected_date":"2025-05-07","created_at":"2025-05-07 16:21:45","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":88.89},{"id":2091,"key":2091,"contract_id":3834,"value":"-800000000","collected_date":"2025-05-07","created_at":"2025-05-07 16:25:37","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":-88.89}],"purchaseContractInvoices":[{"id":2175,"key":2175,"contract_id":3834,"amount":"1.00","value":"1.00","attachment_id":"","from_date":"2025-05-07","description":"asdf asdf ads fasd f \nasdf \nasdf \nasd f\nasdf \nasdf asdf asdf asdf ","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":33098,"object_type":21,"object_id":2175,"attachment_id":24726,"attachment":{"id":24726,"key":24726,"name":"a9a2f5eb-4847-37ff-9e9d-fdb4f8acedfd","extension":"jpg","path":"\/vue\/attachment\/view\/a9a2f5eb-4847-37ff-9e9d-fdb4f8acedfd\/WechatIMG33643.jpg","orig_name":"WechatIMG33643.jpg"}},{"id":33099,"object_type":21,"object_id":2175,"attachment_id":24729,"attachment":{"id":24729,"key":24729,"name":"46708d1b-9853-3b65-89a6-111540022d2c","extension":"jpg","path":"\/vue\/attachment\/view\/46708d1b-9853-3b65-89a6-111540022d2c\/WechatIMG33760.jpg","orig_name":"WechatIMG33760.jpg"}}],"files":[{"id":33100,"object_type":103,"object_id":2175,"attachment_id":24727,"attachment":{"id":24727,"key":24727,"name":"1ac3e1e9-4c90-3de0-b77d-b9f81ccac462","extension":"docx","path":"\/vue\/attachment\/view\/1ac3e1e9-4c90-3de0-b77d-b9f81ccac462\/08-22\u5f85\u5f00\u53d1.docx","orig_name":"08-22\u5f85\u5f00\u53d1.docx"}},{"id":33101,"object_type":103,"object_id":2175,"attachment_id":24728,"attachment":{"id":24728,"key":24728,"name":"95b56d42-9345-326b-b42d-36244d30f767","extension":"docx","path":"\/vue\/attachment\/view\/95b56d42-9345-326b-b42d-36244d30f767\/05-22\u5f85\u5f00\u53d1.docx","orig_name":"05-22\u5f85\u5f00\u53d1.docx"}}]},{"id":2176,"key":2176,"contract_id":3834,"amount":"22.00","value":"22.00","attachment_id":"","from_date":"2025-05-21","description":"asdf \u963f\u65af\u8482\u82ac\u963f\u8428\u5fb7\u53d1\u5927\u6c34\n\u963f\u65af\u8482\u82acasd \u53d1\u65af\u8482\u82ac\u5965\u5fb7\u8d5b\u53d1\u591a\u5c11\u53d1\u751f\u7684\n\u963f\u662f\u5927\u6cd5\u5e08\u5927\u6cd5\u5e08\u7684\u53d1\u751f\u7684\n\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u65af\u8482\u82ac\u963f\u662f\n\u963f\u65af\u987f\u53d1\u7b2c\u4e09\u65b9\u554a\u662f\u5426\u963f\u662f","is_draft":true,"attachment":{},"attachmentRelationships":[{"id":33102,"object_type":21,"object_id":2176,"attachment_id":24730,"attachment":{"id":24730,"key":24730,"name":"0f714f0b-8ae7-3041-b7cb-b8db33fe4935","extension":"jpg","path":"\/vue\/attachment\/view\/0f714f0b-8ae7-3041-b7cb-b8db33fe4935\/WechatIMG73.jpg","orig_name":"WechatIMG73.jpg"}},{"id":33103,"object_type":21,"object_id":2176,"attachment_id":24731,"attachment":{"id":24731,"key":24731,"name":"61553183-d59e-317b-9a6c-f7ca606a9226","extension":"jpg","path":"\/vue\/attachment\/view\/61553183-d59e-317b-9a6c-f7ca606a9226\/WechatIMG33643.jpg","orig_name":"WechatIMG33643.jpg"}}],"files":[{"id":33104,"object_type":103,"object_id":2176,"attachment_id":24732,"attachment":{"id":24732,"key":24732,"name":"5ab8c55f-c12f-3461-9ecf-89a3b77abec0","extension":"docx","path":"\/vue\/attachment\/view\/5ab8c55f-c12f-3461-9ecf-89a3b77abec0\/05-05\u5f85\u5f00\u53d1.docx","orig_name":"05-05\u5f85\u5f00\u53d1.docx"}},{"id":33105,"object_type":103,"object_id":2176,"attachment_id":24733,"attachment":{"id":24733,"key":24733,"name":"2fb1d383-e0db-303c-8691-57fe1aca0108","extension":"docx","path":"\/vue\/attachment\/view\/2fb1d383-e0db-303c-8691-57fe1aca0108\/05-16\u5f85\u5f00\u53d1.docx","orig_name":"05-16\u5f85\u5f00\u53d1.docx"}}]}],"contractScans":[{"id":33155,"object_type":108,"object_id":3834,"attachment_id":24778,"attachment":{"id":24778,"key":24778,"name":"d934ac1b-3c49-3dbf-8b32-825f72be9bf5","extension":"pdf","path":"\/vue\/attachment\/preview\/d934ac1b-3c49-3dbf-8b32-825f72be9bf5\/InvSqrt.pdf","orig_name":"InvSqrt.pdf"}}],"receiptScans":[{"id":33156,"object_type":111,"object_id":3834,"attachment_id":24779,"attachment":{"id":24779,"key":24779,"name":"09bfd0bc-67cf-33fc-9f67-f2580c8cdb75","extension":"jpg","path":"\/vue\/attachment\/preview\/09bfd0bc-67cf-33fc-9f67-f2580c8cdb75\/WechatIMG54800.jpg","orig_name":"WechatIMG54800.jpg"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1013,"user_id":1001,"key":1001,"contract_id":3834,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":1014,"user_id":5329,"key":5329,"contract_id":3834,"user":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},{"id":1015,"user_id":5332,"key":5332,"contract_id":3834,"user":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}},{"id":1016,"user_id":5420,"key":5420,"contract_id":3834,"user":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"id":1017,"user_id":5087,"key":5087,"contract_id":3834,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"id":1018,"user_id":5300,"key":5300,"contract_id":3834,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":1019,"user_id":5295,"key":5295,"contract_id":3834,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":1020,"user_id":5404,"key":5404,"contract_id":3834,"user":{"id":5404,"key":5404,"name":"\u6b66\u51ef","sex":"M","avatar":{}}},{"id":1021,"user_id":1004,"key":1004,"contract_id":3834,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"id":1022,"user_id":1005,"key":1005,"contract_id":3834,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":621,"key":621,"contract_id":3834,"name":"2025-05-14","value":"1","overdue_days":"","pct":0,"collect_status":"\u903e\u671f50\u5929"}],"paymentApproves":[{"id":1725,"client_id":"","project_id":"","title":"asd","status":2,"next_verify_user":"","verify_at":"2025-05-22 13:40:55","description":"asd","refuse_description":"","is_resubmited":false,"created_by":5016,"created_at":"2025-05-22 13:40:51","updated_at":"2025-05-22 13:40:55","supplier_id":431,"purchase_contract_id":3834,"amount":"123213","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""},{"id":1726,"client_id":"","project_id":"","title":"123123","status":2,"next_verify_user":"","verify_at":"2025-05-22 13:41:08","description":"231123312","refuse_description":"","is_resubmited":false,"created_by":5016,"created_at":"2025-05-22 13:41:04","updated_at":"2025-05-22 13:41:08","supplier_id":431,"purchase_contract_id":3834,"amount":"123","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":""}],"costContractAmounts":[],"unreadComments":{},"invoiced":23,"approve_amount":123336,"un_approve_amount":899876664,"un_invoiced":899999977,"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":0,"collected_plan":1,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":2364,"supplier_id":431,"contract_type":3,"signed_at":"2022-06-10","amount":"4060.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2022-08-03 10:59:27","updated_at":"2022-08-03 10:59:27","client_id":"","project_id":"","sales_rep":"","serial_no":"BJHLXT-GFJ-20220610","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":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":{},"purchaseClientRels":[],"purchaseContractPayments":[{"id":1162,"key":1162,"contract_id":2364,"value":"4060.00","collected_date":"2022-06-10","created_at":"2022-08-03 10:59:27","created_by":1011,"description":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"files":[],"approves":[],"pct":100}],"purchaseContractInvoices":[{"id":1179,"key":1179,"contract_id":2364,"amount":"4060","value":"4060","attachment_id":"","from_date":"2022-08-02","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":15766,"object_type":103,"object_id":1179,"attachment_id":10727,"attachment":{"id":10727,"key":10727,"name":"6a89e459-ff8a-3116-8f98-097308f51a44","extension":"pdf","path":"\/vue\/attachment\/view\/6a89e459-ff8a-3116-8f98-097308f51a44\/2022_08_03_10_53_29 2.pdf","orig_name":"2022_08_03_10_53_29 2.pdf"}}]}],"contractScans":[{"id":15765,"object_type":108,"object_id":2364,"attachment_id":10726,"attachment":{"id":10726,"key":10726,"name":"93904ec2-6707-3e1d-88a7-c920cfb530df","extension":"pdf","path":"\/vue\/attachment\/preview\/93904ec2-6707-3e1d-88a7-c920cfb530df\/2022_08_03_10_53_29.pdf","orig_name":"2022_08_03_10_53_29.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":4060,"approve_amount":0,"un_approve_amount":4060,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":4060,"un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":2216,"supplier_id":431,"contract_type":1,"signed_at":"2022-02-11","amount":"1100.00","handler":1011,"description":"\u4f9b\u5e94\u5546\uff1a\u5e7f\u5dde\u4e2d\u601d\u8a89\u6052\u79d1\u6280\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","contract_scan":9660,"created_by":5298,"created_at":"2022-02-25 15:17:24","updated_at":"2022-02-25 15:18:42","client_id":"","project_id":"","sales_rep":"","serial_no":"20220211","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9660,"key":9660,"name":"\/files\/protected\/vue\/attachment\/preview\/df4fdcc0-0b45-3578-bf75-ce3eeb552edf\/2-11\u5317\u4eac\u62d3\u5b9e1100.pdfdf4fdcc0-0b45-3578-bf75-ce3eeb552edf.pdf","extension":"pdf","path":"\/vue\/attachment\/preview\/df4fdcc0-0b45-3578-bf75-ce3eeb552edf\/2-11\u5317\u4eac\u62d3\u5b9e1100.pdf","orig_name":"2-11\u5317\u4eac\u62d3\u5b9e1100.pdf","download":"\/vue\/attachment\/download?name=df4fdcc0-0b45-3578-bf75-ce3eeb552edf"},"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"}},"commentCount":{},"purchaseClientRels":[],"purchaseContractPayments":[{"id":1105,"key":1105,"contract_id":2216,"value":"1100.00","collected_date":"2022-02-24","created_at":"2022-02-25 15:58:54","created_by":5298,"description":"","createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"files":[],"approves":[],"pct":100}],"purchaseContractInvoices":[{"id":1112,"key":1112,"contract_id":2216,"amount":"1100.00","value":"1100.00","attachment_id":"","from_date":"2022-02-23","description":"","is_draft":true,"attachment":{},"attachmentRelationships":[],"files":[{"id":14565,"object_type":103,"object_id":1112,"attachment_id":9667,"attachment":{"id":9667,"key":9667,"name":"fe0683f3-2d7d-34d3-b6ac-d88ff7a2a850","extension":"pdf","path":"\/vue\/attachment\/view\/fe0683f3-2d7d-34d3-b6ac-d88ff7a2a850\/2022_02_25_16_45_59.pdf","orig_name":"2022_02_25_16_45_59.pdf"}}]}],"contractScans":[{"id":14559,"object_type":108,"object_id":2216,"attachment_id":9660,"attachment":{"id":9660,"key":9660,"name":"df4fdcc0-0b45-3578-bf75-ce3eeb552edf","extension":"pdf","path":"\/vue\/attachment\/preview\/df4fdcc0-0b45-3578-bf75-ce3eeb552edf\/2-11\u5317\u4eac\u62d3\u5b9e1100.pdf","orig_name":"2-11\u5317\u4eac\u62d3\u5b9e1100.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":1100,"approve_amount":0,"un_approve_amount":1100,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":1100,"un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":2198,"supplier_id":431,"contract_type":1,"signed_at":"2021-12-07","amount":"63347.00","handler":1011,"description":"","contract_scan":9531,"created_by":5298,"created_at":"2022-01-21 09:26:04","updated_at":"2022-01-21 09:32:59","client_id":"","project_id":"","sales_rep":"","serial_no":"BJHLXT-GFJ-2021207","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{"id":9531,"key":9531,"name":"\/files\/protected\/vue\/attachment\/preview\/ecab8370-b8eb-3ee9-b510-9a1a2f6052c0\/2022_01_21_09_11_08.pdfecab8370-b8eb-3ee9-b510-9a1a2f6052c0.pdf","extension":"pdf","path":"\/vue\/attachment\/preview\/ecab8370-b8eb-3ee9-b510-9a1a2f6052c0\/2022_01_21_09_11_08.pdf","orig_name":"2022_01_21_09_11_08.pdf","download":"\/vue\/attachment\/download?name=ecab8370-b8eb-3ee9-b510-9a1a2f6052c0"},"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"}},"commentCount":{},"purchaseClientRels":[{"id":962,"contract_id":2198,"client_id":2120,"project_id":2706,"client":{"id":2120,"key":2120,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u5316\u5de5\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004},"project":{"id":2706,"key":2706,"name":"\u56fd\u4ea7\u5316\u6d4b\u8bd5\u673a","project_status":3}}],"purchaseContractPayments":[{"id":1097,"key":1097,"contract_id":2198,"value":"63347.00","collected_date":"2021-12-09","created_at":"2022-01-21 09:38:22","created_by":5298,"description":"","createdBy":{"id":5298,"key":5298,"name":"\u675c\u6587\u98de","sex":"F","department_id":3},"files":[],"approves":[],"pct":100}],"purchaseContractInvoices":[{"id":1108,"key":1108,"contract_id":2198,"amount":"63347.00","value":"63347.00","attachment_id":9564,"from_date":"2022-02-12","description":"","is_draft":true,"attachment":{"id":9564,"key":9564,"name":"cfa86ec3-e4d5-3b36-b5b5-8a3efae929b1","extension":"pdf","path":"\/vue\/attachment\/preview\/cfa86ec3-e4d5-3b36-b5b5-8a3efae929b1\/2022_02_14_09_22_33\u526f\u672c.pdf","orig_name":"2022_02_14_09_22_33\u526f\u672c.pdf"},"attachmentRelationships":[],"files":[{"id":7639,"object_type":103,"object_id":1108,"attachment_id":9564,"attachment":{"id":9564,"key":9564,"name":"cfa86ec3-e4d5-3b36-b5b5-8a3efae929b1","extension":"pdf","path":"\/vue\/attachment\/view\/cfa86ec3-e4d5-3b36-b5b5-8a3efae929b1\/2022_02_14_09_22_33\u526f\u672c.pdf","orig_name":"2022_02_14_09_22_33\u526f\u672c.pdf"}}]}],"contractScans":[{"id":14557,"object_type":108,"object_id":2198,"attachment_id":9531,"attachment":{"id":9531,"key":9531,"name":"ecab8370-b8eb-3ee9-b510-9a1a2f6052c0","extension":"pdf","path":"\/vue\/attachment\/preview\/ecab8370-b8eb-3ee9-b510-9a1a2f6052c0\/2022_01_21_09_11_08.pdf","orig_name":"2022_01_21_09_11_08.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":63347,"approve_amount":0,"un_approve_amount":63347,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":63347,"un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":2114,"supplier_id":431,"contract_type":1,"signed_at":"2021-09-28","amount":"116250.00","handler":1011,"description":"\u540c\u65b9\u4ea7\u54c19\u4e2a\u53f0\u5f0f\u673a+1\u53f0\u670d\u52a1\u5668","contract_scan":8747,"created_by":1011,"created_at":"2021-10-26 11:38:52","updated_at":"2021-11-02 12:48:09","client_id":"","project_id":"","sales_rep":"","serial_no":"BJHLXT-GFJ-20210928","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{"id":8747,"key":8747,"name":"\/files\/protected\/vue\/attachment\/preview\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdff609df31-7812-3336-891c-23ed5a4a25a2.pdf","extension":"pdf","path":"\/vue\/attachment\/preview\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdf","orig_name":"2021_11_02_12_40_16.pdf","download":"\/vue\/attachment\/download?name=f609df31-7812-3336-891c-23ed5a4a25a2"},"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":{},"purchaseClientRels":[{"id":873,"contract_id":2114,"client_id":14,"project_id":"","client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{}}],"purchaseContractPayments":[{"id":1053,"key":1053,"contract_id":2114,"value":"80235.00","collected_date":"2021-11-02","created_at":"2021-11-02 12:48:56","created_by":1011,"description":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"files":[],"approves":[],"pct":69.02},{"id":1057,"key":1057,"contract_id":2114,"value":"36015.00","collected_date":"2021-11-12","created_at":"2021-11-12 09:39:38","created_by":1011,"description":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"files":[],"approves":[],"pct":30.98}],"purchaseContractInvoices":[{"id":1064,"key":1064,"contract_id":2114,"amount":"116250.00","value":"116250.00","attachment_id":8748,"from_date":"2021-10-28","description":"","is_draft":true,"attachment":{"id":8748,"key":8748,"name":"f3e64ea0-da71-3e3a-91e9-aa873b851e9a","extension":"pdf","path":"\/vue\/attachment\/preview\/f3e64ea0-da71-3e3a-91e9-aa873b851e9a\/2021_11_02_12_40_03.pdf","orig_name":"2021_11_02_12_40_03.pdf"},"attachmentRelationships":[],"files":[{"id":7598,"object_type":103,"object_id":1064,"attachment_id":8748,"attachment":{"id":8748,"key":8748,"name":"f3e64ea0-da71-3e3a-91e9-aa873b851e9a","extension":"pdf","path":"\/vue\/attachment\/view\/f3e64ea0-da71-3e3a-91e9-aa873b851e9a\/2021_11_02_12_40_03.pdf","orig_name":"2021_11_02_12_40_03.pdf"}}]}],"contractScans":[{"id":14518,"object_type":108,"object_id":2114,"attachment_id":8747,"attachment":{"id":8747,"key":8747,"name":"f609df31-7812-3336-891c-23ed5a4a25a2","extension":"pdf","path":"\/vue\/attachment\/preview\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdf","orig_name":"2021_11_02_12_40_16.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"invoiced":116250,"approve_amount":0,"un_approve_amount":116250,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":116250,"un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":8,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 14:51:18') RETURNING "id" |