/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Prova::find()->orderBy('horario_idhorario'); $query->joinWith(['disciplina']); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['disciplina'] = ['asc' => ['disciplina.nome' => SORT_ASC], 'desc' => ['disciplina.nome' => SORT_DESC]]; $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; } $vencidas = Notas::find()->from(['notas'])->where(['and', 'idcandidato = ' . $this->idcandidato, 'nota >= nota_minima'])->select('iddisciplina'); $query->andFilterWhere(['idprova' => $this->idprova, 'calendario_idcalendario' => $this->calendario_idcalendario, 'horario_idhorario' => $this->horario_idhorario, 'disciplina_iddisciplina' => $this->disciplina_iddisciplina, 'predio_idpredio' => $this->predio_idpredio, 'segunda_chamada' => $this->segunda_chamada])->andFilterWhere(['like', 'disciplina.name', $this->disciplina])->andFilterWhere(['not in', 'disciplina_iddisciplina', $vencidas]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getNotas() { return $this->hasMany(Notas::className(), ['idcandidato' => 'idcandidato']); }