Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 5:32:23' AND e.date<='2024-03-20 23:32:23' AND e.DeviceLoginName='3158' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-20 03:32:23' AND g.time<='2024-03-20 21:32:23' AND g.DeviceLoginName='3158' GROUP BY  g.time, g.Distance;
CountAzimuth:331
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-25 1:36:58' AND e.date<='2024-03-25 23:36:58' AND e.DeviceLoginName='3158' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-24 23:36:58' AND g.time<='2024-03-25 21:36:58' AND g.DeviceLoginName='3158' GROUP BY  g.time, g.Distance;
CountAzimuth:555