Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-28 0:58:42' AND e.date<='2024-03-28 8:58:42' AND e.DeviceLoginName='353173060537865' 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-27 22:58:42' AND g.time<='2024-03-28 06:58:42' AND g.DeviceLoginName='353173060537865' GROUP BY  g.time, g.Distance;
CountAzimuth:230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-26 0:58:42' AND e.date<='2024-03-26 23:58:42' AND e.DeviceLoginName='352353084232922' 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-25 22:58:42' AND g.time<='2024-03-26 21:58:42' AND g.DeviceLoginName='352353084232922' GROUP BY  g.time, g.Distance;
CountAzimuth:1784
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-28 0:51:4' AND e.date<='2024-03-28 12:51:4' AND e.DeviceLoginName='3092' 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-27 22:51:04' AND g.time<='2024-03-28 10:51:04' AND g.DeviceLoginName='3092' GROUP BY  g.time, g.Distance;
CountAzimuth:1079