/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Avaliacao::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, 'id_item' => $this->id_item, 'id_avaliado' => $this->id_avaliado]); $query->andFilterWhere(['like', 'importancia', $this->importancia])->andFilterWhere(['like', 'satisfacao', $this->satisfacao])->andFilterWhere(['like', 'descricao', $this->descricao]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getAvaliacaos() { return $this->hasMany(Avaliacao::className(), ['id_avaliado' => 'id']); }
public function actionAvaliar($turma = null) { if (empty($turma)) { $turma = new Turma(); return $this->render('turma', ['turma' => $turma]); } else { $avaliacao = new Avaliacao(); $turma = Turma::findOne(['id' => $turma]); $itens = Item::find()->all(); if (Yii::$app->request->post()) { $avaliacao = Yii::$app->request->post('Avaliacao'); $ok = true; foreach ($avaliacao as $a) { $av = new Avaliacao(); $av->id_item = $a['id_item']; $av->id_turma = $a['id_turma']; $av->id_avaliado = $a['id_avaliado']; $av->importancia = $a['importancia']; $av->satisfacao = $a['satisfacao']; $av->descricao = $a['descricao']; if (!$av->save()) { return new HttpException(500, 'Houve um erro ao salvar a sua avaliação :\'('); } } return $this->render('obrigado'); } elseif ($turma) { return $this->render('avaliar', ['itens' => $itens, 'turma' => $turma]); } else { throw new HttpException(404, 'Turma Inválida :/'); } } }