Database Queries

总计32条数据
TimeDurationTypeQuery
  
16:03:17.0822.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'

16:03:17.0851.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

16:03:17.0890.7 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

16:03:17.0912.8 msSELECTSELECT count(*) as count, sum(case when "sub".status=1 then 1 else 0 end) countStatus1, sum(case when "sub".status=2 then 1 else 0 end) countStatus2, sum(case when "sub".status=4 then 1 else 0 end) countStatus4, sum(case when "sub".status=5 then 1 else 0 end) countStatus5, sum(case when "sub".status=6 then 1 else 0 end) countStatus6 FROM (SELECT DISTINCT r.* FROM "a57be577deb434"."tbl_punch_repairs" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_verify_rels" "rvr" ON rvr.punch_repair_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_cancel_verify_rels" "crvr" ON crvr.punch_repair_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_carbon_copy_rels" "rccr" ON rccr.punch_repair_id = r.id WHERE (("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 ("rvr"."user_id"=1000)) AND ("u"."department_id"='1') GROUP BY "r"."id") "sub"

16:03:17.0930.2 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("next_verify_user"=1000) OR ("next_cancel_verify_user"=1000)

16:03:17.09417.5 msSELECTSELECT count(object_id) as count FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_punch_repairs" "r" ON uc.object_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_carbon_copy_rels" "rccr" ON rccr.punch_repair_id = r.id WHERE (object_id = r.id AND object_type = '38' AND remind_user_id = '1000' AND is_read = false) AND ("rccr"."user_id"=1000) GROUP BY "object_id"

16:03:17.1121.5 msSELECTSELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_punch_repairs" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_verify_rels" "rvr" ON rvr.punch_repair_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_cancel_verify_rels" "crvr" ON crvr.punch_repair_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_carbon_copy_rels" "rccr" ON rccr.punch_repair_id = r.id WHERE (("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 ("rvr"."user_id"=1000)) AND ("u"."department_id"='1') GROUP BY "r"."id" ORDER BY "r"."created_at" DESC) "c"

16:03:17.1141.6 msSELECTSELECT r.* FROM "a57be577deb434"."tbl_punch_repairs" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_verify_rels" "rvr" ON rvr.punch_repair_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_cancel_verify_rels" "crvr" ON crvr.punch_repair_id = r.id LEFT JOIN "a57be577deb434"."tbl_punch_repair_carbon_copy_rels" "rccr" ON rccr.punch_repair_id = r.id WHERE (("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 ("rvr"."user_id"=1000)) AND ("u"."department_id"='1') GROUP BY "r"."id" ORDER BY "r"."created_at" DESC LIMIT 20

16:03:17.1160.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5329, 5358)

16:03:17.1160.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5358, 5329))

16:03:17.1170.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1

16:03:17.11719.7 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=38) AND ("object_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)) GROUP BY "object_id"

16:03:17.13716.2 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=38) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)) GROUP BY "object_id"

16:03:17.1530.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_carbon_copy_rels" WHERE "punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)

16:03:17.1540.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5252, 1014)

16:03:17.1540.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 1014, 1000))

16:03:17.1550.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_verify_rels" WHERE "punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4) ORDER BY "id"

16:03:17.1550.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1004)

16:03:17.1550.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1005, 1004))

16:03:17.1560.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_verify_rels" WHERE ("status"=0) AND ("punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)) ORDER BY "id"

16:03:17.1560.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_verify_rels" WHERE ("status" != 0) AND ("punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)) ORDER BY "id"

16:03:17.1561.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=201) AND ("object_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4))

16:03:17.1580.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_cancel_verify_rels" WHERE "punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4) ORDER BY "id"

16:03:17.1580.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

16:03:17.1590.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004)

16:03:17.1590.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_cancel_verify_rels" WHERE ("status"=0) AND ("punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)) ORDER BY "id"

16:03:17.1590.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

16:03:17.1600.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004)

16:03:17.1600.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_repair_cancel_verify_rels" WHERE ("status" != 0) AND ("punch_repair_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4)) ORDER BY "id"

16:03:17.1601.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=202) AND ("object_id" IN (200, 196, 190, 186, 174, 173, 170, 169, 4))

16:03:17.1620.5 msSELECTSELECT EXISTS(SELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1000 GROUP BY "ps"."id")

16:03:17.1631.6 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/punch-repair/list', '{"Filter":{"name":"","sort":""},"PunchRepairSearch":{"created_at_period":"","created_by":"","filter":"","form_department":"1","form_punchRepairVerifyRels":"","repair_type":"","status":"","verify_at_period":""},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752221056","token":"7efeb6b675a5716aa3a0fc9639c2d189","version_code":"1141"}', '{"code":200,"data":{"has_punch_strategies":true,"list":[{"id":200,"day_at":"2024-04-02","title":"\u8865\u5361","status":2,"repair_type":2,"repair_time":"2024-04-02 18:00:00","next_verify_user":"","verify_at":"2024-04-22 21:39:17","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-04-22 17:29:55","updated_at":"2024-04-22 21:39:17","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":200,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":209,"punch_repair_id":200,"user_id":1004,"status":1,"description":"","verify_at":"2024-04-22 21:39:17","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":209,"punch_repair_id":200,"user_id":1004,"status":1,"description":"","verify_at":"2024-04-22 21:39:17"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u9000","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":196,"day_at":"2024-04-02","title":"\u8865\u5361","status":2,"repair_type":1,"repair_time":"2024-04-02 09:00:00","next_verify_user":"","verify_at":"2024-04-02 17:48:04","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-04-02 16:32:50","updated_at":"2024-04-02 17:48:04","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":196,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":204,"punch_repair_id":196,"user_id":1004,"status":1,"description":"","verify_at":"2024-04-02 17:48:04","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":204,"punch_repair_id":196,"user_id":1004,"status":1,"description":"","verify_at":"2024-04-02 17:48:04"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u5230","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":190,"day_at":"2024-03-29","title":"\u6253\u4e0d\u4e0a\u5361","status":2,"repair_type":2,"repair_time":"2024-03-29 18:40:00","next_verify_user":"","verify_at":"2024-04-01 11:55:17","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-04-01 10:58:37","updated_at":"2024-04-01 11:55:17","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":190,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":197,"punch_repair_id":190,"user_id":1004,"status":1,"description":"","verify_at":"2024-04-01 11:55:17","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":197,"punch_repair_id":190,"user_id":1004,"status":1,"description":"","verify_at":"2024-04-01 11:55:17"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u9000","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":186,"day_at":"2024-03-28","title":"\u8865\u5361","status":2,"repair_type":2,"repair_time":"2024-03-28 18:00:00","next_verify_user":"","verify_at":"2024-03-29 16:40:43","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-03-29 16:39:58","updated_at":"2024-03-29 16:40:43","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":186,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":193,"punch_repair_id":186,"user_id":1004,"status":1,"description":"\u540c\u610f","verify_at":"2024-03-29 16:40:43","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":193,"punch_repair_id":186,"user_id":1004,"status":1,"description":"\u540c\u610f","verify_at":"2024-03-29 16:40:43"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u9000","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":174,"day_at":"2024-03-25","title":"\u8865\u5361","status":2,"repair_type":2,"repair_time":"2024-03-25 18:00:00","next_verify_user":"","verify_at":"2024-03-27 10:28:05","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-03-27 10:27:39","updated_at":"2024-03-27 10:28:05","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":174,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":181,"punch_repair_id":174,"user_id":1004,"status":1,"description":"","verify_at":"2024-03-27 10:28:05","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":181,"punch_repair_id":174,"user_id":1004,"status":1,"description":"","verify_at":"2024-03-27 10:28:05"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u9000","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":173,"day_at":"2024-03-25","title":"\u8865\u5361","status":6,"repair_type":2,"repair_time":"2024-03-25 00:00:00","next_verify_user":"","verify_at":"","next_cancel_verify_user":"","cancel_at":"2024-03-27 09:57:47.960851+08","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-03-27 09:57:29","updated_at":"2024-03-27 09:57:47","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":173,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":180,"punch_repair_id":173,"user_id":1004,"status":3,"description":"","verify_at":"","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":180,"punch_repair_id":173,"user_id":1004,"status":3,"description":"","verify_at":""},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[{"id":5,"punch_repair_id":173,"user_id":1004,"status":0,"description":"","verify_at":"","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairCancelVerifyRel":{"id":5,"punch_repair_id":173,"user_id":1004,"status":0,"description":"","verify_at":"","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},"havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u9000","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":false},{"id":170,"day_at":"2024-03-25","title":"\u8865\u5361","status":2,"repair_type":2,"repair_time":"2024-03-25 00:00:00","next_verify_user":"","verify_at":"2024-03-27 09:51:25","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-03-27 09:14:46","updated_at":"2024-03-27 09:51:25","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":170,"comment":4},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":177,"punch_repair_id":170,"user_id":1004,"status":1,"description":"","verify_at":"2024-03-27 09:51:25","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":177,"punch_repair_id":170,"user_id":1004,"status":1,"description":"","verify_at":"2024-03-27 09:51:25"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u9000","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":169,"day_at":"2024-03-25","title":"\u8865\u5361","status":2,"repair_type":1,"repair_time":"2024-03-25 00:00:00","next_verify_user":"","verify_at":"2024-03-27 09:51:29","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5329,"created_at":"2024-03-27 09:14:18","updated_at":"2024-03-27 09:51:29","cancel_description":"","createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":169,"comment":3},"unreadComments":{},"punchRepairCarbonCopyRels":[],"punchRepairVerifyRels":[{"id":176,"punch_repair_id":169,"user_id":1004,"status":1,"description":"","verify_at":"2024-03-27 09:51:29","user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":176,"punch_repair_id":169,"user_id":1004,"status":1,"description":"","verify_at":"2024-03-27 09:51:29"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u5230","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true},{"id":4,"day_at":"2023-05-04","title":"\u56e0app\u672a\u5347\u7ea7\u5bfc\u81f4\u65e0\u6cd5\u6253\u5361\uff0c\u5b9e\u9645\u5230\u5c97\u65f6\u95f48\u70b955\uff0c\u95e8\u53e3\u6253\u5361\u673a\u6709\u6307\u7eb9\u6253\u5361\u8bb0\u5f55","status":2,"repair_type":1,"repair_time":"2023-05-04 08:55:00","next_verify_user":"","verify_at":"2023-05-05 13:38:35","next_cancel_verify_user":"","cancel_at":"","description":"","refuse_description":"","is_resubmited":false,"created_by":5358,"created_at":"2023-05-04 17:54:50","updated_at":"2023-05-05 13:38:35","cancel_description":"","createdBy":{"id":5358,"key":5358,"name":"\u5468\u4e9a\u536b","sex":"M","department_id":1,"avatar":{"id":155,"user_id":5358,"name":"\/files\/cdn\/a57be577deb434\/avatar\/cc67a92e-83d7-33d5-b254-2565861062ed.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4,"comment":4},"unreadComments":{},"punchRepairCarbonCopyRels":[{"id":6,"punch_repair_id":4,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}},{"id":7,"punch_repair_id":4,"user_id":5252,"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":8,"punch_repair_id":4,"user_id":1014,"user":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}}],"punchRepairVerifyRels":[{"id":5,"punch_repair_id":4,"user_id":1005,"status":1,"description":"","verify_at":"2023-05-05 13:38:35","user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"lastPunchRepairVerifyRel":{},"havePunchRepairVerifyRel":{"id":5,"punch_repair_id":4,"user_id":1005,"status":1,"description":"","verify_at":"2023-05-05 13:38:35"},"attachmentRelationships":[],"punchRepairCancelVerifyRels":[],"lastPunchRepairCancelVerifyRel":"","havePunchRepairCancelVerifyRel":"","files":[],"repair_type_display":"\u7b7e\u5230","unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_cancel_verify":false,"can_cancel_refuse":false,"can_cancel":true}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":9},{"key":1,"name":"\u5ba1\u6279\u4e2d","count":0},{"key":2,"name":"\u5df2\u901a\u8fc7","count":8},{"key":4,"name":"\u5df2\u62d2\u7edd","count":0},{"key":5,"name":"\u64a4\u9500\u4e2d","count":0},{"key":6,"name":"\u5df2\u64a4\u9500","count":1}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":0},{"key":"self","name":"\u5df2\u53d1\u8d77","value":0},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":9,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-11 16:03:17') RETURNING "id"