@extends('layouts.app')
<style>
	.dataTables_length, .dataTables_filter {
		display: inherit !important;
	}
	th {
		background: #FFF !important;
	}
</style>
@section('content')
<?php usort($tableGrid, "SiteHelpers::_sort"); ?>
<div class="page-titles">
  <h2> {{ $pageTitle }} <small> {{ $pageNote }} </small></h2>
</div>


	<div id="distribusipupukView"></div>	
	<div id="distribusipupukGrid">
		<div class="card">
			<div class="card-body">
			@include( $pageModule.'/toolbar')
			
		
			<div class="table-responsive">			
				<table id="distribusipupukTable" class="display table  table-striped table-hover" cellspacing="0" width="100%">
			        <thead>
			            <tr>
			            	<th>ID</th>	
			            	
			            @if($setting['view-method'] =='expand')<th></th>@endif
			           

			            
		            <?php foreach ($tableGrid as $t) :
						if($t['view'] =='1'):
							$limited = isset($t['limited']) ? $t['limited'] :'';
							if(SiteHelpers::filterColumn($limited ))
							{
								echo '<th align="'.$t['align'].'" width="'.$t['width'].'">'.\SiteHelpers::activeLang($t['label'],(isset($t['language'])? $t['language'] : array())).'</th>';				
							} 
						endif;
					endforeach; ?>
							 <th width="30" class="text-right" > Action </th>
						</tr>

					</thead>	
			               
			    </table>
			</div>	 
		</div>			
	</div>	
	</div>
	
</div>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
		<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
		<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>
		<script src="https://cdn.datatables.net/fixedcolumns/4.3.0/js/dataTables.fixedColumns.min.js"></script>
<script type="text/javascript">
	var table;
	$(document).ready(function() {
		$("#barang").jCombo("{!! url('distribusipupuk/comboselect?filter=m_pupuk_herbisida:id:nama&parent=area') !!}",{initial_text:'Pilih Barang'});
		
		$("#area").jCombo("{!! url('distribusipupuk/comboselect?filter=m_area_kebun:kode_area:nama_area&parent=unit:') !!}{!! session('fid') !!}",{initial_text:'Pilih Gudang'});
		
		$("#petak").jCombo("{!! url('distribusipupuk/comboselect?filter=master_petak:lahan_id:lahan_id|nama_kebun|tahun_tana') !!}",{initial_text:'Pilih Petak'});
		 

		var parexcel = $("#export_excel").attr('href');
		$("#export_excel").attr('href',parexcel+'&search=tanggal:like:{{ date("Y-m-d") }}');

		$('.tips').tooltip();
		$('.dataselect').select2();
		var rows_selected = []; 			
		table = $('#distribusipupukTable').DataTable( {
			"processing": true,
			"serverSide": true,
			"lengthMenu": [[10, 25, 50, 100, 200, 500], [10, 25, 50, 100, 200, 500]],
			"ajax": {
				"url": "{!! url('distribusipupuk')!!}",
				"type": "POST",
				"data": function(d){
					d['barang'] = $("#barang").val();
					d['area'] = $("#area").val();
					d['petak'] = $("#petak").val();
					d['tanggal'] = $("#tanggal").val();
					d['no_dok'] = $("#no_dok").val();
				}
			},
			"columnDefs": [{ 
				"targets": [0],
				"visible": false,
				orderable: false,
				className: 'select-checkbox'
			},
			{
				"targets": 1, // kolom ke-3 (index mulai dari 0)
				"createdCell": function(td, cellData, rowData, row, col) {
					$(td).css('background-color', '#ffeeba'); // ganti warna sesuai kebutuhan
				}
			},{
				"targets": 2, // kolom ke-3 (index mulai dari 0)
				"createdCell": function(td, cellData, rowData, row, col) {
					$(td).css('background-color', '#ffeeba'); // ganti warna sesuai kebutuhan
				}
			},{
				"targets": 3, // kolom ke-3 (index mulai dari 0)
				"createdCell": function(td, cellData, rowData, row, col) {
					$(td).css('background-color', '#ffeeba'); // ganti warna sesuai kebutuhan
				}
			}],
			"columns": [<?php echo $column;?>],
			'order': [[1, 'asc']],
			dom: 'Bfltip',
			buttons: [
				{
					extend: 'excel',
					text: 'Download Excel'
				}
			],
			scrollX: true,
			fixedColumns: {
				leftColumns: 3
			}
		});

	   	<?php if($setting['view-method'] =='expand'): ?>
		$('#distribusipupukTable tbody').on('click', 'td.details-control', function () {
	        var tr = $(this).closest('tr');
	        var row = table.row( tr );
	        var id = row.data().rowId;

	        if ( row.child.isShown() ) {
	        	 row.child.hide();
            	tr.removeClass('shown');
	        }
	        else {
	            // Open this row
	            row.child.show();	            
	            row.child( expand_child(id) ).show();
	            tr.addClass('shown');
	            $.get('{{ url("distribusipupuk/")}}/'+id , function(callback){
	            	$('#'+id).html(callback);
	            	$('#'+id).addClass('data');
	            })
		        
	            
	        }
    	});
    	<?php endif; ?>
		$('.dosearch').change(function( e ){
			// if (e.keyCode === 13) {
				val = $(this).val();
				table.search(val ).draw();
				var parexcel = $("#export_excel").attr('href');
				$("#export_excel").attr('href',parexcel+'&search=tanggal:like:'+val);
			// }
		})  

	    $('#distribusipupukTable').Sdtable({
	    	tableId : '#distribusipupuk',
	    	table   : table,
	    	action  : '{{ url("distribusipupuk")}}' 
	    });

	   
	});
	// Fungsi AJAX hapus permintaan pupuk
	function hapus_permintaan_pupuk(id) {
		if(!confirm('Yakin ingin menghapus data ini?')) return;
		$.ajax({
			url: '{{ url("distribusipupuk/hapus_permintaan_pupuk") }}',
			type: 'GET',
			data: {
				id: id
			},
			success: function(response) {
				if(response.status === 'success') {
					alert(response.message);
					table.ajax.reload();
				} else {
					alert(response.message);
				}
			},
			error: function(xhr) {
				alert('Terjadi kesalahan saat menghapus data');
			}
		});
	}

    function expand_child( id )
    {
    	return '<div id="'+ id+'"><p class="text-center"> Loading Content .. Please wait</p></div>';	
    }

</script>


@endsection