Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060537865' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-27 22:58:42' AND e.date<='2024-03-28 06:58:42'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060537865' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-27 22:58:42' AND e.date<='2024-03-28 06:58:42'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084232922' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-25 22:58:42' AND e.date<='2024-03-26 21:58:42'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084232922' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-25 22:58:42' AND e.date<='2024-03-26 21:58:42'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-27 22:51:04' AND e.date<='2024-03-28 10:51: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='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-27 22:51:04' AND e.date<='2024-03-28 10:51:04'