@extends('app-new')
@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">

    <!-- BEGIN: Page CSS-->
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/form-wizard.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <!-- 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">Balance Report</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{ trans('common/common.home') }}</a>
                    </li>
                    <li class="breadcrumb-item active">Balance Report
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <form id="filterForm" class="loder-disabled" action="/{!! $alias !!}/balance-report" method="POST">
        {{ csrf_field() }}
        <section id="column-search-datatable">
            <div class="content-header row">
                <div class="content-header-left col-md-9 col-12 mb-2">
                    <div class="row breadcrumbs-top">
                        <div class="col-12">
                            <h2 class="content-header-title float-start mb-0"></h2>
                        </div>
                    </div>
                </div>
                <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
                    <div class="mb-1 breadcrumb-right">
                        <div class="dropdown">
                            <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                                data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                                type="button"><i data-feather='filter'></i></button>
                        </div>
                    </div>
                </div>
            </div>
            <div class="offcanvas-end-example">
                <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
                    <div class="offcanvas-header">
                        <h5 id="offcanvasEndLabel" class="offcanvas-title">{{ trans('common/common.filter') }}</h5>
                        <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas"
                            aria-label="Close"></button>
                    </div>
                    <div class="offcanvas-body my-auto mx-0 flex-grow-0">
                        <label class="form-label mt-2" for="month_id">{{ trans('common/common.month') }}</label>
                        <select class="form-control select2" name="month_id" id="month_id">
                            @foreach ($month as $mkey => $monthitem)
                                <option value="{{ $mkey }}" @if ($mkey == $month_id) selected @endif>
                                    {{ $monthitem }}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="year_id">{{ trans('common/common.year') }}</label>
                        <select class="form-control mb-2 select2" name="year_id" id="year_id">
                            @foreach ($year as $ykey => $yearitem)
                                <option value="{{ $yearitem }}" @if ($yearitem == $year_id) selected @endif>
                                    {{ $yearitem }}</option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="location_id">{{ trans('master/master.location') }}</label>
                        <select class="form-control mb-2 select2" name="location_id[]" id="location_id" multiple>
                            @foreach ($locations as $location)
                                <option value="{{ $location->id }}" @if (in_array($location->id, request()->input('location_id', []))) selected @endif>
                                    {{ $location->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="department_id">{{ trans('master/master.department') }}</label>
                        <select class="form-control mb-2 select2" name="department_id[]" id="department_id" multiple>
                            @foreach ($departments as $department)
                                <option value="{{ $department->id }}" @if (in_array($department->id, request()->input('department_id', []))) selected @endif>
                                    {{ $department->name }}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="designation_id">{{ trans('master/master.designation') }}</label>
                        <select class="form-control mb-2 select2" name="designation_id[]" id="designation_id" multiple>
                            @foreach ($designations as $designation)
                                <option value="{{ $designation->id }}" @if (in_array($designation->id, request()->input('designation_id', []))) selected @endif>
                                    {{ $designation->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="category_id">{{ trans('master/master.category') }}</label>
                        <select class="form-control mb-2 select2" name="category_id[]" id="category_id" multiple>
                            @foreach ($categories as $category)
                                <option value="{{ $category->id }}" @if (in_array($category->id, request()->input('category_id', []))) selected @endif>
                                    {{ $category->name }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="company_code_id">{{ trans('master/master.company_code') }}</label>
                        <select class="form-control mb-2 select2" name="company_code_id[]" id="company_code_id" multiple>
                            @foreach ($companyCodes as $companyCode)
                                <option value="{{ $companyCode->id }}" @if (in_array($companyCode->id, request()->input('company_code_id', []))) selected @endif>
                                    {{ $companyCode->number }}
                                </option>
                            @endforeach
                        </select>
                        @if (Auth::user()->is_contractor == 0)
                            <label class="form-label mt-2" for="contractor_id">{{ trans('master/master.contractor') }}</label>
                            <select class="form-control mb-2 select2" name="contractor_id[]" id="contractor_id" multiple>
                                @foreach ($contractors as $contractor)
                                    <option value="{{ $contractor->id }}"
                                        @if (in_array($contractor->id, request()->input('contractor_id', []))) selected @endif>
                                        {{ $contractor->name }}
                                    </option>
                                @endforeach
                            </select>
                        @endif
                        <label class="form-label mt-2" for="employee_type">{{ trans('master/master.employee_type') }}</label>
                        @if (Auth::user()->is_contractor == 0)
                            <select class="form-control mb-2 select2" name="employee_type" id="employee_type">
                                <option value="">Select {{ trans('master/master.type') }}</option>
                                @foreach ($employeeTypes as $empType)
                                    <option value="{{ $empType }}"
                                        @if ($empType == request()->input('employee_type')) selected @endif>
                                        {{ ucwords($empType) }}
                                    </option>
                                @endforeach
                            </select>
                        @else
                            <select class="form-control mb-2 select2" name="employee_type" id="employee_type">
                                <option>Select {{ trans('master/master.type') }}</option>
                                <option value="{{ $employeeType }}" @if ($employeeType == request()->input('employee_type')) selected @endif>
                                    {{ ucwords($employeeType) }}
                                </option>
                            </select>
                        @endif

                        <label class="form-label mt-2" for="employee_id">{{ trans('master/master.employees') }}</label>
                        <select class="form-control mb-2" name="employee_id[]" id="employee_id" multiple></select>
                        <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="">{{ trans('common/common.all') }}</option>
                            <option value="active" @if (request()->input('employee_status') == 'active') selected @endif>
                                {{ trans('common/common.active') }}</option>
                            <option value="inactive" @if (request()->input('employee_status') == 'inactive') selected @endif>
                                {{ trans('common/common.inactive') }}</option>
                            <option value="blacklist" @if (request()->input('employee_status') == 'blacklist') selected @endif>
                                {{ trans('common/common.blacklist') }}</option>
                        </select>
                        <button type="submit"
                            class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center"
                            data-bs-dismiss="offcanvas" aria-label="Close"><i data-feather='search' class="me-2"></i>
                            {{ trans('common/common.search') }}</button>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header border-bottom">
                            <div class="head-label">
                                <h6 class="mb-0">Balance Report - {{ $month_name }}</h6>
                            </div>
                            <div class="dt-action-buttons text-end">
                                <button type="button" id="export-to-excel"
                                    data-url="/{!! $alias !!}/balance-report/export"
                                    class="btn btn-primary waves-effect waves-float waves-light">
                                    <span>{{ trans('common/common.export_to_excel') }}</span>
                                </button>
                                <button type="button"
                                    onclick="window.location.href='/{!! $alias !!}/balance-report'"
                                    class="btn btn-secondary waves-effect waves-float waves-light">
                                    <span>Reset</span>
                                </button>
                            </div>
                        </div>

                        <div class="card-datatable">
                            <table class="dt-column-search table table-responsive tablenewheadfixed" id="organization">
                                <thead>
                                    <tr>
                                        <th class="text-nowrap">S.No</th>
                                        <th class="text-nowrap">{{ trans('common/common.month') }}</th>
                                        <th class="text-nowrap">{{ trans('master/master.employee_code') }}</th>
                                        <th class="text-nowrap">{{ trans('master/master.employee_name') }}</th>
                                        <th class="text-nowrap">{{ trans('master/master.department') }}</th>
                                        <th class="text-nowrap">{{ trans('master/master.designation') }}</th>
                                        <th class="text-nowrap">Actual OT Hours</th>
                                        <th class="text-nowrap">Fact OT Hours(Double Ot)</th>
                                        <th class="text-nowrap">OT Hours Difference</th>
                                        <th class="text-nowrap">Actual OT Amount</th>
                                        <th class="text-nowrap">Fact OT Amount(Double Ot)</th>
                                        <th class="text-nowrap">OT Amount Difference</th>
                                        <th class="text-nowrap">Actual Salary</th>
                                        <th class="text-nowrap">Factual Salary</th>
                                        
                                    </tr>
                                </thead>

                                <tbody>
                                    @php
                                        $totalActualOtHours = $totalFactOtHours = $totalOtHoursDifference = 0;
                                        $totalActualOtAmount = $totalFactOtAmount = 0;
                                        $totalActualSalary = $totalFactualSalary = $totalSalaryDifference = 0;
                                    @endphp
                                    @forelse ($reportData as $row)
                                        @php
                                            $totalActualOtHours += $row->actual_ot_hours;
                                            $totalFactOtHours += $row->fact_ot_hours;
                                            $totalOtHoursDifference += $row->ot_hours_difference;
                                            $totalActualOtAmount += $row->actual_ot_amount;
                                            $totalFactOtAmount += $row->fact_ot_amount;
                                            $totalActualSalary += $row->actual_salary;
                                            $totalFactualSalary += $row->factual_salary;
                                            $totalSalaryDifference += $row->salary_difference;
                                        @endphp
                                        <tr>
                                            <td>{{ ($reportData->currentPage() - 1) * $reportData->perPage() + $loop->iteration }}</td>
                                            <td class="text-nowrap">{{ $row->month }}</td>
                                            <td class="text-nowrap"><strong>{{ $row->employee_code }}</strong></td>
                                            <td class="text-nowrap">{{ $row->employee_name }}</td>
                                            <td class="text-nowrap">{{ $row->department }}</td>
                                            <td class="text-nowrap">{{ $row->designation }}</td>
                                            <td class="text-nowrap">{{ number_format($row->actual_ot_hours, 2, '.', '') }}</td>
                                            <td class="text-nowrap">{{ number_format($row->fact_ot_hours, 2, '.', '') }}</td>
                                            <td class="text-nowrap">{{ number_format($row->ot_hours_difference, 2, '.', '') }}</td>
                                            <td class="text-nowrap">{{ number_format($row->actual_ot_amount, 2, '.', '') }}</td>
                                            <td class="text-nowrap">{{ number_format($row->fact_ot_amount) }}</td>
                                            <td class="text-nowrap">{{ number_format($row->salary_difference) }}</td>
                                            <td class="text-nowrap">{{ number_format($row->actual_salary) }}</td>
                                            <td class="text-nowrap">{{ number_format($row->factual_salary) }}</td>
                                        </tr>
                                    @empty
                                        <tr class="no-record-row">
                                            <td colspan="14" class="text-center">No record found</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                            <br>
                            {{ $reportData->appends(request()->except('page'))->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </form>
    <!--/ Column Search -->
@endsection
@push('footer-script')
    <!-- BEGIN: Page Vendor JS-->
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>
    <!-- END: Page Vendor JS-->

    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
    <script>
        var selectedEmployeeIds = JSON.parse('{!! json_encode(request()->input('employee_id', [])) !!}');
        

        function callDt() {
            var dt_filter_table = $('.dt-column-search');

            if ($('body').attr('data-framework') === 'laravel') {
                assetPath = $('body').attr('data-asset-path');
            }
            if (!dt_filter_table.length) {
                return;
            }

            // The placeholder row spans every column, which DataTables cannot read as
            // data. Hand its text to DataTables instead and drop the row, so the table
            // still gets initialised and keeps its layout when there is nothing to show.
            var placeholderRow = dt_filter_table.find('tbody tr.no-record-row');
            var emptyMessage = placeholderRow.length ? $.trim(placeholderRow.text()) : 'No record found';
            placeholderRow.remove();

            dt_filter_table.DataTable({
                orderCellsTop: true,
                "bPaginate": false,
                "ordering": false,
                "searching": false,
                "bInfo": false,
                language: {
                    emptyTable: emptyMessage
                }
            });
        };

        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });

        function employeeOptionText(item) {
            return item.name + ' (' + (item.employee_code || '') + ')';
        }

        function initializeEmployeeSelect2(selector, preSelectedIds, url) {
            $(selector).select2({
                multiple: true,
                ajax: {
                    url: url,
                    dataType: 'json',
                    data: function(params) {
                        return {
                            alias: '{{ $organization->alias }}',
                            has_contractor_employees: true,
                            employee_type: $('#employee_type').val(),
                            search: params.term,
                            only_current_organization: true
                        };
                    },
                    processResults: function(data) {
                        return {
                            results: $.map(data.data, function(item) {
                                return {
                                    id: item.id,
                                    text: employeeOptionText(item)
                                };
                            })
                        };
                    },
                    cache: true
                },
                placeholder: 'Search with name or code',
                minimumInputLength: 1,
                allowClear: true
            });

            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(employeeOptionText(item), item.id, true, true);
                            $(selector).append(option).trigger('change');
                        });
                    }
                });
            }
        }

        $(document).ready(function() {
            // Filter first, table after, so a table error can never leave the
            // offcanvas showing unstyled selects.
            $('.select2').select2();
            initializeEmployeeSelect2('#employee_id', selectedEmployeeIds, '/ajax/hod-list');
            callDt();
        });

        // The employee list is scoped by employee type, so drop stale picks when it changes.
        $('#employee_type').change(function() {
            $('#employee_id').val(null).trigger('change');
        });

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