| 17:58:49.950 | 4.2 ms | SELECT | SELECT COUNT(*) FROM (SELECT * FROM ((SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ((("w"."start_at" >= '2025-12-17 00:00:00') AND ("w"."end_at" < '2025-12-17 23:59:59')) OR (("w"."start_at" <= '2025-12-17 00:00:00') AND ("w"."end_at" > '2025-12-17 00:00:00')) OR (("w"."start_at" <= '2025-12-17 23:59:59') AND ("w"."end_at" > '2025-12-17 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1000) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT
*,
CASE WHEN end_at IS NULL THEN
(
CASE WHEN start_at > now() THEN start_at ELSE
(
CASE WHEN is_complete = true THEN complete_at ELSE
now() END
)
END
)
ELSE
(
CASE WHEN start_at IS NULL AND end_at < now() THEN
(
CASE WHEN is_complete = true THEN complete_at ELSE
now() END
)
ELSE
end_at
END
)
END AS e_at,
CASE WHEN start_at IS NULL THEN
(
CASE WHEN end_at < now() THEN
(
CASE WHEN is_complete = true
THEN created_at
ELSE end_at
END
)
ELSE
(
CASE WHEN is_complete = true
THEN created_at
ELSE now() END
)
END
)
ELSE start_at END AS s_at
FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" WHERE ((("s"."s_at" >= '2025-12-17 00:00:00') AND ("s"."e_at" < '2025-12-17 23:59:59')) OR (("s"."s_at" <= '2025-12-17 00:00:00') AND ("s"."e_at" > '2025-12-17 00:00:00')) OR (("s"."s_at" <= '2025-12-17 23:59:59') AND ("s"."e_at" > '2025-12-17 23:59:59'))) AND ("s"."created_by"=1000) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."start_at" >= '2025-12-17 00:00:00') AND ("c"."end_at" < '2025-12-17 23:59:59')) OR (("c"."start_at" <= '2025-12-17 00:00:00') AND ("c"."end_at" > '2025-12-17 00:00:00')) OR (("c"."start_at" <= '2025-12-17 23:59:59') AND ("c"."end_at" > '2025-12-17 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at") "c" |
| 17:58:49.954 | 4.6 ms | SELECT | SELECT * FROM ((SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ((("w"."start_at" >= '2025-12-17 00:00:00') AND ("w"."end_at" < '2025-12-17 23:59:59')) OR (("w"."start_at" <= '2025-12-17 00:00:00') AND ("w"."end_at" > '2025-12-17 00:00:00')) OR (("w"."start_at" <= '2025-12-17 23:59:59') AND ("w"."end_at" > '2025-12-17 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1000) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT
*,
CASE WHEN end_at IS NULL THEN
(
CASE WHEN start_at > now() THEN start_at ELSE
(
CASE WHEN is_complete = true THEN complete_at ELSE
now() END
)
END
)
ELSE
(
CASE WHEN start_at IS NULL AND end_at < now() THEN
(
CASE WHEN is_complete = true THEN complete_at ELSE
now() END
)
ELSE
end_at
END
)
END AS e_at,
CASE WHEN start_at IS NULL THEN
(
CASE WHEN end_at < now() THEN
(
CASE WHEN is_complete = true
THEN created_at
ELSE end_at
END
)
ELSE
(
CASE WHEN is_complete = true
THEN created_at
ELSE now() END
)
END
)
ELSE start_at END AS s_at
FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" WHERE ((("s"."s_at" >= '2025-12-17 00:00:00') AND ("s"."e_at" < '2025-12-17 23:59:59')) OR (("s"."s_at" <= '2025-12-17 00:00:00') AND ("s"."e_at" > '2025-12-17 00:00:00')) OR (("s"."s_at" <= '2025-12-17 23:59:59') AND ("s"."e_at" > '2025-12-17 23:59:59'))) AND ("s"."created_by"=1000) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."start_at" >= '2025-12-17 00:00:00') AND ("c"."end_at" < '2025-12-17 23:59:59')) OR (("c"."start_at" <= '2025-12-17 00:00:00') AND ("c"."end_at" > '2025-12-17 00:00:00')) OR (("c"."start_at" <= '2025-12-17 23:59:59') AND ("c"."end_at" > '2025-12-17 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at" |
| 17:58:49.967 | 1.7 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 269, 'v2/user/get-index', '{"access_token":"GyQCDSxxUIq_MDcFvrRqAhndTAObPJc9","device_type":"0","version_code":"269","token":"0b7ea66a7e69e24c968188bba918ce90","posttime":"1765965528"}', '{"code":200,"data":{"announcementUnread":{"count":47},"unread":[{"key":"37","value":1},{"key":999,"value":39},{"key":16,"value":6},{"key":20000,"value":1}],"calendar":{"list":[{"id":277782,"title":"\u3010\u8ffd\u4e66\u795e\u5668\u3011\u514d\u8d39\u770b\u70ed\u95e8\u5c0f\u8bf4+\u7b7e\u5230\u9886688\u91d1\u5e01","client_id":null,"created_by":1000,"start_at":"2025-12-17 09:30:45","end_at":"2025-12-17 09:45:45","type":1,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/7885354f-88cb-3fd6-86a2-e5266fff8f15.png"}},"client":null,"start_at_display":"09:30","end_at_display":"09:45","can_update":true,"can_delete":true,"attachmentRelationships":[]},{"id":277713,"title":"\u3010\u8ffd\u4e66\u795e\u5668\u3011\u514d\u8d39\u770b\u70ed\u95e8\u5c0f\u8bf4+\u7b7e\u5230\u9886688\u91d1\u5e01","client_id":null,"created_by":1000,"start_at":"2025-12-17 09:30:51","end_at":"2025-12-17 09:45:51","type":1,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/7885354f-88cb-3fd6-86a2-e5266fff8f15.png"}},"client":null,"start_at_display":"09:30","end_at_display":"09:45","can_update":true,"can_delete":true,"attachmentRelationships":[]},{"id":277843,"title":"\u521a\u56de\u5bb6","client_id":null,"created_by":1000,"start_at":"2025-12-17 11:53:12","end_at":"2025-12-17 12:53:12","type":1,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/7885354f-88cb-3fd6-86a2-e5266fff8f15.png"}},"client":null,"start_at_display":"11:53","end_at_display":"12:53","can_update":true,"can_delete":true,"attachmentRelationships":[]},{"id":277652,"title":"[\u5143\u5143\u8bb0\u8d26]-\u4e3b\u4eba\uff0c\u4eca\u5929\u8bb0\u8d26\u4e86\u5417~","client_id":null,"created_by":1000,"start_at":"2025-12-17 20:00:41","end_at":"2025-12-17 21:00:41","type":1,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/7885354f-88cb-3fd6-86a2-e5266fff8f15.png"}},"client":null,"start_at_display":"20:00","end_at_display":"21:00","can_update":true,"can_delete":true,"attachmentRelationships":[]}],"point":[{"edate":"2025-12-31","is_used":true,"is_calendar_used":true,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-30","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-29","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-28","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-27","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-26","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-25","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-24","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-23","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-22","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-21","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-20","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-19","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-18","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-17","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-16","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-15","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-14","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-13","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-12","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-11","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-10","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-09","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-08","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-07","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-06","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-05","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-04","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-03","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":true},{"edate":"2025-12-02","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-01","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":4,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.72.15.22","ua":"jinchangxiao\/2.3.169 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2025-12-17 17:58:49') RETURNING "id" |