@extends('adminlte::page')

@section('title', 'My Children\'s Results')

@section('content_header')
    <h1><i class="fas fa-chart-line"></i> Academic Results</h1>
@stop

@section('content')
    {{-- Stats Cards --}}
    <div class="row">
        <div class="col-md-3">
            <div class="info-box bg-info">
                <span class="info-box-icon"><i class="fas fa-users"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Children</span>
                    <span class="info-box-number">{{ $students->count() }}</span>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="info-box bg-success">
                <span class="info-box-icon"><i class="fas fa-chalkboard"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Subjects Taken</span>
                    <span class="info-box-number">
                        {{ \App\Models\Mark::whereIn('student_id', $students->pluck('id'))->distinct('subject_id')->count('subject_id') }}
                    </span>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="info-box bg-warning">
                <span class="info-box-icon"><i class="fas fa-chart-simple"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Average GPA</span>
                    <span class="info-box-number">
                        @php
                            $avgGpa = \App\Models\StudentResult::whereIn('student_id', $students->pluck('id'))->avg('gpa');
                        @endphp
                        {{ number_format($avgGpa ?? 0, 2) }}
                    </span>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="info-box bg-primary">
                <span class="info-box-icon"><i class="fas fa-award"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">Highest GPA</span>
                    <span class="info-box-number">
                        @php
                            $maxGpa = \App\Models\StudentResult::whereIn('student_id', $students->pluck('id'))->max('gpa');
                        @endphp
                        {{ number_format($maxGpa ?? 0, 2) }}
                    </span>
                </div>
            </div>
        </div>
    </div>

    {{-- Filters --}}
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Filter Results</h3>
            <div class="card-tools">
                <button type="button" class="btn btn-tool" data-card-widget="collapse">
                    <i class="fas fa-minus"></i>
                </button>
            </div>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('guardian.results') }}" class="form-inline justify-content-between">
                <div class="form-group mb-2">
                    <label for="student_id" class="mr-2">Student:</label>
                    <select name="student_id" id="student_id" class="form-control" style="min-width: 200px;">
                        <option value="">All Children</option>
                        @foreach($students as $student)
                            <option value="{{ $student->id }}" {{ request('student_id') == $student->id ? 'selected' : '' }}>
                                {{ $student->full_name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="form-group mb-2">
                    <label for="exam_id" class="mr-2">Exam:</label>
                    <select name="exam_id" id="exam_id" class="form-control" style="min-width: 200px;">
                        <option value="">All Exams</option>
                        @foreach($exams ?? [] as $exam)
                            <option value="{{ $exam->id }}" {{ request('exam_id') == $exam->id ? 'selected' : '' }}>
                                {{ $exam->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <button type="submit" class="btn btn-primary mb-2">
                    <i class="fas fa-search"></i> Apply
                </button>
            </form>
        </div>
    </div>

    {{-- Student Summary Table --}}
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Student Performance Summary</h3>
            <div class="card-tools">
                <a href="{{ route('guardian.dashboard') }}" class="btn btn-secondary btn-sm">
                    <i class="fas fa-arrow-left"></i> Back to Dashboard
                </a>
            </div>
        </div>
        <div class="card-body table-responsive p-0">
            <table class="table table-hover table-striped">
                <thead class="bg-light">
                     +
                        <th>Admission No</th>
                        <th>Student Name</th>
                        <th>Class</th>
                        <th>Exam</th>
                        <th>Total Points</th>
                        <th>GPA</th>
                        <th>Division</th>
                        <th>Position</th>
                        <th width="100">Actions</th>
                     +
                </thead>
                <tbody>
                    @forelse($students as $student)
                        @php
                            // Fetch student results for the selected exam (or latest)
                            $studentResult = null;
                            $examId = request('exam_id');
                            if ($examId) {
                                $studentResult = \App\Models\StudentResult::where('student_id', $student->id)
                                    ->where('exam_id', $examId)
                                    ->first();
                            } else {
                                // Get the most recent result (optional)
                                $studentResult = \App\Models\StudentResult::where('student_id', $student->id)
                                    ->latest('created_at')
                                    ->first();
                            }
                        @endphp
                         +
                            <td>{{ $student->admission_no }}</td>
                            <td>
                                <strong>{{ $student->full_name }}</strong><br>
                                <small class="text-muted">{{ $student->email ?? '' }}</small>
                            </td>
                            <td>{{ $student->class->name ?? 'N/A' }}</td>
                            <td>{{ $studentResult ? ($studentResult->exam->name ?? 'N/A') : 'N/A' }}</td>
                            <td>{{ $studentResult->total_points ?? '-' }}</td>
                            <td>{{ number_format($studentResult->gpa ?? 0, 2) }}</td>
                            <td>
                                @if($studentResult)
                                    @php
                                        $divisionClass = match($studentResult->division) {
                                            'I' => 'success',
                                            'II' => 'primary',
                                            'III' => 'warning',
                                            'IV' => 'danger',
                                            default => 'secondary'
                                        };
                                    @endphp
                                    <span class="badge badge-{{ $divisionClass }}">{{ $studentResult->division }}</span>
                                @else
                                    -
                                @endif
                            </td>
                            <td>{{ $studentResult->position ?? '-' }}</td>
                            <td>
                                <a href="{{ route('guardian.result.show', $student->id) }}?exam_id={{ request('exam_id') }}" 
                                   class="btn btn-sm btn-primary" title="View Full Report">
                                    <i class="fas fa-chart-line"></i> Details
                                </a>
                            </td>
                         +
                    @empty
                        <td colspan="9" class="text-center text-muted py-4">
                            <i class="fas fa-info-circle"></i> No students found.
                        </td>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    {{-- Subject Breakdown for Selected Student (Optional) --}}
    @if(request('student_id') && $selectedStudent = $students->firstWhere('id', request('student_id')))
        @php
            $examId = request('exam_id');
            if ($examId) {
                $marks = \App\Models\Mark::where('student_id', $selectedStudent->id)
                            ->where('exam_id', $examId)
                            ->with('subject')
                            ->get();
            } else {
                $marks = \App\Models\Mark::where('student_id', $selectedStudent->id)
                            ->with('subject')
                            ->latest('exam_id')
                            ->get();
            }
        @endphp
        @if($marks->count())
            <div class="card mt-3">
                <div class="card-header bg-success text-white">
                    <h5 class="mb-0"><i class="fas fa-list"></i> Subject Marks for {{ $selectedStudent->full_name }}</h5>
                </div>
                <div class="card-body table-responsive p-0">
                    <table class="table table-bordered table-striped text-center">
                        <thead class="bg-light">
                             +
                                <th>Subject</th>
                                <th>Mark</th>
                                <th>Grade</th>
                                <th>Point</th>
                                <th>Remark</th>
                             +
                        </thead>
                        <tbody>
                            @foreach($marks as $mark)
                                @php
                                    $grade = \App\Models\Grade::where('min_mark', '<=', $mark->mark)
                                        ->where('max_mark', '>=', $mark->mark)
                                        ->first();
                                @endphp
                                <tr>
                                    <td>{{ $mark->subject->name }}</td>
                                    <td>{{ $mark->mark }}</td>
                                    <td>
                                        <span class="badge badge-{{ match($grade->name ?? '') {
                                            'A' => 'success', 'B' => 'primary', 'C' => 'info', 'D' => 'warning', default => 'danger'
                                        } }}">{{ $grade->name ?? '-' }}</span>
                                    </td>
                                    <td>{{ $grade->point ?? 0 }}</td>
                                    <td>{{ $grade->description ?? '-' }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        @endif
    @endif
@stop

@push('css')
<style>
    .table-hover tbody tr:hover {
        background-color: rgba(0,0,0,.02);
    }
    .badge {
        font-size: 0.9rem;
    }
</style>
@endpush