@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 Report</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 Report
                    </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 !!}/payroll-summary-report" class="btn btn-primary box-shadow-2 create-report-btn"
                            id="clearFilters">
                            Clear
                        </a>
                    
                        <a href="/{!! $alias !!}/payroll-summary-report-export?{{ http_build_query($_GET) }}"
                            class="btn btn-success box-shadow-2">
                            Export
                        </a>
                </div>
            </div>
        </div>
    </div>
@endpush
@php
    // Total Wage column should appear right after the last present wage
    // component, in priority order: special > hra > da > basic_salary.
    $wageAliases = ['basic_salary', 'da', 'hra', 'special'];
    $totalWageAfterAlias = null;

    foreach (['special', 'hra', 'da', 'basic_salary'] as $alias) {
        if ($payrollBasicComponents->contains('alias', $alias)) {
            $totalWageAfterAlias = $alias;
            break;
        }
    }

    $hasTotalWage = $totalWageAfterAlias !== null;
@endphp
@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>Emp. Code</th>
                                    <th>UAN No.</th>
                                    <th>ESIC No.</th>
                                    <th>Employee Name</th>
                                    <th>Father/Husband Name</th>
                                    <th>Gender</th>
                                    <th>Skill Category</th>
                                    <th>Department</th>
                                    @foreach ($payrollBasicComponents as $component)
                                        <th>{{ $component->name }}</th>
                                        @if($hasTotalWage && $component->alias == $totalWageAfterAlias)
                                            <th>Total Wage</th>
                                        @endif
                                    @endforeach
                                    <th><b>Total Basic</b></th>
                                    <th>WD</th>
                                    <th>Rest</th>
                                    @foreach ($leaveTypes as $leave)
                                        <th> {{ strtoupper($leave->alias) }} </th>
                                    @endforeach
                                    @foreach ($payrollDeductionComponents as $component)
                                        <th>{{ $component->name }}</th>
                                    @endforeach
                                    <th><b>Total Deduction</b></th>
                                    <th><b>Net Payment</b></th>
                                </tr>
                            </thead>
                            <tbody>
                                @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');
                                        }

                                        $totalBasic = 0;
                                        $totalDeduction = 0;
                                    @endphp

                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $employee->employee_code }}</td>
                                        <td>{{ $employee->uan_number }}</td>
                                        <td>{{ $employee->esic_no }}</td>
                                        <td>{{ $employee->name }}</td>
                                        <td>{{ $employee->father_name }}</td>
                                        <td>{{ $employee->gender }}</td>
                                        <td>{{ optional($employee->category)->name }}</td>
                                        <td>{{ optional($employee->department)->name }}</td>

                                        {{-- Basic Components --}}
                                        @php
                                            $totalWage = 0;
                                            $totalBasic = 0;
                                        @endphp

                                        @foreach($payrollBasicComponents as $component)
                                            @php
                                                $amount = isset($payrollEmployeeTempStructures[$component->id][0])
                                                    ? $payrollEmployeeTempStructures[$component->id][0]['calculate_salary']
                                                    : 0;
                                                if (in_array($component->alias, $wageAliases)) {
                                                    $totalWage += $amount;
                                                } else {
                                                    $totalBasic += $amount;
                                                }
                                            @endphp
                                            <td>{{ number_format($amount,2) }}</td>

                                            @if($hasTotalWage && $component->alias == $totalWageAfterAlias)
                                                <td><b>{{ number_format($totalWage, 2) }}</b></td>
                                            @endif
                                        @endforeach
                                        @php
                                            // Final Total Basic = Total Wage + Other Basic Components
                                            $totalBasic += $totalWage;
                                        @endphp

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

                                        <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) {
                                                    return $item->sum(function ($attendance) {
                                                        return ($attendance->first_half_status == 'L'
                                                                ? ($attendance->is_short_leave ? 1 : 0.5)
                                                                : 0)
                                                            + ($attendance->second_half_status == 'L'
                                                                ? ($attendance->is_short_leave ? 1 : 0.5)
                                                                : 0);
                                                    });
                                                });
                                        @endphp

                                        @foreach($leaveTypes as $leave)
                                            <td>{{ $employeeLeaves[$leave->alias] ?? 0 }}</td>
                                        @endforeach

                                        {{-- Deduction Components --}}
                                        @foreach($payrollDeductionComponents as $component)

                                            @php
                                                $amount = $slipLogs[$component->id] ?? 0;
                                                $totalDeduction += $amount;
                                            @endphp

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

                                        @endforeach

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

                                        <td>
                                            <b>{{ number_format($totalBasic - $totalDeduction,2) }}</b>
                                        </td>
                                    </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