/** * Make the list for json autocomplete search * * @return string */ public static function cityListForAutoComplete() { $cities = City::select(['id', 'name'])->orderBy('name')->get()->transform(function ($city) { return $city['name'] = $city['name'] . ' (' . City::whereId($city['id'])->first()->province->name . ')'; }); return "var cities = " . $cities->toJson(); }
/** * Sbow all adds in a city * * @param $slug * @param $id * * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function showCity($slug, $id) { $city = City::whereId($id)->first(); $categories = ClassifiedCategory::orderBy('id')->get(); $items = Classified::where('city_id', $id)->orderBy('publish_at', 'desc')->get(); return view('classifieds.classified_city', compact('city', 'categories', 'items')); }