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