Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-29 0:31:46' AND e.date<='2024-08-02 23:31:46' AND e.DeviceLoginName='4630' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-28 21:31:46' AND g.time<='2024-08-02 20:31:46' AND g.DeviceLoginName='4630' GROUP BY  g.time, g.Distance;
CountAzimuth:12933
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-29 0:51:43' AND e.date<='2024-08-02 23:51:43' AND e.DeviceLoginName='3162' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-28 21:51:43' AND g.time<='2024-08-02 20:51:43' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:9539