Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-04-24 21:00:00' AND g.time<='2024-04-25 05:13:36' AND g.DeviceLoginName='3044'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 22:35:51' AND TIME<='2024-04-24 22:45:51' AND DeviceLoginName='3044' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 22:43:56' AND TIME<='2024-04-24 22:53:56' AND DeviceLoginName='3044' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-25 05:02:46' AND TIME<='2024-04-25 05:12:46' AND DeviceLoginName='3044' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-24 21:00:00' AND e.date<='2024-04-25 05:13:36'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 22:35:51' AND TIME<='2024-04-24 22:45:51' AND DeviceLoginName='3044' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 22:40:46' AND TIME<='2024-04-24 22:50:46' AND DeviceLoginName='3044' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-24 22:43:56' AND TIME<='2024-04-24 22:53:56' AND DeviceLoginName='3044' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-04-25 05:02:46' AND TIME<='2024-04-25 05:12:46' AND DeviceLoginName='3044' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 0:49:44' AND e.date<='2024-04-19 23:49:44' AND e.DeviceLoginName='3030' 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-14 21:49:44' AND g.time<='2024-04-19 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:3193
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-15 0:49:44' AND e.date<='2024-04-15 23:49:44' AND e.DeviceLoginName='3030' 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-14 21:49:44' AND g.time<='2024-04-15 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:1904
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-16 0:49:44' AND e.date<='2024-04-16 23:49:44' AND e.DeviceLoginName='3030' 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-15 21:49:44' AND g.time<='2024-04-16 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-17 0:49:44' AND e.date<='2024-04-17 23:49:44' AND e.DeviceLoginName='3030' 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-16 21:49:44' AND g.time<='2024-04-17 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-18 0:49:44' AND e.date<='2024-04-18 23:49:44' AND e.DeviceLoginName='3030' 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-17 21:49:44' AND g.time<='2024-04-18 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-19 0:49:44' AND e.date<='2024-04-19 23:49:44' AND e.DeviceLoginName='3030' 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-18 21:49:44' AND g.time<='2024-04-19 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:1289
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-22 0:49:44' AND e.date<='2024-04-22 23:49:44' AND e.DeviceLoginName='3030' 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:49:44' AND g.time<='2024-04-22 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:2275
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-23 0:49:44' AND e.date<='2024-04-23 23:49:44' AND e.DeviceLoginName='3030' 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-22 21:49:44' AND g.time<='2024-04-23 20:49:44' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:2260