| 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
$view = isset($_GET['view']) ? $_GET['view'] : null;
switch($view){
default:
?>
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<h3 align="center" class="panel-title">Data Keuangan : <?php echo "<b> ".$_SESSION['nama_mhs']."</b>"; ?>
</h3>
</div>
<h3 align="center">DATA KEUANGAN </h3>
<?php
$sqlSiswa = mysqli_query($konek, "SELECT * FROM mahasiswa WHERE npm='$_SESSION[npm]'");
$ds=mysqli_fetch_array($sqlSiswa);
$npm = $ds['npm'];
?>
<div class="panel-body">
<div class="">
<table class="demo-table responsive" >
<caption class="title">Invoice</caption>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">No Inv</th>
<th scope="col">Nama</th>
<th scope="col">Noreg</th>
<th scope="col">level Status</th>
<th scope="col">Status</th>
<th scope="col">Nominal</th>
</tr>
</thead>
<?php
//$sql = mysqli_query($konek, "SELECT tahunajaran,id_tagihan,kelas,jenis_tagihan,jumlah FROM d_nonspp WHERE npm='$nis' ");
$sql = mysqli_query($konek, "SELECT * FROM b_inv where npm='$npm' order by id_tagihan asc limit 1 ");
$no=1;
$total =0;
$jumlah=0;
while($d=mysqli_fetch_array($sql)){
$harga = number_format($d['nominal'],0,",",".");
echo "<tr>
<td data-header='No' class='title'>$no</td>
<td data-header='No invoice' >$d[noinv]</td>
<td data-header='Nama' >$d[nmlead]</td>
<td data-header='No Reg' >$d[noreg]</td>
<td data-header='Level' >$d[level]</td>
<td data-header='Status' >$d[status]</td>
<td align=right data-header='Nominal'>Rp. $harga</td>
</tr>";
$jumlah+= $d['nominal'];
$no++;
}
$jumlahnya = ($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 "<td>";
echo "Total ";
echo "<td>";
echo "<align=right td>";
echo rupiah($jumlahnya);
echo "</td>
</tr>";
?>
</table>
<?php
}
?>
</div>
<table width="" class="demo-table responsive" >
<table class="table table-bordered table-striped">
<caption class="title">Data Pembayaran Iuran</caption>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">Tgl Bayar</th>
<th scope="col">Nominal inv</th>
<th scope="col">Bayar</th>
<th scope="col">Periode</th>
<th scope="col">Tgl Exp</th>
<th scope="col">Status</th>
<th scope="col">Catatan</th>
<th scope="col">Bukti Transfer</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 validasi ='valid' AND npm='$npm' group by id_tagihan");
$no=1;
$total =0;
$bayar =0;
$totalb =0;
$sisa =0;
while($d=mysqli_fetch_array($sql)){
$bayartb = number_format($d['bayar'],0,",",".");
echo "<tr>
<td data-header='No' class='title'>$no</td>
<td data-header='Tgl Bayar' align='center'>";
if($d['tgl_bayar']==''){
echo "-";
}else{
echo $d['tgl_bayar'];
}
echo "</td>
<td data-header='Jumlah' >$d[nominal]</td>
<td data-header='Bayar' align='center'>";
if($d['bayar']=='0'){
echo "-";
}else{
echo "Rp. $bayartb";
}
echo "</td>
<td data-header='Jumlah' >$d[periode] Tahun</td>
<td data-header='Jumlah' >$d[tgliuran]</td>
<td data-header='Status bayar' align='center'>";
if($d['validasi']==''){
echo "-";
}else{
echo $d['validasi'];
}
echo "</td>
<td data-header='Status bayar' align='center'>";
if($d['status']=='valid'){
echo "-";
}else{
echo "-";
}
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'];
$npm=$d['npm'];
$status=$d['status'];
$id=$d['id_tagihan'];
//$bayar = $d['bayar'];
$no++;
// $bayarnya = ($bayar);
//$totalnya = ($totalb);
$sisa = $jumlahnya-$bayar ;;
}
//$harga = array_sum($harga);
//Tampilkan
echo "<td>";
echo "";
echo "<td>";
echo "<td>";
echo "Grand Total ";
echo "<td>";
if(isset($jumlahnya)){
echo rupiah($jumlahnya);
}
else
{
echo rupiah(0);
}
echo "<td>";
echo "Pembayaran ";
echo "<td>";
echo rupiah($bayar) ;
echo "<td>";
echo "Sisa Bayar : ";
echo "<td>";
echo rupiah($sisa);
echo "<td>";
// echo "$bayar";
// echo "$sisa";
echo "</td>
</tr>";
?>
</table>
<br>
</div>
<?php
?>
</body>
</html>