/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = MetasCobertura::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'categoria' => $this->categoria, 'ano' => $this->ano, 'cobertura' => $this->cobertura]);
return $dataProvider;
}
<div class="col-md-3">
<table class="table table-bordered table-striped">
<tr>
<th>Año</th>
<th>Cobertura</th>
<th>Meta</th>
</tr>
<?php
for ($i = 0, $y = 2015; $y <= 2020; $y++, $i++) {
?>
<tr>
<td><?php
echo $y;
?>
</td>
<td><?php
echo $series_fazni[$i];
?>
</td>
<td><?php
echo \app\models\MetasCobertura::findOne(['categoria' => 3, 'ano' => $y])->cobertura;
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
/**
* Finds the MetasCobertura model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return MetasCobertura the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = MetasCobertura::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
