@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-4">
            <label class="font-weight-bolder text-success" for="filter_tanggal">
                <i class="fas fa-seedling" style="margin-right:5px; color:#28a745;"></i> tanggal
            </label>
            <input type="date" id="filter_tanggal" name="filter_tanggal" class="form-control border-success" value="{{ date('Y-m-d') }}">
            </div>
			<div class="col-md-4">
            <label class="font-weight-bolder text-success" for="filter_kebun">
                <i class="fas fa-seedling" style="margin-right:5px; color:#28a745;"></i> Kebun
            </label>
            <select name="filter_kebun" id="filter_kebun" class="form-control border-success">
              
            </select>
            </div>
            <div class="col-md-4">
            <label class="font-weight-bolder text-primary" for="filter_rayon">
                <i class="fas fa-map-marker-alt" style="margin-right:5px; color:#007bff;"></i> Rayon
            </label>
            <select name="filter_rayon" id="filter_rayon" class="form-control border-primary">
               
            </select>
            </div>
            <div class="col-md-4">
            <label class="font-weight-bolder text-warning" for="filter_kategori">
                <i class="fas fa-industry" style="margin-right:5px; color:#ffc107;"></i> Kategori
            </label>
            <select name="filter_kategori" id="filter_kategori" class="form-control border-warning">
				<option value="">Pilih Kategori</option>
				<option value="PC">PC</option>
				<option value="RC">RC</option>
            </select>
            </div>

            <div class="col-md-4">
            <label class="font-weight-bolder text-warning" for="filter_kategoripc">
                <i class="fas fa-industry" style="margin-right:5px; color:#ffc107;"></i> Kategori PC
            </label>
            <select name="filter_kategoripc" id="filter_kategoripc" class="form-control border-warning">
               <option value=""></option>
			   <option value="RATOON">RATOON</option>
			   <option value="PC MURNI / EX BERRO">PC MURNI / EX BERRO</option>
			   <option value="PC BONGKAR RATOON">PC BONGKAR RATOON</option>

            </select>
            </div>
			<div class="col-md-4">
            <label class="font-weight-bolder text-warning" for="">
                <i class="fas fa-industry" style="margin-right:5px; color:#ffc107;"></i> -
            </label>
			<br>
            <button class="btn btn-warning" id="btn_filter">
                <i class="fas fa-filter"></i> Filter
            </button>
			<button class="btn btn-success" id="btn_download_excel" style="margin-left:10px;">
				<i class="fas fa-file-excel"></i> Download Excel
			</button>
			
            </div>
        </div>
		<div >

	



		 <div class="table-responsive" 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() {
				$("#filter_kebun").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_kebun:kode_kebun:nama_kebun') !!}",
                                    {  initial_text : 'Pilih Kebun'});                    
				$("#filter_rayon").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_rayon:kode_rayon:nama_rayon&parent=kode_kebun:') !!}",
								{  initial_text : 'Pilih Rayon', parent: "#filter_kebun"}); 
				function fetchTable() {
					var tanggal = $('#filter_tanggal').val();
					var kebun = $('#filter_kebun').val();				
					var rayon = $('#filter_rayon').val();
					var kategori = $('#filter_kategori').val();
					var kategoripc = $('#filter_kategoripc').val();

					$.ajax({
						url: '{{ url("laporanrealpc/getTable") }}',
						type: 'GET',
						data: {
							tanggal: tanggal,
							kebun: kebun,
							rayon: rayon,
							kategori: kategori,
							kategoripc: kategoripc
						},
						headers: {
							'X-Requested-With': 'XMLHttpRequest'
						},
						success: function(html) {
							$('.table-responsive').html(html);
						}
					});
				}

				$('#btn_filter').on('click', function(e) {
					e.preventDefault();
					fetchTable();
				});

				// Optionally, fetch table on page load
				fetchTable();

				$('#btn_download_excel').on('click', function(e) {
						e.preventDefault();
						// Find the first table inside .table-responsive
						var table = $('.table-responsive table').get(0);
						if (!table) {
							alert('Data belum tersedia untuk diunduh.');
							return;
						}
						var wb = XLSX.utils.table_to_book(table, {sheet:"Sheet1"});
						XLSX.writeFile(wb, 'laporan_realpc.xlsx');
					});
			});

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