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>='2024-01-16 22:00:00' AND g.time<='2024-01-17 07:11:11' AND g.DeviceLoginName='9022'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 05:12:30' AND TIME<='2024-01-17 05:22:30' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 06:57:01' AND TIME<='2024-01-17 07:07:01' AND DeviceLoginName='9022' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='9022' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-16 22:00:00' AND e.date<='2024-01-17 07:11:11'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 05:10:30' AND TIME<='2024-01-17 05:20:30' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 05:12:30' AND TIME<='2024-01-17 05:22:30' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 05:16:30' AND TIME<='2024-01-17 05:26:30' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 05:18:20' AND TIME<='2024-01-17 05:28:20' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 05:27:50' AND TIME<='2024-01-17 05:37:50' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 06:45:31' AND TIME<='2024-01-17 06:55:31' AND DeviceLoginName='9022' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-17 06:57:01' AND TIME<='2024-01-17 07:07:01' AND DeviceLoginName='9022' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-15 0:21:59' AND e.date<='2024-01-15 23:21:59' AND e.DeviceLoginName='2461' 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>='2024-01-14 22:21:59' AND g.time<='2024-01-15 21:21:59' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:2054
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-05 17:34:13' AND e.date<='2024-01-09 10:34:13' AND e.DeviceLoginName='2461' 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>='2024-01-05 15:34:13' AND g.time<='2024-01-09 08:34:13' AND g.DeviceLoginName='2461' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-15 0:41:54' AND e.date<='2024-01-15 23:41:54' AND e.DeviceLoginName='356078111430829' 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>='2024-01-14 22:41:54' AND g.time<='2024-01-15 21:41:54' AND g.DeviceLoginName='356078111430829' GROUP BY  g.time, g.Distance;
CountAzimuth:697