Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2522' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 22:00:00' AND e.date<='2023-12-28 11:27:04'
Method:GetStops; stop_time2023-12-18 05:10:42
Method:GetStops; stop_time2023-12-18 05:55:27
Method:GetStops; stop_time2023-12-18 07:01:57
Method:GetStops; stop_time2023-12-18 07:43:27
Method:GetStops; stop_time2023-12-18 08:40:42
Method:GetStops; stop_time2023-12-18 10:20:57
Method:GetStops; stop_time2023-12-18 11:13:27
Method:GetStops; stop_time2023-12-18 12:15:42
Method:GetStops; stop_time2023-12-18 12:31:27
Method:GetStops; stop_time2023-12-18 13:16:57
Method:GetStops; stop_time2023-12-18 13:53:12
Method:GetStops; stop_time2023-12-18 15:41:27
Method:GetStops; stop_time2023-12-19 05:11:25
Method:GetStops; stop_time2023-12-19 05:54:40
Method:GetStops; stop_time2023-12-19 07:24:40
Method:GetStops; stop_time2023-12-19 08:30:10
Method:GetStops; stop_time2023-12-19 09:06:25
Method:GetStops; stop_time2023-12-19 10:22:25
Method:GetStops; stop_time2023-12-19 10:37:55
Method:GetStops; stop_time2023-12-19 11:31:10
Method:GetStops; stop_time2023-12-19 11:59:10
Method:GetStops; stop_time2023-12-19 12:26:55
Method:GetStops; stop_time2023-12-19 12:42:10
Method:GetStops; stop_time2023-12-19 13:49:25
Method:GetStops; stop_time2023-12-19 15:45:10
Method:GetStops; stop_time2023-12-19 16:18:10
Method:GetStops; stop_time2023-12-19 18:21:10
Method:GetStops; stop_time2023-12-20 05:15:25
Method:GetStops; stop_time2023-12-20 05:57:10
Method:GetStops; stop_time2023-12-20 06:43:25
Method:GetStops; stop_time2023-12-20 07:14:55
Method:GetStops; stop_time2023-12-20 07:24:55
Method:GetStops; stop_time2023-12-20 07:31:10
Method:GetStops; stop_time2023-12-20 09:20:10
Method:GetStops; stop_time2023-12-20 09:43:55
Method:GetStops; stop_time2023-12-20 09:56:55
Method:GetStops; stop_time2023-12-20 10:19:10
Method:GetStops; stop_time2023-12-20 10:46:25
Method:GetStops; stop_time2023-12-20 11:17:40
Method:GetStops; stop_time2023-12-20 12:19:10
Method:GetStops; stop_time2023-12-20 12:58:40
Method:GetStops; stop_time2023-12-20 13:41:25
Method:GetStops; stop_time2023-12-20 13:48:55
Method:GetStops; stop_time2023-12-20 14:35:40
Method:GetStops; stop_time2023-12-20 15:38:56
Method:GetStops; stop_time2023-12-20 15:57:42
Method:GetStops; stop_time2023-12-21 05:06:25
Method:GetStops; stop_time2023-12-21 05:50:25
Method:GetStops; stop_time2023-12-21 07:07:33
Method:GetStops; stop_time2023-12-21 07:25:03
Method:GetStops; stop_time2023-12-21 08:42:03
Method:GetStops; stop_time2023-12-21 08:57:18
Method:GetStops; stop_time2023-12-21 09:11:18
Method:GetStops; stop_time2023-12-21 10:03:02
Method:GetStops; stop_time2023-12-21 10:21:32
Method:GetStops; stop_time2023-12-21 10:52:02
Method:GetStops; stop_time2023-12-21 11:19:17
Method:GetStops; stop_time2023-12-21 11:30:32
Method:GetStops; stop_time2023-12-21 11:59:32
Method:GetStops; stop_time2023-12-21 12:19:47
Method:GetStops; stop_time2023-12-21 12:39:02
Method:GetStops; stop_time2023-12-21 12:59:47
Method:GetStops; stop_time2023-12-21 13:21:47
Method:GetStops; stop_time2023-12-21 13:54:17
Method:GetStops; stop_time2023-12-21 14:06:32
Method:GetStops; stop_time2023-12-21 15:06:32
Method:GetStops; stop_time2023-12-21 15:47:17
Method:GetStops; stop_time2023-12-22 05:02:46
Method:GetStops; stop_time2023-12-22 05:47:46
Method:GetStops; stop_time2023-12-22 07:33:31
Method:GetStops; stop_time2023-12-22 07:48:46
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2522' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-27 11:27:35' AND e.date<='2023-12-28 11:27:35'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2522' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-27 11:27:35' AND e.date<='2023-12-28 11:27:35'