<?php

namespace App\Http\Controllers;

use App\Models\Newspaper;
use Illuminate\Http\Request;

class NewspaperController extends Controller
{
    public function show($date)
    {
        $newspaper = Newspaper::published()
            ->where('publish_date', $date)
            ->with(['pages' => fn($q) => $q->with('hotspots')->orderBy('sort_order')->orderBy('page_number')])
            ->firstOrFail();

        $allDates = Newspaper::published()
            ->orderByDesc('publish_date')
            ->pluck('publish_date')
            ->map(fn($d) => $d->format('Y-m-d'))
            ->toArray();

        // Group dates by year → month for archive sidebar
        $archiveTree = [];
        foreach ($allDates as $d) {
            [$y, $m] = explode('-', $d);
            $archiveTree[$y][$m][] = $d;
        }

        $previousEdition = Newspaper::published()
            ->where('publish_date', '<', $date)
            ->orderByDesc('publish_date')
            ->first();

        $nextEdition = Newspaper::published()
            ->where('publish_date', '>', $date)
            ->orderBy('publish_date')
            ->first();

        return view('frontend.reader', compact('newspaper', 'allDates', 'archiveTree', 'previousEdition', 'nextEdition'));
    }
}