@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">
			<button id="downloadAllTables" class="btn btn-primary" style="float: right;">
				<i class="fa fa-download"></i> Download Semua Tabel
			</button>
			<button id="downloadPdfTables" class="btn btn-danger" style="float: right; margin-right:10px;">
				<i class="fa fa-file-pdf-o"></i> Download PDF Semua Tabel
			</button>
			
			
		<div >

	


		 {!! Form::open(array('url'=>'prognosaproduksitebukabag/delete/', 'class'=>'form-horizontal' ,'id' =>'SximoTable' )) !!}
		 <div class="table-responsive" style="min-height:300px;">
		<div class="row">
			<!-- Table Luas -->
			<div class="col-md-12">
				<h4 class="mb-3 text-primary font-weight-bold">
					<i class="fa fa-map" aria-hidden="true"></i> Luas
				</h4>
				<table class="table table-bordered table-sm table-striped">
					<thead class="thead-dark">
						<tr>
							<th rowspan="2" class="text-center align-middle">No</th>
							<th rowspan="2" class="text-center align-middle">Jawa/Luar Jawa</th>
							<th rowspan="2" class="text-center align-middle">Cluster</th>
							<th rowspan="2" class="text-center align-middle">Kode Kebun</th>
							<th rowspan="2" class="text-center align-middle">Nama Kebun</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas Real</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas Sisa</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas Prognosa</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas Real 2024</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas RKAP</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas Takmar</th>
							<th class="text-right text-center align-middle" rowspan="2">Luas Prognosa Sebelumnya</th>
							<th class="text-right text-center align-middle" colspan="4">% Prognosan thd </th>
						</tr>
						<tr>	
							<th class="text-right text-center align-middle">% Real 2024</th>
							<th class="text-right text-center align-middle">% RKAP</th>
							<th class="text-right text-center align-middle">% Takmar</th>
							<th class="text-right text-center align-middle">% Sebelumnya</th>
						</tr>
					</thead>
					<tbody>
						@foreach ($rowData as $i => $row)
						<tr>
							<td>{{ $i+1 }}</td>
							<td>{{ $row->jawa_luarjawa }}</td>
							<td>{{ $row->cluster }}</td>
							<td>{{ $row->kode_kebun }}</td>
							<td>{{ $row->nama_kebun_label }}</td>
							<td class="text-right">{{ number_format($row->luas_real,2) }}</td>
							<td class="text-right">{{ number_format($row->luas_sisa,2) }}</td>
							<td class="text-right" style="background-color:#ffeeba;">{{ number_format($row->luas_prognosa_9A,2) }}</td>
							<td class="text-right">{{ number_format($row->luas_real_2024,2) }}</td>
							<td class="text-right">{{ number_format($row->luas_rkap,2) }}</td>
							<td class="text-right">{{ number_format($row->luas_takmar,2) }}</td>
							<td class="text-right">{{ number_format($row->luas_prognosa_sebelumnya,2) }}</td>
							@php
								$persen_real_2024 = $row->luas_real_2024 != 0 ? ($row->luas_prognosa_9A/$row->luas_real_2024)*100 : 0;
								$persen_rkap = $row->luas_rkap != 0 ? ($row->luas_prognosa_9A/$row->luas_rkap)*100 : 0;
								$persen_takmar = $row->luas_takmar != 0 ? ($row->luas_prognosa_9A/$row->luas_takmar)*100 : 0;
								$persen_sebelumnya = $row->luas_prognosa_sebelumnya != 0 ? ($row->luas_prognosa_9A/$row->luas_prognosa_sebelumnya)*100 : 0;
							@endphp
							<td class="text-right">
								{{ number_format($persen_real_2024,2) }}%
								@if($persen_real_2024 > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_real_2024 == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_rkap,2) }}%
								@if($persen_rkap > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_rkap == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_takmar,2) }}%
								@if($persen_takmar > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_takmar == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_sebelumnya,2) }}%
								@if($persen_sebelumnya > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_sebelumnya == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
						</tr>
						@endforeach
						@if(isset($total))
						<tr class="font-weight-bold" style="font-weight:bold;">
							<td colspan="5" class="text-center">Total</td>
							<td class="text-right"><b>{{ number_format($total['luas_real'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_sisa'],2) }}</b></td>
							<td class="text-right" style="background-color:#ffeeba;"><b>{{ number_format($total['luas_prognosa_9A'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_real_2024'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_rkap'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_takmar'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_prognosa_sebelumnya'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_real_2024'] != 0 ? ($total['luas_prognosa_9A']/$total['luas_real_2024'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_rkap'] != 0 ? ($total['luas_prognosa_9A']/$total['luas_rkap'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_takmar'] != 0 ? ($total['luas_prognosa_9A']/$total['luas_takmar'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['luas_prognosa_sebelumnya'] != 0 ? ($total['luas_prognosa_9A']/$total['luas_prognosa_sebelumnya'])*100 : 0,2) }}%</b></td>
						</tr>
						@endif
					</tbody>
				</table>
			</div>
			<!-- Table Tebu -->
			<div class="col-md-12">
				<h4 class="mb-3 text-success font-weight-bold">
					<i class="fa fa-leaf" aria-hidden="true"></i> Tebu
				</h4>
				<table class="table table-bordered table-sm table-striped">
					<thead class="thead-dark">
						<tr>
							<th rowspan="2" class="text-center align-middle">No</th>
							<th rowspan="2" class="text-center align-middle">Jawa/Luar Jawa</th>
							<th rowspan="2" class="text-center align-middle">Cluster</th>
							<th rowspan="2" class="text-center align-middle">Kode Kebun</th>
							<th rowspan="2" class="text-center align-middle">Nama Kebun</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu Real</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu Sisa</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu Prognosa</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu Real 2024</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu RKAP</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu Takmar</th>
							<th class="text-right text-center align-middle" rowspan="2">Tebu Prognosa Sebelumnya</th>
							<th class="text-right text-center align-middle" colspan="4">% Prognosan thd </th>
						</tr>
						<tr>	
							<th class="text-right text-center align-middle">% Real 2024</th>
							<th class="text-right text-center align-middle">% RKAP</th>
							<th class="text-right text-center align-middle">% Takmar</th>
							<th class="text-right text-center align-middle">% Sebelumnya</th>
						</tr>
					</thead>
					<tbody>
						@foreach ($rowData as $i => $row)
						<tr>
							<td>{{ $i+1 }}</td>
							<td>{{ $row->jawa_luarjawa }}</td>
							<td>{{ $row->cluster }}</td>
							<td>{{ $row->kode_kebun }}</td>
							<td>{{ $row->nama_kebun_label }}</td>
							<td class="text-right">{{ number_format($row->tebu_real,2) }}</td>
							<td class="text-right">{{ number_format($row->tebu_sisa,2) }}</td>
							<td class="text-right" style="background-color:#ffeeba;">{{ number_format($row->tebu_prognosa_9A,2) }}</td>
							<td class="text-right">{{ number_format($row->tebu_real_2024,2) }}</td>
							<td class="text-right">{{ number_format($row->tebu_rkap,2) }}</td>
							<td class="text-right">{{ number_format($row->tebu_takmar,2) }}</td>
							<td class="text-right">{{ number_format($row->tebu_prognosa_sebelumnya,2) }}</td>
							@php
								$persen_real_2024 = $row->tebu_real_2024 != 0 ? ($row->tebu_prognosa_9A/$row->tebu_real_2024)*100 : 0;
								$persen_rkap = $row->tebu_rkap != 0 ? ($row->tebu_prognosa_9A/$row->tebu_rkap)*100 : 0;
								$persen_takmar = $row->tebu_takmar != 0 ? ($row->tebu_prognosa_9A/$row->tebu_takmar)*100 : 0;
								$persen_sebelumnya = $row->tebu_prognosa_sebelumnya != 0 ? ($row->tebu_prognosa_9A/$row->tebu_prognosa_sebelumnya)*100 : 0;
							@endphp
							<td class="text-right">
								{{ number_format($persen_real_2024,2) }}%
								@if($persen_real_2024 > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_real_2024 == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_rkap,2) }}%
								@if($persen_rkap > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_rkap == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_takmar,2) }}%
								@if($persen_takmar > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_takmar == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_sebelumnya,2) }}%
								@if($persen_sebelumnya > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_sebelumnya == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
						</tr>
						@endforeach
						@if(isset($total))
						<tr class="font-weight-bold" style="font-weight:bold;">
							<td colspan="5" class="text-center">Total</td>
							<td class="text-right"><b>{{ number_format($total['tebu_real'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_sisa'],2) }}</b></td>
							<td class="text-right" style="background-color:#ffeeba;"><b>{{ number_format($total['tebu_prognosa_9A'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_real_2024'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_rkap'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_takmar'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_prognosa_sebelumnya'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_real_2024'] != 0 ? ($total['tebu_prognosa_9A']/$total['tebu_real_2024'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_rkap'] != 0 ? ($total['tebu_prognosa_9A']/$total['tebu_rkap'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_takmar'] != 0 ? ($total['tebu_prognosa_9A']/$total['tebu_takmar'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['tebu_prognosa_sebelumnya'] != 0 ? ($total['tebu_prognosa_9A']/$total['tebu_prognosa_sebelumnya'])*100 : 0,2) }}%</b></td>
						</tr>
						@endif
					</tbody>
				</table>
			</div>
			<!-- Table Protas -->
			<div class="col-md-12">
				<h4 class="mb-3 text-info font-weight-bold">
					<i class="fa fa-bar-chart" aria-hidden="true"></i> Protas
				</h4>
				<table class="table table-bordered table-sm table-striped">
					<thead class="thead-dark">
						<tr>
							<th rowspan="2" class="text-center align-middle">No</th>
							<th rowspan="2" class="text-center align-middle">Jawa/Luar Jawa</th>
							<th rowspan="2" class="text-center align-middle">Cluster</th>
							<th rowspan="2" class="text-center align-middle">Kode Kebun</th>
							<th rowspan="2" class="text-center align-middle">Nama Kebun</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas Real</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas Sisa</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas Prognosa</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas Real 2024</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas RKAP</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas Takmar</th>
							<th class="text-right text-center align-middle" rowspan="2">Protas Prognosa Sebelumnya</th>
							<th class="text-right text-center align-middle" colspan="4">% Prognosan thd </th>
						</tr>
						<tr>	
							<th class="text-right text-center align-middle">% Real 2024</th>
							<th class="text-right text-center align-middle">% RKAP</th>
							<th class="text-right text-center align-middle">% Takmar</th>
							<th class="text-right text-center align-middle">% Sebelumnya</th>
						</tr>
					</thead>
					<tbody>
						@foreach ($rowData as $i => $row)
						<tr>
							<td>{{ $i+1 }}</td>
							<td>{{ $row->jawa_luarjawa }}</td>
							<td>{{ $row->cluster }}</td>
							<td>{{ $row->kode_kebun }}</td>
							<td>{{ $row->nama_kebun_label }}</td>
							<td class="text-right">{{ number_format($row->protas_real,2) }}</td>
							<td class="text-right">{{ number_format($row->protas_sisa,2) }}</td>
							<td class="text-right" style="background-color:#ffeeba;">{{ number_format($row->protas_prognosa_9A,2) }}</td>
							<td class="text-right">{{ number_format($row->protas_real_2024,2) }}</td>
							<td class="text-right">{{ number_format($row->protas_rkap,2) }}</td>
							<td class="text-right">{{ number_format($row->protas_takmar,2) }}</td>
							<td class="text-right">{{ number_format($row->protas_prognosa_sebelumnya,2) }}</td>
							@php
								$persen_real_2024 = $row->protas_real_2024 != 0 ? ($row->protas_prognosa_9A/$row->protas_real_2024)*100 : 0;
								$persen_rkap = $row->protas_rkap != 0 ? ($row->protas_prognosa_9A/$row->protas_rkap)*100 : 0;
								$persen_takmar = $row->protas_takmar != 0 ? ($row->protas_prognosa_9A/$row->protas_takmar)*100 : 0;
								$persen_sebelumnya = $row->protas_prognosa_sebelumnya != 0 ? ($row->protas_prognosa_9A/$row->protas_prognosa_sebelumnya)*100 : 0;
							@endphp
							<td class="text-right">
								{{ number_format($persen_real_2024,2) }}%
								@if($persen_real_2024 > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_real_2024 == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_rkap,2) }}%
								@if($persen_rkap > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_rkap == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_takmar,2) }}%
								@if($persen_takmar > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_takmar == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
							<td class="text-right">
								{{ number_format($persen_sebelumnya,2) }}%
								@if($persen_sebelumnya > 100)
									<i class="fa fa-arrow-up text-success"></i>
								@elseif($persen_sebelumnya == 100)
									-
								@else
									<i class="fa fa-arrow-down text-danger"></i>
								@endif
							</td>
						</tr>
						@endforeach
						@if(isset($total))
						<tr class="font-weight-bold" style="font-weight:bold;">
							<td colspan="5" class="text-center">Total</td>
							<td class="text-right"><b>{{ number_format($total['protas_real'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_sisa'],2) }}</b></td>
							<td class="text-right" style="background-color:#ffeeba;"><b>{{ number_format($total['protas_prognosa_9A'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_real_2024'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_rkap'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_takmar'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_prognosa_sebelumnya'],2) }}</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_real_2024'] != 0 ? ($total['protas_prognosa_9A']/$total['protas_real_2024'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_rkap'] != 0 ? ($total['protas_prognosa_9A']/$total['protas_rkap'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_takmar'] != 0 ? ($total['protas_prognosa_9A']/$total['protas_takmar'])*100 : 0,2) }}%</b></td>
							<td class="text-right"><b>{{ number_format($total['protas_prognosa_sebelumnya'] != 0 ? ($total['protas_prognosa_9A']/$total['protas_prognosa_sebelumnya'])*100 : 0,2) }}%</b></td>
						</tr>
						@endif
					</tbody>
				</table>
			</div>
		</div>
		<input type="hidden" name="md" value="" />
		</div>
		{!! Form::close() !!}
		
		<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
					<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
			<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.4.1/html2canvas.min.js"></script>
			<script>
			document.getElementById('downloadAllTables').addEventListener('click', function() {
				// Ambil semua tabel
				var tables = document.querySelectorAll('.table');
				var wb = XLSX.utils.book_new();

				tables.forEach(function(table, idx) {
					var ws = XLSX.utils.table_to_sheet(table);
					var sheetName = table.parentElement.querySelector('h4') ? table.parentElement.querySelector('h4').innerText.trim() : 'Sheet' + (idx+1);
					XLSX.utils.book_append_sheet(wb, ws, sheetName);
				});

				XLSX.writeFile(wb, 'data-tabel.xlsx');
			});
			</script>

			<script>
			document.getElementById('downloadPdfTables').addEventListener('click', function() {
				const tables = document.querySelectorAll('.table');
				const { jsPDF } = window.jspdf;
				const pdf = new jsPDF('l', 'pt', 'a4');
				let y = 40;
				const rightPadding = 40; // Tambahkan padding kanan

				const addTableToPdf = (table, idx, callback) => {
					const h4 = table.parentElement.querySelector('h4');
					const title = h4 ? h4.innerText.trim() : 'Tabel ' + (idx+1);

					html2canvas(table, { scale: 2 }).then(canvas => {
						const pageWidth = pdf.internal.pageSize.getWidth();
						const leftPadding = 40;
						const imgWidth = pageWidth - leftPadding - rightPadding;
						const imgHeight = canvas.height * imgWidth / canvas.width;
						const imgX = leftPadding;

						if (idx > 0) pdf.addPage();
						pdf.setFontSize(14);
						pdf.text(title, leftPadding, 30);
						pdf.addImage(canvas.toDataURL('image/png'), 'PNG', imgX, 40, imgWidth, imgHeight);
						callback();
					});
				};

				let idx = 0;
				function next() {
					if (idx < tables.length) {
						addTableToPdf(tables[idx], idx, function() {
							idx++;
							next();
						});
					} else {
						pdf.save('data-tabel.pdf');
					}
				}
				next();
			});
			</script>
		@include('footer')
	</div>  
</div>
@stop