@php
  $date = request()->input('date', date('Y-m'));
  $item = new App\Models\Order;
@endphp

<div class="mb-4" style="display: flow-root;">
  <a href="{{url()->current()}}?date={{date('Y-m', strtotime($date." -7 months"))}}" class="btn btn-primary float-left">Előző</a>
  <a href="{{url()->current()}}?date={{date('Y-m', strtotime($date." +7 months"))}}" class="btn btn-primary float-right">Következő</a>
</div>

<div style="overflow-x: auto;">
<table class="table mt-4">
  <thead>
    <tr>
      <th scope="col">Dátum</th>
      <th scope="col">Weben felvitt</th>
      <th scope="col">Kézzel felvitt</th>
      <th scope="col">Házhozszállítás</th>
      <th scope="col">Személyes átvétel</th>
    </tr>
  </thead>
  <tbody>
    
    @for ($i = 0; $i <= 6; $i++)
    <tr>
      @php
        $_date = date('Y-m', strtotime($date." -$i months"));

        $web = $item->whereYear('updated_at', '=', date('Y', strtotime($_date)))
                      ->whereMonth('updated_at', date('m', strtotime($_date)))
                      ->where('status', 'feladásra vár')
                      ->count();

        $hand = $item->whereYear('updated_at', '=', date('Y', strtotime($_date)))
                      ->whereMonth('updated_at', date('m', strtotime($_date)))
                      ->where('status', 'Kézbesített')
                      ->count();

        $post = $item->whereYear('updated_at', '=', date('Y', strtotime($_date)))
                      ->whereMonth('updated_at', date('m', strtotime($_date)))
                      ->where('delivery_method', 'posta')
                      ->count();

        $personal = $item->whereYear('updated_at', '=', date('Y', strtotime($_date)))
                          ->whereMonth('updated_at', date('m', strtotime($_date)))
                          ->where('delivery_method', 'személyes átvétel')
                          ->count();

      @endphp
      
      <td>{{$_date}}</td>
      <td>{{$web}}</td>
      <td>{{$hand}}</td>
      <td>{{$post}}</td>
      <td>{{$personal}}</td>
    </tr>
    @endfor

  </tbody>
</table>
</div>