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'));
}
