Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-20 15:57:11' AND e.date<='2023-12-20 7:57:11' AND e.DeviceLoginName='352353083458635' 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-20 13:57:11' AND g.time<='2023-12-20 05:57:11' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 14:57:33' AND e.date<='2023-12-19 23:57:33' AND e.DeviceLoginName='352353083458635' 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 12:57:33' AND g.time<='2023-12-19 21:57:33' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:545
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 7:59:4' AND e.date<='2023-12-19 23:59:4' AND e.DeviceLoginName='2473' 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 05:59:04' AND g.time<='2023-12-19 21:59:04' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1854
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2023-12-19 22:00:00' AND g.time<='2023-12-20 07:17:03' AND g.DeviceLoginName='2882'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2882' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-19 22:00:00' AND e.date<='2023-12-20 07:17:03'
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2023-12-19 0:20:2' AND e.date<='2023-12-20 10:20:2' AND e.DeviceLoginName='356078116288057' 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-18 22:20:02' AND g.time<='2023-12-20 08:20:02' AND g.DeviceLoginName='356078116288057' GROUP BY  g.time, g.Distance;
CountAzimuth:2241