Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-29 7:1:46' AND e.date<='2024-02-29 10:1:46' AND e.DeviceLoginName='3086' 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-29 05:01:46' AND g.time<='2024-02-29 08:01:46' AND g.DeviceLoginName='3086' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-24 0:31:39' AND e.date<='2024-02-25 23:31:39' AND e.DeviceLoginName='3086' 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-23 22:31:39' AND g.time<='2024-02-25 21:31:39' AND g.DeviceLoginName='3086' GROUP BY  g.time, g.Distance;
CountAzimuth:3375
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 11:23:0' AND e.date<='2024-03-03 11:23:0' AND e.DeviceLoginName='4962' 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-26 09:23:00' AND g.time<='2024-03-03 09:23:00' AND g.DeviceLoginName='4962' GROUP BY  g.time, g.Distance;
CountAzimuth:422