Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 0:29:31' AND e.date<='2023-12-24 23:29:31' AND e.DeviceLoginName='352353084275186' 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-23 22:29:31' AND g.time<='2023-12-24 21:29:31' AND g.DeviceLoginName='352353084275186' GROUP BY  g.time, g.Distance;
CountAzimuth:1235
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-04 8:35:17' AND e.date<='2024-01-05 8:35:17' AND e.DeviceLoginName='2933' 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-01-04 06:35:17' AND g.time<='2024-01-05 06:35:17' AND g.DeviceLoginName='2933' GROUP BY  g.time, g.Distance;
CountAzimuth:53
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 0:38:13' AND e.date<='2023-12-25 23:38:13' AND e.DeviceLoginName='2504' 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-24 22:38:13' AND g.time<='2023-12-25 21:38:13' AND g.DeviceLoginName='2504' GROUP BY  g.time, g.Distance;
CountAzimuth:1489
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 10:40:15' AND e.date<='2024-01-05 14:40:15' AND e.DeviceLoginName='2473' 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-01-05 08:40:15' AND g.time<='2024-01-05 12:40:15' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:457
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 12:40:46' AND e.date<='2024-01-05 14:40:46' AND e.DeviceLoginName='358021081803706' 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-01-05 10:40:46' AND g.time<='2024-01-05 12:40:46' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:369
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 5:2:37' AND e.date<='2024-01-05 15:2:37' AND e.DeviceLoginName='355234055741413' 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-01-05 03:02:37' AND g.time<='2024-01-05 13:02:37' AND g.DeviceLoginName='355234055741413' GROUP BY  g.time, g.Distance;
CountAzimuth:1444