/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $id = Auth::user()->id; $role = Auth::user()->role; if ($role == 'developer') { // $projects=\DB::table('projects')->where('developer_id', '=', $id)->get(); $projects = Project::where('developer_id', $id)->get(); return view('agent/projects/list', compact('projects')); } elseif ($role == 'agent') { $projects = Project::where('agent_id', $id)->get(); return view('agent/projects/list', compact('projects')); } elseif ($role == 'customer') { $projects = Project::where('costumer_id', $id)->get(); return view('agent/projects/list', compact('projects')); } elseif ($role == 'admin') { $projects = Project::filter($request->get('name')); return view('projects/list', compact('projects')); } }