@extends('front.layouts.main')


@section('content')


<div class="container-fluid">
  <table class="table table-hover">
    <thead>
      <tr>
        <th scope="col">ID</th>
        <th scope="col">Customer Name</th>
        <th scope="col">Customer email</th>
        <th scope="col">Customer Phone</th>
        <th scope="col">Customer Date Of Birth</th>
        <th scope="col">Customer Orders</th>
        <th scope="col">Customer Due</th>
        <th scope="col"> Clear Due <th>
      </tr>
    </thead>
    @foreach($data as $key => $item)
      @php
          $dues = $item->orders->sum('due');
      @endphp
      @if($dues > 0)
        <tbody>
          <tr>
            <th scope="row">{{$key + 1}}</th>
            <td>{{$item->name}}</td>
            <td>{{$item->email}}</td>
            <td>{{$item->phone}}</td>
            <td>{{$item->dob}}</td>
            <td>{{$item->orders->count()}}</td>
            <td>
              {{ $dues }}
            </td>
            <td> <a class="btn btn-primary" href="{{ route('due-empty',[$item->id]) }}"> Empty Due </td>
          </tr>
        </tbody>
     @endif
  @endforeach
  </table>
</div>


@endsection