@extends('admin.layout.app')

@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.promotion_report') }}</h4>
    <p>{{ __('admin.view_which_students_have_been_promoted_to_the_next_seme') }}</p>

    <form method="GET" class="row g-3 mb-4">
        <div class="col-md-4">
            <label class="form-label">{{ __('admin.program') }}</label>
            <select name="program_id" class="form-select" id="programSelect">
                <option value="">{{ __('admin.select_program') }}</option>
                @foreach($programs as $p)
                    <option value="{{ $p->id }}" {{ request('program_id') == $p->id ? 'selected' : '' }}>
                        {{ $p->name }}
                    </option>
                @endforeach
            </select>
        </div>

        <div class="col-md-4">
            <label class="form-label">{{ __('admin.semester') }}</label>
            <select name="semester_id" class="form-select" id="semesterSelect" {{ $semesters->isEmpty() ? 'disabled' : '' }}>
                <option value="">{{ __('admin.select_semester') }}</option>
                @foreach($semesters as $s)
                    <option value="{{ $s->id }}" {{ request('semester_id') == $s->id ? 'selected' : '' }}>
                        {{ $s->name }}
                    </option>
                @endforeach
            </select>
        </div>

        <div class="col-md-3">
            <label class="form-label">{{ __('admin.promotion_status') }}</label>
            <select name="promotion_status" class="form-select">
                <option value="">{{ __('admin.all_2') }}</option>
                <option value="Promoted" {{ request('promotion_status') == 'Promoted' ? 'selected' : '' }}>{{ __('admin.promoted') }}</option>
                <option value="Passed but Not Promoted" {{ request('promotion_status') == 'Passed but Not Promoted' ? 'selected' : '' }}>{{ __('admin.passed_but_not_promoted') }}</option>
                <option value="Failed" {{ request('promotion_status') == 'Failed' ? 'selected' : '' }}>{{ __('admin.failed') }}</option>
            </select>
        </div>

        <div class="col-md-1 d-flex align-items-end">
            <button type="submit" class="btn btn-primary w-100">{{ __('admin.filter') }}</button>
        </div>
    </form>

    @if($results->isNotEmpty())
        <div class="table-responsive">
            <table class="table table-bordered">
                <thead class="table-light">
                    <tr>
                        <th>{{ __('admin.student_2') }}</th>
                        <th>{{ __('admin.email') }}</th>
                        <th>{{ __('admin.gpa') }}</th>
                        <th>{{ __('admin.semester_result') }}</th>
                        <th>{{ __('admin.promotion_status') }}</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($results as $r)
                        <tr>
                            <td>{{ $r->student->name }} (ID: {{ $r->student->id }})</td>
                            <td>{{ $r->student->email }}</td>
                            <td>{{ $r->gpa }}</td>
                            <td><span class="badge {{ $r->status == 'pass' ? 'bg-success' : 'bg-danger' }}">{{ ucfirst($r->status) }}</span></td>
                            <td>
                                @if($r->promotion_status == 'Promoted')
                                    <span class="badge bg-success">{{ __('admin.promoted') }}</span>
                                @elseif($r->promotion_status == 'Passed but Not Promoted')
                                    <span class="badge bg-warning text-dark">{{ __('admin.passed_but_not_promoted') }}</span>
                                @else
                                    <span class="badge bg-danger">{{ __('admin.failed') }}</span>
                                @endif
                              </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @elseif(request()->has('semester_id'))
        <div class="alert alert-info">{{ __('admin.no_results_found_for_selected_criteria') }}</div>
    @endif

    @if($selectedSemester && $selectedSemester->nextSemester)
        <div class="mt-3 alert alert-secondary">
            <strong>{{ __('admin.next_semester_defined') }}</strong> {{ $selectedSemester->nextSemester->name }}
        </div>
    @elseif($selectedSemester && !$selectedSemester->nextSemester)
        <div class="mt-3 alert alert-warning">
            No next semester defined for {{ $selectedSemester->name }}. Promotion is not possible.
        </div>
    @endif
</div>

<script>
    document.getElementById('programSelect').addEventListener('change', function() {
        let programId = this.value;
        let semesterSelect = document.getElementById('semesterSelect');
        if (programId) {
            fetch(`/exam/get-semesters/${programId}`)
                .then(response => response.json())
                .then(data => {
                    semesterSelect.innerHTML = '<option value="">{{ __('admin.select_semester') }}</option>';
                    data.forEach(sem => {
                        semesterSelect.innerHTML += `<option value="${sem.id}">${sem.name}</option>`;
                    });
                    semesterSelect.disabled = false;
                });
        } else {
            semesterSelect.innerHTML = '<option value="">{{ __('admin.select_semester') }}</option>';
            semesterSelect.disabled = true;
        }
    });
</script>
@endsection