@php
  $date = request()->input('date', date('Y-m'));
  $item = new App\Models\Log;
@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">Feltöltött termékek</th>
      <th scope="col">Feltöltött autó</th>
      <th scope="col">Feltöltött alkatrész</th>
      <th scope="col">Árazás</th>
    </tr>
  </thead>
  <tbody>
    
    @for ($i = 0; $i <= 6; $i++)
    <tr>
      @php
        $_date = date('Y-m', strtotime($date." -$i months"));
        
        $products = $item->whereYear('created_at', '=', date('Y', strtotime($_date)))
                          ->whereMonth('created_at', date('m', strtotime($_date)))
                          ->where('logable_type', 'App\Models\Product')
                          ->where('event', 'Létrehozva')
                          ->count();        
                          
        $cars = $item->whereYear('created_at', '=', date('Y', strtotime($_date)))
                        ->whereMonth('created_at', date('m', strtotime($_date)))
                        ->where('logable_type', 'App\Models\Product')
                        ->where('event', 'Létrehozva')
                        ->where('after->part_id', 1)
                        ->count();

        $parts = $item->whereYear('created_at', '=', date('Y', strtotime($_date)))
                        ->whereMonth('created_at', date('m', strtotime($_date)))
                        ->where('logable_type', 'App\Models\Product')
                        ->where('event', 'Létrehozva')
                        ->whereNot('after->part_id', 1)
                        ->count();

        $price = $item->whereYear('created_at', '=', date('Y', strtotime($_date)))
                        ->whereMonth('created_at', date('m', strtotime($_date)))
                        ->where('logable_type', 'App\Models\Product')
                        ->where('event', 'Módosítás')
                        ->where('before->storage_place != after->storage_place')
                        ->count();

      @endphp
      
      <td>{{$_date}}</td>
      <td>{{$products}}</td>
      <td>{{$cars}}</td>
      <td>{{$parts}}</td>
      <td>{{$price}}</td>
    </tr>
    @endfor

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