ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a26c40071f7a: POST https://beta.jinchangxiao.com/v2/approve/list at 2026-06-08 09:30:40 pm by 125.78.86.146

Performance Profiling

Total processing time: 226 ms; Peak memory: 5.681 MB. Show Profiling Timeline

总计55条数据
TimeDurationCategoryInfo
  
21:30:40.55044.4 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)) GROUP BY "object_id"
21:30:40.59533.2 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND ("remind_user_id"=1001) AND ("is_read"=FALSE) AND ("object_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)) GROUP BY "object_id"
21:30:40.49524.2 msyii\db\Command::querySELECT count(object_id) as count FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_approves" "r" ON uc.object_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE (object_id = r.id) AND ("object_type"=37) AND ("remind_user_id"=1001) AND ("rccr"."user_id"=1001) AND ("is_read"=FALSE) AND ("r"."status" != '0') GROUP BY "object_id"
21:30:40.52014.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.*, CASE WHEN rvr.status = 0 And next_verify_user = 1001 THEN 1 WHEN rcvr.status = 0 And next_cancel_verify_user = 1001 THEN 2 ELSE 0 END as approvesort 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 WHERE ("rvr"."user_id"=1001) AND ("r"."status" != 0) GROUP BY "r"."id", "approvesort" ORDER BY "approvesort" DESC, 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"
21:30:40.53512.8 msyii\db\Command::querySELECT r.*, CASE WHEN rvr.status = 0 And next_verify_user = 1001 THEN 1 WHEN rcvr.status = 0 And next_cancel_verify_user = 1001 THEN 2 ELSE 0 END as approvesort 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 WHERE ("rvr"."user_id"=1001) AND ("r"."status" != 0) GROUP BY "r"."id", "approvesort" ORDER BY "approvesort" DESC, 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
21:30:40.48112.6 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.*, CASE WHEN rvr.status = 0 And next_verify_user = 1001 THEN 1 WHEN rcvr.status = 0 And next_cancel_verify_user = 1001 THEN 2 ELSE 0 END as approvesort 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 WHERE ("rvr"."user_id"=1001) AND ("r"."status" != 0) GROUP BY "r"."id", "approvesort" ORDER BY "approvesort" DESC) "sub"
21:30:40.6719.3 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_term_taxonomy_relationships' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
21:30:40.6556.7 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)
21:30:40.6673.9 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_term_taxonomy_relationships' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
21:30:40.6453.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753))
21:30:40.6353.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (3707, 3709, 3726, 3732, 3733, 3734, 3735, 3740, 3741, 3742, 3743, 3744, 3745, 3746, 3747, 3748, 3749, 3750))
21:30:40.6393.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (3707, 3709, 3726, 3732, 3733, 3734, 3735, 3740, 3741, 3742, 3743, 3744, 3745, 3746, 3747, 3748, 3749, 3750))
21:30:40.6632.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4485, 4472) ORDER BY "remind_date"
21:30:40.6822.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753))
21:30:40.6531.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 45, 287)
21:30:40.6891.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 7, 176, 'v2/approve/list', '{"ApproveSearch":{"filter":"approve","status":"","form_department":"","form_approveVerifyRels":"","form_type":"","created_at_period":"","verify_at_period":"","created_by":"","borrow_collect_status":""},"page":"1","pagesize":"10","posttime":"1780925440","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"176","token":"fd5e430754bce01be1609473f89635eb"}', '{"code":200,"data":{"list":[{"id":2774,"client_id":"","project_id":"","title":"\u65b9\u5f0f\u5730\u65b9","status":1,"next_verify_user":1001,"verify_at":"","description":"\u53d1\u9001\u7684s","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-05-25 16:28:03","updated_at":"2026-05-25 16:28:03","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","approvesort":1,"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":2774,"comment":1},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3744,"approve_id":2774,"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":[]},{"id":3745,"approve_id":2774,"user_id":5250,"status":0,"description":"","verify_at":"","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":3746,"approve_id":2774,"user_id":5064,"status":0,"description":"","verify_at":"","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":[]},{"id":3747,"approve_id":2774,"user_id":5461,"status":0,"description":"","verify_at":"","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"}},"attachmentRelationships":[],"files":[]},{"id":3748,"approve_id":2774,"user_id":5016,"status":0,"description":"","verify_at":"","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"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":3744,"approve_id":2774,"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":true,"can_resubmit":false,"can_verify":true,"can_refuse":true,"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":"#FBDFCC","fgcolor":"#EB6100","status_display":"\u5ba1\u6838\u4e2d","borrow_expire_day":""},{"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","approvesort":1,"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":true,"can_resubmit":false,"can_verify":true,"can_refuse":true,"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":"#FBDFCC","fgcolor":"#EB6100","status_display":"\u5ba1\u6838\u4e2d","borrow_expire_day":""},{"id":2750,"client_id":"","project_id":"","title":"ces","status":1,"next_verify_user":1001,"verify_at":"","description":"ces\u4f46\u662f","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-04-13 16:38:31","updated_at":"2026-04-14 10:17:46","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","approvesort":1,"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":2750,"comment":1},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3709,"approve_id":2750,"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":3709,"approve_id":2750,"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":true,"can_resubmit":false,"can_verify":true,"can_refuse":true,"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":"#FBDFCC","fgcolor":"#EB6100","status_display":"\u5ba1\u6838\u4e2d","borrow_expire_day":""},{"id":2772,"client_id":"","project_id":"","title":"\u51b2\u5395\u6240","status":1,"next_verify_user":5064,"verify_at":"","description":"ssfs","refuse_description":"","is_resubmited":false,"created_by":5064,"created_at":"2026-05-24 14:57:42","updated_at":"2026-05-24 14:58:01","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","approvesort":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":2772,"comment":1},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3740,"approve_id":2772,"user_id":5064,"status":0,"description":"","verify_at":"","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":[]},{"id":3741,"approve_id":2772,"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":[]},{"id":3742,"approve_id":2772,"user_id":5250,"status":0,"description":"","verify_at":"","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":[]}],"lastApproveVerifyRel":{"id":3740,"approve_id":2772,"user_id":5064,"status":0,"description":"","verify_at":"","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"}}},"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":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":"#FBDFCC","fgcolor":"#EB6100","status_display":"\u5ba1\u6838\u4e2d","borrow_expire_day":""},{"id":2770,"client_id":"","project_id":"","title":"\u5de5\u4e66\u6cd5\u5927\u59d1","status":1,"next_verify_user":5250,"verify_at":"","description":"\u5927\u59d1\u8bf4\u5565\u5e72\u7684\u5730\u65b9","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2026-05-22 16:52:02","updated_at":"2026-05-22 16:52:02","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","approvesort":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":2770,"comment":1},"unreadComments":{},"type":{"id":317,"name":"\u5176\u4ed6","approve_verify_user":"","approve_carbon_copy_user":""},"approveCarbonCopyRels":[],"approveVerifyRels":[{"id":3732,"approve_id":2770,"user_id":5250,"status":0,"description":"","verify_at":"","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":3733,"approve_id":2770,"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":3732,"approve_id":2770,"user_id":5250,"status":0,"description":"","verify_at":"","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"}}},"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":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":"#FBDFCC","fgcolor":"#EB6100","status_display":"\u5ba1\u6838\u4e2d","borrow_expire_day":""},{"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","approvesort":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","approvesort":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":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","approvesort":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":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","approvesort":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":2753,"client_id":3432,"project_id":4079,"title":"\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c\u4f60\u7684\u5a1c\u5a1c","status":4,"next_verify_user":"","verify_at":"2026-05-09 17:09:24","description":"\u597d\u653e\u5047\u653e\u5047","refuse_description":"","is_resubmited":false,"created_by":5300,"created_at":"2026-04-14 13:37:34","updated_at":"2026-05-09 17:09:24","supplier_id":287,"purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","approvesort":0,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2753,"comment":8},"unreadComments":{},"type":{"id":315,"name":"\u63d0\u524d\u5f00\u53d1\u7968\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"1011,5360,5252"},"approveCarbonCopyRels":[{"id":9641,"approve_id":2753,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":9642,"approve_id":2753,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}},{"id":9643,"approve_id":2753,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3726,"approve_id":2753,"user_id":1001,"status":2,"description":"","verify_at":"2026-05-09 17:09:24","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":3726,"approve_id":2753,"user_id":1001,"status":2,"description":"","verify_at":"2026-05-09 17:09:24"},"attachmentRelationships":[{"id":57619,"object_type":28,"object_id":2753,"attachment_id":32665,"attachment":{"id":32665,"key":32665,"name":"62d49e35-69d1-320f-9cd5-ba916cc0d474","extension":"jpg","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/62d49e35-69d1-320f-9cd5-ba916cc0d474\/\u91d1\u7545\u900dERP\u843d\u5730\u9875.jpg","orig_name":"\u91d1\u7545\u900dERP\u843d\u5730\u9875.jpg"}}],"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"project":{"id":4079,"key":4079,"name":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee","project_status":3,"buildContract":{"id":4324,"from_project":4079,"serial_no":"2025-12-19-002"}},"supplier":{"id":287,"key":287,"name":"\u73e0\u6d77\u5954\u56fe\u7535\u5b50\u6709\u9650\u516c\u53f8"},"purchaseContract":"","approveCancelVerifyRels":[],"lastApproveCancelVerifyRel":"","haveApproveCancelVerifyRel":"","files":[{"id":57620,"object_type":29,"object_id":2753,"attachment_id":32666,"attachment":{"id":32666,"key":32666,"name":"0a7f3cfe-8890-374e-9c90-797277b22296","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/0a7f3cfe-8890-374e-9c90-797277b22296\/\u4ea7\u54c1\u9009\u62e9\u4e0b\u62c9.png","orig_name":"\u4ea7\u54c1\u9009\u62e9\u4e0b\u62c9.png"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"erpAdvancePaymentTicketApprovePaymentSettles":[],"erpCashCostTicketApprovePaymentSettles":[],"erpPaymentTicketApprovePaymentSettles":[],"erpOtherCollectTicketApproveBorrowSettles":[],"un_settle_amount":0,"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"borrow_done_display":false,"borrow_un_done_display":false,"borrow_overdue_display":false,"payment_done_display":false,"payment_un_done_display":false,"can_borrow":false,"can_cancel_verify":false,"can_cancel_borrow":false,"can_cancel_payment":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#FFE5E5","fgcolor":"#FF0101","status_display":"\u5df2\u62d2\u7edd","borrow_expire_day":""}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":1797},{"key":1,"name":"\u5ba1\u6838\u4e2d","count":5},{"key":2,"name":"\u5df2\u901a\u8fc7","count":1767},{"key":4,"name":"\u5df2\u62d2\u7edd","count":23}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":3},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":1797,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"125.78.86.146","ua":"jinchangxiao\/1.0.40 (emulator emulator; HarmonyOS 6.1.0)"}', FALSE, '2026-06-08 21:30:40', 221774848) RETURNING "id"
21:30:40.4791.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
21:30:40.6311.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.4941.0 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1001) AND ("status" != 0)
21:30:40.4690.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
21:30:40.6490.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32665
21:30:40.6290.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.6330.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753) ORDER BY "id"
21:30:40.6440.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)) ORDER BY "id"
21:30:40.6520.8 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4079
21:30:40.6420.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)) ORDER BY "id"
21:30:40.4710.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:30:40.6660.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 (4485, 4472)) ORDER BY "id"
21:30:40.6300.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, 1, 226, 326, 208, 5, 7, 2, 185, 191, 164, 131, 172, 179, 174, 197, 199, 196, 204, 194, 182, 184, 189, 205, 192, 132, 176, 215, 128, 173, 181, 340, 349, 350, 359, 369, 377, 375, 341, 337, 2100000001, 317, 315, 2100000000))
21:30:40.5490.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1015, 5064, 5300)
21:30:40.6870.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"=2751) AND ("t"."status" IN (2, 5))
21:30:40.6350.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 (1001, 5064, 5250, 5016, 5461))
21:30:40.6320.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5252, 1011, 5360, 5064, 5461, 5016)
21:30:40.6330.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, 1011))
21:30:40.6340.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5064, 5461, 5016)
21:30:40.6430.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5064, 5461, 5016)
21:30:40.5490.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, 5064, 1015, 5300))
21:30:40.6440.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, 5064, 5250, 5016, 5461))
21:30:40.6500.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3432
21:30:40.6510.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4079
21:30:40.6810.2 msyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386
21:30:40.4690.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:30:40.6660.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
21:30:40.6860.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.5500.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 2, 1)
21:30:40.6820.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)) ORDER BY "id"
21:30:40.6810.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753) ORDER BY "id"
21:30:40.6820.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_approve_cancel_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)) ORDER BY "id"
21:30:40.6850.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.6850.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32666
21:30:40.6860.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.6810.2 msyii\db\Command::querySELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=385
21:30:40.6850.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.6850.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)
21:30:40.6860.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2774, 2751, 2750, 2772, 2770, 2776, 2775, 2773, 2769, 2753)