@extends('layouts.frontend')
@section('content')
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-12">
            
            <div class="card">
                <div class="card-header">
                    Cost Analysis Report
                </div>

                <div class="card-body">
                	<div class="row" style="margin-bottom:15px;">
		            <div class="col-md-10">
		            <form action="" id="filtersForm">
		                <div class="input-group">
		                <input type="text" name="from_date" class="form-control mr-2 date" id="date_filter" placeholder="From date">
		                <input type="text" name="to_date" class="form-control mr-2 date" id="date_filter" placeholder="To date">
		                
		                <select class="search" style="margin-right:10px;" name="emp_id">
	                            <option value>Select Employee</option>
	                            @foreach($employees as $key => $item)
	                                <option value="{{ $item->id }}">{{ $item->name }}</option>
	                            @endforeach
	                        </select>
		                <span class="input-group-btn">
		                    <input type="submit" class="btn btn-primary" value="Filter">
		                </span> 
		                </div>
		            </form>
		            </div>
		        </div>
                	
                    <div class="table-responsive">
                    	    
                        <table class=" table table-bordered table-striped table-hover datatable datatable-MealRequest" border=1>
                            <thead>
                                <tr>                                                                                                                                                		                    
		                    <th>
		                        
		                    </th>
		                    <th>
		                       
		                    </th>
		                    @foreach($columns as $key => $item)
			                    <th colspan=4 style="text-align:center;">
			                       {{$key}}
			                    </th>
			            @endforeach
			            <th>
		                        
		                    </th>
		                    <th>
		                        
		                    </th>
		                    <th>
		                        
		                    </th>
		                    <th>
		                        
		                    </th>
		                    <th>
		                        
		                    </th>
			           		                    
                                </tr>
                                <tr>
                                   <th>
		                        {{ trans('cruds.mealRequest.fields.employee_name') }}
		                    </th>
		                    <th>
		                        {{ trans('cruds.employeeManagement.fields.employee_no') }}
		                    </th>
                                   @foreach($columns as $key => $item)
                                   	
	                                   	@foreach($item as $temp)
				                    <th>
				                       {{$temp}}
				                    </th>
				                @endforeach				        
				   @endforeach
				            
			             <th>
			            Total Meal Qty
			            </th>
			            <th>
		                    	Total Employeee Contribution
		                    </th>
		                    <th>
		                    	Total Company Contribution
		                    </th>
		                    <th>
		                    	Total Amount
		                    </th>
		                    <th>
		                    	Sign
		                    </th>
                                </tr>                                                                
                            </thead>
                            <tbody>
                                @foreach($data as $key => $mealRequest)
                                    <tr height="10px">
                                    	@foreach ($mealRequest as $key => $value)
                                    		<td>
    							{{ ($value) ?? 0 }}
    						</td>
					@endforeach                                                                                               
                                    	                                    	
                                        <td style="width:25px;">
                                        </td>                                                                                

                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
@endsection
@section('scripts')
@parent

<script>
    $(function () {
  let dtButtons = $.extend(true, [], $.fn.dataTable.defaults.buttons)
@can('meal_request_delete')
  let deleteButtonTrans = '{{ trans('global.datatables.delete') }}'
  let deleteButton = {
    text: deleteButtonTrans,
    url: "{{ route('frontend.meal-requests.massDestroy') }}",
    className: 'btn-danger',
    action: function (e, dt, node, config) {
      var ids = $.map(dt.rows({ selected: true }).nodes(), function (entry) {
          return $(entry).data('entry-id')
      });

      if (ids.length === 0) {
        alert('{{ trans('global.datatables.zero_selected') }}')

        return
      }

      if (confirm('{{ trans('global.areYouSure') }}')) {
        $.ajax({
          headers: {'x-csrf-token': _token},
          method: 'POST',
          url: config.url,
          data: { ids: ids, _method: 'DELETE' }})
          .done(function () { location.reload() })
      }
    }
  }
  dtButtons.push(deleteButton)
@endcan

  $.extend(true, $.fn.dataTable.defaults, {
    orderCellsTop: true,      
    order: [[ 1, 'desc' ]],
    pageLength: 1000,
  });
  let table = $('.datatable-MealRequest:not(.ajaxTable)').DataTable({ buttons: dtButtons })
  $('a[data-toggle="tab"]').on('shown.bs.tab click', function(e){
      $($.fn.dataTable.tables(true)).DataTable()
          .columns.adjust();
  });
  
let visibleColumnsIndexes = null;
$('.datatable thead').on('input', '.search', function () {
      let strict = $(this).attr('strict') || false
      let value = strict && this.value ? "^" + this.value + "$" : this.value

      let index = $(this).parent().index()
      if (visibleColumnsIndexes !== null) {
        index = visibleColumnsIndexes[index]
      }

      table
        .column(index)
        .search(value, strict)
        .draw()
  });
table.on('column-visibility.dt', function(e, settings, column, state) {
      visibleColumnsIndexes = []
      table.columns(":visible").every(function(colIdx) {
          visibleColumnsIndexes.push(colIdx);
      });
  })
})

</script>

@endsection