Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-17 0:31:0' AND e.date<='2024-04-17 12:31:0' AND e.DeviceLoginName='3210' 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-16 21:31:00' AND g.time<='2024-04-17 09:31:00' AND g.DeviceLoginName='3210' GROUP BY  g.time, g.Distance;
CountAzimuth:1482
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-16 12:33:30' AND e.date<='2024-04-17 12:33:30' AND e.DeviceLoginName='3210' 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-16 09:33:30' AND g.time<='2024-04-17 09:33:30' AND g.DeviceLoginName='3210' GROUP BY  g.time, g.Distance;
CountAzimuth:2827
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-17 0:34:17' AND e.date<='2024-04-17 12:34:17' AND e.DeviceLoginName='3210' 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-16 21:34:17' AND g.time<='2024-04-17 09:34:17' AND g.DeviceLoginName='3210' GROUP BY  g.time, g.Distance;
CountAzimuth:1505
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-17 0:38:0' AND e.date<='2024-04-17 12:38:0' AND e.DeviceLoginName='352353083458635' 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-16 21:38:00' AND g.time<='2024-04-17 09:38:00' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:517