@extends('app-new')
@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">

    <!-- BEGIN: Page CSS-->
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <!-- END: Page CSS-->
    <style>
        .select2-container {
            width: 100% !important;
        }

        .select2-container--default .select2-selection--multiple .select2-selection__choice {
            max-width: 100%;
            white-space: nowrap;
            overflow: hidden;
            text-overflow: ellipsis;
        }

        .select2-container--default .select2-results__option {
            white-space: nowrap;
        }
    </style>
@endpush

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">{{ trans('master/master.monthly_performance_report') }}</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{ trans('common/common.home') }}</a>
                    </li>
                    <li class="breadcrumb-item active">{{ trans('master/master.performance_register') }}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">

        <!-- Filters -->
        <form action="{{ "$orgUrl/attendance-report/performance-register" }}" id="filter-form" method="GET">
            <input type="hidden" id="filename"
                value="{{ $organization->name }} Performance Register - {{ $month_name }} {{ $year_id }}">
            <input type="hidden" id="organization_name" value="{{ $organization->name }}">
            <input type="hidden" id="month_name" value="{{ $month_name }}">
            <input type="hidden" id="sublocation_selected_id" value="{{ json_encode($subLocationIds) }}">

            <div class="content-header row">
                <div class="content-header-left col-md-9 col-12 mb-2">
                    <div class="row breadcrumbs-top">
                        <div class="col-12">
                            <h2 class="content-header-title float-start mb-0"></h2>

                        </div>
                    </div>
                </div>
                <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
                    <div class="mb-1 breadcrumb-right">
                        <div class="dropdown">
                            <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                                data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                                type="button"><i data-feather='filter'></i></button>
                        </div>
                    </div>
                </div>
            </div>

            <div class="offcanvas-end-example">
                <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
                    <div class="offcanvas-header">
                        <h5 id="offcanvasEndLabel" class="offcanvas-title">{{ trans('common/common.filter') }}</h5>
                        <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas"
                            aria-label="Close"></button>
                    </div>
                    <div class="offcanvas-body my-auto mx-0 flex-grow-0">

                        <label class="form-label mt-2 month_id" for="area_id">{{ trans('common/common.month') }}</label>
                        <select class="form-control select2 month_id" name="month_id" id="month_id">
                            @foreach ($month as $mkey => $monthitem)
                                <option value="{{ $mkey }}" @if ($mkey == $month_id || old('month_id') == $mkey) selected @endif>
                                    {{ $monthitem }}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2 year_id" for="area_id">{{ trans('common/common.year') }}</label>
                        <select class="form-control select2 year_id" name="year_id" id="year_id">
                            @foreach ($year as $ykey => $yearitem)
                                <option value="{{ $yearitem }}" @if ($yearitem == $year_id || old('year_id') == $yearitem) selected @endif>
                                    {{ $yearitem }}</option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="date_range">Date range</label>
                        <input type="text" id="date_range" name="date_range" value="{{ $dateRange }}"
                            class="form-control daterangebg">
                        {!! $errors->first('date_range', '<label class="control-label error" for="date_range">:message</label>') !!}


                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.location') }}</label>
                        <select class="form-control select2" name="location_id[]" id="location_id"
                            onchange="getsubLocations(this,'sublocations')" multiple>
                            @foreach ($locations as $location)
                                <option value="{{ $location->id }}" @if ($locationIds && in_array($location->id, $locationIds)) selected @endif>
                                    {{ $location->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.sub_location') }}</label>
                        <select class="form-control select2" name="sub_location_id[]" id="sub_location_id" multiple>
                            @foreach ($subLocations as $subLocation)
                                <option value="{{ $subLocation->id }}" @if ($subLocationIds && in_array($subLocation->id, $subLocationIds)) selected @endif>
                                    {{ $subLocation->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.department') }}</label>
                        <select class="form-control select2" name="department_id[]" id="department_id" multiple>
                            @foreach ($departments as $department)
                                <option value="{{ $department->id }}" @if ($departmentIds && in_array($department->id, $departmentIds)) selected @endif>
                                    {{ $department->name }}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.sub_department') }}</label>
                        <select class="form-control select2" name="sub_department_id[]" id="sub_department_id" multiple>
                            @foreach ($subDepartments as $subDepartment)
                                <option value="{{ $subDepartment->id }}"
                                    @if ($subDepartmentIds && in_array($subDepartment->id, $subDepartmentIds)) selected @endif>{{ $subDepartment->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.designation') }}</label>
                        <select class="form-control select2" name="designation_id[]" id="designation_id" multiple>
                            @foreach ($designations as $designation)
                                <option value="{{ $designation->id }}" @if ($designationIds && in_array($designation->id, $designationIds)) selected @endif>
                                    {{ $designation->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.manager') }}</label>
                        <select class="form-control select2" name="manager_id[]" id="manager_id" multiple>
                            <option value="">Select Manager</option>
                            {{-- Rest will be set by JS --}}
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.workstation') }}</label>
                        <select class="form-control mb-2 select2" name="work_station_id[]" id="work_station_id" multiple>
                            @foreach ($workstations as $workstation)
                                <option value="{{ $workstation->id }}" @if ($workstationIds && in_array($workstation->id, $workstationIds)) selected @endif>
                                    {{ $workstation->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.category') }}</label>
                        <select class="form-control mb-2 select2" name="category_id[]" id="category_id" multiple>
                            @foreach ($categories as $category)
                                <option value="{{ $category->id }}" @if ($categoryIds && in_array($category->id, $categoryIds)) selected @endif>
                                    {{ $category->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.company_code') }}</label>
                        <select class="form-control mb-2 select2" name="company_code_id[]" id="company_code_id" multiple>
                            @foreach ($companyCodes as $companyCode)
                                <option value="{{ $companyCode->id }}" @if ($companyCodeIds && in_array($companyCode->id, $companyCodeIds)) selected @endif>
                                    {{ $companyCode->number }}
                                </option>
                            @endforeach
                        </select>
                        @if (Auth::user()->is_contractor == 0)
                            <label class="form-label mt-2" for="area_id">{{ trans('master/master.contractor') }}</label>
                            <select class="form-control select2" name="contractor_id[]" id="contractor_id" multiple>
                                @foreach ($contractors as $contractor)
                                    <option value="{{ $contractor->id }}"
                                        @if ($contractorIds && in_array($contractor->id, $contractorIds)) selected @endif>
                                        {{ $contractor->name }}
                                    </option>
                                @endforeach
                            </select>
                        @endif
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.employee_type') }}</label>
                        @if (Auth::user()->is_contractor == 0)
                            <select class="form-control mb-2 select2" name="employee_type" id="employee_type">
                                <option value="">Select {{ trans('master/master.type') }}</option>
                                @foreach ($employeeTypes as $empType)
                                    <option value="{{ $empType }}"
                                        @if ($empType == $employeeTypeSelected) selected @endif>
                                        {{ ucwords($empType) }}
                                    </option>
                                @endforeach
                            </select>
                        @else
                            <select class="form-control mb-2 select2" name="employee_type" id="employee_type">
                                <option value="">Select {{ trans('master/master.type') }}</option>
                                <option value="{{ $employeeType }}" @if ($employeeType == $employeeTypeSelected) ) selected @endif>
                                    {{ ucwords($employeeType) }}
                                </option>
                            </select>
                        @endif

                        <label class="form-label mt-2"
                            for="employee_id">{{ trans('employee/employee_create.employee') }}</label>
                        <select class="form-control select2" id="employee_id" name="employee_id[]" multiple>
                            <option value="">Select Employee</option>
                            {{-- Rest will be set by JS --}}
                        </select>
                        <label class="form-label mt-2" for="status">{{ trans('common/common.status') }}</label>
                        <select class="form-control select2" name="status" id="status">
                            <option value="">{{ trans('common/common.all') }}</option>
                            <option value="active" @if (request()->input('status') == 'active') selected @endif>
                                {{ trans('common/common.active') }}</option>
                            <option value="inactive" @if (request()->input('status') == 'inactive') selected @endif>
                                {{ trans('common/common.inactive') }}</option>
                            <option value="blacklist" @if (request()->input('status') == 'blacklist') selected @endif>
                                {{ trans('common/common.blacklist') }}</option>
                        </select>
                        <button type="submit"
                            class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center"
                            data-bs-dismiss="offcanvas" aria-label="Close"><i data-feather='search' class="me-2"></i>
                            {{ trans('common/common.search') }}</button>
                    </div>
                </div>
        </form>
        <!-- // Filters // -->

        <div class="row" id="table-responsive">
            <div class="col-12">
                <div class="card">
                    <div class="card-header border-bottom">
                        <div class="head-label">
                            <ul class="demo-inline-spacing mt-0 mb-0" style="margin-left:-2em">
                                <li class="badge badge-glow bg-light-warning"><strong>Leave</strong> - L</li>
                                <li class="badge badge-glow bg-light-primary"><strong>Holiday</strong> - H</li>
                                <li class="badge badge-glow bg-light-secondary"><strong>Week-Off</strong> - WO</li>
                                <li class="badge badge-glow bg-light-sky text-light-sky">
                                    <strong>{{ ucfirst(App\Helpers\ConstantHelper::MODIFIED) }}</strong>
                                </li>
                                <li class="badge badge-glow bg-light-green text-light-green">
                                    <strong>{{ ucfirst(App\Helpers\ConstantHelper::REGULARIZED) }}</strong>
                                </li>
                            </ul>
                        </div>
                        <div class="dt-action-buttons text-end">
                            <div class="dropdown">
                                <a class="btn btn-primary dropdown-toggle" href="#" role="button"
                                    id="dropdownMenuLink" data-bs-toggle="dropdown" aria-expanded="false">
                                    Export
                                </a>
                                <ul class="dropdown-menu" aria-labelledby="dropdownMenuLink">
                                    <li>
                                        <a target="_blank"
                                            href="/{!! $alias !!}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'pdf'])) }}"
                                            class="dropdown-item" id="exportToPdf">
                                            <span>PDF</span>
                                        </a>
                                    </li>
                                    <li>
                                        <a target="_blank"
                                            href="/{!! $alias !!}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'excel'])) }}"
                                            class="dropdown-item">
                                            <span>Excel</span>
                                        </a>
                                    </li>
                                    <li>
                                        <a target="_blank"
                                            href="/{!! $alias !!}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'csv'])) }}"
                                            class="dropdown-item">
                                            <span>CSV</span>
                                        </a>
                                    </li>
                                </ul>
                            </div>
                        </div>
                    </div>
                    <div class="card-body">
                    </div>
                    <div class="table-responsive persumleftfixed">
                        <table class="table mb-0">
                            <tbody>
                                @foreach ($attendanceSummary as $value)
                                    @php

                                        $tolalDays = count($dateArr);

                                        $value->load([
                                            'vwAttendanceSummary' => function ($q) use ($month_id, $year_id) {
                                                $q->where('month', '=', $month_id)->where('year', '=', $year_id);
                                            },
                                        ]);

                                    @endphp


                                    <tr
                                        style="background-color:rgb(4, 23, 49); color:white; border-top: 5px solid transparent;">
                                        <td class="text-nowrap" colspan="{{ count($dateArr) / 2 }}">
                                            <div style="background-color:rgb(4, 23, 49);" class="d-inline-block">
                                                <strong>{{ trans('master/master.name') }}:</strong>:
                                                {{ $value->name }}
                                                <span class="employeecodereport">
                                                    ({{ $value->employee_code }})
                                                </span> &emsp;
                                                @if ($value->aadhar_number && isset($customFields) && in_array('aadhar_number', $customFields))
                                                    <span class="employeecodereport">
                                                        ( Aadhar : {{ $value->aadhar_number }})
                                                    </span> &emsp;
                                                @endif

                                                @if ($value->date_of_joining && isset($customFields) && in_array('date_of_joining', $customFields))
                                                    <span class="employeecodereport">
                                                        (DOJ :{{ $value->date_of_joining }})
                                                    </span> &emsp;
                                                @endif

                                                <strong>{{ trans('master/master.employee_type') }}:</strong>
                                                {{ ucwords($value->employee_type) }}
                                            </div>
                                        </td>

                                        <td class="text-nowrap" colspan="{{ count($dateArr) / 2 + 2 }}"
                                            class="text-right">
                                            
                                            @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" style="background: white"></td>
                                        @foreach ($dateArr as $dates)
                                            <td class="text-nowrap">{{ date('d', strtotime($dates)) }}</td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        @php
                                            // $atSummary = $value->getAttendanceSummaryList($month_id, $year_id);
                                            $atSummary = $value->getAttendanceSummaryFilter($fromDate, $toDate);
                                        @endphp
                                        <td class="text-nowrap" style="background: white">
                                            <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 = 'bg-light-green';
                                                } elseif (
                                                    @$attendance->entry_mode == App\Helpers\ConstantHelper::MODIFIED
                                                ) {
                                                    $boxColor = 'bg-light-sky';
                                                } else {
                                                    $boxColor = '';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $boxColor }}">
                                                {{ $attendance->in_time ? date('H:i', strtotime($attendance->in_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <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 = 'bg-light-green';
                                                } elseif (
                                                    @$attendance->entry_mode == App\Helpers\ConstantHelper::MODIFIED
                                                ) {
                                                    $boxColor = 'bg-light-sky';
                                                } else {
                                                    $boxColor = '';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $boxColor }}">
                                                {{ $attendance->out_time ? date('H:i', strtotime($attendance->out_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <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' ? \App\Helpers\GeneralHelper::formatToHi($attendance->working_time) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <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="background: white">
                                            <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" style="background: white">
                                                <strong>{{ trans('master/master.incentive_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->incentive_hours && $attendance->incentive_hours != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->incentive_hours) : '-' }}
                                                </td>
                                            @endforeach
                                        </tr>
                                    @endif
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <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;
                                                $autoWeekClass =
                                                    $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF
                                                        ? 'autoweekoff'
                                                        : '';

                                                $bgColor = '';
                                                if (
                                                    $attendance->attendance_type == 'leave' ||
                                                    $attendance->on_duty == 4
                                                ) {
                                                    $bgColor = 'bg-light-warning';
                                                }

                                                if (
                                                    $attendance->attendance_type == 'holiday' ||
                                                    $attendance->on_duty == 3
                                                ) {
                                                    $bgColor = 'bg-light-primary';
                                                }

                                                if (
                                                    $attendance->attendance_type == 'week-off' ||
                                                    $attendance->on_duty == 2
                                                ) {
                                                    $bgColor = 'bg-light-secondary';
                                                }

                                            @endphp
                                            <td class="text-nowrap {{ $bgColor }} {{ $autoWeekClass }}">
                                                {{ $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="background: white">
                                            <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;
                                                $autoWeekClass =
                                                    $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF
                                                        ? 'autoweekoff'
                                                        : '';

                                                $bgColor = '';
                                                if (
                                                    $attendance->attendance_type == 'leave' ||
                                                    $attendance->on_duty == 4
                                                ) {
                                                    $bgColor = 'bg-light-warning';
                                                }

                                                if (
                                                    $attendance->attendance_type == 'holiday' ||
                                                    $attendance->on_duty == 3
                                                ) {
                                                    $bgColor = 'bg-light-primary';
                                                }

                                                if (
                                                    $attendance->attendance_type == 'week-off' ||
                                                    $attendance->on_duty == 2
                                                ) {
                                                    $bgColor = 'bg-light-secondary';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $bgColor }} {{ $autoWeekClass }}">
                                                {{ $attendance->status }} {{ $attendance->is_wfh ? '(WFH)' : '' }}</td>
                                        @endforeach
                                    </tr>
                                @endforeach


                            </tbody>

                        </table>
                        <br>
                        {{ $attendanceSummary->appends($nextQuery)->links('pagination::bootstrap-4') }}

                    </div>
                </div>
            </div>
        </div>

    </section>
    <!--/ Column Search -->
@endsection
@push('footer-script')
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/vendors/js/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>

    <script src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/js/scripts/forms/form-wizard.js"></script>

    {{-- date range picker --}}
    <script type="text/javascript" src="/assets/js/moment.min.js"></script>
    <script type="text/javascript" src="/assets/js/daterangepicker.js"></script>
    <link rel="stylesheet" type="text/css" href="/assets/css/daterangepicker.css" />

    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>
    <script src="/js/common-script.js"></script>

    <script>
        var subLocations = $('#sublocation_selected_id').val();
        $(document).ready(function() {

            $('#location_id').show();
            $('#location_id').select2();
            $('#sub_location_id').show();
            $('#sub_location_id').select2();
            $('#department_id').show();
            $('#department_id').select2();
            $('#sub_department_id').show();
            $('#sub_department_id').select2();
            $('#designation_id').show();
            $('#designation_id').select2();
            $('#employee_id').show();
            $('#employee_id').select2();
            $('#manager_id').show();
            $('#manager_id').select2();
            $('#contractor_id').show();
            $('#contractor_id').select2();
            $('#work_station_id').show();
            $('#work_station_id').select2();
            $('#category_id').show();
            $('#category_id').select2();
            $('#company_code_id').show();
            $('#company_code_id').select2();

            if ($('#location_id').val()) {
                getsubLocations();
            }
            $("#searchbox").hide();
            $(".filterbutton").click(function() {
                $("#searchbox").slideToggle('slow');
            });
            $('#request11').DataTable({
                "scrollX": "100%",
                "scrollCollapse": true,
                "ordering": false,
                "order": [
                    [0, "desc"]
                ],
                dom: 'Bfrtip',
                buttons: [

                ]
            });
        });

        function getsubLocations(th) {
            var subLocationId = "";
            var locationId = $('#location_id').val();
            var data = {
                location_id: locationId,
                '_token': '{{ csrf_token() }}'
            }
            $.ajax({
                url: '/{!! $alias !!}/location/sub-locations',
                type: 'POST',
                data: data,
                success: function(data) {
                    var selectbox = '';
                    if (data) {
                        selectbox = '<label for="sub_location_id">Sub Location</label>';
                        selectbox +=
                            '<div class="form-label-group"><select name="sub_location_id[]" class="form-control select2" id="sub_location_id" multiple>';
                        $.each(data, function(i, item) {
                            if (subLocations.includes(i)) {
                                selectbox += '<option value="' + i + '" selected="selected">' + item +
                                    '</option>';
                            } else {
                                selectbox += '<option value="' + i + '">' + item + '</option>';
                            }
                        });
                        selectbox += '</select></div>';
                    }
                    $('#sub_location_id').html(selectbox);
                    $("#sub_location_id").select2({
                        multiple: true
                    });
                }
            });

        }
    </script>
    <script>
        var subLocations = $('#sublocation_selected_id').val();

        var employeeIds = JSON.parse('{!! json_encode($employeeIds) !!}');

        function daysInMonth(month, year) {
            return new Date(year, month, 0).getDate();
        }

        function callDt() {
            var dt_filter_table = $('.dt-column-search');

            if ($('body').attr('data-framework') === 'laravel') {
                assetPath = $('body').attr('data-asset-path');
            }

            if (dt_filter_table.length) {

                var dt_filter = dt_filter_table.DataTable({
                    orderCellsTop: true,
                    "bPaginate": false,
                    "ordering": false,
                    "searching": false,
                    "bInfo": false,
                });
            }
        };

        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });

        $(document).ready(function() {
            $('.select2').select2();
            $('#year_id').trigger('change');
        });

        $('#month_id, #year_id').change(function() {
            var month = $('#month_id').val();
            var year = $('#year_id').val();
            month = String(month).padStart(2, '0');
            var totalDaysInMonth = daysInMonth(month, year);

            var fromDate = month + '/' + '01' + '/' + year;
            var toDate = month + '/' + totalDaysInMonth + '/' + year;

            $('input[name="date_range"]').daterangepicker({
                minDate: fromDate,
                maxDate: toDate,
                startDate: fromDate,
                endDate: toDate,
            });
        });

        $(document).ready(function() {
            var selectedEmployeeIds = JSON.parse('{!! json_encode($employeeIds) !!}');
            var selectedManagerIds = JSON.parse('{!! json_encode($managerIds) !!}');

            function initializeSelect2(selector, preSelectedIds, url, flag) {
                $(selector).select2({
                    multiple: true,
                    ajax: {
                        url: url,
                        dataType: 'json',
                        data: function(params) {
                            return {
                                alias: '{{ $organization->alias }}',
                                exclude_user_id: '',
                                has_contractor_employees: true,
                                employee_type: $('#employee_type').val(),
                                search: params.term,
                                is_manager: flag,
                                only_current_organization: true
                            };
                        },
                        processResults: function(data) {
                            return {
                                results: $.map(data.data, function(item) {
                                    return {
                                        id: item.id,
                                        text: item.name + ' (' + (item.employee_code || '') +
                                            ')' +
                                            ' (' + item.email + ')',
                                    };
                                })
                            };
                        },
                        cache: true
                    },
                    placeholder: 'Search with name',
                    minimumInputLength: 1,
                    allowClear: true
                });

                function loadPreSelectedOptions() {
                    if (preSelectedIds.length > 0) {
                        $.ajax({
                            url: url,
                            data: {
                                alias: '{{ $organization->alias }}',
                                employee_ids: preSelectedIds
                            },
                            success: function(data) {
                                data.data.forEach(function(item) {
                                    var option = new Option(
                                        item.name + ' (' + (item.employee_code || '') +
                                        ')' +
                                        ' (' + item.email + ')', item.id, true, true
                                    );
                                    $(selector).append(option).trigger('change');
                                });
                            }
                        });
                    }
                }

                loadPreSelectedOptions();
            }

            // Initialize Select2 for employee_id and manager_id
            initializeSelect2('#employee_id', selectedEmployeeIds, '/ajax/hod-list', 0);
            initializeSelect2('#manager_id', selectedManagerIds, '/ajax/hod-list', 1);
        });
    </script>
@endpush