Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-05 0:27:42' AND e.date<='2025-04-05 23:27:42' 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>='2025-04-04 21:27:42' AND g.time<='2025-04-05 20:27:42' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:656
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-06 0:2:40' AND e.date<='2025-04-06 20:2:40' 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>='2025-04-05 21:02:40' AND g.time<='2025-04-06 17:02:40' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:755
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-05 0:2:40' AND e.date<='2025-04-06 20:2:40' 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>='2025-04-04 21:02:40' AND g.time<='2025-04-06 17:02:40' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:1411