@extends('admin.layout.app')

@section('body')
<div class="card card-page p-3 shadow-sm">
    <h4>{{ __('admin.transcript_report') }}</h4>
    <p>{{ __('admin.list_of_students_with_links_to_generate_cumulative_tran') }}</p>
    <div class="table-responsive">
        <table class="table table-bordered">
            <thead class="table-light">
                <tr><th>{{ __('admin.id') }}</th><th>{{ __('admin.name') }}</th><th>{{ __('admin.email') }}</th><th>{{ __('admin.semesters_completed') }}</th><th>{{ __('admin.cgpa') }}</th><th>{{ __('admin.actions') }}</th></tr>
            </thead>
            <tbody>
                @foreach($students as $student)
                @php
                    $studentResults = $allSemesterResults[$student->id] ?? collect();
                    $completed = $studentResults->where('status', 'pass')->count();
                    $cgpa = \App\Services\GpaCalculator::calculateCgpa($student->id);
                @endphp
                <tr>
                    <td>{{ $student->id }}</td>
                    <td>{{ $student->name }}</td>
                    <td>{{ $student->email }}</td>
                    <td>{{ $completed }}</td>
                    <td>{{ number_format($cgpa, 2) }}</td>
                    <td>
                        <a href="{{ route('exam.exam.transcript.cumulative', $student->id) }}" class="btn btn-sm btn-primary" target="_blank">{{ __('admin.download_cumulative') }}</a>
                        <a href="{{ route('exam.students.transcript.form') }}?student_id={{ $student->id }}" class="btn btn-sm btn-info">{{ __('admin.choose_semester_2') }}</a>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection