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