@extends('layouts.app')
@section('title', 'Dashboard Financeiro - ERP-PLUS')
@section('page_title', 'Dashboard Financeiro')
@section('page_subtitle', 'Visao geral das receitas e assinaturas.')

@push('styles')
<style>
    .fin-grid { display: grid; grid-template-columns: repeat(auto-fit, minmax(180px, 1fr)); gap: 16px; margin-bottom: 24px; }
    .fin-card { background: var(--surface); border: 1px solid var(--border); border-radius: 10px; padding: 20px 18px; }
    .fin-card .label { font-size: 11px; font-weight: 700; text-transform: uppercase; color: var(--muted); margin-bottom: 6px; }
    .fin-card .value { font-size: 28px; font-weight: 700; color: var(--text); line-height: 1.1; }
    .fin-card .sub   { font-size: 12px; color: var(--muted); margin-top: 4px; }
    .fin-card.primary .value { color: var(--primary); }
    .fin-card.ok    .value { color: #15803d; }
    .fin-card.warn  .value { color: #a16207; }
</style>
@endpush

@section('content')

@if (session('status'))
    <div class="notice" style="margin-bottom:16px">{{ session('status') }}</div>
@endif

{{-- KPIs --}}
<div class="fin-grid">
    <div class="fin-card primary">
        <div class="label">MRR (Receita mensal recorrente)</div>
        <div class="value">R$ {{ number_format($mrr, 2, ',', '.') }}</div>
        <div class="sub">Assinaturas ativas</div>
    </div>
    <div class="fin-card ok">
        <div class="label">Recebido no mes</div>
        <div class="value">R$ {{ number_format($receivedMonth, 2, ',', '.') }}</div>
        <div class="sub">{{ now()->translatedFormat('F Y') }}</div>
    </div>
    <div class="fin-card warn">
        <div class="label">Cobranças pendentes</div>
        <div class="value">R$ {{ number_format($pendingTotal, 2, ',', '.') }}</div>
        <div class="sub">Aguardando pagamento</div>
    </div>
    <div class="fin-card">
        <div class="label">Assinaturas ativas</div>
        <div class="value">{{ $activeCount }}</div>
        <div class="sub">{{ $trialCount }} em trial · {{ $expiredCount }} expiradas</div>
    </div>
</div>

{{-- Distribuição por plano --}}
<div style="display:grid;grid-template-columns:1fr 1fr;gap:18px;margin-bottom:24px">
    <div class="panel">
        <div class="panel-header">
            <div><h2>Assinaturas por plano</h2></div>
        </div>
        <div style="padding:16px;display:flex;flex-direction:column;gap:10px">
            @forelse ($byPlan as $row)
                @php $plan = $plans->firstWhere('id', $row->plan_id); @endphp
                <div style="display:flex;justify-content:space-between;align-items:center;font-size:14px">
                    <span>{{ $plan?->name ?? 'Plano #'.$row->plan_id }}</span>
                    <div style="display:flex;align-items:center;gap:10px">
                        <span style="font-weight:700">{{ $row->total }}</span>
                        <span style="color:var(--muted);font-size:12px">
                            R$ {{ number_format((float)($plan?->price ?? 0) * $row->total, 2, ',', '.') }}/mes
                        </span>
                    </div>
                </div>
                @php
                    $pct = $activeCount > 0 ? ($row->total / $activeCount * 100) : 0;
                @endphp
                <div style="background:var(--bg);border-radius:4px;height:6px">
                    <div style="background:var(--primary);height:6px;border-radius:4px;width:{{ number_format($pct, 1) }}%"></div>
                </div>
            @empty
                <div class="empty">Nenhuma assinatura ativa.</div>
            @endforelse
        </div>
    </div>

    <div class="panel">
        <div class="panel-header">
            <div><h2>Acoes rapidas</h2></div>
        </div>
        <div style="padding:16px;display:flex;flex-direction:column;gap:10px">
            <a class="button primary" href="{{ route('subscription.admin') }}" style="text-align:center">
                Gerenciar assinaturas
            </a>
            <a class="button" href="{{ route('subscription.charges') }}" style="text-align:center">
                Ver todas as cobranças
            </a>
            <a class="button" href="{{ route('plans.index') }}" style="text-align:center">
                Gerenciar planos
            </a>
            <a class="button" href="{{ route('email-logs.index') }}" style="text-align:center">
                Historico de e-mails
            </a>
        </div>
    </div>
</div>

{{-- Ultimas cobranças --}}
<div class="panel">
    <div class="panel-header">
        <div>
            <h2>Ultimas cobranças</h2>
            <span>{{ $recentCharges->total() }} total</span>
        </div>
        <a class="button" href="{{ route('subscription.charges') }}">Ver todas</a>
    </div>
    <div class="table-wrap">
        <table>
            <thead>
                <tr>
                    <th>Data</th>
                    <th>Empresa</th>
                    <th>Plano</th>
                    <th>Valor</th>
                    <th>Vencimento</th>
                    <th>Status</th>
                    <th></th>
                </tr>
            </thead>
            <tbody>
                @forelse ($recentCharges as $charge)
                    <tr>
                        <td style="white-space:nowrap;font-size:12px">{{ $charge->created_at->format('d/m/Y H:i') }}</td>
                        <td>{{ $charge->company?->name ?? '-' }}</td>
                        <td>{{ $charge->subscription?->plan?->name ?? '-' }}</td>
                        <td>R$ {{ number_format((float) $charge->amount, 2, ',', '.') }}</td>
                        <td>{{ $charge->due_date?->format('d/m/Y') ?? '-' }}</td>
                        <td>
                            @php
                                $pill = match ($charge->status) {
                                    'received' => 'ok',
                                    'pending'  => 'warn',
                                    'refunded' => 'neutral',
                                    default    => '',
                                };
                            @endphp
                            <span class="pill {{ $pill }}">{{ mb_strtoupper($charge->status) }}</span>
                        </td>
                        <td>
                            @if ($charge->invoice_url)
                                <a class="button" href="{{ $charge->invoice_url }}" target="_blank" style="font-size:12px;min-height:28px;padding:3px 10px">Link</a>
                            @endif
                        </td>
                    </tr>
                @empty
                    <tr><td colspan="7"><div class="empty">Nenhuma cobranca encontrada.</div></td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
    @if ($recentCharges->hasPages())
        <div style="padding:12px 16px;border-top:1px solid var(--border)">
            {{ $recentCharges->links() }}
        </div>
    @endif
</div>
@endsection