@php
    $aadhar = isset($customFields) && in_array('aadhar_number', $customFields) ? 1 : 0;
    $doj = isset($customFields) && in_array('date_of_joining', $customFields) ? 1 : 0;
@endphp
<div class="row">
    <div class="col-xs-12">
        <div class="white-box">
            <div class="table-responsive">
                <div class="row">
                    <div class="col-md-12">
                        <table class="table table-bordered" id="request1">
                            <thead>
                                <tr>
                                    <th colspan="35" style="font-weight:bold;text-align: center;">
                                        {{ $organization->name }} Performance Register - {{ $month_name }}
                                        {{ $year_id }}</th>
                                </tr>
                            </thead>
                            <tbody>


                                @foreach ($attendanceSummary as $key => $value)
                                    @php
                                        $rowSpan = 9;
                                        if($user->can_role('Performance Incentive Hours')){
                                            $rowSpan++;
                                        }
                                        $tolalDays = count($dateArr);
                                        $value->load([
                                            'vwAttendanceSummary' => function ($q) use ($month_id, $year_id) {
                                                $q->where('month', '=', $month_id)->where('year', '=', $year_id);
                                            },
                                        ]);
                                    @endphp
                                    <tr></tr>
                                    <tr>
                                        <td colspan="{{ count($dateArr) + 6 }}" style="text-align: center;">
                                            @if (!empty($value->vwAttendanceSummary))
                                                <strong>{{ trans('master/master.present') }}</strong>:
                                                {{ $value->vwAttendanceSummary->total_present }} &emsp;
                                                <strong>{{ trans('master/master.absent') }}</strong>:
                                                {{ $value->vwAttendanceSummary->total_absent }} &emsp;
                                                <strong>{{ trans('master/master.leave') }}</strong>:
                                                {{ $value->vwAttendanceSummary->total_leave }} &emsp;
                                                <strong>{{ trans('master/master.paid_leave') }}</strong>:
                                                {{ $value->vwAttendanceSummary->paid_leave }} &emsp;
                                                <strong>{{ trans('master/master.unpaid_leave') }}</strong>:
                                                {{ $value->vwAttendanceSummary->unpaid_leave }} &emsp;
                                                <strong>{{ trans('master/master.holiday') }}</strong>:
                                                {{ $value->vwAttendanceSummary->total_holiday }} &emsp;
                                                <strong>{{ trans('master/master.week_off') }}</strong>:
                                                {{ $value->vwAttendanceSummary->total_week_off }} &emsp;
                                                <strong>{{ trans('master/master.fine_days') }}</strong>:
                                                {{ round(@$value->vwAttendanceSummary->total_fine_days, 2) }} &emsp;
                                                <strong>Total Penalty Minutes</strong>:
                                                {{ round(@$value->vwAttendanceSummary->total_penalty_minutes) }} &emsp;
                                                <strong>{{ trans('master/master.pay_days') }}</strong>:
                                                {{ round(@$value->vwAttendanceSummary->total_pay_days, 2) }} &emsp;
                                                
                                                <strong>{{ trans('attendance/admin.working_hours') }}</strong>:
                                                {{ number_format(@$value->vwAttendanceSummary->total_working_time, 2) }}
                                                ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds($value->vwAttendanceSummary->total_working_time) }}) &emsp;

                                                <strong>{{ trans('master/master.actual_ot_hours') }}</strong>:
                                                {{ number_format(@$value->vwAttendanceSummary->actual_overtime, 2) }}
                                                ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds(@$value->vwAttendanceSummary->actual_overtime ?: 0) }}) &emsp;

                                                <strong>{{ trans('master/master.approved_ot_hours') }}</strong>:
                                                {{ number_format(@$value->vwAttendanceSummary->total_overtime, 2) }}
                                                ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds($value->vwAttendanceSummary->total_overtime) }}) &emsp;

                                                <strong>{{ trans('master/master.productive_hour') }} </strong>:
                                                {{ number_format(@$value->vwAttendanceSummary->total_productive_hours, 2) }}
                                                ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds(@$value->vwAttendanceSummary->total_productive_hours ?: 0) }}) &emsp;

                                                @if ($user->can_role('Performance Incentive Hours'))
                                                    <strong>{{ trans('master/master.incentive_hours') }} </strong>:
                                                    {{ number_format(@$value->vwAttendanceSummary->total_incentive_hours, 2) }}
                                                    ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds(@$value->vwAttendanceSummary->total_incentive_hours ?: 0) }}) &emsp;
                                                @endif
                                            @endif
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.sr_no') }}</strong>
                                        </td>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.name') }}</strong>
                                        </td>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.employee_code') }}</strong>
                                        </td>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.department') }}</strong>
                                        </td>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.designation') }}</strong>
                                        </td>
                                    @if($hideColumns)
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.father_name') }}</strong>
                                        </td>
                                        
                                        @if ($aadhar)
                                            <td class="text-nowrap">
                                                <strong>
                                                    Aadhar
                                                </strong>
                                            </td>
                                        @endif
                                        @if ($doj)
                                            <td class="text-nowrap">
                                                <strong>
                                                    DOJ
                                                </strong>
                                            </td>
                                        @endif
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.workstation') }}</strong>
                                        </td>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.employee_type') }}</strong>
                                        </td>
                                        <td class="text-nowrap">
                                            <strong>{{ trans('master/master.remark') }}</strong>
                                        </td>
                                    @endif
                                        <td class="text-nowrap"></td>

                                        @foreach ($dateArr as $dates)
                                            <td class="text-nowrap">{{ date('d', strtotime($dates)) }}
                                                ({{ date('D', strtotime($dates)) }})
                                            </td>
                                        @endforeach

                                    </tr>

                                    <tr>
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}"><strong>{{ $key + 1 }}</strong>
                                        </td>
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ @$value->name }}</strong>
                                        </td>
                                        
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ @$value->employee_code }}</strong>
                                        </td>
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ @$value->department->name }}</strong>
                                        </td>
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ @$value->designation->name }}</strong>
                                        </td>
                                    @if($hideColumns)
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ @$value->father_name }}</strong>
                                        </td>
                                        
                                        @if ($aadhar)
                                            <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                                <strong>{{ @$value->aadhar_number }}</strong>
                                            </td>
                                        @endif
                                        @if ($doj)
                                            <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                                <strong>{{ $value->date_of_joining ? date('d-M-Y', strtotime($value->date_of_joining)) : '' }}</strong>
                                            </td>
                                        @endif
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ @$value->workstation->name }}</strong>
                                        </td>
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ ucwords(@$value->employee_type) }}</strong>
                                        </td>
                                        <td class="text-nowrap" rowspan="{{$rowSpan}}">
                                            <strong>{{ ucwords(@$value->remarks) }}</strong>
                                        </td>
                                    @endif
                                        @php
                                            //$atSummary = $vATBBCwbfWp58mB3UgBZecvEAhatXF1FBB3F9alue->getAttendanceSummaryList($month_id, $year_id);
                                            $atSummary = $value->getAttendanceSummaryFilter($fromDate, $toDate);
                                        @endphp
                                        <td class="text-nowrap"><strong>{{ trans('master/master.in') }}: </strong></td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif
                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                if (
                                                    @$attendance->entry_mode == \App\Helpers\ConstantHelper::REGULARIZED
                                                ) {
                                                    $boxColor = '#198754';
                                                } elseif (
                                                    @$attendance->entry_mode == \App\Helpers\ConstantHelper::MODIFIED
                                                ) {
                                                    $boxColor = '#0dcaf0';
                                                } else {
                                                    $boxColor = 'none';
                                                }
                                            @endphp

                                            <td class="text-nowrap" style="background:{{ $boxColor }}">
                                                {{ $attendance->in_time ? date('H:i', strtotime($attendance->in_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.out') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                if (
                                                    @$attendance->entry_mode == \App\Helpers\ConstantHelper::REGULARIZED
                                                ) {
                                                    $boxColor = '#198754';
                                                } elseif (
                                                    @$attendance->entry_mode == \App\Helpers\ConstantHelper::MODIFIED
                                                ) {
                                                    $boxColor = '#0dcaf0';
                                                } else {
                                                    $boxColor = 'none';
                                                }
                                            @endphp

                                            <td class="text-nowrap" style="background:{{ $boxColor }}">
                                                {{ $attendance->out_time ? date('H:i', strtotime($attendance->out_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.in_sub_location') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>
                                                @continue;
                                            @endif
                                            <td class="text-nowrap">
                                                {{ $atSummary[$date]->in_address['sub_location_name'] ?? '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.out_sub_location') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>
                                                @continue;
                                            @endif
                                            <td class="text-nowrap">
                                                {{ $atSummary[$date]->out_address['sub_location_name'] ?? '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('attendance/admin.working_hours') }}:
                                            </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp
                                            <td class="text-nowrap">
                                                {{ $attendance->working_time && $attendance->working_time != '00:00:00' ? date('H:i', strtotime($attendance->working_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.actual_overtime') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp

                                            <td class="text-nowrap">
                                                {{ $attendance->actual_overtime && $attendance->actual_overtime != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->actual_overtime) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.approved_overtime') }}:
                                            </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp

                                            <td class="text-nowrap">
                                                {{ $attendance->overtime && $attendance->overtime != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->overtime) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    @if ($user->can_role('Performance Incentive Hours'))
                                        <tr>
                                            <td class="text-nowrap">
                                                <strong>{{ trans('master/master.incentive_hours') }}:</strong>
                                            </td>
                                            @foreach ($dateArr as $date)
                                                @if (!isset($atSummary[$date]))
                                                    <td>-</td>
                                                @else
                                                    @php
                                                        $attendance = $atSummary[$date];
                                                    @endphp
                                                    <td class="text-nowrap">
                                                        {{ $attendance->incentive_hours && $attendance->incentive_hours != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->incentive_hours) : '-' }}
                                                    </td>
                                                @endif
                                            @endforeach
                                        </tr>
                                    @endif
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.status') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp
                                            <td class="text-nowrap">
                                                {{ $attendance->first_half_status }} @if ($attendance->first_half_status == 'L')
                                                    ({{ strtoupper($attendance->leave_type) }})
                                                @endif <br>
                                                {{ $attendance->second_half_status }} @if ($attendance->second_half_status == 'L')
                                                    ({{ strtoupper($attendance->leave_type) }})
                                                @endif
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="font-weight:bold;">
                                            <strong>{{ trans('master/master.final_status') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp
                                            <td>{{ $attendance->status }}{{ $attendance->is_wfh ? '(WFH)' : '' }}</td>
                                        @endforeach
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>