@extends('admin.layout.admin')

@section('content')
    <div class="content-page">
        <div class="content">
            <div class="container-fluid">
                <div class="page-title-box"></div>
            </div>
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center mb-3">
                                <h4 class="mt-0 header-title">Customers Who Have Placed Orders</h4>
                            </div>
                            <table id="geniustable" class="table table-bordered dt-responsive nowrap"
                                   style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                <thead>
                                <tr>
                                    <th>Customer Name</th>
                                    <th>Email</th>
                                    <th>Phone</th>
                                    <th>Total Orders</th>
                                    <th>Total Amount Spent</th>
                                    <th>Order Details</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($usersWithOrders as $user)
                                    <tr>
                                        <td>{{ ($user->name ?? '') }}</td>
                                        <td>{{ $user->email ?? '' }}</td>
                                        <td>{{ $user->phone_number ?? '' }}</td> 
                                        <td>{{ $user->orders->count() }}</td>
                                        <td>
                                            ${{ number_format($user->orders->sum('total_price'), 2) }}
                                        </td>
                                        <td>
                                            <a href="{{ route('admin.customer.orders', $user->id) }}" class="btn btn-primary btn-sm">
                                                View Orders
                                            </a>
                                        </td>
                                    </tr>
                                @endforeach

                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection