@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">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <!-- END: Page CSS-->
@endpush

@section('content')
    <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">{{ trans('master/master.overtime_incentive') }}</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">{{ trans('master/master.overtime_incentive') }} -
                                {{ trans('master/master.report') }}
                            </li>
                        </ol>
                    </div>
                </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>
    <!-- Column Search -->
    <div class="offcanvas-end-example">
        <form action="{{ route('overtime.incentive.report', ['slug' => $alias]) }}" method="GET">
            <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="area_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 || old('month_id') == $mkey) selected @endif>
                                {{ $monthitem }}</option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_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 || old('year_id') == $yearitem) selected @endif>
                                {{ $yearitem }}</option>
                        @endforeach
                    </select>
                    
                    <label class="form-label mt-2" for="date_range">Date range</label>
                    <input type="text" id="date_range" name="date_range" value="{{$dateRange}}" class="form-control daterangebg"> {!! $errors->first('date_range', '<label class="control-label error" for="date_range">:message</label>')!!}

                    <label class="form-label mt-2" for="area_id">{{trans('master/master.location')}}</label>
                    <select class="form-control mb-2 select2" name="location_id[]" id="location_id" onchange="getsubLocations(this,'sublocations')" multiple>
                        @foreach($locations as $location)
                            <option value="{{$location->id}}" @if( ($locationIds) && in_array($location->id, $locationIds)) selected @endif>{{$location->name}}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_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 ($departmentIds && in_array($department->id, $departmentIds)) selected @endif>
                                {{ $department->name }}</option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_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 ($designationIds && in_array($designation->id, $designationIds)) selected @endif>
                                {{ $designation->name }}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" 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 ($workstationIds && in_array($workstation->id, $workstationIds)) selected @endif>
                                {{ $workstation->name }}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_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 ($categoryIds && in_array($category->id, $categoryIds)) selected @endif>
                                {{ $category->name }}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_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( ($companyCodeIds) && in_array($companyCode->id, $companyCodeIds)) selected @endif>
                                {{$companyCode->number}}
                            </option>
                        @endforeach
                    </select>
                    @if (Auth::user()->is_contractor == 0)
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.contractor') }}</label>
                        <select class="form-control mb-2 select2" name="contractor_id[]" id="contractor_id" multiple>
                            <option value="">Select contractor</option>
                            @foreach ($contractors as $contractor)
                                <option value="{{ $contractor->id }}" @if ($contractorIds && in_array($contractor->id, ($contractorIds))) selected @endif>
                                    {{ $contractor->name }}
                                </option>
                            @endforeach
                        </select>
                    @endif
                    <label class="form-label mt-2" for="area_id">{{ 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"
                            onchange="getEmployeeByType(this.value)">
                            <option value="">Select {{ trans('master/master.type') }}</option>
                            @foreach ($employeeTypes as $empType)
                                <option value="{{ $empType }}" @if ($empType == $employee_type_selected) selected @endif>
                                    {{ ucwords($empType) }}
                                </option>
                            @endforeach
                        </select>
                    @else
                        <select class="form-control mb-2 select2" name="employee_type" id="employee_type"
                            onchange="getEmployeeByType(this.value)">
                            <option>Select {{ trans('master/master.type') }}</option>
                            <option value="{{ $employeeType }}" @if ($employeeType == $employee_type_selected) selected @endif>
                                {{ ucwords($employeeType) }}
                            </option>
                        </select>
                    @endif

                    <label class="form-label mt-2" for="area_id">{{ trans('master/master.employees') }}</label>
                    <select class="form-control mb-2 select2" name="employee_id[]" id="employee_id" multiple>
                        <option value="">Select {{ trans('master/master.type') }}</option>
                    </select>
                    <label class="form-label mt-2" for="status">{{trans('common/common.status')}}</label>
                    <select class="form-control select2" name="status" id="status">
                        <option value="">{{ trans('common/common.all') }}</option>
                        <option value="active" @if(request()->input('status') == "active" ) selected
                            @endif>{{trans('common/common.active')}}</option>
                        <option value="inactive" @if(request()->input('status') == "inactive" ) selected
                            @endif>{{trans('common/common.inactive')}}</option>
                        <option value="blacklist" @if(request()->input('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>
        </form>
    </div>
    
    <section id="column-search-datatable">
        <div class="offcanvas-end-example">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header border-bottom">
                            <div class="head-label">
                                
                            </div>
                            <div class="dt-action-buttons text-end">
                                <a class="dt-button buttons-excel" target="_blank"
                                href="/{{ $alias }}/overtime/incentive/export?month_id={{ $month_id }}&year_id={{ $year_id }}&date_range={{ $dateRange }}&contractor_id={{ $contractorIds ? implode(',', $contractorIds) : '' }}&employee_type={{ $employee_type_selected }}&employee_id={{ $employeeIds ? implode(',', $employeeIds) : '' }}&location_id={{ $locationIds ? implode(',', $locationIds) : '' }}&designation_id={{ $designationIds ? implode(',', $designationIds) : '' }}&category_id={{ $categoryIds ? implode(',', $categoryIds) : '' }}&work_station_id={{ $workstationIds ? implode(',', $workstationIds) : '' }}&company_code_id={{ $companyCodeIds ? implode(',', $companyCodeIds) : '' }}&department_id={{ $departmentIds ? implode(',', $departmentIds) : '' }}&status={{ $status }}"
                                style="display: initial;"><button type="button"
                                    class="btn btn-primary waves-effect waves-float waves-light">
                                    <span> Export to Excel</span>
                                </button></a>
                            </div>
                        </div>
                        
                        <div class="card-datatable">
                            <table class="dt-column-search table table-responsive daysumleftfixed tablenewheadfixed"
                                id="organization">
                                <thead>
                                    <th>S.No</th>
                                    <th class="text-nowrap">Emp. Name & Code</th>
                                    <th>{{ trans('master/master.department') }}</th>
                                    <th>{{ trans('master/master.designation') }}</th>
                                    @foreach ($dateArr as $dates)
                                        <th>{{ date('d', strtotime($dates)) }}</th>
                                    @endforeach
                                    <th class="text-nowrap">
                                        {{ trans('master/master.total_ot') }}({{ trans('master/master.hours') }})
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('master/master.total_working_days') }}
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('payroll/payroll.gross_salary') }}
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('master/master.attendance_incentive_amount') }}
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('master/master.overtime_incentive_amount') }}
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('master/master.multi_amount') }}
                                    </th>
                                    <th class="text-nowrap">
                                        {{ trans('payroll/payroll.total_amount') }}
                                    </th>
                                </thead>
                                <tbody>

                                    @foreach ($employeeSummary as $key => $value)
                                        @php
                                            $totalPresent = $overtime = $actualOvertime = $totalActualOvertime = $totalovertime = 0;
                                            $totalWorkingDays = 0;
                                            $atSummary = $value->getAttendanceSummaryFilter($fromDate, $toDate);
                                            $salarySlip = @$value->salarySlip->select('id','employee_id','month','year','total_gross')
                                                ->where('employee_id',$value->id)
                                                ->where('month','=',$month_id)
                                                ->where('year','=',$year_id)
                                                ->first();  
                                            $totalGross = $salarySlip->total_gross? $salarySlip->total_gross:'-';
                                            $overtimeIncentive = @$salarySlip->slipLogs->where('type_id', $overtimeIncentiveComponent->config_value)->first();
                                            $overtimeIncentive = @$overtimeIncentive->calculate_salary?:0;

                                            $attendanceIncentive = @$salarySlip->slipLogs->where('type_id', $attendanceIncentiveComponent->config_value)->first();
                                            $attendanceIncentive = @$attendanceIncentive->calculate_salary?:0;

                                            $multiAmount = @$salarySlip->slipLogs->where('type_id', $multiAmountComponent->config_value)->first();
                                            $multiAmount = @$multiAmount->calculate_salary?:0;
                                            $totalAmount = $overtimeIncentive + $attendanceIncentive + $multiAmount;
                                            
                                        @endphp
                                        <tr>
                                            <td>
                                                @if (isset($_GET['page']) && $_GET['page'] > 0)
                                                    {{ ($_GET['page'] - 1) * 10 + $loop->iteration }}
                                                @else
                                                    {{ $loop->iteration }}
                                                @endif
                                            </td>
                                            <td class="text-nowrap"><strong>{{ $value->name }}</strong> <span
                                                    class="employeecodereport">({{ $value->employee_code }})</span></td>
                                            <td class="text-nowrap">{{ @$value->department->name }}</td>
                                            <td class="text-nowrap">{{ @$value->designation->name }}</td>   
                                            @foreach ($dateArr as $date)
                                                @if (!isset($atSummary[$date]))
                                                    <td>
                                                        -
                                                    </td>
                                                    @continue;
                                                @endif
                                                @php
                                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                    $approvedOvertime = intval(substr($attendance->overtime, 0, -6)) * 60 + intval(substr($attendance->overtime, -5, -3));
                                                    $overtime = $overtime + $approvedOvertime;
                                                    $totalovertime = round($overtime / 60, 2);
                                                    $actualOvertime += intval(substr($attendance->actual_overtime, 0, -6)) * 60 + intval(substr($attendance->actual_overtime, -5, -3));
                                                    $totalActualOvertime = round($actualOvertime / 60, 2);
                                                    $totalWorkingDays = $totalWorkingDays + $attendance->day_count;
                                                @endphp
                                                <td class="text-nowrap">
                                                    @if($approvedOvertime>0)
                                                        {{round($approvedOvertime /60,2) }}
                                                    @else
                                                    -
                                                    @endif
                                                </td>
                                            @endforeach
                                            <td>{{ $totalovertime?$totalovertime:'-' }}</td>
                                            <td>{{ $totalWorkingDays? $totalWorkingDays:'-'}}</td>  
                                            <td>{{ $totalGross?$totalGross:'-'}}</td>
                                            <td>{{$attendanceIncentive}}</td>
                                            <td>{{$overtimeIncentive}}</td>
                                            <td>{{$multiAmount}}</td>
                                            <td>{{$totalAmount}}</td>
                                        </tr>
                                    @endforeach

                                </tbody>
                            </table>
                            <br>
                            {{ $employeeSummary->appends($nextQuery)->links('pagination::bootstrap-4') }}
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    
    <!--/ 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/vendors/js/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.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/js/scripts/forms/form-wizard.js"></script>
    
    {{-- date range picker --}}
    <script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />

    <!-- 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 subLocations = $('#sublocation_selected_id').val();

        var employeeIds = JSON.parse('{!! json_encode($employeeIds) !!}');

        function daysInMonth(month, year) {
            return new Date(year, month, 0).getDate();
        }

        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) {

                var dt_filter = dt_filter_table.DataTable({
                    orderCellsTop: true,
                    "bPaginate": false,
                    "ordering": false,
                    "searching": false,
                    "bInfo": false,
                });
            }
        };

        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });
        $(document).ready(function() {
            callDt();
            getEmployeeByType("{{ $employee_type_selected }}");
        });

        $(document).ready(function(){
            $('.select2').select2();

            var month = $('#month_id').val();
            var year = $('#year_id').val();
            month = String(month).padStart(2, '0');
            var totalDaysInMonth = daysInMonth(month, year);

            var fromDate = month +'/'+ '01' +'/'+ year;
            var toDate = month +'/'+ totalDaysInMonth +'/'+ year;
            $('input[name="date_range"]').daterangepicker({
                minDate: fromDate,
                maxDate: toDate
            });
        })    

        $('#month_id, #year_id').change(function () {
            var month = $('#month_id').val();
            var year = $('#year_id').val();
            month = String(month).padStart(2, '0');
            var totalDaysInMonth = daysInMonth(month, year);

            var fromDate = month +'/'+ '01' +'/'+ year;
            var toDate = month +'/'+ totalDaysInMonth +'/'+ year;

            $('input[name="date_range"]').daterangepicker({
                minDate: fromDate,
                maxDate: toDate,
                startDate: fromDate,
                endDate: toDate,
            });
        });

    var selectedEmployeeIds = JSON.parse('{!! json_encode($employeeIds) !!}');

    function getEmployeeByType (select) {
        var employeeTypes = [];
        $(select).find(':selected').each(function (key, option) {
            employeeTypes.push($(option).val());
        })
        var url = "{{route('employees-by-type',['alias'=>$alias])}}?employee_type=" + employeeTypes;
        $.ajax({
            url: url,
            type: "GET",
            success: function(data) {
                var op = '';
                for (var i = 0; i < data.length; i++) {
                    op += '<option value="' + data[i].id + '"';

                    if (selectedEmployeeIds.includes((data[i].id).toString())) {
                        op += ' selected ';
                    }

                    op += ' >' + data[i].name + '(' + data[i]
                        .employee_code + ')</option>';
                }
                $('#employee_id').html(op).select2();
            }
        });
    }

    $('#employee_id, #employee_type').change(function () {
        selectedEmployeeIds = [];
        $('#employee_id').find(':selected').each(function (key, option) {
            selectedEmployeeIds.push($(option).val());
        })
    }); 

    </script>
@endpush