@include('./util/header')
<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-header">
                <h4 class="card-title mb-0">Dashboard</h4>
                <p class="card-title-desc">Overview of your account statistics</p>
            </div>
            <div class="card-body">
                <div class="row">
                    <!-- Total Groups Card -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0">
                                        <div class="avatar-sm rounded-circle bg-primary bg-soft">
                                            <span class="avatar-title bg-primary rounded-circle">
                                                <i data-feather="layers" class="text-white font-size-20"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1 ms-3">
                                        <p class="text-uppercase fw-medium text-muted mb-0">Total Groups</p>
                                        <h4 class="mb-0">{{ $totalGroups }}</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Open Groups Card -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0">
                                        <div class="avatar-sm rounded-circle bg-success bg-soft">
                                            <span class="avatar-title bg-success rounded-circle">
                                                <i data-feather="check-circle" class="text-white font-size-20"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1 ms-3">
                                        <p class="text-uppercase fw-medium text-muted mb-0">Open Groups</p>
                                        <h4 class="mb-0">{{ $openGroups }}</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Closed Groups Card -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0">
                                        <div class="avatar-sm rounded-circle bg-warning bg-soft">
                                            <span class="avatar-title bg-warning rounded-circle">
                                                <i data-feather="x-circle" class="text-white font-size-20"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1 ms-3">
                                        <p class="text-uppercase fw-medium text-muted mb-0">Closed Groups</p>
                                        <h4 class="mb-0">{{ $closedGroups }}</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Paid Users Card -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0">
                                        <div class="avatar-sm rounded-circle bg-info bg-soft">
                                            <span class="avatar-title bg-info rounded-circle">
                                                <i data-feather="dollar-sign" class="text-white font-size-20"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1 ms-3">
                                        <p class="text-uppercase fw-medium text-muted mb-0">Paid Orders</p>
                                        <h4 class="mb-0">{{ $paidOrders }}</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Unpaid Orders Card -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0">
                                        <div class="avatar-sm rounded-circle bg-danger bg-soft">
                                            <span class="avatar-title bg-danger rounded-circle">
                                                <i data-feather="alert-circle" class="text-white font-size-20"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1 ms-3">
                                        <p class="text-uppercase fw-medium text-muted mb-0">Unpaid Orders</p>
                                        <h4 class="mb-0">{{ $unpaidOrders }}</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Imported Employees Card -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-shrink-0">
                                        <div class="avatar-sm rounded-circle bg-secondary bg-soft">
                                            <span class="avatar-title bg-secondary rounded-circle">
                                                <i data-feather="users" class="text-white font-size-20"></i>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="flex-grow-1 ms-3">
                                        <p class="text-uppercase fw-medium text-muted mb-0">Imported Employees</p>
                                        <h4 class="mb-0">{{ $importedEmployees }}</h4>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <!-- This Month Section -->
                <div class="row mt-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">This Month Statistics</h5>
                                <p class="card-title-desc text-muted mb-0">{{ \Carbon\Carbon::now()->format('F Y') }}</p>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <!-- Groups Created This Month -->
                                    <div class="col-xl-2 col-md-4 col-sm-6 mb-3">
                                        <div class="card border-primary">
                                            <div class="card-body text-center">
                                                <div class="avatar-sm mx-auto mb-2">
                                                    <span class="avatar-title bg-primary rounded-circle">
                                                        <i data-feather="plus-circle" class="text-white font-size-18"></i>
                                                    </span>
                                                </div>
                                                <p class="text-muted mb-1 small">Groups Created</p>
                                                <h4 class="mb-0">{{ $groupsCreatedThisMonth }}</h4>
                                            </div>
                                        </div>
                                    </div>

                                    <!-- Orders Placed This Month -->
                                    <div class="col-xl-2 col-md-4 col-sm-6 mb-3">
                                        <div class="card border-info">
                                            <div class="card-body text-center">
                                                <div class="avatar-sm mx-auto mb-2">
                                                    <span class="avatar-title bg-info rounded-circle">
                                                        <i data-feather="shopping-bag" class="text-white font-size-18"></i>
                                                    </span>
                                                </div>
                                                <p class="text-muted mb-1 small">Orders Placed</p>
                                                <h4 class="mb-0">{{ $ordersPlacedThisMonth }}</h4>
                                            </div>
                                        </div>
                                    </div>

                                    <!-- Orders Paid This Month -->
                                    <div class="col-xl-2 col-md-4 col-sm-6 mb-3">
                                        <div class="card border-success">
                                            <div class="card-body text-center">
                                                <div class="avatar-sm mx-auto mb-2">
                                                    <span class="avatar-title bg-success rounded-circle">
                                                        <i data-feather="check-circle" class="text-white font-size-18"></i>
                                                    </span>
                                                </div>
                                                <p class="text-muted mb-1 small">Orders Paid</p>
                                                <h4 class="mb-0">{{ $ordersPaidThisMonth }}</h4>
                                            </div>
                                        </div>
                                    </div>

                                    <!-- Groups Closed This Month -->
                                    <div class="col-xl-2 col-md-4 col-sm-6 mb-3">
                                        <div class="card border-warning">
                                            <div class="card-body text-center">
                                                <div class="avatar-sm mx-auto mb-2">
                                                    <span class="avatar-title bg-warning rounded-circle">
                                                        <i data-feather="lock" class="text-white font-size-18"></i>
                                                    </span>
                                                </div>
                                                <p class="text-muted mb-1 small">Groups Closed</p>
                                                <h4 class="mb-0">{{ $groupsClosedThisMonth }}</h4>
                                            </div>
                                        </div>
                                    </div>

                                    <!-- Employees Imported This Month -->
                                    <div class="col-xl-2 col-md-4 col-sm-6 mb-3">
                                        <div class="card border-secondary">
                                            <div class="card-body text-center">
                                                <div class="avatar-sm mx-auto mb-2">
                                                    <span class="avatar-title bg-secondary rounded-circle">
                                                        <i data-feather="user-plus" class="text-white font-size-18"></i>
                                                    </span>
                                                </div>
                                                <p class="text-muted mb-1 small">Employees Imported</p>
                                                <h4 class="mb-0">{{ $employeesImportedThisMonth }}</h4>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <!-- Recent Orders and Groups Section -->
                <div class="row mt-4">
                    <!-- Recent Orders -->
                    <div class="col-xl-6 col-md-12 mb-4">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">Recent Orders</h5>
                                    <a href="{{ route('account-orders') }}" class="btn btn-sm btn-link">View All</a>
                                </div>
                            </div>
                            <div class="card-body">
                                @if($recentOrders->count() > 0)
                                    <div class="table-responsive">
                                        <table class="table table-hover mb-0">
                                            <thead>
                                                <tr>
                                                    <th>Order #</th>
                                                    <th>Date</th>
                                                    <th>Group</th>
                                                    <th>Amount</th>
                                                    <th>Status</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($recentOrders as $order)
                                                    @php
                                                        $isPaid = !is_null($order->datePaid) && 
                                                                 $order->datePaid !== '' && 
                                                                 $order->datePaid !== '0000-00-00' && 
                                                                 $order->datePaid !== '0000-00-00 00:00:00';
                                                        $isCancelled = !is_null($order->dateCancelled) && 
                                                                      $order->dateCancelled !== '' && 
                                                                      $order->dateCancelled !== '0000-00-00' && 
                                                                      $order->dateCancelled !== '0000-00-00 00:00:00';
                                                        $dateAdded = $order->dateAdded ? \Carbon\Carbon::parse($order->dateAdded)->format('M d, Y') : 'N/A';
                                                        $invoiceTotal = $order->invoiceTotal ? number_format($order->invoiceTotal, 2) : '0.00';
                                                    @endphp
                                                    <tr>
                                                        <td>
                                                            <a href="{{ route('account-order-display', ['orderID' => $order->orderID]) }}" class="text-primary">
                                                                #{{ $order->orderID }}
                                                            </a>
                                                        </td>
                                                        <td>{{ $dateAdded }}</td>
                                                        <td>{{ $order->groupName ?? 'N/A' }}</td>
                                                        <td>${{ $invoiceTotal }}</td>
                                                        <td>
                                                            @if($isCancelled)
                                                                <span class="badge bg-danger">Cancelled</span>
                                                            @elseif($isPaid)
                                                                <span class="badge bg-success">Paid</span>
                                                            @else
                                                                <span class="badge bg-warning">Unpaid</span>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                @else
                                    <p class="text-muted text-center mb-0">No orders found</p>
                                @endif
                            </div>
                        </div>
                    </div>

                    <!-- Recent Groups -->
                    <div class="col-xl-6 col-md-12 mb-4">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">Recent Groups</h5>
                                    <a href="{{ route('account') }}" class="btn btn-sm btn-link">View All</a>
                                </div>
                            </div>
                            <div class="card-body">
                                @if($recentGroups->count() > 0)
                                    <div class="table-responsive">
                                        <table class="table table-hover mb-0">
                                            <thead>
                                                <tr>
                                                    <th>Group #</th>
                                                    <th>Group Name</th>
                                                    <th>Created</th>
                                                    <th>Status</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($recentGroups as $group)
                                                    @php
                                                        $isOpen = is_null($group->dateClosed);
                                                        $dateAdded = $group->dateAdded ? \Carbon\Carbon::parse($group->dateAdded)->format('M d, Y') : 'N/A';
                                                    @endphp
                                                    <tr>
                                                        <td>#{{ $group->groupCode }}</td>
                                                        <td>
                                                            <a href="reports-group-summary?gc={{ $group->groupCode }}" class="text-primary">
                                                                {{ $group->groupName }}
                                                            </a>
                                                        </td>
                                                        <td>{{ $dateAdded }}</td>
                                                        <td>
                                                            @if($isOpen)
                                                                <span class="badge bg-success">Open</span>
                                                            @else
                                                                <span class="badge bg-warning">Closed</span>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            <a href="reports-group-summary?gc={{ $group->groupCode }}" class="btn btn-sm btn-info">
                                                                View
                                                            </a>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                @else
                                    <p class="text-muted text-center mb-0">No groups found</p>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>

                <!-- Quick Actions Section -->
                <div class="row mt-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">Quick Actions</h5>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-3 mb-3">
                                        <a href="{{ route('account') }}" class="btn btn-primary w-100">
                                            <i data-feather="layers"></i> View All Groups
                                        </a>
                                    </div>
                                    <div class="col-md-3 mb-3">
                                        <a href="{{ route('account-orders') }}" class="btn btn-info w-100">
                                            <i data-feather="shopping-cart"></i> View Orders
                                        </a>
                                    </div>
                                    <div class="col-md-3 mb-3">
                                        <a href="{{ route('group-request') }}" class="btn btn-success w-100">
                                            <i data-feather="plus-circle"></i> Create Group
                                        </a>
                                    </div>
                                    <div class="col-md-3 mb-3">
                                        <a href="{{ route('employee-import') }}" class="btn btn-warning w-100">
                                            <i data-feather="upload"></i> Import Employees
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@include('./util/footer')