Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-07 21:49:19' AND e.date<='2024-05-08 08:49:19'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-07 21:49:19' AND e.date<='2024-05-08 08:49:19'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-05-08 01:15:43' AND e.date<='2024-05-08 09:15:43'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-05-08 01:15:43' AND e.date<='2024-05-08 09:15:43'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-08 01:46:29' AND e.date<='2024-05-08 11:46:29'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-08 01:46:29' AND e.date<='2024-05-08 11:46:29'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-05-08 03:46:45' AND e.date<='2024-05-08 11:46:45'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-05-08 03:46:45' AND e.date<='2024-05-08 11:46:45'