Up to 5,000 rows, newest schedule_time first. Notification received = received_at when the app calls notification_received.php.
| ID | User ID | User | Schedule time (IST) | Title | Group | FCM sent | Notification received | Active |
|---|---|---|---|---|---|---|---|---|
| 283 | 6 | pooarasan | 27 Apr 2026, 04:00 AM | pooarasan | 4'o Clock | Yes | 14 Jun 2026, 04:18 AM | Yes |
| 282 | 6 | pooarasan | 27 Apr 2026, 03:55 AM | pooarasan | Pooarasan | Yes | 14 Jun 2026, 03:55 AM | Yes |
| 281 | 6 | pooarasan | 27 Apr 2026, 03:50 AM | 3'50 am | Pooarasan | Yes | 14 Jun 2026, 12:00 AM | Yes |
| 276 | 20 | Tamil | 24 Apr 2026, 04:10 AM | 4:05 | 4'o Clock | Yes | 13 Jun 2026, 12:00 AM | Yes |
| 277 | 18 | Naveen | 24 Apr 2026, 04:10 AM | 4:05 | 4'o Clock | Yes | 14 Jun 2026, 04:34 AM | Yes |
| 278 | 17 | Sathish | 24 Apr 2026, 04:10 AM | 4:05 | 4'o Clock | No | 29 May 2026, 04:30 AM | Yes |
| 279 | 15 | Madesh | 24 Apr 2026, 04:10 AM | 4:05 | 4'o Clock | Yes | 14 Jun 2026, 04:17 AM | Yes |
| 271 | 20 | Tamil | 24 Apr 2026, 04:00 AM | 4'o clock | 4'o Clock | Yes | 13 Jun 2026, 12:00 AM | Yes |
| 272 | 18 | Naveen | 24 Apr 2026, 04:00 AM | 4'o clock | 4'o Clock | Yes | 14 Jun 2026, 04:34 AM | Yes |
| 273 | 17 | Sathish | 24 Apr 2026, 04:00 AM | 4'o clock | 4'o Clock | No | 29 May 2026, 04:30 AM | Yes |
| 274 | 15 | Madesh | 24 Apr 2026, 04:00 AM | 4'o clock | 4'o Clock | Yes | 14 Jun 2026, 04:17 AM | Yes |
| User ID | Name | Account status |
|---|---|---|
| 24 | Srinivasan | Active |
| 23 | Hariharan | Active |
| 22 | Mangamma | Active |
| 21 | Selvi | Active |
| 20 | Tamil | Active |
| 18 | Naveen | Active |
| 17 | Sathish | Active |
| 15 | Madesh | Active |
| 13 | test | Active |
| 7 | Nagesh | Active |
| 6 | pooarasan | Active |
| 5 | Guru prasad | Active |
| 4 | vital | Active |
| 1 | Administrator | Active |
All accounts — email and phone are not shown.
users × fcm_tokens)Same join as your query: every FCM token row with its user (multiple rows if a user has multiple devices). Up to 10,000 rows.
| user_id | name | device_name | device_type | is_active | app_version | app_build | os_version | device_model | updated_at |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Administrator | realme RMX3780 | android | 0 | 2.3.2 | 1 | 15 (SDK 35) | RMX3780 | 01 Jun 2026, 11:35 AM |
| 5 | Guru prasad | realme RMX3741 | android | 1 | 2.3.3 | 1 | 15 (SDK 35) | RMX3741 | 14 Jun 2026, 07:26 AM |
| 23 | Hariharan | HUAWEI EVR-L29 | android | 1 | 2.3.3 | 1 | 10 (SDK 29) | EVR-L29 | 10 Jun 2026, 08:28 AM |
| 15 | Madesh | samsung SM-S911B | android | 0 | 2.3.3 | 1 | 16 (SDK 36) | SM-S911B | 14 Jun 2026, 09:17 AM |
| 7 | Nagesh | realme RMX3840 | android | 1 | 2.3.3 | 1 | 16 (SDK 36) | RMX3840 | 14 Jun 2026, 09:34 AM |
| 18 | Naveen | samsung SM-A366E | android | 1 | 2.3.3 | 1 | 16 (SDK 36) | SM-A366E | 14 Jun 2026, 04:34 AM |
| 6 | pooarasan | OPPO CPH2495 | android | 1 | 2.3.3 | 1 | 15 (SDK 35) | CPH2495 | 14 Jun 2026, 07:29 AM |
| 17 | Sathish | samsung SM-A366E | android | 0 | 2.3.3 | 1 | 16 (SDK 36) | SM-A366E | 05 Jun 2026, 05:58 AM |
| 21 | Selvi | vivo vivo 1907 | android | 1 | 2.3.3 | 1 | 12 (SDK 31) | vivo 1907 | 14 Jun 2026, 07:45 AM |
| 24 | Srinivasan | samsung SM-S911B | android | 1 | 2.3.3 | 1 | 16 (SDK 36) | SM-S911B | 14 Jun 2026, 09:17 AM |
| 20 | Tamil | vivo V2058 | android | 1 | 2.3.3 | 1 | 13 (SDK 33) | V2058 | 13 Jun 2026, 06:29 AM |
| 13 | test | Google sdk_gphone64_x86_64 | android | 1 | 2.2.1 | 1 | 16 (SDK 36) | sdk_gphone64_x86_64 | 07 May 2026, 12:01 PM |
| 4 | vital | realme RMX3780 | android | 1 | 2.3.3 | 1 | 15 (SDK 35) | RMX3780 | 01 Jun 2026, 12:20 PM |
Schedule rows in this month whose leave range includes today.
| Schedule time | Title | Contact name | Leave range | User | Notification received |
|---|---|---|---|---|---|
| No matching schedule rows. | |||||
| Dates | Day type | User | Status | Comments | Created |
|---|---|---|---|---|---|
| 12 Jun 2026 → 12 Jun 2026 | first_half |
Tamil ID 20 |
rejected | Health Issues | 12 Jun 2026, 04:17 AM |
| 12 Jun 2026 → 12 Jun 2026 | second_half |
Madesh ID 15 |
approved | Health Issues | 09 Jun 2026, 08:36 AM |
| 12 Jun 2026 → 12 Jun 2026 | first_half |
Madesh ID 15 |
approved | Health Issues | 09 Jun 2026, 08:36 AM |
| 07 Jun 2026 → 07 Jun 2026 | second_half |
Srinivasan ID 24 |
approved | Health Issues | 06 Jun 2026, 04:07 AM |
| 07 Jun 2026 → 07 Jun 2026 | first_half |
Srinivasan ID 24 |
approved | Health Issues | 06 Jun 2026, 04:07 AM |
YYYY-MM-DD.log)Choose a date to load that day’s log (same files as /v4/logs/). Large files truncated at 2 MB.
[2026-06-14 00:00:02] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 00:00:02] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 00:00:02] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] Notification Results:
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] -------------------------
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] All schedules reset: sent = 0
[2026-06-14 00:00:02] [cron_mark_yesterday_absent] start
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] Active status updated based on leave dates
[2026-06-14 00:00:02] [cron_mark_yesterday_absent] {"success":true,"date":"2026-06-13","marked_absent":5,"users_absent":[{"user_id":4,"name":"vital"},{"user_id":13,"name":"test"},{"user_id":17,"name":"Sathish"},{"user_id":20,"name":"Tamil"},{"user_id":22,"name":"Mangamma"}]}
[2026-06-14 00:00:02] [cron_mark_yesterday_absent] end
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] User Tamil → Schedule 271 (active=1) sent to 1 device(s)
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] User Naveen → Schedule 272 (active=1) sent to 1 device(s)
[2026-06-14 00:00:02] [cron_daily_schedule_fcm] User Sathish → Schedule 273 (active=1) no active devices
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User Madesh → Schedule 274 (active=1) sent to 1 device(s)
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User Tamil → Schedule 276 (active=1) sent to 1 device(s)
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User Naveen → Schedule 277 (active=1) sent to 1 device(s)
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User Sathish → Schedule 278 (active=1) no active devices
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User Madesh → Schedule 279 (active=1) sent to 1 device(s)
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User pooarasan → Schedule 281 (active=1) sent to 1 device(s)
[2026-06-14 00:00:03] [cron_daily_schedule_fcm] User pooarasan → Schedule 282 (active=1) sent to 1 device(s)
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] User pooarasan → Schedule 283 (active=1) sent to 1 device(s)
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] -------------------------
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] Total Sent: 9
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] Total Skipped: 2
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] Execution Time: 1.88 sec
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] -------------------------
[2026-06-14 00:00:04] [cron_daily_schedule_fcm] Done.
[2026-06-14 00:00:04] [notification_received] Schedule 281 acknowledged by user_id=6 (event=received)
[2026-06-14 00:00:04] [notification_received] Schedule 282 acknowledged by user_id=6 (event=received)
[2026-06-14 00:00:06] [notification_received] Schedule 283 acknowledged by user_id=6 (event=received)
[2026-06-14 01:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 01:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 01:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 02:00:02] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 02:00:02] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 02:00:02] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 03:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 03:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 03:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 03:50:03] [fcm_token] FCM token saved/updated: user_id=6 device_type=android
[2026-06-14 03:55:02] [notification_received] Schedule 282 acknowledged by user_id=6 (event=tapped)
[2026-06-14 03:55:13] [notification_received] Schedule 282 acknowledged by user_id=6 (event=tapped)
[2026-06-14 03:55:23] [fcm_token] FCM token saved/updated: user_id=6 device_type=android
[2026-06-14 04:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 04:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 04:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 04:00:13] [notification_received] Schedule 283 acknowledged by user_id=6 (event=tapped)
[2026-06-14 04:17:07] [notification_received] Schedule 279 acknowledged by user_id=15 (event=tapped)
[2026-06-14 04:17:07] [notification_received] Schedule 274 acknowledged by user_id=15 (event=received)
[2026-06-14 04:17:07] [fcm_token] FCM token saved/updated: user_id=15 device_type=android
[2026-06-14 04:17:20] [notification_received] Schedule 279 acknowledged by user_id=15 (event=tapped)
[2026-06-14 04:17:28] [fcm_token] FCM token saved/updated: user_id=24 device_type=android
[2026-06-14 04:18:01] [notification_received] Schedule 283 acknowledged by user_id=6 (event=tapped)
[2026-06-14 04:18:12] [fcm_token] FCM token saved/updated: user_id=5 device_type=android
[2026-06-14 04:18:21] [attendance_code_created] date=2026-06-14 type=first_half
[2026-06-14 04:19:08] [attendance_login] user_id=24 date=2026-06-14 first_half
[2026-06-14 04:19:18] [attendance_login] user_id=15 date=2026-06-14 first_half
[2026-06-14 04:26:06] [fcm_token] FCM token saved/updated: user_id=7 device_type=android
[2026-06-14 04:26:09] [attendance_login] user_id=7 date=2026-06-14 first_half
[2026-06-14 04:26:40] [attendance_login] user_id=6 date=2026-06-14 first_half
[2026-06-14 04:26:45] [attendance_logout] user_id=6 date=2026-06-14 first_half
[2026-06-14 04:31:18] [fcm_token] FCM token saved/updated: user_id=21 device_type=android
[2026-06-14 04:31:31] [attendance_login] user_id=21 date=2026-06-14 first_half
[2026-06-14 04:34:22] [fcm_token] FCM token saved/updated: user_id=18 device_type=android
[2026-06-14 04:34:31] [notification_received] Schedule 272 acknowledged by user_id=18 (event=received)
[2026-06-14 04:34:31] [notification_received] Schedule 277 acknowledged by user_id=18 (event=received)
[2026-06-14 04:34:56] [attendance_login] user_id=18 date=2026-06-14 first_half
[2026-06-14 05:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 05:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 05:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 06:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 06:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 06:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 07:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 07:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 07:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 07:12:03] [fcm_token] FCM token saved/updated: user_id=24 device_type=android
[2026-06-14 07:12:06] [attendance_logout] user_id=24 date=2026-06-14 first_half
[2026-06-14 07:13:07] [fcm_token] FCM token saved/updated: user_id=21 device_type=android
[2026-06-14 07:13:10] [attendance_logout] user_id=21 date=2026-06-14 first_half
[2026-06-14 07:15:00] [fcm_token] FCM token saved/updated: user_id=15 device_type=android
[2026-06-14 07:15:04] [attendance_logout] user_id=15 date=2026-06-14 first_half
[2026-06-14 07:24:32] [attendance_logout] user_id=7 date=2026-06-14 first_half
[2026-06-14 07:24:42] [fcm_token] FCM token saved/updated: user_id=6 device_type=android
[2026-06-14 07:26:07] [fcm_token] FCM token saved/updated: user_id=5 device_type=android
[2026-06-14 07:26:11] [attendance_code_created] date=2026-06-14 type=second_half
[2026-06-14 07:26:28] [attendance_login] user_id=6 date=2026-06-14 second_half
[2026-06-14 07:26:40] [attendance_login] user_id=7 date=2026-06-14 second_half
[2026-06-14 07:29:08] [fcm_token] FCM token saved/updated: user_id=6 device_type=android
[2026-06-14 07:45:18] [fcm_token] FCM token saved/updated: user_id=21 device_type=android
[2026-06-14 07:46:28] [attendance_login] user_id=21 date=2026-06-14 second_half
[2026-06-14 07:50:03] [attendance_login] user_id=24 date=2026-06-14 second_half
[2026-06-14 07:51:26] [attendance_logout] user_id=21 date=2026-06-14 second_half
[2026-06-14 07:51:50] [attendance_logout] user_id=18 date=2026-06-14 first_half
[2026-06-14 07:51:54] [attendance_login] user_id=18 date=2026-06-14 second_half
[2026-06-14 08:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 08:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 08:00:01] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 08:20:35] [attendance_logout] user_id=18 date=2026-06-14 second_half
[2026-06-14 09:00:02] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 09:00:02] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 09:00:02] [cron_deactivate_schedules_for_inactive_users] end
[2026-06-14 09:13:35] [attendance_logout] user_id=24 date=2026-06-14 second_half
[2026-06-14 09:16:00] [fcm_token] FCM token saved/updated: user_id=24 device_type=android
[2026-06-14 09:16:00] [logout] User logged out: user_id=24
[2026-06-14 09:16:06] [login] User logged in: user_id=15 name="Madesh" contact=8531087888
[2026-06-14 09:16:08] [fcm_token] FCM token saved/updated: user_id=15 device_type=android
[2026-06-14 09:16:27] [attendance_login] user_id=15 date=2026-06-14 second_half
[2026-06-14 09:16:30] [attendance_logout] user_id=15 date=2026-06-14 second_half
[2026-06-14 09:17:18] [fcm_token] FCM token saved/updated: user_id=15 device_type=android
[2026-06-14 09:17:29] [logout] User logged out: user_id=15
[2026-06-14 09:17:44] [login] User logged in: user_id=24 name="Srinivasan" contact=7806932055
[2026-06-14 09:17:46] [fcm_token] FCM token saved/updated: user_id=24 device_type=android
[2026-06-14 09:34:29] [fcm_token] FCM token saved/updated: user_id=7 device_type=android
[2026-06-14 09:35:03] [attendance_logout] user_id=7 date=2026-06-14 second_half
[2026-06-14 10:00:01] [cron_deactivate_schedules_for_inactive_users] start
[2026-06-14 10:00:01] [cron_deactivate_schedules_for_inactive_users] {"success":true,"message":"No inactive users","inactive_user_ids":[],"schedules_updated":0}
[2026-06-14 10:00:01] [cron_deactivate_schedules_for_inactive_users] end