Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-11 7:59:35' AND e.date<='2024-12-11 23:59:35' 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>='2024-12-11 05:59:35' AND g.time<='2024-12-11 21:59:35' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1152
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-12 1:2:13' AND e.date<='2024-12-12 8:2:13' AND e.DeviceLoginName='354836080167561' 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-12-11 23:02:13' AND g.time<='2024-12-12 06:02:13' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:216
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-12-11 22:00:00' AND g.time<='2024-12-12 08:47:40' AND g.DeviceLoginName='2906'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:07:01' AND TIME<='2024-12-12 07:17:01' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:18:46' AND TIME<='2024-12-12 07:28:46' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:51:16' AND TIME<='2024-12-12 08:01:16' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 08:12:31' AND TIME<='2024-12-12 08:22:31' AND DeviceLoginName='2906' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-11 22:00:00' AND e.date<='2024-12-12 08:47:40'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:07:01' AND TIME<='2024-12-12 07:17:01' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:32:31' AND TIME<='2024-12-12 07:42:31' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:42:41' AND TIME<='2024-12-12 07:52:41' AND DeviceLoginName='2906' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-11 0:46:44' AND e.date<='2024-12-11 23:46:44' AND e.DeviceLoginName='2906' 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-12-10 22:46:44' AND g.time<='2024-12-11 21:46:44' AND g.DeviceLoginName='2906' GROUP BY  g.time, g.Distance;
CountAzimuth:322
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-12-11 22:00:00' AND g.time<='2024-12-12 08:49:39' AND g.DeviceLoginName='2906'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:07:01' AND TIME<='2024-12-12 07:17:01' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:18:46' AND TIME<='2024-12-12 07:28:46' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:51:16' AND TIME<='2024-12-12 08:01:16' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 08:12:31' AND TIME<='2024-12-12 08:22:31' AND DeviceLoginName='2906' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-11 22:00:00' AND e.date<='2024-12-12 08:49:39'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:07:01' AND TIME<='2024-12-12 07:17:01' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:32:31' AND TIME<='2024-12-12 07:42:31' AND DeviceLoginName='2906' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-12 07:42:41' AND TIME<='2024-12-12 07:52:41' AND DeviceLoginName='2906' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:20:51' AND e.date<='2024-12-06 12:20:51' AND e.DeviceLoginName='356078111430936' 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-12-01 22:20:51' AND g.time<='2024-12-06 10:20:51' AND g.DeviceLoginName='356078111430936' GROUP BY  g.time, g.Distance;
CountAzimuth:3460
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-12 2:25:36' AND e.date<='2024-12-12 13:25:36' 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>='2024-12-12 00:25:36' AND g.time<='2024-12-12 11:25:36' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0