role_id)->value('akses'); if($getStatus == 'administrator'){ $listUpt = \App\Model\Setting\UPT::select('office_id','office_name','province_name')->distinct()->get(); }else{ $listUpt = \App\Model\Setting\UPT::where('office_id', Auth::user()->upt)->select('office_id','office_name','province_name')->distinct()->get(); } ?>

REKAP PENGIRIMAN LAPORAN @if($jenis_st == 'First Reminder') ST-1 @elseif($jenis_st == 'Second Reminder') ST-2 @elseif($jenis_st == 'Third Reminder') ST-3 @elseif($jenis_st == 'Last Reminder') STT @endif

whereYear('bi_create_date',$fixYear)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$year)->where('upt', $getUptName)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); ?>
UPT Jan Feb Mar Apr Mei Jun Jul Aug Sep Okt Nov Des
{{$getUptName}} @if($januari != 0) YA @else BELUM @endif @if($februari != 0) YA @else BELUM @endif @if($maret != 0) YA @else BELUM @endif @if($april != 0) YA @else BELUM @endif @if($mei != 0) YA @else BELUM @endif @if($juni != 0) YA @else BELUM @endif @if($juli != 0) YA @else BELUM @endif @if($agustus != 0) YA @else BELUM @endif @if($september != 0) YA @else BELUM @endif @if($oktober != 0) YA @else BELUM @endif @if($november != 0) YA @else BELUM @endif @if($desember != 0) YA @else BELUM @endif