Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 14:46:33' AND e.date<='2024-08-29 14:46:33' AND e.DeviceLoginName='3091' 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-08-28 11:46:33' AND g.time<='2024-08-29 11:46:33' AND g.DeviceLoginName='3091' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-24 0:34:22' AND e.date<='2024-08-25 23:34:22' AND e.DeviceLoginName='2500' 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-08-23 21:34:22' AND g.time<='2024-08-25 20:34:22' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:331
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-26 0:46:7' AND e.date<='2024-08-26 23:46:7' AND e.DeviceLoginName='2500' 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-08-25 21:46:07' AND g.time<='2024-08-26 20:46:07' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:279
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-27 0:46:7' AND e.date<='2024-08-27 23:46:7' AND e.DeviceLoginName='2500' 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-08-26 21:46:07' AND g.time<='2024-08-27 20:46:07' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:958
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-08-28 0:46:7' AND e.date<='2024-08-28 23:46:7' AND e.DeviceLoginName='2500' 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-08-27 21:46:07' AND g.time<='2024-08-28 20:46:07' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:996