@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-6">
						<select name="filter_kebun" id="filter_kebun" class=" border-success"></select>
						<button type="button" class="btn btn-sm btn-success" onclick="loadTableData()">Get Data</button>
						<button type="button" class="btn btn-sm btn-primary" id="downloadExcelBtn">Download Excel</button>
						
				</div>    


			</div>
		<div >

	


		 {!! Form::open(array('url'=>'rekaptimbanganprognosa/delete/', 'class'=>'form-horizontal' ,'id' =>'SximoTable' )) !!}
		 <div class="table-responsive" id="gettable" style="height:500px;">
	    

		</div>
		{!! Form::close() !!}
		<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
						
		<script>
			  $(document).ready(function() {
			        $("#filter_kebun").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_kebun:kode_kebun:nama_kebun') !!}",
            {  initial_text : 'Pilih Kebun'});
			loadTableData();
			
		});

		function loadTableData() {
			$('#gettable').html('<div class="text-center py-5"><span class="spinner-border spinner-border-sm"></span> Loading...</div>');
			$.ajax({
				url: '{!! url("rekaptimbanganprognosa/getData") !!}?filter_kebun=' + $('#filter_kebun').val(),
				type: 'GET',
				success: function(response) {
					$('#gettable').html(response);
				},
				error: function(xhr) {
					$('#gettable').html('<div class="alert alert-danger">Gagal mengambil data.</div>');
				}
			});
		}
			</script>
			<script>
							$('#downloadExcelBtn').on('click', function() {
								var table = document.querySelector('#gettable table');
								if (!table) {
									alert('Data belum tersedia untuk diunduh.');
									return;
								}
								var wb = XLSX.utils.table_to_book(table, {sheet:"Sheet1"});
								XLSX.writeFile(wb, 'data.xlsx');
							});
						</script>
		@include('footer')
	</div>  
</div>
@stop