role_id)->value('akses'); $listUpt = \App\Model\Setting\UPT::select('office_id','office_name','province_name')->distinct()->get(); ?>
| % RT TERBAYAR SEBELUM TNGGAL JATUH TEMPO | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| UPT | @foreach(\App\Model\Date\ListMonth::all() as $key => $value){{$value->nama}} | @endforeach|||||||||||
| {{$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(); ?>{{$paid_rts}} | @endforeach|||||||||||