REKAP PENGIRIMAN LAPORAN

@foreach(\App\Model\Date\ListMonth::all() as $key => $value) @endforeach @foreach($listUpt as $key => $value) office_name ?> @foreach(\App\Model\Date\ListMonth::all() as $key => $value) id_bulan == 1){ $fixMonth = 12; $fixYear = $year - 1; }else{ $fixMonth = $value->id_bulan - 1; $fixYear = $year; } $checkingPengiriman = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',$fixMonth)->whereYear('bi_begin',$fixYear)->where('upt',$uptName)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count(); ?> @endforeach @endforeach

UPT	{{$value->nama}}
{{$value->office_name}}	@if($checkingPengiriman != 0) YA @else BELUM @endif

REKAPITULASI DAN PERSENTASE AKSI PENCEGAHAN PIUTANG

@foreach(\App\Model\Date\ListMonth::all() as $key => $value) @endforeach @foreach($listUpt as $key => $value) office_name ?> @foreach(\App\Model\Date\ListMonth::all() as $key => $value) id_bulan == 1){ $fixMonth = 12; $fixYear = $year - 1; }else{ $fixMonth = $value->id_bulan - 1; $fixYear = $year; } $paid_rts = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',$fixMonth)->whereYear('bi_begin',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('upt',$uptName)->count(); ?> @endforeach @endforeach

	% RT TERBAYAR SEBELUM TNGGAL JATUH TEMPO
UPT	{{$value->nama}}
{{$value->office_name}}	{{$paid_rts}}

@endif