Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-25 21:53:21' AND e.date<='2024-06-26 20:53:21'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-25 21:53:21' AND e.date<='2024-06-26 20:53:21'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-26 12:24:36' AND e.date<='2024-06-26 20:24:36'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-26 12:24:36' AND e.date<='2024-06-26 20:24:36'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-26 11:29:14' AND e.date<='2024-06-26 16:29:14'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-26 11:29:14' AND e.date<='2024-06-26 16:29:14'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-16 21:56:57' AND e.date<='2024-06-21 20:56:57'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-16 21:56:57' AND e.date<='2024-06-21 20:56:57'