Untitled

 avatar
unknown
plain_text
2 years ago
1.4 kB
6
Indexable
<?php
	$no = 1;
	$data_bank = mysqli_query($koneksi,"
	SELECT * FROM tbl_penjualan
	JOIN tbl_konsumen ON tbl_penjualan.pnjl_id = tbl_konsumen.pnjl_id
	JOIN tbl_perumahan ON tbl_penjualan.prmh_id = tbl_perumahan.prmh_id
	JOIN tbl_type ON tbl_penjualan.type_id = tbl_type.type_id
	JOIN tbl_blok ON tbl_penjualan.blok_id = tbl_blok.blok_id
	JOIN tbl_kpr ON tbl_penjualan.kpra_id = tbl_kpr.kpra_id
	JOIN tbl_user ON tbl_penjualan.user_id = tbl_user.user_id									
	JOIN tbl_pembayaran ON tbl_penjualan.pnjl_id = tbl_pembayaran.pnjl_id
	JOIN tbl_berkas ON tbl_penjualan.pnjl_id = tbl_berkas.pnjl_id
	JOIN tbl_website ON tbl_penjualan.prmh_id = tbl_website.prmh_id					
	JOIN tbl_bank ON tbl_berkas.bank_id = tbl_bank.bank_id
	JOIN tbl_notaris ON tbl_berkas.ntrs_id = tbl_notaris.ntrs_id
	
	WHERE tbl_berkas.brks_posisi ='berkas di bank' 
	AND tbl_konsumen.knsm_status ='berkas di bank' 
	AND tbl_blok.blok_status ='berkas di bank'
	
	ORDER BY tbl_berkas.brks_kumpul ASC
	");
	while($d = mysqli_fetch_array($data_bank)){
	$pengumpulan_berkas_bank = date('Y-m-d',strtotime('+7 day', strtotime( date($d['brks_kumpul']) )));
?>
<span style="display:<?php 
		$block2 = 'inline-block';
		$none = 'none';
		if ($pengumpulan_berkas_bank < $tgl_sekarang)  { 
			echo $block2;
		}  else  {
			echo $none;
		}
	?>;">
	<?php echo $no++;?>
</span>			
<?php 
}
?>
Editor is loading...