/** * Display a listing of the resource. * GET /project * * @return Response */ public function index() { $pagetitle = 'My Project List'; Input::flash(); if (Input::get('status') > 1) { if (Input::get('s') != '') { DB::table('projects')->where('project_name', Input::get('s'))->update(array('notif' => 2)); } if (Session::get('role') == 1 || Session::get('role') == 2) { $projects = Project::select_projects_all(Input::get('status', 1), Input::get('s'), Auth::id()); $projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links(); $project_stats = DB::table('project_status')->orderBy('id', 'desc')->get(); } else { $projects = Project::select_projects(Auth::id(), Input::get('status', 1), Input::get('s'), Auth::id()); $projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links(); $project_stats = DB::table('project_status')->where('created_by', Auth::id())->orderBy('id', 'desc')->get(); } return View::make('projects.index', compact('pagetitle', 'projects', 'project_stats')); } else { if (Session::get('role') == 1 || Session::get('role') == 2) { $projects = Project::select_projects_all(Input::get('status', 1), Input::get('s'), Auth::id()); $projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links(); $project_stats = DB::table('project_status')->orderBy('id', 'desc')->get(); } else { $projects = Project::select_projects(Auth::id(), Input::get('status', 1), Input::get('s'), Auth::id()); $projects->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links(); $project_stats = DB::table('project_status')->where('created_by', Auth::id())->orderBy('id', 'desc')->get(); } // $company_status = DB::table('company_status')->get(); return View::make('projects.index', compact('pagetitle', 'projects', 'project_stats')); } // $projects = Project::select_projects(Input::get('status', 1),Input::get('s'),Auth::id()); // return View::make('projects.index', compact('pagetitle', 'projects')); }