@hasanyrole('Admin|Kimutatások')

@php
  $date = request()->input('date', date('Y-m-d'));
@endphp

<div class="mt-4 mb-2" style="display: flow-root;">
  <a href="{{url()->current()}}?date={{date('Y-m-d', strtotime($date." -7 days"))}}" class="btn btn-primary float-left">Előző hét</a>
  <a href="{{url()->current()}}?date={{date('Y-m-d', strtotime($date." +7 days"))}}" class="btn btn-primary float-right">Következő hét</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ék</th>
      <th scope="col">Árazás</th>
      <th scope="col">Feltöltött kép</th>
      <th scope="col">Raktárhelyet módosított</th>
    </tr>
  </thead>
  <tbody>
    
    @for ($i = 0; $i <= 6; $i++)
    <tr>
      @php
        $_date = date('Y-m-d', strtotime($date." -$i days"));
                                
        $modified = $item->myLogs()
                          ->whereBetween('created_at', [$_date.' 00:00:00', $_date.' 23:59:59'])
                          ->where('logable_type', 'App\Models\Product')
                          ->where('event', 'Módosítás')
                          ->where('before->price != after->price')
                          ->count();

        $created = $item->myLogs()
                        ->whereBetween('created_at', [$_date.' 00:00:00', $_date.' 23:59:59'])
                        ->where('logable_type', 'App\Models\Product')
                        ->where('event', 'Létrehozva')
                        ->count();

        $photo = $item->myLogs()
                        ->whereBetween('created_at', [$_date.' 00:00:00', $_date.' 23:59:59'])
                        ->where('logable_type', 'App\Models\Photo')
                        ->where('event', 'Létrehozva')
                        ->count();

        $storage_place = $item->myLogs()
                          ->whereBetween('created_at', [$_date.' 00:00:00', $_date.' 23:59:59'])
                          ->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>{{$created}}</td>
      <td>{{$modified}}</td>
      <td>{{$photo}}</td>
      <td>{{$storage_place}}</td>
    </tr>
    @endfor

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

@endhasanyrole