@extends('admin.layout')
@section('title', 'Dashboard')
@section('content')

@php
$trialCount = $trialUsers->count();
$expiringCount = $expiring->count();
$activeCount = $stats['tenants_paying'] + $stats['tenants_trial'];
@endphp

<div style="display:grid;grid-template-columns:repeat(4,1fr);gap:14px;margin-bottom:24px">
    <div class="stat-card">
        <div class="stat-card-label">Total Tenants</div>
        <div class="stat-card-value">{{ $stats['tenants_total'] }}</div>
        <div class="stat-card-sub">{{ $stats['tenants_active'] }} active</div>
    </div>
    <div class="stat-card">
        <div class="stat-card-label">Paying Users</div>
        <div class="stat-card-value" style="color:var(--positive)">{{ $stats['tenants_paying'] }}</div>
        <div class="stat-card-sub">{{ $stats['tenants_trial'] }} on trial</div>
    </div>
    <div class="stat-card">
        <div class="stat-card-label">MRR</div>
        <div class="stat-card-value" style="color:var(--brand)">${{ number_format($stats['mrr'], 2) }}</div>
        <div class="stat-card-sub">Monthly recurring</div>
    </div>
    <div class="stat-card" style="border-color:var(--warning)">
        <div class="stat-card-label" style="color:var(--warning)">Expiring Soon</div>
        <div class="stat-card-value" style="color:var(--warning)">{{ $expiringCount }}</div>
        <div class="stat-card-sub">Within 7 days</div>
    </div>
</div>

{{-- Quick Email Buttons --}}
<div style="display:flex;gap:8px;margin-bottom:24px;flex-wrap:wrap">
    <form method="POST" action="{{ route('admin.email.send') }}" style="display:inline">
        @csrf
        <input type="hidden" name="trial_users" value="1">
        <input type="hidden" name="subject" value="Your Free Trial is Active — Let's Get Started!">
        <input type="hidden" name="message" value="Hi {name},

Welcome to Financial OS! Your 35-day free trial gives you full access to all premium features.

Get started: Add bank accounts, track transactions, set budgets.

Best, The Financial OS Team">
        <button class="btn btn-info btn-sm">Email Trial Users ({{ $trialCount }})</button>
    </form>
    <form method="POST" action="{{ route('admin.email.send') }}" style="display:inline">
        @csrf
        <input type="hidden" name="expiring_soon" value="1">
        <input type="hidden" name="subject" value="Your Subscription Expires Soon — Renew Today">
        <input type="hidden" name="message" value="Hi {name},

Your Financial OS subscription expires in 7 days. Renew to keep AI insights, bank reconciliation, and more.

Best, The Financial OS Team">
        <button class="btn btn-warning btn-sm">Email Expiring ({{ $expiringCount }})</button>
    </form>
    <form method="POST" action="{{ route('admin.email.send') }}" style="display:inline">
        @csrf
        <input type="hidden" name="all_active" value="1">
        <input type="hidden" name="subject" value="Important Update from Financial OS">
        <input type="hidden" name="message" value="Hi {name},

We have exciting updates to share...

Best, The Financial OS Team">
        <button class="btn btn-primary btn-sm">Email All Active ({{ $activeCount }})</button>
    </form>
</div>

{{-- Trial Users --}}
<div class="table-card" style="margin-bottom:20px">
    <div class="table-header">
        <div style="display:flex;align-items:center;gap:10px">
            <h3 style="font-size:14px;font-weight:600;color:var(--info)">Trial Users</h3>
            <span class="badge badge-info">{{ $trialCount }}</span>
        </div>
        <form method="POST" action="{{ route('admin.email.send') }}" style="display:inline">
            @csrf
            <input type="hidden" name="trial_users" value="1">
            <input type="hidden" name="subject" value="Your Financial OS Trial — Make the Most of It!">
            <input type="hidden" name="message" value="Hi {name},

You're on the Financial OS free trial with full access to AI insights, bank reconciliation, and family sharing.

Upgrade anytime from your dashboard.

Best, The Financial OS Team">
            <button class="btn btn-info btn-sm">Email All Trial</button>
        </form>
    </div>
    <table>
        <thead><tr><th>Tenant</th><th>Email</th><th>Trial Ends</th><th>Days Left</th></tr></thead>
        <tbody>
            @forelse($trialUsers as $t)
            @php $daysLeft = $t->trial_ends_at ? max(0, (int)now()->diffInDays(\Carbon\Carbon::parse($t->trial_ends_at), false)) : 0; @endphp
            <tr>
                <td style="font-weight:600">{{ $t->name }}</td>
                <td>{{ $t->users->first()->email ?? '—' }}</td>
                <td>{{ $t->trial_ends_at ? \Carbon\Carbon::parse($t->trial_ends_at)->format('M d, Y') : '—' }}</td>
                <td><span class="badge badge-{{ $daysLeft < 3 ? 'danger' : ($daysLeft < 7 ? 'warning' : 'info') }}">{{ $daysLeft }}d</span></td>
            </tr>
            @empty
            <tr><td colspan="4" style="text-align:center;padding:30px;color:var(--text-muted)">No trial users</td></tr>
            @endforelse
        </tbody>
    </table>
</div>

{{-- Expiring Soon --}}
<div class="table-card" style="margin-bottom:20px">
    <div class="table-header">
        <div style="display:flex;align-items:center;gap:10px">
            <h3 style="font-size:14px;font-weight:600;color:var(--warning)">Expiring Within 7 Days</h3>
            <span class="badge badge-warning">{{ $expiringCount }}</span>
        </div>
        <form method="POST" action="{{ route('admin.email.send') }}" style="display:inline">
            @csrf
            <input type="hidden" name="expiring_soon" value="1">
            <input type="hidden" name="subject" value="⚠ Your Financial OS Subscription Expires in 7 Days">
            <input type="hidden" name="message" value="Hi {name},

Your subscription expires soon. Renew to keep uninterrupted access.

Best, The Financial OS Team">
            <button class="btn btn-warning btn-sm">Send Reminder</button>
        </form>
    </div>
    <table>
        <thead><tr><th>Tenant</th><th>Plan</th><th>Email</th><th>Expires</th><th>Days</th></tr></thead>
        <tbody>
            @forelse($expiring as $t)
            @php $daysLeft = $t->subscription_ends_at ? max(0, (int)now()->diffInDays(\Carbon\Carbon::parse($t->subscription_ends_at), false)) : 0; @endphp
            <tr>
                <td style="font-weight:600">{{ $t->name }}</td>
                <td>{{ $t->plan->name ?? '—' }}</td>
                <td>{{ $t->users->first()->email ?? '—' }}</td>
                <td><span class="badge badge-danger">{{ \Carbon\Carbon::parse($t->subscription_ends_at)->format('M d') }}</span></td>
                <td><span class="badge badge-{{ $daysLeft < 2 ? 'danger' : 'warning' }}">{{ $daysLeft }}d</span></td>
            </tr>
            @empty
            <tr><td colspan="5" style="text-align:center;padding:30px;color:var(--text-muted)">No expiring subscriptions</td></tr>
            @endforelse
        </tbody>
    </table>
</div>

{{-- Recent & Plans --}}
<div style="display:grid;grid-template-columns:2fr 1fr;gap:18px">
    <div class="table-card">
        <div class="table-header"><h3 style="font-size:14px;font-weight:600">Recent Tenants</h3></div>
        <table>
            <thead><tr><th>Tenant</th><th>Plan</th><th>Status</th><th>Users</th></tr></thead>
            <tbody>
                @foreach($recent as $t)
                <tr>
                    <td style="font-weight:600">{{ $t->name }}</td>
                    <td>{{ $t->plan->name ?? '—' }}</td>
                    <td><span class="badge badge-{{ $t->subscription_status === 'active' ? 'success' : 'info' }}">{{ ucfirst($t->subscription_status) }}</span></td>
                    <td>{{ $t->users->count() }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    <div class="table-card">
        <div class="table-header"><h3 style="font-size:14px;font-weight:600">Plan Distribution</h3></div>
        <table>
            <thead><tr><th>Plan</th><th>Tenants</th></tr></thead>
            <tbody>
                @foreach($plans as $p)
                <tr><td style="font-weight:600">{{ $p->name }}</td><td><span class="badge badge-brand">{{ $p->tenants_count }}</span></td></tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection