Home Explore Help
Sign In
deploy_djid
/
djid_siput
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: main
Branches Tags
djid_siput
/
resources
/
views
/
templates
/
SPP
/
RT
/
dev
/
print-upt-tahun-not-paid.blade.php

print-upt-tahun-not-paid.blade.php 58 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682 
  1. <!DOCTYPE html>
    2. 

  2. <?php 
    3. 

  3.   $getStatus = \App\Model\Privillage\Role::where('id',Auth::user()->role_id)->value('akses'); 
    4. 

  4.   $getUptName = \App\Model\Setting\UPT::where('office_id',$getUptId)->distinct()->value('office_name'); 
    5. 

  5. ?>
    6. 

  6. <html>
    7. 

  7. <head>
    8. 

  8.   <style>
    9. 

  9.     .table-bordered {
    10. 

  10.         border-collapse: collapse;
    11. 

  11.         width: 100%;
    12. 

  12.     }
    13. 

  13. 

  14.     .table-bordered td, .table-bordered th {
    15. 

  15.         border: 1px solid black;
    16. 

  16.         padding: 8px;
    17. 

  17.     }
    18. 

  18.     .thead-light{
    19. 

  19.       background-color: #E9ECEF;
    20. 

  20.     }
    21. 

  21.     .table-bordered th {
    22. 

  22.       padding-top: 12px;
    23. 

  23.       padding-bottom: 12px;
    24. 

  24.       text-align: left;
    25. 

  25.     }
    26. 

  26.   </style>
    27. 

  27. </head>
    28. 

  28. <body>
    29. 

  29.   <center>
    30. 

  30.     <div>
    31. 

  31.       <hr>
    32. 

  32.       <h2 class="font-weight-bolder">REKAPITULASI DAN PERSENTASE AKSI PENCEGAHAN PIUTANG</h2>
    33. 

  33.       <hr>
    34. 

  34.       <table id="example" class="table table-bordered align-items-center">
    35. 

  35.           <thead class="thead-light">
    36. 

  36.               <tr>
    37. 

  37.                 <th class="tg-0pky" colspan="3"></th>
    38. 

  38.                 <th class="tg-0lax" colspan="4" style="background-color: #63a53a; color: #fff; text-align: center;">RT BELUM TERBAYAR (H-30 s.d H)</th>
    39. 

  39.                 <th class="tg-0lax" colspan="3" style="background-color: #ff1228; color: #fff;">RT TIDAK TERBAYAR (MENJADI REMINDER)</th>
    40. 

  40.               </tr>
    41. 

  41.               <tr>
    42. 

  42.                 <td class="tg-0lax">BULAN</td>
    43. 

  43.                 <td class="tg-0lax">TOTAL RT TERBIT</td>
    44. 

  44.                 <td class="tg-0lax">RT TERBAYAR</td>
    45. 

  45.                 <td class="tg-0lax">SUDAH DI-TL UPT</td>
    46. 

  46.                 <td class="tg-0lax">%</td>
    47. 

  47.                 <td class="tg-0lax">BELUM DI-TL UPT</td>
    48. 

  48.                 <td class="tg-0lax">%</td>
    49. 

  49.                 <td class="tg-0lax">JUMLAH RT</td>
    50. 

  50.                 <td class="tg-0lax">%</td>
    51. 

  51.                 <td class="tg-0lax">Tanggal Upload</td>
    52. 

  52.               </tr>
    53. 

  53.             </thead>
    54. 

  54.             <?php
    55. 

  55.             $fixYear = $year - 1;
    56. 

  56. 

  57.             if($getStatus == 'administrator'){
    58. 

  58. 

  59.               //Januari
    60. 

  60.               $paid_rts_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',12)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    61. 

  61.               $nopaid_rts_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',12)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    62. 

  62.               $total_rts_januari = $paid_rts_januari + $nopaid_rts_januari;
    63. 

  63.               $sudah_tl_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',12)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$fixYear)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    64. 

  64.               $belum_tl_januari = $total_rts_januari - $sudah_tl_januari;
    65. 

  65.               $percent_sudah_tl_januari = $sudah_tl_januari / $total_rts_januari * 100;
    66. 

  66.               $percent_belum_tl_januari = $belum_tl_januari / $total_rts_januari * 100;
    67. 

  67.               $jumlah_rt_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',12)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    68. 

  68.               if ($jumlah_rt_januari != 0) {
    69. 

  69.                 $percent_jumlah_rt_januari = $jumlah_rt_januari / $total_rts_januari * 100;
    70. 

  70.               }else{
    71. 

  71.                 $percent_jumlah_rt_januari = 0;
    72. 

  72.               }
    73. 

  73.               $tanggal_upload_januari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',12)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$fixYear)->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->select('updated_at')->distinct()->value('updated_at');
    74. 

  74. 

  75.               //Februari
    76. 

  76.               $paid_rts_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',1)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    77. 

  77.               $nopaid_rts_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',1)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    78. 

  78.               $total_rts_februari = $paid_rts_februari + $nopaid_rts_februari;
    79. 

  79.               $sudah_tl_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',1)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    80. 

  80.               $belum_tl_februari = $total_rts_februari - $sudah_tl_februari;
    81. 

  81.               $percent_sudah_tl_februari = $sudah_tl_februari / $total_rts_februari * 100;
    82. 

  82.               $percent_belum_tl_februari = $belum_tl_februari / $total_rts_februari * 100;
    83. 

  83.               $jumlah_rt_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',1)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    84. 

  84.               if ($jumlah_rt_februari != 0) {
    85. 

  85.                 $percent_jumlah_rt_februari = $jumlah_rt_februari / $total_rts_februari * 100;
    86. 

  86.               }else{
    87. 

  87.                 $percent_jumlah_rt_februari = 0;
    88. 

  88.               }
    89. 

  89.               $tanggal_upload_februari = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',1)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->select('updated_at')->distinct()->value('updated_at');
    90. 

  90. 

  91.               //Maret
    92. 

  92.               $paid_rts_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',2)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    93. 

  93.               $nopaid_rts_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',2)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    94. 

  94.               $total_rts_maret = $paid_rts_maret + $nopaid_rts_maret;
    95. 

  95.               $sudah_tl_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',2)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    96. 

  96.               $belum_tl_maret = $total_rts_maret - $sudah_tl_maret;
    97. 

  97.               $percent_sudah_tl_maret = $sudah_tl_maret / $total_rts_maret * 100;
    98. 

  98.               $percent_belum_tl_maret = $belum_tl_maret / $total_rts_maret * 100;
    99. 

  99.               $jumlah_rt_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',2)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    100. 

  100.               if ($jumlah_rt_maret != 0) {
    101. 

  101.                 $percent_jumlah_rt_maret =  $jumlah_rt_maret / $total_rts_maret * 100;
    102. 

  102.               }else{
    103. 

  103.                 $percent_jumlah_rt_maret = 0;
    104. 

  104.               }
    105. 

  105.               $tanggal_upload_maret = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',2)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    106. 

  106. 

  107.               //April
    108. 

  108.               $paid_rts_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',3)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    109. 

  109.               $nopaid_rts_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',3)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    110. 

  110.               $total_rts_april = $paid_rts_april + $nopaid_rts_april;
    111. 

  111.               $sudah_tl_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',3)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    112. 

  112.               $belum_tl_april = $total_rts_april - $sudah_tl_april;
    113. 

  113.               $percent_sudah_tl_april = $sudah_tl_april / $total_rts_april * 100;
    114. 

  114.               $percent_belum_tl_april = $belum_tl_april / $total_rts_april * 100;
    115. 

  115.               $jumlah_rt_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',3)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    116. 

  116.               if ($jumlah_rt_april != 0) {
    117. 

  117.                 $percent_jumlah_rt_april = $jumlah_rt_april/ $total_rts_april * 100;
    118. 

  118.               }else{
    119. 

  119.                 $percent_jumlah_rt_april = 0;
    120. 

  120.               }
    121. 

  121.               $tanggal_upload_april = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',3)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    122. 

  122. 

  123.               //Mei
    124. 

  124. 

  125.               $paid_rts_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',4)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    126. 

  126.               $nopaid_rts_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',4)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    127. 

  127.               $total_rts_mei = $paid_rts_mei + $nopaid_rts_mei;
    128. 

  128.               $sudah_tl_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',4)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    129. 

  129.               $belum_tl_mei = $total_rts_mei - $sudah_tl_mei;
    130. 

  130.               $percent_sudah_tl_mei = $sudah_tl_mei / $total_rts_mei * 100;
    131. 

  131.               $percent_belum_tl_mei = $belum_tl_mei / $total_rts_mei * 100;
    132. 

  132.               $jumlah_rt_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',4)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    133. 

  133.               if ($jumlah_rt_mei != 0) {
    134. 

  134.                 $percent_jumlah_rt_mei =  $jumlah_rt_mei / $total_rts_mei * 100;
    135. 

  135.               }else{
    136. 

  136.                 $percent_jumlah_rt_mei = 0;
    137. 

  137.               }
    138. 

  138.               $tanggal_upload_mei = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',4)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    139. 

  139. 

  140.               //Juni
    141. 

  141.               $paid_rts_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',5)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    142. 

  142.               $nopaid_rts_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',5)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    143. 

  143.               $total_rts_juni = $paid_rts_juni + $nopaid_rts_juni;
    144. 

  144.               $sudah_tl_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',5)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    145. 

  145.               $belum_tl_juni = $total_rts_juni - $sudah_tl_juni;
    146. 

  146.               $percent_sudah_tl_juni = $sudah_tl_juni / $total_rts_juni * 100;
    147. 

  147.               $percent_belum_tl_juni = $belum_tl_juni / $total_rts_juni * 100;
    148. 

  148.               $jumlah_rt_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',5)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    149. 

  149.               if ($jumlah_rt_juni != 0) {
    150. 

  150.                 $percent_jumlah_rt_juni =  $jumlah_rt_juni / $total_rts_juni * 100;
    151. 

  151.               }else{
    152. 

  152.                 $percent_jumlah_rt_juni = 0;
    153. 

  153.               }
    154. 

  154.               $tanggal_upload_juni = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',5)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    155. 

  155. 

  156.               //Juli
    157. 

  157.               $paid_rts_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',6)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    158. 

  158.               $nopaid_rts_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',6)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    159. 

  159.               $total_rts_juli = $paid_rts_juli + $nopaid_rts_juli;
    160. 

  160.               $sudah_tl_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',6)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('status',1)->count();
    161. 

  161.               $belum_tl_juli = $total_rts_juli - $sudah_tl_juli;
    162. 

  162.               $percent_sudah_tl_juli = $sudah_tl_juli / $total_rts_juli * 100;
    163. 

  163.               $percent_belum_tl_juli = $belum_tl_juli / $total_rts_juli * 100;
    164. 

  164.               $jumlah_rt_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',6)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    165. 

  165.               if ($jumlah_rt_juli != 0) {
    166. 

  166.                 $percent_jumlah_rt_juli = $jumlah_rt_juli / $total_rts_juli * 100;
    167. 

  167.               }else{
    168. 

  168.                 $percent_jumlah_rt_juli = 0;
    169. 

  169.               }
    170. 

  170.               $tanggal_upload_juli = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',6)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    171. 

  171. 

  172.               //Agustus
    173. 

  173.               $paid_rts_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',7)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    174. 

  174.               $nopaid_rts_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',7)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    175. 

  175.               $total_rts_agustus = $paid_rts_agustus + $nopaid_rts_agustus;
    176. 

  176.               $sudah_tl_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',7)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    177. 

  177.               $belum_tl_agustus = $total_rts_agustus - $sudah_tl_agustus;
    178. 

  178.               $percent_sudah_tl_agustus = $sudah_tl_agustus / $total_rts_agustus * 100;
    179. 

  179.               $percent_belum_tl_agustus = $belum_tl_agustus / $total_rts_agustus * 100;
    180. 

  180.               $jumlah_rt_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',7)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    181. 

  181.               if ($jumlah_rt_agustus != 0) {
    182. 

  182.                 $percent_jumlah_rt_agustus =  $jumlah_rt_agustus / $total_rts_agustus * 100;
    183. 

  183.               }else{
    184. 

  184.                 $percent_jumlah_rt_agustus = 0;
    185. 

  185.               }
    186. 

  186.               $tanggal_upload_agustus = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',7)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    187. 

  187. 

  188.               //September
    189. 

  189.               $paid_rts_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',8)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    190. 

  190.               $nopaid_rts_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',8)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    191. 

  191.               $total_rts_september = $paid_rts_september + $nopaid_rts_september;
    192. 

  192.               $sudah_tl_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',8)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    193. 

  193.               $belum_tl_september = $total_rts_september - $sudah_tl_september;
    194. 

  194.               $percent_sudah_tl_september = $sudah_tl_september / $total_rts_september * 100;
    195. 

  195.               $percent_belum_tl_september = $belum_tl_september / $total_rts_september * 100;
    196. 

  196.               $jumlah_rt_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',8)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    197. 

  197.               if ($jumlah_rt_september != 0) {
    198. 

  198.                 $percent_jumlah_rt_september =  $jumlah_rt_september / $total_rts_september * 100;
    199. 

  199.               }else{
    200. 

  200.                 $percent_jumlah_rt_september = 0;
    201. 

  201.               }
    202. 

  202.               $tanggal_upload_september = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',8)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    203. 

  203. 

  204.               //Oktober
    205. 

  205.               $paid_rts_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',9)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    206. 

  206.               $nopaid_rts_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',9)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    207. 

  207.               $total_rts_oktober = $paid_rts_oktober + $nopaid_rts_oktober;
    208. 

  208.               $sudah_tl_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',9)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    209. 

  209.               $belum_tl_oktober = $total_rts_oktober - $sudah_tl_oktober;
    210. 

  210.               $percent_sudah_tl_oktober = $sudah_tl_oktober / $total_rts_oktober * 100;
    211. 

  211.               $percent_belum_tl_oktober = $belum_tl_oktober / $total_rts_oktober * 100;
    212. 

  212.               $jumlah_rt_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',9)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    213. 

  213.               if ($jumlah_rt_oktober != 0) {
    214. 

  214.                 $percent_jumlah_rt_oktober = $jumlah_rt_oktober / $total_rts_oktober * 100;
    215. 

  215.               }else{
    216. 

  216.                 $percent_jumlah_rt_oktober = 0;
    217. 

  217.               }
    218. 

  218.               $tanggal_upload_oktober = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',9)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    219. 

  219. 

  220.               //November
    221. 

  221.               $paid_rts_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',10)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    222. 

  222.               $nopaid_rts_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',10)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    223. 

  223.               $total_rts_november = $paid_rts_november + $nopaid_rts_november;
    224. 

  224.               $sudah_tl_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',10)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    225. 

  225.               $belum_tl_november = $total_rts_november - $sudah_tl_november;
    226. 

  226.               $percent_sudah_tl_november = $sudah_tl_november / $total_rts_november * 100;
    227. 

  227.               $percent_belum_tl_november = $belum_tl_november / $total_rts_november * 100;
    228. 

  228.               $jumlah_rt_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',10)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    229. 

  229.               if ($jumlah_rt_november != 0) {
    230. 

  230.                 $percent_jumlah_rt_november =  $jumlah_rt_november / $total_rts_november * 100;
    231. 

  231.               }else{
    232. 

  232.                 $percent_jumlah_rt_november = 0;
    233. 

  233.               }
    234. 

  234.               $tanggal_upload_november = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',10)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    235. 

  235. 

  236.               //Desember
    237. 

  237.               $paid_rts_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',11)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    238. 

  238.               $nopaid_rts_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',11)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    239. 

  239.               $total_rts_desember = $paid_rts_desember + $nopaid_rts_desember;
    240. 

  240.               $sudah_tl_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',11)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    241. 

  241.               $belum_tl_desember = $total_rts_desember - $sudah_tl_desember;
    242. 

  242.               $percent_sudah_tl_desember = $sudah_tl_desember / $total_rts_desember * 100;
    243. 

  243.               $percent_belum_tl_desember = $belum_tl_desember / $total_rts_desember * 100;
    244. 

  244.               $jumlah_rt_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',11)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    245. 

  245.               if ($jumlah_rt_desember != 0) {
    246. 

  246.                 $percent_jumlah_rt_desember =  $jumlah_rt_desember / $total_rts_desember * 100;
    247. 

  247.               }else{
    248. 

  248.                 $percent_jumlah_rt_desember = 0;
    249. 

  249.               }
    250. 

  250.               $tanggal_upload_desember = \App\Model\SPP\RincianTagihan::whereMonth('bi_begin',11)->where('upt', $getUptName)->orWhereNull('upt')->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    251. 

  251. 

  252. 

  253. 

  254.               }else{
    255. 

  255.                     //Januari
    256. 

  256.                     $paid_rts_januari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',12)->whereYear('bi_begin',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    257. 

  257.                     $nopaid_rts_januari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',12)->whereYear('bi_begin',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    258. 

  258.                     $total_rts_januari = $paid_rts_januari + $nopaid_rts_januari;
    259. 

  259.                     $sudah_tl_januari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',12)->whereYear('bi_begin',$fixYear)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    260. 

  260.                     $belum_tl_januari = $total_rts_januari - $sudah_tl_januari;
    261. 

  261.                     $percent_sudah_tl_januari = $sudah_tl_januari / $total_rts_januari * 100;
    262. 

  262.                     $percent_belum_tl_januari = $belum_tl_januari / $total_rts_januari * 100;
    263. 

  263.                     $jumlah_rt_januari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',12)->whereYear('bi_begin',$fixYear)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    264. 

  264.                     if ($jumlah_rt_januari != 0) {
    265. 

  265.                       $percent_jumlah_rt_januari = $jumlah_rt_januari / $total_rts_januari * 100;
    266. 

  266.                     }else{
    267. 

  267.                       $percent_jumlah_rt_januari = 0;
    268. 

  268.                     }
    269. 

  269.                     $tanggal_upload_januari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',12)->whereYear('bi_begin',$fixYear)->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->select('updated_at')->distinct()->value('updated_at');
    270. 

  270. 

  271.                     //Februari
    272. 

  272.                     $paid_rts_februari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',1)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    273. 

  273.                     $nopaid_rts_februari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',1)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    274. 

  274.                     $total_rts_februari = $paid_rts_februari + $nopaid_rts_februari;
    275. 

  275.                     $sudah_tl_februari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',1)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    276. 

  276.                     $belum_tl_februari = $total_rts_februari - $sudah_tl_februari;
    277. 

  277.                     $percent_sudah_tl_februari = $sudah_tl_februari / $total_rts_februari * 100;
    278. 

  278.                     $percent_belum_tl_februari = $belum_tl_februari / $total_rts_februari * 100;
    279. 

  279.                     $jumlah_rt_februari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',1)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    280. 

  280.                     if ($jumlah_rt_februari != 0) {
    281. 

  281.                       $percent_jumlah_rt_februari = $jumlah_rt_februari / $total_rts_februari * 100;
    282. 

  282.                     }else{
    283. 

  283.                       $percent_jumlah_rt_februari = 0;
    284. 

  284.                     }
    285. 

  285.                     $tanggal_upload_februari = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',1)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->select('updated_at')->distinct()->value('updated_at');
    286. 

  286. 

  287.                     //Maret
    288. 

  288.                     $paid_rts_maret = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',2)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    289. 

  289.                     $nopaid_rts_maret = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',2)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    290. 

  290.                     $total_rts_maret = $paid_rts_maret + $nopaid_rts_maret;
    291. 

  291.                     $sudah_tl_maret = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',2)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    292. 

  292.                     $belum_tl_maret = $total_rts_maret - $sudah_tl_maret;
    293. 

  293.                     $percent_sudah_tl_maret = $sudah_tl_maret / $total_rts_maret * 100;
    294. 

  294.                     $percent_belum_tl_maret = $belum_tl_maret / $total_rts_maret * 100;
    295. 

  295.                     $jumlah_rt_maret = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',2)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    296. 

  296.                     if ($jumlah_rt_maret != 0) {
    297. 

  297.                       $percent_jumlah_rt_maret =  $jumlah_rt_maret / $total_rts_maret * 100;
    298. 

  298.                     }else{
    299. 

  299.                       $percent_jumlah_rt_maret = 0;
    300. 

  300.                     }
    301. 

  301.                     $tanggal_upload_maret = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',2)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    302. 

  302. 

  303.                     //April
    304. 

  304.                     $paid_rts_april = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',3)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    305. 

  305.                     $nopaid_rts_april = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',3)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    306. 

  306.                     $total_rts_april = $paid_rts_april + $nopaid_rts_april;
    307. 

  307.                     $sudah_tl_april = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',3)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    308. 

  308.                     $belum_tl_april = $total_rts_april - $sudah_tl_april;
    309. 

  309.                     $percent_sudah_tl_april = $sudah_tl_april / $total_rts_april * 100;
    310. 

  310.                     $percent_belum_tl_april = $belum_tl_april / $total_rts_april * 100;
    311. 

  311.                     $jumlah_rt_april = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',3)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    312. 

  312.                     if ($jumlah_rt_april != 0) {
    313. 

  313.                       $percent_jumlah_rt_april = $jumlah_rt_april/ $total_rts_april * 100;
    314. 

  314.                     }else{
    315. 

  315.                       $percent_jumlah_rt_april = 0;
    316. 

  316.                     }
    317. 

  317.                     $tanggal_upload_april = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',3)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    318. 

  318. 

  319.                     //Mei
    320. 

  320. 

  321.                     $paid_rts_mei = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',4)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    322. 

  322.                     $nopaid_rts_mei = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',4)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    323. 

  323.                     $total_rts_mei = $paid_rts_mei + $nopaid_rts_mei;
    324. 

  324.                     $sudah_tl_mei = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',4)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    325. 

  325.                     $belum_tl_mei = $total_rts_mei - $sudah_tl_mei;
    326. 

  326.                     $percent_sudah_tl_mei = $sudah_tl_mei / $total_rts_mei * 100;
    327. 

  327.                     $percent_belum_tl_mei = $belum_tl_mei / $total_rts_mei * 100;
    328. 

  328.                     $jumlah_rt_mei = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',4)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    329. 

  329.                     if ($jumlah_rt_mei != 0) {
    330. 

  330.                       $percent_jumlah_rt_mei =  $jumlah_rt_mei / $total_rts_mei * 100;
    331. 

  331.                     }else{
    332. 

  332.                       $percent_jumlah_rt_mei = 0;
    333. 

  333.                     }
    334. 

  334.                     $tanggal_upload_mei = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',4)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    335. 

  335. 

  336.                     //Juni
    337. 

  337.                     $paid_rts_juni = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',5)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    338. 

  338.                     $nopaid_rts_juni = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',5)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    339. 

  339.                     $total_rts_juni = $paid_rts_juni + $nopaid_rts_juni;
    340. 

  340.                     $sudah_tl_juni = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',5)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    341. 

  341.                     $belum_tl_juni = $total_rts_juni - $sudah_tl_juni;
    342. 

  342.                     $percent_sudah_tl_juni = $sudah_tl_juni / $total_rts_juni * 100;
    343. 

  343.                     $percent_belum_tl_juni = $belum_tl_juni / $total_rts_juni * 100;
    344. 

  344.                     $jumlah_rt_juni = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',5)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    345. 

  345.                     if ($jumlah_rt_juni != 0) {
    346. 

  346.                       $percent_jumlah_rt_juni =  $jumlah_rt_juni / $total_rts_juni * 100;
    347. 

  347.                     }else{
    348. 

  348.                       $percent_jumlah_rt_juni = 0;
    349. 

  349.                     }
    350. 

  350.                     $tanggal_upload_juni = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',5)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    351. 

  351. 

  352.                     //Juli
    353. 

  353.                     $paid_rts_juli = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',6)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    354. 

  354.                     $nopaid_rts_juli = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',6)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    355. 

  355.                     $total_rts_juli = $paid_rts_juli + $nopaid_rts_juli;
    356. 

  356.                     $sudah_tl_juli = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',6)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('status',1)->count();
    357. 

  357.                     $belum_tl_juli = $total_rts_juli - $sudah_tl_juli;
    358. 

  358.                     $percent_sudah_tl_juli = $sudah_tl_juli / $total_rts_juli * 100;
    359. 

  359.                     $percent_belum_tl_juli = $belum_tl_juli / $total_rts_juli * 100;
    360. 

  360.                     $jumlah_rt_juli = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',6)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    361. 

  361.                     if ($jumlah_rt_juli != 0) {
    362. 

  362.                       $percent_jumlah_rt_juli = $jumlah_rt_juli / $total_rts_juli * 100;
    363. 

  363.                     }else{
    364. 

  364.                       $percent_jumlah_rt_juli = 0;
    365. 

  365.                     }
    366. 

  366.                     $tanggal_upload_juli = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',6)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    367. 

  367. 

  368.                     //Agustus
    369. 

  369.                     $paid_rts_agustus = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',7)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    370. 

  370.                     $nopaid_rts_agustus = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',7)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    371. 

  371.                     $total_rts_agustus = $paid_rts_agustus + $nopaid_rts_agustus;
    372. 

  372.                     $sudah_tl_agustus = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',7)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    373. 

  373.                     $belum_tl_agustus = $total_rts_agustus - $sudah_tl_agustus;
    374. 

  374.                     $percent_sudah_tl_agustus = $sudah_tl_agustus / $total_rts_agustus * 100;
    375. 

  375.                     $percent_belum_tl_agustus = $belum_tl_agustus / $total_rts_agustus * 100;
    376. 

  376.                     $jumlah_rt_agustus = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',7)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    377. 

  377.                     if ($jumlah_rt_agustus != 0) {
    378. 

  378.                       $percent_jumlah_rt_agustus =  $jumlah_rt_agustus / $total_rts_agustus * 100;
    379. 

  379.                     }else{
    380. 

  380.                       $percent_jumlah_rt_agustus = 0;
    381. 

  381.                     }
    382. 

  382.                     $tanggal_upload_agustus = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',7)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    383. 

  383. 

  384.                     //September
    385. 

  385.                     $paid_rts_september = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',8)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    386. 

  386.                     $nopaid_rts_september = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',8)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    387. 

  387.                     $total_rts_september = $paid_rts_september + $nopaid_rts_september;
    388. 

  388.                     $sudah_tl_september = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',8)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    389. 

  389.                     $belum_tl_september = $total_rts_september - $sudah_tl_september;
    390. 

  390.                     $percent_sudah_tl_september = $sudah_tl_september / $total_rts_september * 100;
    391. 

  391.                     $percent_belum_tl_september = $belum_tl_september / $total_rts_september * 100;
    392. 

  392.                     $jumlah_rt_september = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',8)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    393. 

  393.                     if ($jumlah_rt_september != 0) {
    394. 

  394.                       $percent_jumlah_rt_september =  $jumlah_rt_september / $total_rts_september * 100;
    395. 

  395.                     }else{
    396. 

  396.                       $percent_jumlah_rt_september = 0;
    397. 

  397.                     }
    398. 

  398.                     $tanggal_upload_september = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',8)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    399. 

  399. 

  400.                     //Oktober
    401. 

  401.                     $paid_rts_oktober = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',9)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    402. 

  402.                     $nopaid_rts_oktober = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',9)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    403. 

  403.                     $total_rts_oktober = $paid_rts_oktober + $nopaid_rts_oktober;
    404. 

  404.                     $sudah_tl_oktober = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',9)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    405. 

  405.                     $belum_tl_oktober = $total_rts_oktober - $sudah_tl_oktober;
    406. 

  406.                     $percent_sudah_tl_oktober = $sudah_tl_oktober / $total_rts_oktober * 100;
    407. 

  407.                     $percent_belum_tl_oktober = $belum_tl_oktober / $total_rts_oktober * 100;
    408. 

  408.                     $jumlah_rt_oktober = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',9)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    409. 

  409.                     if ($jumlah_rt_oktober != 0) {
    410. 

  410.                       $percent_jumlah_rt_oktober = $jumlah_rt_oktober / $total_rts_oktober * 100;
    411. 

  411.                     }else{
    412. 

  412.                       $percent_jumlah_rt_oktober = 0;
    413. 

  413.                     }
    414. 

  414.                     $tanggal_upload_oktober = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',9)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    415. 

  415. 

  416.                     //November
    417. 

  417.                     $paid_rts_november = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',10)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    418. 

  418.                     $nopaid_rts_november = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',10)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    419. 

  419.                     $total_rts_november = $paid_rts_november + $nopaid_rts_november;
    420. 

  420.                     $sudah_tl_november = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',10)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    421. 

  421.                     $belum_tl_november = $total_rts_november - $sudah_tl_november;
    422. 

  422.                     $percent_sudah_tl_november = $sudah_tl_november / $total_rts_november * 100;
    423. 

  423.                     $percent_belum_tl_november = $belum_tl_november / $total_rts_november * 100;
    424. 

  424.                     $jumlah_rt_november = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',10)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    425. 

  425.                     if ($jumlah_rt_november != 0) {
    426. 

  426.                       $percent_jumlah_rt_november =  $jumlah_rt_november / $total_rts_november * 100;
    427. 

  427.                     }else{
    428. 

  428.                       $percent_jumlah_rt_november = 0;
    429. 

  429.                     }
    430. 

  430.                     $tanggal_upload_november = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',10)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    431. 

  431. 

  432.                     //Desember
    433. 

  433.                     $paid_rts_desember = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',11)->whereYear('bi_begin',$year)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    434. 

  434.                     $nopaid_rts_desember = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',11)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    435. 

  435.                     $total_rts_desember = $paid_rts_desember + $nopaid_rts_desember;
    436. 

  436.                     $sudah_tl_desember = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',11)->whereYear('bi_begin',$year)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->where('active',1)->count();
    437. 

  437.                     $belum_tl_desember = $total_rts_desember - $sudah_tl_desember;
    438. 

  438.                     $percent_sudah_tl_desember = $sudah_tl_desember / $total_rts_desember * 100;
    439. 

  439.                     $percent_belum_tl_desember = $belum_tl_desember / $total_rts_desember * 100;
    440. 

  440.                     $jumlah_rt_desember = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',11)->whereYear('bi_begin',$year)->where('status','not paid')->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->count();
    441. 

  441.                     if ($jumlah_rt_desember != 0) {
    442. 

  442.                       $percent_jumlah_rt_desember =  $jumlah_rt_desember / $total_rts_desember * 100;
    443. 

  443.                     }else{
    444. 

  444.                       $percent_jumlah_rt_desember = 0;
    445. 

  445.                     }
    446. 

  446.                     $tanggal_upload_desember = \App\Model\SPP\RincianTagihan::where('upt', Auth::user()->upt)->whereMonth('bi_begin',11)->whereYear('bi_begin',$year)->select('updated_at')->where('active',1)->where('status_izin','Perpanjangan')->where('katagori_spp','Pokok')->distinct()->value('updated_at');
    447. 

  447.             }
    448. 

  448.               ?>
    449. 

  449.             <tr>
    450. 

  450.               <td class="tg-0lax">JAN</td>
    451. 

  451.               <td>{{$total_rts_januari}}</td>
    452. 

  452.               <td>{{$paid_rts_januari}}</td>
    453. 

  453.               <td>{{$sudah_tl_januari}}</td>
    454. 

  454.               <td>{!!  substr(strip_tags($percent_sudah_tl_januari), 0, 5) !!} %</td>
    455. 

  455.               <td>{{$belum_tl_januari}}</td>
    456. 

  456.               <td>{!!  substr(strip_tags($percent_belum_tl_januari), 0, 5) !!} %</td>
    457. 

  457.               <td>{{$jumlah_rt_januari}}</td>
    458. 

  458.               <td>{!!  substr(strip_tags($percent_jumlah_rt_januari), 0, 5) !!} %</td>
    459. 

  459.               <td>
    460. 

  460.                 @if($tanggal_upload_januari)
    461. 

  461.                 {{\Carbon\Carbon::parse($tanggal_upload_januari)
    462. 

  462.                        ->format('d, M Y')}}
    463. 

  463.                 @else
    464. 

  464.                 Belum Mengirim
    465. 

  465.                 @endif
    466. 

  466.               </td>
    467. 

  467.             </tr>
    468. 

  468.             <tr>
    469. 

  469.               <td class="tg-0lax">FEB</td>
    470. 

  470.               <td>{{$total_rts_februari}}</td>
    471. 

  471.               <td>{{$paid_rts_februari}}</td>
    472. 

  472.               <td>{{$sudah_tl_februari}}</td>
    473. 

  473.               <td>{!!  substr(strip_tags($percent_sudah_tl_februari), 0, 5) !!} %</td>
    474. 

  474.               <td>{{$belum_tl_februari}}</td>
    475. 

  475.               <td>{!!  substr(strip_tags($percent_belum_tl_februari), 0, 5) !!} %</td>
    476. 

  476.               <td>{{$jumlah_rt_februari}}</td>
    477. 

  477.               <td>{!!  substr(strip_tags($percent_jumlah_rt_februari), 0, 5) !!} %</td>
    478. 

  478.               <td>
    479. 

  479.                 @if($tanggal_upload_februari)
    480. 

  480.                {{\Carbon\Carbon::parse($tanggal_upload_februari)
    481. 

  481.                        ->format('d, M Y')}}
    482. 

  482.                 @else
    483. 

  483.                 Belum Mengirim
    484. 

  484.                 @endif
    485. 

  485.               </td>
    486. 

  486.             </tr>
    487. 

  487.             <tr>
    488. 

  488.               <td class="tg-0lax">MAR</td>
    489. 

  489.               <td>{{$total_rts_maret}}</td>
    490. 

  490.               <td>{{$paid_rts_maret}}</td>
    491. 

  491.               <td>{{$sudah_tl_maret}}</td>
    492. 

  492.               <td>{!!  substr(strip_tags($percent_sudah_tl_maret), 0, 5) !!} %</td>
    493. 

  493.               <td>{{$belum_tl_maret}}</td>
    494. 

  494.               <td>{!!  substr(strip_tags($percent_belum_tl_maret), 0, 5) !!} %</td>
    495. 

  495.               <td>{{$jumlah_rt_maret}}</td>
    496. 

  496.               <td>{!!  substr(strip_tags($percent_jumlah_rt_maret), 0, 5) !!} %</td>
    497. 

  497.               <td>
    498. 

  498.                 @if($tanggal_upload_maret)
    499. 

  499.                 {{\Carbon\Carbon::parse($tanggal_upload_maret)
    500. 

  500.                    ->format('d, M Y')}}
    501. 

  501.                 @else
    502. 

  502.                 Belum Mengirim
    503. 

  503.                 @endif
    504. 

  504.               </td>
    505. 

  505.             </tr>
    506. 

  506.             <tr>
    507. 

  507.               <td class="tg-0lax">APR</td>
    508. 

  508.               <td>{{$total_rts_april}}</td>
    509. 

  509.               <td>{{$paid_rts_april}}</td>
    510. 

  510.               <td>{{$sudah_tl_april}}</td>
    511. 

  511.               <td>{!!  substr(strip_tags($percent_sudah_tl_april), 0, 5) !!} %</td>
    512. 

  512.               <td>{{$belum_tl_april}}</td>
    513. 

  513.               <td>{!!  substr(strip_tags($percent_belum_tl_april), 0, 5) !!} %</td>
    514. 

  514.               <td>{{$jumlah_rt_april}}</td>
    515. 

  515.               <td>{!!  substr(strip_tags($percent_jumlah_rt_april), 0, 5) !!} %</td>
    516. 

  516.               <td>
    517. 

  517.                 @if($tanggal_upload_april)
    518. 

  518.                 {{\Carbon\Carbon::parse($tanggal_upload_april)
    519. 

  519.                        ->format('d, M Y')}}
    520. 

  520.                 @else
    521. 

  521.                 Belum Mengirim
    522. 

  522.                 @endif
    523. 

  523.               </td>
    524. 

  524.             </tr>
    525. 

  525.             <tr>
    526. 

  526.               <td class="tg-0lax">MEI</td>
    527. 

  527.               <td>{{$total_rts_mei}}</td>
    528. 

  528.               <td>{{$paid_rts_mei}}</td>
    529. 

  529.               <td>{{$sudah_tl_mei}}</td>
    530. 

  530.               <td>{!!  substr(strip_tags($percent_sudah_tl_mei), 0, 5) !!} %</td>
    531. 

  531.               <td>{{$belum_tl_mei}}</td>
    532. 

  532.               <td>{!!  substr(strip_tags($percent_belum_tl_mei), 0, 5) !!} %</td>
    533. 

  533.               <td>{{$jumlah_rt_mei}}</td>
    534. 

  534.               <td>{!!  substr(strip_tags($percent_jumlah_rt_mei), 0, 5) !!} %</td>
    535. 

  535.               <td>
    536. 

  536.                 @if($tanggal_upload_mei)
    537. 

  537.                 {{\Carbon\Carbon::parse($tanggal_upload_mei)
    538. 

  538.                        ->format('d, M Y')}}
    539. 

  539.                 @else
    540. 

  540.                 Belum Mengirim
    541. 

  541.                 @endif
    542. 

  542.               </td>
    543. 

  543.             </tr>
    544. 

  544.             <tr>
    545. 

  545.               <td class="tg-0lax">JUN</td>
    546. 

  546.               <td>{{$total_rts_juni}}</td>
    547. 

  547.               <td>{{$paid_rts_juni}}</td>
    548. 

  548.               <td>{{$sudah_tl_juni}}</td>
    549. 

  549.               <td>{!!  substr(strip_tags($percent_sudah_tl_juni), 0, 5) !!} %</td>
    550. 

  550.               <td>{{$belum_tl_juni}}</td>
    551. 

  551.               <td>{!!  substr(strip_tags($percent_belum_tl_juni), 0, 5) !!} %</td>
    552. 

  552.               <td>{{$jumlah_rt_juni}}</td>
    553. 

  553.               <td>{!!  substr(strip_tags($percent_jumlah_rt_juni), 0, 5) !!} %</td>
    554. 

  554.               <td>
    555. 

  555.                 @if($tanggal_upload_juni)
    556. 

  556.                 {{\Carbon\Carbon::parse($tanggal_upload_juni)
    557. 

  557.                        ->format('d, M Y')}}
    558. 

  558.                 @else
    559. 

  559.                 Belum Mengirim
    560. 

  560.                 @endif
    561. 

  561.               </td>
    562. 

  562.             </tr>
    563. 

  563.             <tr>
    564. 

  564.               <td class="tg-0lax">JUL</td>
    565. 

  565.               <td>{{$total_rts_juli}}</td>
    566. 

  566.               <td>{{$paid_rts_juli}}</td>
    567. 

  567.               <td>{{$sudah_tl_juli}}</td>
    568. 

  568.               <td>{!!  substr(strip_tags($percent_sudah_tl_juli), 0, 5) !!} %</td>
    569. 

  569.               <td>{{$belum_tl_juli}}</td>
    570. 

  570.               <td>{!!  substr(strip_tags($percent_belum_tl_juli), 0, 5) !!} %</td>
    571. 

  571.               <td>{{$jumlah_rt_juli}}</td>
    572. 

  572.               <td>{!!  substr(strip_tags($percent_jumlah_rt_juli), 0, 5) !!} %</td>
    573. 

  573.               <td>
    574. 

  574.                 @if($tanggal_upload_juli)
    575. 

  575.                 {{\Carbon\Carbon::parse($tanggal_upload_juli)
    576. 

  576.                        ->format('d, M Y')}}
    577. 

  577.                 @else
    578. 

  578.                 Belum Mengirim
    579. 

  579.                 @endif
    580. 

  580.               </td>
    581. 

  581.             </tr>
    582. 

  582.             <tr>
    583. 

  583.               <td class="tg-0lax">AUG</td>
    584. 

  584.               <td>{{$total_rts_agustus}}</td>
    585. 

  585.               <td>{{$paid_rts_agustus}}</td>
    586. 

  586.               <td>{{$sudah_tl_agustus}}</td>
    587. 

  587.               <td>{!!  substr(strip_tags($percent_sudah_tl_agustus), 0, 5) !!} %</td>
    588. 

  588.               <td>{{$belum_tl_agustus}}</td>
    589. 

  589.               <td>{!!  substr(strip_tags($percent_belum_tl_agustus), 0, 5) !!} %</td>
    590. 

  590.               <td>{{$jumlah_rt_agustus}}</td>
    591. 

  591.               <td>{!!  substr(strip_tags($percent_jumlah_rt_agustus), 0, 5) !!} %</td>
    592. 

  592.               <td>
    593. 

  593.                 @if($tanggal_upload_agustus)
    594. 

  594.                 {{\Carbon\Carbon::parse($tanggal_upload_agustus)
    595. 

  595.                        ->format('d, M Y')}}
    596. 

  596.                 @else
    597. 

  597.                 Belum Mengirim
    598. 

  598.                 @endif
    599. 

  599.               </td>
    600. 

  600.             </tr>
    601. 

  601.             <tr>
    602. 

  602.               <td class="tg-0lax">SEP</td>
    603. 

  603.               <td>{{$total_rts_september}}</td>
    604. 

  604.               <td>{{$paid_rts_september}}</td>
    605. 

  605.               <td>{{$sudah_tl_september}}</td>
    606. 

  606.               <td>{!!  substr(strip_tags($percent_sudah_tl_september), 0, 5) !!} %</td>
    607. 

  607.               <td>{{$belum_tl_september}}</td>
    608. 

  608.               <td>{!!  substr(strip_tags($percent_belum_tl_september), 0, 5) !!} %</td>
    609. 

  609.               <td>{{$jumlah_rt_september}}</td>
    610. 

  610.               <td>{!!  substr(strip_tags($percent_jumlah_rt_september), 0, 5) !!} %</td>
    611. 

  611.               <td>
    612. 

  612.                 @if($tanggal_upload_september)
    613. 

  613.                 {{\Carbon\Carbon::parse($tanggal_upload_september)
    614. 

  614.                        ->format('d, M Y')}}
    615. 

  615.                 @else
    616. 

  616.                 Belum Mengirim
    617. 

  617.                 @endif
    618. 

  618.               </td>
    619. 

  619.             </tr>
    620. 

  620.             <tr>
    621. 

  621.               <td class="tg-0lax">OKT</td>
    622. 

  622.               <td>{{$total_rts_oktober}}</td>
    623. 

  623.               <td>{{$paid_rts_oktober}}</td>
    624. 

  624.               <td>{{$sudah_tl_oktober}}</td>
    625. 

  625.               <td>{!!  substr(strip_tags($percent_sudah_tl_oktober), 0, 5) !!} %</td>
    626. 

  626.               <td>{{$belum_tl_oktober}}</td>
    627. 

  627.               <td>{!!  substr(strip_tags($percent_belum_tl_oktober), 0, 5) !!} %</td>
    628. 

  628.               <td>{{$jumlah_rt_oktober}}</td>
    629. 

  629.               <td>{!!  substr(strip_tags($percent_jumlah_rt_oktober), 0, 5) !!} %</td>
    630. 

  630.               <td>
    631. 

  631.                 @if($tanggal_upload_oktober)
    632. 

  632.                 {{\Carbon\Carbon::parse($tanggal_upload_oktober)
    633. 

  633.                        ->format('d, M Y')}}
    634. 

  634.                 @else
    635. 

  635.                 Belum Mengirim
    636. 

  636.                 @endif
    637. 

  637.               </td>
    638. 

  638.             </tr>
    639. 

  639.             <tr>
    640. 

  640.               <td class="tg-0lax">NOV</td>
    641. 

  641.               <td>{{$total_rts_november}}</td>
    642. 

  642.               <td>{{$paid_rts_november}}</td>
    643. 

  643.               <td>{{$sudah_tl_november}}</td>
    644. 

  644.               <td>{!!  substr(strip_tags($percent_sudah_tl_november), 0, 5) !!} %</td>
    645. 

  645.               <td>{{$belum_tl_november}}</td>
    646. 

  646.               <td>{!!  substr(strip_tags($percent_belum_tl_november), 0, 5) !!} %</td>
    647. 

  647.               <td>{{$jumlah_rt_november}}</td>
    648. 

  648.               <td>{!!  substr(strip_tags($percent_jumlah_rt_november), 0, 5) !!} %</td>
    649. 

  649.               <td>
    650. 

  650.                 @if($tanggal_upload_november)
    651. 

  651.                 {{\Carbon\Carbon::parse($tanggal_upload_november)
    652. 

  652.                        ->format('d, M Y')}}
    653. 

  653.                 @else
    654. 

  654.                 Belum Mengirim
    655. 

  655.                 @endif
    656. 

  656.               </td>
    657. 

  657.             </tr>
    658. 

  658.             <tr>
    659. 

  659.               <td class="tg-0lax">DES</td>
    660. 

  660.               <td>{{$total_rts_desember}}</td>
    661. 

  661.               <td>{{$paid_rts_desember}}</td>
    662. 

  662.               <td>{{$sudah_tl_desember}}</td>
    663. 

  663.               <td>{!!  substr(strip_tags($percent_sudah_tl_desember), 0, 5) !!} %</td>
    664. 

  664.               <td>{{$belum_tl_desember}}</td>
    665. 

  665.               <td>{!!  substr(strip_tags($percent_belum_tl_desember), 0, 5) !!} %</td>
    666. 

  666.               <td>{{$jumlah_rt_desember}}</td>
    667. 

  667.               <td>{!!  substr(strip_tags($percent_jumlah_rt_desember), 0, 5) !!} %</td>
    668. 

  668.               <td>
    669. 

  669.                 @if($tanggal_upload_desember)
    670. 

  670.                 {{\Carbon\Carbon::parse($tanggal_upload_desember)
    671. 

  671.                        ->format('d, M Y')}}
    672. 

  672.                 @else
    673. 

  673.                 Belum Mengirim
    674. 

  674.                 @endif
    675. 

  675.               </td>
    676. 

  676.             </tr>
    677. 

  677.         </table>
    678. 

  678.       <hr>
    679. 

  679.     </div>
    680. 

  680.   </center>
    681. 

  681. </body>
    682. 

  682. </html>
    683.