ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686b93e2d5580: POST https://beta.jinchangxiao.com/v2/purchase-contract/list at 2025-07-07 05:31:14 pm by 223.160.230.231

Performance Profiling

Total processing time: 90 ms; Peak memory: 4.872 MB. Show Profiling Timeline

总计37条数据
TimeDurationCategoryInfo
  
17:31:14.90419.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) GROUP BY "object_id"
17:31:14.94215.7 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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) GROUP BY "object_id"
17:31:14.8867.8 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
17:31:14.8947.4 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 ("c"."cost_type"=1) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 OFFSET 10
17:31:14.8772.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
17:31:14.9592.7 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/list', '{"PurchaseContractSearch":{"keyword":"","contract_type":"","handler":"","sales_rep":""},"page":"2","posttime":"1751880674","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"87bb2d89f3360628e52ce969bf88bf3e"}', '{"code":200,"data":{"list":[{"id":3818,"supplier_id":684,"contract_type":3,"signed_at":"2025-03-07","amount":"3500.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-03-07 09:50:03","updated_at":"2025-03-07 11:01:34","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"SFSHFWH202503060228","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 09:50:11.494352+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3818,"comment":2},"purchaseClientRels":[{"id":3071,"contract_id":3818,"client_id":918,"project_id":3666,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3666,"key":3666,"name":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":2072,"key":2072,"contract_id":3818,"value":"3500.00","collected_date":"2025-03-07","created_at":"2025-03-07 10:15:04","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32729,"object_type":110,"object_id":2072,"attachment_id":24435,"attachment":{"id":24435,"key":24435,"name":"0c68c2ed-6ad8-3125-9fee-cb090c58cb32","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/0c68c2ed-6ad8-3125-9fee-cb090c58cb32\/image.png","orig_name":"image.png"}}],"approves":[{"id":1689,"client_id":918,"project_id":3666,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-03-07 09:58:39","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u571f\u6728\u9879\u76ee\u4e2d55\u53f0\u670d\u52a1\u5668\u7aefEDR\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe53500\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u957f\u6c99\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u9ad8\u65b0\u652f\u884c\n810000194191000001\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-07 09:58:32","updated_at":"2025-03-07 09:58:39","supplier_id":684,"purchase_contract_id":3818,"amount":"3500","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"pct":100}],"purchaseContractInvoices":[{"id":2160,"key":2160,"contract_id":3818,"amount":"3500","value":"3500","attachment_id":null,"from_date":"2025-03-07","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32738,"object_type":103,"object_id":2160,"attachment_id":24443,"attachment":{"id":24443,"key":24443,"name":"7ca8de9b-9d89-33ac-be1e-2f4e0f9ba80e","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/7ca8de9b-9d89-33ac-be1e-2f4e0f9ba80e\/202503070068_25432000000029796062.pdf","orig_name":"202503070068_25432000000029796062.pdf"}}]}],"contractScans":[{"id":32730,"object_type":108,"object_id":3818,"attachment_id":24436,"attachment":{"id":24436,"key":24436,"name":"3fed5de7-dbea-3b2f-b985-1773504f1261","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/3fed5de7-dbea-3b2f-b985-1773504f1261\/PO(8740)3335442943428841670.pdf","orig_name":"PO(8740)3335442943428841670.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":983,"user_id":1011,"key":1011,"contract_id":3818,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":984,"user_id":5360,"key":5360,"contract_id":3818,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":601,"key":601,"contract_id":3818,"name":"2025-03-07","value":"3500","overdue_days":0,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1689,"client_id":918,"project_id":3666,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-03-07 09:58:39","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u571f\u6728\u9879\u76ee\u4e2d55\u53f0\u670d\u52a1\u5668\u7aefEDR\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe53500\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u957f\u6c99\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u9ad8\u65b0\u652f\u884c\n810000194191000001\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-07 09:58:32","updated_at":"2025-03-07 09:58:39","supplier_id":684,"purchase_contract_id":3818,"amount":"3500","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"costContractAmounts":[],"unreadComments":null,"invoiced":3500,"approve_amount":3500,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":3500,"un_collected":0,"collected_plan":3500,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3817,"supplier_id":534,"contract_type":3,"signed_at":"2025-03-06","amount":"31000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-03-07 09:42:23","updated_at":"2025-03-07 09:42:59","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"2025022801-TSZHY5","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 09:42:59.885037+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3817,"comment":1},"purchaseClientRels":[{"id":3070,"contract_id":3817,"client_id":93,"project_id":3699,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1005,"clickable":1},"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[{"id":32722,"object_type":108,"object_id":3817,"attachment_id":24430,"attachment":{"id":24430,"key":24430,"name":"fec2c8b7-b47b-3bcd-a616-59c1beab1e82","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/fec2c8b7-b47b-3bcd-a616-59c1beab1e82\/\u62d3\u5b9e \u53cc\u7ae0 \u6280\u672f\u670d\u52a1\u5408\u540c20250228-TSZHY5.pdf","orig_name":"\u62d3\u5b9e \u53cc\u7ae0 \u6280\u672f\u670d\u52a1\u5408\u540c20250228-TSZHY5.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":981,"user_id":1011,"key":1011,"contract_id":3817,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":982,"user_id":5360,"key":5360,"contract_id":3817,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":600,"key":600,"contract_id":3817,"name":"2025-04-07","value":"31000","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f91\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":0,"approve_amount":0,"un_approve_amount":31000,"un_invoiced":31000,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":0,"un_collected":31000,"collected_plan":31000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3814,"supplier_id":678,"contract_type":1,"signed_at":"2025-03-06","amount":"1300.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-03-06 11:37:44","updated_at":"2025-03-06 11:38:00","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"YTYG20250306","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-06 11:38:00.265795+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3814,"comment":1},"purchaseClientRels":[{"id":3094,"contract_id":3814,"client_id":531,"project_id":3791,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311,"clickable":1},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2159,"key":2159,"contract_id":3814,"amount":"1300","value":"1300","attachment_id":null,"from_date":"2025-03-07","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32724,"object_type":103,"object_id":2159,"attachment_id":24431,"attachment":{"id":24431,"key":24431,"name":"f04d687d-20c2-33ad-a621-60804da281e2","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/f04d687d-20c2-33ad-a621-60804da281e2\/dzfp_25112000000045378206_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250307093845(1).pdf","orig_name":"dzfp_25112000000045378206_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250307093845(1).pdf"}}]}],"contractScans":[{"id":32704,"object_type":108,"object_id":3814,"attachment_id":24416,"attachment":{"id":24416,"key":24416,"name":"2db63238-2bf8-3e36-a32c-af27a28d3e9f","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/2db63238-2bf8-3e36-a32c-af27a28d3e9f\/\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf\u53cc\u7ae0\u5408\u540c1300\u5143.pdf","orig_name":"\u62d3\u5b9e-\u667a\u9886\u8d8b\u52bf\u53cc\u7ae0\u5408\u540c1300\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":977,"user_id":1011,"key":1011,"contract_id":3814,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":978,"user_id":5360,"key":5360,"contract_id":3814,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":598,"key":598,"contract_id":3814,"name":"2025-04-07","value":"1300","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f91\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":1300,"approve_amount":0,"un_approve_amount":1300,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":1300,"collected_plan":1300,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3810,"supplier_id":489,"contract_type":1,"signed_at":"2025-03-05","amount":"1000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-03-05 14:34:26","updated_at":"2025-03-05 14:34:39","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250305-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-05 14:34:39.512905+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3810,"comment":1},"purchaseClientRels":[{"id":3079,"contract_id":3810,"client_id":4,"project_id":3789,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","sales_rep":5300,"clickable":1},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":973,"user_id":1011,"key":1011,"contract_id":3810,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":974,"user_id":5360,"key":5360,"contract_id":3810,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":596,"key":596,"contract_id":3810,"name":"2025-04-04","value":"1000","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f94\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":0,"approve_amount":0,"un_approve_amount":1000,"un_invoiced":1000,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":1000,"collected_plan":1000,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3813,"supplier_id":81,"contract_type":1,"signed_at":"2025-03-04","amount":"300.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-03-06 09:36:20","updated_at":"2025-03-06 09:36:35","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250304-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-06 09:36:35.475788+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3813,"comment":1},"purchaseClientRels":[{"id":3077,"contract_id":3813,"client_id":20,"project_id":3792,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","sales_rep":1005,"clickable":1},"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2156,"key":2156,"contract_id":3813,"amount":"300","value":"300","attachment_id":null,"from_date":"2025-03-06","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32689,"object_type":103,"object_id":2156,"attachment_id":24407,"attachment":{"id":24407,"key":24407,"name":"898bc533-61b4-357b-95d5-c6dde7c83a26","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/898bc533-61b4-357b-95d5-c6dde7c83a26\/dzfp_25112000000044427279_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250306092501(1).pdf","orig_name":"dzfp_25112000000044427279_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250306092501(1).pdf"}}]}],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":975,"user_id":1011,"key":1011,"contract_id":3813,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":976,"user_id":5360,"key":5360,"contract_id":3813,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":597,"key":597,"contract_id":3813,"name":"2025-04-04","value":"300","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f94\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":300,"approve_amount":0,"un_approve_amount":300,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":300,"collected_plan":300,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3806,"supplier_id":59,"contract_type":1,"signed_at":"2025-03-03","amount":"800.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-03-04 09:39:32","updated_at":"2025-03-11 13:25:18","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TGXC20250303-1","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-04 09:39:45.167064+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3806,"comment":1},"purchaseClientRels":[{"id":3089,"contract_id":3806,"client_id":518,"project_id":3788,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2170,"key":2170,"contract_id":3806,"amount":"800","value":"800","attachment_id":null,"from_date":"2025-03-11","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32835,"object_type":103,"object_id":2170,"attachment_id":24504,"attachment":{"id":24504,"key":24504,"name":"29dcc02e-8721-31ae-81b2-c99cecfb677e","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/29dcc02e-8721-31ae-81b2-c99cecfb677e\/\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.11\uff08800\u5143\uff09.pdf","orig_name":"\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.11\uff08800\u5143\uff09.pdf"}}]}],"contractScans":[{"id":32815,"object_type":108,"object_id":3806,"attachment_id":24492,"attachment":{"id":24492,"key":24492,"name":"8cc43939-d5a9-3d1a-ae3e-8f160be7dab0","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/8cc43939-d5a9-3d1a-ae3e-8f160be7dab0\/2025_03_11_13_23_30.pdf","orig_name":"2025_03_11_13_23_30.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":969,"user_id":1011,"key":1011,"contract_id":3806,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":970,"user_id":5360,"key":5360,"contract_id":3806,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":594,"key":594,"contract_id":3806,"name":"2025-04-03","value":"800","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f95\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":800,"approve_amount":0,"un_approve_amount":800,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":800,"collected_plan":800,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3804,"supplier_id":90,"contract_type":1,"signed_at":"2025-02-28","amount":"2987240.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-02-28 17:39:38","updated_at":"2025-03-04 14:06:13","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2025SBQ03860","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 17:41:00.380205+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3804,"comment":4},"purchaseClientRels":[],"purchaseContractPayments":[{"id":2082,"key":2082,"contract_id":3804,"value":"1.00","collected_date":"2025-04-29","created_at":"2025-04-29 15:51:15","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":0},{"id":2083,"key":2083,"contract_id":3804,"value":"1.00","collected_date":"2025-04-21","created_at":"2025-04-29 15:51:22","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[],"approves":[],"pct":0},{"id":2092,"key":2092,"contract_id":3804,"value":"-2","collected_date":"2025-05-08","created_at":"2025-05-08 09:31:27","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"files":[{"id":33032,"object_type":110,"object_id":2092,"attachment_id":24676,"attachment":{"id":24676,"key":24676,"name":"87486f5b-e5dd-368d-ba44-16a05a178b93","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/87486f5b-e5dd-368d-ba44-16a05a178b93\/77.png","orig_name":"77.png"}}],"approves":[],"pct":-0}],"purchaseContractInvoices":[{"id":2153,"key":2153,"contract_id":3804,"amount":"2987240","value":"2987240","attachment_id":null,"from_date":"2025-02-28","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32697,"object_type":103,"object_id":2153,"attachment_id":24350,"attachment":{"id":24350,"key":24350,"name":"ab60b7c3-d45c-3842-bec8-5e6487d01800","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/ab60b7c3-d45c-3842-bec8-5e6487d01800\/25122000000012707968_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"25122000000012707968_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}]}],"contractScans":[{"id":32655,"object_type":108,"object_id":3804,"attachment_id":24374,"attachment":{"id":24374,"key":24374,"name":"185a770c-fb97-3bb1-ab6b-4aeeef74825c","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/185a770c-fb97-3bb1-ab6b-4aeeef74825c\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":32612,"object_type":111,"object_id":3804,"attachment_id":24352,"attachment":{"id":24352,"key":24352,"name":"6509fe1e-12a7-3d14-afeb-de851a1872c3","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/6509fe1e-12a7-3d14-afeb-de851a1872c3\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":967,"user_id":1011,"key":1011,"contract_id":3804,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":968,"user_id":5360,"key":5360,"contract_id":3804,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":593,"key":593,"contract_id":3804,"name":"2025-04-14","value":"2987240","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f84\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":2987240,"approve_amount":0,"un_approve_amount":2987240,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":2987240,"collected_plan":2987240,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3802,"supplier_id":668,"contract_type":3,"signed_at":"2025-02-28","amount":"3000.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-02-28 10:50:02","updated_at":"2025-02-28 13:21:53","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250228-HYF-002","payment_collection_remind_ahead":"","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-02-28 10:50:11.824878+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":668,"key":668,"name":"\u9ec4\u5d58"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3802,"comment":2},"purchaseClientRels":[{"id":3043,"contract_id":3802,"client_id":3270,"project_id":3583,"client":{"id":3270,"key":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":5087,"clickable":1},"project":{"id":3583,"key":3583,"name":"\u670d\u52a1\u8d39-K","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":2071,"key":2071,"contract_id":3802,"value":"3000.00","collected_date":"2025-03-05","created_at":"2025-03-05 14:37:21","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32676,"object_type":110,"object_id":2071,"attachment_id":24397,"attachment":{"id":24397,"key":24397,"name":"220c1486-a268-376f-9d48-98c3bad1da6e","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/220c1486-a268-376f-9d48-98c3bad1da6e\/image.png","orig_name":"image.png"}}],"approves":[{"id":1669,"client_id":3270,"project_id":3583,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u9ec4\u5d58","status":2,"next_verify_user":null,"verify_at":"2025-03-03 15:33:07","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u670d\u52a1\u8d39\u91d1\u989d\uff1a\uffe53000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u62db\u5546\u94f6\u884c\u200b \u5361\u53f7\uff1a6226 0901 0518 1958 \u62db\u884c\u5317\u4eac\u5efa\u56fd\u8def\u652f\u884c \u9ec4\u5d58\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:49","updated_at":"2025-03-03 15:33:07","supplier_id":668,"purchase_contract_id":3802,"amount":"3000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"pct":100}],"purchaseContractInvoices":[],"contractScans":[{"id":32569,"object_type":108,"object_id":3802,"attachment_id":24321,"attachment":{"id":24321,"key":24321,"name":"d4213b45-3b73-3479-8e37-d7c704b30d16","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/d4213b45-3b73-3479-8e37-d7c704b30d16\/\u6280\u672f\u670d\u52a1\u534f\u8bae-20250228-Scan.pdf","orig_name":"\u6280\u672f\u670d\u52a1\u534f\u8bae-20250228-Scan.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":963,"user_id":1011,"key":1011,"contract_id":3802,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":964,"user_id":5360,"key":5360,"contract_id":3802,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":590,"key":590,"contract_id":3802,"name":"2025-03-07","value":"3000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1669,"client_id":3270,"project_id":3583,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u9ec4\u5d58","status":2,"next_verify_user":null,"verify_at":"2025-03-03 15:33:07","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u670d\u52a1\u8d39\u91d1\u989d\uff1a\uffe53000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u62db\u5546\u94f6\u884c\u200b \u5361\u53f7\uff1a6226 0901 0518 1958 \u62db\u884c\u5317\u4eac\u5efa\u56fd\u8def\u652f\u884c \u9ec4\u5d58\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:49","updated_at":"2025-03-03 15:33:07","supplier_id":668,"purchase_contract_id":3802,"amount":"3000","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"costContractAmounts":[],"unreadComments":null,"invoiced":0,"approve_amount":3000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":3000,"un_collected":0,"collected_plan":3000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3801,"supplier_id":223,"contract_type":1,"signed_at":"2025-02-28","amount":"12919.00","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-02-28 10:49:09","updated_at":"2025-03-05 09:15:46","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"WYY-ZC-2025022801-BJJX","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 10:49:24.601955+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":3801,"comment":2},"purchaseClientRels":[{"id":3058,"contract_id":3801,"client_id":189,"project_id":3770,"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","sales_rep":5295,"clickable":1},"project":{"id":3770,"key":3770,"name":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6","project_status":3,"clickable":1}}],"purchaseContractPayments":[{"id":2068,"key":2068,"contract_id":3801,"value":"12919.00","collected_date":"2025-03-03","created_at":"2025-03-03 16:11:48","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32613,"object_type":110,"object_id":2068,"attachment_id":24353,"attachment":{"id":24353,"key":24353,"name":"dcd13f21-9f6f-35f3-a204-2c6cb6bafa62","extension":"png","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/dcd13f21-9f6f-35f3-a204-2c6cb6bafa62\/image.png","orig_name":"image.png"}}],"approves":[{"id":1668,"client_id":189,"project_id":3770,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-03-03 15:33:15","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5353\u8c6a\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe512919\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6536\u6b3e\u4eba\u540d\u79f0\uff1a\u5353\u8c6a\uff08\u4e2d\u56fd\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u94f6\u884c\u6d77\u6dc0\u533a\u652f\u884c\u8425\u4e1a\u90e8\n\u8d26\u53f7\uff1a329856019711\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:25","updated_at":"2025-03-03 15:33:15","supplier_id":223,"purchase_contract_id":3801,"amount":"12919","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"pct":100}],"purchaseContractInvoices":[{"id":2162,"key":2162,"contract_id":3801,"amount":"12919","value":"12919","attachment_id":null,"from_date":"2025-03-05","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32798,"object_type":103,"object_id":2162,"attachment_id":24481,"attachment":{"id":24481,"key":24481,"name":"27a02320-99ea-34fe-b385-67e07cd7d347","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/27a02320-99ea-34fe-b385-67e07cd7d347\/dzfp_25112000000044105879_\u25ca\u00f8\u222b\u00bf\u00a3\u00ae\u00f7\u2013\u03c0\u02d9\u00a3\u00a9\u00ba\u00ba\u00a0\u0131\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20250305163028.pdf","orig_name":"dzfp_25112000000044105879_\u25ca\u00f8\u222b\u00bf\u00a3\u00ae\u00f7\u2013\u03c0\u02d9\u00a3\u00a9\u00ba\u00ba\u00a0\u0131\u201d\u2013\u0153\ufb01\u03c0\u00b4A\u0300\u00e6_20250305163028.pdf"}}]}],"contractScans":[{"id":32663,"object_type":108,"object_id":3801,"attachment_id":24382,"attachment":{"id":24382,"key":24382,"name":"1afa7cb2-3c10-35c8-a6e9-d6c10386c484","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/1afa7cb2-3c10-35c8-a6e9-d6c10386c484\/2025_03_05_09_11_24.pdf","orig_name":"2025_03_05_09_11_24.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":961,"user_id":1011,"key":1011,"contract_id":3801,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":962,"user_id":5360,"key":5360,"contract_id":3801,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":589,"key":589,"contract_id":3801,"name":"2025-03-04","value":"12919","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":1668,"client_id":189,"project_id":3770,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-03-03 15:33:15","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5353\u8c6a\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe512919\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6536\u6b3e\u4eba\u540d\u79f0\uff1a\u5353\u8c6a\uff08\u4e2d\u56fd\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u94f6\u884c\u6d77\u6dc0\u533a\u652f\u884c\u8425\u4e1a\u90e8\n\u8d26\u53f7\uff1a329856019711\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u3002","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-03-03 15:20:25","updated_at":"2025-03-03 15:33:15","supplier_id":223,"purchase_contract_id":3801,"amount":"12919","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null}],"costContractAmounts":[],"unreadComments":null,"invoiced":12919,"approve_amount":12919,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":12919,"un_collected":0,"collected_plan":12919,"is_collected":true,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"},{"id":3800,"supplier_id":618,"contract_type":1,"signed_at":"2025-02-28","amount":"9155.00","handler":5360,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-02-28 09:33:10","updated_at":"2025-02-28 09:35:29","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20250228-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 09:33:22.643253+08","is_chargeback":false,"cost_type":1,"client":null,"project":null,"supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}},"commentCount":{"object_id":3800,"comment":1},"purchaseClientRels":[{"id":3052,"contract_id":3800,"client_id":2546,"project_id":3785,"client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"clickable":1},"project":{"id":3785,"key":3785,"name":"2025\u65b0\u8d2dUPS","project_status":3,"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2155,"key":2155,"contract_id":3800,"amount":"9155","value":"9155","attachment_id":null,"from_date":"2025-03-05","description":"","is_draft":false,"attachment":null,"attachmentRelationships":[],"files":[{"id":32685,"object_type":103,"object_id":2155,"attachment_id":24406,"attachment":{"id":24406,"key":24406,"name":"448ce081-ce73-34ec-885b-f40978493759","extension":"pdf","path":"\/v2\/attachment\/view\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/448ce081-ce73-34ec-885b-f40978493759\/20250305_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25112000000044291569_9155.00\u526f\u672c.pdf","orig_name":"20250305_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25112000000044291569_9155.00\u526f\u672c.pdf"}}]}],"contractScans":[{"id":32561,"object_type":108,"object_id":3800,"attachment_id":24317,"attachment":{"id":24317,"key":24317,"name":"340f1ff3-6b24-3dd3-b110-040de46123ce","extension":"pdf","path":"\/v2\/attachment\/preview\/Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd\/340f1ff3-6b24-3dd3-b110-040de46123ce\/\u62d3\u5b9e-\u6052\u6cf0\u6b63\u5b87UPS\u5408\u540c20250228.pdf","orig_name":"\u62d3\u5b9e-\u6052\u6cf0\u6b63\u5b87UPS\u5408\u540c20250228.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":959,"user_id":1011,"key":1011,"contract_id":3800,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":960,"user_id":5360,"key":5360,"contract_id":3800,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":588,"key":588,"contract_id":3800,"name":"2025-03-25","value":"9155","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f104\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"invoiced":9155,"approve_amount":0,"un_approve_amount":9155,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":0,"un_collected":9155,"collected_plan":9155,"is_collected":false,"can_update":true,"can_update_cost":false,"can_delete":true,"unread":0,"bgcolor":"#89c541"}],"pagenation":{"totalcount":1874,"thispage":2,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-07 17:31:14') RETURNING "id"
17:31:14.8751.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:31:14.9391.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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) GROUP BY "r"."id"
17:31:14.9271.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (2068, 2071, 2072, 2082, 2083, 2092))
17:31:14.9341.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800))
17:31:14.9321.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2153, 2155, 2156, 2159, 2160, 2162, 2170))
17:31:14.9311.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2153, 2155, 2156, 2159, 2160, 2162, 2170))
17:31:14.9351.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800))
17:31:14.8811.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:31:14.9410.6 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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)) ORDER BY "id"
17:31:14.9300.6 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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "id"
17:31:14.9260.6 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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "id"
17:31:14.9250.5 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3583, 3785, 3770, 3699, 3666, 3792, 3789, 3788, 3791)
17:31:14.9290.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id" IN (1668, 1669, 1689)
17:31:14.9240.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "id"
17:31:14.9280.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24353, 24397, 24435, 24676)
17:31:14.9030.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, 5360))
17:31:14.9370.4 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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800)
17:31:14.9020.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (684, 534, 678, 489, 81, 59, 90, 668, 223, 618)
17:31:14.9380.4 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 (3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "remind_date"
17:31:14.9250.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3270, 2546, 189, 93, 918, 20, 4, 518, 531)
17:31:14.9030.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
17:31:14.9290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_approve_rels" WHERE "purchase_contract_payment_id" IN (2068, 2071, 2072, 2082, 2083, 2092)
17:31:14.9270.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001)
17:31:14.9020.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
17:31:14.9040.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
17:31:14.9350.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24317, 24321, 24374, 24382, 24416, 24430, 24436, 24492)
17:31:14.9040.2 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, 5360))
17:31:14.9330.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24406, 24407, 24350, 24431, 24443, 24481, 24504)
17:31:14.9380.2 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, 5360))
17:31:14.9370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
17:31:14.9370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24352