| 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'];;
?>
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<h3 align="center" class="panel-title">Invoice : <?php echo "<b> ".$npm."</b>"; ?>
</h3>
</div>
<h3 align="center">Pembayaran Invoice </h3>
<blockquote>
<blockquote>
<p> <strong><h4>Konfirmasi Pembayaran</h4></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>
5. Sebelum melakukan Transfer Pastikan <br>
<b>
- Massa Berlaku akhir Nomor STR anda sudah benar <br>
- Pastikan Jumlah Nominal Transfer Sudah sesuai.<br>
- Untuk Jumlah Nominal silahkan Croschek kembali dengan menghubungi <br>bagian keuangan Sekretariat IDI.<br>
- Untuk mengetahui Data iuran Tahunan anggota terakhir, silahkan konfirm ke sekretariat" <br>
Kontak Hotline 08111321311</b>
<br>
<br> <br>
<?php
$hari = date('Y-m-d');
$sqlSiswa = mysqli_query($konek, "SELECT * FROM h_anggota WHERE npm='$_GET[npm]' ");
$ds=mysqli_fetch_array($sqlSiswa);
$iuran= $ds['tgliuran'];
$npm= $ds['npm'];
// $noreg= $ds['noreg'];
//$pinv= $ds['pinv'];
?>
<?php if ( $iuran<$hari){
?>
<div class='alert alert-warning'>
<?php
if ($ds['tunggakan']=='bayar'){
echo "
<div class='alert alert-info'>
<i class='far fa-bell'></i> </span>Administrasi Iuran: Terimakasih Sudah melakukan Pembayaran, tunggu validasi. <span style='color:red'>
</div>";
}else if ($ds['tunggakan']=='proses'){
echo "
<div class='alert alert-info'>
<i class='far fa-bell'></i> </span>Administrasi Iuran: Segera lakukan Pembayaran. <span style='color:red'> </span>
</div>";
}
?>
<?php
}else{
?>
<div class='alert alert-info'>
<span style='color:red'><i class='far fa-bell'></i> </span>Administrasi Iuran: Pembayaran sudah Valid... <span style='color:red'> </span>
<a class='btn btn-success btn-sm' href='data_finiuran.php?npm=<?php echo $npm ?>'> Cetak kwitansi</a>
</div>
</div>
<?php
}
?>
<?php
$sqlSiswa = mysqli_query($konek, "SELECT * FROM mahasiswa where npm='$npm'");
$ds=mysqli_fetch_array($sqlSiswa);
$nis = $ds['npm'];
//$tahun= $ds['tahunajaran'];
//$tkelas = substr($ds['kelas'],0,-1);
?>
</p>
</blockquote>
</blockquote>
<div class="table-container"></div>
<div class="panel-body">
<div class="">
<table class="demo-table responsive" >
<caption class="title">Tabel Pembayaran Iuran 5 tahunan</caption>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">No Inv</th>
<th scope="col">Nama</th>
<th scope="col">Masa Awal Iuran</th>
<th scope="col">Masa Akhir Iuran</th>
<th scope="col">Nominal</th>
</tr>
</thead>
<?php
$sql = mysqli_query($konek, "SELECT * FROM b_inv where validasi ='' AND npm='$npm' ");
// $sql = mysqli_query($konek, "select tblnonspp.*,nonspp.bayar from nonspp INNER JOIN tblnonspp ON nonspp.kelas= tblnonspp.kelas group by jenis_tagihan");
$no=1;
$total =0;
$jumlah = 0;
while($d=mysqli_fetch_array($sql)){
$harga = number_format($d['nominal'],0,",",".");
$awaliur1=$d['tgl_awal'];
$akhiriur1=$d['tgl_akhir'];
$awaliur = date('d-m-Y', strtotime($awaliur1)); // Hasil Ymd
$akhiriur = date('d-m-Y', strtotime($akhiriur1)); // Hasil Ymd
echo "<tr>
<td data-header='No' class='title'>$no</td>
<td data-header='NoInvoice' >$d[noinv]</td>
<td data-header='nama' >$d[nmlead]</td>
<td data-header='masa Awal Iuran' >$awaliur</td>
<td data-header='masa Akhir Iuran' >$akhiriur</td>
<td align=right data-header='Jumlah'>Rp. $harga</td>
</tr>";
//$jumlah2 = isset($d['nominal']) ? $d['nominal'] : '';
//$jumlah[] = $d['nominal'];
$npm = $d['npm'];
$jumlah+= $d['nominal'];
$no++;
}
//$gtjumlahnya = array_sum($jumlah);
$gtjumlahnya =($jumlah);
function rupiah($subjumlah){
$hasil_rupiah = "Rp " . number_format($subjumlah,2,',','.');
return $hasil_rupiah;}
//$harga = array_sum($harga);
//Tampilkan
echo "<td>";
echo "";
echo "";
echo "<td>";
echo "<td>";
echo "<td>";
echo "<td>";
echo "Total ";
echo "<td>";
echo "<align=right td>";
echo rupiah($gtjumlahnya);
// echo "<td> <a class='btn btn-danger btn-sm' href='prosesnon.php?act=bayar&total=$jumlahnya&npm=$npm&kelas=$kelas'>Bayar tagihan</a></td>";
echo "</td>
</tr>";
?>
</table>
<?php
}
?>
</div>
<div class="">
<div class="panel-body">
<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">No Inv</th>
<th scope="col">Periode Bulan</th>
<th scope="col">Tanggal Awal</th>
<th scope="col">Tanggal Akhir</th>
<th scope="col">Jumlah total</th>
<th scope="col">Status</th>
<th scope="col">Bukti Transfer</th>
<th scope="col">Action</th>
</tr>
</thead>
<?php
// $sql = mysqli_query($konek, "select * from nonspp WHERE tahunajaran='$tahun' and tkelas='$tkelas' AND npm='$nis' group by idnonspp");
$sql = mysqli_query($konek, "select * from b_inv where validasi ='' AND npm='$npm' group by id_tagihan");
$no=1;
$total =0;
$bayar =0;
$totalb =0;
while($d=mysqli_fetch_array($sql)){
$bayartb = number_format($d['bayar'],0,",",".");
// $harga = number_format($d['nominal'],0,",",".");
$timeStart = strtotime("$awaliur1");
$timeEnd = strtotime("$akhiriur1");
// 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);
echo "<tr>
<td data-header='No' class='title'>$no</td>
<td data-header='Tahun ajaran' >$d[noinv]</td>
<td data-header='Tahun ajaran' >$numBulan Bulan</td>
<td data-header='Tgl Awal' >$d[tgl_awal]</td>
<td data-header='Tgl Akhir' >$d[tgl_akhir]</td>
<td align=right data-header='Jumlah'>Rp. $harga</td>
<td data-header='Status bayar' align='center'>";
if($d['status']==''){
echo "Belum bayar";
}else{
echo $d['status'];
}
echo "</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>
</tr>";
//$bayar[] = $d['bayar'];
//$totalb[] = $d['nominal'];
$bayar += $d['bayar'];
$totalb += $d['nominal'];
$npm=$d['npm'];
$status=$d['status'];
$id=$d['id_tagihan'];
//$bayar = $d['bayar'];
$no++;
}
//$bayarnya = ($bayar);
//$totalnya = ($totalb);
$sisa = $totalb - $bayar ;
//Tampilkan
echo "<td>";
echo "";
echo "<td>";
echo "Grand Total ";
echo "<td>";
echo rupiah($totalb);
echo "<td>";
echo "<td>";
echo "Sisa Bayar : ";
echo "<td text-align='right'>";
echo rupiah($sisa);
echo "<td>";
echo "<td data-header='Bayar' align='center'>";
if($sisa<='0'){
echo "-";
}else{
echo "<a class='btn btn-danger btn-sm' href='prosesnon.php?npm=$npm&act=bayar&sisa=$sisa&id=$id&prd=$numBulan'>Bayar tagihan</a>";
}
echo "</td>";
echo "</td>
</tr>";
?>
</table>
<br>
<div class="panel-body">
<table width="" class="demo-table responsive" >
<table class="table table-bordered table-striped">
<table class="demo-table responsive">
<caption class="title">Data Pembayaran Non Valid</caption>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">No Inv</th>
<th scope="col">Noreg</th>
<th scope="col">jumlah total</th>
<th scope="col">Tgl Exp</th>
<th scope="col">Status</th>
<th scope="col">Bukti Transfer</th>
<th scope="col">validasi</th>
<th scope="col">ket</th>
</tr>
</thead>
<?php
// $sql = mysqli_query($konek, "select * from nonspp WHERE tahunajaran='$tahun' and tkelas='$tkelas' AND npm='$nis' group by idnonspp");
$sql = mysqli_query($konek, "select * from b_inv where validasi ='unvalid' AND npm='$npm' group by id_tagihan");
$no=1;
$total =0;
$bayar =0;
$totalb =0;
while($d=mysqli_fetch_array($sql)){
$bayartb = number_format($d['bayar'],0,",",".");
// $harga = number_format($d['nominal'],0,",",".");
echo "<tr>
<td data-header='No' class='title'>$no</td>
<td data-header='Tahun ajaran' >$d[noinv]</td>
<td data-header='Tahun ajaran' >$d[noreg]</td>
<td align=right data-header='Jumlah'>Rp. $harga</td>
<td data-header='kelas' >$d[tglexp]</td>
<td data-header='Status bayar' align='center'>";
if($d['status']==''){
echo "Belum bayar";
}else{
echo $d['status'];
}
echo "</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='Tahun ajaran' >$d[validasi]</td>
<td data-header='Tahun ajaran' >$d[keterangan]</td>
</tr>";
//$bayar = $d['bayar'];
$no++;
}
?>
</table>
</div>
</body>
</html>