Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085923' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-01-09 22:42:17' AND e.date<='2025-01-11 08:42:17'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085923' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2025-01-09 22:42:17' AND e.date<='2025-01-11 08:42:17'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111471005' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-01-08 22:50:08' AND e.date<='2025-01-11 08:50:08'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111471005' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2025-01-08 22:50:08' AND e.date<='2025-01-11 08:50:08'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-01-10 22:08:07' AND e.date<='2025-01-11 19:08:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2025-01-10 22:08:07' AND e.date<='2025-01-11 19:08:07'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-22 22:08:07' AND e.date<='2025-01-11 19:08:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-22 22:08:07' AND e.date<='2025-01-11 19:08:07'