/** * Display a listing of the resource. * * @return Response */ public function listItem() { $currUser = Auth::user()->id; $oQuery = Companies::join('cities', 'cities.id', '=', 'city_id')->join('regions', 'regions.id', '=', 'cities.region_id')->join('country', 'country.id', '=', 'regions.country_id')->join('users', 'users.id', '=', 'companies.user_id')->select('companies.id as id', 'companies.phone', 'companies.email', 'companies.name', 'companies.web_site', 'companies.description', 'regions.name as region_name', 'regions.id as region_id', 'country.name as country_name', 'users.name as user_name', 'cities.name as city_name'); $aCompany = $oQuery->paginate(10); return View::make('/company/list', array('aCompany' => $aCompany)); }