Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041080400' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:25:28' AND e.date<='2024-10-21 20:25:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041080400' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:25:28' AND e.date<='2024-10-21 20:25:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116305406' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 21:57:52' AND e.date<='2024-10-23 20:57:52'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116305406' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 21:57:52' AND e.date<='2024-10-23 20:57:52'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 21:57:40' AND e.date<='2024-10-21 20:57:40'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 21:57:40' AND e.date<='2024-10-21 20:57:40'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-13 21:57:40' AND e.date<='2024-10-14 20:57:40'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-13 21:57:40' AND e.date<='2024-10-14 20:57:40'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-24 04:59:43' AND e.date<='2024-10-24 11:59:43'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-24 04:59:43' AND e.date<='2024-10-24 11:59:43'