|
RT BELUM TERBAYAR (H-30 s.d H) |
RT TIDAK TERBAYAR (MENJADI REMINDER) |
| BULAN |
TOTAL RT TERBIT |
RT TERBAYAR |
SUDAH DI-TL UPT |
% |
BELUM DI-TL UPT |
% |
JUMLAH RT |
% |
Tanggal Upload |
whereYear('bi_create_date',$fixYear)->where('status','paid')->where('status_izin','Perpanjangan')->where('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->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('katagori_spp',$jenis_st)->distinct()->value('updated_at');
?>
| JAN |
{{$total_rts_januari}} |
{{$paid_rts_januari}} |
{{$sudah_tl_januari}} |
{!! substr(strip_tags($percent_sudah_tl_januari), 0, 5) !!} % |
{{$belum_tl_januari}} |
{!! substr(strip_tags($percent_belum_tl_januari), 0, 5) !!} % |
{{$jumlah_rt_januari}} |
{!! substr(strip_tags($percent_jumlah_rt_januari), 0, 5) !!} % |
@if($tanggal_upload_januari)
{{\Carbon\Carbon::parse($tanggal_upload_januari)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| FEB |
{{$total_rts_februari}} |
{{$paid_rts_februari}} |
{{$sudah_tl_februari}} |
{!! substr(strip_tags($percent_sudah_tl_februari), 0, 5) !!} % |
{{$belum_tl_februari}} |
{!! substr(strip_tags($percent_belum_tl_februari), 0, 5) !!} % |
{{$jumlah_rt_februari}} |
{!! substr(strip_tags($percent_jumlah_rt_februari), 0, 5) !!} % |
@if($tanggal_upload_februari)
{{\Carbon\Carbon::parse($tanggal_upload_februari)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| MAR |
{{$total_rts_maret}} |
{{$paid_rts_maret}} |
{{$sudah_tl_maret}} |
{!! substr(strip_tags($percent_sudah_tl_maret), 0, 5) !!} % |
{{$belum_tl_maret}} |
{!! substr(strip_tags($percent_belum_tl_maret), 0, 5) !!} % |
{{$jumlah_rt_maret}} |
{!! substr(strip_tags($percent_jumlah_rt_maret), 0, 5) !!} % |
@if($tanggal_upload_maret)
{{\Carbon\Carbon::parse($tanggal_upload_maret)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| APR |
{{$total_rts_april}} |
{{$paid_rts_april}} |
{{$sudah_tl_april}} |
{!! substr(strip_tags($percent_sudah_tl_april), 0, 5) !!} % |
{{$belum_tl_april}} |
{!! substr(strip_tags($percent_belum_tl_april), 0, 5) !!} % |
{{$jumlah_rt_april}} |
{!! substr(strip_tags($percent_jumlah_rt_april), 0, 5) !!} % |
@if($tanggal_upload_april)
{{\Carbon\Carbon::parse($tanggal_upload_april)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| MEI |
{{$total_rts_mei}} |
{{$paid_rts_mei}} |
{{$sudah_tl_mei}} |
{!! substr(strip_tags($percent_sudah_tl_mei), 0, 5) !!} % |
{{$belum_tl_mei}} |
{!! substr(strip_tags($percent_belum_tl_mei), 0, 5) !!} % |
{{$jumlah_rt_mei}} |
{!! substr(strip_tags($percent_jumlah_rt_mei), 0, 5) !!} % |
@if($tanggal_upload_mei)
{{\Carbon\Carbon::parse($tanggal_upload_mei)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| JUN |
{{$total_rts_juni}} |
{{$paid_rts_juni}} |
{{$sudah_tl_juni}} |
{!! substr(strip_tags($percent_sudah_tl_juni), 0, 5) !!} % |
{{$belum_tl_juni}} |
{!! substr(strip_tags($percent_belum_tl_juni), 0, 5) !!} % |
{{$jumlah_rt_juni}} |
{!! substr(strip_tags($percent_jumlah_rt_juni), 0, 5) !!} % |
@if($tanggal_upload_juni)
{{\Carbon\Carbon::parse($tanggal_upload_juni)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| JUL |
{{$total_rts_juli}} |
{{$paid_rts_juli}} |
{{$sudah_tl_juli}} |
{!! substr(strip_tags($percent_sudah_tl_juli), 0, 5) !!} % |
{{$belum_tl_juli}} |
{!! substr(strip_tags($percent_belum_tl_juli), 0, 5) !!} % |
{{$jumlah_rt_juli}} |
{!! substr(strip_tags($percent_jumlah_rt_juli), 0, 5) !!} % |
@if($tanggal_upload_juli)
{{\Carbon\Carbon::parse($tanggal_upload_juli)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| AUG |
{{$total_rts_agustus}} |
{{$paid_rts_agustus}} |
{{$sudah_tl_agustus}} |
{!! substr(strip_tags($percent_sudah_tl_agustus), 0, 5) !!} % |
{{$belum_tl_agustus}} |
{!! substr(strip_tags($percent_belum_tl_agustus), 0, 5) !!} % |
{{$jumlah_rt_agustus}} |
{!! substr(strip_tags($percent_jumlah_rt_agustus), 0, 5) !!} % |
@if($tanggal_upload_agustus)
{{\Carbon\Carbon::parse($tanggal_upload_agustus)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| SEP |
{{$total_rts_september}} |
{{$paid_rts_september}} |
{{$sudah_tl_september}} |
{!! substr(strip_tags($percent_sudah_tl_september), 0, 5) !!} % |
{{$belum_tl_september}} |
{!! substr(strip_tags($percent_belum_tl_september), 0, 5) !!} % |
{{$jumlah_rt_september}} |
{!! substr(strip_tags($percent_jumlah_rt_september), 0, 5) !!} % |
@if($tanggal_upload_september)
{{\Carbon\Carbon::parse($tanggal_upload_september)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| OKT |
{{$total_rts_oktober}} |
{{$paid_rts_oktober}} |
{{$sudah_tl_oktober}} |
{!! substr(strip_tags($percent_sudah_tl_oktober), 0, 5) !!} % |
{{$belum_tl_oktober}} |
{!! substr(strip_tags($percent_belum_tl_oktober), 0, 5) !!} % |
{{$jumlah_rt_oktober}} |
{!! substr(strip_tags($percent_jumlah_rt_oktober), 0, 5) !!} % |
@if($tanggal_upload_oktober)
{{\Carbon\Carbon::parse($tanggal_upload_oktober)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| NOV |
{{$total_rts_november}} |
{{$paid_rts_november}} |
{{$sudah_tl_november}} |
{!! substr(strip_tags($percent_sudah_tl_november), 0, 5) !!} % |
{{$belum_tl_november}} |
{!! substr(strip_tags($percent_belum_tl_november), 0, 5) !!} % |
{{$jumlah_rt_november}} |
{!! substr(strip_tags($percent_jumlah_rt_november), 0, 5) !!} % |
@if($tanggal_upload_november)
{{\Carbon\Carbon::parse($tanggal_upload_november)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|
| DES |
{{$total_rts_desember}} |
{{$paid_rts_desember}} |
{{$sudah_tl_desember}} |
{!! substr(strip_tags($percent_sudah_tl_desember), 0, 5) !!} % |
{{$belum_tl_desember}} |
{!! substr(strip_tags($percent_belum_tl_desember), 0, 5) !!} % |
{{$jumlah_rt_desember}} |
{!! substr(strip_tags($percent_jumlah_rt_desember), 0, 5) !!} % |
@if($tanggal_upload_desember)
{{\Carbon\Carbon::parse($tanggal_upload_desember)
->format('d, M Y')}}
@else
Belum Mengirim
@endif
|