/**
* Displays a single LocalizacionAccVariable model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
$model = $this->findModel($id);
$model1 = AccionCentralizadaVariableProgramacion::find()->where(['id_localizacion' => $model->id])->One();
$model2 = AccionCentralizadaVariables::find($model->id_variable)->One();
$request = Yii::$app->request;
if ($request->isAjax) {
Yii::$app->response->format = Response::FORMAT_JSON;
return ['title' => "Variable #" . $id, 'content' => $this->renderAjax('view', ['model' => $model, 'model1' => $model1]), 'footer' => Html::button('Cerrar', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::a('Editar', ['update', 'id' => $id, 'variable' => $model->id_variable, 'localizacion' => $model2->localizacion], ['class' => 'btn btn-primary', 'role' => 'modal-remote'])];
} else {
return $this->render('view', ['model' => $model, 'model1' => $model1]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = AccionCentralizadaVariables::find();
$query->joinWith(['unidadMedida']);
// 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, 'responsable' => $this->responsable, 'meta_programada_variable' => $this->meta_programada_variable, 'unidad_ejecutora' => $this->unidad_ejecutora, 'acc_accion_especifica' => $this->acc_accion_especifica]);
$query->andFilterWhere(['like', 'nombre_variable', $this->nombre_variable])->andFilterWhere(['like', 'definicion', $this->definicion])->andFilterWhere(['like', 'base_calculo', $this->base_calculo])->andFilterWhere(['like', 'unidad_medida.unidad_medida', $this->unidad_medida])->andFilterWhere(['like', 'fuente_informacion', $this->fuente_informacion]);
return $dataProvider;
}
public function VariablesAsignadas()
{
$ace = AccionCentralizadaVariables::find()->select(["accion_centralizada_variables.nombre_variable as nombre", "accion_centralizada_variables.id", "accion_centralizada_variables.localizacion as localizacion", "localizacion_acc_variable.id id_localizacion"])->innerjoin('accion_centralizada_variables_usuarios', 'accion_centralizada_variables_usuarios.id_variable=accion_centralizada_variables.id')->innerjoin('localizacion_acc_variable', 'localizacion_acc_variable.id_variable=accion_centralizada_variables.id')->where(['accion_centralizada_variables_usuarios.id_usuario' => Yii::$app->user->getId()])->asArray()->all();
$provider = new ArrayDataProvider(['allModels' => $ace, 'sort' => ['attributes' => ['nombre']], 'pagination' => ['pageSize' => 10]]);
return $provider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getIdVariable()
{
return $this->hasOne(AccionCentralizadaVariables::className(), ['id' => 'id_variable']);
}
/**
* Finds the AccionCentralizadaVariables model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return AccionCentralizadaVariables the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = AccionCentralizadaVariables::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}