deploy_djid
/
djid_siput


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594
							<!DOCTYPE html>
<?php 
  $getStatus = \App\Model\Privillage\Role::where('id',Auth::user()->role_id)->value('akses'); 
?>
<html>
<head>
  <style>
    .table-bordered {
        border-collapse: collapse;
        width: 100%;
    }

    .table-bordered td, .table-bordered th {
        border: 1px solid black;
        padding: 8px;
    }
    .thead-light{
      background-color: #E9ECEF;
    }
    .table-bordered th {
      padding-top: 12px;
      padding-bottom: 12px;
      text-align: left;
    }
  </style>
</head>
<body>
  <?php 
  $getStatus = \App\Model\Privillage\Role::where('id',Auth::user()->role_id)->value('akses'); 
  $upt = \App\Model\Setting\UPT::select('office_name','office_id')->distinct()->get();
  ?>
  <center>
    <div>
      <hr>
      <h2 class="font-weight-bolder">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 REKAPITULASI DAN PERSENTASE AKSI PENCEGAHAN PIUTANG</h2>
      <hr>
      <table id="example" class="table table-bordered align-items-center">
        <thead class="thead-light">
          <tr>
            <th class="tg-0pky" colspan="3"></th>
            <th class="tg-0lax" colspan="4" style="background-color: #63a53a; color: #fff; text-align: center;">RT BELUM TERBAYAR (H-30 s.d H)</th>
            <th class="tg-0lax" colspan="3" style="background-color: #ff1228; color: #fff;">RT TIDAK TERBAYAR (MENJADI REMINDER)</th>
          </tr>
          <tr>
            <td class="tg-0lax">BULAN</td>
            <td class="tg-0lax">TOTAL RT TERBIT</td>
            <td class="tg-0lax">RT TERBAYAR</td>
            <td class="tg-0lax">SUDAH DI-TL UPT</td>
            <td class="tg-0lax">%</td>
            <td class="tg-0lax">BELUM DI-TL UPT</td>
            <td class="tg-0lax">%</td>
            <td class="tg-0lax">JUMLAH RT</td>
            <td class="tg-0lax">%</td>
            <td class="tg-0lax">Tanggal Upload</td>
          </tr>
        </thead>
        <?php
        $fixYear = $year - 1;

        //Januari
        $paid_rts_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_januari = $paid_rts_januari + $nopaid_rts_januari;
        $sudah_tl_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_januari = $total_rts_januari - $sudah_tl_januari;
        if ($total_rts_januari != 0) {
          $percent_sudah_tl_januari = $sudah_tl_januari / $total_rts_januari * 100;
          $percent_belum_tl_januari = $belum_tl_januari / $total_rts_januari * 100;
        }else{
          $percent_belum_tl_januari = 0;
          $percent_sudah_tl_januari = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_januari = 0;
        }
        if ($jumlah_rt_januari != 0) {
          $percent_jumlah_rt_januari = $jumlah_rt_januari / $total_rts_januari * 100;
        }else{
          $percent_jumlah_rt_januari = 0;
        }
        $tanggal_upload_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->select('updated_at')->distinct()->value('updated_at');

        //Februari
        $paid_rts_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_februari = $paid_rts_februari + $nopaid_rts_februari;
        $sudah_tl_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_februari = $total_rts_februari - $sudah_tl_februari;
        if ($total_rts_februari != 0) {
          $percent_sudah_tl_februari = $sudah_tl_februari / $total_rts_februari * 100;
          $percent_belum_tl_februari = $belum_tl_februari / $total_rts_februari * 100;
        }else{
          $percent_belum_tl_februari = 0;
          $percent_sudah_tl_februari = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',12)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_februari = 0;
        }
        if ($jumlah_rt_februari != 0) {
          $percent_jumlah_rt_februari = $jumlah_rt_februari / $total_rts_februari * 100;
        }else{
          $percent_jumlah_rt_februari = 0;
        }
        $tanggal_upload_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',1)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->select('updated_at')->distinct()->value('updated_at');

        //Maret
        $paid_rts_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_maret = $paid_rts_maret + $nopaid_rts_maret;
        $sudah_tl_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_maret = $total_rts_maret - $sudah_tl_maret;
        if ($total_rts_maret != 0) {
          $percent_sudah_tl_maret = $sudah_tl_maret / $total_rts_maret * 100;
          $percent_belum_tl_maret = $belum_tl_maret / $total_rts_maret * 100;
        }else{
          $percent_belum_tl_maret = 0;
          $percent_sudah_tl_maret = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_maret = 0;
        }
        if ($jumlah_rt_maret != 0) {
          $percent_jumlah_rt_maret = $jumlah_rt_maret / $total_rts_maret * 100;
        }else{
          $percent_jumlah_rt_maret = 0;
        }
        $tanggal_upload_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',2)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //April
        $paid_rts_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_april = $paid_rts_april + $nopaid_rts_april;
        $sudah_tl_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_april = $total_rts_april - $sudah_tl_april;
        if ($total_rts_april != 0) {
          $percent_sudah_tl_april = $sudah_tl_april / $total_rts_april * 100;
          $percent_belum_tl_april = $belum_tl_april / $total_rts_april * 100;
        }else{
          $percent_belum_tl_april = 0;
          $percent_sudah_tl_april = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_april = 0;
        }
        if ($jumlah_rt_april != 0) {
          $percent_jumlah_rt_april = $jumlah_rt_april / $total_rts_april * 100;
        }else{
          $percent_jumlah_rt_april = 0;
        }
        $tanggal_upload_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',3)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //Mei

        $paid_rts_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_mei = $paid_rts_mei + $nopaid_rts_mei;
        $sudah_tl_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_mei = $total_rts_mei - $sudah_tl_mei;
        if ($total_rts_mei != 0) {
          $percent_sudah_tl_mei = $sudah_tl_mei / $total_rts_mei * 100;
          $percent_belum_tl_mei = $belum_tl_mei / $total_rts_mei * 100;
        }else{
          $percent_belum_tl_mei = 0;
          $percent_sudah_tl_mei = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_mei = 0;
        }
        if ($jumlah_rt_mei != 0) {
          $percent_jumlah_rt_mei = $jumlah_rt_mei / $total_rts_mei * 100;
        }else{
          $percent_jumlah_rt_mei = 0;
        }
        $tanggal_upload_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',4)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //Juni
        $paid_rts_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_juni = $paid_rts_juni + $nopaid_rts_juni;
        $sudah_tl_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_juni = $total_rts_juni - $sudah_tl_juni;
        if ($total_rts_juni != 0) {
          $percent_sudah_tl_juni = $sudah_tl_juni / $total_rts_juni * 100;
          $percent_belum_tl_juni = $belum_tl_juni / $total_rts_juni * 100;
        }else{
          $percent_belum_tl_juni = 0;
          $percent_sudah_tl_juni = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_juni = 0;
        }
        if ($jumlah_rt_juni != 0) {
          $percent_jumlah_rt_juni = $jumlah_rt_juni / $total_rts_juni * 100;
        }else{
          $percent_jumlah_rt_juni = 0;
        }
        $tanggal_upload_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',5)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //Juli
        $paid_rts_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_juli = $paid_rts_juli + $nopaid_rts_juli;
        $sudah_tl_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('status',1)->count();
        $belum_tl_juli = $total_rts_juli - $sudah_tl_juli;
        if ($total_rts_juli != 0) {
          $percent_sudah_tl_juli = $sudah_tl_juli / $total_rts_juli * 100;
          $percent_belum_tl_juli = $belum_tl_juli / $total_rts_juli * 100;
        }else{
          $percent_belum_tl_juli = 0;
          $percent_sudah_tl_juli = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_juli = 0;
        }
        if ($jumlah_rt_juli != 0) {
          $percent_jumlah_rt_juli = $jumlah_rt_juli / $total_rts_juli * 100;
        }else{
          $percent_jumlah_rt_juli = 0;
        }
        $tanggal_upload_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',6)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //Agustus
        $paid_rts_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_agustus = $paid_rts_agustus + $nopaid_rts_agustus;
        $sudah_tl_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_agustus = $total_rts_agustus - $sudah_tl_agustus;
        if ($total_rts_agustus != 0) {
          $percent_sudah_tl_agustus = $sudah_tl_agustus / $total_rts_agustus * 100;
          $percent_belum_tl_agustus = $belum_tl_agustus / $total_rts_agustus * 100;
        }else{
          $percent_belum_tl_agustus = 0;
          $percent_sudah_tl_agustus = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_agustus = 0;
        }
        if ($jumlah_rt_agustus != 0) {
          $percent_jumlah_rt_agustus = $jumlah_rt_agustus / $total_rts_agustus * 100;
        }else{
          $percent_jumlah_rt_agustus = 0;
        }
        $tanggal_upload_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',7)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //September
        $paid_rts_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_september = $paid_rts_september + $nopaid_rts_september;
        $sudah_tl_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_september = $total_rts_september - $sudah_tl_september;
        if ($total_rts_september != 0) {
          $percent_sudah_tl_september = $sudah_tl_september / $total_rts_september * 100;
          $percent_belum_tl_september = $belum_tl_september / $total_rts_september * 100;
        }else{
          $percent_belum_tl_september = 0;
          $percent_sudah_tl_september = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_september = 0;
        }
        if ($jumlah_rt_september != 0) {
          $percent_jumlah_rt_september = $jumlah_rt_september / $total_rts_september * 100;
        }else{
          $percent_jumlah_rt_september = 0;
        }
        $tanggal_upload_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',8)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //Oktober
        $paid_rts_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_oktober = $paid_rts_oktober + $nopaid_rts_oktober;
        $sudah_tl_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_oktober = $total_rts_oktober - $sudah_tl_oktober;
        if ($total_rts_oktober != 0) {
          $percent_sudah_tl_oktober = $sudah_tl_oktober / $total_rts_oktober * 100;
          $percent_belum_tl_oktober = $belum_tl_oktober / $total_rts_oktober * 100;
        }else{
          $percent_belum_tl_oktober = 0;
          $percent_sudah_tl_oktober = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_oktober = 0;
        }
        if ($jumlah_rt_oktober != 0) {
          $percent_jumlah_rt_oktober = $jumlah_rt_oktober / $total_rts_oktober * 100;
        }else{
          $percent_jumlah_rt_oktober = 0;
        }
        $tanggal_upload_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',9)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //November
        $paid_rts_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_november = $paid_rts_november + $nopaid_rts_november;
        $sudah_tl_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_november = $total_rts_november - $sudah_tl_november;
        if ($total_rts_november != 0) {
          $percent_sudah_tl_november = $sudah_tl_november / $total_rts_november * 100;
          $percent_belum_tl_november = $belum_tl_november / $total_rts_november * 100;
        }else{
          $percent_belum_tl_november = 0;
          $percent_sudah_tl_november = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_november = 0;
        }
        if ($jumlah_rt_november != 0) {
          $percent_jumlah_rt_november = $jumlah_rt_november / $total_rts_november * 100;
        }else{
          $percent_jumlah_rt_november = 0;
        }
        $tanggal_upload_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',10)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');

        //Desember
        $paid_rts_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $nopaid_rts_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        $total_rts_desember = $paid_rts_desember + $nopaid_rts_desember;
        $sudah_tl_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$year)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->where('active',1)->count();
        $belum_tl_desember = $total_rts_desember - $sudah_tl_desember;
        if ($total_rts_desember != 0) {
          $percent_sudah_tl_desember = $sudah_tl_desember / $total_rts_desember * 100;
          $percent_belum_tl_desember = $belum_tl_desember / $total_rts_desember * 100;
        }else{
          $percent_belum_tl_desember = 0;
          $percent_sudah_tl_desember = 0;
        }
        if (\App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count()) {
          $jumlah_rt_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->count();
        }else{
          $jumlah_rt_desember = 0;
        }
        if ($jumlah_rt_desember != 0) {
          $percent_jumlah_rt_desember = $jumlah_rt_desember / $total_rts_desember * 100;
        }else{
          $percent_jumlah_rt_desember = 0;
        }
        $tanggal_upload_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_create_date',11)->whereYear('bi_create_date',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('bi_type',$bi_type)->distinct()->value('updated_at');
        ?>
        <tr>
          <td class="tg-0lax">JAN</td>
          <td>{{$total_rts_januari}}</td>
          <td>{{$paid_rts_januari}}</td>
          <td>{{$sudah_tl_januari}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_januari), 0, 5) !!} %</td>
          <td>{{$belum_tl_januari}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_januari), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_januari}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_januari), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_januari)
            {{\Carbon\Carbon::parse($tanggal_upload_januari)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">FEB</td>
          <td>{{$total_rts_februari}}</td>
          <td>{{$paid_rts_februari}}</td>
          <td>{{$sudah_tl_februari}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_februari), 0, 5) !!} %</td>
          <td>{{$belum_tl_februari}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_februari), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_februari}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_februari), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_februari)
            {{\Carbon\Carbon::parse($tanggal_upload_februari)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">MAR</td>
          <td>{{$total_rts_maret}}</td>
          <td>{{$paid_rts_maret}}</td>
          <td>{{$sudah_tl_maret}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_maret), 0, 5) !!} %</td>
          <td>{{$belum_tl_maret}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_maret), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_maret}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_maret), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_maret)
            {{\Carbon\Carbon::parse($tanggal_upload_maret)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">APR</td>
          <td>{{$total_rts_april}}</td>
          <td>{{$paid_rts_april}}</td>
          <td>{{$sudah_tl_april}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_april), 0, 5) !!} %</td>
          <td>{{$belum_tl_april}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_april), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_april}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_april), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_april)
            {{\Carbon\Carbon::parse($tanggal_upload_april)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">MEI</td>
          <td>{{$total_rts_mei}}</td>
          <td>{{$paid_rts_mei}}</td>
          <td>{{$sudah_tl_mei}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_mei), 0, 5) !!} %</td>
          <td>{{$belum_tl_mei}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_mei), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_mei}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_mei), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_mei)
            {{\Carbon\Carbon::parse($tanggal_upload_mei)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">JUN</td>
          <td>{{$total_rts_juni}}</td>
          <td>{{$paid_rts_juni}}</td>
          <td>{{$sudah_tl_juni}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_juni), 0, 5) !!} %</td>
          <td>{{$belum_tl_juni}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_juni), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_juni}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_juni), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_juni)
            {{\Carbon\Carbon::parse($tanggal_upload_juni)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">JUL</td>
          <td>{{$total_rts_juli}}</td>
          <td>{{$paid_rts_juli}}</td>
          <td>{{$sudah_tl_juli}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_juli), 0, 5) !!} %</td>
          <td>{{$belum_tl_juli}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_juli), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_juli}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_juli), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_juli)
            {{\Carbon\Carbon::parse($tanggal_upload_juli)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">AUG</td>
          <td>{{$total_rts_agustus}}</td>
          <td>{{$paid_rts_agustus}}</td>
          <td>{{$sudah_tl_agustus}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_agustus), 0, 5) !!} %</td>
          <td>{{$belum_tl_agustus}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_agustus), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_agustus}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_agustus), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_agustus)
            {{\Carbon\Carbon::parse($tanggal_upload_agustus)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">SEP</td>
          <td>{{$total_rts_september}}</td>
          <td>{{$paid_rts_september}}</td>
          <td>{{$sudah_tl_september}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_september), 0, 5) !!} %</td>
          <td>{{$belum_tl_september}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_september), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_september}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_september), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_september)
            {{\Carbon\Carbon::parse($tanggal_upload_september)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">OKT</td>
          <td>{{$total_rts_oktober}}</td>
          <td>{{$paid_rts_oktober}}</td>
          <td>{{$sudah_tl_oktober}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_oktober), 0, 5) !!} %</td>
          <td>{{$belum_tl_oktober}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_oktober), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_oktober}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_oktober), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_oktober)
            {{\Carbon\Carbon::parse($tanggal_upload_oktober)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">NOV</td>
          <td>{{$total_rts_november}}</td>
          <td>{{$paid_rts_november}}</td>
          <td>{{$sudah_tl_november}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_november), 0, 5) !!} %</td>
          <td>{{$belum_tl_november}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_november), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_november}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_november), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_november)
            {{\Carbon\Carbon::parse($tanggal_upload_november)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
         <tr>
          <td class="tg-0lax">DES</td>
          <td>{{$total_rts_desember}}</td>
          <td>{{$paid_rts_desember}}</td>
          <td>{{$sudah_tl_desember}}</td>
          <td>{!!  substr(strip_tags($percent_sudah_tl_desember), 0, 5) !!} %</td>
          <td>{{$belum_tl_desember}}</td>
          <td>{!!  substr(strip_tags($percent_belum_tl_desember), 0, 5) !!} %</td>
          <td>{{$jumlah_rt_desember}}</td>
          <td>{!!  substr(strip_tags($percent_jumlah_rt_desember), 0, 5) !!} %</td>
          <td>
            @if($tanggal_upload_desember)
            {{\Carbon\Carbon::parse($tanggal_upload_desember)
             ->format('d, M Y')}}
             @else
             Belum Mengirim
             @endif
           </td>
         </tr>
       </table>
      <hr>
    </div>
  </center>
</body>
</html>