public function getList() { $countries = Country::whereHas('translations', function ($query) { $query->where('locale', 'de')->whereNotNull('name'); })->get()->lists('name', 'id'); $list = $countries->toArray(); asort($list); return $list; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $this->validate($request, ['search' => 'string|max:20']); if ($request->has('search')) { $search = $request->input('search'); $countries = Country::whereHas('translations', function ($query) use($search) { $query->where('name', 'like', $search . '%'); })->paginate(15); } else { $countries = Country::paginate(15); } if ($request->wantsJSON()) { return response()->json($countries->toArray(), 200); } else { return view('pages.country.index', ['countries' => $countries]); } }