@extends('layouts.frontend') @push('title', get_phrase('Hotel Directory Listing')) @push('meta')@endpush @push('css') @endpush @section('frontend_layout') @php $HotelBooking = json_decode(get_homepage_settings('HotelBooking') ?? '{}'); $HotelExclusive = json_decode(get_homepage_settings('HotelExclusive') ?? '{}'); $HotelSize = json_decode(get_homepage_settings('HotelSize') ?? '{}'); $HotelBanner = json_decode(get_homepage_settings('HotelBanner') ?? '{}'); @endphp

{{ $HotelExclusive->title ?? '' }}

{{ $HotelExclusive->description ?? '' }}

{{ get_phrase('Find Gateway Deals') }}

{{ $HotelSize->title ?? '' }}

{{ $HotelSize->description ?? '' }}

{{ get_phrase('Explore Hotel') }}
@foreach ($listing_countries as $index => $country) @if ($index === 0)

{{ $country->name }}

{{ $country->name }}
@endif @if ($index === 1)
@foreach ($listing_countries->slice(1, 2) as $subCountry)

{{ $subCountry->name }}

{{ $subCountry->name }}
@endforeach
@endif @if ($index === 2)
@foreach ($listing_countries->slice(3, 2) as $subCountry)

{{ $subCountry->name }}

{{ $subCountry->name }}
@endforeach
@endif @if ($index === 5)

{{ $country->name }}

{{ $country->name }}
@endif @endforeach

{{ get_phrase('Top Hotels') }}

{{ get_phrase('See all') }}
@php $topListings = $top_listings->where('is_popular', 'top')->sortByDesc('created_at')->take(4); @endphp @foreach ($topListings->sortByDesc('created_at') as $listing) @php $images = json_decode($listing->image) ?? []; $claimStatus = App\Models\ClaimedListing::where('listing_id', $listing->id)->where('listing_type', 'hotel')->first(); @endphp
@php $images = json_decode($listing->image); $image = isset($images[0]) ? $images[0] : null; @endphp @php $is_in_wishlist = check_wishlist_status($listing->id, $listing->type); @endphp
@if(isset($claimStatus) && $claimStatus->status == 1) @endif {{ $listing->title }}
@php $city_name = App\Models\City::where('id', $listing->city)->first()->name; $country_name = App\Models\Country::where('id', $listing->country)->first()->name; @endphp

{{ $city_name . ', ' . $country_name }}

@php $reviews_count = App\Models\Review::where('listing_id', $listing->id)->where('user_id', '!=', $listing->user_id)->where('type', 'hotel')->where('reply_id', null)->count(); $total_ratings = App\Models\Review::where('listing_id', $listing->id)->where('user_id', '!=', $listing->user_id)->where('type', 'hotel')->where('reply_id', null)->sum('rating'); $average_rating = $reviews_count > 0 ? $total_ratings / $reviews_count : 0; @endphp

{{ number_format($average_rating, 1) }}

({{ $reviews_count }})

    @php $features = json_decode($listing->feature, true) ?? []; $displayedFeatures = array_slice($features, 0, 2); $remainingCount = count($features) - 2; @endphp @foreach ($displayedFeatures as $feature) @php $amenities = App\Models\Amenities::where('id', $feature)->first(); @endphp @if ($amenities)
  • {{ $amenities->name }}
    • @endif @endforeach @if ($remainingCount > 0)
  • +{{ $remainingCount }} {{ get_phrase('More') }}
    • @endif
{{ get_phrase('See Details') }}

{{ currency($listing->price) }}

/{{ get_phrase('night') }}

@endforeach
@php DB::statement("SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))"); $cities = App\Models\City::select('cities.*', DB::raw('COUNT(hotel_listings.id) as listings_count'))->join('hotel_listings', 'hotel_listings.city', '=', 'cities.id')->groupBy('cities.id', 'cities.name', 'cities.image')->get(); @endphp @if ($cities->count() > 0) @foreach ($cities->take(4) as $city)

{{ $city->name }}

{{ $city->listings_count }} {{ get_phrase('Hotels') }}
@endforeach @endif

{{ get_phrase('Popular Hotel') }}

{{ get_phrase('See All') }}
@php $popularListings = $top_listings->where('is_popular', 'popular')->sortByDesc('created_at')->take(4); @endphp @foreach ($popularListings->sortByDesc('created_at') as $listing) @php $images = json_decode($listing->image) ?? []; @endphp
@php $images = json_decode($listing->image); $image = isset($images[0]) ? $images[0] : null; $claimStatus = App\Models\ClaimedListing::where('listing_id', $listing->id)->where('listing_type', 'hotel')->first(); @endphp @php $is_in_wishlist = check_wishlist_status($listing->id, $listing->type); @endphp
@if(isset($claimStatus) && $claimStatus->status == 1) @endif {{ $listing->title }}
@php $city_name = App\Models\City::where('id', $listing->city)->first()->name; $country_name = App\Models\Country::where('id', $listing->country)->first()->name; @endphp

{{ $city_name . ', ' . $country_name }}

@php $reviews_count = App\Models\Review::where('listing_id', $listing->id)->where('user_id', '!=', $listing->user_id)->where('type', 'hotel')->where('reply_id', null)->count(); $total_ratings = App\Models\Review::where('listing_id', $listing->id)->where('user_id', '!=', $listing->user_id)->where('type', 'hotel')->where('reply_id', null)->sum('rating'); $average_rating = $reviews_count > 0 ? $total_ratings / $reviews_count : 0; @endphp

{{ number_format($average_rating, 1) }}

({{ $reviews_count }})

    @php $features = json_decode($listing->feature, true) ?? []; $displayedFeatures = array_slice($features, 0, 2); $remainingCount = count($features) - 2; @endphp @foreach ($displayedFeatures as $feature) @php $amenities = App\Models\Amenities::where('id', $feature)->first(); @endphp @if ($amenities)
  • {{ $amenities->name }}
    • @endif @endforeach @if ($remainingCount > 0)
  • +{{ $remainingCount }} {{ get_phrase('More') }}
    • @endif
{{ get_phrase('See Details') }}

{{ currency($listing->price) }}

/{{ get_phrase('night') }}

@endforeach

{{ $HotelBooking->title ?? '' }}

  • icon {{ get_phrase('Flexible budget') }}
  • icon {{ get_phrase('Peaceful place') }}
  • icon {{ get_phrase('Well decorated') }}
{{ get_phrase('Contact Us') }}
@endsection @push('js') @if (Auth::check()) @else @endif @endpush