@use('App\Core\Support\Money')
<x-layouts.admin title="Reports">
    <div class="mb-4 flex flex-wrap items-end justify-between gap-3">
        <form method="GET" class="flex items-end gap-2">
            <div>
                <label for="currency" class="block text-xs text-slate-500">Currency</label>
                <select id="currency" name="currency" class="mt-1 rounded-lg border border-slate-300 bg-white px-3 py-2 text-sm">
                    @foreach ($currencies as $c)
                        <option value="{{ $c }}" @selected($currency === $c)>{{ $c }}</option>
                    @endforeach
                </select>
            </div>
            <x-ui.button variant="secondary">Show</x-ui.button>
        </form>
        <x-ui.button variant="secondary" :href="route('admin.reports.csv', ['currency' => $currency])">Download CSV</x-ui.button>
    </div>

    <x-ui.card title="Revenue & registrations — last 12 months" :description="'Net revenue (payments less refunds) in '.$currency.'. All time: '.Money::format($totals['revenue'], $currency)">
        <div class="overflow-x-auto">
            <table class="min-w-full text-sm">
                <thead class="text-left text-xs uppercase tracking-wide text-slate-500">
                    <tr><th scope="col" class="py-2 pr-4">Month</th><th scope="col" class="py-2 pr-4 text-right">Registrations</th>
                        <th scope="col" class="py-2 pr-4 text-right">New paid subscriptions</th><th scope="col" class="py-2 pr-4 text-right">Payments</th>
                        <th scope="col" class="py-2 text-right">Net revenue</th></tr>
                </thead>
                <tbody class="divide-y divide-slate-100">
                    @foreach ($monthly as $row)
                        <tr>
                            <td class="py-2 pr-4">{{ $row['month'] }}</td>
                            <td class="py-2 pr-4 text-right tabular-nums">{{ number_format($row['registrations']) }}</td>
                            <td class="py-2 pr-4 text-right tabular-nums">{{ number_format($row['new_paid']) }}</td>
                            <td class="py-2 pr-4 text-right tabular-nums">{{ number_format($row['payments']) }}</td>
                            <td class="py-2 text-right tabular-nums">{{ Money::format($row['revenue'], $currency) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </x-ui.card>

    <x-ui.card title="Current subscriptions by plan" class="mt-6">
        <ul class="divide-y divide-slate-100 text-sm">
            @forelse ($byPlan as $row)
                <li class="flex justify-between py-2"><span>{{ $row['plan'] }}</span><span class="tabular-nums">{{ number_format($row['count']) }}</span></li>
            @empty
                <li class="py-2 text-slate-500">No subscriptions yet.</li>
            @endforelse
        </ul>
    </x-ui.card>
</x-layouts.admin>