ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a325d4edfb39: POST https://beta.jinchangxiao.com/v2/approve/list at 2026-06-17 04:39:42 pm by 39.156.194.178

Performance Profiling

Total processing time: 222 ms; Peak memory: 5.684 MB. Show Profiling Timeline

总计54条数据
TimeDurationCategoryInfo
  
16:39:42.95033.8 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"=1000) AND ("rccr"."user_id"=1000) AND ("is_read"=FALSE) AND ("r"."status" != '0') GROUP BY "object_id"
16:39:43.03827.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)) GROUP BY "object_id"
16:39:43.00727.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" 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)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000) OR ("rcvr"."user_id"=1000)) AND ("r"."status"='2') 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:39:42.98522.2 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)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000) OR ("rcvr"."user_id"=1000)) AND ("r"."status"='2') 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:39:43.06618.5 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND ("remind_user_id"=1000) AND ("is_read"=FALSE) AND ("object_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)) GROUP BY "object_id"
16:39:42.93116.5 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)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000) OR ("rcvr"."user_id"=1000)) AND ("r"."status"='2') GROUP BY "r"."id") "sub"
16:39:43.0923.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (3711, 3712, 3714, 3720, 3722, 3734, 3735, 3736, 3737, 3743, 3749, 3750))
16:39:43.1253.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', 1000, 6, 177, 'v2/approve/list', '{"ApproveSearch":{"filter":"","status":"2","form_department":"","form_approveVerifyRels":"","form_type":"","created_at_period":"","verify_at_period":"","created_by":"","borrow_collect_status":""},"page":"1","pagesize":"10","posttime":"1781685581","access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"6","version_code":"177","token":"88807aea3a1bdaa45df439eb9f26205b"}', '{"code":200,"data":{"list":[{"id":2776,"client_id":"","project_id":"","title":"\u6d4b\u8bd5\u65b0\u5efa\u6309\u94ae\u663e\u793a\u95ee\u9898","status":2,"next_verify_user":"","verify_at":"2026-06-04 17:48:53","description":"c\u800c\u662f","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-06-04 17:48:50","updated_at":"2026-06-04 17:48:53","supplier_id":431,"purchase_contract_id":4472,"amount":"1","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":"1","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":2776,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3750,"approve_id":2776,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-04 17:48:53","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":3750,"approve_id":2776,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-04 17:48:53"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4472,"key":4472,"name":"\u6d4b\u8bd5\u590d\u53e4\u98ce","handler":1011,"cost_type":2,"erp_un_settle_amount":"100","created_at":"2026-05-15 21:34:44","amount":"100","serial_no":"\u6d4b\u8bd5\u590d\u53e4\u98ce","is_verify":true,"is_edit_verify":false,"is_chargeback_verify":false,"purchaseContractPaymentCollectionRemindDates":[],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[{"id":135631,"object_id":4472,"taxonomy_id":386,"term_id":18,"value":"","object_type":8,"extra_int":"385","in_amount":"","out_amount":"100","key":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","amount":"100","description":"","parent_id":"385","serial_no":"6115","taxonomy":{"id":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}]},"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":2775,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2026-06-02 17:31:01","description":"\u6d4b\u8bd5","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-06-02 17:30:58","updated_at":"2026-06-02 17:31:01","supplier_id":431,"purchase_contract_id":4485,"amount":"900","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":"900","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"900","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":2775,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3749,"approve_id":2775,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-02 17:31:01","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":3749,"approve_id":2775,"user_id":1001,"status":1,"description":"","verify_at":"2026-06-02 17:31:01"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4485,"key":4485,"name":"\u4efb\u52a1\u800c\u4e3a","handler":1011,"cost_type":2,"erp_un_settle_amount":"300","created_at":"2026-06-01 15:37:14","amount":"300","serial_no":"\u4efb\u52a1\u800c\u4e3a","is_verify":false,"is_edit_verify":false,"is_chargeback_verify":false,"purchaseContractPaymentCollectionRemindDates":[],"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"costContractAmounts":[{"id":135698,"object_id":4485,"taxonomy_id":386,"term_id":18,"value":"","object_type":8,"extra_int":"385","in_amount":"","out_amount":"300","key":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","amount":"300","description":"","parent_id":"385","serial_no":"6115","taxonomy":{"id":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":""}}}]},"approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[{"id":52,"purchase_contract_id":4485,"erp_cash_cost_ticket_id":8489,"erp_cash_cost_ticket_purchase_contract_settle_id":63,"approve_id":2775,"amount":"900","description":""}],"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,"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":2773,"client_id":"","project_id":"","title":"334","status":2,"next_verify_user":"","verify_at":"2026-05-25 10:47:12","description":"3434","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-05-25 10:47:09","updated_at":"2026-05-25 10:47:12","supplier_id":45,"purchase_contract_id":"","amount":"900","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":"900","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":2773,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3743,"approve_id":2773,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-25 10:47:12","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":3743,"approve_id":2773,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-25 10:47:12"},"attachmentRelationships":[],"client":{},"project":{},"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":[],"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":2771,"client_id":"","project_id":"","title":"5345","status":2,"next_verify_user":"","verify_at":"2026-05-22 17:51:50","description":"53454","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-05-22 17:50:00","updated_at":"2026-05-22 17:51:50","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":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":2771,"comment":3},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3736,"approve_id":2771,"user_id":5250,"status":1,"description":"","verify_at":"2026-05-22 17:51:06","user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"attachmentRelationships":[],"files":[]},{"id":3737,"approve_id":2771,"user_id":5064,"status":1,"description":"","verify_at":"2026-05-22 17:51:50","user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3736,"approve_id":2771,"user_id":5250,"status":1,"description":"","verify_at":"2026-05-22 17:51:06"},"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":2769,"client_id":"","project_id":"","title":"dgdfg","status":2,"next_verify_user":"","verify_at":"2026-05-22 16:53:27","description":"\u4e2a\u7535\u996d\u9505","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-05-22 16:31:04","updated_at":"2026-05-22 16:53:27","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":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":2769,"comment":2},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[{"id":9654,"approve_id":2769,"user_id":5064,"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}},{"id":9655,"approve_id":2769,"user_id":5461,"user":{"id":5461,"key":5461,"name":"\u8096\u5e05","sex":"M","avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"}}},{"id":9656,"approve_id":2769,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}}],"approveVerifyRels":[{"id":3734,"approve_id":2769,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-22 16:52: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":[]},{"id":3735,"approve_id":2769,"user_id":5064,"status":1,"description":"\u4e2a\u5730\u65b9\u5927\u59d1\u53d1\u5927\u6c34","verify_at":"2026-05-22 16:53:27","user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3734,"approve_id":2769,"user_id":1001,"status":1,"description":"","verify_at":"2026-05-22 16:52: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":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":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\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/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\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/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\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/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":""}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":2569},{"key":1,"name":"\u5ba1\u6838\u4e2d","count":0},{"key":2,"name":"\u5df2\u901a\u8fc7","count":2569},{"key":4,"name":"\u5df2\u62d2\u7edd","count":0}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":2},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":2569,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/1.0.41 (HUAWEI Mate 60 BRA-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-06-17 16:39:43', 207301888) RETURNING "id"
16:39:43.0953.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (3711, 3712, 3714, 3720, 3722, 3734, 3735, 3736, 3737, 3743, 3749, 3750))
16:39:43.1123.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749))
16:39:43.1013.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749))
16:39:43.0871.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:42.9481.1 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1000) AND ("status" != 0)
16:39:43.1000.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)) ORDER BY "id"
16:39:42.9210.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
16:39:43.1060.8 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4111, 1111)
16:39:43.0900.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749) ORDER BY "id"
16:39:43.0850.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:43.0990.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)) ORDER BY "id"
16:39:42.9230.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:39:43.1090.5 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, 4485, 4460, 4472)) ORDER BY "id"
16:39:42.9300.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:39:43.0860.5 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, 2, 1, 326, 208, 226, 5, 205, 199, 184, 200, 165, 179, 178, 192, 197, 164, 174, 196, 204, 194, 142, 177, 128, 172, 176, 331, 232, 131, 173, 181, 337, 215, 340, 350, 359, 374, 377, 335, 349, 360, 341, 2100000001, 2100000000, 319, 317))
16:39:43.1200.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))
16:39:43.1210.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"=2749) AND ("t"."status" IN (2, 5))
16:39:43.0360.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1000, 5064)
16:39:43.1080.4 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, 4485, 4460, 4472) ORDER BY "remind_date"
16:39:43.1170.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE (amount - all_settle_amount > 0) AND ("status"=2) AND ("id"=54)
16:39:42.9200.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:39:43.0370.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5064, 1001))
16:39:43.1180.3 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"=54)
16:39:43.1190.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:43.0890.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5252, 5360, 5064, 5461, 5016)
16:39:43.1070.3 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 (4472, 4485, 4460, 4458)
16:39:43.1050.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (982, 3435, 3454)
16:39:43.0910.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 1000, 5064, 5250)
16:39:43.0890.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 (5064, 5252, 1013, 5360, 5016, 5461))
16:39:43.1040.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32651, 32662)
16:39:43.1100.3 msyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386
16:39:43.0910.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, 1001, 5064, 5250, 1011))
16:39:43.1050.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1111, 4111)
16:39:43.1110.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)) ORDER BY "id"
16:39:43.0380.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
16:39:43.1070.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 45, 125)
16:39:43.1110.3 msyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=385
16:39:43.1120.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)) ORDER BY "id"
16:39:43.1110.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749) ORDER BY "id"
16:39:43.1160.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32652
16:39:43.1190.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:43.1090.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
16:39:43.1160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:43.1170.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:43.1180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)
16:39:43.1190.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2776, 2775, 2773, 2771, 2769, 2758, 2765, 2756, 2755, 2749)