@include('admin.show.extra')

@hasanyrole('Admin|Kimutatások')

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

<div class="mt-4 mb-4" 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">Ebben az időszakban hozzáadva</th>
    <th scope="col">Eladva</th>
    <th scope="col">Eladás összege (Ft)</th>
    </tr>
</thead>
<tbody>

    @for ($i = 0; $i < 6; $i++)
    <tr>
        @php
        $_date = date('Y-m-d', strtotime($date." -$i days"));
        $sold = $item->products()->whereBetween('updated_at', [$_date.' 00:00:00', $_date.' 23:59:59'])->where('state', 'Eladva');
        @endphp

        <td>{{$date}}</td>
        <td>{{$item->products()->whereBetween('created_at', [$_date.' 00:00:00', $_date.' 23:59:59'])->count()}}</td>
        <td>{{$sold->count()}}</td>    
        <td>{{$sold->sum('price')}}</td>
        </div>
    </tr>
    @endfor

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

@endhasanyrole