Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-09 13:9:13' AND e.date<='2024-03-10 13:9:13' AND e.DeviceLoginName='2652' 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-03-09 11:09:13' AND g.time<='2024-03-10 11:09:13' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:805
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-14 0:36:54' AND e.date<='2024-03-14 23:36:54' AND e.DeviceLoginName='9378' 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-03-13 22:36:54' AND g.time<='2024-03-14 21:36:54' AND g.DeviceLoginName='9378' GROUP BY  g.time, g.Distance;
CountAzimuth:2271
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-13 14:33:54' AND e.date<='2024-03-14 14:33:54' AND e.DeviceLoginName='2923' 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-03-13 12:33:54' AND g.time<='2024-03-14 12:33:54' AND g.DeviceLoginName='2923' GROUP BY  g.time, g.Distance;
CountAzimuth:1768
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-11 0:33:54' AND e.date<='2024-03-11 14:33:54' AND e.DeviceLoginName='2923' 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-03-10 22:33:54' AND g.time<='2024-03-11 12:33:54' AND g.DeviceLoginName='2923' GROUP BY  g.time, g.Distance;
CountAzimuth:2162