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
