public static function ra() { $pagetitle = "Project/s List"; Input::flash(); $project = Project::requestProjectsList(Input::get('status', 1), Input::get('s')); $project->appends(array('status' => Input::get('status', 1), 's' => Input::get('s')))->links(); $project_status = DB::table('project_status')->select(DB::raw('concat(users.first_name, " " ,users.last_name, " " ,project_status.update) as history, project_status.id, project_status.created_at, project_status.access'))->join('users', 'users.id', '=', 'project_status.user_id')->where('project_status.access', '<', 3)->orderBy('id', 'desc')->get(); return View::make('projects.ra', compact('pagetitle', 'project', 'project_status')); }