Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:8:32' AND e.date<='2024-07-14 23:8:32' AND e.DeviceLoginName='352353084655866' 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-07-07 21:08:32' AND g.time<='2024-07-14 20:08:32' AND g.DeviceLoginName='352353084655866' GROUP BY  g.time, g.Distance;
CountAzimuth:4655
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 0:7:18' AND e.date<='2024-07-16 10:7:18' AND e.DeviceLoginName='2513' 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-07-15 21:07:18' AND g.time<='2024-07-16 07:07:18' AND g.DeviceLoginName='2513' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 10:34:37' AND e.date<='2024-07-16 10:34:37' AND e.DeviceLoginName='3186' 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-07-15 07:34:37' AND g.time<='2024-07-16 07:34:37' AND g.DeviceLoginName='3186' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:34:37' AND e.date<='2024-07-09 23:34:37' AND e.DeviceLoginName='3186' 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-07-07 21:34:37' AND g.time<='2024-07-09 20:34:37' AND g.DeviceLoginName='3186' GROUP BY  g.time, g.Distance;
CountAzimuth:1796
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 0:34:37' AND e.date<='2024-07-10 23:34:37' AND e.DeviceLoginName='3186' 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-07-09 21:34:37' AND g.time<='2024-07-10 20:34:37' AND g.DeviceLoginName='3186' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:34:37' AND e.date<='2024-07-11 23:34:37' AND e.DeviceLoginName='3186' 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-07-10 21:34:37' AND g.time<='2024-07-11 20:34:37' AND g.DeviceLoginName='3186' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 0:34:37' AND e.date<='2024-07-12 23:34:37' AND e.DeviceLoginName='3186' 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-07-11 21:34:37' AND g.time<='2024-07-12 20:34:37' AND g.DeviceLoginName='3186' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-15 0:38:46' AND e.date<='2024-07-15 23:38:46' AND e.DeviceLoginName='352353084656807' 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-07-14 21:38:46' AND g.time<='2024-07-15 20:38:46' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:5