<?php

namespace App\Http\Controllers\Frontend;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\{Page, Product, Category};

class SitemapController extends Controller
{
    public function index(){
      $products = Product::filter(request(['code', 'price', 'sorting', 'type']))
                        ->where('status', 1)
                        ->with('category')
                        ->with('subcategory')
                        ->with('sticker')
                        ->withWhereHas('translation', fn($query) => $query->where('language', 'bg'))
                        ->whereNotIn('mcat_id', ['257'])
                        ->orderBy('id', 'desc')
                        ->get();


      $pages = Page::latest()->
      withWhereHas('translation',
        fn($query) => $query->select('*')->where('language', 'bg')
      )
      ->where('status', 1)
      ->get();

      return response()->view('layouts.frontend.pages.sitemap', compact('products', 'pages'))->header('Content-Type', 'text/xml');
    }
}