/**
  * Show the form for creating a new resource.
  *
  * @param Request $request
  * @return \Illuminate\Http\Response
  */
 public function find(Request $request)
 {
     $givenname = $request->input('givenname');
     $surname = $request->input('surname');
     $request->flashOnly('givenname', 'surname');
     $holderQuery = Holder::with('animals.medications')->where('givenname', 'LIKE', $givenname)->orWhere('surname', 'LIKE', $surname);
     $holderSql = $holderQuery->toSql();
     $holder = $holderQuery->first();
     return view('home.index', ['holder' => $holder, 'sql' => $holderSql]);
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int $id
  * @return Response
  */
 public function destroy($id)
 {
     Holder::destroy($id);
     alert()->success('', 'Holder successfully deleted!');
     return redirect('holder');
 }