public function run () { DB::table('districts')->delete(); District::create([ 'cname' => '黄浦区', 'ename' => 'HuangPu District', 'code' => 1, 'city_id' => 1, 'active' => 1 ]); District::create([ 'cname' => '浦东新区', 'ename' => 'HuangPu District', 'code' => 2, 'city_id' => 1, 'active' => 1 ]); }
public function actionLoaddistrict($id = null) { //$id คือ รหัส pk ของจังหวัด $districts = District::find()->where(['province_id' => $id])->orderBy('district_name')->all(); $option = '<option value="">-กรุณาเลือกอำเภอ-</option>'; foreach ($districts as $d) { $option .= '<option value="' . $d->id . '">' . $d->district_name . '</option>'; } echo $option; }
public function actionFind() { $searchForm = new FindForm(); $view['districtList'] = ArrayHelper::map(District::find()->where("district != ''")->orderBy('district')->all(), 'id_district', 'district'); $params = ArrayHelper::merge(Yii::$app->request->getQueryParams(), Yii::$app->request->post()); $searchForm->load($params); if (implode('', $searchForm->toArray())) { //$view['list'] = $searchForm->search(); } else { $amount = (int) ArrayHelper::getValue(Main::findBySql("select count(id_person) as amount from main")->asArray()->one(), 'amount'); } $view['pagination'] = new Pagination(['pageSize' => 10]); //dd($amount); $dataProvider = new ActiveDataProvider(['query' => $searchForm->getSearchQuery(), 'totalCount' => $amount ? $amount : null, 'pagination' => $view['pagination']]); //dd($dataProvider); $view['dataProvider'] = $dataProvider; $view['searchForm'] = $searchForm; return $this->render('find', $view); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function getEdit($id) { $this->districts = District::all('id', 'name'); $area = Area::find($id); if ($area) { return view('modules.area.form', array('is_edit' => true, 'area' => $area, 'districts' => $this->districts)); } else { return $this->notFoundResponse(); } }
/** * Remove the specified resource from storage. * * @return \Illuminate\Http\Response */ public function postDestroy() { if ($this->request->ajax()) { $id = $this->request['id'] ?: ''; $data = District::find($id); if ($data) { $data->delete(); } $response = array('url' => route('place.index')); return $response; } }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $value = District::find($id); if ($value == null) { return response(['errorMessage' => 'Not Found'], 404); } $value->delete(); return response('', 200); }
/* @var $this yii\web\View */ /* @var $model app\models\Contact */ /* @var $form yii\widgets\ActiveForm */ if($model->isNewRecord){ $province = []; $district = []; $tambon = []; $district_list = []; $tambon_list = []; }else{ $province = $model->tambon->province_id; $district = $model->tambon->district_id; $tambon = $model->tambon_id; $district_list = ArrayHelper::map(District::find() ->where(['province_id'=>$province])->all(), 'id', 'district_name'); $tambon_list = ArrayHelper::map(Tambon::find() ->where(['district_id'=>$district])->all(), 'id', 'tambon_name'); } ?> <div class="contact-form"> <?php $form = ActiveForm::begin(); ?> <?= $form->field($model, 'firstname')->textInput(['maxlength' => true]) ?> <?= $form->field($model, 'lastname')->textInput(['maxlength' => true]) ?>
/** * Update the profile * * @param int $id * @return Response */ public function updateprofile($id) { $data['user'] = User::findOrFail($id); $data['sectors'] = Sector::lists('name', 'id'); $data['districts'] = District::lists('district', 'id'); $districtsselected = PartnerDistrict::get_districts_selected($id); $data['districtsselected'] = PartnerDistrict::format_selected($districtsselected); $data['cancelbtn'] = Permission::hasPermission('users.index'); return view('users.profile', $data); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $data['project'] = $project = Project::find($id); if ($project) { $data['sectors'] = Sector::lists('name', 'id'); $data['states'] = State::lists('state', 'id'); $data['districts'] = District::where('state_id', $data['project']->state_id)->lists('district', 'id'); $data['taluks'] = Taluk::where('district_id', $data['project']->district_id)->lists('taluk', 'id'); $data['cancelbtn'] = Permission::hasPermission('projects.index'); return view('projects.edit', $data); } else { Session::flash($this->danger, Lang::get('ruban.project.notfound')); return Redirect::route('ruban.projects.index'); } }
public function getDistricts() { return @$this->hasOne(District::className(), ['DISTRICT_ID' => 'province']); }
/** * @return \yii\db\ActiveQuery */ public function getBaseDistricts() { return $this->hasMany(District::className(), ['province_id' => 'id']); }
/** * Get districts that belong to the city/province by city_id * * @param int $id City id * * @return \Illuminate\Support\Collection $collection */ protected function _getDistrictsByCityId($id) { $dbRaw = DB::raw("id, CONCAT(type, ' ', name) as name"); $districts = District::where('city_id', $id)->select($dbRaw)->orderBy('name')->get(); return $districts; }
/** * @return \yii\db\ActiveQuery */ public function getDistrict() { return $this->hasOne(District::className(), ['id' => 'district_id']); }
protected function getDistrict($id) { $datas = District::find()->where(['AMPHUR_ID' => $id])->all(); return $this->MapData($datas, 'DISTRICT_ID', 'DISTRICT_NAME'); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $data['card'] = $card = Card::find($id); if ($card) { $data['sectors'] = Sector::lists('name', 'id'); $data['districts'] = District::groupby($this->district)->lists($this->district, 'id'); $data['projects'] = Project::orderby('name', 'asc')->lists('name', 'id'); $data['listbtn'] = Permission::hasPermission('cards.update'); return view('cards.edit', $data); } else { Session::flash('danger', Lang::get('ruban.card.notfound')); return Redirect::route('ruban.cards.index'); } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function getEdit($id) { $this->districts = District::all('id', 'name'); $street = Street::find($id); if ($street) { return view('modules.street.form', array('is_edit' => true, 'street' => $street, 'districts' => $this->districts)); } else { return $this->notFoundResponse(); } }
public function getdistrict() { $equipmenttypes = District::where($this->state_id, Input::get('id'))->orderby('district', 'asc')->lists('district', 'id'); $out = '<option value="">Select Option</option>'; if ($equipmenttypes) { foreach ($equipmenttypes as $key => $equipmenttype) { $out .= '<option value="' . $key . '">' . $equipmenttype . '</option>'; } } echo $out; }
public function getReceiverinfo (Request $request) { $user = Auth::user(); $receiverInfoSet = ReceiverInfo::where('uid', '=', $user->id) ->where('active', '=', '1') ->orderBy('last_used', 'desc') ->orderBy('created_at', 'desc') ->get(); $provinceSet = Province::all(); $provinces = array(); foreach ($provinceSet as $province) { array_push($provinces, $province); } $cities = City::all(); $districts = array(); foreach ($cities as $city) { $district = District::where('city_code', '=', $city->code) ->where('active', '=', '1') ->first(); if ($district) { array_push($districts, $district); } } $receiverInfos = array(); foreach ($receiverInfoSet as $receiverInfo) { array_push($receiverInfos, $receiverInfo); } $data = [ 'receiverInfos' => $receiverInfos, 'provinces' => $provinces, 'cities' => $cities, 'districts' => $districts, 'receiverActive' => true, 'wTitle' => '个人中心 - 收货人信息' ]; return view('profile/receiver_info', $data); }
public function getDistrict (Request $request) { $city = $request->input('city'); $districts = District::where('city_code', '=', $city) ->where('active', '=', 1) ->get(); $html = $this->districtList($districts); return $this->successResponse('res', $html); }