public function getTireSensorHistoricalData($partsIds, $dateIni, $dateEnd)
 {
     $this->getFleetTireAndSensorParts($partsData, null, $partsIds);
     $tireSensor = TireSensor::select('part_id', 'temperature', 'pressure', 'created_at')->whereIn('part_id', $partsIds);
     if (!empty($dateIni) && $dateIni != '-') {
         $tireSensor = $tireSensor->where('created_at', '>=', $dateIni);
     }
     if (!empty($dateEnd) && $dateEnd != '-') {
         $tireSensor = $tireSensor->where('created_at', '<=', $dateEnd);
     }
     $tireSensor = $tireSensor->get();
     $historicalDataPos = $this->setHistoricalDataPositions($partsData);
     if (!empty($tireSensor)) {
         foreach ($tireSensor as $data) {
             $historicalDataPos[$partsData[$data->part_id]['position']][] = $data;
         }
     }
     return $this->getHistoricalData($historicalDataPos);
 }
 protected function getTiresWarningAndDanger($sensorsIds)
 {
     //         $sensors = \DB::select('part_id', \DB::raw('AVG(temperature) as avg_temperature'))
     //             ->from(
     //                 TireSensor::select('part_id', 'temperature')
     //                 ) as 't'
     //             ->groupBy('part_id')
     //             ->get();
     $sensorsReturn = [];
     $warningPressure = (int) config('app.tires_warning_pressure_percentage') * (int) config('app.tires_ideal_pressure') / 100;
     $sensorsReturn['warningMinPressure'] = (int) config('app.tires_ideal_pressure') - $warningPressure;
     $sensorsReturn['warningMaxPressure'] = (int) config('app.tires_ideal_pressure') + $warningPressure;
     $dangerPressure = (int) config('app.tires_danger_pressure_percentage') * (int) config('app.tires_ideal_pressure') / 100;
     $sensorsReturn['dangerMinPressure'] = (int) config('app.tires_ideal_pressure') - $dangerPressure;
     $sensorsReturn['dangerMaxPressure'] = (int) config('app.tires_ideal_pressure') + $dangerPressure;
     //         $sensors = \DB::select(\DB::raw('
     //             select part_id, avg(temperature) as avg_temperature, avg(pressure) as avg_pressure
     //             from (
     //                 select part_id, temperature, pressure
     //                 from tire_sensor
     //                 where (
     //                     select count(*) from tire_sensor as p
     //                     where p.part_id = tire_sensor.part_id and p.created_at >= tire_sensor.created_at
     //                     and p.part_id in ('.implode(',',$parts).')
     //                     ) <= 3
     //             ) as t
     //             group by part_id'));
     $sensors = TireSensor::select('part_id', 'temperature as avg_temperature', 'pressure as avg_pressure')->whereIn('tire_sensor.id', $sensorsIds)->get();
     if (!empty($sensors)) {
         foreach ($sensors as $sensor) {
             $sensorsReturn['parts'][$sensor->part_id] = $sensor;
         }
     }
     return $sensorsReturn;
 }