Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-11 05:59:35' AND e.date<='2024-12-11 21:59: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-11 05:59:35' AND e.date<='2024-12-11 21:59:35'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-11 23:02:13' AND e.date<='2024-12-12 06:02: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='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-11 23:02:13' AND e.date<='2024-12-12 06:02:13'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-11 22:00:00' AND e.date<='2024-12-12 08:47:40'
Method:GetStops; stop_time2024-12-12 07:12:01
Method:GetStops; stop_time2024-12-12 07:23:46
Method:GetStops; stop_time2024-12-12 07:56:16
Method:GetStops; stop_time2024-12-12 08:17:31
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-10 22:46:44' AND e.date<='2024-12-11 21:46:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-10 22:46:44' AND e.date<='2024-12-11 21:46:44'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-11 22:00:00' AND e.date<='2024-12-12 08:49:39'
Method:GetStops; stop_time2024-12-12 07:12:01
Method:GetStops; stop_time2024-12-12 07:23:46
Method:GetStops; stop_time2024-12-12 07:56:16
Method:GetStops; stop_time2024-12-12 08:17:31
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111430936' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 22:20:51' AND e.date<='2024-12-06 10:20:51'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111430936' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:20:51' AND e.date<='2024-12-06 10:20:51'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-12 00:25:36' AND e.date<='2024-12-12 11:25:36'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-12 00:25:36' AND e.date<='2024-12-12 11:25:36'