public function search(SearchRequest $request)
 {
     $input = $request->cpf;
     //$users = DB::table('user')->where('cpf','LIKE', '%'. $input .'%');
     if ($users = Usuario::find($input)) {
         return view('vendedor/resultado', compact('users'));
     }
     return redirect('vendedor')->with('message', 'fail');
 }
 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create($id)
 {
     if ($existe = DB::table('user')->join('supervisor', 'user.id', '=', 'supervisor.id_user')->select('user.*')->where('user.cpf', '=', $id)->where('supervisor.status', '=', 1)->get()) {
         return redirect('fiscal')->with('message', 'primarysupervisor');
     }
     if ($existence = DB::table('user')->join('supervisor', 'user.id', '=', 'supervisor.id_user')->select('user.*')->where('user.cpf', '=', $id)->where('supervisor.status', '=', 0)->get()) {
         $supervisors = DB::table('user')->join('supervisor', 'user.id', '=', 'supervisor.id_user')->select('supervisor.*')->where('user.cpf', '=', $id)->get();
         //return $supervisors;
         return view('fiscal.reativar', compact('supervisors'));
         //return redirect('fiscal')->with('message','primaryseller');
     }
     $user = Usuario::find($id);
     // return $user->cpf;
     return view('fiscal.create', compact('user'));
 }