Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 0:6:21' AND e.date<='2023-12-23 23:6:21' AND e.DeviceLoginName='2526' 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-19 22:06:21' AND g.time<='2023-12-23 21:06:21' AND g.DeviceLoginName='2526' GROUP BY  g.time, g.Distance;
CountAzimuth:4945
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-22 23:0:0' AND e.date<='2023-12-23 5:0:0' AND e.DeviceLoginName='4861' 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-22 21:00:00' AND g.time<='2023-12-23 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:92
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 15:45:8' AND e.date<='2023-12-26 15:45:8' AND e.DeviceLoginName='4865' 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-25 13:45:08' AND g.time<='2023-12-26 13:45:08' AND g.DeviceLoginName='4865' GROUP BY  g.time, g.Distance;
CountAzimuth:2647
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-25 4:4:7' AND e.date<='2023-12-25 23:4:7' AND e.DeviceLoginName='2726' 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-25 02:04:07' AND g.time<='2023-12-25 21:04:07' AND g.DeviceLoginName='2726' GROUP BY  g.time, g.Distance;
CountAzimuth:207
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-24 4:4:7' AND e.date<='2023-12-24 23:4:7' AND e.DeviceLoginName='2726' 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-24 02:04:07' AND g.time<='2023-12-24 21:04:07' AND g.DeviceLoginName='2726' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-23 4:4:7' AND e.date<='2023-12-23 23:4:7' AND e.DeviceLoginName='2726' 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-23 02:04:07' AND g.time<='2023-12-23 21:04:07' AND g.DeviceLoginName='2726' GROUP BY  g.time, g.Distance;
CountAzimuth:231
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 15:4:7' AND e.date<='2023-12-19 23:4:7' AND e.DeviceLoginName='2726' 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-19 13:04:07' AND g.time<='2023-12-19 21:04:07' AND g.DeviceLoginName='2726' GROUP BY  g.time, g.Distance;
CountAzimuth:654