public function listarPorEstado($estadoId) { $estado = Estado::find($estadoId); if (is_null($estado)) { App::abort(404); } $municipios = Municipio::orderBy('nombre')->where('estado_id', '=', $estadoId)->get(); return $municipios; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Estado::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(['idEstado' => $this->idEstado]); $query->andFilterWhere(['like', 'nombre', $this->nombre]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Estado::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, 'usuariocrea' => $this->usuariocrea, 'fechacrea' => $this->fechacrea, 'usuariomodifica' => $this->usuariomodifica, 'fechamodifica' => $this->fechamodifica]); $query->andFilterWhere(['like', 'estado', $this->estado]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getEstado() { return $this->hasOne(Estado::className(), ['id' => 'estado_id']); }
public function ubicacion() { $estados = Estado::all(); $data = RepositorieLocal::datosUbicacion(); return view('admin.ubicacion', compact('estados', 'data')); }
/** * Finds the Estado model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Estado the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Estado::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return \yii\db\ActiveQuery */ public function getEstado() { return $this->hasOne(Estado::className(), ['esta_codigo' => 'esta_codigo']); }
<?php echo $form->field($model, 'alun_data_nascimento')->widget(DatePicker::classname(), ['options' => ['placeholder' => 'Selecione uma data ...'], 'pluginOptions' => ['autoclose' => true, 'format' => 'dd/mm/yyyy']]); ?> <?php echo $form->field($model, 'alun_habilitado')->checkbox(); ?> <?php echo $form->field($model, 'alun_observacao')->textarea(['rows' => 6]); ?> <?php $rows = \app\models\Estado::find()->all(); $estado = \yii\helpers\ArrayHelper::map($rows, 'esta_codigo', 'esta_nome'); echo $form->field($model, 'esta_codigo')->dropDownList($estado, ['prompt' => 'Selecione um estado', 'onchange' => ' $.get( "' . Url::toRoute('/aluno/municipio') . '", { id: $(this).val() } ) .done(function( data ) { $( "#' . Html::getInputId($model, 'muni_codigo') . '" ).html( data ); } ); ']); ?> <?php echo $form->field($model, 'muni_codigo')->dropDownList(['prompt' => 'Selecione um estado']); ?> <div class="form-group">
<?php echo $form->field($model, 'publicar_id')->widget(SwitchInput::classname(), ['pluginOptions' => ['onText' => 'Si', 'offText' => 'No'], 'inlineLabel' => false]); ?> </div> </div> <?php echo Html::hiddenInput('fechaIngreso', $model->fechaIngreso); echo Html::hiddenInput('ingreso_id', $model->ingreso_id); $dataForma = ArrayHelper::map(\app\models\FormaIngreso::find()->asArray()->all(), 'id', 'nombre'); echo Form::widget(['model' => $model, 'form' => $form, 'columns' => 6, 'attributes' => ['nroA' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Número A..', 'addon' => ['append' => ['content' => '.00']]]], 'nroB' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Número B..']], 'nroC' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Número C..']], 'nroD' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Número D..']], 'descEpoca' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Epoca...']], 'codformaing' => ['type' => Form::INPUT_WIDGET, 'label' => 'Tipo de Ingreso', 'widgetClass' => '\\kartik\\widgets\\Select2', 'options' => ['data' => $dataForma]]]]); $dataCopia = ArrayHelper::map(\app\models\Copia::find()->asArray()->all(), 'id', 'nombre'); $dataEstado = ArrayHelper::map(\app\models\Estado::find()->asArray()->all(), 'id', 'nombre'); $dataTipo = ArrayHelper::map(\app\models\TipoAcervo::find()->asArray()->all(), 'id', 'descripcion'); echo Form::widget(['model' => $model, 'form' => $form, 'columns' => 6, 'attributes' => ['tipoAcervo_id' => ['type' => Form::INPUT_WIDGET, 'label' => 'Tipo de Acervo', 'widgetClass' => '\\kartik\\widgets\\Select2', 'options' => ['data' => $dataTipo]], 'copia_id' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\widgets\\Select2', 'options' => ['data' => $dataCopia]], 'estado_id' => ['type' => Form::INPUT_WIDGET, 'label' => 'Estado', 'widgetClass' => '\\kartik\\widgets\\Select2', 'options' => ['data' => $dataEstado]], 'material' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Material...']], 'forma' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Forma...']], 'color' => ['type' => Form::INPUT_TEXT, 'options' => ['placeholder' => 'Color...']]]]); $dataUbicacion = ArrayHelper::map(\app\models\Ubicacion::find()->asArray()->all(), 'id', 'nombre'); echo Form::widget(['model' => $model, 'form' => $form, 'columns' => 3, 'attributes' => ['ubicacion_id' => ['type' => Form::INPUT_WIDGET, 'label' => 'Ubicación', 'widgetClass' => '\\kartik\\widgets\\Select2', 'options' => ['data' => $dataUbicacion]], 'descUbicacion' => ['type' => Form::INPUT_TEXT, 'label' => 'Más detalles ubicación', 'options' => ['placeholder' => 'Más detalles...']], 'lugarprocac' => ['type' => Form::INPUT_TEXT, 'label' => 'Lugar de Procedencia', 'options' => ['placeholder' => 'Lugar de procedencia...']]]]); ?> <div class="row"> <div class="col-sm-6"> <?php echo $form->field($model, 'TemaIds')->widget(Select2::classname(), ['data' => $model->dropTema, 'options' => ['multiple' => true]]); ?> </div> <div class="col-sm-6"> <?php echo $form->field($model, 'ColeccionIds')->widget(Select2::classname(), ['data' => $model->dropColeccion, 'options' => ['multiple' => true]]);
/* @var $form yii\widgets\ActiveForm */ ?> <div class="municipio-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'muni_nome')->textInput(['maxlength' => true]); ?> <?php // DropdownList $rows = Estado::find()->all(); $data = ArrayHelper::map($rows, 'esta_codigo', 'esta_nome'); echo $form->field($model, 'esta_codigo')->dropDownList($data, ['prompt' => 'Selecione um estado']); ?> <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>
<p> <?php echo Html::a('Create Aluno', ['create'], ['class' => 'btn btn-success']); ?> </p> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'alun_codigo', 'alun_nome', 'alun_matricula', 'alun_data_nascimento', 'alun_habilitado:boolean', ['class' => 'yii\\grid\\ActionColumn']]]); ?> </div> <?php use app\models\Aluno; use app\models\Estado; //$model = new Aluno(); //$model->alun_nome = "Francisco"; //$model->alun_matricula = "23423"; //$model->alun_data_nascimento = "09/09/1999"; //$model->muni_codigo = 1; //$model->esta_codigo = 1; //$model->save(); // //print_r($model->errors); $estado = Estado::findOne(1); echo $estado->esta_nome . "<br>"; foreach ($estado->municipios as $municipio) { echo $municipio->muni_nome . "<br>"; }
public function actionEstado($id) { $estado = \app\models\Estado::findOne($id); return $estado; }