Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2657' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-10 22:33:03' AND e.date<='2023-12-12 08:33:03'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2657' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-10 22:33:03' AND e.date<='2023-12-12 08:33: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='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-11-17 19:49:18' AND e.date<='2023-11-17 20:00:18'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-11-17 19:49:18' AND e.date<='2023-11-17 20:00:18'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3188' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-11-15 15:45:18' AND e.date<='2023-11-15 15:57:18'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3188' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-11-15 15:45:18' AND e.date<='2023-11-15 15:57:18'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3100' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-11-15 15:45:18' AND e.date<='2023-11-15 15:57:18'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3100' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-11-15 15:45:18' AND e.date<='2023-11-15 15:57:18'