public function hotsite($id, $url_name) { $user = User::find($id); if ($user->typeuser_id < 5) { $subcategories = SubCategory::where('category_id', 1)->get(); } else { $subcategories = Subcategory::where('category_id', 2)->get(); } $advertUser = Advert::where('user_id', $id)->where('status', '>', '0')->orderByRaw("RAND()")->paginate(18); $marcas = VeiculoMarca::get(); $advertAluga = Advert::where('user_id', $id)->where('tipo_anuncio', '=', 'aluga')->where('status', '>', '0')->count(); $advertVenda = Advert::where('user_id', $id)->where('tipo_anuncio', '=', 'venda')->where('status', '>', '0')->count(); if (empty($advertUser)) { return view('error.error404'); } else { return view('site.pages.hotsite', compact('advertUser', 'user', 'advertAluga', 'advertVenda', 'subcategories', 'marcas')); } }