@extends('layouts.app')
@section('title', 'Estatísticas')
@section('content')
    <div class="page-header"><h1 class="page-title">Estatísticas comerciais</h1></div>

    <div class="grid-cards" style="margin-bottom:1.5rem;">
        <div class="card tile"><span class="tile-meta">Sales Boxes abertas</span><span class="tile-title">{{ $salesBoxesOpened }}/{{ $salesBoxesTotal }}</span></div>
        <div class="card tile"><span class="tile-meta">Conteúdos nunca descarregados</span><span class="tile-title">{{ $neverUsedCount }}</span></div>
    </div>

    <div style="display:grid;grid-template-columns:1fr 1fr;gap:1.25rem;">
        <div>
            <h2 class="page-title" style="font-size:1.05rem;">Parceiros mais ativos</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table>
                    <thead><tr><th>Parceiro</th><th>Downloads</th><th>Último acesso</th></tr></thead>
                    <tbody>
                        @forelse ($topPartners as $p)
                            <tr>
                                <td><a href="{{ route('admin.partners.edit', $p) }}">{{ $p->name }}</a></td>
                                <td>{{ $p->downloads_count }}</td>
                                <td class="muted">{{ optional($p->last_access_at)->format('d/m/Y') ?? '—' }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="3" class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>

            <h2 class="page-title" style="font-size:1.05rem;">Parceiros inativos (sem downloads)</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table>
                    <thead><tr><th>Parceiro</th><th>Último acesso</th></tr></thead>
                    <tbody>
                        @forelse ($inactivePartners as $p)
                            <tr>
                                <td><a href="{{ route('admin.partners.edit', $p) }}">{{ $p->name }}</a></td>
                                <td class="muted">{{ optional($p->last_access_at)->format('d/m/Y') ?? 'Nunca' }}</td>
                            </tr>
                        @empty
                            <tr><td colspan="2" class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>

            <h2 class="page-title" style="font-size:1.05rem;">Downloads por país</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table><tbody>
                    @forelse ($downloadsByCountry as $row)
                        <tr><td>{{ $row->name }}</td><td style="text-align:right;">{{ $row->total }}</td></tr>
                    @empty
                        <tr><td class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                    @endforelse
                </tbody></table>
            </div>

            <h2 class="page-title" style="font-size:1.05rem;">Downloads por mercado (parceiro)</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table><tbody>
                    @forelse ($downloadsByPartnerMarket as $row)
                        <tr><td>{{ $row->name }}</td><td style="text-align:right;">{{ $row->total }}</td></tr>
                    @empty
                        <tr><td class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                    @endforelse
                </tbody></table>
            </div>
        </div>

        <div>
            <h2 class="page-title" style="font-size:1.05rem;">Downloads por hotel</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table><tbody>
                    @forelse ($downloadsByHotel as $row)
                        <tr><td>{{ $row->name }}</td><td style="text-align:right;">{{ $row->total }}</td></tr>
                    @empty
                        <tr><td class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                    @endforelse
                </tbody></table>
            </div>

            <h2 class="page-title" style="font-size:1.05rem;">Downloads por campanha</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table><tbody>
                    @forelse ($downloadsByCampaign as $row)
                        <tr><td>{{ $row->name }}</td><td style="text-align:right;">{{ $row->total }}</td></tr>
                    @empty
                        <tr><td class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                    @endforelse
                </tbody></table>
            </div>

            <h2 class="page-title" style="font-size:1.05rem;">Downloads por idioma</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table><tbody>
                    @forelse ($downloadsByLanguage as $row)
                        <tr><td>{{ $row->name }}</td><td style="text-align:right;">{{ $row->total }}</td></tr>
                    @empty
                        <tr><td class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                    @endforelse
                </tbody></table>
            </div>

            <h2 class="page-title" style="font-size:1.05rem;">Sales Kits mais utilizados</h2>
            <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
                <table><tbody>
                    @forelse ($topSalesKits as $k)
                        <tr><td><a href="{{ route('admin.sales-kits.edit', $k) }}">{{ $k->name }}</a></td><td style="text-align:right;">{{ $k->downloads_count }}</td></tr>
                    @empty
                        <tr><td class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                    @endforelse
                </tbody></table>
            </div>
        </div>
    </div>

    <h2 class="page-title" style="font-size:1.05rem;">Conteúdos mais procurados</h2>
    <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
        <table>
            <thead><tr><th>Material</th><th>Categoria</th><th>Downloads</th></tr></thead>
            <tbody>
                @forelse ($mostRequested as $m)
                    <tr>
                        <td><a href="{{ route('admin.materials.edit', $m) }}">{{ $m->title }}</a></td>
                        <td class="muted">{{ $m->category?->name }}</td>
                        <td>{{ $m->downloads_count }}</td>
                    </tr>
                @empty
                    <tr><td colspan="3" class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>

    <h2 class="page-title" style="font-size:1.05rem;">Conteúdos nunca utilizados</h2>
    <div class="card" style="padding:0.5rem 1rem;margin-bottom:1.25rem;">
        <table>
            <thead><tr><th>Material</th><th>Categoria</th><th>Criado em</th></tr></thead>
            <tbody>
                @forelse ($neverUsed as $m)
                    <tr>
                        <td><a href="{{ route('admin.materials.edit', $m) }}">{{ $m->title }}</a></td>
                        <td class="muted">{{ $m->category?->name }}</td>
                        <td class="muted">{{ $m->created_at->format('d/m/Y') }}</td>
                    </tr>
                @empty
                    <tr><td colspan="3" class="muted" style="padding:1rem;text-align:center;">Sem dados.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>

    <h2 class="page-title" style="font-size:1.05rem;">Sales Boxes sem interação</h2>
    <div class="card" style="padding:0.5rem 1rem;">
        <table>
            <thead><tr><th>Sales Box</th><th>Parceiro</th><th>Criada em</th></tr></thead>
            <tbody>
                @forelse ($salesBoxesNoInteraction as $b)
                    <tr>
                        <td><a href="{{ route('admin.sales-boxes.edit', $b) }}">{{ $b->name }}</a></td>
                        <td class="muted">{{ $b->partner?->name ?? '—' }}</td>
                        <td class="muted">{{ $b->created_at->format('d/m/Y') }}</td>
                    </tr>
                @empty
                    <tr><td colspan="3" class="muted" style="padding:1rem;text-align:center;">Todas as Sales Boxes já tiveram interação.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
@endsection