@extends('layout.report', ['max_width' => '1200px'])

@section('report')
    <h1>Under Performers Report</h1>
    <pre>
 
        {{ $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>Phone</th>
                <th>Average attitude</th>
                <th>Absence%</th>
                <th>Incident Report</th>
                @foreach($mup_names as $mup_name)
                    <th>{{ $mup_name }} MUP</th>
                    @foreach($group->courses as $co)
                        <th>{{ $mup_name }} MUP {{ $co->name }}</th>
                    @endforeach
                @endforeach
                @foreach($group->courses as $co)
                    <th>Avg Gr {{ $co->name }}</th>
                @endforeach
            {{--    <th>Average Grading</th> --}}
            </tr>
        </thead>
        <tbody>
            @foreach ($students as $student)
                @php
                    $isUnder = $check_mup 
                        ? ($student->isUnderPerforming($course->id, $from, $to, 3) 
                           || $student->isUnderPerforming($course->id, $from, $to, 4) 
                           || $student->isUnderPerforming($course->id, $from, $to, 5))
                        : $student->isUnderPerforming($course->id, $from, $to, $mup_grades[0]);
                @endphp

                @if($isUnder)
                    <tr>
                        <td>{{ $student->student_number }}</td>
                        <td colspan="2">{{ $student->user->name }}</td>
                        <td>{{ $student->user->phone }}</td>
                        <td>{{ $student->averageGradeAttitude($course->id, $from, $to) }}</td>
                        @php
                            $absencePercentage = $student->absencePercentage($course->id, $from, $to , false,false,true);
                        @endphp
                        <td style="color: {{ $absencePercentage > 5 ? 'red' : 'black' }}">{{$absencePercentage}}</td>
                        <td>{{ $data = app('App\Models\IncidentAll')->allIncidents([ "students" => [$student->student_number] ])->count()}}</td>

                        @foreach($mup_grades as $mup_grade)
                            <td>{{ $student->makeUpAtGrade($mup_grade, $course->id, $from, $to) }}</td>
                            @foreach($group->courses as $co)
                                <td>{{ $student->makeUpAtGrade($mup_grade, $co->id, $from, $to) }}</td>
                            @endforeach
                        @endforeach

                        @foreach($group->courses as $co)
                            @php
                             $grade =  $student->averageGrade($co->id, $from, $to)
                            @endphp
                            <td style="color: {{ $grade < 60 ? 'red' : 'black' }}">{{ $grade }}</td>
                        @endforeach
                        {{--<td>{{ $student->averageGrade($course->id, $from, $to) }}</td>--}}
                    </tr>
                @endif
            @endforeach
        </tbody>
    </table>
@endsection