@extends('layout.report', ['max_width' => '100%'])
@section('report')
    <style>
        body {
            padding: 20px;
        }

        td {
            background-color: transparent !important;
            border: none !important;
            text-align: left !important;
            padding: 8px !important;

        }

        tr {
            border: none !important;
            background-color: transparent !important;
            text-align: left !important;
        }

        th {
            background-color: transparent !important;
            border: none !important;
            text-align: left !important;
            padding: 8px !important;
        }

        thead,
        tfoot {
            border: 1px dashed #000;
            border-collapse: collapse;
        }

        thead {
            height: 48px;
        }

        tfoot {
            height: 80px;
        }

        tfoot tr {
            border: 1px dashed #000 !important;
        }

        table {
            padding: 20px;
            border: 1px dashed #000;
            border-collapse: collapse;
        }

        .grid-container {
            display: grid;
            grid-template-columns: repeat(2, 1fr);
            gap: 20px;
        }

        #logo {
            opacity: 0;
        }

        .title-section {
            display: flex;
            justify-content: space-between;
            text-align: left;
            margin-top: 30mm;
        }

        .half {
            text-align: left !important;
        }

        .stamps {
            display: flex;
            justify-content: space-between;
            text-align: left;
            margin-top: 20px;
            margin-bottom: 20px;
        }
    </style>
    @php
        $totalGrade = 0;
        $totalCreditHours = 0;
        $index = 1;
        $total_points = 0;
    @endphp

    <div class="title-section">
        <div class="half">
            <b>Name:</b> {{ $student->user->name }} <br />
            <b>Id Number:</b> {{ $student->user->id_number }} <br />
        </div>
        <div class="half">
            <b>Academic Number:</b> {{ $student->student_number }} <br />
            <b>Status:</b> {{ $student->student->status_name }} <br />
        </div>

    </div>

    @php
        function getName($semester)
        {
            $courses = $semester->sortBy('subject_id');
            return $semester = $courses->first()->semester->name;
        }
        $semesters = $semesters->sort(function ($a, $b) {
            return getName($a) > getName($b);
        });
    @endphp

    <div class="grid-container">
        @foreach ($semesters as $courses)
            @php
                $courses = $courses->sortBy('subject_id');
                $semester = $courses->first()->semester;
                $grade = 0;
                $creditHours = 0;

                $points = 0;
            @endphp

            <div>

                <h5>Semester {{ $index++ }} {{ $semester->label }}</h5>
                <table>
                    <thead>
                        <tr>
                            <th style="width: 200px;">Subject</th>
                            <th>Grade</th>
                            <th>Credit</th>
                            <th>Quality Points</th>
                        </tr>
                    </thead>
                    <tbody style="height: 200px;">
                        @foreach ($courses as $course)
                            @if ($course->grade <= 45)
                                @continue
                            @endif
                            <tr>
                                <td style="width: 200px;">{{ $course->subject->name }}</td>
                                <td>{{ $course->final }}</td>
                                <td>{{ valOrNA($course->credit_hours) }}</td>
                                <td>{{ valOrNA($course->quality_points) }}</td>
                                @php
                                    $grade += $course->grade * $course->credit_hours;
                                    $points += $course->quality_points;
                                    $creditHours += $course->credit_hours;
                                    $totalGrade += $course->grade * $course->credit_hours;
                                    $total_points += $course->quality_points;
                                    $totalCreditHours += $course->credit_hours;
                                @endphp
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="footer">
                            <th>Current</th>
                            @if ($creditHours != 0)
                                <th>{{ round($points / $creditHours, 2) }}</th>
                            @else
                                <th>0</th>
                            @endif
                            <th>{{ $creditHours }}</th>
                            <th>{{ $points }}</th>
                        </tr>
                        <tr class="footer">
                            <th>Cumulative</th>
                            @if ($totalCreditHours != 0)
                                <th>{{ round($total_points / $totalCreditHours, 2) }}</th>
                            @else
                                <th>0</th>
                            @endif
                            <th>{{ $totalCreditHours }}</th>
                            <th>{{ $total_points }}</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        @endforeach
    </div>
    <div class="tail" style="margin-top: 12px;">
        <h5>End of Trainee's Record</h5>
        @if ($totalCreditHours != 0)
            <h4>Cumulative GPA: {{ round($total_points / $totalCreditHours, 2) }}</h4>
        @endif
    </div>
    <div class="stamps">
        <div>
            <h3>Mr. Radhi Eid Al-Shammari</h3>
            <h5>Deputy Executive Director</h5>
        </div>
        <div>
            <span>Print Date: {{ date('d/m/Y') }}</span>
        </div>
    </div>

    <pre>N/A = Not Applicable     *=OJT retaken</pre>