Database Queries

总计43条数据
TimeDurationTypeQuery
  
10:18:32.44910.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA'

10:18:32.4611.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

10:18:32.4651.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='90') AND ("deleted"=FALSE)

10:18:32.4701.7 msSELECTSELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_reimbursements" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"

10:18:32.47218.1 msSELECTSELECT COUNT(*) FROM (SELECT DISTINCT r.*, CASE WHEN r.status = 2 THEN 1 ELSE 0 END as settlesort FROM "a57be577deb434"."tbl_reimbursements" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_reimbursement_verify_rels" "rvr" ON rvr.reimbursement_id = r.id LEFT JOIN "a57be577deb434"."tbl_reimbursement_settle_rels" "rsr" ON rsr.reimbursement_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 = 15 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 7 LEFT JOIN "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" "rccr" ON rccr.reimbursement_id = r.id WHERE (("r"."status" != 0) OR ("r"."created_by"=5295)) AND (("r"."created_by"=5295) OR ("rccr"."user_id"=5295) OR ("rsr"."user_id"=5295) OR ("rvr"."user_id"=5295)) AND ("r"."client_id"='90') GROUP BY "r"."id" ORDER BY "r"."created_at" DESC) "c"

10:18:32.49114.9 msSELECTSELECT DISTINCT r.*, CASE WHEN r.status = 2 THEN 1 ELSE 0 END as settlesort FROM "a57be577deb434"."tbl_reimbursements" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_reimbursement_verify_rels" "rvr" ON rvr.reimbursement_id = r.id LEFT JOIN "a57be577deb434"."tbl_reimbursement_settle_rels" "rsr" ON rsr.reimbursement_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 = 15 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt2" ON dt2.object_id = r.id AND dt2.term_id = 18 AND dt2.object_type = 7 LEFT JOIN "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" "rccr" ON rccr.reimbursement_id = r.id WHERE (("r"."status" != 0) OR ("r"."created_by"=5295)) AND (("r"."created_by"=5295) OR ("rccr"."user_id"=5295) OR ("rsr"."user_id"=5295) OR ("rvr"."user_id"=5295)) AND ("r"."client_id"='90') GROUP BY "r"."id" ORDER BY "r"."created_at" DESC LIMIT 10

10:18:32.5071.0 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1011)

10:18:32.5084.0 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5295))

10:18:32.5130.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 1)

10:18:32.51333.1 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20) AND ("object_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)) GROUP BY "object_id"

10:18:32.54717.1 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)) GROUP BY "object_id"

10:18:32.5640.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)

10:18:32.5650.4 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (185, 369, 184, 307, 349, 380, 379))

10:18:32.5650.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267))

10:18:32.5660.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (349, 369, 380, 379)

10:18:32.5660.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

10:18:32.5660.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)

10:18:32.5670.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)

10:18:32.5671.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267) ORDER BY "id"

10:18:32.5690.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1001, 5295, 1005)

10:18:32.5690.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5252, 1005, 1001))

10:18:32.5701.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)) ORDER BY "id"

10:18:32.5712.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)) ORDER BY "id"

10:18:32.5732.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267))

10:18:32.5750.4 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24159, 24144, 24612, 24635, 25475, 26293, 26977, 26978)

10:18:32.5760.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=90

10:18:32.5760.5 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "created_by", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3731

10:18:32.5770.3 msSELECTSELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3

10:18:32.5770.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

10:18:32.5780.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)

10:18:32.5780.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1

10:18:32.5780.4 msSELECTSELECT "id", "id" AS "key", "client_id", "project_id", "scenario_id", "scenario_option_id" FROM "a57be577deb434"."tbl_work_logs" WHERE "id" IN (37531, 37426, 37196, 36849, 36564)

10:18:32.5790.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (66, 72)

10:18:32.5790.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1

10:18:32.5800.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=90

10:18:32.5800.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE ("user_id"=5295) AND ("reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267))

10:18:32.5810.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)

10:18:32.5820.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

10:18:32.5820.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)

10:18:32.5821.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267))

10:18:32.5840.3 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24378, 24379, 26378, 26390, 26391, 26392)

10:18:32.5840.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id" IN (7875, 7876, 7775, 7744, 7593, 7421, 7413, 7341, 7268, 7267)

10:18:32.5862.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1146, 'v2/reimbursement/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"90","posttime":"1754619520","token":"f69037e2ac5787b1cd472914a43a6094","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":7875,"status":2,"amount":"68.00","occurrence_at":"2025-06-04 09:46:00","settle_accounts_at":"","settle_accounts_by":null,"description":"\u8bf7\u82cf\u9ece\u4e16\u5ba2\u6237\u559d\u5496\u5561\u8d39\u7528\u62a5\u9500","created_by":5295,"created_at":"2025-07-21 11:17:07","updated_at":"2025-07-21 16:37:00","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":37531,"pre_sales_id":null,"implement_record_id":null,"settlesort":1,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7875,"comment":4},"unreadComments":null,"type":{"id":185,"name":"\u62db\u5f85\u8d39"},"costType":{"id":369,"object_id":7875,"taxonomy_id":369,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","term_id":18,"description":null,"sort":5,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":185,"is_system":false,"serial_no":null},"name":"\u9910\u996e\u8d39"},"settleAccountsBy":null,"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":28500,"reimbursement_id":7875,"user_id":5252,"status":1,"verify_at":"2025-07-21 11:28:56","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":28501,"reimbursement_id":7875,"user_id":1005,"status":1,"verify_at":"2025-07-21 16:37:00","user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":28500,"reimbursement_id":7875,"user_id":5252,"status":1,"verify_at":"2025-07-21 11:28:56"},"attachmentRelationships":[{"id":35911,"object_type":19,"object_id":7875,"attachment_id":26978,"attachment":{"id":26978,"key":26978,"name":"957cbb65-16dd-3e23-a5c1-5fae9ce96e4c","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/957cbb65-16dd-3e23-a5c1-5fae9ce96e4c\/IMG_20250721_111655.jpg","orig_name":"IMG_20250721_111655.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":37531,"key":37531,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":72,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":10398,"reimbursement_id":7875,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#F39800","status_display":"\u672a\u7ed3\u7b97"},{"id":7876,"status":2,"amount":"294.00","occurrence_at":"2025-06-04 09:46:00","settle_accounts_at":"","settle_accounts_by":null,"description":"\u8bf7\u82cf\u9ece\u4e16\u5ba2\u6237\u5403\u996d\u8d39\u7528\u62a5\u9500","created_by":5295,"created_at":"2025-07-21 11:16:40","updated_at":"2025-07-21 16:37:00","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":37531,"pre_sales_id":null,"implement_record_id":null,"settlesort":1,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7876,"comment":4},"unreadComments":null,"type":{"id":185,"name":"\u62db\u5f85\u8d39"},"costType":{"id":369,"object_id":7876,"taxonomy_id":369,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","term_id":18,"description":null,"sort":5,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":185,"is_system":false,"serial_no":null},"name":"\u9910\u996e\u8d39"},"settleAccountsBy":null,"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":28498,"reimbursement_id":7876,"user_id":5252,"status":1,"verify_at":"2025-07-21 11:29:09","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":28499,"reimbursement_id":7876,"user_id":1005,"status":1,"verify_at":"2025-07-21 16:37:00","user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":28498,"reimbursement_id":7876,"user_id":5252,"status":1,"verify_at":"2025-07-21 11:29:09"},"attachmentRelationships":[{"id":35910,"object_type":19,"object_id":7876,"attachment_id":26977,"attachment":{"id":26977,"key":26977,"name":"5b3d4c42-2775-343d-900e-b85c0cb3c39e","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/5b3d4c42-2775-343d-900e-b85c0cb3c39e\/IMG_20250721_111631.jpg","orig_name":"IMG_20250721_111631.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":37531,"key":37531,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":72,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":10397,"reimbursement_id":7876,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#F39800","status_display":"\u672a\u7ed3\u7b97"},{"id":7775,"status":3,"amount":"484.95","occurrence_at":"2025-05-21 00:00:00","settle_accounts_at":"2025-07-04 14:14:36","settle_accounts_by":1013,"description":"5\u6708\u4efd\u4eac\u4e1c\/\u987a\u4e30\u5feb\u9012\u8d39\u7528","created_by":1011,"created_at":"2025-06-18 16:56:47","updated_at":"2025-07-04 14:14:36","refuse_description":"","client_id":90,"project_id":3731,"next_verify_user":null,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":7775,"comment":8},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":379,"object_id":7775,"taxonomy_id":379,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":379,"name":"\u5feb\u9012\u8d39","term_id":18,"description":null,"sort":18,"created_by":1001,"created_at":"2024-04-16 22:20:15","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u5feb\u9012\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":27995,"reimbursement_id":7775,"user_id":5295,"status":1,"verify_at":"2025-06-18 17:13:24","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":27996,"reimbursement_id":7775,"user_id":5252,"status":1,"verify_at":"2025-06-23 10:08:00","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":27997,"reimbursement_id":7775,"user_id":1001,"status":1,"verify_at":"2025-06-30 16:47:07","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":27995,"reimbursement_id":7775,"user_id":5295,"status":1,"verify_at":"2025-06-18 17:13:24"},"attachmentRelationships":[],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","created_by":5295,"project_status":3,"budget":"229600","collected":"229600","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}},"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":10202,"reimbursement_id":7775,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[{"id":35180,"object_type":22,"object_id":7775,"attachment_id":26378,"attachment":{"id":26378,"key":26378,"name":"9655caec-d777-3d16-8822-a1e84d5c3287","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/9655caec-d777-3d16-8822-a1e84d5c3287\/\u9b4f\u6cfd\u6587.pdf","orig_name":"\u9b4f\u6cfd\u6587.pdf"}},{"id":35181,"object_type":22,"object_id":7775,"attachment_id":26390,"attachment":{"id":26390,"key":26390,"name":"7006f2c2-dd14-379e-b556-7916b8db906c","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/7006f2c2-dd14-379e-b556-7916b8db906c\/\u987a\u4e301060.2.pdf","orig_name":"\u987a\u4e301060.2.pdf"}},{"id":35182,"object_type":22,"object_id":7775,"attachment_id":26391,"attachment":{"id":26391,"key":26391,"name":"fa29e968-faf2-30c8-ab42-72fe72d9dd17","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/fa29e968-faf2-30c8-ab42-72fe72d9dd17\/\u4eac\u4e1c\u6708\u7ed3.pdf","orig_name":"\u4eac\u4e1c\u6708\u7ed3.pdf"}},{"id":35183,"object_type":22,"object_id":7775,"attachment_id":26392,"attachment":{"id":26392,"key":26392,"name":"f512b9e4-5df3-38fd-84ff-486afc0bc488","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/f512b9e4-5df3-38fd-84ff-486afc0bc488\/\u987a\u4e30\u540c\u57ce\u6025\u9001\u7535\u5b50\u53d1\u7968.pdf","orig_name":"\u987a\u4e30\u540c\u57ce\u6025\u9001\u7535\u5b50\u53d1\u7968.pdf"}}],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7744,"status":3,"amount":"57.00","occurrence_at":"2025-05-14 09:43:00","settle_accounts_at":"2025-07-04 14:04:05","settle_accounts_by":1013,"description":"\u62dc\u8bbf\u82cf\u9ece\u4e16\u5ba2\u6237\u8f66\u8d39\u62a5\u9500","created_by":5295,"created_at":"2025-06-16 13:38:31","updated_at":"2025-07-04 14:04:05","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":37426,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7744,"comment":4},"unreadComments":null,"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":349,"object_id":7744,"taxonomy_id":349,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":349,"name":"\u7684\u58eb\u8d39","term_id":18,"description":null,"sort":3,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":184,"is_system":false,"serial_no":null},"name":"\u7684\u58eb\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":27911,"reimbursement_id":7744,"user_id":5252,"status":1,"verify_at":"2025-06-18 10:18:17","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":27912,"reimbursement_id":7744,"user_id":1001,"status":1,"verify_at":"2025-06-30 16:47:04","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":27911,"reimbursement_id":7744,"user_id":5252,"status":1,"verify_at":"2025-06-18 10:18:17"},"attachmentRelationships":[{"id":35067,"object_type":19,"object_id":7744,"attachment_id":26293,"attachment":{"id":26293,"key":26293,"name":"0d55672e-3488-392f-9bbf-5d28cd3c2992","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/0d55672e-3488-392f-9bbf-5d28cd3c2992\/IMG_20250616_133309.jpg","orig_name":"IMG_20250616_133309.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":37426,"key":37426,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":72,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":10172,"reimbursement_id":7744,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7593,"status":3,"amount":"897.00","occurrence_at":"2025-04-10 12:00:00","settle_accounts_at":"2025-05-29 10:37:16","settle_accounts_by":1013,"description":"\u8bf7\u82cf\u9ece\u4e16\u5ba2\u6237\u5403\u996d\u8d39\u7528\u62a5\u9500","created_by":5295,"created_at":"2025-05-12 13:26:12","updated_at":"2025-05-29 10:37:16","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":37196,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7593,"comment":5},"unreadComments":null,"type":{"id":185,"name":"\u62db\u5f85\u8d39"},"costType":{"id":369,"object_id":7593,"taxonomy_id":369,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","term_id":18,"description":null,"sort":5,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":185,"is_system":false,"serial_no":null},"name":"\u9910\u996e\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":27205,"reimbursement_id":7593,"user_id":5252,"status":1,"verify_at":"2025-05-14 10:11:19","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":27206,"reimbursement_id":7593,"user_id":1001,"status":1,"verify_at":"2025-05-29 10:19:55","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":27205,"reimbursement_id":7593,"user_id":5252,"status":1,"verify_at":"2025-05-14 10:11:19"},"attachmentRelationships":[{"id":34027,"object_type":19,"object_id":7593,"attachment_id":25475,"attachment":{"id":25475,"key":25475,"name":"a3bff575-25dc-34c8-ba66-2e90df64d1bf","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a3bff575-25dc-34c8-ba66-2e90df64d1bf\/IMG_20250512_132546.jpg","orig_name":"IMG_20250512_132546.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":37196,"key":37196,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":66,"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9883,"reimbursement_id":7593,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7421,"status":3,"amount":"90.00","occurrence_at":"2025-02-27 10:31:00","settle_accounts_at":"2025-03-26 09:50:52","settle_accounts_by":1013,"description":"\u8bf7\u82cf\u9ece\u4e16\u5ba2\u6237\u559d\u5496\u5561\u8d39\u7528\u62a5\u9500","created_by":5295,"created_at":"2025-03-17 15:12:54","updated_at":"2025-03-26 09:50:52","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":36849,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7421,"comment":4},"unreadComments":null,"type":{"id":185,"name":"\u62db\u5f85\u8d39"},"costType":{"id":369,"object_id":7421,"taxonomy_id":369,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","term_id":18,"description":null,"sort":5,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":185,"is_system":false,"serial_no":null},"name":"\u9910\u996e\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":26501,"reimbursement_id":7421,"user_id":5252,"status":1,"verify_at":"2025-03-18 10:00:41","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":26502,"reimbursement_id":7421,"user_id":1001,"status":1,"verify_at":"2025-03-20 08:20:30","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26501,"reimbursement_id":7421,"user_id":5252,"status":1,"verify_at":"2025-03-18 10:00:41"},"attachmentRelationships":[{"id":32981,"object_type":19,"object_id":7421,"attachment_id":24635,"attachment":{"id":24635,"key":24635,"name":"c215417d-e28c-37f9-a7e5-0137a22dfeb1","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/c215417d-e28c-37f9-a7e5-0137a22dfeb1\/IMG_20250317_151241.jpg","orig_name":"IMG_20250317_151241.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":36849,"key":36849,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":72,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9598,"reimbursement_id":7421,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7413,"status":3,"amount":"65.00","occurrence_at":"2025-02-27 10:31:00","settle_accounts_at":"2025-03-26 09:50:52","settle_accounts_by":1013,"description":"\u62dc\u8bbf\u82cf\u9ece\u4e16\u5ba2\u6237\u8f66\u8d39\u62a5\u9500","created_by":5295,"created_at":"2025-03-17 14:54:57","updated_at":"2025-03-26 09:50:52","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":36849,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7413,"comment":4},"unreadComments":null,"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":349,"object_id":7413,"taxonomy_id":349,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":349,"name":"\u7684\u58eb\u8d39","term_id":18,"description":null,"sort":3,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":184,"is_system":false,"serial_no":null},"name":"\u7684\u58eb\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":26445,"reimbursement_id":7413,"user_id":5252,"status":1,"verify_at":"2025-03-18 10:08:42","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":26446,"reimbursement_id":7413,"user_id":1001,"status":1,"verify_at":"2025-03-20 08:20:30","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26445,"reimbursement_id":7413,"user_id":5252,"status":1,"verify_at":"2025-03-18 10:08:42"},"attachmentRelationships":[{"id":32959,"object_type":19,"object_id":7413,"attachment_id":24612,"attachment":{"id":24612,"key":24612,"name":"ef34d44d-038a-3bcc-8d54-4e9ded5820d9","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/ef34d44d-038a-3bcc-8d54-4e9ded5820d9\/IMG_20250317_145242.jpg","orig_name":"IMG_20250317_145242.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":36849,"key":36849,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":72,"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9570,"reimbursement_id":7413,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7341,"status":3,"amount":"29.50","occurrence_at":"2025-02-26 00:00:00","settle_accounts_at":"2025-04-01 15:37:10","settle_accounts_by":1013,"description":"\u95ea\u9001\u8d39\uff08\u5c0f\u7c73\u624b\u8868\u95ea\u9001\u7ed9\u5434\u660a\uff0c\u65b9\u4fbf\u7b2c\u4e8c\u5929\u62dc\u8bbf\u7528\u6237\uff09","created_by":1011,"created_at":"2025-03-04 14:35:53","updated_at":"2025-04-01 15:37:10","refuse_description":null,"client_id":90,"project_id":3731,"next_verify_user":null,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":7341,"comment":5},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":380,"object_id":7341,"taxonomy_id":380,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":380,"name":"\u7269\u6d41\u8d39","term_id":18,"description":null,"sort":19,"created_by":1001,"created_at":"2024-04-16 22:20:28","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u7269\u6d41\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":26183,"reimbursement_id":7341,"user_id":5295,"status":1,"verify_at":"2025-03-04 19:41:39","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":26184,"reimbursement_id":7341,"user_id":5252,"status":1,"verify_at":"2025-03-18 10:19:36","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":26185,"reimbursement_id":7341,"user_id":1001,"status":1,"verify_at":"2025-03-20 08:20:26","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26183,"reimbursement_id":7341,"user_id":5295,"status":1,"verify_at":"2025-03-04 19:41:39"},"attachmentRelationships":[],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":{"id":3731,"key":3731,"name":"2024veeam\u548c\u5b58\u50a8\u7eed\u4fdd","created_by":5295,"project_status":3,"budget":"229600","collected":"229600","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}},"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9460,"reimbursement_id":7341,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[{"id":32659,"object_type":22,"object_id":7341,"attachment_id":24378,"attachment":{"id":24378,"key":24378,"name":"851576b4-5bff-39a6-8a65-860fceefd2e5","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/851576b4-5bff-39a6-8a65-860fceefd2e5\/\u95ea\u9001\u7535\u5b50\u7968\u636e.pdf","orig_name":"\u95ea\u9001\u7535\u5b50\u7968\u636e.pdf"}},{"id":32660,"object_type":22,"object_id":7341,"attachment_id":24379,"attachment":{"id":24379,"key":24379,"name":"94c2f9de-3920-3f23-bbd9-b62598a7d40e","extension":"pdf","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/94c2f9de-3920-3f23-bbd9-b62598a7d40e\/\u95ea\u9001\u7535\u5b50\u7968\u636e\u884c\u7a0b\u5355.pdf","orig_name":"\u95ea\u9001\u7535\u5b50\u7968\u636e\u884c\u7a0b\u5355.pdf"}}],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7268,"status":3,"amount":"465.00","occurrence_at":"2025-01-14 11:58:00","settle_accounts_at":"2025-02-26 11:31:25","settle_accounts_by":1013,"description":"\u8bf7\u82cf\u9ece\u4e16\u5ba2\u6237\u559d\u5496\u5561\u8d39\u7528\u62a5\u9500","created_by":5295,"created_at":"2025-02-17 11:47:10","updated_at":"2025-02-26 11:31:25","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":36564,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7268,"comment":4},"unreadComments":null,"type":{"id":185,"name":"\u62db\u5f85\u8d39"},"costType":{"id":369,"object_id":7268,"taxonomy_id":369,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":369,"name":"\u9910\u996e\u8d39","term_id":18,"description":null,"sort":5,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":185,"is_system":false,"serial_no":null},"name":"\u9910\u996e\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":25958,"reimbursement_id":7268,"user_id":5252,"status":1,"verify_at":"2025-02-18 14:49:17","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25959,"reimbursement_id":7268,"user_id":1001,"status":1,"verify_at":"2025-02-18 15:19:30","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25958,"reimbursement_id":7268,"user_id":5252,"status":1,"verify_at":"2025-02-18 14:49:17"},"attachmentRelationships":[{"id":32342,"object_type":19,"object_id":7268,"attachment_id":24159,"attachment":{"id":24159,"key":24159,"name":"a08787b2-3cd3-3a04-aab6-b1e6bd6d5fc6","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/a08787b2-3cd3-3a04-aab6-b1e6bd6d5fc6\/img_20250217_114651.jpg","orig_name":"img_20250217_114651.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":36564,"key":36564,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":66,"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9358,"reimbursement_id":7268,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7267,"status":3,"amount":"65.00","occurrence_at":"2025-01-14 11:58:00","settle_accounts_at":"2025-02-26 11:31:25","settle_accounts_by":1013,"description":"\u62dc\u8bbf\u82cf\u9ece\u4e16\u5ba2\u6237\u8f66\u8d39\u62a5\u9500","created_by":5295,"created_at":"2025-02-17 11:40:53","updated_at":"2025-02-26 11:31:25","refuse_description":null,"client_id":90,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":36564,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":7267,"comment":5},"unreadComments":null,"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":349,"object_id":7267,"taxonomy_id":349,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":349,"name":"\u7684\u58eb\u8d39","term_id":18,"description":null,"sort":3,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":184,"is_system":false,"serial_no":null},"name":"\u7684\u58eb\u8d39"},"settleAccountsBy":{"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"}},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":26052,"reimbursement_id":7267,"user_id":5252,"status":1,"verify_at":"2025-02-20 11:30:58","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","user_status":"1","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":26053,"reimbursement_id":7267,"user_id":1001,"status":1,"verify_at":"2025-02-20 14:28:02","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26052,"reimbursement_id":7267,"user_id":5252,"status":1,"verify_at":"2025-02-20 11:30:58"},"attachmentRelationships":[{"id":32391,"object_type":19,"object_id":7267,"attachment_id":24144,"attachment":{"id":24144,"key":24144,"name":"8a3924fe-e445-3d51-b9b7-f12118cd62ed","extension":"jpg","path":"\/v2\/attachment\/view\/qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA\/8a3924fe-e445-3d51-b9b7-f12118cd62ed\/IMG_20250217_113846.jpg","orig_name":"IMG_20250217_113846.jpg"}}],"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null,"workLog":{"id":36564,"key":36564,"client_id":90,"project_id":null,"scenario_id":1,"scenario_option_id":66,"scenarioOption":{"id":66,"key":66,"name":"\u5ba2\u60c5\u589e\u8fdb"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"project":null},"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9404,"reimbursement_id":7267,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","user_status":"1","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"files":[],"erpCashCostTicket":null,"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"}],"pagenation":{"totalcount":75,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:18:32') RETURNING "id"