/** * Display a listing of the resource. * * @return Response */ public function listItem() { $currUser = Auth::user(); $oQuery = Countries::join('users', 'users.id', '=', 'user_id')->select('country.id as id', 'country.name', 'country.description', 'users.name as user_name', 'users.id as user_id'); if ($currUser->is_admin == 0) { return Redirect::route('user-dashboard', array()); } $aCountry = $oQuery->paginate(10); return View::make('/country/list', array('aCountry' => $aCountry)); }