Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080274714' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-30 16:17:13' AND e.date<='2024-10-31 21:59:13'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080274714' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-30 16:17:13' AND e.date<='2024-10-31 21:59:13'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2494' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-30 22:00:27' AND e.date<='2024-10-31 07:00:27'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2494' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-30 22:00:27' AND e.date<='2024-10-31 07:00:27'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084144218' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-29 22:21:53' AND e.date<='2024-10-31 08:21:53'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084144218' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-29 22:21:53' AND e.date<='2024-10-31 08:21:53'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084144218' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-28 22:21:53' AND e.date<='2024-10-29 21:21:53'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084144218' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-28 22:21:53' AND e.date<='2024-10-29 21:21:53'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080173346' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-11 22:21:08' AND e.date<='2024-10-13 21:21:08'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080173346' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-11 22:21:08' AND e.date<='2024-10-13 21:21:08'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3139' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 10:33:51'
Method:GetStops; stop_time2024-10-31 10:19:20
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3139' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 10:57:51'
Method:GetStops; stop_time2024-10-31 10:19:20
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2533' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 11:43:53'
Method:GetStops; stop_time2024-10-31 05:30:09
Method:GetStops; stop_time2024-10-31 07:00:39
Method:GetStops; stop_time2024-10-31 07:17:39
Method:GetStops; stop_time2024-10-31 07:27:24
Method:GetStops; stop_time2024-10-31 07:57:09
Method:GetStops; stop_time2024-10-31 09:18:39
Method:GetStops; stop_time2024-10-31 09:39:09
Method:GetStops; stop_time2024-10-31 10:31:54
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2533' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-30 22:00:00' AND e.date<='2024-10-31 11:45:56'
Method:GetStops; stop_time2024-10-31 05:30:09
Method:GetStops; stop_time2024-10-31 07:00:39
Method:GetStops; stop_time2024-10-31 07:17:39
Method:GetStops; stop_time2024-10-31 07:27:24
Method:GetStops; stop_time2024-10-31 07:57:09
Method:GetStops; stop_time2024-10-31 09:18:39
Method:GetStops; stop_time2024-10-31 09:39:09
Method:GetStops; stop_time2024-10-31 10:31:54