<?php

namespace App\Http\Controllers;

use App\Models\Category;
use App\Models\Item;
use Illuminate\Http\Response;

class SitemapController extends Controller
{
    public function index(): Response
    {
        $items = Item::select(['id', 'updated_at'])
            ->where('status', 'active')
            ->whereIn('listing_type', ['sale', 'inventory_open'])
            ->whereHas('user', fn($q) => $q->where('is_active', true))
            ->orderBy('updated_at', 'desc')
            ->get();

        $categories = Category::select(['id', 'updated_at'])
            ->where('is_active', true)
            ->orderBy('name')
            ->get();

        return response(
            view('sitemap', compact('items', 'categories'))->render(),
            200,
            ['Content-Type' => 'application/xml; charset=utf-8']
        );
    }
}