Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='9022' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-16 22:00:00' AND e.date<='2024-01-17 07:11:11'
Method:GetStops; stop_time2024-01-17 05:17:30
Method:GetStops; stop_time2024-01-17 07:02:01
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-14 22:21:59' AND e.date<='2024-01-15 21:21:59'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-14 22:21:59' AND e.date<='2024-01-15 21:21:59'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 15:34:13' AND e.date<='2024-01-09 08:34:13'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 15:34:13' AND e.date<='2024-01-09 08:34:13'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111430829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-14 22:41:54' AND e.date<='2024-01-15 21:41:54'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111430829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-14 22:41:54' AND e.date<='2024-01-15 21:41:54'