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>='2023-12-20 13:57:11' AND e.date<='2023-12-20 05:57:11'
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>='2023-12-20 13:57:11' AND e.date<='2023-12-20 05:57:11'
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>='2023-12-19 12:57:33' AND e.date<='2023-12-19 21:57:33'
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>='2023-12-19 12:57:33' AND e.date<='2023-12-19 21:57:33'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-19 05:59:04' AND e.date<='2023-12-19 21:59:04'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-19 05:59:04' AND e.date<='2023-12-19 21:59:04'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2882' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-19 22:00:00' AND e.date<='2023-12-20 07:17:03'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288057' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-18 22:20:02' AND e.date<='2023-12-20 08:20:02'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288057' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-18 22:20:02' AND e.date<='2023-12-20 08:20:02'