public function getCommunity($community) { $community = \App\Community::where('community', '=', $community)->with('properties')->first(); if (is_null($community)) { abort(404); } $properties = \App\Property::whereHas('community', function ($q) use($community) { $q->where('community', '=', $community['community']); $q->where('Status', '!=', 'closed'); })->paginate(15); return view('pages.communityDetail')->with(['community' => $community, 'properties' => $properties, 'communities' => $this->communities, 'communitySelect' => $this->communitySelect]); }
public function searchResults(Request $request) { $result = null; // OR search if ($request->architectures) { $result = Property::whereHas('architectures', function ($query) use($request) { $query->whereIn('id', array_keys($request->architectures)); }); } // AND search (from http://laravel.io/forum/04-07-2014-search-post-by-many-tags) if ($request->exteriorFeatures) { if (!$result) { $result = Property::where('id', '>', 1); } $result = $result->whereHas('exteriorFeatures', function ($query) use($request) { $query->whereIn('id', array_keys($request->exteriorFeatures)); }, count(array_keys($request->exteriorFeatures))); } if ($result) { $properties = $result->get(); } return view('properties.searchResults', compact('properties')); }