Total processing time: 132 ms; Peak memory: 5.379 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
15:30:52.556 | 20.5 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374)) GROUP BY "object_id" |
15:30:52.524 | 17.6 ms | yii\db\Command::query | SELECT 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 is_read = false) AND ("rccr"."user_id"=1001) AND ("r"."status" != 0) GROUP BY "object_id" |
15:30:52.577 | 16.4 ms | yii\db\Command::query | SELECT "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 (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374)) GROUP BY "object_id" |
15:30:52.516 | 7.3 ms | yii\db\Command::query | SELECT 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_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 ("dt1"."taxonomy_id"='2100000001') AND ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001)) GROUP BY "r"."id") "sub" |
15:30:52.542 | 5.8 ms | yii\db\Command::query | SELECT 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_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 ("dt1"."taxonomy_id"='2100000001') AND ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001)) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC) "c" |
15:30:52.548 | 5.5 ms | yii\db\Command::query | 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_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 ("dt1"."taxonomy_id"='2100000001') AND ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001)) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC LIMIT 20 |
15:30:52.593 | 3.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374) |
15:30:52.617 | 3.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22498, 25446, 25447, 25787, 25823, 25964, 25965, 25966) |
15:30:52.625 | 3.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=37) AND ("visit_date"='2025-08-26') |
15:30:52.608 | 2.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (25786, 25822, 27154) |
15:30:52.506 | 2.3 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
15:30:52.630 | 2.0 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/approve/list', '{"ApproveSearch":{"form_type":["2100000001"],"filter":"all","form_department":"","created_by":"","form_approveVerifyRels":"","status":"","created_at_period":"","verify_at_period":"","borrow_collect_status":"","erp_payment_settle_amount":""},"Filter":{"name":"","sort":""},"page":"1","web_access_token":"bMbho0_rXPW7OXlAQb1YuSTyV_XtCLu3"}', '{"code":2000,"result":{"list":[{"id":2132,"client_id":"","project_id":"","title":"\u501f\u6b3e\u7533\u8bf7","status":2,"next_verify_user":"","verify_at":"2025-08-18 09:50:45","description":"\u501f\u6b3e","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-08-18 09:50:43","updated_at":"2025-08-18 09:50:45","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"50000","borrow_collect_day":"2025-08-23","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"50000","erp_borrow_un_settle_amount":"0","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":2132,"comment":1},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":7622,"approve_id":2132,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7623,"approve_id":2132,"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"}}}],"approveVerifyRels":[{"id":2784,"approve_id":2132,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-18 09:50:45","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2784,"approve_id":2132,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-18 09:50:45"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":{},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":2103,"client_id":2115,"project_id":2684,"title":"\u6295\u6807\u4fdd\u8bc1\u91d1\u7533\u8bf7-\u6cb3\u5317\u519c\u4fe1\u9879\u76ee\u534f\u52a9","status":2,"next_verify_user":"","verify_at":"2025-07-29 10:51:47","description":"Tristen\uff0c\u6c5f\u5357\u79d1\u53cb\u540c\u4e00\u4e2a\u9879\u76ee\u56e0\u6295\u6807\u5bb6\u6570\u4e0d\u591f\u4e0a\u6b21\u6d41\u6807\u4e86\uff0c\u56e0\u6807\u4e66\u65e0\u9700\u6539\u52a8\uff0c\u8fd8\u9700\u8981\u54b1\u4eec\u534f\u52a9\u4e00\u4e0b\u3002\n\u7533\u8bf7\u652f\u4ed8\u6cb3\u5317\u519c\u4fe1\u7684\u9879\u76ee\u5e2e\u6c5f\u5357\u79d1\u53cb\u6295\u6807\u4fdd\u8bc1\u91d1\u91d1\u989d\uff1a\uffe5100000\uff0c\u5bf9\u65b9\u5df2\u7ecf\u628a\u73b0\u91d1\u6c47\u81f3\u7fc1\u5bb6\u62107062\u5361\u5185\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5f00\u6237\u540d\u79f0\uff1a\u745e\u548c\u5b89\u60e0\u9879\u76ee\u7ba1\u7406\u96c6\u56e2\u6709\u9650\u516c\u53f8\n\u5f00 \u6237 \u884c\uff1a\u4e2d\u56fd\u6c11\u751f\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u77f3\u5bb6\u5e84\u5efa\u8bbe\u5357\u5927\u8857\u652f\u884c\n\u8d26 \u53f7\uff1a696048833\n\u6c47\u6b3e\u5907\u6ce8\uff1a\u6295\u6807\u4fdd\u8bc1\u91d1\u3001\u6cb3\u5317\u519c\u4fe1\u4fe1\u606f\u7cfb\u7edf\u5bc6\u7801\u5e94\u7528\u5b89\u5168\u52a0\u56fa\u9879\u76ee\u6807\u6bb5\u4e00\uff08\u4e09\u6b21\uff09\u3001RHP-C102401434325-1 \n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u501f\u6b3e\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-29 10:51:16","updated_at":"2025-07-29 10:51:47","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"100000","borrow_collect_day":"2025-08-31","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":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2103,"comment":3},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":7540,"approve_id":2103,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7541,"approve_id":2103,"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"}}}],"approveVerifyRels":[{"id":2734,"approve_id":2103,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-29 10:51:47","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2734,"approve_id":2103,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-29 10:51:47"},"attachmentRelationships":[{"id":36131,"object_type":28,"object_id":2103,"attachment_id":27154,"attachment":{"id":27154,"key":27154,"name":"3a1ef9af-ec0c-382b-a70c-cabaa9dd5f4d","extension":"jpg","path":"\/vue\/attachment\/view\/3a1ef9af-ec0c-382b-a70c-cabaa9dd5f4d\/1081753699945_.pic.jpg","orig_name":"1081753699945_.pic.jpg"}}],"client":{"id":2115,"key":2115,"name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e"},"project":{"id":2684,"key":2684,"name":"\u56fd\u5bc6\u4e8c\u671f\u9879\u76ee","project_status":3,"buildContract":{"id":2148,"from_project":2684,"serial_no":"XMHT-202131"}},"supplier":"","purchaseContract":{},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1926,"client_id":25,"project_id":3665,"title":"\u6295\u6807\u4fdd\u8bc1\u91d1","status":2,"next_verify_user":"","verify_at":"2025-06-03 14:35:12","description":"\u7533\u8bf7\u652f\u4ed8\u6295\u6807\u4fdd\u8bc1\uff0c\u91d1\u989d\uff1a\uffe512000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u62db\u6807\u9879\u76ee\u540d\u79f0\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821\u4fe1\u606f\u5316\u8fd0\u7ef4\u9879\u76ee\n\u62db\u6807\u9879\u76ee\u7f16\u53f7\uff1a11010825210200044190-XM001\/\u7b2c1\u5305\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6536\u6b3e\u5355\u4f4d\uff1a\u5317\u4eac\u79d1\u6280\u56ed\u62cd\u5356\u62db\u6807\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u540d\uff1a\u5317\u4eac\u79d1\u6280\u56ed\u62cd\u5356\u62db\u6807\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u94f6\u884c\uff1a\u5e7f\u53d1\u94f6\u884c\u5317\u4eac\u4e07\u67f3\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a9550880031224600183\n\u7535\u6c47\u6295\u6807\u4fdd\u8bc1\u91d1\u65f6\u5e94\u5728\u7535\u6c47\u6c47\u6b3e\u9644\u8a00\u4e2d\u6ce8\u660e\uff1a\u9879\u76ee\u7f16\u53f7\uff1a11010825210200044190-XM001\/\u7b2c 1 \u5305\u6295\u6807\u4fdd\u8bc1\u91d1\n\n\u56de\u6b3e\u65e5\u671f\uff1a\u81ea\u4e2d\u6807\u901a\u77e5\u4e66\u53d1\u51fa\u4e4b\u65e5\u8d77 5 \u4e2a\u5de5\u4f5c\u65e5\u5185\u9000\u8fd8","refuse_description":"","is_resubmited":false,"created_by":1005,"created_at":"2025-06-03 14:04:56","updated_at":"2025-06-03 14:35:12","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"12000","borrow_collect_day":"2025-07-31","borrow_collect_status":1,"borrow_collect_description":"2025\u5e747\u67082\u65e5\u56de\u6b3e\u3002","borrow_collect_at":"2025-07-02 10:25:10.851983+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":1926,"comment":5},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":6949,"approve_id":1926,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6950,"approve_id":1926,"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"}}}],"approveVerifyRels":[{"id":2484,"approve_id":1926,"user_id":1001,"status":1,"description":"","verify_at":"2025-06-03 14:35:12","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2484,"approve_id":1926,"user_id":1001,"status":1,"description":"","verify_at":"2025-06-03 14:35:12"},"attachmentRelationships":[],"client":{"id":25,"key":25,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821"},"project":{"id":3665,"key":3665,"name":"24\u5e74\u865a\u62df\u5316\u7eed\u4fdd\u53ca\u670d\u52a1","project_status":5,"buildContract":""},"supplier":"","purchaseContract":{},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1927,"client_id":2115,"project_id":2684,"title":"\u6295\u6807\u4fdd\u8bc1\u91d1\u7533\u8bf7-\u6cb3\u5317\u519c\u4fe1\u9879\u76ee","status":2,"next_verify_user":"","verify_at":"2025-06-03 14:35:04","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6cb3\u5317\u519c\u4fe1\u7684\u9879\u76ee\u5e2e\u6c5f\u5357\u79d1\u53cb\u6295\u6807\u4fdd\u8bc1\u91d1\u91d1\u989d\uff1a\uffe5100000\uff0c\u5bf9\u65b9\u5df2\u7ecf\u628a\u73b0\u91d1\u6c47\u81f3\u7fc1\u5bb6\u62107062\u5361\u5185\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u5f00\u6237\u540d\u79f0\uff1a\u745e\u548c\u5b89\u60e0\u9879\u76ee\u7ba1\u7406\u96c6\u56e2\u6709\u9650\u516c\u53f8\n\u5f00 \u6237 \u884c\uff1a\u4e2d\u56fd\u6c11\u751f\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u77f3\u5bb6\u5e84\u5efa\u8bbe\u5357\u5927\u8857\u652f\u884c\n\u8d26 \u53f7\uff1a696048833\n\u6c47\u6b3e\u5907\u6ce8\uff1a\u6295\u6807\u4fdd\u8bc1\u91d1\u3001RHP-C102401434325-1\u3001\u6cb3\u5317\u519c\u4fe1\u4fe1\u606f\u7cfb\u7edf\u5bc6\u7801\u5e94\u7528\u5b89\u5168\u52a0\u56fa\u9879\u76ee\uff08\u4e8c\u6b21\uff09\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u501f\u6b3e\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-06-03 14:25:27","updated_at":"2025-06-03 14:35:04","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"100000","borrow_collect_day":"2025-08-31","borrow_collect_status":1,"borrow_collect_description":"2025\u5e746\u670812\u65e5\u56de\u6b3e\u3002","borrow_collect_at":"2025-06-12 16:59:39.553061+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":1927,"comment":5},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":6951,"approve_id":1927,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6952,"approve_id":1927,"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"}}}],"approveVerifyRels":[{"id":2485,"approve_id":1927,"user_id":1001,"status":1,"description":"","verify_at":"2025-06-03 14:35:04","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2485,"approve_id":1927,"user_id":1001,"status":1,"description":"","verify_at":"2025-06-03 14:35:04"},"attachmentRelationships":[],"client":{"id":2115,"key":2115,"name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e"},"project":{"id":2684,"key":2684,"name":"\u56fd\u5bc6\u4e8c\u671f\u9879\u76ee","project_status":3,"buildContract":{"id":2148,"from_project":2684,"serial_no":"XMHT-202131"}},"supplier":"","purchaseContract":{},"files":[{"id":34628,"object_type":29,"object_id":1927,"attachment_id":25964,"attachment":{"id":25964,"key":25964,"name":"2b313c40-f311-38f1-bacd-bf94e970290e","extension":"doc","path":"\/vue\/attachment\/view\/2b313c40-f311-38f1-bacd-bf94e970290e\/\u6cb3\u5317\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e\u4fe1\u606f\u7cfb\u7edf\u5bc6\u7801\u5e94\u7528\u5b89\u5168\u52a0\u56fa\u9879\u76ee\uff08\u4e8c\u6b21\uff09\u62db\u6807\u6587\u4ef6.doc","orig_name":"\u6cb3\u5317\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e\u4fe1\u606f\u7cfb\u7edf\u5bc6\u7801\u5e94\u7528\u5b89\u5168\u52a0\u56fa\u9879\u76ee\uff08\u4e8c\u6b21\uff09\u62db\u6807\u6587\u4ef6.doc"}},{"id":34629,"object_type":29,"object_id":1927,"attachment_id":25965,"attachment":{"id":25965,"key":25965,"name":"380a8728-79f2-36ee-8819-c611b08b16cb","extension":"jpg","path":"\/vue\/attachment\/view\/380a8728-79f2-36ee-8819-c611b08b16cb\/521748931183_.pic.jpg","orig_name":"521748931183_.pic.jpg"}},{"id":34630,"object_type":29,"object_id":1927,"attachment_id":25966,"attachment":{"id":25966,"key":25966,"name":"84b80d6a-9799-3652-a78e-2d871a8fe0d1","extension":"pdf","path":"\/vue\/attachment\/view\/84b80d6a-9799-3652-a78e-2d871a8fe0d1\/\u501f\u6b3e\u5355.pdf","orig_name":"\u501f\u6b3e\u5355.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1898,"client_id":"","project_id":"","title":"\u501f\u6b3e\u7533\u8bf7-\u6295\u6807\u4fdd\u8bc1\u91d1 \uffe530000","status":2,"next_verify_user":"","verify_at":"2025-05-27 10:09:14","description":"Tristen\uff0c\u8fd9\u4e2a\u9879\u76ee\u4e3a\u5e2e\u610f\u7545\u6295\u6807\u7684\u9879\u76ee\uff1a\u4e2d\u56fd\u5987\u5973\u7f51\u7f51\u7ad9\u5b89\u5168\u670d\u52a1\u516c\u5f00\u62db\u6807\u516c\u544ahttp:\/\/www.ccgp.gov.cn\/cggg\/zygg\/gkzb\/202505\/t20250508_24562630.htm \n\n\u73b0\u5bf9\u65b9\u5df2\u5c06\u6b3e\u9879\u6c47\u81f3\uff1a\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225 8801 7450 7062\n\u7533\u8bf7\u5bf9\u516c\u4ed8\u51fa\uff1a\n\u6295\u6807\u4fdd\u8bc1\u91d1\u91d1\u989d\uff1a\u4eba\u6c11\u5e0130000\u5143\n\u6295\u6807\u4fdd\u8bc1\u91d1\u94f6\u884c\u8d26\u53f7\uff1a\n\u6536\u6b3e\u5355\u4f4d\uff1a\u5317\u4eac\u6c47\u8bda\u91d1\u6865\u56fd\u9645\u62db\u6807\u54a8\u8be2\u6709\u9650\u516c\u53f8\n\u8d26\u53f7\uff1a10000010169207\n\u5f00\u6237\u94f6\u884c\uff1a\u6d59\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u884c\u8425\u4e1a\u90e8\n\u5f00\u6237\u884c\u884c\u53f7\uff1a316100000025\n\u5907\u6ce8\u6ce8\u660e\u9879\u76ee\u7f16\u53f7\uff1aBJJQ-2025-342\n\uff08\u6c47\u6b3e\u65f6\uff0c\u8bf7\u8f93\u5165\u5f00\u6237\u94f6\u884c\u5168\u79f0\u201c\u6d59\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u884c\u8425\u4e1a\u90e8\u201d\uff0c\u4ee5\u907f\u514d\u51fa\u73b0\u6c47\u6b3e\u4e0d\u6210\u529f\uff09\n\n\u8bf7\u60a8\u5ba1\u6279\uff01\n","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-05-27 10:08:26","updated_at":"2025-05-27 10:09:14","supplier_id":511,"purchase_contract_id":"","amount":"","borrow_amount":"30000","borrow_collect_day":"2025-07-31","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"2025-06-05 16:24:42.348284+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":1898,"comment":5},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":6846,"approve_id":1898,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6847,"approve_id":1898,"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"}}}],"approveVerifyRels":[{"id":2448,"approve_id":1898,"user_id":1001,"status":1,"description":"","verify_at":"2025-05-27 10:09:14","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2448,"approve_id":1898,"user_id":1001,"status":1,"description":"","verify_at":"2025-05-27 10:09:14"},"attachmentRelationships":[{"id":34407,"object_type":28,"object_id":1898,"attachment_id":25822,"attachment":{"id":25822,"key":25822,"name":"eb03902d-188b-307a-99fb-0322c1656a0d","extension":"jpg","path":"\/vue\/attachment\/view\/eb03902d-188b-307a-99fb-0322c1656a0d\/471748311125_.pic.jpg","orig_name":"471748311125_.pic.jpg"}}],"client":{},"project":{},"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":{},"files":[{"id":34408,"object_type":29,"object_id":1898,"attachment_id":25823,"attachment":{"id":25823,"key":25823,"name":"6b8451eb-1359-3b89-b12e-6a01adfe772e","extension":"pdf","path":"\/vue\/attachment\/view\/6b8451eb-1359-3b89-b12e-6a01adfe772e\/\u501f\u6b3e\u5355.pdf","orig_name":"\u501f\u6b3e\u5355.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1886,"client_id":3340,"project_id":3867,"title":"\u6d4b\u8bd5\u8bbe\u5907\u62bc\u91d1-\u4ed8\u6b3e\u7533\u8bf7","status":2,"next_verify_user":"","verify_at":"2025-05-22 14:03:37","description":"Tristen\uff0c\u6cfd\u6587\u7528\u6237\u9700\u8981\u6d4b\u8bd5\u6df1\u4fe1\u670d\u8bbe\u5907\uff0c\u9700\u8981\u652f\u4ed8\u62bc\u91d1\uff1a\u91d1\u989d\uffe551642\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u62bc\u91d1\u8d26\u53f7\uff1a\n\u8d26\u6237\u540d:\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\u5730\u5740:\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u603b\u884c\u5927\u53a6\u8425\u4e1a\u90e8\n\u94f6\u884c\u8d26\u53f7:755901852710611\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-05-22 14:03:01","updated_at":"2025-05-22 14:03:37","supplier_id":138,"purchase_contract_id":"","amount":"","borrow_amount":"51642","borrow_collect_day":"2025-06-30","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"2025-06-10 16:43:33.936799+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":1886,"comment":6},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":6808,"approve_id":1886,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6809,"approve_id":1886,"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"}}}],"approveVerifyRels":[{"id":2434,"approve_id":1886,"user_id":1001,"status":1,"description":"","verify_at":"2025-05-22 14:03:37","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2434,"approve_id":1886,"user_id":1001,"status":1,"description":"","verify_at":"2025-05-22 14:03:37"},"attachmentRelationships":[{"id":34363,"object_type":28,"object_id":1886,"attachment_id":25786,"attachment":{"id":25786,"key":25786,"name":"3596c0b5-a960-3f12-8ef9-41ef9d9166d7","extension":"png","path":"\/vue\/attachment\/view\/3596c0b5-a960-3f12-8ef9-41ef9d9166d7\/image.png","orig_name":"image.png"}}],"client":{"id":3340,"key":3340,"name":"\u5317\u4eac\u661f\u8fb0\u672a\u6765\u7a7a\u95f4\u6280\u672f\u7814\u7a76\u9662\uff08\u8fc7\u5355\uff09"},"project":{"id":3867,"key":3867,"name":"\u65b0\u8d2d\u684c\u9762\u4e91\u8bbe\u5907","project_status":4,"buildContract":""},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":{},"files":[{"id":34364,"object_type":29,"object_id":1886,"attachment_id":25787,"attachment":{"id":25787,"key":25787,"name":"07d11c69-8ea5-3210-a2dc-5690b4952082","extension":"pdf","path":"\/vue\/attachment\/view\/07d11c69-8ea5-3210-a2dc-5690b4952082\/2025_05_22_14_02_38.pdf","orig_name":"2025_05_22_14_02_38.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1856,"client_id":2128,"project_id":3559,"title":"\u6295\u6807\u4fdd\u8bc1\u91d1\u7533\u8bf7-\u8ba1\u7b97\u5904\u7406\u5e73\u53f0\u9879\u76ee \u62db\u6807\u7f16\u53f7\uff1aZC25G230087","status":2,"next_verify_user":"","verify_at":"2025-05-08 17:30:50","description":"\u4eba\u8bda\uff0c33\u6240\u9ad8\u6027\u80fd\u5e73\u53f0\u6295\u6807\uff0c\u7528\u822a\u5929\u4fe1\u606f\u7cfb\u7edf\u5de5\u7a0b\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u6295\u6807\uff0c\u9700\u8981\u501f\u6b3e\u57ab\u4ed8\u6295\u6807\u4fdd\u8bc1\u91d1\u6b3e80100\u5143\uff0c\u5bf9\u65b9\u56de\u6b3e\u540e\u8fd4\u8fd880100\u5143\u3002\n@\u96c5\u82b3\uff1a\u53e6\u5916\u9700\u8981\u5728\u4e24\u4e2a\u6587\u4ef6\u4e0a\u76d6\u7ae0","refuse_description":"","is_resubmited":false,"created_by":5087,"created_at":"2025-05-08 17:30:10","updated_at":"2025-05-08 17:30:50","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"80100","borrow_collect_day":"2025-07-08","borrow_collect_status":1,"borrow_collect_description":"2025\u5e745\u670821\u65e5\u6536\u5230\u6c47\u6b3e\u3002","borrow_collect_at":"2025-05-22 10:56:34.543412+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":1856,"comment":8},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":6685,"approve_id":1856,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6686,"approve_id":1856,"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"}}}],"approveVerifyRels":[{"id":2395,"approve_id":1856,"user_id":1001,"status":1,"description":"","verify_at":"2025-05-08 17:30:50","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2395,"approve_id":1856,"user_id":1001,"status":1,"description":"","verify_at":"2025-05-08 17:30:50"},"attachmentRelationships":[],"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"},"project":{"id":3559,"key":3559,"name":"\u56fe\u5f62\u8bbe\u8ba1\u4e0e\u4eff\u771f\u8ba1\u7b97\u4e00\u4f53\u5316\u5e73\u53f0-K","project_status":5,"buildContract":""},"supplier":"","purchaseContract":{},"files":[{"id":33993,"object_type":29,"object_id":1856,"attachment_id":25446,"attachment":{"id":25446,"key":25446,"name":"e1dedf78-fe6c-3d1c-abf3-0d34756ecb00","extension":"docx","path":"\/vue\/attachment\/view\/e1dedf78-fe6c-3d1c-abf3-0d34756ecb00\/\u786e\u8ba4\u51fd-\u6807\u524d.docx","orig_name":"\u786e\u8ba4\u51fd-\u6807\u524d.docx"}},{"id":33994,"object_type":29,"object_id":1856,"attachment_id":25447,"attachment":{"id":25447,"key":25447,"name":"b122f656-ba71-307e-ba66-d7d8c5c288ca","extension":"docx","path":"\/vue\/attachment\/view\/b122f656-ba71-307e-ba66-d7d8c5c288ca\/\u5408\u4f5c\u534f\u8bae\u4e66-\u6807\u524d.docx","orig_name":"\u5408\u4f5c\u534f\u8bae\u4e66-\u6807\u524d.docx"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1704,"client_id":"","project_id":"","title":"\u8f6f\u8003\u62a5\u540d\u53ca\u57f9\u8bad\u8d39","status":2,"next_verify_user":"","verify_at":"2025-03-11 12:32:06","description":"\u4eba\u8bda\uff0c\u8f6f\u80032\u4eba\u57f9\u8bad\u52a0\u62a5\u540d\u8d39\uff0c\u517110\u4e07\u5143\uff0c\u5982\u679c\u8003\u8bd5\u6ca1\u901a\u8fc7\uff0c\u9000\u8d3999520\uff0c\u5982\u679c\u901a\u8fc7\uff0c\u5bf9\u65b9\u53ef\u4ee5\u7ed9\u6211\u4eec\u5f00\u57f9\u8bad\u53d1\u7968\uff0c\u7a0e\u70b9\u6211\u4eec\u627f\u62c5\u3002\n\n\u5b66\u77e5\u65b9\u8fbe\u7f34\u8d39\u65b9\u5f0f\uff08\u5317\u4eac\uff09\uff1a\n1. \u5bf9\u516c\u8d26\u6237\n\u6237\u540d\uff1a\u5317\u4eac\u5b66\u77e5\u65b9\u8fbe\u4fe1\u606f\u79d1\u6280\u7814\u7a76\u9662\n\u8d26\u53f7\uff1a11050163560000000674\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u6e05\u534e\u56ed\u652f\u884c","refuse_description":"","is_resubmited":false,"created_by":1005,"created_at":"2025-03-11 12:21:43","updated_at":"2025-03-11 12:32:06","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"100000","borrow_collect_day":"2025-07-28","borrow_collect_status":1,"borrow_collect_description":"2025\u5e745\u670828\u65e5\u9000\u56de\u3002","borrow_collect_at":"2025-05-28 17:35:51.030951+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":1704,"comment":5},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":6195,"approve_id":1704,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6196,"approve_id":1704,"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"}}}],"approveVerifyRels":[{"id":2194,"approve_id":1704,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-11 12:32:06","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2194,"approve_id":1704,"user_id":1001,"status":1,"description":"","verify_at":"2025-03-11 12:32:06"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":{},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1439,"client_id":"","project_id":"","title":"\u501f\u6b3e\u7533\u8bf7","status":2,"next_verify_user":"","verify_at":"2024-11-27 13:53:36","description":"\u4eba\u8bda\uff0c\u6211\u4e2a\u4eba\u7528\u6b3e\uff0c\u9700\u898160\u4e07\u5468\u8f6c\uff0c12\u6708\u5e95\u4e4b\u524d\u6362\u56de\u6765\u3002\n\n\u8d75\u6657\u7131 \u4e2d\u56fd\u94f6\u884c 6217900100012601103","refuse_description":"","is_resubmited":false,"created_by":1005,"created_at":"2024-11-27 13:53:22","updated_at":"2024-11-27 13:53:36","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"600000","borrow_collect_day":"2024-12-30","borrow_collect_status":1,"borrow_collect_description":"60\u4e07\u501f\u6b3e\u90fd\u5df2\u7ecf\u8fd8\u6e05\u3002","borrow_collect_at":"2024-12-27 09:53:06.586982+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":1439,"comment":9},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":5212,"approve_id":1439,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":5213,"approve_id":1439,"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"}}}],"approveVerifyRels":[{"id":1860,"approve_id":1439,"user_id":1001,"status":1,"description":"","verify_at":"2024-11-27 13:53:36","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":1860,"approve_id":1439,"user_id":1001,"status":1,"description":"","verify_at":"2024-11-27 13:53:36"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":{},"files":[],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""},{"id":1374,"client_id":3301,"project_id":"","title":"\u6295\u6807\u4fdd\u8bc1\u91d1\u7533\u8bf7-\u5317\u4eac\u5b8f\u4e00\u5de5\u7a0b\u7ba1\u7406\u54a8\u8be2\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2024-11-05 14:05:27","description":"Tristen\uff0c\u7533\u8bf7\u66ff\u610f\u7545\u91d1\u878d\u65f6\u62a5\u793e\u9879\u76ee\u9012\u4ea4\u6295\u6807\u4fdd\u8bc1\u91d1\uff0c\u91d1\u989d\uff1a\uffe510042\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u8d26\u6237\u540d\u79f0\uff1a\u5317\u4eac\u5b8f\u4e00\u5de5\u7a0b\u7ba1\u7406\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u4ec5\u9650\u6295\u6807\u4fdd\u8bc1\u91d1\u4f7f\u7528\uff09\n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e7f\u6e20\u8def\u652f\u884c\n\u8d26\u53f7\uff1a1105 0171 5000 0000 0967\n\u6c47\u6b3e\u5907\u6ce8\u9879\u76ee\u7f16\u53f7\uff1aHYGC-2024-0042\n\n\u5907\u6ce8\uff1a\u5bf9\u516c\u4ed8\u6b3e\u7533\u8bf7\u5355\u5df2\u63d0\u4ea4\uff0c\u610f\u7545\u7684\u73b0\u91d1\u5df2\u6536\u52307062\u5361\u53f7\u3002","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2024-11-05 10:45:39","updated_at":"2024-11-05 14:05:27","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"10042","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"2024\u5e7412\u670819\u65e5\u5df2\u9000\u56de\u3002","borrow_collect_at":"2025-05-08 14:39:42.981521+08","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":1374,"comment":5},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7","approve_verify_user":"1001","approve_carbon_copy_user":"5388,1013"},"approveCarbonCopyRels":[{"id":4956,"approve_id":1374,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":4957,"approve_id":1374,"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"}}}],"approveVerifyRels":[{"id":1780,"approve_id":1374,"user_id":1001,"status":1,"description":"","verify_at":"2024-11-05 14:05:27","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":1780,"approve_id":1374,"user_id":1001,"status":1,"description":"","verify_at":"2024-11-05 14:05:27"},"attachmentRelationships":[],"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e"},"project":{},"supplier":"","purchaseContract":{},"files":[{"id":30015,"object_type":29,"object_id":1374,"attachment_id":22498,"attachment":{"id":22498,"key":22498,"name":"eb038ae7-6ff1-3f24-ab83-c2f513795b98","extension":"pdf","path":"\/vue\/attachment\/view\/eb038ae7-6ff1-3f24-ab83-c2f513795b98\/2024_11_05_10_44_45.pdf","orig_name":"2024_11_05_10_44_45.pdf"}}],"erpOtherCollectTickets":[],"erpCollectTicketSettles":[],"un_settle_amount":0,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_payment":false,"can_borrow":false,"can_create_erp_other_collect_ticket":false,"can_create_erp_collect_ticket":false,"can_create_erp_cash_cost_ticket":false,"bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7","borrow_expire_day":""}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":10},{"key":1,"name":"\u5ba1\u6279\u4e2d","count":0},{"key":2,"name":"\u5df2\u901a\u8fc7","count":10},{"key":4,"name":"\u5df2\u62d2\u7edd","count":0}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":3},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":10,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-26 15:30:52') RETURNING "id" |
15:30:52.601 | 2.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (1780, 1860, 2194, 2395, 2434, 2448, 2484, 2485, 2734, 2784)) |
15:30:52.504 | 1.9 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
15:30:52.616 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374)) |
15:30:52.603 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (1780, 1860, 2194, 2395, 2434, 2448, 2484, 2485, 2734, 2784)) |
15:30:52.606 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374)) |
15:30:52.611 | 1.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2684, 3665, 3867, 3559) |
15:30:52.614 | 1.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (511, 138) |
15:30:52.509 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:30:52.628 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=55378 |
15:30:52.622 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE (amount - settle_amount > 0) AND ("status"=2) AND ("id"=5) |
15:30:52.514 | 0.9 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
15:30:52.598 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374) |
15:30:52.523 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1001) AND ("status" != 0) |
15:30:52.613 | 0.6 ms | yii\db\Command::query | SELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3665, 3559, 3867, 2684) |
15:30:52.597 | 0.6 ms | yii\db\Command::query | SELECT "id", "name", "approve_verify_user", "approve_carbon_copy_user" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (213, 100, 45, 166, 135, 140, 184, 189, 154, 197, 199, 204, 1, 6, 7, 131, 2, 129, 172, 130, 179, 181, 164, 175, 205, 226, 128, 155, 171, 142, 210, 200, 212, 194, 2100000001, 209, 153, 331, 349, 353, 359, 373, 374, 377, 340, 369, 341, 336)) |
15:30:52.600 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374) ORDER BY "id" |
15:30:52.605 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374)) ORDER BY "id" |
15:30:52.555 | 0.4 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1005, 5087, 1001)) |
15:30:52.605 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374)) ORDER BY "id" |
15:30:52.555 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 1, 4) |
15:30:52.611 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2115, 25, 3340, 2128, 3301) |
15:30:52.623 | 0.3 ms | yii\db\Command::query | SELECT 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 - settle_amount as un_settle_amount, handler, serial_no, abstract FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE (amount - settle_amount > 0) AND ("status"=2) AND ("id"=5) |
15:30:52.621 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374) |
15:30:52.554 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 1005, 5087) |
15:30:52.599 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013) |
15:30:52.600 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:30:52.599 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1013, 5388)) |
15:30:52.601 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
15:30:52.623 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" WHERE "approve_id" IN (2132, 2103, 1926, 1927, 1898, 1886, 1856, 1704, 1439, 1374) |