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);
}
