@extends('layouts.index')

@push('css')
<style>
	.break-word{
		max-width: 200px !important;
		word-wrap: break-word !important;
		white-space: inherit !important;
	}

	.table-responsive{
		max-height: 800px !important;
		overflow-y: scroll;
	}

	td{
		vertical-align: middle !important;
		text-align: center !important;
	}
	th{
		vertical-align: middle !important;
		text-align: center !important;
	}

	table td {
		position: relative;
	}

	thead{
		position: sticky; 
		top: -5px;
		z-index: 1;
	}
</style>
@endpush

@section('content')

@include('layouts.include._breadcrumb')

<div class="page-content-wrapper">

	@include('layouts.include.filter', ['semester' => true])

	<div class="row">
		<div class="col-md-12">
			<div class="card">
				<div class="card-body">
					<div class="card-title">
						<div class="row">
							<div class="col-6">
								<h3 class="mb-0"> {{ $title }} Per Urusan </h3>
							</div>
							<div class="col-6 text-right">
								<a class="btn btn-warning" href="{{ route('print', 'hasil_pelaksanaan_rkpd_terhadap_apbd_per_urusan') . '?tahun='.$request->get('tahun', $tahun).'&semester='.$request->get('semester', 'all').'' }}" target="_blank">Print</a>
							</div>
						</div>
					</div>
					<p>
						{{-- <a class="btn btn-warning" href="{{ route('print', 'anggaran_bidang_urusan') }}" target="_blank">Print</a> --}}
					</p>
					@php
					$tahun = $request->get('tahun', date("Y"));
					$semester = $request->get('semester', 'all');
					$text = "";
					if ($semester == "all") {
						$text = "Semester 1 & 2";
					}elseif($semester == "semester1") {
						$text = "Semester 1";
					}elseif($semester == "semester2") {
						$text = "Semester 2";
					}elseif($semester == "tri1") {
						$text = "Triwulan 1";
					}elseif($semester == "tri2") {
						$text = "Triwulan 2";
					}elseif($semester == "tri3") {
						$text = "Triwulan 3";
					}elseif($semester == "tri4") {
						$text = "Triwulan 4";
					}
					@endphp
					<div class="table-responsive">
						<table class="table table-hover table-bordered datatablePrintUrusan" style="width: 100%">
							<thead class="table-dark">
								<tr>
									<th rowspan="4"  width="20px">No</th>
									<th rowspan="4"  class="break-word">Bidang Urusan</th>
									<th rowspan="4" > APBD </th>
									<th rowspan="4" > Realisasi APBD <br> {{ $text }}</th>
								</tr>

								<tr>
									<th colspan="4"> Tingkat Capaian Kinerja (%) dan Predikat Kinerja SKPD</th>
								</tr>

								<tr>
									<th colspan="2">Capaian Kinerja (K)</th>
									<th colspan="2">Realisasi Anggaran (RP)</th>
								</tr>

								<tr>
									<th>Persentase (%)</th>
									<th>Predikat Kinerja</th>
									<th>Persentase (%)</th>
									<th>Predikat Kinerja</th>
								</tr>
							</thead>
							<tbody>
								@if($datas['urusan'])
								@foreach ($datas['urusan'] as $mun)
									<tr class="font-weight-bold pointer table-success" data-self="mun" data-id="{{ $mun['id'] }}">
										<td>{{ \Helper::numberToRoman($loop->iteration) }}</td>
										<td class="break-word">{{ $mun['nama_urusan'] }}</td>
										<td>{{ number_format($mun['anggaranApbd']) }}</td>
										<td>{{ number_format($mun['realisasiApbd']) }}</td>
										<td>{{ $mun['persenK'] }}</td>
										<td>{{ $mun['predikatK'] }}</td>
										<td>{{ $mun['persenRp'] }}</td>
										<td>{{ $mun['predikatRp'] }}</td>
									</tr>

									<tr class="table-dark sembunyi" data-self="pd" data-parent="mun_{{ $mun['id'] }}">
										<td  colspan="8" style="text-align: left !important">Bidang Urusan</td>
										<td style="display: none;"></td>
										<td style="display: none;"></td>
										<td style="display: none;"></td>
										<td style="display: none;"></td>
										<td style="display: none;"></td>
										<td style="display: none;"></td>
										<td style="display: none;"></td>
									</tr>

									@foreach ($mun['daftar_mbun'] as $mbun)
										<tr class="sembunyi pointer" data-self="mbun" data-parent="mun_{{ $mun['id'] }}" style="background-color: bisque;">
											<td>{{ $loop->iteration }}</td>
											<td class="break-word">{{ $mbun['nama_bidang_urusan'] }}</td>
											<td>{{ number_format($mbun['anggaran_apbd_mbun']) }}</td>
											<td>{{ number_format($mbun['realisasi_apbd_mbun']) }}</td>
											<td>{{ $mbun['persenK'] }}</td>
											<td>{{ $mbun['predikatK'] }}</td>
											<td>{{ $mbun['persenRp'] }}</td>
											<td>{{ $mbun['predikatRp'] }}</td>
										</tr>
									@endforeach
								@endforeach
								<tr class="font-weight-bold table-dark">
									<td>&nbsp;</td>
									<td>Total :</td>
									<td>{{ number_format($datas2['urusan']['ttlDistribusiApbd']) }}</td>
									<td>{{ number_format($datas2['urusan']['ttlRealisasiApbd']) }}</td>
									<td>{{ $datas2['urusan']['ttlPersenK'] }}</td>
									<td>{{ \Helper::hitungPredikat($datas2['urusan']['ttlPersenK']) }}</td>
									<td>{{ $datas2['urusan']['ttlPersenRp'] }}</td>
									<td>{{ \Helper::hitungPredikat($datas2['urusan']['ttlPersenRp']) }}</td>
								</tr>
								@else
								<tr class="table-light">
									<td colspan="100%" class="break-word">
										Kosong
									</td>
								</tr>
								@endif
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>


		<div class="col-md-12">
			<div class="card">
				<div class="card-body">
					<div class="card-title">
						<div class="row">
							<div class="col-6">
								<h3 class="mb-0"> {{ $title }} Per OPD</h3>
							</div>
							<div class="col-6 text-right">
								<a class="btn btn-warning" href="{{ route('print', 'hasil_pelaksanaan_rkpd_terhadap_apbd_per_opd') . '?tahun='.$request->get('tahun', $tahun).'&semester='.$request->get('semester', 'all').'' }}" target="_blank">Print</a>
							</div>
						</div>
					</div>
					<p>
						{{-- <a class="btn btn-warning" href="{{ route('print', 'anggaran_bidang_urusan') }}" target="_blank">Print</a> --}}
					</p>
					@php
					$tahun = $request->get('tahun', date("Y"));
					$semester = $request->get('semester', 'all');
					$text = "";
					if ($semester == "all") {
						$text = "Semester 1 & 2";
					}elseif($semester == "semester1") {
						$text = "Semester 1";
					}elseif($semester == "semester2") {
						$text = "Semester 2";
					}elseif($semester == "tri1") {
						$text = "Triwulan 1";
					}elseif($semester == "tri2") {
						$text = "Triwulan 2";
					}elseif($semester == "tri3") {
						$text = "Triwulan 3";
					}elseif($semester == "tri4") {
						$text = "Triwulan 4";
					}
					@endphp
					<div class="table-responsive">
						<table class="table table-hover table-bordered datatablePrintUrusan" style="width: 100%">
							<thead class="table-dark">
								<tr>
									<th rowspan="4"  width="20px">No</th>
									<th rowspan="4"  class="break-word">Perangkat Daerah</th>
									<th rowspan="4" > APBD </th>
									<th rowspan="4" > Realisasi APBD <br> {{ $text }}</th>
								</tr>

								<tr>
									<th colspan="4"> Tingkat Capaian Kinerja (%) dan Predikat Kinerja SKPD</th>
								</tr>

								<tr>
									<th colspan="2">Capaian Kinerja (K)</th>
									<th colspan="2">Realisasi Anggaran (RP)</th>
								</tr>

								<tr>
									<th>Persentase (%)</th>
									<th>Predikat Kinerja</th>
									<th>Persentase (%)</th>
									<th>Predikat Kinerja</th>
								</tr>
							</thead>
							<tbody>
								@if($datas['opd'])
								@foreach ($datas['opd'] as $opd)
									<tr>
										<td>{{ $loop->iteration }}</td>
										<td class="break-word">{{ $opd['nama_perangkat_daerah'] }}</td>
										<td>{{ number_format($opd['anggaran_apbd_pd']) }}</td>
										<td>{{ number_format($opd['realisasi_apbd_pd']) }}</td>
										<td>{{ $opd['persenK'] }}</td>
										<td>{{ $opd['predikatK'] }}</td>
										<td>{{ $opd['persenRp'] }}</td>
										<td>{{ $opd['predikatRp'] }}</td>
									</tr>
								@endforeach
								<tr class="font-weight-bold table-dark">
									<td>&nbsp;</td>
									<td>Total :</td>
									<td>{{ number_format($datas2['opd']['ttlDistribusiApbd']) }}</td>
									<td>{{ number_format($datas2['opd']['ttlRealisasiApbd']) }}</td>
									<td>{{ $datas2['opd']['ttlPersenK'] }}</td>
									<td>{{ \Helper::hitungPredikat($datas2['opd']['ttlPersenK']) }}</td>
									<td>{{ $datas2['opd']['ttlPersenRp'] }}</td>
									<td>{{ \Helper::hitungPredikat($datas2['opd']['ttlPersenRp']) }}</td>
								</tr>
								@else
								<tr class="table-light">
									<td colspan="100%" class="break-word">
										Kosong
									</td>
								</tr>
								@endif
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>
	</div>

</div>
@endsection

@push('js')
<script>
	$(document).ready(function() {
    $('.datatablePrintUrusan').DataTable( {
        dom: 'Bfrtip',
				paging: false,
				ordering: false,
				searching: false,
        buttons: [
            'csv', 'excel'
        ]
    } );
	} );
</script>
@endpush