68c90cbd7dc81: POST https://beta.jinchangxiao.com/vue/reimbursement/list at 2025-09-16 03:07:41 pm by 114.244.128.96
Database Queries
总计36条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:07:41.518 | 2.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1011 |
| 15:07:41.521 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 15:07:41.526 | 1.5 ms | SELECT | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_reimbursements" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1011) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 15:07:41.528 | 6.7 ms | SELECT | SELECT 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) AND (("r"."created_by" IN (5360, 5311, 1011, 1011)) OR ("rccr"."user_id"=1011) OR ("rsr"."user_id"=1011) OR ("rvr"."user_id"=1011)) AND ("r"."status"='4') AND (("r"."created_by"='1011')) GROUP BY "r"."id") "sub" |
| 15:07:41.535 | 1.0 ms | SELECT | SELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE ("next_verify_user"=1011) AND ("status" != 0) |
| 15:07:41.537 | 18.3 ms | SELECT | SELECT 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 = '1011' AND is_read = false) AND ("rccr"."user_id"=1011) AND ("r"."status" != 0) GROUP BY "object_id" |
| 15:07:41.555 | 0.9 ms | SELECT | SELECT 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"=1011) GROUP BY "r"."id") |
| 15:07:41.556 | 1.0 ms | SELECT | SELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE "id" IN (SELECT "r"."id" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE ("r"."status"=0) AND ("r"."created_by"=1011) GROUP BY "r"."id") |
| 15:07:41.557 | 4.6 ms | SELECT | SELECT 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) AND (("r"."created_by" IN (5360, 5311, 1011, 1011)) OR ("rccr"."user_id"=1011) OR ("rsr"."user_id"=1011) OR ("rvr"."user_id"=1011)) AND ("r"."status"='4') AND (("r"."created_by"='1011')) GROUP BY "r"."id" ORDER BY "r"."created_at" DESC) "c" |
| 15:07:41.562 | 4.7 ms | SELECT | 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) AND (("r"."created_by" IN (5360, 5311, 1011, 1011)) OR ("rccr"."user_id"=1011) OR ("rsr"."user_id"=1011) OR ("rvr"."user_id"=1011)) AND ("r"."status"='4') AND (("r"."created_by"='1011')) GROUP BY "r"."id" ORDER BY "r"."created_at" DESC LIMIT 20 |
| 15:07:41.567 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 15:07:41.568 | 0.4 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011) |
| 15:07:41.569 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3 |
| 15:07:41.569 | 22.3 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20) AND ("object_id" IN (400, 395, 212, 118)) GROUP BY "object_id" |
| 15:07:41.592 | 17.1 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20) AND (remind_user_id = 1011 AND is_read = false) AND ("object_id" IN (400, 395, 212, 118)) GROUP BY "object_id" |
| 15:07:41.609 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (400, 395, 212, 118) |
| 15:07:41.610 | 0.4 ms | SELECT | SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (97, 101, 205, 206, 165, 179, 142, 153, 140, 197, 115, 194, 5, 7, 94, 114, 1, 330, 105, 316, 313, 317, 107, 326, 349, 340, 359, 374)) |
| 15:07:41.610 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id" IN (400, 395, 212, 118)) |
| 15:07:41.611 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id" IN (326, 330) |
| 15:07:41.611 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id" IN (400, 395, 212, 118) |
| 15:07:41.611 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id" IN (400, 395, 212, 118) ORDER BY "id" |
| 15:07:41.613 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1001) |
| 15:07:41.613 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1014)) |
| 15:07:41.614 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id" IN (400, 395, 212, 118)) ORDER BY "id" |
| 15:07:41.615 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id" IN (400, 395, 212, 118)) ORDER BY "id" |
| 15:07:41.617 | 2.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id" IN (400, 395, 212, 118)) |
| 15:07:41.619 | 1.6 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (2239, 2445, 2810, 2823) |
| 15:07:41.621 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE ("user_id"=1011) AND ("reimbursement_id" IN (400, 395, 212, 118)) |
| 15:07:41.622 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id" IN (400, 395, 212, 118) |
| 15:07:41.622 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1014 |
| 15:07:41.623 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1014) |
| 15:07:41.623 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id" IN (400, 395, 212, 118)) |
| 15:07:41.625 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id" IN (400, 395, 212, 118) |
| 15:07:41.628 | 3.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=20) AND ("visit_date"='2025-09-16') |
| 15:07:41.632 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=3, "last_visit_at"='now()' WHERE "id"=56586 |
| 15:07:41.633 | 1.5 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/reimbursement/list', '{"ReimbursementSearch":{"created_by":["1011"],"filter":"all","form_department":"","form_type":"","form_costType":"","form_reimbursementVerifyRels":"","status":"4","created_at_period":"","settle_accounts_at_period":"","occurrence_at_period":""},"Filter":{"name":"created_at","sort":"DESC"},"page":"1","web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":{"list":[{"id":400,"status":4,"amount":"200","occurrence_at":"2019-04-30 12:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"\u91d1\u7545\u900dbug\u4e00\u4e2a\uff0c\u82f9\u679c\u7cfb\u7edf\u767b\u5f55\u9875\u9762\u5bc6\u7801\u4fdd\u5b58\u95ee\u9898\u3002","created_by":1011,"created_at":"2019-05-05 12:03:04","updated_at":"2019-05-05 12:27:07","refuse_description":"\u8fd9\u4e2abug\u4e0d\u662f\u5168\u7b97\u8fc7\u4e86\u561b\uff1f","client_id":"","project_id":"","next_verify_user":"","is_resubmited":false,"work_log_id":"","pre_sales_id":"","implement_record_id":"","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":400,"comment":4},"unreadComments":{},"type":{"id":205,"name":"\u5176\u4ed6"},"costType":{"id":330,"object_id":400,"taxonomy_id":330,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":330,"name":"\u91d1\u7545\u900dBUG","term_id":18,"description":"","sort":15,"created_by":1001,"created_at":"2019-03-16 11:17:55","updated_at":"","is_delete":true,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":205,"is_system":false,"serial_no":""},"name":"\u91d1\u7545\u900dBUG"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":1292,"reimbursement_id":400,"user_id":1001,"status":2,"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":{},"haveReimbursementVerifyRel":{"id":1292,"reimbursement_id":400,"user_id":1001,"status":2,"verify_at":""},"attachmentRelationships":[{"id":868,"object_type":19,"object_id":400,"attachment_id":2823,"attachment":{"id":2823,"key":2823,"name":"3ae20b20-092d-3e8d-a79a-eed81b67369a","extension":"jpeg","path":"\/vue\/attachment\/view\/3ae20b20-092d-3e8d-a79a-eed81b67369a\/20190505120303.jpeg","orig_name":"20190505120303.jpeg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[{"id":370,"reimbursement_id":400,"user_id":1014,"user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}}],"files":[],"erpCashCostTicket":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":true,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":false,"bgcolor":"#CE4A50","status_display":"\u5df2\u62d2\u7edd"},{"id":395,"status":4,"amount":"400","occurrence_at":"2019-04-28 10:30:00","settle_accounts_at":"","settle_accounts_by":"","description":"\u91d1\u7545\u900dbug 2\u4e2a;","created_by":1011,"created_at":"2019-04-28 13:33:02","updated_at":"2019-04-30 15:33:29","refuse_description":"1.bug\u4e0d\u7528\u6731\u6731\u5ba1\u6838\u30022.\u8fd9\u662f\u4e00\u4e2abug\u5bfc\u81f4\u3002","client_id":"","project_id":"","next_verify_user":"","is_resubmited":true,"work_log_id":"","pre_sales_id":"","implement_record_id":"","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":395,"comment":5},"unreadComments":{},"type":{"id":205,"name":"\u5176\u4ed6"},"costType":{"id":330,"object_id":395,"taxonomy_id":330,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":330,"name":"\u91d1\u7545\u900dBUG","term_id":18,"description":"","sort":15,"created_by":1001,"created_at":"2019-03-16 11:17:55","updated_at":"","is_delete":true,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":205,"is_system":false,"serial_no":""},"name":"\u91d1\u7545\u900dBUG"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":1284,"reimbursement_id":395,"user_id":1014,"status":1,"verify_at":"","user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}},{"id":1285,"reimbursement_id":395,"user_id":1001,"status":2,"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":{},"haveReimbursementVerifyRel":{"id":1284,"reimbursement_id":395,"user_id":1014,"status":1,"verify_at":""},"attachmentRelationships":[{"id":863,"object_type":19,"object_id":395,"attachment_id":2810,"attachment":{"id":2810,"key":2810,"name":"8ea97868-f936-32dd-bcd4-e0060c3c17fb","extension":"jpeg","path":"\/vue\/attachment\/view\/8ea97868-f936-32dd-bcd4-e0060c3c17fb\/20190428133256.jpeg","orig_name":"20190428133256.jpeg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[{"id":305,"reimbursement_id":395,"user_id":1014,"user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}}],"files":[],"erpCashCostTicket":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":false,"bgcolor":"#CE4A50","status_display":"\u5df2\u62d2\u7edd"},{"id":212,"status":4,"amount":"50","occurrence_at":"2019-03-18 09:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"2019\u5e742\u6708\u4efd\u7535\u8bdd\u8d39\u7528","created_by":1011,"created_at":"2019-02-18 10:57:30","updated_at":"2019-02-19 20:36:12","refuse_description":"\u6b21\u6708\u63d0\u4ea4","client_id":"","project_id":"","next_verify_user":"","is_resubmited":true,"work_log_id":"","pre_sales_id":"","implement_record_id":"","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":212,"comment":5},"unreadComments":{},"type":{"id":197,"name":"\u5e7f\u544a\u8d39"},"costType":{"id":326,"object_id":212,"taxonomy_id":326,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":326,"name":"\u5e7f\u544a\u8d39","term_id":18,"description":"\u5728\u7535\u53f0\u3001\u6742\u5fd7\u7b49\u5a92\u4f53\u520a\u767b\u5e7f\u544a\u6240\u4ea7\u751f\u7684\u8d39\u7528\u3002","sort":8,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"2025-08-12 17:44:33","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":197,"is_system":false,"serial_no":"660137"},"name":"\u5e7f\u544a\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":706,"reimbursement_id":212,"user_id":1014,"status":1,"verify_at":"","user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}},{"id":707,"reimbursement_id":212,"user_id":1001,"status":2,"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":{},"haveReimbursementVerifyRel":{"id":706,"reimbursement_id":212,"user_id":1014,"status":1,"verify_at":""},"attachmentRelationships":[{"id":522,"object_type":19,"object_id":212,"attachment_id":2445,"attachment":{"id":2445,"key":2445,"name":"64681eba-9c38-3de5-85b1-a53191528fe1","extension":"pdf","path":"\/vue\/attachment\/view\/64681eba-9c38-3de5-85b1-a53191528fe1\/011001800211_34283370.pdf","orig_name":"011001800211_34283370.pdf"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[{"id":59,"reimbursement_id":212,"user_id":1014,"user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}}],"files":[],"erpCashCostTicket":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":false,"bgcolor":"#CE4A50","status_display":"\u5df2\u62d2\u7edd"},{"id":118,"status":4,"amount":"50","occurrence_at":"2019-01-03 17:00:00","settle_accounts_at":"","settle_accounts_by":"","description":"\u7535\u8bdd\u8865\u52a9\u8d39\u7528","created_by":1011,"created_at":"2019-01-03 17:34:42","updated_at":"2019-01-08 15:51:32","refuse_description":"\u6ce8\u660e\u6708\u4efd","client_id":"","project_id":"","next_verify_user":"","is_resubmited":true,"work_log_id":"","pre_sales_id":"","implement_record_id":"","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":118,"comment":5},"unreadComments":{},"type":{"id":197,"name":"\u5e7f\u544a\u8d39"},"costType":{"id":326,"object_id":118,"taxonomy_id":326,"term_id":18,"value":"","object_type":7,"extra_int":"","in_amount":"","out_amount":"","taxonomy":{"id":326,"name":"\u5e7f\u544a\u8d39","term_id":18,"description":"\u5728\u7535\u53f0\u3001\u6742\u5fd7\u7b49\u5a92\u4f53\u520a\u767b\u5e7f\u544a\u6240\u4ea7\u751f\u7684\u8d39\u7528\u3002","sort":8,"created_by":1000,"created_at":"2018-11-26 15:42:33","updated_at":"2025-08-12 17:44:33","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":197,"is_system":false,"serial_no":"660137"},"name":"\u5e7f\u544a\u8d39"},"settleAccountsBy":{},"reimbursementCarbonCopyRels":[],"reimbursementVerifyRels":[{"id":398,"reimbursement_id":118,"user_id":1014,"status":1,"verify_at":"","user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}},{"id":399,"reimbursement_id":118,"user_id":1001,"status":2,"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":{},"haveReimbursementVerifyRel":{"id":398,"reimbursement_id":118,"user_id":1014,"status":1,"verify_at":""},"attachmentRelationships":[{"id":349,"object_type":19,"object_id":118,"attachment_id":2239,"attachment":{"id":2239,"key":2239,"name":"68a2dbc0-ba36-345b-af70-da57ac9df866","extension":"jpg","path":"\/vue\/attachment\/view\/68a2dbc0-ba36-345b-af70-da57ac9df866\/\u5317\u4eac\u4e00\u5361\u901a\u7535\u5b50\u53d1\u7968.jpg","orig_name":"\u5317\u4eac\u4e00\u5361\u901a\u7535\u5b50\u53d1\u7968.jpg"}}],"client":{},"project":{},"workLog":{},"preSales":{},"implement":{},"needSettle":[],"reimbursementSettleRels":[{"id":111,"reimbursement_id":118,"user_id":1014,"user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","user_status":"-1","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}}],"files":[],"erpCashCostTicket":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_settle":false,"can_verify":false,"can_refuse":false,"can_erp_settle":false,"invoice_duplicated":false,"bgcolor":"#CE4A50","status_display":"\u5df2\u62d2\u7edd"}],"countArr":[{"key":"all","name":"\u5168\u90e8","value":"700","count":4},{"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":"700","count":4}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":0},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0},{"key":"settle","name":"\u6211\u7ed3\u7b97\u7684","value":0},{"key":"is_draft","name":"\u8349\u7a3f","value":9}],"can_create":true,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 15:07:41') RETURNING "id" |