Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-16 21:38:51' AND e.date<='2024-04-17 20:38:51'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-16 21:38:51' AND e.date<='2024-04-17 20:38:51'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-16 21:40:28' AND e.date<='2024-04-17 20:40: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-16 21:40:28' AND e.date<='2024-04-17 20:40: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='356078116301603' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-17 21:37:42' AND e.date<='2024-04-18 07:37:42'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116301603' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-17 21:37:42' AND e.date<='2024-04-18 07:37:42'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116301603' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-17 21:38:58' AND e.date<='2024-04-18 07:38:58'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116301603' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-17 21:38:58' AND e.date<='2024-04-18 07:38:58'