@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">
    <link rel="stylesheet" href="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.css">
    <link rel="stylesheet" href="/assets/css/daterangepicker.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-->
    <style>
        .tablenewheadfixed th:nth-child(3),
        .tablenewheadfixed td:nth-child(3) {
            position: sticky;
            left: 0;
            z-index: 2;
            background: white;
        }
        .tablenewheadfixed th:nth-child(4),
        .tablenewheadfixed td:nth-child(4) {
            position: sticky;
            left: 200px; 
            z-index: 2;
            background: white;
        }
    </style>
@endpush
@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">Muster-Roll Report</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="/{!! $alias !!}/home">Home</a>
                    </li>
                    <li class="breadcrumb-item active">Muster-Roll Report
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush

@section('content')
    <section id="dashboard-ecommerce">
        <form method="post" id="muster-roll-fetch">
            <input type="hidden" name="_token" value="{{ csrf_token() }}">

            <div class="content-header row">
                <div class="content-header-left col-md-9 col-12 mt-2 mb-2">
                    <div class="row breadcrumbs-top">
                        <div class="col-md-3">
                            <label class="form-label" for="area_id">{{ trans('admin/template.month') }}</label>
                            <select class="form-control mb-2 select2" name="month" id="month">
                                @foreach ($months as $key => $val)
                                    <option class="form-control" value="{{ $key }}"
                                        @if ($key == $month) selected @endif>{{ $val }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label" for="year">{{ trans('admin/template.year') }}</label>
                            <select class="form-control mb-2 select2" name="year" id="year">
                                @foreach ($years as $val)
                                    <option class="form-control" value="{{ $val }}"
                                        @if ($val == $year) selected @endif>{{ $val }}</option>
                                @endforeach
                            </select>
                        </div>                   
                        <div class="col-md-6">
                            <button type="submit" class="btn btn-primary mb-1 mt-2 me-1">
                                {{ trans('admin/template.attendance_fetch') }}</button>
                        </div>
                    </div>
                </div>
                <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none mt-2">
                    <div class="mb-1 mt-2 breadcrumb-right">
                        <div class="dropdown">
                            <button type="button" id="exportToExcel" class="btn-icon btn btn-primary btn-round">Export to
                                Excel</button>
                            <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">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">
                        <div class="row">

                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <label class="form-label mt-2"
                                        for="area_id">{{ trans('master/master.contractor') }}</label>
                                    <select class="form-control mb-2 select2" name="contractor_id">
                                        <option value="0">Select contractor</option>
                                        @foreach ($contractors as $contractor)
                                            <option value="{{ $contractor->id }}"
                                                @if ($contractor->id == $request->contractor_id) selected @endif>{{ $contractor->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            
                            <div class="col-sm-12">
                                <div class="form-label-group">
                                    <label class="form-label mt-2"
                                        for="area_id">{{ trans('master/master.location') }}</label>
                                    <select class="form-control mb-2 select2" name="location_id">
                                        <option value="0">Select Location</option>
                                        @foreach ($locations as $location)
                                            <option value="{{ $location->id }}"
                                                @if ($location->id == $request->location_id) selected @endif>{{ $location->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-12">
                                <div class="form-label-group">
                                    <label class="form-label mt-2"
                                        for="area_id">{{ trans('master/master.department') }}</label>
                                    <select class="form-control mb-2 select2" name="department_id">
                                        <option value="0">Select Department</option>
                                        @foreach ($departments as $department)
                                            <option value="{{ $department->id }}"
                                                @if ($department->id == $request->department_id) selected @endif>{{ $department->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <label class="form-label">Employee Type</label>
                                    <select class="form-control select2" id="employee_type" name="employee_type"
                                        onchange="getEmployeeByType(this.value)">
                                        <option value="">Select {{ trans('master/master.type') }}</option>
                                        @foreach ($employeeTypes as $empType)
                                            <option value="{{ $empType }}"
                                                @if ($empType == $request->employee_type) selected @endif>
                                                {{ ucwords($empType) }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <label class="form-label">Employees</label>
                                    <select class="form-control select2" id="employees_id" name="employees_id[]"
                                        multiple>
                                        <option value="">Select Employees</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <label class="form-label" 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>
                                </div>
                            </div>
                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <label class="form-label">Month Day's Status</label>
                                    <select class="form-control" id="status" name="status">
                                        <option value="">Select Value</option>
                                        <option value="complete" @if ($request->status == 'complete') selected @endif>
                                            Completed</option>
                                        <option value="incomplete" @if ($request->status == 'incomplete') selected @endif>
                                            In-Completed</option>
                                    </select>
                                </div>
                            </div>
                            <label class="form-label mt-2" for="employee_status">{{ trans('common/common.status') }}</label>
                            <select class="form-control select2" name="employee_status" id="employee_status">
                                <option value="all" @if (request()->input('employee_status', 'active') == 'all') selected @endif>
                                    {{ trans('common/common.all') }}
                                </option>
                                <option value="active" @if (request()->input('employee_status', 'active') == 'active') selected @endif>
                                    {{ trans('common/common.active') }}
                                </option>
                                <option value="inactive" @if (request()->input('employee_status') == 'inactive') selected @endif>
                                    {{ trans('common/common.inactive') }}
                                </option>
                            </select>
                        </div>
                        <button type="submit"
                            class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center"
                            onclick="filter()" data-bs-dismiss="offcanvas" aria-label="Close"><i data-feather='search'
                                class="me-2"></i> {{ trans('common/common.search') }}
                        </button>
                    </div>
                </div>
            </div>
        </form>
        
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header row">
                        <div class="col-md-12 text-center">
                            @if (!empty($contractorName))
                                <h5 class="text-danger">
                                    Contractor : <strong>{{ $contractorName }}</strong>
                                </h5>
                            @endif
                            @if (!empty($locationName))
                                <h5 class="text-danger">
                                    Location : <strong>{{ $locationName }}</strong>
                                </h5>
                            @endif
                            @if (!empty($employeeType))
                                <h5 class="text-danger">
                                    Employee Type : <strong>{{ $employeeType }}</strong>
                                </h5>
                            @endif
                            @if (!empty($status))
                                <h5 class="text-danger">
                                    Month Day's Status : <strong>{{ $status }}</strong>
                                </h5>
                            @endif
                            @if (!empty($departmentName))
                                <h5 class="text-danger">
                                    DEPARTMENT : <strong>{{ $departmentName }}</strong>
                                </h5>
                            @endif
                            @if (!empty($contractorName))
                               
                                <h4 class="text-danger">
                                    ATTENDANCE REGISTER OF <strong>{{ $contractorName }}</strong> FOR
                                    THE MONTH OF
                                    <strong>
                                        {{ date('F - Y', strtotime('01-' . $month . '-' . $year)) }}
                                    </strong>
                                </h4>
                            @else
                                <h4 class="text-danger">
                                    ATTENDANCE REGISTER OF <strong>{{ $organization->name }}</strong> FOR
                                    THE MONTH OF
                                    <strong>
                                        {{ date('F - Y', strtotime('01-' . $month . '-' . $year)) }}
                                    </strong>
                                </h4>    
                            @endif
                            
                        </div>
                    </div>
                    @if (count($empShifts))
                        <div class="card-header row">
                            @foreach ($empShifts as $shift)
                                <div class="col-md-3">
                                    <strong>{{ $shift->name }}</strong> <br>
                                    <span
                                        style="font-size:10px; margin-bottom:10px">({{ date('h:i A', strtotime($shift->start_time)) }}
                                        - {{ date('h:i A', strtotime($shift->end_time)) }}) | Marked as <div
                                            style="height: 10px; width:10px; border-radius:25%; background-color: {{ $bgColors[$shift->id] }}"
                                            class="d-inline-block"></div>
                                    </span>

                                </div>
                            @endforeach
                        </div>
                    @endif
                    <div class="card-datatable table-responsive position-relative" style="max-height: 700px; overflow-y:scroll;">
                        <table class=" table border table-responsive tablenewheadfixed" id="organization" border="1px black">
                            <thead style="position: sticky; top:0px;">
                                <tr class="text-center">
                                    <th rowspan="2">Yearly Regd No</th>
                                    <th rowspan="2">Serial No</th>
                                    <th rowspan="2">Name & Residensial Address</th>
                                    <th rowspan="2">Employee Code</th>
                                    <th rowspan="2">Father's Name or Husband's Name in case of Married Woman</th>
                                    <th rowspan="2">Certifying Surgeons Certificate No</th>
                                    <th rowspan="2">Designation</th>
                                    <th rowspan="2">Nature of Work</th>
                                    @foreach ($dateList as $date)
                                        <th colspan="2">{{ date('d (D)', strtotime($date)) }}</th>
                                    @endforeach
                                    <th rowspan="2">Days Actually Worked</th>
                                    <th rowspan="2">Weekly Holiday Entitled</th>
                                    <th rowspan="2">Accident or Sick Leave</th>
                                    <th rowspan="2">Leave with Wages</th>
                                    <th rowspan="2">Late</th>
                                    <th rowspan="2">Leave without Pay</th>
                                    <th rowspan="2">Total Days Worked</th>
                                    <th rowspan="2">Total Days Absent</th>
                                    <th rowspan="2">Remarks</th>
                                </tr>
                                <tr>
                                    @foreach ($dateList as $date)
                                        <th>H1</th>
                                        <th>H2</th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($totalEmployees as $key => $employee)
                                    <tr>
                                        <td>-</td>
                                        <td>
                                            @if (isset($_GET['page']) && $_GET['page'] > 0)
                                                {{ ($_GET['page'] - 1) * 50 + $loop->iteration }}
                                            @else
                                                {{ $loop->iteration }}
                                            @endif
                                        </td>
                                        <td>
                                            {{ $employee->name }} <br>
                                            <span style="font-size: 10px">
                                                {{ $employee->geo_address }}
                                            </span>
                                        </td>
                                        <td>{{ $employee->employee_code }}</td>
                                        <td>{{ @$employee->father_name ?: '-' }}</td>
                                        <td>-</td>
                                        <td>{{ @$employee->designation->name ?: '-' }}</td>
                                        <td>-</td>
                                        @php
                                            $payrollProcess = new \App\Lib\Services\PayrollProcess();
                                            $attendanceData = $payrollProcess->getPayrollAttendanceData(
                                                $organization,
                                                $employee,
                                                $month,
                                                $year,
                                            );
                                            $atSummary = $employee->getAttendanceSummaryList($month, $year);

                                            $daysActuallyWorked = 0;
                                            $lateDays = 0;
                                            $weekHolidays = 0;
                                            $totalMonthDays = date('t', strtotime($year . '-' . $month . '-01'));
                                        @endphp

                                        @foreach ($dateList as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    --
                                                </td>
                                                <td>
                                                    --
                                                </td>
                                                @continue;
                                            @endif
                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp

                                            <td style="background-color: {{ @$bgColors[$attendance->shift_id] }}">
                                                @if ($attendance->first_half_status == 'L' || $attendance->on_duty == 4)
                                                    L
                                                @elseif($attendance->first_half_status == 'H' || $attendance->on_duty == 3)
                                                    H
                                                @elseif($attendance->first_half_status == 'WO' || $attendance->on_duty == 2)
                                                    WO
                                                @elseif($attendance->first_half_status == 'P')
                                                    P
                                                @elseif($attendance->first_half_status == 'PO')
                                                    PO
                                                @elseif($attendance->first_half_status == 'A')
                                                    A
                                                @else
                                                    {{@$attendance->first_half_status }}
                                                @endif
                                            </td>
                                            @php
                                            // dd($attendance);
                                            //     if($attendance->shift_id){
                                            //         dd('12');
                                            //     }
                                            @endphp
                                            <td style="background-color: {{ @$bgColors[$attendance->shift_id] }}">
                                                @if ($attendance->second_half_status == 'L' || $attendance->on_duty == 4)
                                                    L
                                                @elseif($attendance->second_half_status == 'H' || $attendance->on_duty == 3)
                                                    H
                                                @elseif($attendance->second_half_status == 'WO' || $attendance->on_duty == 2)
                                                    WO
                                                @elseif($attendance->second_half_status == 'P')
                                                    P
                                                @elseif($attendance->second_half_status == 'PO')
                                                    PO
                                                @elseif($attendance->second_half_status == 'A')
                                                    A
                                                @else
                                                    {{@$attendance->second_half_status  }}
                                                @endif
                                            </td>

                                            @php
                                                $lateDays += $attendance->late_comer;
                                                $leavesData = $payrollProcess->getMonthlyLeaves(
                                                    $employee,
                                                    $month,
                                                    $year,
                                                );
                                            @endphp
                                        @endforeach
                                        <td>{{ round(@$attendanceData['present'] ?: 0, 1) }}</td>
                                        <td>{{ round(@$attendanceData['weekOffs'] + @$attendanceData['holidays'] ?: 0, 1) }}
                                        </td>
                                        <td>-</td>
                                        <td>{{ round(@$leavesData['totalLeavesWPay'], 1) }}</td>
                                        <td>{{ round($lateDays, 1) }}</td>
                                        <td>{{ round(@$leavesData['totalLeavesWOPay'], 1) }}</td>
                                        <td>{{ round(@$attendanceData['totalPaidDays'] ?: 0, 1) }}</td>
                                        <td>{{ round(@$attendanceData['absent'] ?: 0, 1) }}</td>
                                        <td>-</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                    <div class="mt-2 d-flex justify-content-end align-items-end">
                        {{ $totalEmployees->appends($request->except('page'))->links('pagination::bootstrap-4') }}
                    </div>
                </div>
            </div>
        </div>
    </section>
@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="/assets/js/moment.min.js"></script>
    <script src="/assets/js/daterangepicker.js"></script>
    <script src="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
    <script src="/assets/plugins/bower_components/bootstrap-daterangepicker/daterangepicker.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/vendors/js/extensions/toastr.min.js"></script>
    <script src="/app-assets/js/scripts/forms/form-wizard.js"></script>

    
    <!-- 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>
        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });

        $(function() {
            getEmployeeByType('{{ $request->employee_type }}')
        })

        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>';
                    }
                    $('#employees_id').html(op);
                }
            });

        }

        $('#exportToExcel').click(function() {
            $('#muster-roll-fetch').attr('action', '/{!! $alias !!}/muster-roll-report/export');
            $('#muster-roll-fetch').submit();
            $('#muster-roll-fetch').attr('action', '/{!! $alias !!}/muster-roll-report');
            $(".preloader").fadeOut();
        });

        $(document).ready(function() {
            var selectedEmployeeIds = JSON.parse('{!! json_encode($request->employees_id ?? 0) !!}');

            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('#employees_id', selectedEmployeeIds, '/ajax/hod-list', 0);
        });
    </script>
@endpush