@extends('member-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">Leave Report</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="{{url('')}}/member/{!! $alias !!}/home">Home</a>
                    </li>
                    <li class="breadcrumb-item active">Leave Report
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <!-- Filters -->
        <form action="{!! route('leave-report-member',['alias'=>$alias]) !!}" method="GET">
                
                <input type="hidden" id="organization_name" value="{{$organization->name}}">
            <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" for="area_id">Location</label>
                    <select class="form-control mb-2 select2" name="location_id[]" id="location_id" onchange="getsubLocations(this,'sublocations')" multiple>
                        <option value="">Select Location</option>
                        @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>
                        <option value="">Select Sub Location</option>
                        @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>
                        <option value="">Select Department</option>
                        @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>
                        <option value="">Select Sub Department</option>
                        @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>
                         <option value="">Select Designation</option>       
                        @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">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>
                    <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>
                        <option value="">Select Employee</option>
                        @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>
    <!-- // Filters // -->

    </form>
        <div class="row" id="table-responsive">
            <div class="col-12">
                <div class="card">
                   
                  <div class="card-body">
                  </div>

                    <div class="table-responsive">
                         <table class="table mb-0" id="organization">
                            <thead>
                                <tr>
                                    <th scope="col" class="text-nowrap">ID</th>
                                    <th scope="col" class="text-nowrap">Department</th>
                                    <th scope="col" class="text-nowrap">Designation</th>
                                    <th scope="col" class="text-nowrap">Employee Name</th>
                                    <th scope="col" class="text-nowrap">Employee Code</th>
                                    <th scope="col" class="text-nowrap">Type of Leave</th>
                                    <th scope="col" class="text-nowrap">Total Leave</th>
                                    <th scope="col" class="text-nowrap">Applied  Leave</th>
                                    <th scope="col" class="text-nowrap">Approved Leave </th>
                                    <th scope="col" class="text-nowrap">Pending Leave</th>
                                    <th scope="col" class="text-nowrap">Balance Leave</th>
                                    <th scope="col" class="text-nowrap">Lapsed Leave</th>
                                </tr>
                            </thead>
                        <tbody>
                            @foreach($dataArr as $value)
                                @foreach($value['leaves'] as $leave)
                                    <tr>
                                        <td>{{$loop->iteration}}</td>
                                        <td class="text-nowrap"><strong>{{$value['department_name']}}</strong></td>
                                        <td class="text-nowrap"><strong>{{$value['designation_name']}}</strong></td>
                                        <td class="text-nowrap">{{$value['employee_name']}}</td>
                                        <td class="text-nowrap">{{$value['employee_code']}}</td>
                                        <td class="text-nowrap">{{$leave['name']}}</td>
                                        <td class="text-nowrap">{{$leave['total']}}</td>
                                        <td class="text-nowrap">{{$leave['applied']}}</td>
                                        <td class="text-nowrap">{{$leave['approved']}}</td>
                                        <td class="text-nowrap">{{$leave['pending']}}</td>
                                        <td class="text-nowrap">{{$leave['balance']}}</td>
                                        <td class="text-nowrap">{{$leave['lapsed']}}</td>
                                    </tr>
                                @endforeach
                            @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 src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>
    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
<script>
var subLocations = $('#sublocation_selected_id').val(); 
$(document).ready(function() {
        $('#location_id').show();
        $('#location_id').select2();
        $('#sub_location_id').show();
        $('#sub_location_id').select2();
        $('#department_id').show();
        $('#department_id').select2();
        $('#sub_department_id').show();
        $('#sub_department_id').select2();
        $('#designation_id').show();
        $('#designation_id').select2();
        $('#employee_id').show();
        $('#employee_id').select2();
        $('#manager_id').show();
        $('#manager_id').select2();
        $('#contractor_id').show();
        $('#contractor_id').select2();

    if ($('#location_id').val()) {
        getsubLocations();
    } 

    });

    $(document).ready(function () { 
            $("#searchbox").hide(); 
            $(".filterbutton").click(function() {
                $("#searchbox").slideToggle('slow'); 
            });     
    });

    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--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>
<style type="text/css">
.dt-buttons 
    {
    padding-left: 10px;
    }
div.dataTables_wrapper div.dataTables_filter input 
   {
    margin-left: -13.25rem;
   }
div.dataTables_wrapper .dataTables_info 
   {
    padding-left: 10px;
   }
</style>
<script>
$(document).ready(function() {
  
    $('#organization').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 me-2',
                      text: feather.icons['share'].toSvg({ class: 'font-small-4 me-50' }) + "{{trans('manager/manager.export')}}",
                      buttons: [
                          {
                              extend: 'print',
                              {{--filename: '{{$organization->name}}, {{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                              title: '{{$organization->name}} - {{ date("d-m-Y H-i-s") }}',--}}
                              text: feather.icons['printer'].toSvg({ class: 'font-small-4 me-50' }) + 'Print',
                              className: 'dropdown-item',
                              exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                          },
                          {
                              extend: 'csv',
                              {{--filename: '{{$organization->name}}, {{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                              title: '{{$organization->name}} - {{ date("d-m-Y H-i-s") }}',--}}
                              text: feather.icons['file-text'].toSvg({ class: 'font-small-4 me-50' }) + 'Csv',
                              className: 'dropdown-item',
                              exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                          },
                          {
                              extend: 'excel',
                             {{-- filename: '{{$organization->name}}, {{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                              title: '{{$organization->name}} - {{ date("d-m-Y H-i-s") }}',--}}
                              text: feather.icons['file'].toSvg({ class: 'font-small-4 me-50' }) + 'Excel',
                              className: 'dropdown-item',
                              exportOptions: { columns: Array.from(Array($("#organization th").length).keys()) },
                          },
                          {
                              extend: 'pdf',
                             {{-- filename: '{{$organization->name}} - {{ date("d-m-Y H-i-s") }}',
                              title: '{{$organization->name}} - {{ date("d-m-Y H-i-s") }}',--}}
                              text: feather.icons['clipboard'].toSvg({ class: 'font-small-4 me-50' }) + 'Pdf',
                              className: 'dropdown-item',
                              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: '{{$organization->name}} {{$title}}, {{Auth::user()->name}} - {{ date("d-m-Y H-i-s") }}',
                              title: '{{$organization->name}} {{$title}} - {{ date("d-m-Y H-i-s") }}',--}}
                              text: feather.icons['copy'].toSvg({ class: 'font-small-4 me-50' }) + '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);
                      }
                      }
                      
                  ],
    } );
    $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });  
  } );
</script>
@endpush