Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-24 21:00:00' AND e.date<='2024-04-25 05:13:36'
Method:GetStops; stop_time2024-04-24 22:40:51
Method:GetStops; stop_time2024-04-24 22:48:56
Method:GetStops; stop_time2024-04-25 05:07:46
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-14 21:49:44' AND e.date<='2024-04-19 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-14 21:49:44' AND e.date<='2024-04-19 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-14 21:49:44' AND e.date<='2024-04-15 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-14 21:49:44' AND e.date<='2024-04-15 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-15 21:49:44' AND e.date<='2024-04-16 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-15 21:49:44' AND e.date<='2024-04-16 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-16 21:49:44' AND e.date<='2024-04-17 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-16 21:49:44' AND e.date<='2024-04-17 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-17 21:49:44' AND e.date<='2024-04-18 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-17 21:49:44' AND e.date<='2024-04-18 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-18 21:49:44' AND e.date<='2024-04-19 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-18 21:49:44' AND e.date<='2024-04-19 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-21 21:49:44' AND e.date<='2024-04-22 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-21 21:49:44' AND e.date<='2024-04-22 20:49:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-22 21:49:44' AND e.date<='2024-04-23 20:49:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3030' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-22 21:49:44' AND e.date<='2024-04-23 20:49:44'