role_id)->value('akses'); $listUpt = \App\Model\Setting\UPT::select('office_id','office_name','province_name')->distinct()->get(); ?>

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}}