---

Data Status Tagihan {{date('d F Y')}}

---

@foreach($listUpt as $key => $value) whereYear('bi_create_date',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('upt',$value->office_name)->count(); $nopaid_rts = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',$fixMonth)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('upt',$value->office_name)->count(); $total_rts = $paid_rts + $nopaid_rts; $sudah_tl = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',$fixMonth)->whereYear('bi_create_date',$fixYear)->where('upt',$value->office_name)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count(); $belum_tl = $total_rts - $sudah_tl; $tanggal_upload = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',$fixMonth)->whereYear('bi_create_date',$fixYear)->where('upt',$value->office_name)->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->select('updated_at')->distinct()->value('updated_at'); $jumlah_rt = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',$fixMonth)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('upt',$value->office_name)->count(); ?> @endforeach

			ST BELUM TERBAYAR (H-30 s.d H)				ST TIDAK TERBAYAR (MENJADI REMINDER)
UPT	TOTAL ST TERBIT	ST TERBAYAR	SUDAH DI-TL UPT	%	BELUM DI-TL UPT	%	JUMLAH ST	%	Tanggal Upload
{{$value->office_name}}	{{$total_rts}}	{{$paid_rts}}	{{$sudah_tl}}	0 %	{{$belum_tl}}	0 %	{{$jumlah_rt}}	0 %	@if($tanggal_upload) {{\Carbon\Carbon::parse($tanggal_upload) ->format('d, M Y')}} @else Belum Mengirim @endif

---