Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116287687' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-01 22:03:23' AND e.date<='2023-12-02 21:03:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116287687' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-01 22:03:23' AND e.date<='2023-12-02 21:03:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-09 08:20:00' AND e.date<='2024-01-10 08:20:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-09 08:20:00' AND e.date<='2024-01-10 08:20:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 22:20:00' AND e.date<='2024-01-02 21:20:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 22:20:00' AND e.date<='2024-01-02 21:20:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 22:20:00' AND e.date<='2024-01-03 21:20:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 22:20:00' AND e.date<='2024-01-03 21:20:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 22:20:00' AND e.date<='2024-01-04 21:20:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4844' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 22:20:00' AND e.date<='2024-01-04 21:20:00'