Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-19 8:8:21' AND e.date<='2024-03-24 8:8:21' AND e.DeviceLoginName='2554' 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-02-19 06:08:21' AND g.time<='2024-03-24 06:08:21' AND g.DeviceLoginName='2554' GROUP BY  g.time, g.Distance;
CountAzimuth:14118