@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/plugins/forms/form-wizard.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-->
@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.day_summary_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.day_summary_report') }} -
                        @if ($time)
                            {{ trans('master/master.time') }}
                        @else
                            {{ trans('master/master.status') }}
                        @endif {{ trans('master/master.wise') }}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    @if ($time)
        {{ Form::open(['url' => $alias . '/attendance-report/day-summary?time=1', 'method' => 'GET']) }}
    @else
        <form action="{!! route('attendance-daily-summary', ['alias' => $alias]) !!}" method="GET">
    @endif
    <section id="column-search-datatable">
        <input type="hidden" name="time" value="{{ $time }}">

        <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" for="area_id">{{ trans('common/common.month') }}</label>
                    <select class="form-control select2" 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" for="area_id">{{ trans('common/common.year') }}</label>
                    <select class="form-control mb-2 select2" 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 mb-2 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.department') }}</label>
                    <select class="form-control mb-2 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.designation') }}</label>
                    <select class="form-control mb-2 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.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 mb-2 select2" name="contractor_id[]" id="contractor_id" multiple>
                            <option value="">Select contractor</option>
                            @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"
                            onchange="getEmployeeByType(this.value)">
                            <option value="">Select {{ trans('master/master.type') }}</option>
                            @foreach ($employeeTypes as $empType)
                                <option value="{{ $empType }}" @if ($empType == $employee_type_selected) selected @endif>
                                    {{ ucwords($empType) }}
                                </option>
                            @endforeach
                        </select>
                    @else
                        <select class="form-control mb-2 select2" name="employee_type" id="employee_type"
                            onchange="getEmployeeByType(this.value)">
                            <option value="">Select {{ trans('master/master.type') }}</option>
                            <option value="{{ $employeeType }}" @if ($employeeType == $employee_type_selected) selected @endif>
                                {{ ucwords($employeeType) }}
                            </option>
                        </select>
                    @endif

                    <label class="form-label mt-2" for="area_id">{{ trans('master/master.employees') }}</label>
                    <select class="form-control mb-2 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>
            <div class="row">
                <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-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>
                                    <li class="badge badge-glow bg-light-success text-light-success">
                                        <strong>Present</strong></li>
                                    <li class="badge badge-glow bg-light-danger ">
                                        <strong>Absent</strong></li>
                                    <li class="badge badge-glow bg-light-orange ">
                                        <strong>Half-day</strong></li>
                                    <li class="badge badge-glow bg-light-yellow">
                                        <strong>Week-off</strong></li>
                                    <li class="badge badge-glow bg-light-grey ">
                                        <strong>Holiday</strong></li>
                                    <li class="badge badge-glow bg-light-blue">
                                        <strong>Leave</strong></li>

                                </ul>
                            </div>
                            
                            <div class="dt-action-buttons text-end">
                                {{-- @if ($time)
                                    <a class="dt-button buttons-excel" target="_blank"
                                        href="/{!! $alias !!}/attendance-report/day-wise-ot-export?time={{ $time ?: '' }}&month_id={{ $month_id }}&year_id={{ $year_id }}&date_range={{ $dateRange }}&contractor_id={{ $contractorIds ? implode(',', $contractorIds) : '' }}&employee_type={{ $employee_type_selected }}&employee_id={{ $employeeIds ? implode(',', $employeeIds) : '' }}&location_id={{ $locationIds ? implode(',', $locationIds) : '' }}&designation_id={{ $designationIds ? implode(',', $designationIds) : '' }}&category_id={{ $categoryIds ? implode(',', $categoryIds) : '' }}&work_station_id={{ $workstationIds ? implode(',', $workstationIds) : '' }}&company_code_id={{ $companyCodeIds ? implode(',', $companyCodeIds) : '' }}&department_id={{ $departmentIds ? implode(',', $departmentIds) : '' }}&status={{ $status }}"
                                        style="display: initial;"><button type="button"
                                            class="btn btn-primary waves-effect waves-float waves-light">
                                            <span> Daily OT Export</span>
                                        </button>
                                    </a>
                                @endif --}}
                                @if ($time)
                                    <div class="btn-group me-1">
                                        <button type="button" class="btn btn-primary dropdown-toggle" data-bs-toggle="dropdown">
                                            Daily OT Export
                                        </button>

                                        <ul class="dropdown-menu">
                                            <li>
                                                <a class="dropdown-item" target="_blank"
                                                    href="/{{ $alias }}/attendance-report/day-wise-ot-export?time={{ $time ?: '' }}&month_id={{ $month_id }}&year_id={{ $year_id }}&date_range={{ $dateRange }}&contractor_id={{ $contractorIds ? implode(',', $contractorIds) : '' }}&employee_type={{ $employee_type_selected }}&employee_id={{ $employeeIds ? implode(',', $employeeIds) : '' }}&location_id={{ $locationIds ? implode(',', $locationIds) : '' }}&designation_id={{ $designationIds ? implode(',', $designationIds) : '' }}&category_id={{ $categoryIds ? implode(',', $categoryIds) : '' }}&work_station_id={{ $workstationIds ? implode(',', $workstationIds) : '' }}&company_code_id={{ $companyCodeIds ? implode(',', $companyCodeIds) : '' }}&department_id={{ $departmentIds ? implode(',', $departmentIds) : '' }}&status={{ $status }}">
                                                    Excel
                                                </a>
                                            </li>
                                            <li>
                                                <a class="dropdown-item" target="_blank"
                                                    href="/{{ $alias }}/attendance-report/day-wise-pdf-export?time={{ $time ?: '' }}&month_id={{ $month_id }}&year_id={{ $year_id }}&date_range={{ $dateRange }}&contractor_id={{ $contractorIds ? implode(',', $contractorIds) : '' }}&employee_type={{ $employee_type_selected }}&employee_id={{ $employeeIds ? implode(',', $employeeIds) : '' }}&location_id={{ $locationIds ? implode(',', $locationIds) : '' }}&designation_id={{ $designationIds ? implode(',', $designationIds) : '' }}&category_id={{ $categoryIds ? implode(',', $categoryIds) : '' }}&work_station_id={{ $workstationIds ? implode(',', $workstationIds) : '' }}&company_code_id={{ $companyCodeIds ? implode(',', $companyCodeIds) : '' }}&department_id={{ $departmentIds ? implode(',', $departmentIds) : '' }}&status={{ $status }}">
                                                    PDF
                                                </a>
                                            </li>
                                        </ul>
                                    </div>
                                @endif
                                <div class="btn-group">
                                    <button type="button" class="btn btn-primary dropdown-toggle" data-bs-toggle="dropdown">
                                        Export
                                    </button>

                                    <ul class="dropdown-menu">
                                        <li>
                                            <a class="dropdown-item" target="_blank"
                                                href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}">
                                                Excel
                                            </a>
                                        </li>
                                        <li>
                                            <a class="dropdown-item" target="_blank"
                                                href="{{ request()->fullUrlWithQuery(['export' => 'pdf']) }}">
                                                PDF
                                            </a>
                                        </li>
                                    </ul>
                                </div>
                            </div>

                        </div>
                        <div class="card-datatable">
                            <table class="dt-column-search table table-responsive daysumleftfixed tablenewheadfixed"
                                id="organization">
                                <thead>
                                    <th>S.No</th>
                                    <th class="text-nowrap">Emp. Name & Code</th>
                                    <th>{{ trans('master/master.department') }}</th>
                                    <th>{{ trans('master/master.sub_department') }}</th>
                                    @if (!$time)
                                    <th>{{ trans('Manager') }}</th>
                                    @endif
                                    @foreach ($dateArr as $dates)
                                        <th>{{ date('j', strtotime($dates)) }}({{ ucfirst(strtolower(date('D', strtotime($dates)))) }})</th>
                                        <th></th>
                                    @endforeach
                                    <th class="text-nowrap">{{ trans('master/master.total_paid_days') }}</th>
                                    <th class="text-nowrap">{{ trans('master/master.total_duty') }}</th>
                                    <th class="text-nowrap">
                                        Total Week Off
                                    </th>
                                    <th class="text-nowrap">
                                        Total Holiday
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('master/master.total_actual_ot') }}({{ trans('master/master.hours') }})
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('master/master.total_ot') }}({{ trans('master/master.hours') }})
                                    </th>
                                    @if (!$time)
                                        <th>{{ trans('employee/employee.aadhar_number') }}</th>
                                        <th class="text-nowrap">{{ trans('Esic Number') }}</th>
                                        <th class="text-nowrap">{{ trans('UAN Number') }}</th>
                                        <th class="text-nowrap">{{ trans('Present') }}</th>
                                        <th class="text-nowrap">{{ trans('Absent') }}</th>
                                        <th class="text-nowrap">{{ trans('Leave') }}</th>
                                        <th class="text-nowrap">{{ trans('Unpaid Leave') }}</th>
                                        <th class="text-nowrap">{{ trans('Holidays') }}</th>
                                        <th class="text-nowrap">{{ trans('Week Offs') }}</th>
                                        <th class="text-nowrap">{{ trans('Fine Days') }}</th>
                                        <th class="text-nowrap">
                                            {{ trans('Total Overtime') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('single OT') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('double Ot') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('Incentive Hours') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('Working Hour(Sunday)') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('Working Hours(Nights)') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('Payable Hours') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('Productive Hours') }}
                                        </th>
                                        <th class="text-nowrap">
                                            {{ trans('Industrial Hours') }}
                                        </th>
                                    @php
                                        $maxLeaveCount = 0;
                                        foreach ($employeeSummary as $value) {
                                            $count = count($value->Leave_types ?? []);
                                            if ($count > $maxLeaveCount) {
                                                $maxLeaveCount = $count;
                                            }
                                        }
                                    @endphp
                                    <th colspan="{{ $maxLeaveCount }}" style="text-align: center; font-weight: bold">
                                        Leaves types
                                    </th>
                                    @endif
                                </thead>
                                <tbody>
                                    @foreach ($employeeSummary as $key => $value)
                                        @php
                                            $totalPaidDays = $totalPresent = $overtime = $actualOvertime = $totalActualOvertime = $totalovertime = 0;
                                            $attendanceSummaryProcess = new  App\Lib\Services\AttendanceSummaryProcess();

                                            $woHoCounts = $attendanceSummaryProcess->getAttSmryWOHOCount(
                                                $organization->id,
                                                $value->id,
                                                $fromDate,
                                                $toDate
                                            );
                                        @endphp
                                        <tr>
                                            <td>
                                                @if (isset($_GET['page']) && $_GET['page'] > 0)
                                                    {{ ($_GET['page'] - 1) * 10 + $loop->iteration }}
                                                @else
                                                    {{ $loop->iteration }}
                                                @endif
                                            </td>
                                            <td class="text-nowrap"><strong>{{ $value->name }}</strong> <br /><span
                                                    class="employeecodereport">({{ $value->employee_code }})</span></td>
                                            <td class="text-nowrap">{{ @$value->department->name }}</td>
                                            <td class="text-nowrap">{{ @$value->SubDepartment->name }}</td>
                                            @if (!$time)
                                            <td class="text-nowrap">{{ @$value->hod->name }}</td>
                                            @endif

                                            @foreach ($dateArr as $date)
                                                @php
                                                    $attendance = $value->attendanceSummary->where('attendance_date', $date)->first();
                                                @endphp

                                                @if (!$attendance)
                                                    <td>
                                                        -
                                                    </td>
                                                    <td>
                                                        -
                                                    </td>

                                                    @continue;

                                                @endif
                                                @php
                                                    $overtime +=intval(substr($attendance->overtime, 0, -6)) * 60 + intval(substr($attendance->overtime, -5, -3));
                                                    $totalovertime = round($overtime / 60, 2);
                                                    $actualOvertime += intval(substr($attendance->actual_overtime, 0, -6)) * 60 + intval(substr($attendance->actual_overtime, -5, -3));
                                                    $totalActualOvertime = round($actualOvertime / 60, 2);
                                                    $autoWeekClass = $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF ? 'autoweekoff' : '';
                                                    $attendanceColors = [
                                                        'present'  => 'bg-light-success',
                                                        'absent'   => 'bg-light-danger',
                                                        'week-off' => 'bg-light-yellow',
                                                        'holiday'  => 'bg-light-grey',
                                                        'leave'    => 'bg-light-blue',
                                                    ];
                                                    $boxColor = $attendanceColors[$attendance->attendance_type] ?? '';
                                                   if (round($attendance->day_count, 2) == 0.50 && $attendance->attendance_type=='present') {
                                                        $boxColor = 'bg-light-orange';
                                                    }
                                                    $entryModeColors = [
                                                        App\Helpers\ConstantHelper::REGULARIZED => 'bg-light-green',
                                                        App\Helpers\ConstantHelper::MODIFIED    => 'bg-light-sky',
                                                    ];
                                                    $boxColor = $entryModeColors[$attendance->entry_mode] ?? $boxColor;

                                                    $totalPaidDays += $attendance->day_count ?: 0;
                                                    if (
                                                        $attendance->attendance_type == 'present' &&
                                                        $attendance->on_duty == 1
                                                    ) {
                                                        $totalPresent = $totalPresent + $attendance->day_count;
                                                    }
                                                @endphp

                                                <td class="text-nowrap date-group-left {{ $autoWeekClass }} {{ $boxColor }}">
                                                    {{ $time && !empty($attendance->in_time)
                                                        ? date('H:i', strtotime($attendance->in_time))
                                                        : $attendance->first_half_status }}

                                                    @if ($attendance->first_half_status == 'L')
                                                        ({{ strtoupper($attendance->leave_type) }})
                                                    @endif
                                                </td>
                                                <td class="text-nowrap date-group-right {{ $autoWeekClass }} {{ $boxColor }}">
                                                    {{ $time && !empty($attendance->out_time)
                                                        ? date('H:i', strtotime($attendance->out_time))
                                                        : $attendance->second_half_status }}

                                                    @if ($attendance->second_half_status == 'L')
                                                        ({{ strtoupper($attendance->leave_type) }})
                                                    @endif
                                                </td>
                                            @endforeach

                                            <td>{{ $totalPaidDays }}</td>
                                            <td>{{ $totalPresent }}</td>
                                            <td>{{ $woHoCounts['total_week_off'] }}</td>
                                            <td>{{ $woHoCounts['total_holiday'] }}</td>
                                            <td>{{ $totalActualOvertime }}</td>
                                            <td>{{ $totalovertime }}</td>
                                            @if (!$time)
                                            <td class="text-nowrap">
                                            {{ preg_replace('/(\d{4})(\d{4})(\d{4})/', '$1 $2 $3', $value->aadhar_number) }}
                                            </td>
                                            <td class="text-nowrap">
                                                {{ preg_replace('/(\d{4})(\d{4})(\d{4})/', '$1 $2 $3', $value->esic_no) }}
                                            </td>
                                            <td class="text-nowrap">
                                                {{ preg_replace('/(\d{4})(\d{4})(\d{4})/', '$1 $2 $3', $value->uan_number) }}
                                            </td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['present'] }}</td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['absent'] }}</td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['leaves'] }}</td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['unpaidLeaves'] }}</td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['holidays'] }}</td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['weekOffs'] }}</td>
                                            <td class="text-nowrap">{{ @$value->payroll_data['fineDays'] }}</td>
                                            <td class="text-nowrap">{{ @$value->additional_data['overtime_hours'] }}</td>
                                            <td class="text-nowrap">{{ @$value->additional_data['single_ot'] }}</td>
                                            <td class="text-nowrap">{{ @$value->additional_data['double_ot'] }}</td>
                                            <td class="text-nowrap">{{ @$value->additional_data['incentive_hours'] }}</td>
                                            <td class="text-nowrap">{{ @$value->additional_data['sunday_working_hours'] }}</td>
                                            <td class="text-nowrap">{{ @$value->additional_data['night_working_hours'] }}</td>
                                        @php
                                            $totalPayableSeconds = 0;

                                            foreach ($value->attendanceSummary as $attendance) {
                                                $timeParts = explode(':', $attendance->payable_hours);
                                                if (count($timeParts) === 3) {
                                                    $hours = (int) $timeParts[0];
                                                    $minutes = (int) $timeParts[1];
                                                    $seconds = (int) $timeParts[2];

                                                    $totalPayableSeconds += ($hours * 3600) + ($minutes * 60) + $seconds;
                                                }
                                            }

                                            $decimalPayableHours = $totalPayableSeconds / 3600;
                                        @endphp

                                        <td>{{ number_format($decimalPayableHours, 2) }}</td>


                                        @php
                                            $totalProductiveSeconds = 0;

                                            foreach ($value->attendanceSummary as $attendance) {
                                                $timeParts = explode(':', $attendance->productive_hours);
                                                if (count($timeParts) === 3) {
                                                    $hours = (int) $timeParts[0];
                                                    $minutes = (int) $timeParts[1];
                                                    $seconds = (int) $timeParts[2];

                                                    $totalProductiveSeconds += ($hours * 3600) + ($minutes * 60) + $seconds;
                                                }
                                            }

                                            $decimalProductiveHours = $totalProductiveSeconds / 3600;
                                        @endphp

                                        <td>{{ number_format($decimalProductiveHours, 2) }}</td>
                                        <td>{{ @$value->industrial_hours }}</td>


                                            @foreach ($value->Leave_types as $leave)
                                                <td class="text-nowrap">
                                                    @if (!empty($leave['taken_leaves']) || !empty($leave['balance_leaves']))
                                                        <b>{{ strtoupper($leave['leaveType']) }}</b>: {{ $leave['taken_leaves'] ?? '-' }}
                                                        <b>Taken</b> / {{ $leave['balance_leaves'] ?? '-' }} <b>Balance</b>
                                                    @else
                                                        -
                                                    @endif
                                                </td>
                                            @endforeach
                                            @endif

                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            <br>
                            {{ $employeeSummary->appends($nextQuery)->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                </div>
            </div>
    </section>
    </form>
    <!--/ Column Search -->
@endsection
@push('footer-script')
    <!-- BEGIN: Page Vendor JS-->
    <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>
        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() {
            callDt();
            getEmployeeByType("{{ $employee_type_selected }}");
        });

        $(document).ready(function() {
            $('.select2').select2();

            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;

            var minDate = moment(fromDate, "MM/DD/YYYY").subtract(1, 'month');
            var maxDate = moment(toDate, "MM/DD/YYYY");

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

        $('#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;

            var minDate = moment(fromDate, "MM/DD/YYYY").subtract(1, 'month');
            var maxDate = moment(toDate, "MM/DD/YYYY");

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

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

        function getEmployeeByType(employee_type) {
            var url = "{!! route('employees-by-type', ['alias' => $alias]) !!}?employee_type=" + employee_type;
            $.ajax({
                url: url,
                type: "GET",
                success: function(data) {
                    op = '';
                    for (var i = 0; i < data.length; i++) {
                        op += '<option value="' + data[i].id + '">' + data[i].name + '(' + data[i]
                            .employee_code + ')</option>';
                    }
                    $('#employee_id').html(op);
                }
            });

        }

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

            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);
        });
    </script>
@endpush