@extends('layouts.main')

@section('content')
    <h1>{{$title}}</h1>
    <a class="btn btn-dark" href="{{route('customer.create')}}">Add customer</a>
    <hr>
  
        <div class="table-responsive">                          
          <table class="table table-hover table-striped" id="example">
            <thead> 
              <th>ID</th>              
              <th>Date</th>
              <th>Name</th>
              <th>Phone Number</th>
              <th>Address</th>
              <th>Gender</th>
              <th>Age</th>
              <th>Customer Type</th>
              @for ($year=2025; $year<=date("Y"); $year++)
              <th>{{  $year }}</th>                  
              @endfor
                

            </thead>
            <tbody>
              @foreach($customers as $customer)
                <tr>
                    <td>{{ $customer->id }}</td>
                    <td>{{Carbon\Carbon::parse($customer->created_at)->format('Y-m-d')}}</td>
                    <td>{{$customer->name}}</td>
                    <td>{{$customer->phone_number}}</td>
                    <td>{{$customer->address}}</td> 
                    <td>{{ $customer->gender }}</td>
                    <td>{{ $customer->age }}</td>
                    <td>{{ $customer->customer_type }}</td>
                    @for ($year=2020; $year<=date("Y"); $year++)
                    <td>{{ number_format($customer->yearslySales($customer->id,$year)) }}</td>                                      
                    @endfor                       
                </tr>
              @endforeach             
            </tbody>
          </table>          
       </div>
  
@endsection