@extends('admin.layout.app')
@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.course_reports') }}</h4>
    <form method="GET" class="row g-2 mb-3">
        <div class="col-md-3">
            <select name="semester_id" class="form-select">
                <option value="">{{ __('admin.all_semesters') }}</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-2">
            <button class="btn btn-primary">{{ __('admin.filter') }}</button>
            <a href="{{ route('reports.courses.export.pdf', request()->query()) }}" class="btn btn-secondary">{{ __('admin.export_pdf') }}</a>
        </div>
    </form>
    <div class="table-responsive">
        <table class="table table-bordered">
            <thead>
                <tr><th>{{ __('admin.title') }}</th><th>{{ __('admin.code') }}</th><th>{{ __('admin.semester') }}</th><th>{{ __('admin.credit_hours') }}</th><th>{{ __('admin.teachers') }}</th><th>{{ __('admin.students_enrolled') }}</th><th>{{ __('admin.pass_rate') }}</th></tr>
            </thead>
            <tbody>
                @foreach($courses as $c)
                <tr>
                    <td>{{ $c->title }}<\/td>
                    <td>{{ $c->code ?? '—' }}<\/td>
                    <td>{{ $c->semester->name ?? '' }}<\/td>
                    <td>{{ $c->credit_hours ?? '—' }}<\/td>
                    <td>{{ $c->teachers->pluck('name')->implode(', ') }}<\/td>
                    <td>{{ $c->enrollments->where('status', 'active')->count() }}<\/td>
                    <td>
                        @php
                            $totalResults = \App\Models\StudentCourseResult::where('course_id', $c->id)->count();
                            $passed = \App\Models\StudentCourseResult::where('course_id', $c->id)->where('is_passed', true)->count();
                            $passRate = $totalResults ? round(($passed/$totalResults)*100, 2) : 0;
                        @endphp
                        {{ $passRate }}%
                     </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    {{ $courses->links('pagination::bootstrap-4') }}
</div>
@endsection