Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3086' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-29 05:01:46' AND e.date<='2024-02-29 08:01:46'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3086' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-29 05:01:46' AND e.date<='2024-02-29 08:01:46'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3086' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-23 22:31:39' AND e.date<='2024-02-25 21:31:39'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3086' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-23 22:31:39' AND e.date<='2024-02-25 21:31:39'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-26 09:23:00' AND e.date<='2024-03-03 09:23: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='4962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-26 09:23:00' AND e.date<='2024-03-03 09:23:00'