protected function findModelItem($id)
{
if (($model = ItemProgramacao::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = ItemProgramacao::find()->where(['evento_idevento' => $params['idevento']]);
$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(['iditemProgramacao' => $this->iditemProgramacao, 'hora' => $this->hora, 'vagas' => $this->vagas, 'cargaHoraria' => $this->cargaHoraria, 'local_idlocal' => $this->local_idlocal, 'evento_idevento' => $this->evento_idevento, 'tipo_idtipo' => $this->tipo_idtipo]);
$query->andFilterWhere(['like', 'titulo', $this->titulo])->andFilterWhere(['like', 'descricao', $this->descricao])->andFilterWhere(['like', 'data', $this->data])->andFilterWhere(['like', 'detalhe', $this->detalhe])->andFilterWhere(['like', 'notificacao', $this->notificacao]);
return $dataProvider;
}
/**
* Finds the ItemProgramacao model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return ItemProgramacao the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = ItemProgramacao::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('A página solicitada não existe.');
}
}
public function getListaItem($id_evento)
{
$model = ItemProgramacao::find()->select(['evento.sigla', 'itemProgramacao.iditemProgramacao', 'itemProgramacao.titulo', 'itemProgramacao.descricao'])->leftJoin("evento", "evento.idevento = itemProgramacao.evento_idevento")->where('evento_idevento = "' . $id_evento . '"')->all();
return $model;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getItemProgramacaoIditemProgramacaos()
{
return $this->hasMany(ItemProgramacao::className(), ['iditemProgramacao' => 'itemProgramacao_iditemProgramacao'])->viaTable('itemProgramacao_has_pacote', ['pacote_idpacote' => 'idpacote']);
}
public function getItemProgramacao()
{
return $this->hasMany(ItemProgramacao::className(), ['evento_idevento' => 'idevento']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getItemProgramacaos()
{
return $this->hasMany(ItemProgramacao::className(), ['tipo_idtipo' => 'idtipo']);
}
public function getItemProgramacao()
{
return $this->hasOne(ItemProgramacao::className(), ['iditemProgramacao' => 'itemProgramacao_iditemProgramacao']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getItemProgramacao()
{
return $this->hasMany(ItemProgramacao::className(), ['palestrante_idPalestrante' => 'idPalestrante']);
}
public function possuiItemProgramacao()
{
$id_evento = Yii::$app->request->post('evento_idevento');
$results = ItemProgramacao::find()->where(['evento_idevento' => $id_evento])->count();
return $results;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getItemProgramacaos()
{
return $this->hasMany(ItemProgramacao::className(), ['local_idlocal' => 'idlocal']);
}
