@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 

@push('content-header')
<div class="row breadcrumbs-top">
    <div class="col-12">
        <h2 class="content-header-title float-start mb-0">{{trans('master/master.overTime_monthly_actual_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">{{trans('master/master.overTime_monthly_actual_report')}}
                </li>
            </ol>
        </div>
    </div>
</div>
@endpush
@section('content')
    <!-- Column Search -->
    <form action="{!! route('overtime-monthly-actual-report',['alias'=>$alias]) !!}" method="GET">
        <section id="column-search-datatable">
            {{-- <input type="hidden" name="_token" value="{{ csrf_token() }}" /> --}}
            <input type="hidden" id="filename" value="{{$organization->name}} {{trans('master/master.overTime_monthly_actual_report')}}">
            <input type="hidden" id="organization_name" value="{{$organization->name}}">
            <input type="hidden" id="state" value="{{$state}}">
            <input type="hidden" id="sublocation_selected_id" value="{{json_encode($subLocationIds)}}">
                
            <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">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" >Type</label>
                            <select class="form-control mb-2 select2" name="type" id="ot-type">
                                <option value="monthly" @if(($type == 'monthly') || (old('type') == $type)) selected @endif>Monthly</option>
                                <option value="quarterly" @if(($type == 'quarterly') || (old('type') == $type)) selected @endif>Quarterly</option>
                            </select>
                        <div class="ot-months @if($type == 'quarterly') display-nonebox @endif ">
                            <label class="form-label mt-2">Month</label>
                            <select class="form-control ot-months-list  select2" name="month_id" id="month_id" @if($type == 'quarterly') disabled @endif">
                                @foreach ($month as $mkey=>$monthitem)
                                    <option value="{{$mkey}}" @if(($mkey == $month_id) || (old('month_id') == $mkey)) selected @endif>{{$monthitem}}</option>
                                @endforeach
                                
                            </select>
                        </div>
                        <div class="ot-quarter  @if($type == 'monthly') display-nonebox @endif "">
                            <label class="form-label mt-2" for="area_id">Quarter</label>
                            <select class="form-control ot-quarter-list mb-2 select2" name="month_id" id="month_id"  @if($type == 'monthly') disabled @endif ">
                                <option value="">Select</option>
                                @foreach ($quarters as $quarter)
                                <option value="{{$quarter['month_ids']}}" @if($quarter['month_ids'] == $month_id) selected @endif>{{$quarter['title']}}</option>
                                @endforeach
                            </select>
                        </div>
                        <label class="form-label mt-2" for="area_id">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="area_id">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">Sub Location</label>
                        <select class="form-control mb-2 select2" name="sub_location_id[]" id="sub_location_id" multiple>
                           @foreach($subLocations as $subLocation)
                               <option value="{{$subLocation->id}}" @if( ($subLocationIds) && in_array($subLocation->id, $subLocationIds)) selected @endif>{{$subLocation->name}}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">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">Sub Department</label>
                        <select class="form-control mb-2 select2" name="sub_department_id[]" id="sub_department_id" multiple>
                           @foreach($subDepartments as $subDepartment)
                                <option value="{{$subDepartment->id}}" @if( ($subDepartmentIds) && in_array($subDepartment->id, $subDepartmentIds)) selected @endif>{{$subDepartment->name}}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">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">Manager</label>
                        <select class="form-control mb-2 select2" name="manager_id[]" id="manager_id" multiple>
                            @foreach($managers as $manager)
                                    <option value="{{$manager->id}}" @if( ($managerIds) && in_array($manager->id, $managerIds)) selected @endif>{{$manager->name}}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">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( ($contractorIds) && in_array($contractor->id, $contractorIds)) selected @endif>{{$contractor->name}}</option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">Employee Type</label>
                        <select class="form-control mb-2 select2" name="employee_type" id="employee_type" onchange="getEmployeeByType(this.value)">
                                <option value="">Select Type</option>
                                @foreach($employeeTypes as $empType)
                                    <option value="{{$empType}}" @if( $empType == $employeeTypeSelected)) selected @endif>
                                        {{ucwords($empType)}}
                                    </option>
                                @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">Employees</label>
                        <select class="form-control mb-2 select2" name="employee_id[]" id="employee_id" multiple>
                            @foreach($employees as $employee)
                                <option value="{{$employee->id}}" @if( ($employeeIds) && in_array($employee->id, $employeeIds)) selected @endif>
                                    {{$employee->name}}({{$employee->employee_code}})
                                </option>
                            @endforeach
                        </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> Search</button>
                    </div>
                </div>
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-datatable">
                                <table class="dt-column-search table table-responsive" id="organization">
                                    <thead>
                                        <tr>
                                            <th scope="col" class="text-nowrap">S No.</th>
                                            <th scope="col" class="text-nowrap">{{trans('master/master.employee_code')}}</th>
                                            <th scope="col" class="text-nowrap">{{trans('master/master.employee_name')}}</th>
                                            <th scope="col" class="text-nowrap">{{trans('master/master.manager')}} {{trans('master/master.name')}}</th>
                                            <th scope="col" class="text-nowrap">{{trans('master/master.department')}}</th>
                                           
                                            <th scope="col" class="text-nowrap">{{trans('master/master.working_hours')}}</th>
                                            <th scope="col" class="text-nowrap">{{trans('master/master.actual_ot_hours')}}</th>
                                            <th scope="col" class="text-nowrap">{{trans('master/master.approved_ot_hours')}}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach($dataArr as $value)
                                        @php 
                                            $actualOvertimeBg = $approvedOvertimeBg =  '';
                                            if($maxOvertimeHour != -1){
                                                if($value->actual_overtime >= $maxOvertimeHour){
                                                    $actualOvertimeBg = 'overtime-bg-red';
                                                }
                                                
                                                if($value->total_overtime >= $maxOvertimeHour){
                                                    $approvedOvertimeBg = 'overtime-bg-red';
                                                }
                                            }
                                        @endphp
                                        <tr>
                                            <td class="text-nowrap">{{ $loop->iteration }}</td>
                                            <td class="text-nowrap"><strong>{{$value->employee_code}}</strong></td>
                                            <td class="text-nowrap">{{$value->name}}</td>
                                            <td class="text-nowrap">{{@$value->employee->manager->name}}</td>
                                            <td class="text-nowrap">{{@$value->employee->department->name}}</td>
                                            
                                            <td class="text-nowrap">@if($value->total_working_time){{number_format($value->total_working_time,2,'.','')}}@else 0.00 @endif</td>
                                            <td  class="text-nowrap "><span class="otspan {{$actualOvertimeBg}}">@if($value->actual_overtime){{number_format($value->actual_overtime,2,'.','')}}@else 0.00 @endif </span></td>
                                            <td class="text-nowrap "><span class="otspan {{$approvedOvertimeBg}}">@if($value->total_overtime){{number_format($value->total_overtime,2,'.','')}} @else 0.00  @endif</span></td>
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </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/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>


    <!-- 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(); 
        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({
                dom: '<"card-header border-bottom p-1"<"head-label"><"dt-action-buttons text-end"B>><"d-flex justify-content-between align-items-center mx-0 row"<"col-sm-12 col-md-6"l><"col-sm-12 col-md-6"f>>t<"d-flex justify-content-between mx-0 row"<"col-sm-12 col-md-6"i><"col-sm-12 col-md-6"p>>',
                orderCellsTop: true,
                language: {
                    paginate: {
                    // remove previous & next text from pagination
                    previous: '&nbsp;',
                    next: '&nbsp;'
                    }
                },
                
                buttons: [
                    {
                    text: feather.icons['file'].toSvg({ class: 'me-50 font-small-4' }) + '{{trans("common/common.export_to_excel")}}',
                    className: 'create-new btn btn-outline-secondary ',
                    attr: {
                        'onclick':"document.location.href='/{!! $alias !!}/overtime/monthly-actual-report-export?{!!request()->getQueryString()!!}';"
                        
                    },
                    init: function (api, node, config) {
                        $(node).removeClass('btn-secondary');
                    }
                    }
                ],
                
               
            
            });
            }

            $('div.head-label').html('<h6 class="mb-0">{{trans("master/master.overTime_monthly_actual_report")}}  @if($state==1)({{isset($organization->address) ? $organization->address->state->name: ''}})@endif</h6>');
        };

        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });
        $(document).ready(function(){
            if ($('#location_id').val()) {
                getsubLocations();
            }
            callDt();
        })

        function getsubLocations(th) {
            var locationId = $('#location_id').val();
            
            var subLocationId = "";

            var data = {
                location_id: locationId,
                '_token': '{{{csrf_token()}}}'
            }
            $.ajax({
                url: '/{!! $alias !!}/location/sub-locations',
                type: 'POST',
                data: data,
                success: function(data) {
                    var selectbox = '';
                    if (data) {
                        selectbox = '<label for="sub_location_id">Sub Location</label>';
                        selectbox += '<div class="form-label-group"><select name="sub_location_id[]" class="form-control select2" id="sub_location_id" multiple>';
                        $.each(data, function(i, item) {
                            if (subLocations.includes(i)) {
                                selectbox += '<option value="' + i + '" selected="selected">' + item + '</option>';
                            } else {
                                selectbox += '<option value="' + i + '">' + item + '</option>';
                            }
                        });
                        selectbox += '</select></div>';
                    }
                    $('#sub_location_id').html(selectbox);
                    $("#sub_location_id").select2({
                        multiple: true
                    });
                }
            });
            
        }
        
        function getEmployeeByType (employee_type) {
            var url = "{!! route('employees-by-type',['alias'=>$alias]) !!}?employee_type=" + employee_type;
            $.ajax({
                url: url,
                type: "GET",
                success: function (data) {
                    op = '';
                    for (var i = 0; i < data.length; i++){
                        op += '<option value="'+data[i].id+'">'+data[i].name+'('+data[i].employee_code+')</option>';
                    }
                    $('#employee_id').html(op);
                }
            });

        }
    </script>

<script>
    $(document).ready(function(){
        $('#ot-type').on('change', function(){
            var type = $(this).val(); 
            if(type=='monthly'){
                $(".ot-months").removeClass('display-nonebox');
                $('.ot-months-list').prop('disabled', false);
                $('.ot-months-list').prop('disabled', false);
                $(".ot-quarter").addClass('display-nonebox');
                $('.ot-quarter-list').prop('disabled', true);
            }else{
                $(".ot-months").addClass('display-nonebox');
                $('.ot-months-list').prop('disabled', true);
                $(".ot-quarter").removeClass('display-nonebox');
                $('.ot-quarter-list').prop('disabled', false);
            }
        });
    });
    </script> 
    
    
@endpush