@extends('admin.layout.app')

@section('title', 'Admin Dashboard')

@section('content')
@php
    $categoryCount = \DB::table('categories')->count();
    $subcategoryCount = \DB::table('sub_categories')->count();
    $productCount = \DB::table('products')->count();
    $orderCount = \DB::table('orders')->count();
    $userCount = \DB::table('users')->count();
    $vendorCount = \DB::table('vendors')->count();
    $couponCount = \DB::table('coupons')->count();
    $schoolCount = \DB::table('schools')->count();
    $registerCount = \DB::table('students')->count();
    $compulsaryItemCount = \DB::table('compulsary_items')->count();
    $addonCount = \DB::table('add_ons')->count();
@endphp

<div class="dashboard-wrapper" style="background: #f4f7fa; padding: 32px; border-radius: 22px; margin-top: 30px;">
    <h2 style="font-weight: 600; color: #175CD3; margin-bottom: 8px;">
        Welcome Admin
    </h2>
</div>

<div class="row mt-4">
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#f6c23e;">
                    <i class="bi bi-list-ul"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Categories</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $categoryCount }}</div>
                </div>
            </div>
        </div>
    </div>


     <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#f6c23e;">
                    <i class="bi bi-list-ul"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Subcategories</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $subcategoryCount }}</div>
                </div>
            </div>
        </div>
    </div>




    
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#1cc88a;">
                    <i class="bi bi-box-fill"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Products</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $productCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#4e73df;">
                    <i class="bi bi-bag-fill"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Orders</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $orderCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#36b9cc;">
                    <i class="bi bi-people-fill"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Users</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $userCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#fd7e14;">
                    <i class="bi bi-person-badge"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Vendors</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $vendorCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <a href="{{ route('admin.vendor-reports.stock') }}" class="text-decoration-none">
            <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
                <div class="d-flex align-items-center mb-2">
                    <div style="font-size:2rem;color:#0d6efd;">
                        <i class="bi bi-box-seam"></i>
                    </div>
                    <div class="ms-3">
                        <div class="fw-semibold" style="color:#667085;">Vendor Stock Report</div>
                        <div class="small text-muted">View stock by vendor</div>
                    </div>
                </div>
            </div>
        </a>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#20c997;">
                    <i class="bi bi-ticket-detailed-fill"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Coupons</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $couponCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100 d-flex flex-column justify-content-between">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#39a7f1;">
                    <i class="bi bi-building"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Schools</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $schoolCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100 d-flex flex-column justify-content-between">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#d63384;">
                    <i class="bi bi-person-lines-fill"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Registered Students</div>
                    <div class="h4 mb-0" style="color:#101828;">{{ $registerCount }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100 d-flex flex-column justify-content-between">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#0d6efd;">
                    <i class="bi bi-collection"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Compulsory</div>
                    <div class="h4 mb-0" style="color:#101828;">
                        {{ $compulsaryCount ?? 0 }}
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4 mb-4">
        <div class="card border-0 shadow-sm rounded-3 py-4 px-4 h-100 d-flex flex-column justify-content-between">
            <div class="d-flex align-items-center mb-2">
                <div style="font-size:2rem;color:#ffc107;">
                    <i class="bi bi-puzzle-fill"></i>
                </div>
                <div class="ms-3">
                    <div class="fw-semibold" style="color:#667085;">Addons</div>
                    <div class="h4 mb-0" style="color:#101828;">
                        {{ $addonCount ?? 0 }}
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection