Database Queries

总计41条数据
TimeDurationTypeQuery
  
17:46:33.8813.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

17:46:33.8852.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

17:46:33.8931.2 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

17:46:33.8958.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 WHERE ("r"."created_by"=1001) AND ("r"."status"=0) GROUP BY "r"."id") "sub"

17:46:33.9033.0 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE ("next_verify_user"=1001) AND ("status" != 0)

17:46:33.90730.3 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 remind_user_id = '1001' AND is_read = false) AND ("rccr"."user_id"=1001) AND ("r"."status" != 0) GROUP BY "object_id"

17:46:33.9371.6 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"=1001) GROUP BY "r"."id")

17:46:33.9391.9 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE "id" IN (SELECT "r"."id" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE ("r"."status"=0) AND ("r"."created_by"=1001) GROUP BY "r"."id")

17:46:33.9417.3 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 WHERE ("r"."created_by"=1001) AND ("r"."status"=0) GROUP BY "r"."id" ORDER BY "r"."created_at" DESC) "c"

17:46:33.9496.7 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 WHERE ("r"."created_by"=1001) AND ("r"."status"=0) GROUP BY "r"."id" ORDER BY "r"."created_at" DESC LIMIT 20

17:46:33.9560.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

17:46:33.9570.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

17:46:33.9580.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

17:46:33.95835.0 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20) AND ("object_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)) GROUP BY "object_id"

17:46:33.99419.5 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)) GROUP BY "object_id"

17:46:34.0130.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)

17:46:34.0140.5 msSELECTSELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (184, 349, 374))

17:46:34.0150.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215))

17:46:34.0160.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (349, 374)

17:46:34.0160.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)

17:46:34.0177.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215) ORDER BY "id"

17:46:34.0240.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

17:46:34.0240.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

17:46:34.0252.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)) ORDER BY "id"

17:46:34.0300.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

17:46:34.0300.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

17:46:34.0315.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)) ORDER BY "id"

17:46:34.0365.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215))

17:46:34.0420.7 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (28243, 28245, 28247, 28249, 28251, 28256, 28262, 28263, 28264, 28265, 28266, 28268, 28269, 28270, 28271, 28272, 28273)

17:46:34.0431.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE ("user_id"=1001) AND ("reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215))

17:46:34.0442.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)

17:46:34.0470.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

17:46:34.0470.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

17:46:34.0484.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215))

17:46:34.0520.3 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (28246, 28258, 28275, 28276)

17:46:34.0523.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)

17:46:34.0560.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "reimbursement_id" IN (8239, 8238, 8236, 8235, 8234, 8233, 8232, 8231, 8230, 8229, 8228, 8227, 8226, 8225, 8223, 8220, 8219, 8218, 8217, 8215)

17:46:34.0560.5 msSELECTSELECT count(distinct reimbursement_id) as count, number FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE (number is not null) AND ("number" IN ('25117000001081283504', '25117000001088427827', '25119110025000120122', '13501247040138558184', '13501257040143416517', '13501247040138560180', '13501247040169240677', '13501257040143412230', '13501257040143410464', '25117000001088334631')) GROUP BY "number"

17:46:34.0623.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20) AND ("visit_date"='2025-09-18')

17:46:34.0661.0 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=195, "last_visit_at"='now()' WHERE "id"=56622

17:46:34.0682.5 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/reimbursement/list', '{"ReimbursementSearch":{"filter":"is_draft","form_department":"","created_by":"","form_type":"","form_costType":"","form_reimbursementVerifyRels":"","status":"","created_at_period":"","settle_accounts_at_period":"","occurrence_at_period":""},"Filter":{"name":"created_at","sort":"DESC"},"page":"1","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"list":[{"id":8239,"status":0,"amount":"73.80","occurrence_at":"2025-08-27 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:26:17","updated_at":"2025-09-18 16:26:17","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":374,"object_id":8239,"taxonomy_id":374,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":374,"name":"\u71c3\u6cb9\u8d39","term_id":18,"description":"","sort":10,"created_by":1001,"created_at":"2018-12-07 21:59:48","updated_at":"2025-08-12 17:53:52","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":184,"is_system":false,"serial_no":"660151"},"name":"\u71c3\u6cb9\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":29444,"reimbursement_id":8239,"user_id":1001,"status":0,"verify_at":"","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":{"id":29444,"reimbursement_id":8239,"user_id":1001,"status":0,"verify_at":"","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"}}},"haveReimbursementVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[{"id":10749,"reimbursement_id":8239,"user_id":1001}],"reimbursementSettleRels":[{"id":10749,"reimbursement_id":8239,"user_id":1001,"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"}}}],"files":[{"id":49668,"object_type":22,"object_id":8239,"attachment_id":28276,"attachment":{"id":28276,"key":28276,"name":"e979c6ab-32f0-3f2f-accc-6b4cb61e9d37","extension":"pdf","path":"\/vue\/attachment\/view\/e979c6ab-32f0-3f2f-accc-6b4cb61e9d37\/\u6ef4\u6ef4\u7535\u5b50\u53d1\u7968-1.pdf","orig_name":"\u6ef4\u6ef4\u7535\u5b50\u53d1\u7968-1.pdf"}}],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":61,"reimbursement_id":8239,"attachment_id":28276,"op":"invoice","number":"25117000001088334631","reimbursementCount":{"count":7,"number":"25117000001088334631"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8238,"status":0,"amount":"73.80","occurrence_at":"2025-08-27 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:25:48","updated_at":"2025-09-18 16:25:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":374,"object_id":8238,"taxonomy_id":374,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":374,"name":"\u71c3\u6cb9\u8d39","term_id":18,"description":"","sort":10,"created_by":1001,"created_at":"2018-12-07 21:59:48","updated_at":"2025-08-12 17:53:52","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":184,"is_system":false,"serial_no":"660151"},"name":"\u71c3\u6cb9\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":29443,"reimbursement_id":8238,"user_id":1001,"status":0,"verify_at":"","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":{"id":29443,"reimbursement_id":8238,"user_id":1001,"status":0,"verify_at":"","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"}}},"haveReimbursementVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[{"id":10748,"reimbursement_id":8238,"user_id":1001}],"reimbursementSettleRels":[{"id":10748,"reimbursement_id":8238,"user_id":1001,"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"}}}],"files":[{"id":49667,"object_type":22,"object_id":8238,"attachment_id":28275,"attachment":{"id":28275,"key":28275,"name":"c8c8e742-876d-3c3d-9344-448adfaec7ab","extension":"pdf","path":"\/vue\/attachment\/view\/c8c8e742-876d-3c3d-9344-448adfaec7ab\/\u6ef4\u6ef4\u7535\u5b50\u53d1\u7968-1.pdf","orig_name":"\u6ef4\u6ef4\u7535\u5b50\u53d1\u7968-1.pdf"}}],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":60,"reimbursement_id":8238,"attachment_id":28275,"op":"invoice","number":"25117000001088334631","reimbursementCount":{"count":7,"number":"25117000001088334631"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8236,"status":0,"amount":"33.00","occurrence_at":"2025-03-23 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:21:48","updated_at":"2025-09-18 16:21:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49666,"object_type":19,"object_id":8236,"attachment_id":28273,"attachment":{"id":28273,"key":28273,"name":"3a2f038c-f532-33de-88c5-4ea95a917564","extension":"jpg","path":"\/vue\/attachment\/view\/3a2f038c-f532-33de-88c5-4ea95a917564\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":59,"reimbursement_id":8236,"attachment_id":28273,"op":"toll_invoice","number":"13501257040143412230","reimbursementCount":{"count":2,"number":"13501257040143412230"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8235,"status":0,"amount":"122.00","occurrence_at":"2025-03-24 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:21:48","updated_at":"2025-09-18 16:21:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49665,"object_type":19,"object_id":8235,"attachment_id":28272,"attachment":{"id":28272,"key":28272,"name":"89167274-10f2-3eed-8b98-59ea400335d8","extension":"jpg","path":"\/vue\/attachment\/view\/89167274-10f2-3eed-8b98-59ea400335d8\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":58,"reimbursement_id":8235,"attachment_id":28272,"op":"toll_invoice","number":"13501257040143410464","reimbursementCount":{"count":1,"number":"13501257040143410464"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":false,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8234,"status":0,"amount":"33.00","occurrence_at":"2025-03-19 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:21:48","updated_at":"2025-09-18 16:21:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49664,"object_type":19,"object_id":8234,"attachment_id":28271,"attachment":{"id":28271,"key":28271,"name":"20d3d668-8162-31c8-9d8a-46da1321d3eb","extension":"jpg","path":"\/vue\/attachment\/view\/20d3d668-8162-31c8-9d8a-46da1321d3eb\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":57,"reimbursement_id":8234,"attachment_id":28271,"op":"toll_invoice","number":"13501247040169240677","reimbursementCount":{"count":2,"number":"13501247040169240677"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8233,"status":0,"amount":"33.00","occurrence_at":"2025-03-21 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:21:48","updated_at":"2025-09-18 16:21:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49663,"object_type":19,"object_id":8233,"attachment_id":28270,"attachment":{"id":28270,"key":28270,"name":"f3c6cce9-eec8-32f4-9409-5ea15a5844bd","extension":"jpg","path":"\/vue\/attachment\/view\/f3c6cce9-eec8-32f4-9409-5ea15a5844bd\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":56,"reimbursement_id":8233,"attachment_id":28270,"op":"toll_invoice","number":"13501247040138560180","reimbursementCount":{"count":2,"number":"13501247040138560180"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8232,"status":0,"amount":"33.00","occurrence_at":"2025-03-23 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:21:48","updated_at":"2025-09-18 16:21:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49662,"object_type":19,"object_id":8232,"attachment_id":28269,"attachment":{"id":28269,"key":28269,"name":"8cbb93c0-4e12-35a4-9799-75cd80622f13","extension":"jpg","path":"\/vue\/attachment\/view\/8cbb93c0-4e12-35a4-9799-75cd80622f13\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":55,"reimbursement_id":8232,"attachment_id":28269,"op":"toll_invoice","number":"13501257040143416517","reimbursementCount":{"count":2,"number":"13501257040143416517"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8231,"status":0,"amount":"33.00","occurrence_at":"2025-03-20 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:21:48","updated_at":"2025-09-18 16:21:48","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49661,"object_type":19,"object_id":8231,"attachment_id":28268,"attachment":{"id":28268,"key":28268,"name":"aaa54e40-2df1-3813-ad74-4ad21d30f6b7","extension":"jpg","path":"\/vue\/attachment\/view\/aaa54e40-2df1-3813-ad74-4ad21d30f6b7\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":54,"reimbursement_id":8231,"attachment_id":28268,"op":"toll_invoice","number":"13501247040138558184","reimbursementCount":{"count":2,"number":"13501247040138558184"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8230,"status":0,"amount":"33.00","occurrence_at":"2025-03-23 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:17:29","updated_at":"2025-09-18 16:17:29","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49660,"object_type":19,"object_id":8230,"attachment_id":28266,"attachment":{"id":28266,"key":28266,"name":"3e99bb8a-08e9-3329-a6c5-5491f3b1d52f","extension":"jpg","path":"\/vue\/attachment\/view\/3e99bb8a-08e9-3329-a6c5-5491f3b1d52f\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":53,"reimbursement_id":8230,"attachment_id":28266,"op":"toll_invoice","number":"13501257040143412230","reimbursementCount":{"count":2,"number":"13501257040143412230"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8229,"status":0,"amount":"33.00","occurrence_at":"2025-03-19 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:17:29","updated_at":"2025-09-18 16:17:29","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49659,"object_type":19,"object_id":8229,"attachment_id":28265,"attachment":{"id":28265,"key":28265,"name":"375a4c78-f82f-33b9-a14c-235a1d53e894","extension":"jpg","path":"\/vue\/attachment\/view\/375a4c78-f82f-33b9-a14c-235a1d53e894\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":52,"reimbursement_id":8229,"attachment_id":28265,"op":"toll_invoice","number":"13501247040169240677","reimbursementCount":{"count":2,"number":"13501247040169240677"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8228,"status":0,"amount":"33.00","occurrence_at":"2025-03-21 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:17:29","updated_at":"2025-09-18 16:17:29","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49658,"object_type":19,"object_id":8228,"attachment_id":28264,"attachment":{"id":28264,"key":28264,"name":"aa8cf607-df36-3f99-ae6f-753780860bd2","extension":"jpg","path":"\/vue\/attachment\/view\/aa8cf607-df36-3f99-ae6f-753780860bd2\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":51,"reimbursement_id":8228,"attachment_id":28264,"op":"toll_invoice","number":"13501247040138560180","reimbursementCount":{"count":2,"number":"13501247040138560180"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8227,"status":0,"amount":"33.00","occurrence_at":"2025-03-23 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:17:29","updated_at":"2025-09-18 16:17:29","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49657,"object_type":19,"object_id":8227,"attachment_id":28263,"attachment":{"id":28263,"key":28263,"name":"e2a123a7-dbd0-3e59-9447-79388d6d78b3","extension":"jpg","path":"\/vue\/attachment\/view\/e2a123a7-dbd0-3e59-9447-79388d6d78b3\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":50,"reimbursement_id":8227,"attachment_id":28263,"op":"toll_invoice","number":"13501257040143416517","reimbursementCount":{"count":2,"number":"13501257040143416517"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8226,"status":0,"amount":"33.00","occurrence_at":"2025-03-20 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:17:29","updated_at":"2025-09-18 16:17:29","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49656,"object_type":19,"object_id":8226,"attachment_id":28262,"attachment":{"id":28262,"key":28262,"name":"3e15ef9f-b1f1-3db3-857e-3bba70e82d5d","extension":"jpg","path":"\/vue\/attachment\/view\/3e15ef9f-b1f1-3db3-857e-3bba70e82d5d\/20151758183294_.pic.jpg","orig_name":"20151758183294_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":49,"reimbursement_id":8226,"attachment_id":28262,"op":"toll_invoice","number":"13501247040138558184","reimbursementCount":{"count":2,"number":"13501247040138558184"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8225,"status":0,"amount":"6.00","occurrence_at":"2025-09-18 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:09:46","updated_at":"2025-09-18 16:09:46","refuse_description":"","client_id":"","project_id":"","next_verify_user":1001,"is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":349,"object_id":8225,"taxonomy_id":349,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":349,"name":"\u51fa\u79df\u8f66\u8d39","term_id":18,"description":"\u53d1\u751f\u5728\u5de5\u4f5c\u5730\u7684\u51fa\u79df\u8f66\u8d39\u3002","sort":3,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"2025-08-12 17:36:34","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":184,"is_system":false,"serial_no":"660129"},"name":"\u51fa\u79df\u8f66\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":29441,"reimbursement_id":8225,"user_id":1001,"status":0,"verify_at":"","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":{"id":29441,"reimbursement_id":8225,"user_id":1001,"status":0,"verify_at":"","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"}}},"haveReimbursementVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[{"id":49655,"object_type":22,"object_id":8225,"attachment_id":28258,"attachment":{"id":28258,"key":28258,"name":"bae2fb3a-8407-38d0-a9cc-ac545e376d9a","extension":"jpg","path":"\/vue\/attachment\/view\/bae2fb3a-8407-38d0-a9cc-ac545e376d9a\/112821758182826_.pic.jpg","orig_name":"112821758182826_.pic.jpg"}}],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":48,"reimbursement_id":8225,"attachment_id":28258,"op":"","number":"25119110025000120122","reimbursementCount":{"count":8,"number":"25119110025000120122"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8223,"status":0,"amount":"5.00","occurrence_at":"2025-09-18 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:08:01","updated_at":"2025-09-18 16:08:01","refuse_description":"","client_id":"","project_id":"","next_verify_user":1001,"is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":349,"object_id":8223,"taxonomy_id":349,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":349,"name":"\u51fa\u79df\u8f66\u8d39","term_id":18,"description":"\u53d1\u751f\u5728\u5de5\u4f5c\u5730\u7684\u51fa\u79df\u8f66\u8d39\u3002","sort":3,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"2025-08-12 17:36:34","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":184,"is_system":false,"serial_no":"660129"},"name":"\u51fa\u79df\u8f66\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":29439,"reimbursement_id":8223,"user_id":1001,"status":0,"verify_at":"","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":{"id":29439,"reimbursement_id":8223,"user_id":1001,"status":0,"verify_at":"","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"}}},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49653,"object_type":19,"object_id":8223,"attachment_id":28256,"attachment":{"id":28256,"key":28256,"name":"b313ce05-2e9c-31c1-b3ed-695375d49a31","extension":"jpg","path":"\/vue\/attachment\/view\/b313ce05-2e9c-31c1-b3ed-695375d49a31\/112821758182826_.pic.jpg","orig_name":"112821758182826_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[{"id":10745,"reimbursement_id":8223,"user_id":1001}],"reimbursementSettleRels":[{"id":10745,"reimbursement_id":8223,"user_id":1001,"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"}}}],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":46,"reimbursement_id":8223,"attachment_id":28256,"op":"","number":"25119110025000120122","reimbursementCount":{"count":8,"number":"25119110025000120122"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8220,"status":0,"amount":"12.50","occurrence_at":"2025-03-15 10:34:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:05:19","updated_at":"2025-09-18 16:05:19","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49648,"object_type":19,"object_id":8220,"attachment_id":28251,"attachment":{"id":28251,"key":28251,"name":"f3e46798-47b9-366f-976f-1ffab7f98f4e","extension":"jpg","path":"\/vue\/attachment\/view\/f3e46798-47b9-366f-976f-1ffab7f98f4e\/112681758091545_.pic.jpg","orig_name":"112681758091545_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":41,"reimbursement_id":8220,"attachment_id":28251,"op":"train_ticket","number":"25119110025000120122","reimbursementCount":{"count":8,"number":"25119110025000120122"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8219,"status":0,"amount":"12.50","occurrence_at":"2025-03-15 10:34:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 16:01:13","updated_at":"2025-09-18 16:01:13","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49647,"object_type":19,"object_id":8219,"attachment_id":28249,"attachment":{"id":28249,"key":28249,"name":"1fa22dc9-3f54-3e35-8c6d-17490404bc65","extension":"jpg","path":"\/vue\/attachment\/view\/1fa22dc9-3f54-3e35-8c6d-17490404bc65\/112681758091545_.pic.jpg","orig_name":"112681758091545_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":40,"reimbursement_id":8219,"attachment_id":28249,"op":"train_ticket","number":"25119110025000120122","reimbursementCount":{"count":8,"number":"25119110025000120122"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8218,"status":0,"amount":"33.00","occurrence_at":"2025-09-18 15:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 15:59:33","updated_at":"2025-09-18 15:59:33","refuse_description":"","client_id":"","project_id":"","next_verify_user":1001,"is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{"id":184,"name":"\u4ea4\u901a\u8d39"},"costType":{"id":349,"object_id":8218,"taxonomy_id":349,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":349,"name":"\u51fa\u79df\u8f66\u8d39","term_id":18,"description":"\u53d1\u751f\u5728\u5de5\u4f5c\u5730\u7684\u51fa\u79df\u8f66\u8d39\u3002","sort":3,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"2025-08-12 17:36:34","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":184,"is_system":false,"serial_no":"660129"},"name":"\u51fa\u79df\u8f66\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":29436,"reimbursement_id":8218,"user_id":1001,"status":0,"verify_at":"","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":{"id":29436,"reimbursement_id":8218,"user_id":1001,"status":0,"verify_at":"","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"}}},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49645,"object_type":19,"object_id":8218,"attachment_id":28247,"attachment":{"id":28247,"key":28247,"name":"90723dcd-428c-3c08-a3e5-3928ba6f8776","extension":"jpg","path":"\/vue\/attachment\/view\/90723dcd-428c-3c08-a3e5-3928ba6f8776\/112681758091545_.pic.jpg","orig_name":"112681758091545_.pic.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[{"id":10742,"reimbursement_id":8218,"user_id":1001}],"reimbursementSettleRels":[{"id":10742,"reimbursement_id":8218,"user_id":1001,"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"}}}],"files":[{"id":49646,"object_type":22,"object_id":8218,"attachment_id":28246,"attachment":{"id":28246,"key":28246,"name":"eeb1ae55-2f5a-300f-8369-e93d3aeeb49f","extension":"pdf","path":"\/vue\/attachment\/view\/eeb1ae55-2f5a-300f-8369-e93d3aeeb49f\/25112000000181039170.pdf","orig_name":"25112000000181039170.pdf"}}],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":false,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8217,"status":0,"amount":"411.40","occurrence_at":"2025-08-27 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 15:56:08","updated_at":"2025-09-18 15:56:08","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49644,"object_type":19,"object_id":8217,"attachment_id":28245,"attachment":{"id":28245,"key":28245,"name":"9320432b-1ac0-3e97-aaf7-e8b726a5d133","extension":"pdf","path":"\/vue\/attachment\/view\/9320432b-1ac0-3e97-aaf7-e8b726a5d133\/invoice-10.pdf","orig_name":"invoice-10.pdf"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":39,"reimbursement_id":8217,"attachment_id":28245,"op":"invoice","number":"25117000001088427827","reimbursementCount":{"count":2,"number":"25117000001088427827"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"},{"id":8215,"status":0,"amount":"3.50","occurrence_at":"2025-08-27 00:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"","created_by":1001,"created_at":"2025-09-18 15:56:08","updated_at":"2025-09-18 15:56:08","refuse_description":"","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","settlesort":0,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"unreadComments":{},"type":{},"costType":{},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[],"lastReimbursementVerifyRel":{},"haveReimbursementVerifyRel":{},"attachmentRelationships":[{"id":49642,"object_type":19,"object_id":8215,"attachment_id":28243,"attachment":{"id":28243,"key":28243,"name":"e4f6e3e0-b2ec-31d9-b38b-7d2093272076","extension":"pdf","path":"\/vue\/attachment\/view\/e4f6e3e0-b2ec-31d9-b38b-7d2093272076\/invoice-8.pdf","orig_name":"invoice-8.pdf"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[],"files":[],"erpCashCostTicket":{},"reimbursementInvoiceNumbers":[{"id":37,"reimbursement_id":8215,"attachment_id":28243,"op":"invoice","number":"25117000001081283504","reimbursementCount":{"count":3,"number":"25117000001081283504"}}],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":true,"bgcolor":"#000000","status_display":"\u8349\u7a3f"}],"countArr":[{"key":"all","name":"\u5168\u90e8","value":"9086.78","count":53},{"key":1,"name":"\u5ba1\u6279\u4e2d","value":"0","count":0},{"key":2,"name":"\u672a\u7ed3\u7b97","value":"0","count":0},{"key":3,"name":"\u7ed3\u7b97\u5b8c\u6210","value":"0","count":0},{"key":4,"name":"\u5df2\u62d2\u7edd","value":"0","count":0}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":1},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0},{"key":"settle","name":"\u6211\u7ed3\u7b97\u7684","value":6},{"key":"is_draft","name":"\u8349\u7a3f","value":53}],"can_create":true,"pagenation":{"totalcount":53,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-18 17:46:34') RETURNING "id"