Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-17 0:38:51' AND e.date<='2024-04-17 23:38:51' AND e.DeviceLoginName='4849' 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:51' AND g.time<='2024-04-17 20:38:51' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:2291
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-17 0:40:28' AND e.date<='2024-04-17 23:40:28' AND e.DeviceLoginName='2762' 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:40:28' AND g.time<='2024-04-17 20:40:28' AND g.DeviceLoginName='2762' GROUP BY  g.time, g.Distance;
CountAzimuth:2100
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-18 0:37:42' AND e.date<='2024-04-18 10:37:42' AND e.DeviceLoginName='356078116301603' 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-17 21:37:42' AND g.time<='2024-04-18 07:37:42' AND g.DeviceLoginName='356078116301603' GROUP BY  g.time, g.Distance;
CountAzimuth:360
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-18 0:38:58' AND e.date<='2024-04-18 10:38:58' AND e.DeviceLoginName='356078116301603' 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-17 21:38:58' AND g.time<='2024-04-18 07:38:58' AND g.DeviceLoginName='356078116301603' GROUP BY  g.time, g.Distance;
CountAzimuth:372