@extends('layouts.app')
@section('title', 'Dashboard')

@section('content')

<div class="row g-4 mb-4">
    <div class="col-sm-6 col-xl-3">
        <div class="card h-100">
            <div class="card-body d-flex align-items-center">
                <div class="flex-shrink-0">
                    <div class="bg-primary bg-opacity-10 rounded-3 p-3">
                        <i class="fa-solid fa-users text-primary fs-4"></i>
                    </div>
                </div>
                <div class="flex-grow-1 ms-3">
                    <h6 class="text-muted mb-1">Total Users</h6>
                    <h3 class="mb-0">{{ number_format($counts['users']) }}</h3>
                </div>
            </div>
        </div>
    </div>
    <div class="col-sm-6 col-xl-3">
        <div class="card h-100">
            <div class="card-body d-flex align-items-center">
                <div class="flex-shrink-0">
                    <div class="bg-warning bg-opacity-10 rounded-3 p-3">
                        <i class="fa-solid fa-credit-card text-warning fs-4"></i>
                    </div>
                </div>
                <div class="flex-grow-1 ms-3">
                    <h6 class="text-muted mb-1">Subscriptions</h6>
                    <h3 class="mb-0">{{ number_format($counts['subscriptions']) }}</h3>
                </div>
            </div>
        </div>
    </div>
    <div class="col-sm-6 col-xl-3">
        <div class="card h-100">
            <div class="card-body d-flex align-items-center">
                <div class="flex-shrink-0">
                    <div class="bg-info bg-opacity-10 rounded-3 p-3">
                        <i class="fa-solid fa-dollar-sign text-info fs-4"></i>
                    </div>
                </div>
                <div class="flex-grow-1 ms-3">
                    <h6 class="text-muted mb-1">Revenue</h6>
                    <h3 class="mb-0">${{ number_format($counts['totalRevenue'], 2) }}</h3>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row g-4 mb-4">
    <div class="col-sm-6 col-xl-3">
        <div class="card h-100">
            <div class="card-body d-flex align-items-center">
                <div class="flex-shrink-0">
                    <div class="bg-success bg-opacity-10 rounded-3 p-3">
                        <i class="fa-solid fa-lock text-success fs-4"></i>
                    </div>
                </div>
                <div class="flex-grow-1 ms-3">
                    <h6 class="text-muted mb-1">OpenVPN</h6>
                    <h3 class="mb-0">{{ number_format($counts['openvpnServers']) }}</h3>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row g-4">
    <div class="col-lg-6">
        <div class="card h-100">
            <div class="card-header bg-transparent">
                <div class="d-flex justify-content-between align-items-center">
                    <h5 class="mb-0">Latest Users</h5>
                    <a href="{{ route('admin.userList') }}" class="btn btn-sm btn-primary">View All</a>
                </div>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-hover mb-0">
                        <thead class="table-light">
                            <tr>
                                <th class="border-0 py-3 ps-4">User</th>
                                <th class="border-0 py-3">Status</th>
                                <th class="border-0 py-3 text-center pe-4">Joined</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($counts['latestUsers'] as $user)
                            <tr>
                                <td class="py-3 ps-4">
                                    <div class="d-flex align-items-center">
                                        <div class="flex-shrink-0">
                                            <div class="avatar avatar-sm bg-primary text-white rounded-circle">
                                                {{ strtoupper(substr($user->name, 0, 1)) }}
                                            </div>
                                        </div>
                                        <div class="flex-grow-1 ms-3">
                                            <h6 class="mb-0">{{ $user->name }}</h6>
                                            <small class="text-muted">{{ $user->email }}</small>
                                        </div>
                                    </div>
                                </td>
                                <td class="py-3">
                                    @if($user->isPremium == 1)
                                        <span class="badge bg-warning text-dark">Premium</span>
                                    @else
                                        <span class="badge bg-secondary">Free</span>
                                    @endif
                                </td>
                                <td class="py-3 text-center text-muted pe-4">
                                    {{ $user->created_at->format('M d, Y') }}
                                </td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="3" class="text-center py-4 text-muted">
                                    No users found
                                </td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div class="col-lg-6">
        <div class="card h-100">
            <div class="card-header bg-transparent">
                <div class="d-flex justify-content-between align-items-center">
                    <h5 class="mb-0">Latest Subscriptions</h5>
                    <a href="{{ route('admin.orders') }}" class="btn btn-sm btn-success">View All</a>
                </div>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-hover mb-0">
                        <thead class="table-light">
                            <tr>
                                <th class="border-0 py-3 ps-4">User</th>
                                <th class="border-0 py-3">Plan</th>
                                <th class="border-0 py-3 text-center pe-4">Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($counts['latestOrders'] as $order)
                            <tr>
                                <td class="py-3 ps-4">
                                    <div class="d-flex align-items-center">
                                        <div class="flex-shrink-0">
                                            <div class="avatar avatar-sm bg-success text-white rounded-circle">
                                                {{ strtoupper(substr($order->name, 0, 1)) }}
                                            </div>
                                        </div>
                                        <div class="flex-grow-1 ms-3">
                                            <h6 class="mb-0">{{ $order->name }}</h6>
                                            <small class="text-muted">{{ $order->email }}</small>
                                        </div>
                                    </div>
                                </td>
                                <td class="py-3">
                                    <span class="badge" style="background: rgba(233, 69, 96, 0.1); color: #e94560;">
                                        {{ $order->pakage_name }}
                                    </span>
                                </td>
                                <td class="py-3 text-center">
                                    <span class="text-success fw-semibold">${{ number_format($order->price, 2) }}</span>
                                </td>
                            </tr>
                            @empty
                            <tr>
                                <td colspan="3" class="text-center py-4 text-muted">
                                    No subscriptions found
                                </td>
                            </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('style')
<style>
.avatar {
    width: 36px;
    height: 36px;
    display: flex;
    align-items: center;
    justify-content: center;
    font-weight: 600;
    font-size: 14px;
}
</style>
@endpush