Performance Profiling

Total processing time: 165 ms; Peak memory: 5.615 MB. Show Profiling Timeline

总计44条数据
TimeDurationCategoryInfo
  
16:47:11.04433.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)) GROUP BY "object_id"
16:47:11.00020.6 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"=1015) AND ("rccr"."user_id"=1015) AND ("is_read"=FALSE) AND ("r"."status" != '0') GROUP BY "object_id"
16:47:11.07819.4 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND ("remind_user_id"=1015) AND ("is_read"=FALSE) AND ("object_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)) GROUP BY "object_id"
16:47:11.03011.3 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"=1015) OR ("rccr"."user_id"=1015) OR ("rvr"."user_id"=1015) OR ("rcvr"."user_id"=1015)) 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
16:47:11.0227.3 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"=1015) OR ("rccr"."user_id"=1015) OR ("rvr"."user_id"=1015) OR ("rcvr"."user_id"=1015)) 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"
16:47:10.9927.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"=1015) OR ("rccr"."user_id"=1015) OR ("rvr"."user_id"=1015) OR ("rcvr"."user_id"=1015)) GROUP BY "r"."id") "sub"
16:47:11.1333.2 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', 1015, 0, 276, 'v2/approve/list', '{"ApproveSearch":{"filter":"","created_by":""},"access_token":"Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ","device_type":"0","version_code":"276","page":"1","token":"cc91ca010be82fc97649351062a18836","posttime":"1784105230","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":2751,"client_id":"","project_id":"","title":"gggg","status":1,"next_verify_user":1001,"verify_at":"","description":"ffff","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2026-04-13 21:37:00","updated_at":"2026-04-13 21:37:00","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"855","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":"855","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2751,"comment":1},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,5252"},"approveCarbonCopyRels":[{"id":9616,"approve_id":2751,"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":9617,"approve_id":2751,"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":3707,"approve_id":2751,"user_id":1001,"status":0,"description":"","verify_at":"","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":{"id":3707,"approve_id":2751,"user_id":1001,"status":0,"description":"","verify_at":"","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"}}},"haveApproveVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":true,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":"#FBDFCC","fgcolor":"#EB6100","status_display":"\u5ba1\u6838\u4e2d","borrow_expire_day":""},{"id":2735,"client_id":"","project_id":"","title":"\u4eba\u5de5\u667a\u80fd\u4f01\u4e1a\u5e94\u7528\u843d\u5730\u57f9\u8bad\u8bfe\u7a0b","status":2,"next_verify_user":"","verify_at":"2026-03-20 15:15:56","description":"3\u670828\u57f9\u8bad\u8bfe\u8d39\u7528","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2026-03-20 15:15:26","updated_at":"2026-03-20 15:15:56","supplier_id":"","purchase_contract_id":"","amount":"1980","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":"1980","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":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2735,"comment":30},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":9579,"approve_id":2735,"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":9580,"approve_id":2735,"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":3687,"approve_id":2735,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-20 15:15:56","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":3687,"approve_id":2735,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-20 15:15:56"},"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":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":2437,"client_id":"","project_id":"","title":"\u65b0\u540c\u4e8b\u529e\u516c\u8bbe\u5907","status":2,"next_verify_user":"","verify_at":"2025-11-26 13:35:45","description":"PC\u673a\u7528\u84dd\u7259\u9002\u914d\u5668 79\u5143","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2025-11-26 13:23:05","updated_at":"2025-11-26 13:35:45","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":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2437,"comment":3},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":8538,"approve_id":2437,"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":8539,"approve_id":2437,"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"}}}],"approveVerifyRels":[{"id":3224,"approve_id":2437,"user_id":1001,"status":1,"description":"","verify_at":"2025-11-26 13:35: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":3224,"approve_id":2437,"user_id":1001,"status":1,"description":"","verify_at":"2025-11-26 13:35:45"},"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":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":2304,"client_id":"","project_id":"","title":"\u516c\u53f8\u81ea\u7528\u6df1\u4fe1\u670dSASE\u5b89\u5168\u4e0a\u7f51\u4e91\u670d\u52a1","status":2,"next_verify_user":"","verify_at":"2025-10-09 11:38:58","description":"\u516c\u53f8\u81ea\u7528\u6df1\u4fe1\u670dSASE\u5b89\u5168\u4e0a\u7f51\u4e91\u670d\u52a1 \u4e00\u5e74\u670d\u52a1 \u91d1\u989d 5745","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2025-10-09 11:38:46","updated_at":"2025-10-09 11:38:58","supplier_id":138,"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":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2304,"comment":2},"unreadComments":{},"type":{"id":321,"name":"\u6d4b\u8bd5\u8bbe\u5907\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,1011,5360"},"approveCarbonCopyRels":[{"id":8125,"approve_id":2304,"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":8126,"approve_id":2304,"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":8127,"approve_id":2304,"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"}}}],"approveVerifyRels":[{"id":3019,"approve_id":2304,"user_id":1001,"status":1,"description":"","verify_at":"2025-10-09 11:38:58","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":3019,"approve_id":2304,"user_id":1001,"status":1,"description":"","verify_at":"2025-10-09 11:38:58"},"attachmentRelationships":[],"client":{},"project":{},"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":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":2213,"client_id":"","project_id":"","title":"\u7533\u8bf7\u8d2d\u4e70\u6df1\u4fe1\u670d\u5f15\u6d41\u5668SDW-R-AE1300","status":2,"next_verify_user":"","verify_at":"2025-08-28 15:58:17","description":"\u8d2d\u4e70\u6df1\u4fe1\u670d\u5f15\u6d41\u5668SDW-R-AE1300\uff0c\u7528\u4e8e\u529e\u516c\u5ba4\u8fde\u63a5SASE \u00a5480","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2025-08-28 15:58:02","updated_at":"2025-08-28 15:58:17","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":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2213,"comment":2},"unreadComments":{},"type":{"id":321,"name":"\u6d4b\u8bd5\u8bbe\u5907\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,1011,5360"},"approveCarbonCopyRels":[{"id":7851,"approve_id":2213,"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":7852,"approve_id":2213,"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":7853,"approve_id":2213,"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"}}}],"approveVerifyRels":[{"id":2894,"approve_id":2213,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-28 15:58:17","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":2894,"approve_id":2213,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-28 15:58:17"},"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":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":2143,"client_id":"","project_id":"","title":"\u8d2d\u4e70\u5927\u5bb9\u91cf\u5149\u9a71\u7533\u8bf7","status":2,"next_verify_user":"","verify_at":"2025-08-11 17:19:58","description":"\u8d2d\u4e70\u5927\u5bb9\u91cf\u5149\u76d8\u7528\u4e8e\u7ed9\u5218\u5fae\u5ba2\u6237\u523b\u5f55\u64cd\u4f5c\u7cfb\u7edf\u8f6f\u4ef6\u5171\u8ba166\u5143","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2025-08-11 17:12:32","updated_at":"2025-08-11 17:19:58","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":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2143,"comment":2},"unreadComments":{},"type":{"id":321,"name":"\u6d4b\u8bd5\u8bbe\u5907\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1013,1011,5360"},"approveCarbonCopyRels":[{"id":7646,"approve_id":2143,"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":7647,"approve_id":2143,"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":7648,"approve_id":2143,"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"}}}],"approveVerifyRels":[{"id":2791,"approve_id":2143,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-11 17:19:58","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":2791,"approve_id":2143,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-11 17:19:58"},"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":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":2053,"client_id":2191,"project_id":"","title":"\u7533\u8bf7\u8d2d\u4e70\u5927\u5bb9\u91cfUSB\u523b\u5f55\u673a\u4e00\u4e2a","status":2,"next_verify_user":"","verify_at":"2025-07-16 13:31:43","description":"\u73b0\u5404\u79cd\u64cd\u4f5c\u7cfb\u7edf\u5b89\u88c5\u76d8\u5bb9\u91cf\u589e\u52a0\uff0c\u539f\u6709\u523b\u5f55\u673a\u5df2\u65e0\u6cd5\u6ee1\u8db3\u8981\u6c42\uff0c\u7533\u8bf7\u8d2d\u4e70USB\u84dd\u5149\u523b\u5f55\u673a\u4e00\u53f0\u7ea6300\u5143\uff0c\u84dd\u5149\u514b\u9686\u76d850\u7247\u7ea6130\u5143\uff0c\u516c\u53f8\u81ea\u7528","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2025-07-16 13:31:28","updated_at":"2025-07-16 13:31:43","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","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":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":2053,"comment":2},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":7361,"approve_id":2053,"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":2657,"approve_id":2053,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-16 13:31:43","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":2657,"approve_id":2053,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-16 13:31:43"},"attachmentRelationships":[],"client":{"id":2191,"key":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{},"supplier":"","purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"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,"can_create_erp_advance_payment_ticket":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":1789,"client_id":"","project_id":"","title":"\u8d75\u5b87-\u5458\u5de5\u52b3\u52a8\u5408\u540c\u5230\u671f\u65e52025-05-12","status":2,"next_verify_user":"","verify_at":"2025-04-14 12:49:24","description":"Hi\uff0c\u660a\u54e5&\u8001\u5927\n\n\u6280\u672f\u90e8\u5458\u5de5\uff1a\u8d75\u5b87\uff0c\u5458\u5de5\u52b3\u52a8\u5408\u540c2025\u5e7405\u670812\u65e5\u5230\u671f\uff0c\u662f\u5426\u6b63\u5e38\u7eed\u7b7e\uff1f\n\n\u82e5\u6b63\u5e38\u7eed\u7ea6\uff0c\u7b7e\u7f72\u4e00\u4e2a3\u5e74\u671f\u9650\u7684\u7eed\u7ea6\u5408\u540c\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-04-08 15:15:52","updated_at":"2025-04-14 12:49:24","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","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":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","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"}},"commentCount":{"object_id":1789,"comment":3},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":2306,"approve_id":1789,"user_id":1015,"status":1,"description":"\u540c\u610f\u7eed\u7b7e","verify_at":"2025-04-14 12:27:10","user":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"attachmentRelationships":[],"files":[]},{"id":2307,"approve_id":1789,"user_id":1001,"status":1,"description":"","verify_at":"2025-04-14 12:49: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":2306,"approve_id":1789,"user_id":1015,"status":1,"description":"\u540c\u610f\u7eed\u7b7e","verify_at":"2025-04-14 12:27:10"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[{"id":33401,"object_type":29,"object_id":1789,"attachment_id":24993,"attachment":{"id":24993,"key":24993,"name":"5eaf5faa-f205-3489-bd97-518de5d53d5c","extension":"pdf","path":"\/v2\/attachment\/view\/Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ\/5eaf5faa-f205-3489-bd97-518de5d53d5c\/\u8d75\u5b8720250512.pdf","orig_name":"\u8d75\u5b8720250512.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"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,"can_create_erp_advance_payment_ticket":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":1713,"client_id":"","project_id":"","title":"\u66f4\u6362\u529e\u516c\u7535\u8111","status":2,"next_verify_user":"","verify_at":"2025-03-12 23:29:04","description":"\u7533\u8bf7\u66f4\u6362\u534e\u4e3a\u529e\u516c\u7b14\u8bb0\u672c\u7535\u8111\u4e00\u53f0 \u578b\u53f7metabook x 9600\u5143","refuse_description":"","is_resubmited":false,"created_by":1015,"created_at":"2025-03-12 14:34:14","updated_at":"2025-03-12 23:29:04","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","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":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":1713,"comment":5},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":6217,"approve_id":1713,"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":2207,"approve_id":1713,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-12 23:29:04","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":2207,"approve_id":1713,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-12 23:29:04"},"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":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_create_erp_advance_payment_ticket":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":1692,"client_id":"","project_id":"","title":"\u57f9\u8bad\u8d39\u7528\u4ed8\u6b3e\u7533\u8bf7-\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-03-07 11:36:57","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5434\u660a\uff08PE\uff09\u548c\u970d\u4e1c\u9633\/\u5468\u5b50\u5065\uff08TE\uff09\u539f\u5382\u57f9\u8bad\u53ca\u8003\u8bd5\u8d39\u7528\u5408\u8ba1\u91d1\u989d\uff1a\uffe515000\u5143\uff0c\n\u57f9\u8bad\u5468\u671f\uff1a2025\u5e743\u670825\u65e5\u81f32025\u5e743\u670828\u65e5\n\u57f9\u8bad\u5730\u70b9\uff1a\u5357\u4eac\u516c\u53f8\u603b\u90e86\u697c\u57f9\u8bad\u5ba4\uff0c\u8bf7\u5ba1\u6279\uff01\n\u7f34\u8d39\u8bf4\u660e:\u53c2\u52a0\u9ad8\u7ea7\u8ba4\u8bc1\u7684\u5b66\u5458\u9700\u57282025\u5e743\u670814\u65e518:00\u524d\u7f34\u7eb3\u57f9\u8bad \u8d39 (5000\u5143\/\u4eba,\u8003\u8bd5\u901a\u8fc7\u9000\u8fd84000\u5143) ,\u8fc7\u671f\u4e0d\u4e88\u53d7\u7406\u3002\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u8d26\u6237\u540d\u79f0\uff1a\u822a\u5929\u58f9\u8fdb\u5236(\u6c5f\u82cf)\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u56fd\u519c\u4e1a\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5357\u4eac\u9ad8\u65b0\u6280\u672f\u5f00\u53d1\u533a\u652f\u884c\n\u94f6\u884c\u8d26\u6237\uff1a10115601040024686","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-03-07 11:21:17","updated_at":"2025-03-07 11:36:57","supplier_id":661,"purchase_contract_id":"","amount":"","borrow_amount":"","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":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","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"}},"commentCount":{"object_id":1692,"comment":7},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":6150,"approve_id":1692,"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":6151,"approve_id":1692,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6152,"approve_id":1692,"user_id":1015,"user":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}}}],"approveVerifyRels":[{"id":2177,"approve_id":1692,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-07 11:36:57","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":2177,"approve_id":1692,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-07 11:36:57"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[{"id":32732,"object_type":29,"object_id":1692,"attachment_id":24438,"attachment":{"id":24438,"key":24438,"name":"fe995d2d-78dc-3f8d-b41f-f8ae1b1771d7","extension":"pdf","path":"\/v2\/attachment\/view\/Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ\/fe995d2d-78dc-3f8d-b41f-f8ae1b1771d7\/\u5173\u4e8e\u5f00\u5c552025\u5e74\u7b2c1\u671f\u8ba4\u8bc1\u57f9\u8bad\u7684\u901a\u77e5.pdf","orig_name":"\u5173\u4e8e\u5f00\u5c552025\u5e74\u7b2c1\u671f\u8ba4\u8bc1\u57f9\u8bad\u7684\u901a\u77e5.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"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,"can_create_erp_advance_payment_ticket":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":""}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":32},{"key":1,"name":"\u5ba1\u6838\u4e2d","count":1},{"key":2,"name":"\u5df2\u901a\u8fc7","count":27},{"key":4,"name":"\u5df2\u62d2\u7edd","count":4}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":0},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":32,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-15 16:47:11', 157104128) RETURNING "id"
16:47:11.1203.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692))
16:47:11.1062.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (2177, 2207, 2306, 2307, 2657, 2791, 2894, 3019, 3224, 3687, 3707))
16:47:11.1092.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (2177, 2207, 2306, 2307, 2657, 2791, 2894, 3019, 3224, 3687, 3707))
16:47:11.1152.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692))
16:47:11.1011.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:11.0981.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:10.9900.8 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_approves" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1015) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
16:47:11.1040.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692) ORDER BY "id"
16:47:11.1280.8 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"=2751) AND ("t"."status" IN (2, 5))
16:47:11.1140.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)) ORDER BY "id"
16:47:11.1000.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 (165, 179, 142, 166, 183, 194, 1, 137, 139, 5, 226, 184, 189, 164, 172, 6, 213, 174, 197, 199, 2, 205, 203, 229, 129, 175, 131, 192, 200, 215, 156, 153, 136, 317, 341, 349, 350, 354, 373, 374, 377, 326, 359, 375, 321, 2100000000, 2100000001))
16:47:10.9990.7 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1015) AND ("status" != 0)
16:47:10.9780.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ'
16:47:11.1120.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)) ORDER BY "id"
16:47:11.1270.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:10.9810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
16:47:11.1240.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:11.0420.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1015, 1011)
16:47:11.1250.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:11.1260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:11.0430.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 (1011, 1015))
16:47:11.1030.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5388, 1015, 1011, 5360, 5252)
16:47:11.1040.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 (5388, 1013, 5360, 1011, 5252, 1015))
16:47:11.1140.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
16:47:11.1060.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1015))
16:47:11.1190.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692) ORDER BY "id"
16:47:11.1240.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24438, 24993)
16:47:11.1200.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)) ORDER BY "id"
16:47:11.1130.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:47:11.1190.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (138, 661)
16:47:11.0440.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 2)
16:47:11.1050.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1015)
16:47:11.1200.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)) ORDER BY "id"
16:47:11.1180.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2191
16:47:10.9780.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:47:11.1250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)
16:47:11.1270.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2751, 2735, 2437, 2304, 2213, 2143, 2053, 1789, 1713, 1692)