@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/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/forms/select/select2.min.css">
    <link rel="stylesheet" type="text/css" href="../../../assets/css/jquery-ui.min.css">
    <!-- END: Page CSS-->
@endpush

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h3 class="content-header-title float-start mb-0">Salary Register</h3>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="{{ url('') }}/{!! $alias !!}/home">Home</a>
                    </li>
                    <li class="breadcrumb-item active">Salary Register
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush

@push('prev-next-head')
    <div class="content-header-right text-end col-md-3">
        <div class="form-group breadcrumb-right">
            <div class="row">
                <div class="col-md-12">
                    <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>
                    <a href="/{!! $alias !!}/salary-register" class="btn btn-primary box-shadow-2 create-report-btn"
                        id="clearFilters">Clear</a>
                    @if($exportExcel)
                        <a href="/{!! $alias !!}/salary-register-export?{{ http_build_query($_GET) }}"
                            class="btn btn-success box-shadow-2">
                            Export
                        </a>
                    @else
                        <a href="/{!! $alias !!}/salary-register-pdf?{{ http_build_query($_GET) }}"
                            class="btn btn-primary box-shadow-2 cretareportbtn">
                                Export
                        </a>
                    @endif
                </div>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <section id="column-search-datatable">
        <div class="row mt-2">
            <div class="col-12">
                <div class="card">
                    <div class="card-datatable table-responsive">
                        <table class="dt-column-search table table-responsive dataTable" id="dataTable" data-url="">
                            <thead>
                                <tr class="head-tr">
                                    <th>S.No.</th>
                                    <th>Employee Name</th>
                                    <th>Emp. Code</th>
                                    <th>Father/Husband Name</th>
                                    <th>Designation/Category</th>

                                    @foreach ($payrollComponentHeads1 as $component)
                                        <th>
                                            {{ @$componentAbv[$component->id] }}
                                        </th>
                                    @endforeach
                                    <th>WD</th>
                                    <th>Rest</th>
                                    @foreach ($leaveTypes as $leave)
                                        <th> {{ strtoupper($leave->alias) }} </th>
                                    @endforeach
                                    <th>Total</th>
                                    @foreach ($payrollComponentHeads2 as $component)
                                        <th>
                                            {{ @$componentAbv[$component->id] }}
                                        </th>
                                    @endforeach
                                    @foreach ($payrollComponentHeads3 as $component)
                                        <th>
                                            {{ @$componentAbv[$component->id] }}
                                        </th>
                                    @endforeach
                                    <th>Total Deduction</th>
                                    @foreach ($payrollComponentHeads4 as $component)
                                        <th>
                                            {{ @$componentAbv[$component->id] }}
                                        </th>
                                    @endforeach
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $employeeTotalDeduction = 0;
                                    $employeeNetAmtPaid = 0;
                                @endphp
                                @foreach ($employees as $employee)
                                    @php
                                        $payrollEmployeeTempStructures = isset(
                                            $employee->employeeCtcMaster->payrollEmployeeTempStructures,
                                        )
                                            ? $employee->employeeCtcMaster->payrollEmployeeTempStructures
                                                ->groupBy('type_id')
                                                ->toArray()
                                            : [];

                                        $slipLogs = [];
                                        if (
                                            isset($employee->salarySlip->slipLogs) &&
                                            !empty($employee->salarySlip->slipLogs)
                                        ) {
                                            $slipLogs = $employee->salarySlip->slipLogs->pluck(
                                                'calculate_salary',
                                                'type_id',
                                            );
                                        }
                                    @endphp
                                    <tr class="detail-tr">
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $employee->name }}</td>
                                        <td>{{ $employee->employee_code }}</td>
                                        <td>{{ $employee->father_name }}</td>
                                        <td>{{ @$employee->department->name }} - {{ @$employee->category->name }}</td>
                                        @foreach ($payrollComponentHeads1 as $component)
                                            <td>
                                                {{ isset($payrollEmployeeTempStructures[$component->id][0]) ? $payrollEmployeeTempStructures[$component->id][0]['calculate_salary'] : 0 }}
                                            </td>
                                        @endforeach
                                        <td>{{ $employee->salarySlip->total_present_days ?? 0 }}</td>
                                        <td>{{ $employee->salarySlip->week_offs ?? 0 }}</td>
                                        @php
                                            $employeeLeaves = $employee->attendanceSummary
                                                ->groupBy('leave_type')
                                                ->map(function ($item, $key) {
                                                    $sum = $item->sum(function ($item1) {
                                                        return ($item1->first_half_status == 'L'
                                                            ? ($item1->is_short_leave == '1'
                                                                ? 1
                                                                : 0.5)
                                                            : 0) +
                                                            ($item1->second_half_status == 'L'
                                                                ? ($item1->is_short_leave == '1'
                                                                    ? 1
                                                                    : 0.5)
                                                                : 0);
                                                    });

                                                    return $sum;
                                                });
                                        @endphp
                                        @foreach ($leaveTypes as $leave)
                                            <td>
                                                {{ isset($employeeLeaves[$leave->alias]) ? $employeeLeaves[$leave->alias] : 0 }}
                                            </td>
                                        @endforeach
                                        <td>0</td>
                                        @foreach ($payrollComponentHeads2 as $component)
                                            <td>
                                                {{ isset($slipLogs[$component->id]) && $slipLogs[$component->id] ? $slipLogs[$component->id] : 0 }}
                                            </td>
                                        @endforeach
                                        @foreach ($payrollComponentHeads3 as $component)
                                            @php
                                                $val =
                                                    isset($slipLogs[$component->id]) && $slipLogs[$component->id]
                                                        ? $slipLogs[$component->id]
                                                        : 0;
                                                $employeeTotalDeduction += $val;
                                            @endphp
                                            <td>{{ $val }}</td>
                                        @endforeach
                                        <td>{{ $employeeTotalDeduction }}</td>
                                        @foreach ($payrollComponentHeads4 as $component)
                                            <td>
                                                {{ isset($slipLogs[$component->id]) && $slipLogs[$component->id] ? $slipLogs[$component->id] : 0 }}
                                            </td>
                                        @endforeach
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>

                        @if (count($employees) == 0)
                            <div>
                                <center>No record(s) found!</center>
                            </div>
                        @endif

                        <div class="d-flex justify-content-between mx-0 row">
                            <div class="col-sm-12 col-md-6">
                                <div class="dataTables_info" id="organization_info" role="status" aria-live="polite">
                                    Showing {{ ($employees->currentPage() - 1) * $employees->perPage() + 1 }}
                                    to {{ ($employees->currentPage() - 1) * $employees->perPage() + $employees->count() }}
                                    of {{ $employees->total() }} entries
                                </div>
                            </div>
                            <div class="col-sm-12 col-md-6">
                                {{ $employees->appends(request()->except('page'))->links('partials.pagination') }}
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

    <form method="get" id="filter-form">
        <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">
                    <div class="row">
                        <div class="col-md-12">
                            <label class="form-label" for="year">{{ trans('admin/template.year') }}</label>
                            <select class="form-control mb-2" name="year" id="year">
                                <option value="">select</option>
                                @foreach ($years as $val)
                                    <option class="form-control" value="{{ $val }}"
                                        @if ($val == $year) selected @endif>{{ $val }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-12">
                            <label class="form-label" for="area_id">{{ trans('admin/template.month') }}</label>
                            <select class="form-control mb-2" name="month" id="month">
                                <option value="">select</option>
                                @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-12">
                            <label class="form-label" for="area_id">Workstation</label>
                            <select name="work_station_id" id="work_station_id" class="form-control mb-2">
                                <option value="">All</option>
                                @foreach ($workStations as $key => $workStation)
                                    <option value="{{ $workStation->id }}"
                                        @if ($workStation->id == request()->work_station_id) selected @endif>{{ $workStation->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-12">
                            <label class="form-label" for="area_id">Department</label>
                            <select name="department_id" id="department_id" class="form-control mb-2">
                                <option value="">All</option>
                                @foreach ($departments as $key => $department)
                                    <option value="{{ $department->id }}"
                                        @if ($department->id == request()->department_id) selected @endif>{{ $department->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-12 mb-2">
                            <label class="form-label" for="category_id">Category</label>
                            <select name="category_id[]" id="category_id" class="form-control select2"
                                multiple="multiple">
                                {{-- <option value="">All</option> --}}
                                @foreach ($categories as $key => $category)
                                    <option value="{{ $category->id }}" @if (!empty(request()->category_id) && in_array($category->id, request()->category_id)) selected @endif>
                                        {{ $category->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-12 mb-2">
                            <label class="form-label" for="employee_type">Employee Type</label>
                            <select name="employee_type" id="employee_type" class="form-control"
                                onchange="selectEmployeeTypes(this.value);">
                                <option value=""></option>
                                @foreach ($employeeTypes as $employeeType)
                                    <option value="{{ $employeeType }}" @if ($employeeType == request()->employee_type) selected @endif>
                                        {{ ucfirst($employeeType) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-12" id="contractor_div">
                            <label class="form-label" for="contractor_id">Contractor</label>
                            <select name="contractor_id" id="contractor_id" class="form-control">
                                <option value=""></option>
                                @foreach ($contractors as $contractor)
                                    <option value="{{ $contractor->id }}"
                                        @if ($contractor->id == request()->contractor_id) selected @endif>
                                        {{ ucfirst($contractor->name) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <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>
                        Apply
                    </button>
                </div>
            </div>
        </div>
    </form>
@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="/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>
    <!-- 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>
    <script src="/app-assets/vendors/js/forms/select/select2.full.min.js"></script>
    <script src="/../assets/js/jquery-ui.min.js"></script>
    <!-- END: Page JS-->

    <script>
        $(document).ready(function() {
            var emptype = '{{ request()->employee_type }}';
            $('.select2').select2();
            $("#contractor_div").hide();
            selectEmployeeTypes(emptype)
        });

        function selectEmployeeTypes(val) {
            if (val == 'workman') {
                $("#contractor_div").show();
            } else {
                $("#contractor_div").hide();
                $("#contractor_id").val(''); 
            }
        }
    </script>
@endpush