<?php

namespace App\Http\Controllers\Frontend;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\{Language, Product, Banner, Category, Favorite};
use LaravelLocalization;
use Auth;

class HomeController extends Controller
{
    public function index()
    {
      $currentLanguage = LaravelLocalization::getCurrentLocale();

      $language_info = Language::where('code', $currentLanguage)->first();

      $special_products = Product::inRandomOrder()
                                  ->where('status', 1)
                                  ->where('sticker_id', '>',  0)
                                  ->with('category')
                                  ->with('subcategory')
                                  ->with('sticker')
                                  ->with('rates')
                                  ->withWhereHas('translation', fn($query) => $query->where('language', $currentLanguage))
                                  ->limit(8)
                                  ->get();

      $new_products = Product::where('status', 1)
                              ->with('category')
                              ->with('subcategory')
                              ->with('sticker')
                              ->with('rates')
                              ->withWhereHas('translation', fn($query) => $query->where('language', $currentLanguage))
                              ->orderBy('id', 'desc')
                              ->limit(8)
                              ->get();

      $favorites = Favorite::where('user_id', Auth::id())->get();

      return view('layouts.frontend.pages.home', compact('new_products', 'special_products', 'currentLanguage', 'language_info', 'favorites'));
    }
}