Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-22 0:58:31' AND e.date<='2024-04-22 23:58:31' AND e.DeviceLoginName='4884' 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-04-21 21:58:31' AND g.time<='2024-04-22 20:58:31' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:308
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-26 0:51:50' AND e.date<='2024-02-26 23:51:50' AND e.DeviceLoginName='5132' 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-02-25 21:51:50' AND g.time<='2024-02-26 20:51:50' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:1512
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:51:50' AND e.date<='2024-02-27 23:51:50' AND e.DeviceLoginName='5132' 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-02-26 21:51:50' AND g.time<='2024-02-27 20:51:50' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:1590
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-02-27 0:12:12' AND e.date<='2024-02-27 23:12:12' AND e.DeviceLoginName='5132' 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-02-26 21:12:12' AND g.time<='2024-02-27 20:12:12' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:1590
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 0:12:12' AND e.date<='2024-03-07 23:12:12' AND e.DeviceLoginName='5132' 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-03-06 21:12:12' AND g.time<='2024-03-07 20:12:12' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:1730
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 0:12:12' AND e.date<='2024-03-21 23:12:12' AND e.DeviceLoginName='5132' 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-03-20 21:12:12' AND g.time<='2024-03-21 20:12:12' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:2059
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-25 0:12:12' AND e.date<='2024-03-25 23:12:12' AND e.DeviceLoginName='5132' 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-03-24 21:12:12' AND g.time<='2024-03-25 20:12:12' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:2428
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-26 0:12:12' AND e.date<='2024-03-26 23:12:12' AND e.DeviceLoginName='5132' 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-03-25 21:12:12' AND g.time<='2024-03-26 20:12:12' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:2423
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-29 0:12:12' AND e.date<='2024-03-29 23:12:12' AND e.DeviceLoginName='5132' 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-03-28 21:12:12' AND g.time<='2024-03-29 20:12:12' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:2504