Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-11 15:7:10' AND e.date<='2024-09-11 15:13:10' AND e.DeviceLoginName='4884' 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-09-11 12:07:10' AND g.time<='2024-09-11 12:13:10' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-11 13:24:0' AND e.date<='2024-09-12 13:24:0' AND e.DeviceLoginName='356078116305406' 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-09-11 10:24:00' AND g.time<='2024-09-12 10:24:00' AND g.DeviceLoginName='356078116305406' GROUP BY  g.time, g.Distance;
CountAzimuth:329
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-09-12 0:2:29' AND e.date<='2024-09-12 16:2:29' AND e.DeviceLoginName='4884' 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-09-11 21:02:29' AND g.time<='2024-09-12 13:02:29' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:1388