@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 text-left">
					<form method="GET" action="{{ url($pageModule) }}" class="form-inline">
						<div class="form-group mt-2">
							<select name="filter_pg" id="filter_pg" class="form-control mr-2 select2 "
								style="width:400px;">
							</select>
						</div>

						<div class="form-group mt-2">
							<select name="filter_periode" id="filter_periode" class="form-control mr-2 select2 "
								style="width:400px;">
							</select>
						</div>

						<button type="submit" class="btn btn-sm btn-primary ml-2">Filter</button>
						<button type="button" class="btn btn-sm btn-success ml-2" id="downloadBtn">Download</button>
					
					</form>
					
				</div>
				<div class="col-md-6 text-right">
					<a href="{{ url('prognosa') }}" class="btn btn-sm btn-primary"><i class="fa fa-plus"></i> Tambah Prognosa</a>
						

					</div>
			</div>
		<div >

	


		 {!! Form::open(array('url'=>'rekapprognosa/delete/', 'class'=>'form-horizontal' ,'id' =>'SximoTable' )) !!}
		 <div class="table-responsive" style="min-height:300px;">
		<ul class="nav nav-tabs" id="rekapTabs" role="tablist">
			<li class="nav-item">
				<a class="nav-link active" id="prognosa-tab" data-toggle="tab" href="#prognosa" role="tab" aria-controls="prognosa" aria-selected="true">Prognosa</a>
			</li>
			<li class="nav-item">
				<a class="nav-link" id="rekap-kebun-tab" data-toggle="tab" href="#rekap-kebun" role="tab" aria-controls="rekap-kebun" aria-selected="false">Rekap Kebun</a>
			</li>
			<li class="nav-item">
				<a class="nav-link" id="rekap-rayon-tab" data-toggle="tab" href="#rekap-rayon" role="tab" aria-controls="rekap-rayon" aria-selected="false">Rekap Rayon</a>
			</li>
		</ul>
		<div class="tab-content" id="rekapTabsContent">
			<div class="tab-pane fade show active" id="prognosa" role="tabpanel" aria-labelledby="prognosa-tab">
				<table class="table table-hover table-striped" id="dataTable">
					<thead>
						<tr>
							<th class="number"> No </th>
							@foreach ($tableGrid as $t)
								@if($t['view'] =='1')
									<th>{{ $t['label'] }}</th>
								@endif
							@endforeach
						</tr>
					</thead>
					<tbody>
						@php 
							$countprotas = 3;
							$countluas = 0;
							$countluas2 = 0;
							$countluas3 = 1;
							$counttebu = 1;
							$counthablur = 3;
							$countrend = 5;
						@endphp
						@foreach ($rowData as $i=> $row)
							<tr>
								<td width="30"> {{ ++$i }} </td>
								@php
									// Group fields
									$groupFields = ['nama_kebun', 'nama_rayon'];
								@endphp

								@foreach ($tableGrid as $field)
									@if($field['view'] =='1')
										<?php $limited = isset($field['limited']) ? $field['limited'] :''; ?>
										@if(SiteHelpers::filterColumn($limited ))
											@if(in_array($field['field'], $groupFields))
												@if(!isset($prevGroup) || !isset($prevGroup[$field['field']]) || $prevGroup[$field['field']] !== $row->{$field['field']})
													<td rowspan="{{ $row->group_count ?? 1 }}" >
														{!! SiteHelpers::formatRows($row->{$field['field']}, $field, $row) !!}
													</td>
													@php $prevGroup[$field['field']] = $row->{$field['field']}; @endphp
												@else
													<td></td>
												@endif
											@else
												<td style="text-align: right;">
													@if(is_numeric($row->{$field['field']}))
														@if($field['field'] == 'PROGNOSA')
															@if($i == $countprotas)
																{{ number_format($rowData[$counttebu]->PROGNOSA/$rowData[$countluas]->PROGNOSA,2) }}
																@php $countprotas = $countprotas + 7;
																	$counttebu = $counttebu + 7;
																	$countluas = $countluas + 7;
																@endphp
															@elseif($i == $countrend)
																{{ number_format($rowData[$counthablur]->PROGNOSA/$rowData[$countluas2]->PROGNOSA,2) }}
																@php $counthablur = $counthablur + 7;
																	$countrend = $countrend + 7;
																	$countluas2 = $countluas2 + 7;
																@endphp
															@elseif($i == $countluas3)
																{{ number_format($row->{$field['field']},3) }}
																@php $countluas3 = $countluas3 + 7; 
																@endphp
															@else
																@if($row->{$field['field']} == "0.00")
																	{{ "-" }}
																@else
																	{{ number_format($row->{$field['field']},2) }}
																@endif
															@endif
														@else
															@if($row->{$field['field']} == "0.00")
																{{ "-" }}
															@else
																{{ number_format($row->{$field['field']},2) }}
															@endif
														@endif
													@else
														{!! SiteHelpers::formatRows($row->{$field['field']}, $field, $row) !!}
													@endif
												</td>
											@endif
										@endif
									@endif
								@endforeach
						@endforeach
					</tbody>
				</table>
			</div>
			<div class="tab-pane fade" id="rekap-kebun" role="tabpanel" aria-labelledby="rekap-kebun-tab">
				{{-- TODO: Isi tabel rekap kebun di sini --}}
				<div class="alert alert-info mt-3">Tabel Rekap Kebun belum diimplementasikan.</div>
			</div>
			<div class="tab-pane fade" id="rekap-rayon" role="tabpanel" aria-labelledby="rekap-rayon-tab">
				{{-- TODO: Isi tabel rekap rayon di sini --}}
				<div class="alert alert-info mt-3">Tabel Rekap Rayon belum diimplementasikan.</div>
			</div>
		</div>
		<input type="hidden" name="md" value="" />
		</div>
		{!! Form::close() !!}
		<script>
			$("#filter_pg").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_pg:kode_pg:nama_pg') !!}", {
				initial_text: 'Pilih Pabrik Gula', selected_value: "{{ request('filter_pg') }}"
			});

			$("#filter_periode").jCombo("{!! url('dataprodisconsole/comboselect?filter=master_bulan_tanam:bulan_tanam:bulan_tanam') !!}", {
				initial_text: 'Pilih Periode Input', selected_value: "{{ $periode }}"
			});

			$("#filter_periode").on('change', function () {
				var filterPeriode = $(this).val();
				var filterPg = $("#filter_pg").val();

				
				@php if(empty(request('filter_periode'))){ @endphp
					window.location.href = "{{ url($pageModule) }}?filter_pg=" + filterPg + "&filter_periode=" + filterPeriode;
				@php } @endphp

				// Redirect to the same page with the selected filters
				
			});

			$('#rekap-kebun-tab').on('click', function () {
				var periode = $('#filter_periode').val();
				var filter_pg = $('#filter_pg').val();
				$.ajax({
					url: "{{ url('rekapprognosa/rekap_prognosa_kebun') }}",
					type: "GET",
					data: { periode: periode, filter_pg: filter_pg },
					beforeSend: function() {
						$('#rekap-kebun').html('<div class="text-center mt-3">Loading...</div>');
					},
					success: function (data) {
						$('#rekap-kebun').html(data);
					},
					error: function () {
						$('#rekap-kebun').html('<div class="alert alert-danger mt-3">Gagal memuat data Rekap Kebun.</div>');
					}
				});
			});

			$('#rekap-rayon-tab').on('click', function () {
				var periode = $('#filter_periode').val();
				var filter_pg = $('#filter_pg').val();
				$.ajax({
					url: "{{ url('rekapprognosa/rekap_prognosa_rayon') }}",
					type: "GET",
					data: { periode: periode, filter_pg: filter_pg },
					beforeSend: function() {
						$('#rekap-rayon').html('<div class="text-center mt-3">Loading...</div>');
					},
					success: function (data) {
						$('#rekap-rayon').html(data);
					},
					error: function () {
						$('#rekap-rayon').html('<div class="alert alert-danger mt-3">Gagal memuat data Rekap Rayon.</div>');
					}
				});
			});

		</script>
			<script>
		document.getElementById('downloadBtn').addEventListener('click', function () {
			// Cek tab aktif
			var activeTab = document.querySelector('.nav-link.active').getAttribute('id');
			var table;
			if (activeTab === 'prognosa-tab') {
				table = document.getElementById('dataTable');
			} else if (activeTab === 'rekap-kebun-tab') {
				table = document.getElementById('datatable2');
			} else if (activeTab === 'rekap-rayon-tab') {
				table = document.getElementById('datatable3');
			}

			if (table) {
				var workbook = XLSX.utils.table_to_book(table, { sheet: "Sheet1" });
				XLSX.writeFile(workbook, activeTab+'.xlsx');
			} else {
				alert('Tabel tidak ditemukan untuk tab yang aktif.');
			}
		});
							</script>
		
	</div>  
</div>
@stop