Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-22 7:42:23' AND e.date<='2024-05-16 7:42:23' 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-04-22 04:42:23' AND g.time<='2024-05-16 04:42:23' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:11019
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-15 7:44:38' AND e.date<='2024-05-15 7:44:38' 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-05-15 04:44:38' AND g.time<='2024-05-15 04:44:38' 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-05-15 0:44:38' AND e.date<='2024-05-15 23:44:38' 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-05-14 21:44:38' AND g.time<='2024-05-15 20:44:38' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:734