Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2505' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-11 07:23:13' AND e.date<='2023-12-13 07:23: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='2505' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-11 07:23:13' AND e.date<='2023-12-13 07:23: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='2927' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-12 07:31:39' AND e.date<='2023-12-13 07:31:39'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2927' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-12 07:31:39' AND e.date<='2023-12-13 07:31:39'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3134' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-12 22:31:44' AND e.date<='2023-12-13 17:31:44'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3134' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-12 22:31:44' AND e.date<='2023-12-13 17:31:44'