Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-31 0:44:1' AND e.date<='2024-07-31 23:44:1' AND e.DeviceLoginName='8997' 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-07-30 21:44:01' AND g.time<='2024-07-31 20:44:01' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:45
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 15:9:36' AND e.date<='2024-07-16 18:9:36' AND e.DeviceLoginName='3206' 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-07-16 12:09:36' AND g.time<='2024-07-16 15:09:36' AND g.DeviceLoginName='3206' GROUP BY  g.time, g.Distance;
CountAzimuth:715
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-16 15:51:27' AND e.date<='2024-07-16 17:51:27' AND e.DeviceLoginName='3206' 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-07-16 12:51:27' AND g.time<='2024-07-16 14:51:27' AND g.DeviceLoginName='3206' GROUP BY  g.time, g.Distance;
CountAzimuth:540
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-29 0:21:11' AND e.date<='2024-08-02 14:21:11' AND e.DeviceLoginName='356078116302726' 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-07-28 21:21:11' AND g.time<='2024-08-02 11:21:11' AND g.DeviceLoginName='356078116302726' GROUP BY  g.time, g.Distance;
CountAzimuth:5733