Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-29 0:6:10' AND e.date<='2024-04-30 10:6:10' AND e.DeviceLoginName='3172' 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-04-28 21:06:10' AND g.time<='2024-04-30 07:06:10' AND g.DeviceLoginName='3172' GROUP BY  g.time, g.Distance;
CountAzimuth:184
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-26 23:0:0' AND e.date<='2024-04-27 5:0:0' AND e.DeviceLoginName='352353086156905' 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-04-26 20:00:00' AND g.time<='2024-04-27 02:00:00' AND g.DeviceLoginName='352353086156905' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-26 23:0:0' AND e.date<='2024-04-27 5:0:0' AND e.DeviceLoginName='9004' 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-04-26 20:00:00' AND g.time<='2024-04-27 02:00:00' AND g.DeviceLoginName='9004' GROUP BY  g.time, g.Distance;
CountAzimuth:114
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-26 23:0:0' AND e.date<='2024-04-27 5:0:0' AND e.DeviceLoginName='2557' 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-04-26 20:00:00' AND g.time<='2024-04-27 02:00:00' AND g.DeviceLoginName='2557' GROUP BY  g.time, g.Distance;
CountAzimuth:213
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-27 0:0:8' AND e.date<='2024-04-27 23:59:8' AND e.DeviceLoginName='356078118085311' 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-04-26 21:00:08' AND g.time<='2024-04-27 20:59:08' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:1311
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-28 0:0:8' AND e.date<='2024-04-28 23:59:8' AND e.DeviceLoginName='356078118085311' 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-04-27 21:00:08' AND g.time<='2024-04-28 20:59:08' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:2107
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-30 12:0:0' AND e.date<='2024-04-30 15:0:0' AND e.DeviceLoginName='352353084275277' 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-04-30 09:00:00' AND g.time<='2024-04-30 12:00:00' AND g.DeviceLoginName='352353084275277' GROUP BY  g.time, g.Distance;
CountAzimuth:236