@extends('layout.report', ['max_width' => '100%'])
@section('report')
    <style>
        td,
        th {
            border: 1px solid black;
            padding: 5px;
            font-size: 12px;
        }
    </style>
        <h1>Final Grade List</h1>
        <pre>{{ $group->name }}      From Sem: {{ $semester->name }}    Semester: {{ $group->semesterNumber }}     {{ $subject != null ? $subject->name : '          ' }}    {{ 'exported at: ' . date('d-m-Y H:i') }}</pre>
        <table>
            <thead>
                <tr>
                    <th>Trainee Number</th>
                    <th colspan="2">Name</th>
                    @if ($subject != null)
                        @if ($is_hod)
                            <th>Marks</th>
                        @endif
                        <th>Grade</th>
                    @else
                        @foreach ($subjects as $subject)
                            <th colspan="{{ $is_hod ? 2 : 1 }}">{{ $subject->name }}</th>
                        @endforeach
                    @endif
                </tr>
            </thead>
            <tbody>
                @foreach ($group->students->sort(function ($a, $b) {
                    return $a->user->name <=> $b->user->name;
                }) as $student)
                    <tr>
                        <td>{{ $student->student_number }}</td>
                        <td colspan="2">{{ $student->user->name }}</td>
                        @foreach ($subjects as $subject)
                            @php
                                $course_grade = $grades->where('student_educational_id', $student->id)->where('subject_id', $subject->id)->first() ?? new App\Models\CourseGrade();
                                $marks = $course_grade != null ? $course_grade->grade : 0;
                                $grade = '';
                                if ($marks >= 95) {
                                    $grade = 'A+';
                                } elseif ($marks >= 90) {
                                    $grade = 'A';
                                } elseif ($marks >= 85) {
                                    $grade = 'B+';
                                } elseif ($marks >= 80) {
                                    $grade = 'B';
                                } elseif ($marks >= 75) {
                                    $grade = 'C+';
                                } elseif ($marks >= 70) {
                                    $grade = 'C';
                                } elseif ($marks >= 65) {
                                    $grade = 'D+';
                                } elseif ($marks >= 60) {
                                    $grade = 'D';
                                } else {
                                    $grade = 'F';
                                }
                                if (str_contains($course_grade->status, 'Fail')) {
                                    $grade = 'F';
                                }
                            @endphp
                            @if ($is_hod)
                                <td>
                                    {{ $marks }}
                                </td>
                            @endif
                            <td>
                                {{ $subject->name == 'English' ? $course_grade->status : $grade }}
                            </td>
                        @endforeach
                    </tr>
                @endforeach
            </tbody>
        </table>
        @if ($is_hod)
            {{-- signature --}}
            <div style="width: 100%; display: flex; justify-content: space-between; margin-top: 30px;">
                <div style="width: 33%; display: inline-block; text-align: center;">
                    <p>Instructor 1</p>
                </div>
                <div style="width: 33%; display: inline-block; text-align: center;">
                    <p>Instructor 2</p>
                </div>
                <div style="width: 33%; display: inline-block; text-align: center;">
                    <p>HOD</p>
                </div>
            </div>
        @else
            <p style="text-align: left; font-size: 16px; font-weight: bold;">
                * F = Fail<br />
                * If any result is Fail. Please refer to make up schedule.
            </p>
        @endif
@endsection