/** * @param $province_id * @param $category_id * * @return int */ static function ProvinceAddsCount($province_id, $category_id = null) { if ($category_id) { $count = Classified::join('cities', 'classifieds.city_id', '=', 'cities.id')->where('cities.province_id', $province_id)->where('classifieds.category_id', $category_id)->count(); } else { $count = Classified::join('cities', 'classifieds.city_id', '=', 'cities.id')->where('cities.province_id', $province_id)->count(); } if ($count) { return "({$count})"; } return '<span class="light-grey">(' . $count . ')</span>'; }
/** * Show all adds in a province * * @param $slug * * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function showProvince($slug) { $province = Province::whereSlug($slug)->first(); $categories = ClassifiedCategory::orderBy('id')->get(); $items = Classified::join('cities', 'classifieds.city_id', '=', 'cities.id')->where('cities.province_id', '=', $province->id)->select('classifieds.*')->orderBy('publish_at', 'desc')->get(); return view('classifieds.classified_province', compact('province', 'categories', 'items')); }