@extends('admin.layout.app')
@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.department_reports') }}</h4>
    <div class="mb-3">
        <a href="{{ route('reports.departments.export.pdf') }}" class="btn btn-secondary">{{ __('admin.export_pdf') }}</a>
    </div>
    <div class="table-responsive">
        <table class="table table-bordered">
            <thead><tr><th>{{ __('admin.name') }}</th><th>{{ __('admin.faculty_2') }}</th><th>{{ __('admin.university') }}</th><th>{{ __('admin.programs') }}</th><th>{{ __('admin.students') }}</th></tr></thead>
            <tbody>
                @foreach($departments as $d)
                <tr>
                    <td>{{ $d->name }}<br><small>{{ $d->code ?? '' }}</small></td>
                    <td>{{ $d->faculty->name ?? '' }}<\/td>
                    <td>{{ $d->faculty->university->name ?? '' }}<\/td>
                    <td>{{ $d->programs->count() }}<\/td>
                    <td>{{ $d->programs->sum(fn($p) => $p->semesters->sum(fn($sem) => $sem->courses->sum(fn($c) => $c->enrollments->count()))) }}<\/td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
    {{ $departments->links('pagination::bootstrap-4') }}
</div>
@endsection