---

DATA @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 REKAP PENGIRIMAN LAPORAN

---

@foreach($upt as $key => $value) whereYear('bi_create_date',$fixYear)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); $desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$year)->where('upt', $value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count(); ?> @endforeach

UPT	Jan	Feb	Mar	Apr	Mei	Jun	Jul	Aug	Sep	Okt	Nov	Des
{{$value->office_name}}	@if($januari == 0) BELUM @else YA @endif	@if($februari == 0) BELUM @else YA @endif	@if($maret == 0) BELUM @else YA @endif	@if($april == 0) BELUM @else YA @endif	@if($mei == 0) BELUM @else YA @endif	@if($juni == 0) BELUM @else YA @endif	@if($juli == 0) BELUM @else YA @endif	@if($agustus == 0) BELUM @else YA @endif	@if($september == 0) BELUM @else YA @endif	@if($oktober == 0) BELUM @else YA @endif	@if($november == 0) BELUM @else YA @endif	@if($desember == 0) BELUM @else YA @endif

---