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-21 23:24:44' AND e.date<='2024-05-22 09:24:44'
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-21 23:24:44' AND e.date<='2024-05-22 09:24:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 21:45:20' AND e.date<='2024-05-22 20:45:20'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 21:45:20' AND e.date<='2024-05-22 20:45:20'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-31 21:45:20' AND e.date<='2024-04-30 20:45:20'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-31 21:45:20' AND e.date<='2024-04-30 20:45:20'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 21:45:20' AND e.date<='2024-05-22 20:45:20'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 21:45:20' AND e.date<='2024-05-22 20:45:20'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-31 21:45:20' AND e.date<='2024-04-30 20:45:20'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-31 21:45:20' AND e.date<='2024-04-30 20:45:20'