| {{$value->office_name}} |
whereYear('bi_begin',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('upt',$value->office_name)->count();
$nopaid_rts = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',$fixMonth)->whereYear('bi_begin',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('upt',$value->office_name)->count();
$total_rts = $paid_rts + $nopaid_rts;
if ($paid_rts == 0) {
$rt_terbayar = 0;
}else{
$rt_terbayar = $paid_rts / $total_rts * 100;
}
$sudah_tl = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',$fixMonth)->whereYear('bi_begin',$fixYear)->where('upt',$value->office_name)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('status','not paid')->where('active',1)->count();
$belum_tl = $nopaid_rts - $sudah_tl;
if ($sudah_tl == 0) {
$rt_yang_tl = 0;
}else{
$rt_yang_tl = $sudah_tl / $nopaid_rts * 100;
}
$tanggal_upload = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',$fixMonth)->whereYear('bi_begin',$fixYear)->where('upt',$value->office_name)->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->select('updated_at')->distinct()->value('updated_at');
$jumlah_rt = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',$fixMonth)->whereYear('bi_begin',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('upt',$value->office_name)->count();
?>
{{$total_rts}} |
{{$paid_rts}} |
{{number_format($rt_terbayar, 2)}} % |
{{$nopaid_rts}} |
{{$sudah_tl}} |
{{$belum_tl}} |
{{number_format($rt_yang_tl, 2)}} & |
@if($tanggal_upload)
{{\Carbon\Carbon::parse($tanggal_upload)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
@endforeach