ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68736d1fd60b6: POST https://beta.jinchangxiao.com/v2/reimbursement/list at 2025-07-13 04:23:59 pm by 120.244.156.33

Database Queries

总计40条数据
TimeDurationTypeQuery
  
16:23:59.8802.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'

[+] Explain
16:23:59.8831.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:23:59.8870.7 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
16:23:59.88912.1 msSELECTSELECT count(*) as count, sum(amount) as sum, 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=3 then 1 else 0 end) countStatus3, sum(case when "sub".status=4 then 1 else 0 end) countStatus4, sum(case when "sub".status=1 then amount else 0 end) countAmount1, sum(case when "sub".status=2 then amount else 0 end) countAmount2, sum(case when "sub".status=3 then amount else 0 end) countAmount3, sum(case when "sub".status=4 then amount else 0 end) countAmount4 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"=1000)) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("rccr"."user_id"=1000) OR ("rsr"."user_id"=1000) OR ("rvr"."user_id"=1000)) AND ("u"."department_id"='3') GROUP BY "r"."id") "sub"

[+] Explain
16:23:59.9011.0 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE ("next_verify_user"=1000) AND ("status" != 0)

[+] Explain
16:23:59.90216.2 msSELECTSELECT count(object_id) as count FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_reimbursements" "r" ON uc.object_id = r.id LEFT JOIN "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" "rccr" ON rccr.reimbursement_id = r.id WHERE (object_id = r.id) AND ("object_type"=20) AND ("r"."status" != 0) AND ("remind_user_id"=1000) AND ("is_read"=FALSE) AND ("rccr"."user_id"=1000) GROUP BY "object_id"

[+] Explain
16:23:59.9190.9 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE "id" IN (SELECT "r"."id" FROM "a57be577deb434"."tbl_reimbursements" "r" LEFT JOIN "a57be577deb434"."tbl_reimbursement_settle_rels" "rsr" ON r.id = rsr.reimbursement_id WHERE ("r"."status"=2) AND ("rsr"."user_id"=1000) GROUP BY "r"."id")

[+] Explain
16:23:59.9209.4 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"=1000)) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("rccr"."user_id"=1000) OR ("rsr"."user_id"=1000) OR ("rvr"."user_id"=1000)) AND ("r"."status"='3') AND ("u"."department_id"='3') GROUP BY "r"."id" ORDER BY "r"."created_at" DESC) "c"

[+] Explain
16:23:59.92910.0 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"=1000)) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("rccr"."user_id"=1000) OR ("rsr"."user_id"=1000) OR ("rvr"."user_id"=1000)) AND ("r"."status"='3') AND ("u"."department_id"='3') GROUP BY "r"."id" ORDER BY "r"."created_at" DESC LIMIT 10

[+] Explain
16:23:59.9400.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 1011)

[+] Explain
16:23:59.9400.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360))

[+] Explain
16:23:59.9410.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3

[+] Explain
16:23:59.94119.5 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20) AND ("object_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)) GROUP BY "object_id"

[+] Explain
16:23:59.96115.1 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)) GROUP BY "object_id"

[+] Explain
16:23:59.9760.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)

[+] Explain
16:23:59.9770.4 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (307, 352, 379, 366, 356))

[+] Explain
16:23:59.9770.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241))

[+] Explain
16:23:59.9780.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (379, 366, 352, 356)

[+] Explain
16:23:59.9780.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

[+] Explain
16:23:59.9790.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)

[+] Explain
16:23:59.9790.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)

[+] Explain
16:23:59.9791.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241) ORDER BY "id"

[+] Explain
16:23:59.9810.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5252, 1001, 5295, 1011)

[+] Explain
16:23:59.9810.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5252, 1011, 5295, 5300))

[+] Explain
16:23:59.9821.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)) ORDER BY "id"

[+] Explain
16:23:59.9831.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)) ORDER BY "id"

[+] Explain
16:23:59.9851.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241))

[+] Explain
16:23:59.9870.4 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23982, 24464, 24465)

[+] Explain
16:23:59.9870.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (518, 2545, 12)

[+] Explain
16:23:59.9880.4 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "created_by" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3772, 3760, 3766)

[+] Explain
16:23:59.9880.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5300, 5295)

[+] Explain
16:23:59.9890.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5300))

[+] Explain
16:23:59.9890.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)

[+] Explain
16:23:59.9890.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE ("user_id"=1000) AND ("reimbursement_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241))

[+] Explain
16:23:59.9900.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241)

[+] Explain
16:23:59.9910.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

[+] Explain
16:23:59.9910.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)

[+] Explain
16:23:59.9911.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id" IN (7352, 7346, 7313, 7249, 7248, 7247, 7246, 7232, 7231, 7241))

[+] Explain
16:23:59.9930.2 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23884, 23886, 23885, 24030, 24031, 24034, 24036, 24037, 24038, 24039, 24040, 24164, 24165, 24434)

[+] Explain
16:23:59.9942.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/reimbursement/list', '{"ReimbursementSearch":{"created_by":"","filter":"","form_costType":"","form_department":"3","form_type":"","period":"","status":"3"},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752395008","token":"189c49742964c01baf9885de5e416a47","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":7352,"status":3,"amount":"37.10","occurrence_at":"2025-03-10 11:00:00","settle_accounts_at":"2025-03-14 11:42:43","settle_accounts_by":1013,"description":"\u56fd\u79d1\u73af\u5b87\u9879\u76ee\uff0c\u95ea\u9001\u663e\u5361","created_by":5360,"created_at":"2025-03-10 11:47:03","updated_at":"2025-03-14 11:42:43","refuse_description":null,"client_id":518,"project_id":3772,"next_verify_user":null,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":7352,"comment":7},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":379,"object_id":7352,"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":26233,"reimbursement_id":7352,"user_id":5295,"status":1,"verify_at":"2025-03-10 13:32:29","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":26234,"reimbursement_id":7352,"user_id":1011,"status":1,"verify_at":"2025-03-10 14:37:45","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":26235,"reimbursement_id":7352,"user_id":5252,"status":1,"verify_at":"2025-03-12 17:25:18","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":26236,"reimbursement_id":7352,"user_id":1001,"status":1,"verify_at":"2025-03-14 10:21:19","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26233,"reimbursement_id":7352,"user_id":5295,"status":1,"verify_at":"2025-03-10 13:32:29"},"attachmentRelationships":[{"id":32772,"object_type":19,"object_id":7352,"attachment_id":24464,"attachment":{"id":24464,"key":24464,"name":"da36a090-e73d-335b-8e85-86bfb9c864c4","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/da36a090-e73d-335b-8e85-86bfb9c864c4\/\u53d1\u7968.png","orig_name":"\u53d1\u7968.png"}},{"id":32773,"object_type":19,"object_id":7352,"attachment_id":24465,"attachment":{"id":24465,"key":24465,"name":"12aaee0c-b269-36e3-987d-d4bb6f485049","extension":"jpg","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/12aaee0c-b269-36e3-987d-d4bb6f485049\/\u8ba2\u5355\u622a\u56fe.jpg","orig_name":"\u8ba2\u5355\u622a\u56fe.jpg"}}],"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K","created_by":5295,"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":9476,"reimbursement_id":7352,"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"}}}],"files":[],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7346,"status":3,"amount":"100.00","occurrence_at":"2025-02-28 09:00:00","settle_accounts_at":"2025-03-14 11:42:43","settle_accounts_by":1013,"description":"25\u5e741\u6708\u4efd\u30012\u6708\u4efd\u7535\u8bdd\u8865\u52a9\u8d39\u7528","created_by":5360,"created_at":"2025-03-07 10:07:20","updated_at":"2025-03-14 11:42:43","refuse_description":null,"client_id":null,"project_id":null,"next_verify_user":null,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":7346,"comment":6},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":352,"object_id":7346,"taxonomy_id":352,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":352,"name":"\u624b\u673a\u8d39","term_id":18,"description":"\u96f6\u98df\/\u996e\u6599\/\u65e5\u5e38\u7528\u54c1","sort":14,"created_by":1001,"created_at":"2018-12-10 15:05:29","updated_at":"2024-04-16 22:12:03","is_delete":false,"approve_verify_user":"\u96f6\u98df\/\u996e\u6599\/\u65e5\u5e38\u7528\u54c1","approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u624b\u673a\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":26202,"reimbursement_id":7346,"user_id":1011,"status":1,"verify_at":"2025-03-10 14:38:45","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":26203,"reimbursement_id":7346,"user_id":5252,"status":1,"verify_at":"2025-03-12 17:25:07","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":26204,"reimbursement_id":7346,"user_id":1001,"status":1,"verify_at":"2025-03-14 10:21:19","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":26202,"reimbursement_id":7346,"user_id":1011,"status":1,"verify_at":"2025-03-10 14:38:45"},"attachmentRelationships":[],"client":null,"project":null,"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9466,"reimbursement_id":7346,"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"}}}],"files":[{"id":32728,"object_type":22,"object_id":7346,"attachment_id":24434,"attachment":{"id":24434,"key":24434,"name":"020cbdb4-b04f-3a60-accc-1c70c9f013a1","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/020cbdb4-b04f-3a60-accc-1c70c9f013a1\/WX20250307-100659@2x.png","orig_name":"WX20250307-100659@2x.png"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7313,"status":3,"amount":"21.20","occurrence_at":"2025-02-10 15:10:00","settle_accounts_at":"2025-03-14 11:42:43","settle_accounts_by":1013,"description":"\u56fd\u79d1\u73af\u5b87\u9879\u76ee\uff0c\u95ea\u9001\u62a5\u4ef7\u5355","created_by":5360,"created_at":"2025-02-17 14:49:56","updated_at":"2025-03-14 11:42:43","refuse_description":null,"client_id":518,"project_id":3772,"next_verify_user":null,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null,"settlesort":0,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":7313,"comment":7},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":379,"object_id":7313,"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":25996,"reimbursement_id":7313,"user_id":5295,"status":1,"verify_at":"2025-02-17 17:27:58","user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":25997,"reimbursement_id":7313,"user_id":1011,"status":1,"verify_at":"2025-02-26 10:17:40","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":25998,"reimbursement_id":7313,"user_id":5252,"status":1,"verify_at":"2025-03-12 17:25:30","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25999,"reimbursement_id":7313,"user_id":1001,"status":1,"verify_at":"2025-03-14 10:21:19","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25996,"reimbursement_id":7313,"user_id":5295,"status":1,"verify_at":"2025-02-17 17:27:58"},"attachmentRelationships":[],"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K","created_by":5295,"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":9377,"reimbursement_id":7313,"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"}}}],"files":[{"id":32345,"object_type":22,"object_id":7313,"attachment_id":24164,"attachment":{"id":24164,"key":24164,"name":"541276b0-86b9-3586-8545-3d3f2cbf2ac7","extension":"jpg","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/541276b0-86b9-3586-8545-3d3f2cbf2ac7\/\u8ba2\u5355\u4fe1\u606f.jpg","orig_name":"\u8ba2\u5355\u4fe1\u606f.jpg"}},{"id":32346,"object_type":22,"object_id":7313,"attachment_id":24165,"attachment":{"id":24165,"key":24165,"name":"2f056d11-8f96-3cdd-a35d-bc711000f9ad","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/2f056d11-8f96-3cdd-a35d-bc711000f9ad\/\u53d1\u7968.png","orig_name":"\u53d1\u7968.png"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7249,"status":3,"amount":"60.00","occurrence_at":"2025-02-12 00:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"\u5e74\u4f1a\u7528\u7ea2\u8272\u6761\u5e45\uff084M*0.5M\uff09\u5370\u5237\u8d39","created_by":1011,"created_at":"2025-02-12 10:15:47","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":null,"project_id":null,"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":7249,"comment":4},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":356,"object_id":7249,"taxonomy_id":356,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":356,"name":"\u529e\u516c\u7528\u54c1","term_id":18,"description":"","sort":13,"created_by":1001,"created_at":"2018-12-10 15:04:19","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u529e\u516c\u7528\u54c1"},"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":25768,"reimbursement_id":7249,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:29:44","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25769,"reimbursement_id":7249,"user_id":1001,"status":1,"verify_at":"2025-02-14 05:21:41","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25768,"reimbursement_id":7249,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:29:44"},"attachmentRelationships":[],"client":null,"project":null,"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9290,"reimbursement_id":7249,"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"}}}],"files":[{"id":32211,"object_type":22,"object_id":7249,"attachment_id":24040,"attachment":{"id":24040,"key":24040,"name":"901516a0-1bbb-327a-80c7-cddac2e7c8a4","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/901516a0-1bbb-327a-80c7-cddac2e7c8a4\/dzfp_25112000000026920904_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250211171402.pdf","orig_name":"dzfp_25112000000026920904_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250211171402.pdf"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7248,"status":3,"amount":"51.46","occurrence_at":"2025-02-10 00:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"\u86c7\u5e74\u5f00\u5de5\u7ea2\u5305\u76ae","created_by":1011,"created_at":"2025-02-12 10:15:10","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":null,"project_id":null,"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":7248,"comment":4},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":356,"object_id":7248,"taxonomy_id":356,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":356,"name":"\u529e\u516c\u7528\u54c1","term_id":18,"description":"","sort":13,"created_by":1001,"created_at":"2018-12-10 15:04:19","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u529e\u516c\u7528\u54c1"},"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":25766,"reimbursement_id":7248,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:29:59","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25767,"reimbursement_id":7248,"user_id":1001,"status":1,"verify_at":"2025-02-14 05:21:41","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25766,"reimbursement_id":7248,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:29:59"},"attachmentRelationships":[],"client":null,"project":null,"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9289,"reimbursement_id":7248,"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"}}}],"files":[{"id":32209,"object_type":22,"object_id":7248,"attachment_id":24038,"attachment":{"id":24038,"key":24038,"name":"a9862075-48e8-376e-b3b0-9e4fbd8e17e8","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a9862075-48e8-376e-b3b0-9e4fbd8e17e8\/24.46-\u7ea2\u5305.pdf","orig_name":"24.46-\u7ea2\u5305.pdf"}},{"id":32210,"object_type":22,"object_id":7248,"attachment_id":24039,"attachment":{"id":24039,"key":24039,"name":"b22453d9-3e11-3008-8dc6-8e84ad74ee2f","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b22453d9-3e11-3008-8dc6-8e84ad74ee2f\/27-\u7ea2\u5305\u76ae.pdf","orig_name":"27-\u7ea2\u5305\u76ae.pdf"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7247,"status":3,"amount":"108.00","occurrence_at":"2025-01-20 00:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"2025\u5e741\u6708\u4eac\u4e1c\u5feb\u9012\u8d39\u7528\uffe5108","created_by":1011,"created_at":"2025-02-12 09:46:37","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":null,"project_id":null,"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":7247,"comment":6},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":379,"object_id":7247,"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":25764,"reimbursement_id":7247,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:07","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25765,"reimbursement_id":7247,"user_id":1001,"status":1,"verify_at":"2025-02-14 05:21:41","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25764,"reimbursement_id":7247,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:07"},"attachmentRelationships":[],"client":null,"project":null,"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9288,"reimbursement_id":7247,"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"}}}],"files":[{"id":32206,"object_type":22,"object_id":7247,"attachment_id":24034,"attachment":{"id":24034,"key":24034,"name":"1df995d0-7b34-33de-b544-186e4e496bea","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/1df995d0-7b34-33de-b544-186e4e496bea\/\u987a\u4e30-1\u6708\u4efd\u5feb\u9012\u53d1\u7968154.pdf","orig_name":"\u987a\u4e30-1\u6708\u4efd\u5feb\u9012\u53d1\u7968154.pdf"}},{"id":32207,"object_type":22,"object_id":7247,"attachment_id":24036,"attachment":{"id":24036,"key":24036,"name":"594768db-3b18-3f45-b22d-02a82d3947f6","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/594768db-3b18-3f45-b22d-02a82d3947f6\/\u4eac\u4e1c-1\u6708\u4efd\u5feb\u9012\u53d1\u7968499.2.pdf","orig_name":"\u4eac\u4e1c-1\u6708\u4efd\u5feb\u9012\u53d1\u7968499.2.pdf"}},{"id":32208,"object_type":22,"object_id":7247,"attachment_id":24037,"attachment":{"id":24037,"key":24037,"name":"856b601a-4ca6-3d30-9c25-1c1727cfe4f1","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/856b601a-4ca6-3d30-9c25-1c1727cfe4f1\/\u660e\u7ec6\u5355.pdf","orig_name":"\u660e\u7ec6\u5355.pdf"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7246,"status":3,"amount":"50.00","occurrence_at":"2025-01-31 00:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"2025\u5e741\u6708\u4efd\u7535\u8bdd\u8865\u52a9\u8d39\u7528","created_by":1011,"created_at":"2025-02-12 09:41:23","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":null,"project_id":null,"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":7246,"comment":3},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":352,"object_id":7246,"taxonomy_id":352,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":352,"name":"\u624b\u673a\u8d39","term_id":18,"description":"\u96f6\u98df\/\u996e\u6599\/\u65e5\u5e38\u7528\u54c1","sort":14,"created_by":1001,"created_at":"2018-12-10 15:05:29","updated_at":"2024-04-16 22:12:03","is_delete":false,"approve_verify_user":"\u96f6\u98df\/\u996e\u6599\/\u65e5\u5e38\u7528\u54c1","approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u624b\u673a\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":25758,"reimbursement_id":7246,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:14","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25759,"reimbursement_id":7246,"user_id":1001,"status":1,"verify_at":"2025-02-14 05:21:41","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25758,"reimbursement_id":7246,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:14"},"attachmentRelationships":[],"client":null,"project":null,"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9285,"reimbursement_id":7246,"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"}}}],"files":[{"id":32199,"object_type":22,"object_id":7246,"attachment_id":24031,"attachment":{"id":24031,"key":24031,"name":"a2ae2bde-3558-30fa-94fc-7887d590ea1b","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a2ae2bde-3558-30fa-94fc-7887d590ea1b\/50.pdf","orig_name":"50.pdf"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7232,"status":3,"amount":"37.17","occurrence_at":"2025-01-20 00:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"\u5468\u4e00\u4f8b\u4f1a\u7528\u6c34\u679c\uff1a1-20 \u9999\u85492\u5305 \uffe519.58\n\u5468\u4e00\u4f8b\u4f1a\u7528\u6c34\u679c\uff1a1-20 \u9999\u85492\u5305 \uffe517.59","created_by":1011,"created_at":"2025-02-12 09:39:35","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":null,"project_id":null,"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":7232,"comment":4},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":366,"object_id":7232,"taxonomy_id":366,"term_id":18,"value":null,"object_type":7,"extra_int":null,"in_amount":null,"out_amount":null,"taxonomy":{"id":366,"name":"\u8336\u70b9\u8d39","term_id":18,"description":null,"sort":16,"created_by":1001,"created_at":"2022-07-05 12:37:21","updated_at":"","is_delete":false,"approve_verify_user":null,"approve_carbon_copy_user":null,"parent_id":307,"is_system":false,"serial_no":null},"name":"\u8336\u70b9\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":25754,"reimbursement_id":7232,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:42","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25755,"reimbursement_id":7232,"user_id":1001,"status":1,"verify_at":"2025-02-14 05:21:40","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25754,"reimbursement_id":7232,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:42"},"attachmentRelationships":[],"client":null,"project":null,"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9283,"reimbursement_id":7232,"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"}}}],"files":[{"id":32196,"object_type":22,"object_id":7232,"attachment_id":23885,"attachment":{"id":23885,"key":23885,"name":"5cf135ed-0953-315a-8e6e-7290ba63e844","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/5cf135ed-0953-315a-8e6e-7290ba63e844\/19.58.pdf","orig_name":"19.58.pdf"}},{"id":32197,"object_type":22,"object_id":7232,"attachment_id":24030,"attachment":{"id":24030,"key":24030,"name":"13b573f3-6a26-3812-acfb-6f2f6830f637","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/13b573f3-6a26-3812-acfb-6f2f6830f637\/17.59.pdf","orig_name":"17.59.pdf"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7231,"status":3,"amount":"61.01","occurrence_at":"2025-01-21 13:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"\u987a\u4e30\u540c\u57ce\u6025\u9001\u73b0\u91d1\u7ed9\u5218\u82f1\u6960 \u5feb\u9012\u73b0\u91d1\u8d39\u7528","created_by":1011,"created_at":"2025-02-10 14:44:53","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":2545,"project_id":3760,"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":7231,"comment":3},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":379,"object_id":7231,"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":25740,"reimbursement_id":7231,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:58","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25741,"reimbursement_id":7231,"user_id":1001,"status":1,"verify_at":"2025-02-14 05:21:39","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25740,"reimbursement_id":7231,"user_id":5252,"status":1,"verify_at":"2025-02-12 14:30:58"},"attachmentRelationships":[],"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","created_by":1001,"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"}}},"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9276,"reimbursement_id":7231,"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"}}}],"files":[{"id":32132,"object_type":22,"object_id":7231,"attachment_id":23884,"attachment":{"id":23884,"key":23884,"name":"b7c1d659-417c-3eeb-867e-a6e836509475","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b7c1d659-417c-3eeb-867e-a6e836509475\/\u987a\u4e30\u540c\u57ce\u6025\u9001\u7535\u5b50\u53d1\u7968.pdf","orig_name":"\u987a\u4e30\u540c\u57ce\u6025\u9001\u7535\u5b50\u53d1\u7968.pdf"}},{"id":32133,"object_type":22,"object_id":7231,"attachment_id":23886,"attachment":{"id":23886,"key":23886,"name":"329f0cc2-e3c2-3025-95b1-291e59de858f","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/329f0cc2-e3c2-3025-95b1-291e59de858f\/\u987a\u4e30\u540c\u57ce\u8ba2\u5355\u8be6\u60c5.pdf","orig_name":"\u987a\u4e30\u540c\u57ce\u8ba2\u5355\u8be6\u60c5.pdf"}}],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"},{"id":7241,"status":3,"amount":"144.00","occurrence_at":"2025-01-20 00:00:00","settle_accounts_at":"2025-02-26 11:32:21","settle_accounts_by":1013,"description":"2025\u5e741\u6708\u4efd\u4eac\u4e1c\u5feb\u9012\u8d39\u7528\uff1a\uffe5144","created_by":1011,"created_at":"2025-02-10 14:40:19","updated_at":"2025-02-26 11:32:21","refuse_description":null,"client_id":12,"project_id":3766,"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":7241,"comment":5},"unreadComments":null,"type":{"id":307,"name":"\u65e5\u5e38\u529e\u516c"},"costType":{"id":379,"object_id":7241,"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":25735,"reimbursement_id":7241,"user_id":5300,"status":1,"verify_at":"2025-02-18 14:45:35","user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":25736,"reimbursement_id":7241,"user_id":5252,"status":1,"verify_at":"2025-02-18 14:46:51","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":25737,"reimbursement_id":7241,"user_id":1001,"status":1,"verify_at":"2025-02-18 15:19:29","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"}}}],"lastReimbursementVerifyRel":null,"haveReimbursementVerifyRel":{"id":25735,"reimbursement_id":7241,"user_id":5300,"status":1,"verify_at":"2025-02-18 14:45:35"},"attachmentRelationships":[{"id":32129,"object_type":19,"object_id":7241,"attachment_id":23982,"attachment":{"id":23982,"key":23982,"name":"0c7495e1-9c40-3009-8bad-87e65edc6d92","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/0c7495e1-9c40-3009-8bad-87e65edc6d92\/image.png","orig_name":"image.png"}}],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3766,"key":3766,"name":"POTJ25013202-\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-G-2025","created_by":5300,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}}},"workLog":null,"preSales":null,"implement":null,"needSettle":[],"reimbursementSettleRels":[{"id":9274,"reimbursement_id":7241,"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"}}}],"files":[],"unread":0,"can_update":false,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"bgcolor":"#80C269","status_display":"\u7ed3\u7b97\u5b8c\u6210"}],"countArr":[{"key":"all","name":"\u5168\u90e8","value":"235955.50","count":643},{"key":1,"name":"\u5ba1\u6279\u4e2d","value":"11223.45","count":13},{"key":2,"name":"\u672a\u7ed3\u7b97","value":"0","count":0},{"key":3,"name":"\u7ed3\u7b97\u5b8c\u6210","value":"223932.05","count":625},{"key":4,"name":"\u5df2\u62d2\u7edd","value":"800.00","count":5}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":8},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0},{"key":"settle","name":"\u6211\u7ed3\u7b97\u7684","value":6}],"pagenation":{"totalcount":625,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-13 16:23:59') RETURNING "id"

[+] Explain