@extends('layouts.admin')

@section('content')
    <div class="container">
        <h4 class="text-center">Shop Ratings</h4>
        <table class="table text-center"> <!-- Add text-center class to center align table content -->
            <thead>
                <tr>
                    <th>Shop</th>
                    <th>Rating</th>
                    <th>Total Ratings</th>
                </tr>
            </thead>
            <tbody>
            @forelse ($ratings->groupBy('shop_id') as $shopId => $shopRatings)
                @php
                    // Retrieve shop details based on shop_id
                    $shop = \App\Models\User::where('role_as', 2)
                                            ->where('id', $shopId)
                                            ->with('shop')
                                            ->first(); // Assuming shop details are stored in the shops table
                    
                    // Calculate overall rating for the shop
                    $overallRating = $shopRatings->avg('shop_rating');
                    
                    // Count total ratings for the shop
                    $totalRatings = $shopRatings->count();
                @endphp

                <tr>
                    <td>{{ $shop->shop->shop_name ?? 'No Name Available' }}</td>
                    <td>
                        @if ($overallRating)
                            {{ number_format($overallRating, 2) }} / 5.0
                        @else
                            No rating yet.
                        @endif
                    </td>
                    <td>{{ $totalRatings }}</td>
                </tr>
            @empty
                <tr>
                    <td colspan="3">No ratings available.</td>
                </tr>
            @endforelse
            </tbody>
        </table>
    </div>
@endsection