/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Alumnos::find(); $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; } $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'p_nombre', $this->p_nombre])->andFilterWhere(['like', 's_nombre', $this->s_nombre])->andFilterWhere(['like', 'p_apellido', $this->p_apellido])->andFilterWhere(['like', 's_apellido', $this->s_apellido])->andFilterWhere(['like', 'nacimiento', $this->nacimiento])->andFilterWhere(['like', 'rut', $this->rut])->andFilterWhere(['like', 'mail', $this->mail])->andFilterWhere(['like', 't_fijo', $this->t_fijo])->andFilterWhere(['like', 't_celular', $this->t_celular])->andFilterWhere(['like', 'direccion', $this->direccion])->andFilterWhere(['like', 'comuna', $this->comuna])->andFilterWhere(['like', 'servicio', $this->servicio])->andFilterWhere(['like', 'funcion', $this->funcion])->andFilterWhere(['like', 'horario', $this->horario]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Alumnos::find(); $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; } $query->andFilterWhere(['id_alumno' => $this->id_alumno, 'clase' => $this->clase, 'nota_final' => $this->nota_final]); $query->andFilterWhere(['like', 'nombre', $this->nombre])->andFilterWhere(['like', 'apellidos', $this->apellidos]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Alumnos::find(); $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; } $query->andFilterWhere(['idalumno' => $this->idalumno, 'apellido', $this->apellido, 'nombre', $this->nombre, 'cuil' => $this->cuil, 'fechanac' => $this->fechanac, 'idsexo' => $this->idsexo, 'idsalud' => $this->idsalud, 'nacion', $this->nacion, 'observaciones', $this->observaciones, 'discapacidad' => $this->discapacidad, 'originario' => $this->originario, 'grufam' => $this->grufam, 'idpropietario' => $this->idpropietario, 'idinstruccion' => $this->idinstruccion, 'idocupacion' => $this->idocupacion, 'montotal' => $this->montotal, 'becario' => $this->becario, 'idcarrera' => $this->idcarrera, 'anioingreso' => $this->anioingreso, 'anioingresou' => $this->anioingresou, 'asistencia' => $this->asistencia, 'promedio' => $this->promedio, 'idconvocatoria' => $this->idconvocatoria]); $query->andFilterWhere(['=', 'dni', $this->dni]); $dataProvider = new ActiveDataProvider(['query' => $query]); if ($this->dni != '') { return $dataProvider; } else { return true; } }
public function actionView() { $form = new FormSearch(); $search = null; if ($form->load(Yii::$app->request->get())) { if ($form->validate()) { $search = Html::encode($form->q); $table = Alumnos::find()->where(["like", "id_alumno", $search])->orWhere(["like", "nombre", $search])->orWhere(["like", "apellidos", $search]); $count = clone $table; $pages = new Pagination(["pageSize" => 5, "totalCount" => $count->count()]); $model = $table->offset($pages->offset)->limit($pages->limit)->all(); } else { $form->getErrors(); } } else { $table = Alumnos::find(); $count = clone $table; $pages = new Pagination(["pageSize" => 5, "totalCount" => $count->count()]); $model = $table->offset($pages->offset)->limit($pages->limit)->all(); } return $this->render("view", ["model" => $model, "form" => $form, "search" => $search, "pages" => $pages]); }
public function actionViewViejo() { $table = new Alumnos(); /* Metodo que me trae todos los registro de la tabla */ $model = $table->find()->all(); $form = new FormSearch(); /* Variable que contendra la busqueda */ $search = null; /* Si el formulario es envio por get*/ if ($form->load(Yii::$app->request->get())) { if ($form->validate()) { /* Metodo encode para evitar ataques del tipo xss */ $search = Html::encode($form->q); /* Consulta sql */ $query = "SELECT * FROM alumnos WHERE id_alumno LIKE '%{$search}%' OR "; $query .= "nombre LIKE '%{$search}%' OR apellidos LIKE '%{$search}%'"; /* Guardamos en la variable model los datos que nos traera la consulta */ $model = $table->findBySql($query)->all(); } else { $form->getErros(); } } return $this->render("view", ['model' => $model, "form" => $form, "search" => $search]); }
public function actionView() { $table = new Alumnos(); $model = $table->find()->orderBy('clase, note_final')->all(); $form = new FormSearch(); $search = null; if ($form->load(Yii::$app->request->get())) { if ($form->validate()) { $search = Html::encode($form->q); #$model = $table->find()->where('id_alumno LIKE :data OR nombre LIKE :data OR apellidos LIKE :data')->addParams([":data"=>"%".$search."%"])->all(); $table = Alumnos::find()->where(["like", "id_alumno", $search])->orWhere(["like", "nombre", $search])->orWhere(["like", "apellidos", $search]); // clonar el objeto $table una vez hecha la consulta // se crea la instancia para la paginacion $count = clone $table; $pages = new Pagination(["pageSize" => 2, "totalCount" => $count->count()]); $model = $table->offset($pages->offset)->limit($pages->limit)->all(); } else { $form->getErrors; } } else { $table = Alumnos::find(); $count = clone $table; $pages = new Pagination(["pageSize" => 2, "totalCount" => $count->count()]); $model = $table->offset($pages->offset)->limit($pages->limit)->all(); } return $this->render("view", ["model" => $model, "form" => $form, "search" => $search, "pages" => $pages]); }