public function editArea($id) { $qb = DB::table('rajaongkir_indonesia_subdistricts AS S')->leftJoin('rajaongkir_indonesia_cities AS C', 'S.city_id', '=', 'C.city_id')->leftJoin('rajaongkir_indonesia_provinces AS P', 'C.province_id', '=', 'P.province_id')->where('subdistrict_id', $id); $area = $qb->first(); $cities = []; $provinces = AddressHelper::getProvinces(true); foreach ($provinces as $idx => $province) { $cities[$province] = AddressHelper::getCities($idx, true, true); } $cities = ['' => 'Select City'] + $cities; return view('admin.location.area.edit', ['cities' => $cities, 'area' => $area]); }
public function get(Request $request, $type) { $lists = []; switch ($type) { case 'provinces': $lists = AddressHelper::getProvinces(true); break; case 'cities': $lists = AddressHelper::getCities($request->get('province_id', null), true); break; case 'subdistricts': $lists = AddressHelper::getSubdistricts($request->get('city_id', null), true); break; } if ($request->has('default_label')) { $defaultLabel = $request->input('default_label'); } else { $defaultLabel = trans('forms.please_select'); } $return = [$defaultLabel] + $lists; return response()->json($return); }