@foreach ($contractors as $contractor)
<div class="table-responsive">
    <table class="table mb-0 emp_table">
        <thead>
            <tr>
                <th colspan="{{($shifts->count() * 3) + 5}}" style="font-weight:bold; text-align: center;">{{ $contractor->name }}</th>
            </tr>
            <tr>
                <th></th>
                <th></th>
    
                @foreach ($shifts as $shift)
                    <th class="text-center" colspan="3" style="font-weight:bold; text-align: center;">
                        {{ $shift->name }}</th>
                @endforeach
                <th class="text-center" colspan="6" style="font-weight:bold; text-align: center;">
                    {{ trans('master/master.total') }}</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td style="font-weight:bold;">{{ trans('master/master.department') }}</td>
                <td style="font-weight:bold;">{{ trans('master/master.designation') }}</td>

                @foreach ($shifts as $shift)
                    <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.planned') }}</td>
                    <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.present') }}</td>
                    <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.difference') }}</td>
                @endforeach
                <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.planned') }}</td>
                <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.present') }}</td>
                <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.difference') }}</td>
                <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.late_coming') }}</td>
                <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.short_excess_variance') }}</td>
                <td class="text-nowrap" style="font-weight:bold;">{{ trans('master/master.late_coming_variance') }}</td>
            </tr>

            @php
                $totalArray = [];
                
                $data = $rotaProcess->getContractorWiseDailyEmployeesData($organization, $contractor->id, $date, $shifts, $departments, $designations);
            @endphp

            
            @foreach ($departments as $department)
                @foreach ($designations as $designation)
                    @if($data[$department->id][$designation->id]['no_of_employees'])
                        <tr>
                            <td style="font-weight:bold;">{{ $department->name }}</td>
                            <td style="font-weight:bold;">{{ $designation->name }}</td>
                            @php
                                $totalPlan = 0;
                                $totalPresent = 0;
                                $totalDifference = 0;
                                $totalLateCount = 0;
                            @endphp
                            @foreach ($shifts as $shift)
                                @php
                                    $plannedCount = $data[$department->id][$designation->id][$shift->id]['planned_count'];
                                    $presentCount = $data[$department->id][$designation->id][$shift->id]['present_count'];
                                    $lateCount = $data[$department->id][$designation->id][$shift->id]['late_count'];
                                    $differenceCount = $data[$department->id][$designation->id][$shift->id]['difference'];

                                    if (!isset($totalArray[$shift->id])) {
                                        $totalArray[$shift->id] = [
                                            'planned' => 0,
                                            'present' => 0,
                                            'diff' => 0,
                                            'late_count' => 0,
                                        ];
                                    }
                                    $totalPlan += $plannedCount;
                                    $totalPresent += $presentCount;
                                    $totalDifference += $differenceCount;
                                    $totalLateCount += $lateCount;
                                    
                                    $totalArray[$shift->id]['planned'] += $plannedCount;
                                    $totalArray[$shift->id]['present'] += $presentCount;
                                    $totalArray[$shift->id]['diff'] += $differenceCount;
                                    $totalArray[$shift->id]['late_count'] += $lateCount;
                                @endphp

                                <td class="text-nowrap">{{ $plannedCount }}</td>
                                <td class="text-nowrap">{{ $presentCount }}</td>
                                <td class="text-nowrap">{{ $presentCount - $plannedCount }}</td>
                            @endforeach
                            <td class="text-nowrap">{{ $totalPlan }}</td>
                            <td class="text-nowrap">{{ $totalPresent }}</td>
                            <td class="text-nowrap">{{ $totalDifference }}</td>
                            <td class="text-nowrap">{{ $totalLateCount }}</td>
                            @php
                                $shortExcessVariance = $totalPlan > 0 ? round($totalDifference / $totalPlan * 100, 2) : "-";
                                $shortExcessVarianceBg = '';
                                if($shortExcessVariance != '-' && $shortExcessVariance != 0 && isset($contractor->userDetail->short_excess_variance) && abs($shortExcessVariance) > $contractor->userDetail->short_excess_variance){
                                    $shortExcessVarianceBg = 'text-danger';
                                }else{
                                    $shortExcessVarianceBg = 'text-success';
                                }
                            
                                $lateComingVariance = $totalPresent > 0 ? round($totalLateCount / $totalPresent * 100, 2) : "-";
                                $lateComingVarianceBg = '';
                                if($lateComingVariance != '-' && $lateComingVariance != 0 && isset($contractor->userDetail->late_coming_variance) && abs($lateComingVariance) > $contractor->userDetail->late_coming_variance){
                                    $lateComingVarianceBg = 'text-danger';
                                }else{
                                    $lateComingVarianceBg = 'text-success';
                                }
                            @endphp
                            <td class="text-nowrap {{ $shortExcessVarianceBg }}">{{ $shortExcessVariance }} %</td>
                            <td class="text-nowrap {{ $lateComingVarianceBg }}">{{ $lateComingVariance }} %</td>
                        </tr>
                    @endif
                @endforeach
            @endforeach

            @if(count($totalArray) > 0)
            <tr>
                <td colspan="2" style="font-weight:bold">{{ trans('master/master.total') }}</td>

                @php
                    $totalPlanG = 0;
                    $totalPresentG = 0;
                    $totalDifferenceG = 0;
                    $totalLateCountG = 0;
                @endphp

                @foreach ($shifts as $shift)
                    @php
                        $totalPlanG += $totalArray[$shift->id]['planned'];
                        $totalPresentG += $totalArray[$shift->id]['present'];
                        $totalDifferenceG += $totalArray[$shift->id]['diff'];
                        $totalLateCountG += $totalArray[$shift->id]['late_count'];
                    @endphp
                    <td class="sum_contractor_plan_emp{{ $loop->iteration }}"
                        style="font-weight:bold">
                        {{ $totalArray[$shift->id]['planned'] }}
                    </td>
                    <td class="sum_contractor_present_emp{{ $loop->iteration }}"
                        style="font-weight:bold">
                        {{ $totalArray[$shift->id]['present'] }}
                    </td>
                    <td class="sum_contractor_absent_emp{{ $loop->iteration }}"
                        style="font-weight:bold">
                        {{ $totalArray[$shift->id]['diff'] }}
                    </td>
                @endforeach

                <td class="total_sum_plan_emp" style="font-weight:bold">{{ $totalPlanG }}</td>
                <td class="total_sum_present_emp" style="font-weight:bold">{{ $totalPresentG }}</td>
                <td class="total_sum_absent_emp" style="font-weight:bold">{{ $totalDifferenceG }}</td>
                <td class="total_sum_absent_emp" style="font-weight:bold">{{ $totalLateCountG }}</td>
                @php
                    $shortExcessVarianceG = $totalPlanG > 0 ? round($totalDifferenceG / $totalPlanG * 100, 2) : "-";
                    $shortExcessVarianceBgG = '';
                    if($shortExcessVarianceG != '-' && $shortExcessVarianceG != 0 && isset($contractor->userDetail->short_excess_variance) && abs($shortExcessVarianceG) > $contractor->userDetail->short_excess_variance){
                        $shortExcessVarianceBgG = 'text-danger';
                    }else{
                        $shortExcessVarianceBgG = 'text-success';
                    }
                    
                    $lateComingVarianceG = $totalPresentG > 0 ? round($totalLateCountG / $totalPresentG * 100, 2) : "-";
                    $lateComingVarianceBgG = '';
                    if($lateComingVarianceG != '-' && $lateComingVarianceG != 0 && isset($contractor->userDetail->late_coming_variance) && abs($lateComingVarianceG) > $contractor->userDetail->late_coming_variance){
                        $lateComingVarianceBgG = 'text-danger';
                    }else{
                        $lateComingVarianceBgG = 'text-success';
                    }
                @endphp
                <td class="text-nowrap {{ $shortExcessVarianceBgG }}" style="font-weight:bold">{{ $shortExcessVarianceG }} %</td>
                <td class="text-nowrap {{ $lateComingVarianceBgG }}" style="font-weight:bold">{{ $lateComingVarianceG }} %</td>
            </tr>
            @endif
        </tbody>
    </table>
</div>
@endforeach