@extends('layouts.app')

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

				<div class="col-md-12 text-right">
					{!! Form::open(['url' => $pageModule . '', 'method' => 'get', 'class' => 'form-inline', 'id' => 'filterForm']) !!}
						<div class="form-group">
							<label for="start_date">Tanggal Awal:</label>
							<input type="date" name="start_date" id="start_date" class="form-sm-control mx-sm-2" value="{{ request('start_date') }}">
						</div>
						<div class="form-group">
							<label for="end_date">Tanggal Akhir:</label>
							<input type="date" name="end_date" id="end_date" class="form-sm-control mx-sm-2" value="{{ request('end_date') }}">
						</div>
						<button type="submit" class="btn btn-sm btn-primary">Filter</button>
						<button id="downloadExcel" type="button" class="btn btn-sm btn-success">Download Excel</button>

					
					{!! Form::close() !!}
				</div>
			</div>
		<div >

	



		 <div class="table-responsive" style="min-height:300px;">
	    <table id="dataTable" class="table table-hover table-striped  ">
	        <thead>
				<tr>
					<th class="number"> No </th>			
					<th> Nama Cluster </th>
					<th> Nama Kebun </th>
					<th> Nama Rayon </th>
					<th> Ha Tebang </th>
					<th> Netto Ton </th>
					<th> Protas </th>
				  </tr>
	        </thead>

	        <tbody>
							
			@php $i = 0; @endphp
					@foreach ($rekapData as $row)
						<tr>
							<td>{{ ++$i }}</td>
							<td>{{ $row->nama_cluster }}</td>
							<td>{{ $row->nama_kebun }}</td>
							<td>{{ $row->nama_rayon }}</td>
							<td>{{ $row->ha_tebang }}</td>
							<td>{{ $row->netto_ton }}</td>
							<td>{{ $row->protas }}</td>
							

						</tr>
					@endforeach
	        </tbody>
	      
	    </table>
		<input type="hidden" name="md" value="" />
		</div>

		
	
	</div>  
</div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script>
	document.getElementById('downloadExcel').addEventListener('click', function () {
		// Ambil tabel
		var table = document.getElementById('dataTable');
		var workbook = XLSX.utils.table_to_book(table, { sheet: "Sheet1" });

		// Unduh file Excel
		XLSX.writeFile(workbook, 'rekap_data.xlsx');
	});

					</script>
@stop