@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-->
@endpush
@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">Wages Sheet</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="/{!! $alias !!}/home">Home</a>
                    </li>
                    <li class="breadcrumb-item active">Wages Sheet
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush

@section('content')
    <section id="dashboard-ecommerce">
        <div class="content-header row">
            <div class="content-header-right text-md-end col-md-12 col-12 d-md-block d-none mt-2">
                <div class="mb-1 mt-2 breadcrumb-right">
                    <button
                        class="px-2 btn-icon btn btn-secondary btn-round dropdown-toggle waves-effect waves-float waves-light"
                        type="button" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                        Export
                    </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 class="dropdown-menu">
                        <a class="dropdown-item" target="_blank"
                            href="{{ $orgUrl . '/wages-sheet/export?' . request()->getQueryString() . '&export=excel' }}">
                            <span>{{ trans('common/common.excel') }}</span>
                        </a>
                        {{-- <a class="dropdown-item" target="_blank"
                            href="{{ $orgUrl . '/wages-sheet/export?' . request()->getQueryString() . '&export=pdf' }}">
                            <span>{{ trans('common/common.pdf') }}</span>
                        </a> --}}
                    </div>
                </div>
            </div>
        </div>

        <div class="offcanvas-end-example">
            <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
                <div class="offcanvas-body my-auto mx-0 flex-grow-0">
                    <form>
                        <div class="row">
                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <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>
                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <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>
                            <div class="col-sm-12 mt-1">
                                <div class="form-label-group">
                                    <label class="form-label" 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.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>

                        <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>
                    </form>
                </div>

            </div>
        </div>

        <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($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">
                                    WAGES SHEET OF <strong>{{ $contractorName }}</strong> FOR
                                    THE MONTH OF
                                    <strong>
                                        {{ date('F - Y', strtotime('01-' . $month . '-' . $year)) }}
                                    </strong>
                                </h4>
                            @else
                                <h4 class="text-danger">
                                    WAGES SHEET OF <strong>{{ $organization->name }}</strong> FOR
                                    THE MONTH OF
                                    <strong>
                                        {{ date('F - Y', strtotime('01-' . $month . '-' . $year)) }}
                                    </strong>
                                </h4>
                            @endif
                        </div>
                    </div>
                    <div class="card-datatable table-responsive">
                        <table class="table table-responsive tablenewheadfixed" id="organization" border="1px black">
                            <thead>
                                <tr>
                                    <th>Serial No</th>
                                    <th>ESIC No.</th>
                                    <th>UAN No.</th>
                                    <th>PF No.</th>
                                    <th>Emp Code</th>
                                    <th>Name of Worker</th>
                                    <th>Gender</th>
                                    <th>DOB</th>
                                    <th>DOJ</th>
                                    <th>Department</th>
                                    <th>Workstation</th>
                                    <th>Activity</th>
                                    <th>Education</th>
                                    <th>Category</th>
                                    <th>Worked Days</th>
                                    <th>PH</th>
                                    <th>Arrears Days</th>
                                    <th>Total Paid Days</th>
                                    <th>Actual OT hrs</th>
                                    <th>Arrears OT hrs</th>
                                    <th>Total OT</th>

                                    @foreach ($earningDerivedComponents as $component)
                                        <th>{{ $component->name ?? '-' }}</th>
                                    @endforeach
                                    <th>Total Earnings</th>
                                    @foreach ($deductionDerivedComponents as $component)
                                        <th>{{ $component->name ?? '-' }}</th>
                                    @endforeach
                                    <th>Total Deductions</th>
                                    <th>Net Payable</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($employees as $index => $employee)
                                    @php
                                        $payrollProcess = new \App\Lib\Services\PayrollProcess();
                                        $attendanceData = $payrollProcess->getPayrollAttendanceData(
                                            $organization,
                                            $employee,
                                            $month,
                                            $year,
                                        );

                                        $atSummary = $employee->getAttendanceSummaryList($month, $year);
                                        $leavesData = $payrollProcess->getMonthlyLeaves($employee, $month, $year);

                                        $present = $attendanceData['present'] ?? 0;
                                        $absent = $attendanceData['absent'] ?? 0;
                                        $weekOff = $attendanceData['weekOffs'] ?? 0;
                                        $hd = $attendanceData['halfDays'] ?? 0;
                                        $arrearDays = $attendanceData['arrearDays'] ?? 0;
                                        $co = $attendanceData['compensations'] ?? 0;
                                        $ph = $attendanceData['holidays'] ?? 0;
                                        $payDay = $attendanceData['totalPaidDays'] ?? 0;
                                        $totalPaidDay = $payDay + $co - ($ph + $hd);

                                        $earningDerivedTotal = 0;
                                        $deductionDerivedTotal = 0;
                                        $slipLogs = isset($employee->salarySlip->slipLogs)
                                            ? $employee->salarySlip->slipLogs->pluck('calculate_salary', 'type_id')
                                            : [];
                                    @endphp
                                    <tr>
                                        <td>{{ $index + 1 }}</td>
                                        <td>{{ $employee->esic_no ?? '-' }}</td>
                                        <td>{{ $employee->uan_no ?? '-' }}</td>
                                        <td>{{ $employee->pf_no ?? '-' }}</td>
                                        <td>{{ $employee->employee_code ?? '-' }}</td>
                                        <td>{{ ucfirst($employee->name) ?? '-' }}</td>
                                        <td>{{ ucfirst($employee->gender) ?? '-' }}</td>
                                        <td>{{ $employee->dob ? date('d-m-Y', strtotime($employee->dob)) : '-' }}</td>
                                        <td>{{ $employee->date_of_joining ? date('d-m-Y', strtotime($employee->date_of_joining)) : '-' }}
                                        </td>
                                        <td>{{ isset($employee->department->name) ? ucfirst($employee->department->name) : '-' }}
                                        </td>
                                        <td>{{ isset($employee->workstation->name) ? ucfirst($employee->workstation->name) : '-' }}
                                        </td>
                                        <td>{{ isset($employee->designation->name) ? ucfirst($employee->designation->name) : '-' }}
                                        </td>
                                        <td>{{ $employee->education ?? '-' }}</td>
                                        <td>{{ $employee->category->name ?? '-' }}</td>
                                        <td>{{ $present }}</td>
                                        <td>{{ $ph }}</td>
                                        <td>{{ $arrearDays ?? '-' }}</td>
                                        <td>{{ round($totalPaidDay, 2) }}</td>
                                        <td>{{ $attendanceData['actualOT'] ?? '-' }}</td>
                                        <td>{{ $attendanceData['arrearsOT'] ?? '-' }}</td>
                                        <td>{{ $attendanceData['totalOT'] ?? '-' }}</td>

                                        @foreach ($earningDerivedComponents as $component)
                                            @php
                                                $earning = round($slipLogs[$component->id] ?? 0, 2);
                                                $earningDerivedTotal += $earning;
                                            @endphp
                                            <td>{{ $earning }}</td>
                                        @endforeach

                                        <td>{{ round($earningDerivedTotal, 2) }}</td>

                                        @foreach ($deductionDerivedComponents as $component)
                                            @php
                                                $deduction = round($slipLogs[$component->id] ?? 0, 2);
                                                $deductionDerivedTotal += $deduction;
                                            @endphp
                                            <td>{{ $deduction }}</td>
                                        @endforeach

                                        <td>{{ round($deductionDerivedTotal, 2) }}</td>

                                        @php
                                            $netPayable = $earningDerivedTotal - $deductionDerivedTotal;
                                        @endphp

                                        <td>{{ round($netPayable, 2) }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    <div class="d-flex justify-content-end align-items-end">
                        {{ $employees->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 selectedEmployees = <br />
<b>Warning</b>:  Undefined variable $request in <b>/var/www/html/thepresence360/resources/views/attendance-report/wage-sheet/index.blade.php</b> on line <b>390</b><br />
<br />
<b>Warning</b>:  Attempt to read property "employees_id" on null in <b>/var/www/html/thepresence360/resources/views/attendance-report/wage-sheet/index.blade.php</b> on line <b>390</b><br />
[];
            var url = "{!! route('employees-by-type', ['alias' => $alias]) !!}?employee_type=" + employee_type;
            $.ajax({
                url: url,
                type: "GET",
                success: function(data) {
                    op = '<option value="">Select Employees</option>';
                    for (var i = 0; i < data.length; i++) {
                        op += '<option value="' + data[i].id + '" ' + (selectedEmployees.includes(data[i].id
                                .toString()) ? 'selected' : '') + '>' + data[i].name + '(' + data[i]
                            .employee_code + ')</option>';
                    }
                    $('#employees_id').html(op);
                }
            });
        }
    </script>
@endpush