@extends('Backend.Layouts.app')
@php
    $page_title = "Customers";
@endphp

@section('content')
<section class="container">
    <div class="card">
        <div class="card-header"> Manage Customers ({{ $customers->count() }})</div>
        <section class="card-body">
            <div class="table-responsive">
                <table class="table table-condensed datatable">
                    <thead>
                        <tr>
                            <th>School</th>
                            <th>Contact phone</th>
                            <th>Total Orders</th>
                            <th>Total Qty ordered</th>
                            <th>Total amount ordered</th>
                            <th>Last ordered date </th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse ( $customers as $school => $info )
                        <tr>
                            <td>{{ $school }} </td>
                            <td>{{ latest_order_school_contact($school) }}</td>
                            <td>{{ total_order_by_school($school) }}</td>
                            <td>{{ total_qty_ordered_by_school($school) }}</td>
                            <td>{{ total_amount_paid_by_school($school)}}</td>
                            <td>{{ last_ordered_date_by_school($school) }}</td>
                        </tr>
                        @empty
                            
                        @endforelse
                                 
                    </tbody>
                </table>
            </div>
        </section>
    </div>
</section>
@stop