@extends('layout.report', ['max_width' => '1200px'])
@section('report')
    <h1>Trainee Status Report</h1>
    <pre>{{ $group->name }}     {{ $course ? $course->name : '          ' }}      {{ 'Week ' . $from . ' to ' . $to }}        {{ 'exported at: ' . date('d-m-Y H:i') }}</pre>
    <table>
        <thead>
            <tr>
                <th>Trainee Number</th>
                <th colspan="2" style="min-width: 300px">Name</th>
                <th>Last 4w%</th>
                <th>Real%</th>
                <th>Final%</th>
                <th>Excuse%</th>
                <th>Bonus</th>
                <th>Probation</th>
                <th>Trainee Statement</th>
                <th style="min-width: 150px">Note</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($students as $student)
                <tr>
                    <td>{{ $student->student_number }}</td>
                    @php
                        $course ??= new App\Models\Course();
                    @endphp
                    <td colspan="2" style="min-width: 300px">{{ $student->user->name }}</td>
                    <td>{{ $student->absencePercentage($course->id, max(getCurrentWeek() - 4, 0), getCurrentWeek()) }}</td>
                    <td>{{ $student->absencePercentage($course->id, $from, $to) }}</td>
                    <td>{{ $student->absencePercentage($course->id, $from, $to) - $student->absencePercentage($course->id, $from, $to, false, true) -  ($student->bonuses->first() ? 5:0) }}
                    </td>
                    <td>{{ $student->absencePercentage($course->id, $from, $to, false, true) }}</td>
                    <td>
                        {{ $student->bonuses->first() ? $student->bonuses->first()->created_at->format('Y-m-d') : 'NA' }}
                    </td>
                    <td>
                        {{ $student->probations->first() ? $student->probations->first()->created_at->format('Y-m-d') : 'NA' }}
                    </td>
                    <td></td>
                    <td style="min-width: 150px"></td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection