@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">
                    <form class="form-inline d-flex flex-wrap align-items-end gap-3">
							 @php
                            $tanggal_akhir = request('tanggal_akhir') ?? date('Y-m-d', strtotime('-1 day'));
                            $tanggal_awal = request('tanggal_awal') ?? date('Y-m-d', strtotime('-7 days'));
                        @endphp

                        <input type="date" class="form-control mb-2" id="tanggal_awal" name="tanggal_awal" value="{{ $tanggal_awal }}">
                        <input type="date" class="form-control mb-2" id="tanggal_akhir" name="tanggal_akhir" value="{{ $tanggal_akhir }}">

                        

                        <select class="form-control mb-2" id="kebun" name="kebun"></select>
						<select class="form-control mb-2" id="rayon" name="rayon"></select>

                        <select class="form-control mb-2" id="aff" name="aff">
                            <option value="">-- Pilih AFF --</option>
                            <option value="AFF" {{ request('aff') == 'aff' ? 'selected' : '' }}>AFF</option>
                            <option value="" {{ request('aff') == '' ? 'selected' : 'selected' }}>NON AFF</option>

                        </select>

                        <button type="submit" class="btn btn-primary mb-2">Filter</button>
                        <button type="button" class="btn btn-success mb-2" id="download-excel">Download Excel</button>    
						                    </form>
                </div>
			</div>
		<div >

	



		 <div class="table-responsive" id="gettable" style="min-height:300px;">
	    
		<input type="hidden" name="md" value="" />
		</div>
		    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
			
		<script>
		$(document).ready(function() {
			$("#kebun").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_kebun:kode_kebun:nama_kebun') !!}",
			{  initial_text : 'Pilih Kebun', selected_value : '{{ request('kebun') }}' });

			$("#rayon").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_rayon:kode_rayon:nama_rayon') !!}",
			{  initial_text : 'Pilih Rayon', selected_value : '{{ request('rayon') }}' });

			
			$('#send').click(function (e) { 
				e.preventDefault();
				loadTable();
			});

			loadTable();

			function loadTable() {
				var form = $('form').serialize();
				// Tampilkan loading
				$('#gettable').html('<div class="text-center my-5"><div class="spinner-border text-primary" role="status"><span class="visually-hidden">Loading...</span></div><div>Loading data...</div></div>');
				$.ajax({
					url : "{!! url('realisasiproduksipetakvstakmar/getTable') !!}",
					type: "GET",
					data: form,
					success: function(data)
					{
						$('#gettable').html(data);
					},
					error: function(jqXHR, textStatus, errorThrown)
					{
						$('#gettable').html('<div class="alert alert-danger">Error get data from ajax</div>');
					}
				});
			}

			$('#download-excel').click(function (e) { 
				e.preventDefault();
				var form = $('form').serialize();
				window.location.href = "{!! url('realisasiproduksipetakvstakmar/export?"+form+"') !!}";
			});

		});
		</script>		
		
		@include('footer')
	</div>  
</div>
@stop