Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-09 11:09:13' AND e.date<='2024-03-10 11:09: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='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-09 11:09:13' AND e.date<='2024-03-10 11:09: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='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-13 22:36:54' AND e.date<='2024-03-14 21:36: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='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-13 22:36:54' AND e.date<='2024-03-14 21:36:54'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2923' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-13 12:33:54' AND e.date<='2024-03-14 12:33: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='2923' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-13 12:33:54' AND e.date<='2024-03-14 12:33:54'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2923' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-10 22:33:54' AND e.date<='2024-03-11 12:33: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='2923' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-10 22:33:54' AND e.date<='2024-03-11 12:33:54'