public static function findAllForDropDownList() { $models = Provincias::find()->orderBy('nombre_provincia')->all(); $listData = []; foreach ($models as $model) { if (intval($model->id)) { $listData[$model->id] = $model->nombre_provincia; } } return $listData; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Provincias::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]); $query->andFilterWhere(['like', 'nombre_provincia', $this->nombre_provincia]); return $dataProvider; }
/** * Creates a new Clientes model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Clientes(); $model->setScenario('register'); $post = Yii::$app->request->post(); $formName = basename($model->className()); if ($model->load($post)) { // Default value $model->role = isset($post[$formName]['role']) ? $post[$formName]['role'] : 20; $model->fecha_conexion = isset($post[$formName]['fecha_conexion']) ? $post[$formName]['fecha_conexion'] : Yii::$app->fn->GetDate('none'); $model->fecha_modif = isset($post[$formName]['fecha_modif']) ? $post[$formName]['fecha_modif'] : Yii::$app->fn->GetDate('none'); $model->fecha_registro = isset($post[$formName]['fecha_registro']) ? $post[$formName]['fecha_registro'] : Yii::$app->fn->GetDate(); $model->id_estado = isset($post[$formName]['id_estado']) ? $post[$formName]['id_estado'] : 1; // VALIDATE: Provincia if (!empty($model->id_provincia)) { $nombre_provincia = Provincias::findOne(['id' => $model->id_provincia])->nombre_provincia; } if (empty($model->id_provincia) && empty($model->provincia)) { $model->addError($model->provincia, 'Please fill the provincia field.'); } elseif (!empty($model->id_provincia) && !empty($model->provincia) && $nombre_provincia != $model->provincia) { $model->addError($model->id_provincia, 'Please select provincia from the list or fill manually your provincia.'); } elseif (!empty($model->id_provincia)) { $model->provincia = $nombre_provincia; } else { $model->id_provincia = null; } if (!count($model->errors) && $model->validate()) { $model->setPassword(); $model->generateAuthKey(); if ($model->save()) { return $this->redirect(['view', 'id' => $model->id]); } } } // Load empty/error form return $this->render('create', ['model' => $model]); }
/** * @return \yii\db\ActiveQuery */ public function getIdProvincia() { return $this->hasOne(Provincias::className(), ['id' => 'id_provincia']); }
?> <?php echo $form->field($model, 'dni')->textInput(); ?> <?php echo $form->field($model, 'fecha_nacimiento')->widget(DatePicker::className(), ['dateFormat' => 'yyyy-MM-dd', 'clientOptions' => ['yearRange' => '-115:+0', 'changeYear' => true]]); ?> <?php echo $form->field($model, 'domicilio')->textInput(['maxlength' => true]); ?> <?php $provincia = ArrayHelper::map(Provincias::find()->all(), 'provincia_id', 'provincia'); echo $form->field($model, 'provincia_id')->dropDownList($provincia, ['prompt' => 'Por favor elija una', 'onchange' => ' $.get( "' . Url::toRoute('dependent-dropdown/departamento') . '", { id: $(this).val() } ) .done(function( data ) { $( "#' . Html::getInputId($model, 'departamento_id') . '" ).html( data ); } ); ']); ?> <?php echo $form->field($model, 'departamento_id')->dropDownList(array(), ['prompt' => 'Por favor elija uno', 'onchange' => ' $.get( "' . Url::toRoute('dependent-dropdown/localidad') . '", { id: $(this).val() } ) .done(function( data ) { $( "#' . Html::getInputId($model, 'localidad_id') . '" ).html( data ); }
?> <?php echo $form->field($model, 'codigo_postal')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'zoom')->textInput(); ?> <?php echo $form->field($model, 'radius')->textInput(); ?> <?php $items = yii\helpers\ArrayHelper::map(\app\models\Provincias::find()->all(), 'id', 'nombre'); echo $form->field($model, 'provincia_id')->dropDownList($items, ['prompt' => 'seleccione Provincia']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> <?php ActiveForm::end(); ?> </div>
public function getProvincia() { return Provincias::findOne(['id' => $this->id_provincia])->nombre_provincia; }
/** * Finds the Provincias model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Provincias the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Provincias::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
?> <?php echo $form->field($model, 'direccion')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'numero_oficina')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'ciudad')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'id_provincia')->dropdownList(Provincias::findAllForDropDownList(), ['prompt' => '--- Otras ---']); ?> <?php echo $form->field($model, 'provincia')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'id_pais')->dropdownList(Paises::findAllForDropDownList(), ['prompt' => '--- Select Status ---']); ?> <?php echo $form->field($model, 'codigo_postal')->textInput(['maxlength' => true]); ?> <?php