Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-03-28 22:39:44' AND e.date<='2025-03-29 10:39: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='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2025-03-28 22:39:44' AND e.date<='2025-03-29 10:39:44'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2709' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2025-03-17 16:37:28' AND e.date<='2025-03-29 16:37:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2709' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2025-03-17 16:37:28' AND e.date<='2025-03-29 16:37:28'