@extends('layouts.app')

@section('content')
{{--*/ usort($tableGrid, "SiteHelpers::_sort") /*--}}
<div class="page-titles">
  <h2> {{ $pageTitle }} <small> {{ $pageNote }} </small></h2>
</div>

<div class="toolbar-nav">
<form method="GET" action="">
	<div class="row">
		<div class="col-md-6">
			<input type="text" name="tanggal_range" class="form-control form-control-sm" id="tanggal_range" placeholder="Select date range" value="{{ request('tanggal_range') }}">
		</div>
		<div class="col-md-2">
			<button class="btn btn-sm btn-primary" type="submit">Filter</button>
		</div>
		<div class="col-md-2">
			<a href="{{ url()->current() }}?download=1{{ request('tanggal_range') ? '&tanggal_range=' . urlencode(request('tanggal_range')) : '' }}" class="btn btn-sm btn-success">
				Download
			</a>
		</div>
	</div>
	<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
	<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/moment@2.29.4/moment.min.js"></script>
	<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
	<script>
	document.addEventListener("DOMContentLoaded", function() {
		if (window.$ && $.fn.daterangepicker) {
			$('#tanggal_range').daterangepicker({
				locale: { format: 'YYYY-MM-DD' },
				autoUpdateInput: false,
				maxSpan: { days: 7 }
			});
			$('#tanggal_range').on('apply.daterangepicker', function(ev, picker) {
				$(this).val(picker.startDate.format('YYYY-MM-DD') + ' - ' + picker.endDate.format('YYYY-MM-DD'));
			});
			$('#tanggal_range').on('cancel.daterangepicker', function(ev, picker) {
				$(this).val('');
			});
		}
	});
	</script>
</form>


  
</div>

<div  class="card">
	<div class="card-body">
		<div class="toolbar-nav">
			<div class="row">
				<div class="col-md-6">
						
				</div>    
			</div>
		<div >

	


		 {!! Form::open(array('url'=>'consolespreadsheet/delete/', 'class'=>'form-horizontal' ,'id' =>'SximoTable' )) !!}
		 <div class="table-responsive" style="height:400px;">
	    <table class="table table-hover table-striped  ">
	        <thead style="position: sticky; top: 0; background-color: #fff; z-index: 1;">>
				<tr>
					<th class="number"> No </th>			
					@foreach ($tableGrid as $t)
						@if($t['view'] =='1')
							<th>{{ $t['label'] }}</th>
						@endif
					@endforeach
				  </tr>
	        </thead>

	        <tbody>
							
	            @foreach ($rowData as $row)
	                <tr>
						<td width="30"> {{ ++$i }} </td>	
					@foreach ($tableGrid as $field)
						 @if($field['view'] =='1')
						 	<?php $limited = isset($field['limited']) ? $field['limited'] :''; ?>
						 	@if(SiteHelpers::filterColumn($limited ))
							 <td>					 
							 	{!! SiteHelpers::formatRows($row->{$field['field']},$field ,$row ) !!}						 
							 </td>
							@endif	
						 @endif					 
					 @endforeach				 
					
	                </tr>
					
	            @endforeach
	              
	        </tbody>
	      
	    </table>
		<input type="hidden" name="md" value="" />
		</div>
		{!! Form::close() !!}
		
		
		@include('footer')
	</div>  
</div>
@stop