@extends('layout.report', ['max_width' => '100%'])
@section('report')
@php
    $students = $group->students;
@endphp
    <h1>Group Wise GPA List</h1>
    <pre>{{ $group->name }}                 {{ 'exported at: ' . date('d-m-Y H:i') }}</pre>
    <table>
        <thead>
            <tr>
                <th>#</th>
                <th>Number</th>
                <th>Name</th>
                @if ($students->first() !== null)
                @php
                    $semesters = [];
                    foreach ($students->first()->semestersGpa() as $semester => $gpa) 
                    {
                        if (!$this_semester_only || $semester == $activeSemester->id) 
                        {
                            $semesters[] = App\Models\Semester::find($semester);
                        }
                    }
                    // sort semesters by name
                    usort($semesters, function ($a, $b) {
                        return $a->name > $b->name;
                    });
                @endphp
                    @foreach ($semesters as $semester)
                        <th>{{ $semester->name }}</th>
                    @endforeach
                @endif
                @if(!$this_semester_only)
                    <th>GPA</th>
                @endif
            </tr>
        </thead>
        <tbody>
            @foreach ($group->students as $student)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $student->student_number }}</td>
                    <td>{{ $student->user->name }}</td>
                    @foreach ($semesters as $semester)
                        <td>{{ @$student->semestersGpa()[$semester->id] }}</td>
                    @endforeach
                    @if(!$this_semester_only)
                        <td style="padding: 0 10px">{{ $student->courseGradesGpa() }}</td>
                    @endif
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection