<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Newspaper;
use App\Models\NewspaperPage;
use App\Models\Hotspot;

class DashboardController extends Controller
{
    public function index()
    {
        $stats = [
            'total_newspapers' => Newspaper::count(),
            'published' => Newspaper::where('status', 'published')->count(),
            'drafts' => Newspaper::where('status', 'draft')->count(),
            'total_pages' => NewspaperPage::count(),
            'total_hotspots' => Hotspot::count(),
        ];

        $recentNewspapers = Newspaper::with('pages')
            ->orderByDesc('publish_date')
            ->limit(5)
            ->get();

        return view('admin.dashboard', compact('stats', 'recentNewspapers'));
    }
}