Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-11 9:23:13' AND e.date<='2023-12-13 9:23:13' AND e.DeviceLoginName='2505' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-11 07:23:13' AND g.time<='2023-12-13 07:23:13' AND g.DeviceLoginName='2505' GROUP BY  g.time, g.Distance;
CountAzimuth:5176
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-12 9:31:39' AND e.date<='2023-12-13 9:31:39' AND e.DeviceLoginName='2927' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-12 07:31:39' AND g.time<='2023-12-13 07:31:39' AND g.DeviceLoginName='2927' GROUP BY  g.time, g.Distance;
CountAzimuth:591
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-13 0:31:44' AND e.date<='2023-12-13 19:31:44' AND e.DeviceLoginName='3134' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2023-12-12 22:31:44' AND g.time<='2023-12-13 17:31:44' AND g.DeviceLoginName='3134' GROUP BY  g.time, g.Distance;
CountAzimuth:3135