| Server IP : 88.223.91.238 / 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/superadmin/ |
Upload File : |
<?php include "header.php";
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['status']<>"login"){
header("location:location:../login.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<head>
<title>IDI | List Kategori</title>
<!-- Custom fonts for this template-->
<link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
<!-- Custom styles for this template-->
<link href="css/sb-admin-2.min.css" rel="stylesheet">
<!-- Custom styles for this page -->
<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
<style type="text/css">
body{
font-family: roboto;
}
table {
margin: 0 auto;
border-collapse: collapse;
}
tbody {
color: #000;
}
table td {
padding: 5px 10px;
border: 1px solid #e0e0e0;
font: normal 10px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 11px Tahoma, Geneva, sans-serif;
}
/* untuk ukuran layar 700px kebawah */
@media screen and (max-width: 780px) {
.header,
.footer{
text-align: center;
}
.left {
width: auto;
float: none;
}
.middle {
width: auto;
float: none;
}
.right {
width: auto;
float: none;
}
}
</style>
</head>
<body id="page-top">
<body>
<!-- Page Wrapper -->
<div id="wrapper">
<?php include "sidebar.php"; ?>
<!-- Content Wrapper -->
<div id="content-wrapper" class="d-flex flex-column">
<!-- Main Content -->
<div id="content">
<?php include "topbar.php";?>
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- DataTales Example -->
<div class="card shadow mb-4">
<div class="card-header py-3">
<h6 class="m-0 font-weight-bold text-primary">List Post</h6>
</div>
<div class="card-body">
<div class="table-responsive">
<?php
//$npm=$_GET['npm'];
$sekarang =date('Y-m-d');
?>
<center><caption class="title">List Anggota Iuran Expired</caption></center>
<br>
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">Tgl_Revisi</th>
<th scope="col">ID</th>
<th scope="col">Kwitansi</th>
<th scope="col">Nama</th>
<th scope="col">Tanggal_Awal</th>
<th scope="col">Tanggal-Akhir</th>
<th scope="col">Tanggal_Bayar</th>
<th scope="col">Nominal</th>
<th scope="col">Status </th>
<th scope="col">Kwitansi</th>
<th scope="col">Bantu Upload</th>
<th scope="col">Validasi</th>
</tr>
</thead>
<?php
$now =date('Y-m-d');
// $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 h_anggota.tgliuran < '$now' and h_anggota.level= 'user' order by npm ");
$sql=mysqli_query($konek, "SELECT * FROM h_anggota where rev_iuran='1' AND validasi='proses' ");
$no=1;
$total =0;
$bayar =0;
$totalb =0;
while($d=mysqli_fetch_array($sql)){
// $bayartb = number_format($d['nominal'],0,",",".");
$kembali =new DateTime($d['tgliuran']);
$lambat =new DateTime($sekarang);
$diff =$lambat->diff($kembali);
$tanggal1 = new DateTime($d['tgliuran']);
$tanggal2 = new DateTime();
$perbedaan = $tanggal2->diff($tanggal1)->format("%a");
$date1 = date_create($d['tgliuran']);
$date2 = date_create($sekarang);
$interval = date_diff($date1, $date2);
$awaliuran2 = $d['awalmbstr'];
$nominal = $d['nominal_iur'];
$tglbayar2 = $d['tglbayar_iur'];
$validasi = $d['validasi'];
// $str= $d['mbstr'];
// $date = new DateTime($str);
// $mbstr = $date->format('d-m-Y');
//
$tgliuran= $d['tgliuran'];
$date = new DateTime($tgliuran);
$iuran= $date->format('d-m-Y');
//
$date = new DateTime($awaliuran2);
$awaliuran = $date->format('d-m-Y');
$date = new DateTime($tglbayar2);
$tglbayar = $date->format('d-m-Y');
?>
<tr>
<td><?php echo $no?></td>
<td><?php echo $d['tgl_rev'] ?></td>
<td><?php echo $d['npm']?></td>
<td><?php echo $d['nokwit']?></td>
<td><?php echo $d['nmlead']?></td>
<td><?php echo $awaliuran ?></td>
<td><?php echo $iuran ?></td>
<td><?php echo $tglbayar ?></td>
<td><?php echo $nominal ?></td>
<td><?php echo $validasi ?></td>
<td><a href="../anggota/kwitansi/<?php echo $d['foto']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<?php
if ($d['foto']==""){
?>
<?php echo $d['foto']; ?>
<?php
}else{
?>
<img src="../anggota/kwitansi/<?php echo $d['foto']; ?>" style="width:50%;"/>
<?php
}
?>
</td>
<td><a class='btn btn-warning btn-sm' href='kwt_iurrev.php?npm=<?php echo $d['npm']?>&view=1'>Bantu Upload</a></td>
<td><a class='btn btn-danger btn-sm' href='validasi_iur.php?npm=<?php echo $d['npm']?>&view=1'>Validasi</a></td>
</tr>
<?php
$no++;
}
?>
</tr>
</table>
<br>
<br>
</div>
<!-- End Main Content -->
</div>
<!-- End Page Wrapper -->
<!-- Bootstrap core JavaScript-->
<script src="vendor/jquery/jquery.min.js"></script>
<script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- Core plugin JavaScript-->
<script src="vendor/jquery-easing/jquery.easing.min.js"></script>
<!-- Custom scripts for all pages-->
<script src="js/sb-admin-2.min.js"></script>
<!-- Page level plugins -->
<script src="vendor/datatables/jquery.dataTables.min.js"></script>
<script src="vendor/datatables/dataTables.bootstrap4.min.js"></script>
<!-- Page level custom scripts -->
<script src="js/demo/datatables-demo.js"></script>
</div>
</body>
</html>