Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:25:28' AND e.date<='2024-10-21 23:25:28' AND e.DeviceLoginName='862531041080400' 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-20 21:25:28' AND g.time<='2024-10-21 20:25:28' AND g.DeviceLoginName='862531041080400' GROUP BY  g.time, g.Distance;
CountAzimuth:1488
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-23 0:57:52' AND e.date<='2024-10-23 23:57:52' AND e.DeviceLoginName='356078116305406' 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-22 21:57:52' AND g.time<='2024-10-23 20:57:52' AND g.DeviceLoginName='356078116305406' GROUP BY  g.time, g.Distance;
CountAzimuth:1426
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:57:40' AND e.date<='2024-10-21 23:57:40' 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-10-20 21:57:40' AND g.time<='2024-10-21 20:57:40' AND g.DeviceLoginName='3206' GROUP BY  g.time, g.Distance;
CountAzimuth:3149
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-14 0:57:40' AND e.date<='2024-10-14 23:57:40' 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-10-13 21:57:40' AND g.time<='2024-10-14 20:57:40' AND g.DeviceLoginName='3206' GROUP BY  g.time, g.Distance;
CountAzimuth:2912
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-24 7:59:43' AND e.date<='2024-10-24 14:59:43' AND e.DeviceLoginName='352353083458635' 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-24 04:59:43' AND g.time<='2024-10-24 11:59:43' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:751