public function searchResult() { $cats = Cat::all(); $stateList = State::lists('name', 'name'); $catList = Cat::lists('name', 'name'); $featured = Biz::whereFeatured('YES')->paginate(3); $recent = Biz::orderBy('created_at', 'desc')->paginate(1); $val = Input::get('category'); $loc = Input::get('location'); if ($sub = SubCat::whereName($val)->first()) { $subID = $sub->id; if ($area = Lga::whereName($loc)->first()) { $areaID = $area->id; $bizs = Biz::bySub($subID)->byArea($areaID)->get(); if ($bizs->count() > 0) { return view('pages.search-page', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } else { $bizs = $sub->biz; return view('pages.no-search', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } } else { $state = State::whereName($loc)->first(); $stateID = $state->id; $bizs = Biz::bySub($subID)->byState($stateID)->get(); if ($bizs->count() > 0) { return view('pages.search-page', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } else { $bizs = $sub->biz; return view('pages.no-search', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'key', 'loc')); } } } else { $cat = Cat::whereName($val)->first(); $catID = $cat->id; if ($area = Lga::whereName($loc)->first()) { $areaID = $area->id; $bizs = Biz::byCat($catID)->byArea($areaID)->get(); if ($bizs->count() > 0) { return view('pages.search-page', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } else { $bizs = $cat->biz; return view('pages.no-search', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } } else { $state = State::whereName($loc)->first(); $stateID = $state->id; $bizs = Biz::byCat($catID)->byState($stateID)->get(); if ($bizs->count() > 0) { return view('pages.search-page', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } else { $bizs = $cat->biz; return view('pages.no-search', compact('bizs', 'stateList', 'catList', 'cats', 'featured', 'recent', 'val', 'loc')); } } } }