@extends('admin.layout')

@section('content')
<div class="flex justify-between items-center mb-6">
    <div>
        <h1 class="text-3xl font-bold text-gray-800">Leaderboard</h1>
        <p class="text-gray-600">Track student performance and rankings across different subjects and levels</p>
    </div>
    <div class="flex space-x-3">
        <button onclick="exportLeaderboard()" class="bg-green-600 hover:bg-green-700 text-white px-4 py-2 rounded-lg flex items-center">
            <i class="fas fa-file-export mr-2"></i> Export CSV
        </button>
        <button onclick="refreshLeaderboard()" class="bg-blue-600 hover:bg-blue-700 text-white px-4 py-2 rounded-lg flex items-center">
            <i class="fas fa-sync-alt mr-2"></i> Refresh
        </button>
    </div>
</div>

<!-- Stats Overview -->
<div class="grid grid-cols-1 md:grid-cols-4 gap-6 mb-6">
    <div class="bg-white rounded-lg shadow p-6">
        <div class="flex items-center">
            <div class="p-3 rounded-full bg-blue-100 text-blue-600">
                <i class="fas fa-users text-xl"></i>
            </div>
            <div class="ml-4">
                <h3 class="text-lg font-semibold text-gray-600">Total Participants</h3>
                <p class="text-3xl font-bold text-gray-800">{{ number_format($totalParticipants) }}</p>
            </div>
        </div>
    </div>
    
    <div class="bg-white rounded-lg shadow p-6">
        <div class="flex items-center">
            <div class="p-3 rounded-full bg-green-100 text-green-600">
                <i class="fas fa-trophy text-xl"></i>
            </div>
            <div class="ml-4">
                <h3 class="text-lg font-semibold text-gray-600">Top Score</h3>
                <p class="text-3xl font-bold text-gray-800">
                    @if($leaderboard->count() > 0)
                        {{ $leaderboard->first()->total_score }}
                    @else
                        0
                    @endif
                </p>
            </div>
        </div>
    </div>
    
    <div class="bg-white rounded-lg shadow p-6">
        <div class="flex items-center">
            <div class="p-3 rounded-full bg-purple-100 text-purple-600">
                <i class="fas fa-chart-line text-xl"></i>
            </div>
            <div class="ml-4">
                <h3 class="text-lg font-semibold text-gray-600">Average Score</h3>
                <p class="text-3xl font-bold text-gray-800">{{ number_format($averageScore, 1) }}</p>
            </div>
        </div>
    </div>
    
    <div class="bg-white rounded-lg shadow p-6">
        <div class="flex items-center">
            <div class="p-3 rounded-full bg-yellow-100 text-yellow-600">
                <i class="fas fa-clock text-xl"></i>
            </div>
            <div class="ml-4">
                <h3 class="text-lg font-semibold text-gray-600">Active Filters</h3>
                <p class="text-3xl font-bold text-gray-800">
                    {{ request()->anyFilled(['subject', 'level', 'region', 'school', 'search']) ? count(request()->all()) - 1 : 0 }}
                </p>
            </div>
        </div>
    </div>
</div>

<!-- Filters -->
<div class="bg-white rounded-lg shadow p-6 mb-6">
    <form action="{{ route('admin.leaderboard.index') }}" method="GET" class="grid grid-cols-1 md:grid-cols-6 gap-4">
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Search</label>
            <input type="text" name="search" value="{{ request('search') }}" 
                   class="w-full border border-gray-300 rounded-lg px-3 py-2 focus:outline-none focus:ring-2 focus:ring-blue-500"
                   placeholder="Name or email...">
        </div>
        
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Subject</label>
            <select name="subject" class="w-full border border-gray-300 rounded-lg px-3 py-2 focus:outline-none focus:ring-2 focus:ring-blue-500">
                <option value="">All Subjects</option>
                @foreach($subjects as $subject)
                    <option value="{{ $subject->id }}" {{ request('subject') == $subject->id ? 'selected' : '' }}>
                        {{ $subject->name }}
                    </option>
                @endforeach
            </select>
        </div>
        
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Level</label>
            <select name="level" class="w-full border border-gray-300 rounded-lg px-3 py-2 focus:outline-none focus:ring-2 focus:ring-blue-500">
                <option value="">All Levels</option>
                @foreach($levels as $level)
                    <option value="{{ $level->id }}" {{ request('level') == $level->id ? 'selected' : '' }}>
                        {{ $level->name }}
                    </option>
                @endforeach
            </select>
        </div>
        
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">Region</label>
            <select name="region" class="w-full border border-gray-300 rounded-lg px-3 py-2 focus:outline-none focus:ring-2 focus:ring-blue-500">
                <option value="">All Regions</option>
                @foreach($regions as $region)
                    <option value="{{ $region }}" {{ request('region') == $region ? 'selected' : '' }}>
                        {{ $region }}
                    </option>
                @endforeach
            </select>
        </div>
        
        <div>
            <label class="block text-sm font-medium text-gray-700 mb-1">School</label>
            <select name="school" class="w-full border border-gray-300 rounded-lg px-3 py-2 focus:outline-none focus:ring-2 focus:ring-blue-500">
                <option value="">All Schools</option>
                @foreach($schools as $school)
                    <option value="{{ $school }}" {{ request('school') == $school ? 'selected' : '' }}>
                        {{ $school }}
                    </option>
                @endforeach
            </select>
        </div>
        
        <div class="flex items-end space-x-2">
            <button type="submit" class="bg-blue-600 hover:bg-blue-700 text-white px-4 py-2 rounded-lg w-full">
                <i class="fas fa-filter mr-2"></i> Apply
            </button>
            <a href="{{ route('admin.leaderboard.index') }}" class="bg-gray-600 hover:bg-gray-700 text-white px-4 py-2 rounded-lg flex items-center">
                <i class="fas fa-times"></i>
            </a>
        </div>
    </form>
</div>

<!-- Leaderboard Table -->
<div class="bg-white rounded-lg shadow overflow-hidden">
    <div class="overflow-x-auto">
        <table class="min-w-full divide-y divide-gray-200">
            <thead class="bg-gray-50">
                <tr>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Rank</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Student</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Subject</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Level</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Score</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Time Spent</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">School</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Region</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Last Updated</th>
                </tr>
            </thead>
            <tbody class="bg-white divide-y divide-gray-200">
                @forelse($leaderboard as $index => $entry)
                <tr class="hover:bg-gray-50 transition duration-150">
                    <td class="px-6 py-4 whitespace-nowrap">
                        <div class="flex items-center">
                            @if($index < 3)
                                <div class="flex-shrink-0 w-8 h-8 rounded-full flex items-center justify-center 
                                    {{ $index == 0 ? 'bg-yellow-100 text-yellow-800' : 
                                       ($index == 1 ? 'bg-gray-100 text-gray-800' : 
                                       'bg-orange-100 text-orange-800') }}">
                                    <i class="fas fa-medal text-sm"></i>
                                </div>
                            @else
                                <div class="flex-shrink-0 w-8 h-8 rounded-full bg-blue-100 text-blue-800 flex items-center justify-center text-sm font-bold">
                                    {{ $index + 1 }}
                                </div>
                            @endif
                            <span class="ml-2 text-sm font-medium text-gray-900">
                                #{{ ($leaderboard->currentPage() - 1) * $leaderboard->perPage() + $index + 1 }}
                            </span>
                        </div>
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap">
                        <div class="flex items-center">
                            <div class="flex-shrink-0 h-10 w-10 bg-blue-500 rounded-full flex items-center justify-center text-white font-bold text-sm">
                                {{ substr($entry->user->first_name, 0, 1) }}{{ substr($entry->user->last_name, 0, 1) }}
                            </div>
                            <div class="ml-4">
                                <div class="text-sm font-medium text-gray-900">
                                    {{ $entry->user->first_name }} {{ $entry->user->last_name }}
                                </div>
                                <div class="text-sm text-gray-500">{{ $entry->user->email }}</div>
                            </div>
                        </div>
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap">
                        <div class="text-sm text-gray-900">{{ $entry->subject->name ?? 'N/A' }}</div>
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap">
                        <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full 
                            {{ $entry->competitionLevel->level == 1 ? 'bg-green-100 text-green-800' : 
                               ($entry->competitionLevel->level == 2 ? 'bg-blue-100 text-blue-800' : 
                               'bg-purple-100 text-purple-800') }}">
                            {{ $entry->competitionLevel->name ?? 'N/A' }}
                        </span>
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap">
                        <div class="text-sm font-bold text-gray-900">{{ $entry->total_score }}</div>
                        <div class="text-xs text-gray-500">points</div>
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">
                        @php
                            $hours = floor($entry->time_spent / 3600);
                            $minutes = floor(($entry->time_spent % 3600) / 60);
                            $seconds = $entry->time_spent % 60;
                        @endphp
                        @if($hours > 0)
                            {{ $hours }}h {{ $minutes }}m
                        @elseif($minutes > 0)
                            {{ $minutes }}m {{ $seconds }}s
                        @else
                            {{ $seconds }}s
                        @endif
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">
                        {{ $entry->school ?? 'N/A' }}
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">
                        {{ $entry->region ?? 'N/A' }}
                    </td>
                    <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">
                        {{ $entry->updated_at->diffForHumans() }}
                    </td>
                </tr>
                @empty
                <tr>
                    <td colspan="9" class="px-6 py-4 text-center text-sm text-gray-500">
                        <div class="flex flex-col items-center justify-center py-8">
                            <i class="fas fa-trophy text-gray-300 text-4xl mb-3"></i>
                            <p class="text-gray-500">No leaderboard entries found.</p>
                            @if(request()->anyFilled(['subject', 'level', 'region', 'school', 'search']))
                                <p class="text-sm text-gray-400 mt-1">Try adjusting your filters</p>
                            @endif
                        </div>
                    </td>
                </tr>
                @endforelse
            </tbody>
        </table>
    </div>
    
    <!-- Pagination -->
    @if($leaderboard->hasPages())
    <div class="bg-white px-4 py-3 border-t border-gray-200 sm:px-6">
        {{ $leaderboard->withQueryString()->links() }}
    </div>
    @endif
</div>

<!-- Top Performers Section -->
@if($leaderboard->count() > 0)
<div class="mt-8">
    <h2 class="text-2xl font-bold text-gray-800 mb-6">Top Performers</h2>
    <div class="grid grid-cols-1 md:grid-cols-3 gap-6">
        @foreach($leaderboard->take(3) as $index => $topPerformer)
        <div class="bg-white rounded-lg shadow p-6 text-center transform hover:scale-105 transition duration-200">
            <div class="flex justify-center mb-4">
                @if($index == 0)
                    <div class="w-16 h-16 bg-yellow-100 rounded-full flex items-center justify-center">
                        <i class="fas fa-crown text-yellow-500 text-2xl"></i>
                    </div>
                @elseif($index == 1)
                    <div class="w-16 h-16 bg-gray-100 rounded-full flex items-center justify-center">
                        <i class="fas fa-medal text-gray-500 text-2xl"></i>
                    </div>
                @else
                    <div class="w-16 h-16 bg-orange-100 rounded-full flex items-center justify-center">
                        <i class="fas fa-medal text-orange-500 text-2xl"></i>
                    </div>
                @endif
            </div>
            <h3 class="text-lg font-bold text-gray-800">{{ $topPerformer->user->first_name }} {{ $topPerformer->user->last_name }}</h3>
            <p class="text-sm text-gray-600 mb-2">{{ $topPerformer->school ?? 'N/A' }}</p>
            <div class="text-3xl font-bold text-blue-600 mb-2">{{ $topPerformer->total_score }}</div>
            <p class="text-sm text-gray-500">points • {{ $topPerformer->subject->name ?? 'N/A' }}</p>
            <div class="mt-4 flex justify-center space-x-2">
                <span class="px-2 py-1 text-xs bg-green-100 text-green-800 rounded-full">
                    Level {{ $topPerformer->competitionLevel->level ?? 'N/A' }}
                </span>
                <span class="px-2 py-1 text-xs bg-purple-100 text-purple-800 rounded-full">
                    {{ $topPerformer->region ?? 'N/A' }}
                </span>
            </div>
        </div>
        @endforeach
    </div>
</div>
@endif

<script>
function exportLeaderboard() {
    // Get current filters
    const params = new URLSearchParams(window.location.search);
    
    // Add export parameter
    params.set('export', 'csv');
    
    // Redirect to export URL
    window.location.href = '{{ route('admin.leaderboard.index') }}?' + params.toString();
}

function refreshLeaderboard() {
    window.location.reload();
}

// Auto-refresh every 30 seconds if no filters are applied
@if(!request()->anyFilled(['subject', 'level', 'region', 'school', 'search']))
setTimeout(() => {
    refreshLeaderboard();
}, 30000);
@endif

// Add some visual effects for top ranks
document.addEventListener('DOMContentLoaded', function() {
    const topRows = document.querySelectorAll('tbody tr');
    topRows.forEach((row, index) => {
        if (index === 0) {
            row.classList.add('bg-yellow-50', 'border-l-4', 'border-yellow-400');
        } else if (index === 1) {
            row.classList.add('bg-gray-50', 'border-l-4', 'border-gray-400');
        } else if (index === 2) {
            row.classList.add('bg-orange-50', 'border-l-4', 'border-orange-400');
        }
    });
});
</script>

<style>
/* Custom styles for leaderboard */
tbody tr:nth-child(-n+3) {
    font-weight: 600;
}

/* Highlight top 3 rows */
.bg-yellow-50 {
    background-color: #fffbeb;
}

.bg-gray-50 {
    background-color: #f9fafb;
}

.bg-orange-50 {
    background-color: #fff7ed;
}
</style>
@endsection