@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">Factual 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">Factual Report
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <form id="filterForm" class="loder-disabled" action="/{!! $alias !!}/factual-report"
        method="POST">
        {{ csrf_field() }}
        <section id="column-search-datatable">
            <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 (in_array($location->id, request()->input('location_id', []))) 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 (in_array($department->id, request()->input('department_id', []))) 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 (in_array($designation->id, request()->input('designation_id', []))) 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 (in_array($workstation->id, request()->input('work_station_id', []))) selected @endif>
                                    {{ $workstation->name }}
                                </option>
                            @endforeach
                        </select>
                          <label class="form-label mt-2" for="area_id">{{ trans('master/master.shift') }}</label>
                        <select class="form-control mb-2 select2" name="shift_id[]" id="shift_id" multiple>
                            @foreach ($shifts as $shift)
                                <option value="{{ $shift->id }}" @if (in_array($shift->id, request()->input('shift_id', []))) selected @endif>
                                    {{ $shift->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 (in_array($category->id, request()->input('category_id', []))) 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 (in_array($companyCode->id, request()->input('company_code_id', []))) 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 (in_array($contractor->id, request()->input('contractor_id', []))) 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 == request()->input('employee_type')) 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>Select {{ trans('master/master.type') }}</option>
                                <option value="{{ $employeeType }}" @if ($employeeType == request()->input('employee_type')) 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" name="employee_id[]" id="employee_id" multiple>
                            <option value="">Select {{ trans('master/master.type') }}</option>
                        </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>
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header border-bottom">
                            <div class="head-label">
                                {{-- @if (!$factualReport)
                                    <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>
                                    </ul>
                                @endif --}}
                            </div>
                            <div class="dt-action-buttons text-end">
                                <button type="button" id="export-to-excel"
                                    data-url="/{!! $alias !!}/factual-report/export"
                                    class="btn btn-primary waves-effect waves-float waves-light">
                                    <span> Export to Excel</span>
                                </button>
                                <button type="button" 
                                    onclick="window.location.href='/{!! $alias !!}/factual-report'"
                                    class="btn btn-secondary waves-effect waves-float waves-light">
                                    <span>Reset</span>
                                </button>
                            </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.category') }}</th>
                                    <th>{{ trans('master/master.designation') }}</th>
                                    <th>{{ trans('master/master.shift') }}</th>
                                    @foreach ($dateArr as $dates)
                                        <th>{{ date('d', strtotime($dates)) }}</th>
                                        <th></th>
                                    @endforeach
                                </thead>
                                <tbody>

                                    @foreach ($employeeSummary as $key => $value)
                                    @php
                                       $atSummary = $value->processedAttendance ?? [];
                                    @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->category->name }}</td>
                                        <td class="text-nowrap">{{ @$value->designation->name }}</td>
                                        <td class="text-nowrap">
                                            @if ($value->display_shift_name)
                                                {{ $value->display_shift_name }}
                                                @if ($value->display_shift_start && $value->display_shift_end)
                                                    <br />
                                                    <span class="employeecodereport">({{ date('H:i', strtotime($value->display_shift_start)) }} - {{ date('H:i', strtotime($value->display_shift_end)) }})</span>
                                                @endif
                                            @else
                                                {{ @$value->shift->name ?? '-' }}
                                            @endif
                                        </td>

                                        @foreach ($dateArr as $date)

                                            @php
                                                $attendance = $atSummary[$date] ?? null;

                                                $autoWeekClass = ($attendance && $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF)
                                                    ? 'autoweekoff'
                                                    : '';

                                                if ($attendance && $attendance->entry_mode == App\Helpers\ConstantHelper::REGULARIZED) {
                                                    $boxColor = 'bg-light-green';
                                                } elseif ($attendance && $attendance->entry_mode == App\Helpers\ConstantHelper::MODIFIED) {
                                                    $boxColor = 'bg-light-sky';
                                                } else {
                                                    $boxColor = '';
                                                }
                                            @endphp

                                            {{-- IN TIME --}}
                                            <td class="text-nowrap {{ $autoWeekClass }} {{ $boxColor }}">
                                                @if ($attendance &&
                                                    $attendance->in_time &&
                                                    !(
                                                        $attendance->on_duty == 2 ||
                                                        ($attendance->on_duty == 3 && $attendance->is_week_off == 0)
                                                    )
                                                )
                                                    {{ date('H:i', strtotime($attendance->in_time)) }}
                                                @else
                                                    -
                                                @endif
                                            </td>

                                            {{-- OUT TIME --}}
                                            <td>
                                                @if ($attendance &&
                                                    $attendance->out_time &&
                                                    !(
                                                        $attendance->on_duty == 2 ||
                                                        ($attendance->on_duty == 3 && $attendance->is_week_off == 0)
                                                    )
                                                )
                                                    {{ date('H:i', strtotime($attendance->out_time)) }}
                                                @else
                                                    -
                                                @endif
                                            </td>

                                        @endforeach
                                    </tr>
                                @endforeach

                                </tbody>
                            </table>
                            <br>
                            {{ $employeeSummary->appends(request()->except('page'))->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 selectedEmployeeIds = JSON.parse('{!! json_encode(request()->input('employee_id', [])) !!}');

        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("{{ request()->employee_type }}");
        });

        $(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;
            $('input[name="date_range"]').daterangepicker({
                minDate: fromDate,
                maxDate: toDate
            });
        })

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

        function getEmployeeByType(select) {
            var employeeTypes = [];
            $(select).find(':selected').each(function(key, option) {
                employeeTypes.push($(option).val());
            })
            var url = "{!! route('employees-by-type', ['alias' => $alias]) !!}?employee_type=" + employeeTypes;
            $.ajax({
                url: url,
                type: "GET",
                success: function(data) {
                    var op = '';
                    for (var i = 0; i < data.length; i++) {
                        op += '<option value="' + data[i].id + '"';

                        if (selectedEmployeeIds.includes((data[i].id).toString())) {
                            op += ' selected ';
                        }

                        op += ' >' + data[i].name + '(' + data[i]
                            .employee_code + ')</option>';
                    }
                    $('#employee_id').html(op).select2();
                }
            });
        }

        $('#employee_id, #employee_type').change(function() {
            selectedEmployeeIds = [];
            $('#employee_id').find(':selected').each(function(key, option) {
                selectedEmployeeIds.push($(option).val());
            })
        });

        $('#export-to-excel').click(function() {
            var exportUrl = $(this).data('url');
            var filterUrl = $('#filterForm').attr('action');
            $('#filterForm').attr('action', exportUrl);
            $('#filterForm').attr('target', "_blank");
            $('#filterForm').submit();
            $('#filterForm').attr('action', filterUrl);
            $('#filterForm').removeAttr('target');
        });
    </script>
@endpush