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]]); ?>
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(); }