ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a53b4b503365: POST https://beta.jinchangxiao.com/v2/approve/list at 2026-07-12 11:37:25 pm by 223.74.191.180

Performance Profiling

Total processing time: 234 ms; Peak memory: 5.772 MB. Show Profiling Timeline

总计54条数据
TimeDurationCategoryInfo
  
23:37:25.13834.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)) GROUP BY "object_id"
23:37:25.10131.8 msyii\db\Command::querySELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476, 5499, 5500)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC LIMIT 10 OFFSET 20
23:37:25.07623.9 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476, 5499, 5500)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC) "c"
23:37:25.05222.7 msyii\db\Command::querySELECT count(object_id) as count FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_approves" "r" ON uc.object_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE (object_id = r.id) AND ("object_type"=37) AND ("remind_user_id"=1001) AND ("rccr"."user_id"=1001) AND ("is_read"=FALSE) AND ("r"."status" != '0') GROUP BY "object_id"
23:37:25.17319.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND ("remind_user_id"=1001) AND ("is_read"=FALSE) AND ("object_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)) GROUP BY "object_id"
23:37:25.03119.1 msyii\db\Command::querySELECT count(*) as count, sum(case when "sub".status=1 then 1 else 0 end) countStatus1, sum(case when "sub".status=2 then 1 else 0 end) countStatus2, sum(case when "sub".status=4 then 1 else 0 end) countStatus4 FROM (SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476, 5499, 5500)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) GROUP BY "r"."id") "sub"
23:37:25.2013.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (3695, 3696, 3697, 3699, 3700, 3711, 3712, 3714, 3720, 3722, 3726))
23:37:25.2393.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 7, 179, 'v2/approve/list', '{"ApproveSearch":{"filter":"","status":"","form_department":"","form_approveVerifyRels":"","form_type":"","created_at_period":"","verify_at_period":"","created_by":"","borrow_collect_status":""},"page":"3","pagesize":"10","posttime":"1783870644","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"179","token":"8e786dc082078c03b36072dd45ced916"}', '{"code":200,"data":{"list":[{"id":2753,"client_id":3432,"project_id":4079,"title":"\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c","status":4,"next_verify_user":"","verify_at":"2026-05-09 17:09:24","description":"\u597d\u653e\u5047\u653e\u5047","refuse_description":"","is_resubmited":false,"created_by":5300,"created_at":"2026-04-14 13:37:34","updated_at":"2026-05-09 17:09:24","supplier_id":287,"purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2753,"comment":8},"unreadComments":{},"type":{"id":315,"name":"\u63d0\u524d\u5f00\u53d1\u7968\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1011,5360,5252"},"approveCarbonCopyRels":[{"id":9641,"approve_id":2753,"user_id":1011,"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":9642,"approve_id":2753,"user_id":5360,"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"}}},{"id":9643,"approve_id":2753,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3726,"approve_id":2753,"user_id":1001,"status":2,"description":"","verify_at":"2026-05-09 17:09:24","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3726,"approve_id":2753,"user_id":1001,"status":2,"description":"","verify_at":"2026-05-09 17:09:24"},"attachmentRelationships":[{"id":57619,"object_type":28,"object_id":2753,"attachment_id":32665,"attachment":{"id":32665,"key":32665,"name":"62d49e35-69d1-320f-9cd5-ba916cc0d474","extension":"jpg","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/62d49e35-69d1-320f-9cd5-ba916cc0d474\/\u91d1\u7545\u900dERP\u843d\u5730\u9875.jpg","orig_name":"\u91d1\u7545\u900dERP\u843d\u5730\u9875.jpg"}}],"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"project":{"id":4079,"key":4079,"name":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee","project_status":3,"buildContract":{"id":4324,"from_project":4079,"serial_no":"2025-12-19-002"}},"supplier":{"id":287,"key":287,"name":"\u73e0\u6d77\u5954\u56fe\u7535\u5b50\u6709\u9650\u516c\u53f8"},"purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[{"id":57620,"object_type":29,"object_id":2753,"attachment_id":32666,"attachment":{"id":32666,"key":32666,"name":"0a7f3cfe-8890-374e-9c90-797277b22296","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/0a7f3cfe-8890-374e-9c90-797277b22296\/\u4ea7\u54c1\u9009\u62e9\u4e0b\u62c9.png","orig_name":"\u4ea7\u54c1\u9009\u62e9\u4e0b\u62c9.png"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#FFE5E5","fgcolor":"#FF0101","status_display":"\u5df2\u62d2\u7edd","borrow_expire_day":""},{"id":2758,"client_id":"","project_id":"","title":"\u5ba1\u6279\u7ba1\u7406\u6807\u9898\u6807\u9898\uff0c\u5ba1\u6279\u5185\u5bb9\u5ba1\u6279\u5185\u5bb9\u3001\u5ba2\u6237\u540d\u79f0\u3001\u5546\u673a\u540d\u79f0\u662f\u5e76\u884c\u542c\u5199\u5185\u5bb9\u3002\u4e0d\u8981\u6025\u4e0d\u8981\u6025\u4e0d\u8981\u6025\u3002","status":2,"next_verify_user":"","verify_at":"2026-05-09 10:44:51","description":"\u8fdb\u5165\u7533\u8bf7\u8fdb\u5165\u7533\u8bf7\u3002\u8fdb\u5165\u3002\u7533\u8bf7\u4e86\u4e86\u7533\u8bf7\u4e86\u3002","refuse_description":"","is_resubmited":false,"created_by":1000,"created_at":"2026-04-17 12:01:24","updated_at":"2026-05-09 10:44:51","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2758,"comment":4},"unreadComments":{},"type":{"id":319,"name":"\u6b63\u5e38\u5f00\u7968","approve_verify_user":"1011","approve_carbon_copy_user":"5360,5252"},"approveCarbonCopyRels":[{"id":9626,"approve_id":2758,"user_id":5360,"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"}}},{"id":9627,"approve_id":2758,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3714,"approve_id":2758,"user_id":1011,"status":1,"description":"","verify_at":"2026-05-09 10:44:51","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"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3714,"approve_id":2758,"user_id":1011,"status":1,"description":"","verify_at":"2026-05-09 10:44:51"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2765,"client_id":982,"project_id":1111,"title":"\u597d\u597d\u7684\u597d\u7684\u597d","status":2,"next_verify_user":"","verify_at":"2026-04-30 13:54:42","description":"\u597d\u597d\u5982\u4f55\u53d1\u6325","refuse_description":"","is_resubmited":false,"created_by":1000,"created_at":"2026-04-30 13:53:55","updated_at":"2026-04-30 13:54:42","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2765,"comment":1},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":9639,"approve_id":2765,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3722,"approve_id":2765,"user_id":1000,"status":1,"description":"","verify_at":"2026-04-30 13:54:42","user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3722,"approve_id":2765,"user_id":1000,"status":1,"description":"","verify_at":"2026-04-30 13:54:42"},"attachmentRelationships":[{"id":57615,"object_type":28,"object_id":2765,"attachment_id":32662,"attachment":{"id":32662,"key":32662,"name":"8e16456e-abc1-32cb-a6d6-f3b97ee31ad0","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/8e16456e-abc1-32cb-a6d6-f3b97ee31ad0\/20260430135349.png","orig_name":"20260430135349.png"}}],"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":1111,"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf","project_status":3,"buildContract":{"id":1186,"from_project":1111,"serial_no":"DX190911WLQ01 "}},"supplier":"","purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2756,"client_id":3435,"project_id":4111,"title":"\u6d4b\u8bd5\uff0c\u4e0d\u8981\u4fee\u6539\u72b6\u6001\uff0c\u4e0d\u8981\u901a\u8fc7\u5ba1\u6279","status":2,"next_verify_user":"","verify_at":"2026-04-30 13:48:32","description":"\u6d3b\u7684\u597d\u597d\u7684\u8fd8","refuse_description":"","is_resubmited":false,"created_by":1000,"created_at":"2026-04-16 11:02:21","updated_at":"2026-04-30 13:48:32","supplier_id":45,"purchase_contract_id":4460,"amount":"","borrow_amount":"999","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"999","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2756,"comment":2},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,5252"},"approveCarbonCopyRels":[{"id":9634,"approve_id":2756,"user_id":1013,"user":{"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"}}},{"id":9635,"approve_id":2756,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3720,"approve_id":2756,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-30 13:48:32","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3720,"approve_id":2756,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-30 13:48:32"},"attachmentRelationships":[{"id":57593,"object_type":28,"object_id":2756,"attachment_id":32651,"attachment":{"id":32651,"key":32651,"name":"eaa72b05-2175-312c-ada8-72d8cf827542","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/eaa72b05-2175-312c-ada8-72d8cf827542\/ChatGPT Image 2026\u5e744\u670829\u65e5 09_09_24.png","orig_name":"ChatGPT Image 2026\u5e744\u670829\u65e5 09_09_24.png"}}],"client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":4111,"key":4111,"name":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","project_status":3,"buildContract":{"id":4388,"from_project":4111,"serial_no":"JCX-ZHY-2025110101"}},"supplier":{"id":45,"key":45,"name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4460,"key":4460,"name":"\u91cd\u65b0\u63d0\u4ea44-22","handler":1011,"cost_type":1,"erp_un_settle_amount":"445","created_at":"2026-04-13 10:09:29","amount":"445","serial_no":"\u91cd\u65b0\u63d0\u4ea44-22","is_verify":true,"is_edit_verify":false,"is_chargeback_verify":false,"purchaseContractPaymentCollectionRemindDates":[],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[{"id":57594,"object_type":29,"object_id":2756,"attachment_id":32652,"attachment":{"id":32652,"key":32652,"name":"5bc2e771-81d8-3e85-b5c9-3d2f19a26c29","extension":"jpg","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/5bc2e771-81d8-3e85-b5c9-3d2f19a26c29\/\u91d1\u7545\u900dERP\u843d\u5730\u9875.jpg","orig_name":"\u91d1\u7545\u900dERP\u843d\u5730\u9875.jpg"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[{"id":27,"erp_other_collect_ticket_id":54,"approve_id":2756,"amount":"","description":""}],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":true,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":true,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2755,"client_id":3454,"project_id":"","title":"21321","status":2,"next_verify_user":"","verify_at":"2026-04-16 10:36:45","description":"213213","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-04-16 10:36:39","updated_at":"2026-04-16 10:36:45","supplier_id":125,"purchase_contract_id":"","amount":"123213","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"123213","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":2755,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3712,"approve_id":2755,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 10:36:45","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3712,"approve_id":2755,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 10:36:45"},"attachmentRelationships":[],"client":{"id":3454,"key":3454,"name":"\u7a37\u5c71\u53bf\u5b89\u536b\u58eb\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{},"supplier":{"id":125,"key":125,"name":"\u5929\u6d25\u5e02\u8fbe\u6069\u534e\u5929\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2749,"client_id":"","project_id":"","title":"\u6d4b\u662f\u65b0\u5efa\u5ba1\u6279\u5ba2\u6237\u540d\u79f0\u5546\u673a\u540d\u79f0\u5ba1\u6279\u4f60\u90a3\u6ca1\u6709\u4ed6\u8bf4\u55ef\u662f\u70b9\u524d\u9762\u90a3\u4e2a\u5b58\u8349\u7684\u6309\u94ae\u7279\u957f\u4e86\u5176\u5b9e\u5e94\u8be5\u76f4\u63a5\u6210\u4ece\u4e00\u9003\u7a3f\u5c31\u5b8c\u4e8b\u4e86\u662f\u63d0\u793a\u5427\u5e94\u8be5\u5c31\u662f\u5c31\u662f\u63d0\u9192\u524d\u4e0d\u8981\u544a\u4ed6\u4e00\u58f0\u4ed6\u542c\u4e0d\u7b11\u7684\u662f\u4e0a\u5e02\u770b\u4e00\u4e0b\u5443\u7f51\u9875\u4e0a\u4e0d\u63d0\u9192\u7f51\u9875\u6211\u8981\u70b9\u4fdd\u5b58\u7684\u4ed3\u554a\u4ed6\u5c31\u76f4\u63a5\u5b58\u4e0a\u4e86\u5bf9\u6d4b\u8bd5\u6807\u9898\u6807\u9898\uff0c\u6d4b\u8bd5\u5207\u6765\u5207\u53bb\u3002\u7f16\u8f91\u5ba1\u6279\u6d4b\u8bd5\u3002\u54e6\uff0c\u7f16\u8f91\u5ba1\u6279\u6d4b\u8bd5\uff0c\u6211\u70b9\u4e00\u4e0b\u6682\u505c\u6587\u6848\u624d\u4f1a\u7cbe\u51c6\u3002\u5207\u6362\u8bed\u97f3\u4f4d\u7f6e\u3002","status":2,"next_verify_user":"","verify_at":"2026-04-16 10:31:09","description":"\u54c7\uff0c\u54e6\u6211\u7adf\u7136\u4e24\u4e2a\u90fd\u80fd\u540c\u65f6\u5f55\u97f3\u3002\u7533\u8bf7\u5185\u5bb9\u6d4b\u8bd5\u3002ok ok\u95ea\u7247\u4eba\u95ea\u53ef\u4eba\u8fd8\u53ef\u4ee5\u3002\u54b3\u55fd\u54b3\u55fd\u54b3\u55fd\u54b3\u55fd\u597d\u50cf\u559c\u6b22\u4ed6\u4eca\u5929\u8981\u5f00\u6ca1\u770b\u89c1\u8ddf\u90a3\u5929\u633a\u50cf\u4eca\u5929\u53c2\u7684\u5c0f\u5c0f\u516c\u4e3b\u88d9\u55ef\u6211\u89c9\u5f97\u5c31\u662f\u7684\u90a3\u4e2a\u7ecf\u7406\u4e86\u611f\u89c9\u53ef\u4ee5\u7684\u540d\u6211\u4f30\u8ba1\u770b\u5230\u56de\u6765\u56de\u5730\u53d8\u56e0\u7559\u5728\u6211\u7ed9\u4ed6\u8ba9\u4ed6\u542c\u5199\u55ef\uff0c\u7f16\u8f91\u5f55\u97f3\u529f\u80fd\u6d4b\u8bd5\u55ef\u3002\u539f\u6765\u662f\u8fd9\u4e2a\u6837\u5b50\u3002","refuse_description":"","is_resubmited":false,"created_by":5064,"created_at":"2026-04-13 14:25:00","updated_at":"2026-04-16 10:31:09","supplier_id":45,"purchase_contract_id":4458,"amount":"","borrow_amount":"500","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"500","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2749,"comment":27},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,5252"},"approveCarbonCopyRels":[{"id":9622,"approve_id":2749,"user_id":1013,"user":{"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"}}},{"id":9623,"approve_id":2749,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3711,"approve_id":2749,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 10:31:09","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3711,"approve_id":2749,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 10:31:09"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":45,"key":45,"name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4458,"key":4458,"name":"\u6d4b\u8bd5\u62d2\u7edd\u540e\u7684\u72b6\u6001","handler":1011,"cost_type":1,"erp_un_settle_amount":"3","created_at":"2026-04-10 09:54:33","amount":"3","serial_no":"\u6d4b\u8bd5\u62d2\u7edd\u540e\u7684\u72b6\u6001","is_verify":false,"is_edit_verify":false,"is_chargeback_verify":false,"purchaseContractPaymentCollectionRemindDates":[],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":true,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":true,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2746,"client_id":3432,"project_id":4078,"title":"\u6d4b\u8bd5\u501f\u6b3e\u7533\u8bf7\u4ea4\u8868","status":2,"next_verify_user":"","verify_at":"2026-04-01 13:50:28","description":"\u6d4b","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-04-01 13:50:24","updated_at":"2026-04-01 13:50:28","supplier_id":45,"purchase_contract_id":"","amount":"","borrow_amount":"50000","borrow_collect_day":"2026-04-30","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"50000","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":2746,"comment":1},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,5252"},"approveCarbonCopyRels":[{"id":9605,"approve_id":2746,"user_id":1013,"user":{"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"}}},{"id":9606,"approve_id":2746,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3700,"approve_id":2746,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-01 13:50:28","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3700,"approve_id":2746,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-01 13:50:28"},"attachmentRelationships":[],"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"project":{"id":4078,"key":4078,"name":"2025\u5e74\u6c11\u94f6\u884c\u5b89\u5168\u80fd\u529b\u5efa\u8bbe\u9879\u76ee","project_status":3,"buildContract":{"id":4323,"from_project":4078,"serial_no":"2025-12-19-001"}},"supplier":{"id":45,"key":45,"name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[{"id":28,"erp_other_collect_ticket_id":54,"approve_id":2746,"amount":"50000","description":""}],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":true,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2745,"client_id":"","project_id":"","title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d","status":2,"next_verify_user":"","verify_at":"2026-03-26 17:43:09","description":"\u9886\u5bfc\uff0c\u4f60\u597d\uff1a\n\n \u9700\u8981\u5411\u5382\u5546\u652f\u4ed8\u5230\u671f\u8d27\u6b3e\uff0c\u8bf7\u5ba1\u6279\uff01","refuse_description":"","is_resubmited":false,"created_by":1005,"created_at":"2026-03-26 17:41:08","updated_at":"2026-03-26 17:43:09","supplier_id":138,"purchase_contract_id":4449,"amount":"50000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"50000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"50000","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2745,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":9604,"approve_id":2745,"user_id":1011,"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"}}}],"approveVerifyRels":[{"id":3699,"approve_id":2745,"user_id":1005,"status":1,"description":"","verify_at":"2026-03-26 17:43:09","user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3699,"approve_id":2745,"user_id":1005,"status":1,"description":"","verify_at":"2026-03-26 17:43:09"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d \u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4449,"key":4449,"name":"SXF20260326","handler":1011,"cost_type":1,"erp_un_settle_amount":"0","created_at":"2026-03-26 17:29:10","amount":"100000.00","serial_no":"SXF20260326","is_verify":false,"is_edit_verify":false,"is_chargeback_verify":false,"purchaseContractPaymentCollectionRemindDates":[{"id":1132,"key":1132,"contract_id":4449,"name":"2026-03-28","value":"50000","overdue_days":"","status":1,"remind_date":"2026-03-28"},{"id":1133,"key":1133,"contract_id":4449,"name":"2026-03-30","value":"50000","overdue_days":0,"status":1,"remind_date":"2026-03-30"}],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[]},"approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[{"id":510,"erp_payment_ticket_id":2337,"erp_payment_ticket_settle_id":2372,"sales_contract_id":"","purchase_contract_id":4449,"erp_cost_ticket_id":"","erp_other_payment_ticket_id":"","approve_id":2745,"amount":"50000","description":""}],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":true,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2743,"client_id":"","project_id":"","title":"2026\u5e74\u6e05\u660e\u8282\u5047\u65e5\u653e\u5047\u5b89\u6392","status":2,"next_verify_user":"","verify_at":"2026-03-25 10:44:03","description":"\u8001\u5927\uff0c2026\u5e74\u6e05\u660e\u8282\u56fd\u5bb6\u6cd5\u5b9a\u5047\u65e5\u5b89\u6392\uff1a4\u67084\u65e5\u20144\u67086\u65e5\uff08\u5468\u516d\/\u5468\u65e5\/\u5468\u4e00\uff09\u4f11\u606f\uff0c\u65e0\u8c03\u4f11\uff0c\u662f\u5426\u6267\u884c\uff1f","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2026-03-25 10:37:27","updated_at":"2026-03-25 10:44:03","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","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"}},"commentCount":{"object_id":2743,"comment":2},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":9601,"approve_id":2743,"user_id":1011,"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"}}}],"approveVerifyRels":[{"id":3697,"approve_id":2743,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-25 10:44:03","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3697,"approve_id":2743,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-25 10:44:03"},"attachmentRelationships":[{"id":57476,"object_type":28,"object_id":2743,"attachment_id":32548,"attachment":{"id":32548,"key":32548,"name":"423e6874-e723-3627-86df-33f1cc23c839","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/423e6874-e723-3627-86df-33f1cc23c839\/\u56fe\u7247.png","orig_name":"\u56fe\u7247.png"}}],"client":{},"project":{},"supplier":"","purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2742,"client_id":2202,"project_id":4149,"title":"\u501f\u6b3e\u7533\u8bf7\u2014\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2026-03-25 10:21:19","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u4e50\u6210\u5b66\u6821\u2014\u6df1\u4fe1\u670d\u9632\u706b\u5899\u6d4b\u8bd5\u673a\u62bc\u91d1\uff0c\u91d1\u989d21488\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u4ed8\u6b3e\u4fe1\u606f\uff1a\n\u5f00\u6237\u540d\uff1a\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u603b\u884c\u5927\u53a6\u8425\u4e1a\u90e8\n\u8d26\u53f7\uff1a7559 0185 2710 611","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2026-03-25 10:03:17","updated_at":"2026-03-25 10:21:19","supplier_id":138,"purchase_contract_id":"","amount":"","borrow_amount":"21488","borrow_collect_day":"2026-06-26","borrow_collect_status":-1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"21488","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","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"}},"commentCount":{"object_id":2742,"comment":3},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,5252"},"approveCarbonCopyRels":[{"id":9598,"approve_id":2742,"user_id":1013,"user":{"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"}}},{"id":9599,"approve_id":2742,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":9600,"approve_id":2742,"user_id":5300,"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"}}}],"approveVerifyRels":[{"id":3695,"approve_id":2742,"user_id":1011,"status":1,"description":"","verify_at":"2026-03-25 10:21:00","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"}},"attachmentRelationships":[],"files":[]},{"id":3696,"approve_id":2742,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-25 10:21:19","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3695,"approve_id":2742,"user_id":1011,"status":1,"description":"","verify_at":"2026-03-25 10:21:00"},"attachmentRelationships":[{"id":57466,"object_type":28,"object_id":2742,"attachment_id":32543,"attachment":{"id":32543,"key":32543,"name":"30926e5f-d48c-3bee-b79b-d7542473d1ba","extension":"jpg","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/30926e5f-d48c-3bee-b79b-d7542473d1ba\/\u501f\u6b3e\u535521488\u5143.jpg","orig_name":"\u501f\u6b3e\u535521488\u5143.jpg"}},{"id":57467,"object_type":28,"object_id":2742,"attachment_id":32544,"attachment":{"id":32544,"key":32544,"name":"839d2c07-068d-3eb5-81a5-ae30f54e7e4e","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/839d2c07-068d-3eb5-81a5-ae30f54e7e4e\/\u56fe\u7247.png","orig_name":"\u56fe\u7247.png"}}],"client":{"id":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09"},"project":{"id":4149,"key":4149,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u65b0\u8d2d-2026","project_status":2,"buildContract":""},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d \u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[{"id":24,"erp_other_collect_ticket_id":49,"approve_id":2742,"amount":"21488","description":""},{"id":25,"erp_other_collect_ticket_id":50,"approve_id":2742,"amount":"21488","description":""}],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":true,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#E8F5E5","fgcolor":"#22A100","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":16}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":2650},{"key":1,"name":"\u5ba1\u6838\u4e2d","count":12},{"key":2,"name":"\u5df2\u901a\u8fc7","count":2604},{"key":4,"name":"\u5df2\u62d2\u7edd","count":32}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":2},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":2650,"thispage":3,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.74.191.180","ua":"jinchangxiao\/1.0.43 (HUAWEI Mate 60 Pro ALN-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-07-12 23:37:25', 224526848) RETURNING "id"
23:37:25.2053.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (3695, 3696, 3697, 3699, 3700, 3711, 3712, 3714, 3720, 3722, 3726))
23:37:25.2223.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742))
23:37:25.2103.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742))
23:37:25.1951.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.0501.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1001) AND ("status" != 0)
23:37:25.2271.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE (amount - all_settle_amount > 0) AND ("status"=2) AND ("id" IN (49, 50, 54))
23:37:25.0181.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
23:37:25.2150.9 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4079, 1111, 4111, 4078, 4149)
23:37:25.1930.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.2090.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)) ORDER BY "id"
23:37:25.1990.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742) ORDER BY "id"
23:37:25.2160.7 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4079, 4149, 4111, 4078, 1111)
23:37:25.1350.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1000, 1001, 5064, 1005, 5360)
23:37:25.1940.7 msyii\db\Command::querySELECT "id", "name", "approve_verify_user", "approve_carbon_copy_user" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (212, 205, 204, 7, 226, 5, 164, 132, 173, 185, 191, 197, 199, 184, 200, 165, 179, 178, 192, 189, 203, 265, 232, 2, 1, 131, 172, 142, 177, 128, 337, 215, 341, 349, 350, 359, 369, 374, 377, 340, 335, 360, 2100000001, 317, 2100000000, 319, 315))
23:37:25.2340.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."approve_id"=2746) AND ("t"."status" IN (2, 5))
23:37:25.2080.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)) ORDER BY "id"
23:37:25.0210.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:37:25.2200.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 (4458, 4449, 4460)) ORDER BY "id"
23:37:25.0290.6 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
23:37:25.1360.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 (1000, 5064, 5360, 1005, 5300, 1001))
23:37:25.2320.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."approve_id"=2756) AND ("t"."status" IN (2, 5))
23:37:25.2140.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3432, 982, 3435, 3454, 2202)
23:37:25.2330.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."approve_id"=2749) AND ("t"."status" IN (2, 5))
23:37:25.2190.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4458, 4449, 4460) ORDER BY "remind_date"
23:37:25.2290.5 msyii\db\Command::querySELECT id, null::integer as purchase_contract_id, null::integer as sales_contract_id, null::integer as erp_other_income_ticket_id, id as erp_other_collect_ticket_id, 4 as ticket_type, null::integer as cost_type, created_at, amount, amount - all_settle_amount as un_settle_amount, handler, serial_no, abstract FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE (amount - all_settle_amount > 0) AND ("status"=2) AND ("id" IN (49, 50, 54))
23:37:25.2350.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."approve_id"=2742) AND ("t"."status" IN (2, 5))
23:37:25.0170.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
23:37:25.2300.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.2140.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32543, 32544, 32548, 32651, 32662, 32665)
23:37:25.1970.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5252, 5300, 1011, 5360)
23:37:25.2180.4 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name", "handler", "cost_type", "erp_un_settle_amount", "created_at", "amount", "erp_un_settle_amount", "serial_no", "is_verify", "is_edit_verify", "is_chargeback_verify" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4460, 4458, 4449)
23:37:25.2260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.2170.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (287, 45, 125, 138)
23:37:25.2000.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 1005, 1000)
23:37:25.1370.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 3, 1, 4)
23:37:25.1980.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 (1013, 5360, 1011, 5300, 5252))
23:37:25.2260.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32652, 32666)
23:37:25.2000.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 (1000, 1005, 1011, 1001))
23:37:25.2210.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742) ORDER BY "id"
23:37:25.2190.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
23:37:25.2210.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)) ORDER BY "id"
23:37:25.2220.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)) ORDER BY "id"
23:37:25.2300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.2280.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.2310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)
23:37:25.2290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2753, 2758, 2765, 2756, 2755, 2749, 2746, 2745, 2743, 2742)