Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3091' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-28 11:46:33' AND e.date<='2024-08-29 11:46:33'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3091' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-28 11:46:33' AND e.date<='2024-08-29 11:46:33'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-23 21:34:22' AND e.date<='2024-08-25 20:34:22'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-23 21:34:22' AND e.date<='2024-08-25 20:34:22'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-25 21:46:07' AND e.date<='2024-08-26 20:46:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-25 21:46:07' AND e.date<='2024-08-26 20:46:07'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-26 21:46:07' AND e.date<='2024-08-27 20:46:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-26 21:46:07' AND e.date<='2024-08-27 20:46:07'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-27 21:46:07' AND e.date<='2024-08-28 20:46:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-27 21:46:07' AND e.date<='2024-08-28 20:46:07'