public function actionIndex2($id)
{
$searchModel = new FaerSearch();
$dataProvider = $searchModel->searchfixed($id);
//$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$comite = Comite::findOne(['id' => $id]);
return $this->render('index2', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'comite' => $comite]);
}
public function actionSinAprobar($id)
{
$comite = Comite::findOne(['id' => $id]);
$proyectos = Faer::find()->where(['categoria' => $comite->tipo]);
if (strtoupper($comite->getSubtipo0()->one()->nombre) != "GENERAL") {
$proyectos = $proyectos->andWhere(['subcategoria' => $comite->subtipo]);
}
$proyectos = $proyectos->all();
$html = $this->renderAjax('_por_aprobar', ['proyectos' => $proyectos]);
return Json::encode($html);
}
public function searchfixed($id)
{
$comite = Comite::findOne(['id' => $id]);
$proyectos_ya_asignados = ArrayHelper::getColumn(ProyectosComite::find()->asArray()->all(), 'proyecto', false);
$query = Faer::find()->where(['categoria' => $comite->tipo]);
if (!empty($proyectos_ya_asignados)) {
$query = $query->andWhere(['not in', 'numero', $proyectos_ya_asignados]);
}
if (strtoupper($comite->getSubtipo0()->one()->nombre) != "GENERAL") {
$query = $query->andWhere(['subcategoria' => $comite->subtipo]);
}
$dataProvider = new ActiveDataProvider(['query' => $query]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Comite::find();
//var_dump($params); die();
// 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, 'tipo' => $this->tipo, 'fecha_inicio' => $this->fecha_inicio, 'fecha_fin' => $this->fecha_fin, 'subtipo' => $this->subtipo, 'convocatoria' => $this->convocatoria]);
$query->andFilterWhere(['like', 'descripcion', $this->descripcion])->andFilterWhere(['like', 'nombre', $this->nombre])->andFilterWhere(['like', 'observaciones', $this->observaciones]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getIdComite()
{
return $this->hasOne(Comite::className(), ['id' => 'id_comite']);
}
/**
* @inheritdoc
*/
public function rules()
{
return [[['proyecto', 'comite'], 'integer'], [['fecha_aprobacion'], 'safe'], [['acta_aprobacion', 'usuario_aprobo'], 'string', 'max' => 255], [['comite'], 'exist', 'skipOnError' => true, 'targetClass' => Comite::className(), 'targetAttribute' => ['comite' => 'id']], [['proyecto'], 'exist', 'skipOnError' => true, 'targetClass' => Faer::className(), 'targetAttribute' => ['proyecto' => 'numero']]];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getComites()
{
return $this->hasMany(Comite::className(), ['subtipo' => 'id']);
}
/**
* Finds the Comite model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Comite the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Comite::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/* @var $model app\models\FaerSearch */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Búsqueda</h3>
</div>
<div class="panel-body faer-search">
<?php
echo Html::beginForm(Url::to(['index3']));
?>
<div class="row">
<div class="col-lg-4">
<?php
echo Html::dropDownList('comite', null, ArrayHelper::map(Comite::find()->all(), 'id', 'nombre'), ['prompt' => 'Cualquier comité', 'class' => 'form-control']);
?>
</div>
<div class="form-group pull-right">
<?php
echo Html::submitButton(Yii::t('app', 'Buscar'), ['class' => 'btn btn-primary btn-xs']);
?>
<?php
echo Html::resetButton(Yii::t('app', 'Restablecer'), ['class' => 'btn btn-default btn-xs']);
?>
</div>
<?php
echo Html::endForm();
