Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-05 0:59:9' AND e.date<='2024-10-05 17:59:9' 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-10-04 21:59:09' AND g.time<='2024-10-05 14:59:09' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:306
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-05 0:0:46' AND e.date<='2024-10-05 18:0:46' AND e.DeviceLoginName='2876' 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-10-04 21:00:46' AND g.time<='2024-10-05 15:00:46' AND g.DeviceLoginName='2876' GROUP BY  g.time, g.Distance;
CountAzimuth:674
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-05 0:33:44' AND e.date<='2024-10-05 21:33:44' 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-10-04 21:33:44' AND g.time<='2024-10-05 18:33:44' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:622