Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-11 0:33:3' AND e.date<='2023-12-12 10:33:3' AND e.DeviceLoginName='2657' 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>='2023-12-10 22:33:03' AND g.time<='2023-12-12 08:33:03' AND g.DeviceLoginName='2657' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-17 21:49:18' AND e.date<='2023-11-17 22:0:18' AND e.DeviceLoginName='2876' 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>='2023-11-17 19:49:18' AND g.time<='2023-11-17 20:00:18' AND g.DeviceLoginName='2876' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-15 17:45:18' AND e.date<='2023-11-15 17:57:18' AND e.DeviceLoginName='3188' 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>='2023-11-15 15:45:18' AND g.time<='2023-11-15 15:57:18' AND g.DeviceLoginName='3188' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-11-15 17:45:18' AND e.date<='2023-11-15 17:57:18' AND e.DeviceLoginName='3100' 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>='2023-11-15 15:45:18' AND g.time<='2023-11-15 15:57:18' AND g.DeviceLoginName='3100' GROUP BY  g.time, g.Distance;
CountAzimuth:4