| Server IP : 91.108.119.23 / Your IP : 216.73.217.31 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/IDI/anggota/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php include "header.php"; ?>
<?php include "../koneksi.php"; ?>
<?php
$view = isset($_GET['view']) ? $_GET['view'] : null;
switch($view){
default:
$npm=$_GET['npm'];
?>
<h4 align="center" class="panel-title">Invoice : <?php echo "<b> ".$npm."</b>"; ?> </h4>
<h4 align="center">Pembayaran Invoice </h4>
<blockquote>
<blockquote>
<p> <strong>Konfirmasi Pembayaran</strong></p>
<p> Pembayaran akan di cek dan di Validasi oleh admin:<br>
1. Silahkan Transfer pembayaran ke Account kami.<br>
2. TRANSFER KE BANK BNI 7740740758 AN IDI CABANG KODYA BANDUNG<br>
3. Setelah melakukan Pembayaran Konfirmasi Pembayaran kepada Kami dengan cara Click bayar tagihan<br>
Input Jumlah pembayaran dan bukti transfers.<br>
4. Admin akan memverifikasi dan memberikan notifikasi otomatis.
<br>
<?php
$npm=$_GET['npm'];
$sekarang =date("Y-m-d");
?>
<br>
<p>NPM: <?php echo $npm ?></p>
<table width="" class="demo-table responsive" >
<table class="table table-bordered table-striped">
<caption class="title">Data Pembayaran Iuran 5 Tahunan</caption>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">No Invoice</th>
<th scope="col">Status</th>
<th scope="col">Tanggal_Awal</th>
<th scope="col">Tanggal_Akhir</th>
<th scope="col">Periode_Bulan</th>
<th scope="col">Iuran_bulanan</th>
<th scope="col">Jumlah_Invoice</th>
<th scope="col">Total_Bayar_Iuran</th>
<th scope="col">Tgl_Bayar</th>
<th scope="col">Validasi</th>
<th scope="col">Bukti_Transfer</th>
<th scope="col">Cetak_kwitansi</th>
</tr>
</thead>
<?php
// $sql = mysqli_query($konek, "select * from nonspp WHERE npm='$nis'AND status='valid' group by idnonspp");
$sql = mysqli_query($konek, "select * from b_inv where npm='$npm' ");
$no=1;
$total =0;
$bayar =0;
//$totalb =0;
$sisa =0;
$sisabayar =0;
while($d=mysqli_fetch_array($sql)){
$bayartb = number_format($d['bayar'],0,",",".");
$nominal= $d['nominal'];
$noinv= $d['noinv'];
$status = isset($d['status']) ? $d['status'] : null;
// $sisa= $allperiod-$d['periode'];
$sisabyr= $nominal-$d['bayar'];
echo "<tr>
<td data-header='No' class='title'>$no</td>
<td data-header='No Invoice' >$d[noinv]</td>
<td data-header='No Invoice' >$d[status]</td>
<td data-header='Tanggal Awal' >$d[tgl_awal]</td>
<td data-header='Tanggal Akhir' >$d[tgl_akhir]</td>
<td data-header='Periode Bulan' >$d[periode] Bulan</td>
<td data-header='Nominal' >$d[bulanan]</td>
<td data-header='Nominal' >$d[nominal]</td>
<td data-header='Bayar' align='center'>Rp. $bayartb</td>
<td data-header='Tgl Bayar' align='center'>$d[tgl_bayar]</td>
<td data-header='Jumlah' >$d[validasi]</td>
<td data-header='Bukti Trans' align='center'>";
if($d['gambar']==''){
echo "-";
}else{
echo "<img src=../files/$d[gambar] width='100' height='126'> ";
}
echo "</td>
<td data-header='Cetak Kwitansi' align='center'><a class='btn btn-success btn-sm' href='cetak_kwiur.php?npm=$npm&noinv=$noinv'>Kwitansi</a> </td>
</tr>";
$bayar+= $d['bayar'];
//$totalb+= $d['nominal'];
$npm=$d['npm'];
$status=$d['status'];
$id=$d['id_tagihan'];
//$bayar = $d['bayar'];
$no++;
// $bayarnya = ($bayar);
//$totalnya = ($totalb);
//$sisab = $totalb-$bayar ;;
}
function rupiah($subjumlah){
$hasil_rupiah = "Rp " . number_format($subjumlah,2,',','.');
return $hasil_rupiah;}
//$harga = array_sum($harga);
//Tampilkan
echo "<td>";
echo "";
echo "<td>";
echo "<td>";
echo "";
echo "<td>";
//if(isset($jumlahnya)){
//
// echo rupiah($jumlahnya);
// }
// else
// {
// echo rupiah(0);
// }
echo "<td>";
echo "<td>";
echo "<td>";
echo "Pembayaran ";
echo "<td>";
echo rupiah($bayar) ;
echo "<td>";
echo "<td>";
echo "</td>
</tr>";
}
?>
</table>
<br>
<table width="" class="demo-table responsive" >
<table class="table table-bordered table-striped">
<table class="demo-table responsive">
<caption class="title">Data Pembayaran Iuran</caption>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">ID</th>
<th scope="col">Tanggal JT Iuran</th>
<th scope="col">Terlambat</th>
<th scope="col">Periode</th>
<th scope="col">Nominal</th>
<th scope="col">Action</th>
</tr>
</thead>
<?php
// $sql = mysqli_query($konek, "select * from b_inv where validasi ='' AND npm='$npm' group by id_tagihan");
// $sql=mysqli_query($konek, "SELECT h_anggota.*, level.tingkat, level.nominal FROM h_anggota JOIN level ON h_anggota.tingkat = level.tingkat
// WHERE tgliuran < '$sekarang' AND npm='$npm'");
// $result = mysqli_query($konek, "select * from level where tingkat='17' ");
// $dk=mysqli_fetch_array($result);
// $bayartb = number_format($dk['nominal'],0,",",".");
$sql=mysqli_query($konek, "SELECT kat_nm,nominal FROM level WHERE kat_nm='bulanan'");
$u = mysqli_fetch_array($sql);
$nomiur=$u['nominal'];
$sekarang = date('Y-m-d');
$sql=mysqli_query($konek, "SELECT h_anggota.* FROM h_anggota WHERE tgliuran < '$sekarang' AND npm='$npm'");
$no=1;
$total =0;
$bayar =0;
$totalb =0;
while($d=mysqli_fetch_array($sql)){
// $bayartb = number_format($dk['nominal'],0,",",".");
$kembali =new DateTime($d['tgliuran']);
$lambat =new DateTime($sekarang);
$diff =$lambat->diff($kembali);
$tiuran = isset($d['tgliuran']) ? $d['tgliuran'] : null;
$b_iuran = isset($d['b_iuran']) ? $d['b_iuran'] : null;
// $b_iuran ='proses';
//cari periode
$timeStart = strtotime("$tiuran");
$timeEnd = strtotime("$sekarang");
// Menambah bulan ini + semua bulan pada tahun sebelumnya
$numBulan = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))*12;
// menghitung selisih bulan
$numBulan += date("m",$timeEnd)-date("m",$timeStart);
?>
<h3>Reminder Tanggal Jatuh Tempo Iuran </h3>
<p>Hari ini Tanggal: <?php echo $sekarang?></p>
<p>Expired Tanggal: <?php echo $d['tgliuran']?></p>
<tr>
<td><?php echo $no?></td>
<td><?php echo $d['npm']?></td>
<td><?php echo $d['tgliuran']?></td>
<td><?php echo $numBulan ?> Bulan</td>
<td>60 Bulan</td>
<td><?php echo $nomiur ?></td>
<td data-header='Bayar' align='center'>
<?php
if($tiuran < $sekarang AND $b_iuran=='' ){
echo "<a class='btn btn-danger btn-sm' href='bayar_iur.php?npm=$npm&iuran=$nomiur'>Bayar Iuran</a>";
}else{
echo "-";
}
?>
</td>
</td>
</tr>
<?php
$no++;
}
?>
</table>
<br>
<br> <br> <br> <br>
</diV>
</body>
</html>