@section('title') {{$user}} NBA clips profile @endsection
@section('desc') {{$user}} NBA clips posting profile and statistics @endsection
<x-app-layout>
    <div class="card filled-out">
        <div class="card-body card-smp">
            <div class="row">
                <h1 class="text-center pb-2">{{$user}}</h1>
                <p class="text-muted text-center">Refreshed every hour</p>
                <div class="table-responsive">
                    <table class="table table-striped table-bordered table-success">
                        <thead class="table-light">
                        <tr>
                            <th scope="col">Year</th>
                            <th scope="col">Clips</th>
                            <th scope="col">AVG Width</th>
                            <th scope="col">AVG Height</th>
                            <th scope="col">AVG Size MB</th>
                            <th scope="col">AVG Bitrate Kbps</th>
                            <th scope="col">AVG Duration S</th>
                            <th scope="col">AVG comments</th>
                            <th scope="col">AVG ups</th>
                            <th scope="col">Clips per day</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach($user_stats as $s)
                            <tr>
                                <td>{{$s->year}}</td>
                                <td>{{number_format($s->amount,0)}}</td>
                                <td>{{number_format($s->width,0)}}</td>
                                <td>{{number_format($s->height,0)}}</td>
                                <td>{{number_format($s->size / 1024,0)}}</td>
                                <td>{{number_format($s->bitrate / 1000,2)}}</td>
                                <td>{{number_format($s->duration,1)}}</td>
                                <td>{{number_format($s->comments,1)}}</td>
                                <td>{{number_format($s->ups,1)}}</td>
                                <td>
                                    @if($s->year === 2022)
                                        {{number_format($s->amount/ $days, 1)}}
                                    @else
                                        {{number_format($s->amount/ 365, 1)}}
                                    @endif
                                </td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
                <div class="row">
                    <div class="col-12">
                        <div class="list-group">
                            @foreach($user_posts as $c)
                                <a href="{{route('post', $c->id)}}"
                                   class="list-group-item d-flex justify-content-between align-items-center lg-mbt">{{$c->title}}
                                    <span class="badge bg-info rounded-pill">{{\Carbon\Carbon::parse($c->posted)->tz('America/New_York')->format('g:ia D jS M Y')}}, {{number_format($c->ups, 0)}} ups</span></a>
                            @endforeach
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</x-app-layout>