@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/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_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_report')}}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <!-- Filters -->
        <form action="{{ route('overtime-masters.report',['slug'=>$alias]) }}" method="POST">
            <input type="hidden" name="_token" value="{{ csrf_token() }}" />
            <input type="hidden" id="filename" value="overtime-report">
            <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" for="name">{{trans('master/master.date_range')}}</label>
                        <input type="text" id="date_range" name="date_range" class="form-control" value="{{$date_range}}"/>

                        <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">{{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(isset($departmentSelected) && (in_array($department->id, $departmentSelected))) 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(isset($designationSelected) && (in_array($designation->id, $designationSelected))) 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">{{trans('master/master.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) || (old('employee_type') == $empType)) selected @endif>
                                        {{ucwords($empType)}}
                                    </option>
                                @endforeach
                        </select>
                        <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>
                            @foreach($employees as $employee)
                                    <option value="{{$employee->id}}" @if(isset($employeeSelected) && (in_array($employee->id, $employeeSelected))) 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> {{trans('common/common.search')}}</button>
                    </div>
                </div>
            </div>
    <!-- // Filters // -->

        </form>
        <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">{{trans('common/common.id')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('master/master.employee_name')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('master/master.employee_code')}}e</th>
                                    <th scope="col" class="text-nowrap">{{trans('master/master.employee_type')}}</th>
                                    <th scope="col" class="text-nowrap" style="display:none" >{{trans('master/master.manager')}} {{trans('master/master.name')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('master/master.contractor')}} {{trans('master/master.name')}}</th>
                                    <th  scope="col" class="text-nowrap" style="display:none" >{{trans('employee/employee.location')}}</th>
                                    <th  scope="col" class="text-nowrap" style="display:none" >{{trans('employee/employee.sub_location')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('attendance/admin.attendance_date')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('attendance/admin.punch_in')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('attendance/admin.punch_out')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('attendance/admin.working_norms')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('attendance/admin.working_hours')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('master/master.actual_overtime')}}</th>
                                    <th scope="col" class="text-nowrap">{{trans('master/master.approved_overtime')}}</th>
                                    
                                </tr>
                            </thead>
                            <tbody>
                                                                @foreach($data as $value)
                               
                                <tr>
                                    <td class="text-nowrap">{{ $count++ }}</td>
                                    <td class="text-nowrap">@if($value->employee) {{$value->employee->name}} @endif </td>
                                    <td class="text-nowrap">@if($value->employee) {{$value->employee->employee_code}} @endif</td>
                                    <td class="text-nowrap">@if($value->employee) {{ucfirst($value->employee->employee_type)}} @endif</td>
                                    <td class="text-nowrap" style="display:none">@if($value->employee && $value->employee->manager) {{$value->employee->manager->name}} @endif </td>
                                    <td class="text-nowrap">@if($value->employee && $value->employee->contractor) {{$value->employee->contractor->name}} @endif </td>
                                    <td class="text-nowrap" style="display:none">
                                        @if($value->employee && $value->employee->locations) 
                                            @foreach ($value->employee->locations as $emplocation)
                                            {{$emplocation->name}}
                                                @if (!$loop->last) , @endif
                                            @endforeach
                                         @endif</td>
                                    <td class="text-nowrap" style="display:none">
                                        @if($value->employee && $value->employee->subLocations) 
                                            @foreach ($value->employee->subLocations as $empSubLocation)
                                                {{$empSubLocation->name}}
                                                @if (!$loop->last) , @endif
                                            @endforeach
                                         @endif</td>
                                    </td>

                                    <td class="text-nowrap">{{$value->attendance_date}}</td>
                                    <td class="text-nowrap">{{$value->in_time}}</td>
                                    <td class="text-nowrap">{{$value->out_time}}</td>
                                    <td class="text-nowrap">@if($value->employee && $value->employee->organization){{$value->employee->organization->working_hour}}@endif</td>
                                    <td class="text-nowrap">{{$value->working_time}}</td>
                                    <td class="text-nowrap">{{($value->actual_overtime)? $value->actual_overtime : '00.00.00'}}</td>
                                    <td class="text-nowrap">{{($value->overtime)? $value->overtime : '00:00:00'}}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </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 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" />

    <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>
    <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>
    $(document).ready(function() {
        callDt();
    });
    
    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: [{
                extend: 'collection',
                className: 'btn btn-outline-secondary dropdown-toggle',
                text: feather.icons['share'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('common/common.export')}}",
                buttons: [
                    {
                        extend: 'print',
                        filename: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        title: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        text: feather.icons['printer'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('common/common.print')}}",
                        className: 'dropdown-item',
                        exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                    },
                    {
                        extend: 'csv',
                        filename: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        title: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        text: feather.icons['file-text'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('common/common.csv')}}",
                        className: 'dropdown-item',
                        exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                    },
                    {
                        extend: 'excel',
                        filename: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        title: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        text: feather.icons['file'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('common/common.excel')}}",
                        className: 'dropdown-item',
                        exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                    },
                    {
                        extend: 'pdf',
                        filename: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        title: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        text: feather.icons['clipboard'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('common/common.pdf')}}",
                        className: 'dropdown-item',
                        orientation : 'landscape',
                        exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                            customize: function(doc) {
                                doc['footer']=(function() {
                                    return {
                                        columns: [
                                            {
                                                alignment: 'center',
                                                text: ['Downloaded by: ', { text: '{{Auth::user()->name}}' }, ' on {{ date("d-m-Y") }} at {{ date("g:i A") }}']
                                            }
                                        ],
                                        margin: 10
                                    }
                                }); 
                            },
                        },
                    {
                        extend: 'copy',
                        filename: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        title: '{{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                        text: feather.icons['copy'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('common/common.copy')}}",
                        className: 'dropdown-item',
                        exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) }
                    }
                ],
                init: function (api, node, config) {
                    $(node).removeClass('btn-secondary');
                    $(node).parent().removeClass('btn-group');
                    setTimeout(function () {
                    $(node).closest('.dt-buttons').removeClass('btn-group').addClass('d-inline-flex');
                    }, 50);
                }
                },
            ],
        
        });
        }

        $('div.head-label').html('<h6 class="mb-0">{{trans("master/master.overtime_report")}} {{trans("master/master.listing")}}</h6>');
    };

    $(function() {
        var filterFromdate = "{{$filterFromdate}}";
        var filterTodate = "{{$filterTodate}}";
        $('input[name="date_range"]').daterangepicker({
            timePicker: false,
            opens: 'left',
            startDate: moment(filterFromdate).format('MM/DD/YYYY'),
            endDate:  moment(filterTodate).format('MM/DD/YYYY'),
            locale: {
                format: 'MM/DD/YYYY'
            }
        }, function(start, end, label) {
            console.log("A new date selection was made: " + start.startOf('month').format('YYYY-MM-DD') + ' to ' + end.endOf('month').format('YYYY-MM-DD'));
        });
    });
    function getEmployeeByType (employee_type) {
        var url = "{{route('employees-by-type',['alias'=>$alias])}}?employee_type=" + employee_type;
        $.easyAjax({
            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>
@endpush