Untitled
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...