@extends('layout.report', ['max_width' => '100%'])
@section('report')
@php
$sums = [];
@endphp
    <h1>Missed Hours Report</h1>
    <pre>{{ $group->name }}      {{ 'Week ' . $from . ' to ' . $to }}        {{ 'exported at: ' . date('d-m-Y H:i') }}</pre>
    <table>
        <thead>
            <tr>
                <th rowspan="2">no</th>
                <th colspan="2" rowspan="2">Name</th>
                @foreach ($courses as $course)
                    <th colspan="2">{{ $course->name }}</th>
                @endforeach
                {{-- <th colspan="2">Morning Assembly</th> --}}
                <th colspan="2">Total</th>
            </tr>
            <tr>
                @foreach ($courses as $course)
                    @php
                        $sums[$course->id] = [
                            'missed' => 0,
                            'excused_hours' => 0,
                        ];
                    @endphp
                    <th>missed</th>
                    <th>execuse</th>
                @endforeach
                @php
                    $sums['morning'] = [
                        'missed' => 0,
                        'excused_hours' => 0,
                    ];
                    $sums['total'] = [
                        'missed' => 0,
                        'excused_hours' => 0,
                    ];
                @endphp
              {{--  <th>missed</th>--}}
              {{--  <th>execuse</th>--}}
                <th>missed</th>
                <th>execuse</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($students as $student)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td colspan="2">{{ $student->user->name }}</td>
                    @foreach ($courses as $course)
                    @php
                        $missed = $student->missedHours($course->id, $from, $to);
                        $excused = $student->excusedHours($course->id, $from, $to);
                        $sums[$course->id]['missed'] += $missed;
                        $sums[$course->id]['excused_hours'] += $excused;
                    @endphp

                        <td>{{ $missed }}</td>
                        <td>{{ $excused }}</td>
                    @endforeach
                    @php
                     //   $total_morning = max(0,$student->morningAbsences($from, $to)->sum('total_missed_hours'));
                     //   $excused_morning = $student->morningAbsences($from, $to, false, true)->sum('excused_hours');

                        $total_missed = $student->missedHours(null, $from, $to);
                        $total_excused = $student->excusedHours(null, $from, $to, false, true);

                        $sums['total']['missed'] += $total_missed;
                        $sums['total']['excused_hours'] += $total_excused;

                    //    $sums['morning']['missed'] += $total_morning;
                    //    $sums['morning']['excused_hours'] += $excused_morning;
                    @endphp
                  {{--  <td>{{ $total_morning }}</td>--}}
                   {{-- <td>{{ $excused_morning }}</td>--}}
                    <td>{{ $total_missed }}</td>
                    <td>{{ $total_excused }}</td>
                </tr>
            @endforeach
            <tr>
                <td colspan="3">Total</td>
                @foreach ($courses as $course)
                    <td>{{ $sums[$course->id]['missed'] }}</td>
                    <td>{{ $sums[$course->id]['excused_hours'] }}</td>
                @endforeach
             {{--   <td>{{ $sums['morning']['missed'] }}</td>--}}
              {{--  <td>{{ $sums['morning']['excused_hours'] }}</td>--}}
                <td>{{ $sums['total']['missed'] }}</td>
                <td>{{ $sums['total']['excused_hours'] }}</td>
            </tr>
        </tbody>
    </table>
@endsection