How We Built an AI-Powered Editorial Publishing Platform with Laravel, Multi-Role Workflows and SEO Automation

<?php

declare(strict_types=1);

namespace App\Http\Controllers;

use App\Enums\PostStatus;
use App\Models\Post;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\Cache;

final class SitemapController extends Controller
{
    public function __invoke(): Response
    {
        $xml = Cache::remember('sitemap.xml', now()->addHour(), function (): string {
            $writer = new \XMLWriter();
            $writer->openMemory();
            $writer->startDocument('1.0', 'UTF-8');
            $writer->startElement('urlset');
            $writer->writeAttribute('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9');
            $writer->writeAttribute('xmlns:xhtml', 'http://www.w3.org/1999/xhtml');

            Post::query()
                ->where('status', PostStatus::Published)
                ->with('translations:id,translation_group_id,locale,slug')
                ->orderBy('id')
                ->chunkById(1000, function ($posts) use ($writer): void {
                    foreach ($posts as $post) {
                        $writer->startElement('url');
                        $writer->writeElement('loc', route('posts.show', $post->slug));
                        $writer->writeElement('lastmod', $post->updated_at->toAtomString());

                        foreach ($post->translations as $alt) {
                            $writer->startElement('xhtml:link');
                            $writer->writeAttribute('rel', 'alternate');
                            $writer->writeAttribute('hreflang', $alt->locale);
                            $writer->writeAttribute('href', route('posts.show', $alt->slug));
                            $writer->endElement();
                        }

                        $writer->endElement(); // url
                    }
                });

            $writer->endElement(); // urlset
            $writer->endDocument();

            return $writer->outputMemory();
        });

        return response($xml, 200, ['Content-Type' => 'application/xml']);
    }
}