<?php

namespace App\Http\Controllers;

use App\Models\MusicImage;
use App\Models\Product;
use App\Models\Testimonials;
use App\Models\Blogs;
use App\Models\SiteGallery;
use App\Models\Investor;
use App\Models\OurService;
use App\Models\Region;
use App\Models\Vendor;
use App\Models\SubVendor;
use App\Models\User;
use App\Models\Event;
use App\Models\Banner;
use App\Models\Category;
use App\Models\Advertisement;
use App\Models\Package;
use App\Models\Brand;
use App\Models\GalleryAlbum;
use App\Models\Music;
use App\Models\Costume;
use App\Models\FAQPage;
use App\Models\Carnival;
use App\Models\OurTeam;
use App\Models\City;
use App\Models\Country;
use App\Models\CarnivalMembers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Str;
use App\Services\ProductService;
use DB;
use Carbon\Carbon;
use Illuminate\Support\Facades\Route;


class FrontendConroller extends Controller
{
    public function home()
    {
        $events = Event::with('images', 'tickets')->orderBy('id', 'desc')->get()->take('5');
        // $events = Event::with('images','tickets')->orderBy('id','desc')->get()->take('5');
        $banners = Banner::where('type', 'home')->get();
        $regions = Region::with('countries')->OrderBy('placement', 'ASC')->get();
        $services = OurService::get()->take('4');
        $siteGallery = SiteGallery::with('user')->whereHas('user', function ($query) {
            $query->where('role_id', 1);
        })->get();
        $products = Product::with('brand')->get();
        $investors = Investor::all();
        $testimonials = Testimonials::where('status', 1)->get();
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        $carnivals = Carnival::with('user')->get()->take('6');
        // dd($events->toArray());
        $carnival_com = Carnival::has('user')->pluck('head');

        $carnival_commitee = Vendor::with('user')->whereIn('user_id', $carnival_com)->orderBy('id', 'DESC')->get();

        // dd($carnivals->toArray(), $carnival_com->toArray(), $carnival_commitee->toArray());

        return view('front.home', compact('carnivals', 'events', 'regions', 'services', 'siteGallery', 'products', 'investors', 'blogs', 'testimonials', 'carnival_commitee', 'banners'));
    }
    public function aboutus()
    {
        $banners = Banner::where('type', 'aboutus')->get();
        $services = OurService::get()->take('4');
        $investors = Investor::all();
        $testimonials = Testimonials::where('status', 1)->get();
        $siteGallery = SiteGallery::get();
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        $products = Product::with('brand')->get();
        $carnival_com = Carnival::has('user')->pluck('head');
        $ourTeam = OurTeam::orderBy('id', 'DESC')->take(6)->get();
        $faqs = FAQPage::where('status', 1)->where('page', 'AboutUs')->get();
        $carnival_commitee = Vendor::with('user')->whereIn('user_id', $carnival_com)->orderBy('id', 'DESC')->get();


        return view('front.aboutus', compact('services', 'carnival_commitee', 'products', 'blogs', 'investors', 'testimonials', 'siteGallery', 'ourTeam', 'faqs', 'banners'));
    }
    public function travel()
    {
        return view('front.travel');
    }
    public function carnival_listing()
    {

        $regions = Region::with('countries')->OrderBy('placement', 'ASC')->get();
        $carnivals = Carnival::with('user')->get();
        $investors = Investor::all();
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        $products = Product::with('brand')->get();
        $carnival_com = Carnival::has('user')->pluck('head');
        $carnival_commitee = Vendor::with('user')->whereIn('user_id', $carnival_com)->orderBy('id', 'DESC')->get();
        // dd($events->toArray());
        return view('front.carnival-listing', compact('products', 'blogs', 'carnivals', 'investors', 'regions', 'carnival_commitee'));
    }
    public function get_carnivals_by_region($id)
    {
        $carnivals = Carnival::with('user', 'city')->where('region_id', $id)->get();

        // Format the data to send as JSON
        $data = $carnivals->map(function ($carnival) {
            return [
                'id' => $carnival->id,
                'name' => $carnival->name,
                'image_url' => $carnival->city && $carnival->city->airport ? asset($carnival->city->airport) : 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                'imageUrl_hotel' => $carnival->city && $carnival->city->hotel ? asset($carnival->city->hotel) : 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                'imageUrl_event' => $carnival->city && $carnival->city->event ? asset($carnival->city->event) : 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                // 'image_url' => 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                // 'image_url' => 'https://carnivalguide.co/travel/img/home/city_1.jpg',

            ];
        });

        return response()->json($data);
    }
    public function get_carnivals_by_region_for_home($id)
    {
        $carnivals = Carnival::with('user', 'city')->where('region_id', $id)->take(6)->get();

        // Format the data to send as JSON
        $data = $carnivals->map(function ($carnival) {
            return [
                'id' => $carnival->id,
                'name' => $carnival->name,
                'image_url' => $carnival->city && $carnival->city->airport ? asset($carnival->city->airport) : 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                'imageUrl_hotel' => $carnival->city && $carnival->city->hotel ? asset($carnival->city->hotel) : 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                'imageUrl_event' => $carnival->city && $carnival->city->event ? asset($carnival->city->event) : 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                // 'image_url' => 'https://carnivalguide.co/travel/img/home/city_1.jpg',
                // 'image_url' => asset('images/carnivals/' . $carnival->image),

            ];
        });

        return response()->json($data);
    }
    public function event_listing(Request $request)
    {
        $banners = Banner::where('type', 'event')->get();
        $products = Product::with('brand')->get();
        $upcoming_events = Event::with('tickets')
            ->where('status', 'active')
            ->where('package_id', 6)
            ->whereBetween('start_date', [
                Carbon::now(),
                Carbon::now()
                    ->addMonths(3),
            ])->orderBy('id', 'DESC')->get();
        $carnival_events = Event::with('tickets')->where('status', 'active')
            ->where('start_date', '>', Carbon::now())->orderBy('id', 'DESC')->get()->take(8);
        $all_events = Event::with('tickets')->where('status', 'active')
            ->where('start_date', '>', Carbon::now())->orderBy('id', 'DESC')->get()->take(4);
        $popular_events = Event::with('tickets')->where('status', 'active')
            ->whereHas('category', function ($query) {
                $query->where('title', 'like', '%' . 'Party' . '%');
            })
            ->where('start_date', '>', Carbon::now())->orderBy('id', 'DESC')->get()->take(8);
        $ads = Advertisement::where('type', 'event')->get();

        // Debug: Check if events are being loaded
        \Log::info('Event Listing Debug:', [
            'upcoming_events_count' => $upcoming_events->count(),
            'carnival_events_count' => $carnival_events->count(),
            'all_events_count' => $all_events->count(),
            'popular_events_count' => $popular_events->count(),
            'sample_upcoming_event' => $upcoming_events->first() ? $upcoming_events->first()->only(['id', 'name', 'status', 'start_date']) : null,
        ]);

        return view('front.events', compact('products', 'banners', 'upcoming_events', 'all_events', 'carnival_events', 'popular_events', 'ads'));
    }
    public function category_tour_listing()
    {
        return view('front.category-tours');
    }
    public function tour_listing()
    {
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        $products = Product::with('brand')->get();
        return view('front.tours', compact('blogs', 'products'));
    }
    public function flight()
    {
        return view('front.flight');
    }
    public function flight_listing()
    {
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        return view('front.flight-isting', compact('blogs'));
    }
    public function hotel_listing()
    {
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        $products = Product::with('brand')->get();
        return view('front.hotel-isting', compact('blogs', 'products'));
    }
    public function gallery()
    {
        return view('front.gallery');
    }
    public function car_rental()
    {
        return view('front.car-rental');
    }
    public function get_product(Request $request)
    {
        $query = Product::with('product_images', 'media', 'category', 'brand', 'product_variant', 'user');
        $getSearchVal = $request->get('getSearchVal', null);

        if ($request->has('categories') && !empty($request->categories)) {
            $query->whereIn('category_id', $request->categories);
        }

        if ($request->filled('brands')) {
            $query->whereIn('brand_id', $request->brands);
        }

        if ($request->filled('price_ranges')) {
            $price_ranges = $request->price_ranges;
            $query->whereHas('product_variant', function ($q) use ($price_ranges) {
                $q->where(function ($query) use ($price_ranges) {
                    foreach ($price_ranges as $range) {
                        $min = (float) $range['min'];
                        $max = (float) $range['max'];
                        $query->orWhereBetween('price', [$min, $max]);
                    }
                });
            });
        }

        if ($request->filled('product_condition')) {
            $query->whereIn('condition', $request->product_condition);
        }

        if ($request->filled('stock_condition')) {
            $query->whereIn('stock_condition', $request->stock_condition);
        }

        if ($request->filled('sale')) {
            $query->where('sale', 'true');
        }

        if (!empty($getSearchVal)) {
            $query->where('title', 'like', '%' . $getSearchVal . '%');
        }

        $products = $query->orderBy('id', 'DESC')->paginate(18);
        return $products;
    }

    public function product_detail($slug)
    {
        $product = Product::with('variants', 'product_variant', 'product_images')->where('slug', $slug)->firstOrFail();
        $related = Product::where('category_id', $product->category_id)->where('user_id', $product->user_id)->where('id', '!=', $product->id)->orderBy('id', 'DESC')->get();
        $same_cat = Product::where('category_id', $product->category_id)->where('id', '!=', $product->id)->orderBy('id', 'DESC')->take(9)->get();
        return view('ShopFrontend.product-detail', compact('product', 'related', 'same_cat'));
    }

    public function get_vendors(Request $request)
    {
        $previous_route = app('router')->getRoutes()->match(Request::create(url()->previous()))->getName() ?? 'N/A';
        $vendor_type = $request->get('vendor_type', null);
        $regionId = $request->get('getRegion');
        $getSearchVal = $request->get('getSearchVal');
        $getGender = $request->get('getGender');


        $carnival_com = Carnival::has('user')->pluck('head');

        // $query = Vendor::query();
        // if ($previous_route == 'front.vendors') {
        //     $query = Vendor::with('user')->whereIn('user_id', $carnival_com);
        // } else {
        $query = Vendor::with('user', 'package')->whereHas('package', function ($query) {
            $query->where('title', '!=', 'Carnival Committee');
        });
        // }
        $query->with([
            'user' => function ($query) {
                $query->select('id', 'first_name', 'last_name', 'slug', 'image', 'city', 'country');
            },
            'continent' => function ($query) {
                $query->select('id', 'name');
            },
            'user.products' => function ($query) {
                $query->select('user_id', DB::raw('MIN(new_price) as min_price'), DB::raw('MAX(new_price) as max_price'))
                    ->groupBy('user_id');
            },
        ]);

        if ($vendor_type) {
            $query->whereHas('package', function ($query) use ($vendor_type) {
                $query->where('title', $vendor_type);
            });
        }

        if ($regionId) {
            $query->where('continent', $regionId);
        }

        if ($getSearchVal) {
            $query->where('name', 'like', '%' . $getSearchVal . '%')
                ->orWhereHas('user', function ($query) use ($getSearchVal) {
                    $query->where('first_name', 'like', "%$getSearchVal%")
                        ->orWhere('last_name', 'like', "%$getSearchVal%");
                });
        }

        if ($getGender) {
            $query->WhereHas('user', function ($query) use ($getGender) {
                $query->where('gender', $getGender);
            });
        }
        // dd($previous_route, $request->toArray());


        $vendors = $query->orderBy('id', 'DESC')->paginate(18);

        return $vendors;
    }
    public function shop_home()
    {
        $categories = Category::where('status', 1)->take(3)->get();
        $oackages = Package::where('status', 1)->get();
        $brands = Brand::where('status', 1)->take(2)->get();
        $products = Product::with('brand')->orderBy('id', 'DESC')->take(10)->get();
        $new_arrivals = Product::orderBy('id', 'DESC')->take(10)->get();
        $discounted_products = Product::orderBy('id', 'DESC')->take(10)->get();
        $topVendors = Vendor::with('products')
            ->orderBy('id', 'DESC')
            ->take(10)
            ->get();
        $banners = Banner::where('type', 'shop')->get();

        $top_sellers = collect();

        foreach ($topVendors as $vendor) {
            $product = $vendor->products()->first();
            if ($product) {
                $top_sellers->push($product);
            }
        }
        // dd($top_sellers->toArray());
        $investors = Investor::all();
        $ads = Advertisement::all()->take('2');
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('6');
        // dd($products->toArray());
        return view('ShopFrontend.home', compact('products', 'investors', 'blogs', 'categories', 'oackages', 'new_arrivals', 'top_sellers', 'brands', 'discounted_products', 'banners', 'ads'));
    }
    public function product_listing(Request $request)
    {
        $products = Product::with('brand')->get();
        $brands = Brand::where('status', 1)
            ->withCount('products')
            ->get();
        $cat1 = Category::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $cat2 = Category::where('status', 1)
            ->whereNotIn('id', $cat1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $cat3 = Category::where('status', 1)
            ->whereNotIn('id', $cat1->pluck('id')->merge($cat2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $selected_brand = '';

        if ($request->brand && $request->brand != null) {
            $selected_brand = $request->brand;
        }


        return view('ShopFrontend.product-listing', compact('products', 'brands', 'cat1', 'cat2', 'cat3', 'selected_brand'));
    }
    public function package_detail()
    {
        $products = Product::with('brand')->get();
        return view('ShopFrontend.package-detail', compact('products'));
    }
    public function vendor_listing()
    {
        $mascamp_banners = Banner::where('type', 'mascamps')->get();
        $regions = Region::OrderBy('placement', 'ASC')->get();
        $adv1 = Advertisement::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv2 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv3 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id')->merge($adv2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $carnival_com = Carnival::has('user')->pluck('head');
        // $carnival_commitee = Vendor::with('user')->whereIn('user_id', $carnival_com)->orderBy('id', 'DESC')->get();
        $carnival_commitee = Vendor::with('user', 'package')->whereHas('package', function ($query) {
            $query->where('title', 'Carnival Committee');
        })->orderBy('id', 'DESC')->get();

        return view('ShopFrontend.vendors', compact('regions', 'mascamp_banners', 'adv1', 'adv2', 'adv3', 'carnival_commitee'));
    }
    public function contact_us()
    {
        return view('ShopFrontend.contact');
    }
    public function marketplace()
    {
        $products = Product::with('brand')->get();
        return view('ShopFrontend.marketplace', compact('products'));
    }
    public function compare_produts()
    {
        $products = Product::with('brand')->get();
        return view('ShopFrontend.compare-produts', compact('products'));
    }
    public function track_order()
    {
        $products = Product::with('brand')->get();
        return view('ShopFrontend.track-order', compact('products'));
    }
    public function blog_list()
    {
        $products = Product::with('brand')->get();
        return view('ShopFrontend.blog-list', compact('products'));
    }
    public function blog_detail($id)
    {
        $products = Product::with('brand')->get();
        $blog = Blogs::with('user')->where('slug', $id)->first();

        if (!$blog) {
            return redirect()->back()->with('error', 'Blog not found');
        }

        $related_blogs = Blogs::with('user')
            ->where('id', '!=', $blog->id)
            ->where('category_id', $blog->category_id)
            ->orderBy('id', 'desc')
            ->get()->take(3);

        $recent_blogs = Blogs::with('user')
            ->where('id', '!=', $blog->id)
            ->where('category_id', $blog->category_id)
            ->orderBy('id', 'desc')
            ->get()->take(7);

        return view('ShopFrontend.blog-detail', compact('products', 'blog', 'related_blogs', 'recent_blogs'));
    }

    public function vendor_detail($slug)
    {
        $user = User::with('banners', 'vendor.package', 'subVendor.package')->whereSlug($slug)->first();

        if (!$user) {
            abort(404, 'Vendor not found');
        }

        $carnival = Carnival::with('mascamps', 'members', 'events')
            ->where('head', $user->id)
            ->first();

        // dd($carnival->toArray());
        $vendor = Vendor::with('user', 'products.category', 'gallery', 'subvendor')
            ->where('user_id', $user->id)
            ->first();

        $subvendors = SubVendor::with('products.category')
            ->where('vendor_id', $user->id)
            ->get();

        $categories = collect();
        $products = collect();

        if ($vendor) {
            $categories = $vendor->products->pluck('category')->filter()->unique('id');
            $products = Product::where('user_id', $user->id)->with('brand')->get();
        }

        $ads = Advertisement::where('status', 1)->take(2)->get();

        $vendorPackageName = optional($user->vendor?->package)->title;
        $subVendorPackageName = optional($user->subVendor?->package)->title;
        $investors = Investor::all();

        $carnival_com = Carnival::has('user')->pluck('head');
        // var_dump($carnival_com->toArray());
        // dd($vendor->toArray());
        $all_categories = Category::with('subcategories')->where('status', 1)->get();

        $carnival_commitee = Vendor::with('user')->whereIn('user_id', $carnival_com)->orderBy('id', 'DESC')->get();

        if ($vendorPackageName === 'Artistes' || $subVendorPackageName === 'Artistes') {
            $events = Event::with('category', 'images')
                ->where('user_id', $user->id)
                ->orderByDesc('start_date')
                ->take(3)
                ->get();

            $musics = Music::with('imagesRelation')
                ->where('user_id', $user->id)
                ->orderByDesc('id')
                ->get();

            $costumes = Costume::with('category')
                ->where('user_id', $user->id)
                ->orderByDesc('id')
                ->get();

            return view('ShopFrontend.artist.detail', compact(
                'events',
                'vendor',
                'categories',
                'products',
                'ads',
                'subvendors',
                'user',
                'musics',
                'user',
                'costumes'
            ));
        }

        return view('ShopFrontend.vendor-detail', compact(
            'vendor',
            'categories',
            'products',
            'ads',
            'subvendors',
            'user',
            'investors',
            'carnival_commitee',
            'user',
            'all_categories',
            'carnival'
        ));
    }

    // public function vendor_detail($slug)
    // {
    //     $user = User::with('banners')->whereSlug($slug)->first();
    //     if ($user->carnivals) {
    //         $carnival = Carnival::with('mascamps', 'members')->where('head', $user->id)->first();
    //     } else {
    //         $carnival = null;
    //     }
    //     $vendor = Vendor::with('user', 'products', 'products.category', 'gallery')->where('user_id', $user->id)->first();
    //     $subvendors = SubVendor::with('products', 'products.category')->where('vendor_id', $user->id)->get();
    //     // dd($subvendors->toArray());
    //     if ($vendor) {
    //         $categories = $vendor->products->pluck('category')->unique('id');
    //         $products = Product::where('user_id', $user->id)->with('brand')->get();
    //     }
    //     else {
    //         $categories = [];
    //         $products = [];
    //     }
    //     $ads = Advertisement::where('status', 1)->take(2)->get();
    //     $vendorPackageName = optional($user->vendor?->package)->title;
    //     $subVendorPackageName = optional($user->subVendor?->package)->title;

    //     if ($vendorPackageName === 'Artistes' || $subVendorPackageName === 'Artistes') {
    //         $events = Event::with('category', 'images')->where('user_id', $user->id)->orderBy('start_date', 'DESC')->take(3)->get();
    //         $musics = Music::with('imagesRelation')->where('user_id', $user->id)->orderBy('id', 'DESC')->get();
    //         $costumes = Costume::with('category')->where('user_id', $user->id)->orderBy('id', 'DESC')->get();
    //         return view('ShopFrontend.artist.detail', compact('events', 'vendor', 'categories', 'products', 'ads', 'subvendors', 'user', 'musics', 'costumes'));
    //     } else {
    //         return view('ShopFrontend.vendor-detail', compact('vendor', 'categories', 'products', 'ads', 'subvendors', 'user', 'carnival'));
    //     }
    // }

    public function get_vendor_products($slug, Request $request)
    {
        $products = Product::where('user_id', $slug);
        $getSearchVal = $request->get('getSearchVal', null);

        if ($request->has('cat') && $request->cat != 0) {
            $products = $products->where('category_id', $request->cat);
        }
        if ($request->has('subcat') && $request->subcat != 0) {
            $products = $products->where('subcategory_id', $request->subcat);
        }

        // Handle gender-based filtering
        // if ($request->has('gender')) {
        //     $gender = $request->gender;
        //     switch ($gender) {
        //         case 'women':
        //             $products = $products->where('women', 1);
        //             break;
        //         case 'men':
        //             $products = $products->where('men', 1);
        //             break;
        //         case 'kids':
        //             $products = $products->where('kids', 1);
        //             break;
        //         case 'accessories':
        //             $products = $products->where('accessories', 1);
        //             break;
        //     }
        // }

        if ($request->has('attribute') && $request->attribute == 'bestSale') {
            // Best seller logic can be added here
        }
        if ($request->has('attribute') && $request->attribute == 'onsale') {
            $products = $products->where('sale', true);
        }
        if ($request->has('attribute') && $request->attribute == 'new') {
            // New arrivals logic can be added here
        }

        if (!empty($getSearchVal)) {
            $products->where('title', 'like', '%' . $getSearchVal . '%');
        }
        $products = $products->orderBy('id', 'DESC')->take(5)->get();

        return $products;
    }
    public function get_subVendors(Request $request)
    {
        $vendors = SubVendor::with([
            'user' => function ($query) {
                $query->select('id', 'first_name', 'last_name', 'slug');
            },
            'vendor' => function ($query) {
                $query->where('package_id', 8);
            },
            'user.products' => function ($query) {
                $query->select('user_id', DB::raw('MIN(new_price) as min_price'), DB::raw('MAX(new_price) as max_price'))
                    ->groupBy('user_id');
            }
        ])
            ->orderBy('id', 'DESC')
            ->paginate(18);

        return $vendors;
    }
    public function sub_vendor_detail($slug)
    {
        $user = User::whereSlug($slug)->first();

        if (!$user) {
            return redirect()->back()->with('error', 'User not found');
        }

        $subvendor = SubVendor::with('products', 'products.category', 'products.features')
            ->where('user_id', $user->id)
            ->first();

        if (!$subvendor) {
            return redirect()->back()->with('error', 'Subvendor not found');
        }

        $categories = $subvendor->products->pluck('category')->unique('id');
        $products = Product::where('user_id', $user->id)->with('brand')->get();
        $brands = Brand::where('status', 1)->take(2)->get();
        $ads = Advertisement::where('status', 1)->take(2)->get();

        return view('ShopFrontend.subvendor-detail', compact('user', 'subvendor', 'categories', 'products', 'brands', 'ads'));
    }
    public function carnivalViewMoreSearch(Request $request)
    {
        $query = $request->query ? $request->query : '';

        if (!$query) {
            return redirect()->back();
        }

        $latestUpcoming = Carnival::where('city_id', $request->city_id)
            ->orderBy('start_date', 'desc')
            ->first();

        if (!$latestUpcoming) {
            $latestUpcoming = Carnival::where('country_id', $request->country_id)
                ->orderBy('start_date', 'desc')
                ->first();
        }

        if ($latestUpcoming) {
            return redirect()->route('events.view.more', ['slug' => $latestUpcoming->id]);
        }

        return redirect()->back();
    }
    public function eventViewMore(Request $request, $slug)
    {
        $carnivals = Carnival::with('country_tabs', 'images')->find($slug);

        if (!$carnivals) {
            return redirect()->back()->with('error', 'Carnival not found');
        }

        $products = Product::with('brand')->get();
        $blogs = Blogs::with('user')->orderBy('id', 'DESC')->get()->take('3');
        $all_blogs = Blogs::with('user')->orderBy('id', 'DESC')->paginate(12);
        $cities = City::all();
        $countries = Country::all();

        return view('front.view_more', compact('carnivals', 'products', 'blogs', 'all_blogs', 'cities', 'countries'));
    }

    public function getDiscounted(Request $request)
    {
        if (!$request->has('discount')) {
            return response()->json(['error' => 'Discount parameter is required'], 400);
        }

        $discounted_products = Product::where('discount', '<=', $request->discount)->take(10)->get();
        return $discounted_products;
    }

    public function about_us($slug)
    {
        $user = User::with('vendor', 'subVendor', 'products')->whereSlug($slug)->first();

        if (!$user) {
            return redirect()->back()->with('error', 'User not found');
        }

        $event = Event::with('category', 'images')->first();

        if (!$event) {
            return redirect()->back()->with('error', 'No events found');
        }

        $related = Event::with('user')
            ->where('category_id', $event->category_id)
            ->where('user_id', $event->user_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->get();

        $vendorPackageName = optional($user->vendor?->package)->title;
        $subVendorPackageName = optional($user->subVendor?->package)->title;
        $products = Product::with('brand')->get();
        $brands = Brand::where('status', 1)
            ->withCount('products')
            ->get();

        if ($vendorPackageName === 'Models' || $subVendorPackageName === 'Models' || $vendorPackageName === 'Artistes' || $subVendorPackageName === 'Artistes') {
            return view('ShopFrontend.model.detail', compact('event', 'user', 'products', 'brands'));
        } else {
            return view('ShopFrontend.vendorAboutUs', compact('user'));
        }
    }

    public function myEvents($slug)
    {
        $banners = Banner::where('type', 'mascamps')->get();
        $user = User::with('vendor', 'subVendor')->whereSlug($slug)->first();

        if (!$user) {
            return redirect()->back()->with('error', 'User not found');
        }

        $events = Event::with('category')->where('user_id', $user->id)->get();
        $regions = Region::with('countries')->OrderBy('placement', 'ASC')->get();
        $cat1 = Category::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $cat2 = Category::where('status', 1)
            ->whereNotIn('id', $cat1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $cat3 = Category::where('status', 1)
            ->whereNotIn('id', $cat1->pluck('id')->merge($cat2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('ShopFrontend.vendorEvents', compact('user', 'events', 'banners', 'cat1', 'cat2', 'cat3', 'regions'));
    }

    public function myGallery($slug)
    {
        $user = User::with('vendor', 'subVendor')->whereSlug($slug)->first();
        // $siteGallery = SiteGallery::where('user_id', $user->id)
        $siteGallery = GalleryAlbum::with('images')->where('user_id', $user->id)
            ->get();

        return view('ShopFrontend.vendorGallery', compact('user', 'siteGallery'));
    }
    public function getAlbumImgs(Request $request)
    {
        $siteGallery = GalleryAlbum::with('images')->where('id', $request->id)
            ->first();
        return $siteGallery;
    }

    public function getAlbumMusic(Request $request)
    {
        $siteGallery = Music::with('imagesRelation')->where('id', $request->id)
            ->first();
        return $siteGallery;
    }

    public function get_events(Request $request)
    {
        $regionId = $request->get('getRegion');
        $event_type = $request->get('event_type');
        $getSearchVal = $request->get('getSearchVal', null);
        $carnivalEvents = $request->get('carnivalEvents');

        $query = Event::with('images', 'tickets', 'User', 'country');
        if ($request->has('categories') && !empty($request->categories)) {
            $query->whereIn('category_id', $request->categories);
        }
        if (!is_null($event_type)) {
            $query->where('all_day', 1);
        }

        if (!empty($getSearchVal)) {
            $query->where('name', 'like', '%' . $getSearchVal . '%');
        }

        if ($request->filled('brands')) {
            $query->whereIn('venue', $request->brands);
        }

        // if ($request->filled('carnivalEvents')) {
        //     $carnival = Carnival::where('slug', $carnivalEvents)->first();
        //     // $carnival = $carnival->packageVendors('Events')->pluck('id');
        //     $carnival = $carnival->packageVendors('Events');
        //     dd($carnival->toArray(), $query->get()->pluck('id')->toArray());
        //     $query->whereIn('id', $carnival);
        // }

        if ($request->filled('carnivalEvents')) {
            $carnival = Carnival::where('slug', $carnivalEvents)->first();

            if ($carnival) {
                $vendors = $carnival->packageVendors('Events');
                $vendorUserIds = $vendors->pluck('user_id')->unique();
                // dd($vendors->toArray(), $vendorUserIds->toArray());

                $query->whereIn('user_id', $vendorUserIds);
            }
        }

        if ($request->filled('price_ranges')) {
            $price_ranges = is_array($request->price_ranges) ? $request->price_ranges : json_decode($request->price_ranges, true);

            if (is_array($price_ranges)) {  // Ensure it's an array before looping
                $query->whereHas('tickets', function ($q) use ($price_ranges) {
                    $q->whereIn('id', function ($subQuery) {
                        $subQuery->selectRaw('MIN(id)')
                            ->from('event_tickets')
                            ->whereColumn('event_tickets.event_id', 'events.id')
                            ->groupBy('event_tickets.event_id');
                    });

                    $q->where(function ($priceQuery) use ($price_ranges) {
                        foreach ($price_ranges as $range) {
                            $min = (float) ($range['min'] ?? 0);
                            $max = (float) ($range['max'] ?? PHP_INT_MAX);
                            $priceQuery->orWhereBetween('price', [$min, $max]);
                        }
                    });
                });
            }
        }

        // dd($request->toArray(), $query->get()->count());

        $events = $query->orderBy('id', 'DESC')->paginate(18);
        return $events;
    }

    public function myEventDetail($event_slug)
    {
        $event = Event::with('category', 'images')
            ->whereSlug($event_slug)
            ->first();

        if (!$event) {
            return redirect()->back()->with('error', 'Event not found');
        }

        $related = Event::with('user')
            ->where('category_id', $event->category_id)
            ->where('user_id', $event->user_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->get();

        $same_cat = Event::with('user')
            ->where('category_id', $event->category_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->take(9)
            ->get();

        return view('ShopFrontend.vendorEventDetails', compact('event', 'related', 'same_cat'));
    }

    public function modelListing()
    {
        $mascamp_banners = Banner::where('type', 'mascamps')->get();
        $regions = Region::OrderBy('placement', 'ASC')->get();
        $adv1 = Advertisement::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv2 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv3 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id')->merge($adv2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('ShopFrontend.model.listing', compact('regions', 'mascamp_banners', 'adv1', 'adv2', 'adv3'));
    }
    public function modelDetail($slug)
    {
        $user = User::with('vendor', 'events')->whereSlug($slug)->first();
        $event = Event::with('category', 'images')
            ->first();
        $related = Event::with('user')->where('category_id', $event->category_id)
            ->where('user_id', $event->user_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->get();
        $same_cat = Event::with('user')->where('category_id', $event->category_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->take(9)
            ->get();

        return view('ShopFrontend.model.detail', compact('event', 'related', 'same_cat', 'user'));
    }
    public function artistListing()
    {
        $mascamp_banners = Banner::where('type', 'mascamps')->get();
        $regions = Region::OrderBy('placement', 'ASC')->get();
        $adv1 = Advertisement::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv2 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv3 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id')->merge($adv2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('ShopFrontend.artist.listing', compact('regions', 'mascamp_banners', 'adv1', 'adv2', 'adv3'));
    }
    public function artistDetail($slug)
    {
        $user = User::with('vendor', 'events')->whereSlug($slug)->first();
        $event = Event::with('category', 'images')
            ->first();
        $related = Event::with('user')->where('category_id', $event->category_id)
            ->where('user_id', $event->user_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->get();
        $same_cat = Event::with('user')->where('category_id', $event->category_id)
            ->where('id', '!=', $event->id)
            ->orderBy('id', 'DESC')
            ->take(9)
            ->get();

        return view('ShopFrontend.artist.detail', compact('event', 'related', 'same_cat', 'user'));
    }
    public function musicDetail($slug)
    {
        $music = Music::where('id', $slug)->first();
        $related_music = Music::where('user_id', $music->user_id)->get();
        $user = User::with('vendor', 'events')->where('id', $music->user_id)->first();
        $products = Product::with('brand')->get();
        $brands = Brand::where('status', 1)
            ->withCount('products')
            ->get();
        return view('ShopFrontend.artist.music-detail', compact('products', 'brands', 'music', 'related_music', 'user'));
    }

    public function get_music(Request $request)
    {
        $query = Music::with('imagesRelation');
        $getSearchVal = $request->get('getSearchVal', null);

        if ($request->has('artiste_name') && !empty($request->artiste_name)) {
            $query->where('artiste_name', 'like', '%' . $request->artiste_name . '%');
        }

        if (!empty($getSearchVal)) {
            $query->where('real_name', 'like', '%' . $getSearchVal . '%')
                ->orWhere('producer', 'like', '%' . $getSearchVal . '%')
                ->orWhere('writer', 'like', '%' . $getSearchVal . '%')
                ->orWhere('song_title', 'like', '%' . $getSearchVal . '%');
        }

        if ($request->has('real_name') && !empty($request->real_name)) {
            $query->where('real_name', 'like', '%' . $request->real_name . '%');
        }

        if ($request->has('producer') && !empty($request->producer)) {
            $query->where('producer', 'like', '%' . $request->producer . '%');
        }

        if ($request->has('writer') && !empty($request->writer)) {
            $query->where('writer', 'like', '%' . $request->writer . '%');
        }

        if ($request->has('song_title') && !empty($request->song_title)) {
            $query->where('song_title', 'like', '%' . $request->song_title . '%');
        }

        if ($request->has('release_date') && !empty($request->release_date)) {
            $query->whereDate('release_date', $request->release_date);
        }

        if ($request->has('country') && !empty($request->country)) {
            $query->where('country', $request->country);
        }

        if ($request->has('region') && !empty($request->region)) {
            $query->where('region', $request->region);
        }

        if ($request->has('event_id') && !empty($request->event_id)) {
            $query->where('event_id', $request->event_id);
        }

        if ($request->has('for_sale') && $request->for_sale !== null) {
            $query->where('for_sale', $request->for_sale);
        }

        if ($request->has('price_min') && $request->has('price_max')) {
            $query->whereBetween('price', [$request->price_min, $request->price_max]);
        } elseif ($request->has('price_min')) {
            $query->where('price', '>=', $request->price_min);
        } elseif ($request->has('price_max')) {
            $query->where('price', '<=', $request->price_max);
        }

        $musics = $query->orderBy('id', 'DESC')->paginate(18);
        return $musics;
    }

    public function myMusicGallery($slug)
    {
        $user = User::with('vendor', 'subVendor')->whereSlug($slug)->first();
        $siteGallery = Music::with('imagesRelation')->has('imagesRelation')->where('user_id', $user->id)
            ->get();
        // dd($siteGallery->toArray(), $siteGallery[0]->imagesRelation->toArray());

        return view('ShopFrontend.vendorMusicGallery', compact('user', 'siteGallery'));
    }

    public function carnival_listing_all()
    {
        $mascamp_banners = Banner::where('type', 'mascamps')->get();
        $regions = Region::OrderBy('placement', 'ASC')->get();
        $adv1 = Advertisement::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv2 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv3 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id')->merge($adv2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('ShopFrontend.carnivals', compact('regions', 'mascamp_banners', 'adv1', 'adv2', 'adv3'));
    }

    public function shop_event_listing(Request $request)
    {
        $carnival = $request->carnival ?? null;
        $mascamp_banners = Banner::where('type', 'mascamps')->get();
        $regions = Region::OrderBy('placement', 'ASC')->get();
        $countries = Country::withCount('events')->with('events')->OrderBy('name', 'ASC')->get();
        $adv1 = Advertisement::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv2 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv3 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id')->merge($adv2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('ShopFrontend.events', compact('regions', 'mascamp_banners', 'adv1', 'adv2', 'adv3', 'countries', 'carnival'));
    }
    public function get_carnivals(Request $request)
    {
        $vendor_type = $request->get('vendor_type', null);
        $regionId = $request->get('getRegion');
        $carnival_commitee2 = Carnival::has('user')->get();
        $carnival_commitee = Carnival::has('user')->pluck('head');

        $query = Vendor::query()
            // ->whereIn('user_id', $carnival_commitee)
            ->whereHas('package', function ($query) {
                $query->where('title', 'Carnival Committee');
            })
            ->with([
                'package',
                'user' => function ($query) {
                    $query->select('id', 'first_name', 'last_name', 'slug', 'image');
                },
                'user.products' => function ($query) {
                    $query->select('user_id', DB::raw('MIN(new_price) as min_price'), DB::raw('MAX(new_price) as max_price'))
                        ->groupBy('user_id');
                },
            ]);

        if ($vendor_type) {
            $query->whereHas('package', function ($query) use ($vendor_type) {
                $query->where('title', $vendor_type);
            });
        }

        if ($regionId) {
            $query->where('continent', $regionId);
        }

        $vendors = $query->orderBy('id', 'DESC')->paginate(18);

        return $vendors;
    }

    public function carnival_detail($slug)
    {
        $carnival = Carnival::with('mascamps', 'members')->whereSlug($slug)->first();
        $user_id = $carnival->head;
        // dd($user_id);
        $vendor = Vendor::with('user', 'products', 'products.category', 'gallery')->where('user_id', $user_id)->first();
        $user = User::with('banners')->where('id', $user_id)->first();
        // dd($user, $user_id, $carnival->toArray());
        $blogs = Blogs::where('user_id', $user_id)->with('user')->orderBy('id', 'DESC')->get()->take('6');
        $subvendors = SubVendor::with('products', 'products.category')->where('vendor_id', $user->id)->get();
        // dd($subvendors->toArray());
        $categories = $vendor->products->pluck('category')->unique('id');
        $products = Product::where('user_id', $user->id)->with('brand')->get();
        $ads = Advertisement::where('status', 1)->take(2)->get();
        $vendorPackageName = optional($user->vendor?->package)->title;
        $subVendorPackageName = optional($user->subVendor?->package)->title;

        return view('ShopFrontend.carnival.detail', compact('carnival', 'vendor', 'categories', 'products', 'ads', 'subvendors', 'user'));
    }

    public function loadBannerDetails(Request $request)
    {
        $data = [];
        $type = $request->type;
        $carnival = Carnival::find($request->carnival_id);

        switch ($type) {
            case 'costume':
                $data = Costume::where('user_id', $carnival->head)->with('category')->orderBy('id', 'DESC')->get()->take('10');
                break;

            case 'events':
                $data = Event::where('user_id', $carnival->head)->with('images', 'tickets', 'country_tabs')->orderBy('id', 'desc')->get()->take('10');
                break;

                // default:
                //     // Optional: code for cases not matching 'costumes' or 'events'
                //     break;
        }

        return view('partials.banner_details', compact('type', 'data'));
    }

    public function getCarnivalThings(Request $request)
    {
        // dd($request->toArray());
        $selectedTab = $request->selectedTab;
        $carnivalId = $request->carnivalId;
        $things = '';

        if ($selectedTab == 'Events') {
            $things = Event::with('tickets')->orderBy('id', 'DESC')->take(3)->get();

            $things->map(function ($event) {
                $event->price = count($event->tickets) > 0 ? '$' . $event->tickets[0]->price . ' / person' : 'FREE';
                return $event;
            });
        }

        return response()->json(['things' => $things]);
    }

    public function cgGear_listing(Request $request)
    {
        // Retrieve products by admin users
        $products = Product::whereHas('user', function ($query) {
            $query->whereHas('role', function ($query) {
                $query->where('name', 'Admin');
            });
        })->take(30)->get();

        // Filter for best-seller products
        $bestSeller = $products->filter(function ($product) {
            return $product->sale > 100;
        });

        // Exclude best-seller products from the new arrivals
        $newArrivals = $products->whereNotIn('id', $bestSeller->pluck('id'))
            ->sortByDesc('created_at')
            ->take(16);

        // Exclude both best-seller and new-arrival products from the most-reviewed
        $mostReviews = $products->whereNotIn('id', $bestSeller->pluck('id'))
            ->whereNotIn('id', $newArrivals->pluck('id'))
            ->sortByDesc('reviews')
            ->take(16);

        return view('front.cgGear-listing', compact('products', 'bestSeller', 'newArrivals', 'mostReviews'));
    }

    // public function cgGear_listing(Request $request)
    // {
    //     $products = Product::whereHas('user', function ($query) {
    //         $query->whereHas('role', function ($query) {
    //             $query->where('name', 'Admin');
    //         });
    //     })->get()->take(30);

    //     $bestSeller = $products->filter(function ($product) {
    //         return $product->sale > 100;
    //     });

    //     $newArrivals = $products->sortByDesc('created_at')->take(16);

    //     $mostReviews = $products->sortByDesc('reviews')->take(16);

    //     return view('front.cgGear-isting', compact('products', 'bestSeller', 'newArrivals', 'mostReviews'));
    // }

    public function carnival_member($id)
    {
        $user = CarnivalMembers::where('id', $id)->first();

        return view('ShopFrontend.carnival_member', compact('user'));
    }

    public function brand_listing(Request $request)
    {
        $mascamp_banners = Banner::where('type', 'mascamps')->get();
        $regions = Region::OrderBy('placement', 'ASC')->get();
        $countries = Country::withCount('events')->with('events')->OrderBy('name', 'ASC')->get();
        $adv1 = Advertisement::where('status', 1)
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv2 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id'))
            ->inRandomOrder()
            ->take(3)
            ->get();

        $adv3 = Advertisement::where('status', 1)
            ->whereNotIn('id', $adv1->pluck('id')->merge($adv2->pluck('id')))
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('ShopFrontend.brands', compact('regions', 'mascamp_banners', 'adv1', 'adv2', 'adv3', 'countries'));
    }

    public function get_brands(Request $request)
    {
        $getSearchVal = $request->get('getSearchVal', null);

        $query = Brand::where('status', 1);

        if (!empty($getSearchVal)) {
            $query->where('title', 'like', '%' . $getSearchVal . '%');
        }

        $brands = $query->orderBy('id', 'DESC')->paginate(18);

        return $brands;
    }

    public function vendorByPhone($phone)
    {
        $vendor = Vendor::where('phone', $phone)
            ->orWhereHas('user', function ($query) use ($phone) {
                $query->where('phone', $phone);
            })
            ->first();

        return response()->json(['vendor' => $vendor]);
    }
}

• [D] Auth
• [D] SubVendor
• [D] Vendor
• [F] AddToCartController.php
  Delete
• [F] AdminController.php
  Delete
• [F] AdvertisementController.php
  Delete
• [F] AppointmentController.php
  Delete
• [F] BannerController.php
  Delete
• [F] BlogsController.php
  Delete
• [F] BrandController.php
  Delete
• [F] CarnivalCommitteeController.php
  Delete
• [F] CarnivalController.php
  Delete
• [F] CategoryController.php
  Delete
• [F] CityController.php
  Delete
• [F] ContactController.php
  Delete
• [F] Controller.php
  Delete
• [F] CostumeController.php
  Delete
• [F] CountryController.php
  Delete
• [F] CustomerController.php
  Delete
• [F] EventController.php
  Delete
• [F] EventsCountryTabController.php
  Delete
• [F] FAQController.php
  Delete
• [F] FAQPageController.php
  Delete
• [F] FeatureController.php
  Delete
• [F] FrontendConroller.php
  Delete
• [F] HomeController.php
  Delete
• [F] InvestorController.php
  Delete
• [F] ModelBookingController.php
  Delete
• [F] MusicController.php
  Delete
• [F] OrderController.php
  Delete
• [F] OurServiceController.php
  Delete
• [F] OurTeamController.php
  Delete
• [F] PackageController.php
  Delete
• [F] PackagePermissionController.php
  Delete
• [F] PaymentController.php
  Delete
• [F] PermissionsController.php
  Delete
• [F] ProductController.php
  Delete
• [F] RegionController.php
  Delete
• [F] RoleController.php
  Delete
• [F] RolePermissionController.php
  Delete
• [F] ServiceController.php
  Delete
• [F] SiteGalleryController.php
  Delete
• [F] StateController.php
  Delete
• [F] SubcategoryController.php
  Delete
• [F] SubscriberController.php
  Delete
• [F] SubVendorController.php
  Delete
• [F] SubvendorGalleryController.php
  Delete
• [F] TestimonialsController.php
  Delete
• [F] TicketController.php
  Delete
• [F] UserAccountDetailController.php
  Delete
• [F] UserManagementController.php
  Delete
• [F] VariantController.php
  Delete
• [F] VendorController.php
  Delete
• [F] VendorGalleryController.php
  Delete