public function actionMunicipio($id) { $rows = \app\models\Municipio::find()->where(['esta_codigo' => $id])->all(); echo "<option>Selecione um municipio</option>"; if (count($rows) > 0) { foreach ($rows as $row) { echo "<option value='{$row->muni_codigo}'>{$row->muni_nome}</option>"; } } else { echo "<option>Nenhum municipio cadastrado</option>"; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Municipio::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(['muni_codigo' => $this->muni_codigo, 'esta_codigo' => $this->esta_codigo]); $query->andFilterWhere(['like', 'muni_nome', $this->muni_nome]); return $dataProvider; }
/** * Updates an existing ProyectoLocalizacion model. * For ajax request will return json object * and for non-ajax request if update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $request = Yii::$app->request; $model = $this->findModel($id); //Escenario $model->scenario = $this->findAmbito($model->id_proyecto); switch ($model->scenario) { case 'Nacional': $model->id_pais = Pais::findOne(['nombre' => 'Venezuela'])->id; break; default: $model->id_pais = Pais::findOne(['nombre' => 'Venezuela'])->id; break; } //Listas desplegables $paises = Pais::find()->all(); $estados = Estados::find()->all(); $parroquias = Parroquia::find()->all(); $municipios = Municipio::find()->all(); if ($request->isAjax) { /* * Process for ajax request */ Yii::$app->response->format = Response::FORMAT_JSON; if ($request->isGet) { return ['title' => "Update ProyectoLocalizacion #" . $id, 'content' => $this->renderPartial('update', ['model' => $model, 'paises' => $paises, 'estados' => $estados, 'municipios' => $municipios, 'parroquias' => $parroquias]), 'footer' => Html::button('Close', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::button('Save', ['class' => 'btn btn-primary', 'type' => "submit"])]; } else { if ($model->load($request->post()) && $model->save()) { return ['forceReload' => 'true', 'title' => "ProyectoLocalizacion #" . $id, 'content' => $this->renderPartial('view', ['model' => $model, 'paises' => $paises, 'estados' => $estados, 'municipios' => $municipios, 'parroquias' => $parroquias]), 'footer' => Html::button('Close', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::a('Edit', ['update', 'id' => $id], ['class' => 'btn btn-primary', 'role' => 'modal-remote'])]; } else { return ['title' => "Update ProyectoLocalizacion #" . $id, 'content' => $this->renderPartial('update', ['model' => $model, 'paises' => $paises, 'estados' => $estados, 'municipios' => $municipios, 'parroquias' => $parroquias]), 'footer' => Html::button('Close', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::button('Save', ['class' => 'btn btn-primary', 'type' => "submit"])]; } } } else { /* * Process for non-ajax request */ if ($model->load($request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('update', ['model' => $model, 'paises' => $paises, 'estados' => $estados, 'municipios' => $municipios, 'parroquias' => $parroquias]); } } }
/** * Remove the specified Municipio from storage. * * @param int $id * * @return Response */ public function destroy($id) { /** @var Municipio $municipio */ $municipio = Municipio::find($id); if (empty($municipio)) { Flash::error('Municipio not found'); return redirect(route('municipios.index')); } $municipio->delete(); Flash::message('Municipio deleted successfully.'); return redirect(route('municipios.index')); }
/** * Find Municipio by given id * * @param int $id * * @return \Illuminate\Support\Collection|null|static|Municipio */ public function findMunicipioById($id) { return Municipio::find($id); }
/** * Lists all Municipio models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Municipio::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }