public function excel($params)
{
$query = Procedencia::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => array('pageSize' => 10000)]);
$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', 'descripcion', $this->descripcion]);
return $dataProvider;
}
use yii\web\Response;
use yii\helpers\Url;
use kartik\select2\Select2;
/* @var $this yii\web\View */
/* @var $model app\models\RceExamen */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="rce-examen-form">
<?php
$form = ActiveForm::begin(['id' => 'dynamic-form']);
?>
<?php
echo $form->field($model, 'procedencia_id')->dropDownList(ArrayHelper::map(Procedencia::find()->all(), 'id', 'descripcion'), ['prompt' => 'Seleccionar Procedencia', 'style' => 'width:300px']);
?>
<?php
$rces = RceExamen::find('reserva_id')->all();
$ids = [];
foreach ($rces as $i => $rce) {
$ids[$i] = $rce->reserva_id;
}
$data = ArrayHelper::map(Reserva::find()->where(['not in', 'id', $ids])->all(), 'id', 'ReservaSelect');
?>
<?php
echo $form->field($model, "reserva_id")->widget(Select2::classname(), ['data' => $data, 'options' => ['placeholder' => 'Seleccionar Reserva...', 'id' => 'reservaId'], 'pluginOptions' => ['width' => '300px', 'disabled' => !$model->isNewRecord]]);
?>
/**
* Finds the Procedencia model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Procedencia the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Procedencia::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function getDatosRce()
{
$procedencia = Procedencia::find()->where(['id' => $this->procedencia_id])->one();
$reserva = Reserva::find()->where(['id' => $this->reserva_id])->one();
return $procedencia->descripcion . ' ' . $reserva->getReservaSelect();
}
