Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-02 0:3:23' AND e.date<='2023-12-02 23:3:23' AND e.DeviceLoginName='356078116287687' 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-01 22:03:23' AND g.time<='2023-12-02 21:03:23' AND g.DeviceLoginName='356078116287687' GROUP BY  g.time, g.Distance;
CountAzimuth:2650
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-09 10:20:0' AND e.date<='2024-01-10 10:20:0' AND e.DeviceLoginName='4844' 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>='2024-01-09 08:20:00' AND g.time<='2024-01-10 08:20:00' AND g.DeviceLoginName='4844' GROUP BY  g.time, g.Distance;
CountAzimuth:1616
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-02 0:20:0' AND e.date<='2024-01-02 23:20:0' AND e.DeviceLoginName='4844' 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>='2024-01-01 22:20:00' AND g.time<='2024-01-02 21:20:00' AND g.DeviceLoginName='4844' GROUP BY  g.time, g.Distance;
CountAzimuth:483
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-03 0:20:0' AND e.date<='2024-01-03 23:20:0' AND e.DeviceLoginName='4844' 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>='2024-01-02 22:20:00' AND g.time<='2024-01-03 21:20:00' AND g.DeviceLoginName='4844' GROUP BY  g.time, g.Distance;
CountAzimuth:516
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-04 0:20:0' AND e.date<='2024-01-04 23:20:0' AND e.DeviceLoginName='4844' 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>='2024-01-03 22:20:00' AND g.time<='2024-01-04 21:20:00' AND g.DeviceLoginName='4844' GROUP BY  g.time, g.Distance;
CountAzimuth:8