ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686b93f03453d: POST https://beta.jinchangxiao.com/v2/purchase-contract/of-supplier at 2025-07-07 05:31:28 pm by 223.160.230.231

Performance Profiling

Total processing time: 129 ms; Peak memory: 4.739 MB. Show Profiling Timeline

总计42条数据
TimeDurationCategoryInfo
  
17:31:28.24926.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114)) GROUP BY "object_id"
17:31:28.31421.2 msyii\db\Command::querySELECT "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 (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114)) GROUP BY "object_id"
17:31:28.2326.9 msyii\db\Command::querySELECT 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"
17:31:28.2815.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (1053, 1057, 1097, 1105, 1162, 2090, 2091, 2096))
17:31:28.2394.8 msyii\db\Command::querySELECT 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 10
17:31:28.2194.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
17:31:28.3382.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 166, 'v2/purchase-contract/of-supplier', '{"id":"431","page":"1","pagesize":"10","posttime":"1751880688","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"1d811201e41f2b69b88439556b6a0901"}', '{"code":200,"data":{"list":[{"id":3852,"supplier_id":431,"contract_type":4,"signed_at":"2025-07-04","amount":"4621","handler":1013,"description":"","contract_scan":null,"created_by":1001,"created_at":"2025-07-04 11:00:14","updated_at":"2025-07-04 15:31:55","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":2,"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":{"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":3852,"comment":2},"purchaseClientRels":[{"id":3148,"contract_id":3852,"client_id":982,"project_id":1018,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"clickable":1},"project":{"id":1018,"key":1018,"name":"\u89c6\u9891\u534f\u4f5c\u53ca\u5373\u65f6\u901a\u8baf\u878d\u5408\u65b9\u6848","project_status":5,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[{"id":118136,"object_id":3852,"taxonomy_id":369,"term_id":18,"value":"","object_type":8,"extra_int":"185","in_amount":null,"out_amount":"4535","key":369,"name":"\u9910\u996e\u8d39","amount":"4535","description":"","parent_id":"185","serial_no":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","parent_id":185,"parent":{"id":185,"name":"\u62db\u5f85\u8d39","parent_id":null}}},{"id":118137,"object_id":3852,"taxonomy_id":374,"term_id":18,"value":"","object_type":8,"extra_int":"184","in_amount":null,"out_amount":"86","key":374,"name":"\u71c3\u6cb9\u8d39","amount":"86","description":"","parent_id":"184","serial_no":null,"taxonomy":{"id":374,"name":"\u71c3\u6cb9\u8d39","parent_id":184,"parent":{"id":184,"name":"\u4ea4\u901a\u8d39","parent_id":null}}}],"unreadComments":null,"invoiced":0,"approve_amount":0,"un_approve_amount":4621,"un_invoiced":4621,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u8d39\u7528\u5408\u540c","collected":0,"un_collected":4621,"collected_plan":0,"is_collected":false,"can_update":false,"can_update_cost":true,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3849,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"53534531","handler":1011,"description":"\u7279\u5c14\u7279\u4eba\u542c","contract_scan":null,"created_by":1001,"created_at":"2025-07-03 14:33:27","updated_at":"2025-07-04 14:56:27","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"teeth7","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":true,"cost_type":2,"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":{"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":null,"from_date":"2025-07-03","description":"53534","is_draft":true,"attachment":null,"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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":[{"id":33232,"object_type":108,"object_id":3849,"attachment_id":24802,"attachment":{"id":24802,"key":24802,"name":"09b8c582-0d98-3918-b3cf-1e0f68e8f900","extension":"png","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/09b8c582-0d98-3918-b3cf-1e0f68e8f900\/\u622a\u5c4f2025-07-03 14.39.11.png","orig_name":"\u622a\u5c4f2025-07-03 14.39.11.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[{"id":118133,"object_id":3849,"taxonomy_id":348,"term_id":18,"value":"","object_type":8,"extra_int":"185","in_amount":null,"out_amount":"53534531","key":348,"name":"\u793c\u54c1\u8d39","amount":"53534531","description":"","parent_id":"185","serial_no":null,"taxonomy":{"id":348,"name":"\u793c\u54c1\u8d39","parent_id":185,"parent":{"id":185,"name":"\u62db\u5f85\u8d39","parent_id":null}}}],"unreadComments":null,"invoiced":535,"approve_amount":0,"un_approve_amount":53534531,"un_invoiced":53533996,"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":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":null,"created_by":1001,"created_at":"2025-07-03 14:21:31","updated_at":"2025-07-04 14:57:07","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u8d39\u7528\u5408\u540c","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-04 14:57:07.92213+08","is_chargeback":false,"cost_type":2,"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":{"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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"project_id":null,"title":"34234 ","status":2,"next_verify_user":null,"verify_at":"2025-07-03 14:25:23","description":"42342","refuse_description":null,"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":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"pct":100}],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1028,"user_id":1001,"key":1001,"contract_id":3848,"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":629,"key":629,"contract_id":3848,"name":"2025-07-04","value":"1","overdue_days":null,"pct":0,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1733,"client_id":null,"project_id":null,"title":"34234 ","status":2,"next_verify_user":null,"verify_at":"2025-07-03 14:25:23","description":"42342","refuse_description":null,"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":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null},{"id":1734,"client_id":null,"project_id":null,"title":"\u65e0\u4eba","status":2,"next_verify_user":null,"verify_at":"2025-07-03 14:45:44","description":"wrewer","refuse_description":null,"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":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"costContractAmounts":[{"id":118135,"object_id":3848,"taxonomy_id":369,"term_id":18,"value":"","object_type":8,"extra_int":"185","in_amount":null,"out_amount":"50000000","key":369,"name":"\u9910\u996e\u8d39","amount":"50000000","description":"","parent_id":"185","serial_no":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","parent_id":185,"parent":{"id":185,"name":"\u62db\u5f85\u8d39","parent_id":null}}}],"unreadComments":null,"invoiced":0,"approve_amount":4000066,"un_approve_amount":45999934,"un_invoiced":50000000,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":50000000,"un_collected":0,"collected_plan":1,"is_collected":true,"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":null,"created_by":1001,"created_at":"2025-04-14 14:27:28","updated_at":"2025-06-27 14:41:54","client_id":null,"project_id":null,"sales_rep":null,"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":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":{"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,"clickable":1},"project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898","project_status":3,"clickable":1}},{"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,"clickable":1},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","project_status":3,"clickable":1}}],"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":null,"from_date":"2025-05-07","description":"asdf asdf ads fasd f \nasdf \nasdf \nasd f\nasdf \nasdf asdf asdf asdf ","is_draft":true,"attachment":null,"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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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":null,"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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null}},{"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":null,"pct":0,"collect_status":"\u903e\u671f54\u5929"}],"paymentApproves":[{"id":1725,"client_id":null,"project_id":null,"title":"asd","status":2,"next_verify_user":null,"verify_at":"2025-05-22 13:40:55","description":"asd","refuse_description":null,"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":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null},{"id":1726,"client_id":null,"project_id":null,"title":"123123","status":2,"next_verify_user":null,"verify_at":"2025-05-22 13:41:08","description":"231123312","refuse_description":null,"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":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"costContractAmounts":[],"unreadComments":null,"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":null,"created_by":1011,"created_at":"2022-08-03 10:59:27","updated_at":"2022-08-03 10:59:27","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BJHLXT-GFJ-20220610","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"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":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":[{"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":null,"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":null,"from_date":"2022-08-02","description":null,"is_draft":true,"attachment":null,"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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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":null,"project_id":null,"sales_rep":null,"serial_no":"20220211","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"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":{"id":9660,"key":9660,"name":"\/files\/protected\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/df4fdcc0-0b45-3578-bf75-ce3eeb552edf\/2-11\u5317\u4eac\u62d3\u5b9e1100.pdfdf4fdcc0-0b45-3578-bf75-ce3eeb552edf.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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":null,"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":null,"from_date":"2022-02-23","description":null,"is_draft":true,"attachment":null,"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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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":null,"project_id":null,"sales_rep":null,"serial_no":"BJHLXT-GFJ-2021207","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"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":{"id":9531,"key":9531,"name":"\/files\/protected\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/ecab8370-b8eb-3ee9-b510-9a1a2f6052c0\/2022_01_21_09_11_08.pdfecab8370-b8eb-3ee9-b510-9a1a2f6052c0.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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,"clickable":1},"project":{"id":2706,"key":2706,"name":"\u56fd\u4ea7\u5316\u6d4b\u8bd5\u673a","project_status":3,"clickable":1}}],"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":null,"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":null,"is_draft":true,"attachment":{"id":9564,"key":9564,"name":"cfa86ec3-e4d5-3b36-b5b5-8a3efae929b1","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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":null,"project_id":null,"sales_rep":null,"serial_no":"BJHLXT-GFJ-20210928","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"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":{"id":8747,"key":8747,"name":"\/files\/protected\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdff609df31-7812-3336-891c-23ed5a4a25a2.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"purchaseClientRels":[{"id":873,"contract_id":2114,"client_id":14,"project_id":null,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":null}],"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":null,"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":null,"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":null,"is_draft":true,"attachment":{"id":8748,"key":8748,"name":"f3e64ea0-da71-3e3a-91e9-aa873b851e9a","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/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":null,"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"}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-07 17:31:28') RETURNING "id"
17:31:28.2162.6 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:31:28.2902.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (1064, 1108, 1112, 1179, 2175, 2176, 2178))
17:31:28.2932.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (1064, 1108, 1112, 1179, 2175, 2176, 2178))
17:31:28.2962.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114))
17:31:28.2992.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114))
17:31:28.3061.7 msyii\db\Command::querySELECT "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 (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114)) GROUP BY "r"."id"
17:31:28.2241.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:31:28.3111.1 msyii\db\Command::querySELECT "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 (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114)) ORDER BY "id"
17:31:28.2881.0 msyii\db\Command::querySELECT "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 (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114) ORDER BY "id"
17:31:28.2760.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114) ORDER BY "id"
17:31:28.2790.8 msyii\db\Command::querySELECT "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 (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114) ORDER BY "id"
17:31:28.2780.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2706, 3801, 3786, 1018)
17:31:28.2450.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (9660, 9531, 8747)
17:31:28.2870.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=1733
17:31:28.3030.6 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114)
17:31:28.2470.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1011, 5298))
17:31:28.3050.5 msyii\db\Command::querySELECT "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 (3852, 3849, 3848, 3834, 2364, 2216, 2198, 2114) ORDER BY "remind_date"
17:31:28.2450.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431
17:31:28.2480.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3)
17:31:28.2870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_approve_rels" WHERE "purchase_contract_payment_id" IN (1053, 1057, 1097, 1105, 1162, 2090, 2091, 2096)
17:31:28.2770.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (14, 2120, 3278, 3334, 982)
17:31:28.2490.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1013))
17:31:28.2460.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 5298)
17:31:28.3130.4 msyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (348, 369, 374)
17:31:28.2990.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8747, 9531, 9660, 10726, 24778, 24802)
17:31:28.2800.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5298, 1001)
17:31:28.2960.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8748, 9564, 9667, 10727, 24727, 24728, 24732, 24733, 24801)
17:31:28.3050.3 msyii\db\Command::querySELECT "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, 5329, 1005, 5087, 1004, 5300))
17:31:28.3040.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5329, 5332, 5420, 5087, 5300, 5295, 5404, 1004, 1005)
17:31:28.2480.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1011)
17:31:28.2930.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24726, 24729, 24730, 24731, 24800)
17:31:28.3030.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24779
17:31:28.3130.3 msyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (185, 184)
17:31:28.2890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (8748, 9564)
17:31:28.2860.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24797