@extends('admin.layout.app')
@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.exam_marks_report') }}</h4>
    <form method="GET" class="row g-2 mb-3">
        <div class="col-md-3">
            <select name="semester_id" class="form-select" id="semesterSelect">
                <option value="">{{ __('admin.select_semester_2') }}</option>
                @foreach($semesters as $sem)
                    <option value="{{ $sem->id }}" {{ request('semester_id') == $sem->id ? 'selected' : '' }}>{{ $sem->name }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <select name="course_id" class="form-select" id="courseSelect">
                <option value="">{{ __('admin.select_course') }}</option>
                @foreach($courses as $c)
                    <option value="{{ $c->id }}" {{ request('course_id') == $c->id ? 'selected' : '' }}>{{ $c->title }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-2">
            <button class="btn btn-primary">{{ __('admin.filter') }}</button>
        </div>
    </form>

    @if(!empty($marksData))
    <div class="table-responsive">
        <table class="table table-bordered">
            <thead>
                <tr><th>{{ __('admin.student_2') }}</th>
                @foreach($marksData['examTypes'] as $type)
                    <th>{{ $type->name }} ({{ $type->weight }}%)</th>
                @endforeach
                <th>{{ __('admin.total_3') }}</th>
            </tr>
            </thead>
            <tbody>
                @foreach($marksData['students'] as $enrollment)
                @php
                    $totalWeighted = 0;
                @endphp
                <tr>
                    <td>{{ $enrollment->student->name }} ({{ $enrollment->student->email }})</td>
                    @foreach($marksData['examTypes'] as $type)
                        @php
                            $mark = $marksData['marks'][$enrollment->student_user_id][$type->id] ?? null;
                            $percentage = $mark ? ($mark->marks_obtained / $mark->max_marks) * 100 : 0;
                            $totalWeighted += $percentage * ($type->weight / 100);
                        @endphp
                        <td>{{ $mark ? $mark->marks_obtained . '/' . $mark->max_marks : '—' }}<br><small>{{ round($percentage,1) }}%</small></td>
                    @endforeach
                    <td><strong>{{ round($totalWeighted, 2) }}%</strong></td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    @endif
</div>
<script>
    // Simple chaining for semester->courses
    document.getElementById('semesterSelect').addEventListener('change', function() {
        let semesterId = this.value;
        let courseSelect = document.getElementById('courseSelect');
        if (semesterId) {
            fetch(`/admin/get-courses/${semesterId}`)
                .then(res => res.json())
                .then(data => {
                    courseSelect.innerHTML = '<option value="">{{ __('admin.select_course') }}</option>';
                    data.forEach(c => {
                        courseSelect.innerHTML += `<option value="${c.id}">${c.title}</option>`;
                    });
                });
        } else {
            courseSelect.innerHTML = '<option value="">{{ __('admin.select_course') }}</option>';
        }
    });
</script>
@endsection