| Server IP : 2.57.91.31 / Your IP : 216.73.217.80 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 "koneksi.php";
session_start();
// 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 Kota Bandung</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">
<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<!-- Chosen Select -->
<link rel="stylesheet" type="text/css" href="css/plugins/chosen/css/chosen.min.css" />
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
<script src="https://cdn.jsdelivr.net/npm/jquery@3.7.1/dist/jquery.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js"></script>
<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 12px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 12px 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>
<style type="text/css">
/* Table demo-table */
table {
margin: auto;
font-family: "Lucida Sans Unicode", "Lucida Grande", "Segoe Ui";
font-size: 12px;
}
.demo-table {
border-collapse: collapse;
font-size: 11px;
}
.demo-table th,
.demo-table td {
border-bottom: 1px solid #e1edff;
border-left: 1px solid #e1edff;
padding: 5px 10px;
}
.demo-table th,
.demo-table td:last-child {
border-right: 1px solid #e1edff;
}
.demo-table td:first-child {
border-top: 1px solid #e1edff;
}
.demo-table td:last-child{
border-bottom: 0;
}
caption {
caption-side: top;
margin-bottom: 10px;
}
/* Table Header */
.demo-table thead th {
background-color: #508abb;
color: #FFFFFF;
border-color: #6ea1cc !important;
text-transform: uppercase;
}
/* Table Body */
.demo-table tbody td {
color: #353535;
}
.demo-table tbody tr:nth-child(odd) td {
background-color: #f4fbff;
}
.demo-table tbody tr:hover th,
.demo-table tbody tr:hover td {
background-color: #ffffa2;
border-color: #ffff0f;
transition: all .2s;
}
.table-container {
overflow: auto;
}
/* side bar jqery*/
@media only screen and (max-width: 480px) {
table {
width: 100%;
}
thead th.column-primary {
width: 100%;
}
thead th:not(.column-primary) {
display:none;
}
th[scope="row"] {
vertical-align: top;
}
td {
display: block;
width: auto;
text-align: right;
}
thead th::before {
text-transform: uppercase;
font-weight: bold;
content: attr(data-header);
}
thead th:first-child span {
display: none;
}
td::before {
float: left;
text-transform: uppercase;
font-weight: bold;
content: attr(data-header);
}
}
</style>
</head>
<body id="page-top">
<body>
<!-- Page Wrapper -->
<div id="wrapper">
<?php include "sidebar006.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">
<h4><b>Data Anggota Invoice Iuran</b></h4>
<br>
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>No</th>
<th>No_Invoice</th>
<th>Tanggal_Invoice</th>
<th>Nama</th>
<th>Telp</th>
<th>Status</th>
<th>Periode</th>
<th>Tanggl_bayar</th>
<th>Awal_Iuran</th>
<th>Akhir_Iuran</th>
<th>Nominal</th>
<th>Bukti_trans</th>
<th> Action Bayar</th>
<th> Bantu</th>
<th>Hapus</th>
</tr>
</thead>
<tbody >
<?php
//require 'config.php';// where pake kutip
// $hari = date('Y-m-d');
// $row = $konek->query("SELECT * FROM h_anggota where tgliuran <= '$hari' AND tunggakan='bayar' order by tgl_daf,keterangan ") or die(mysqli_error());
//$noinv=$_GET['noinv'];
$npm=$_GET['npm'];
$hari = date('Y-m-d');
// $row = $konek->query("SELECT * FROM b_inv where status='bayar' order by tglinv DESC ") or die(mysqli_error());
$row = $konek->query("SELECT a.*,b.telp FROM b_inv a,h_anggota b where a.status='bayar' and a.npm=b.npm order by a.tglinv DESC ") or die(mysqli_error());
// $row = $konek->query("SELECT a.*,b.tgl_daf FROM h_registrasi a,h_anggota2npa b where a.npa=b.npa AND data='New' order by tgl_reg") or die(mysqli_error());
$hari = date('Y-m-d');
$no = 1;
while($fetch = $row->fetch_array()){
// $str= $fetch['mbstr'];
// $date = new DateTime($str);
// $mbstr = $date->format('d-m-Y');
//
// $tgliuran= $fetch['tgliuran'];
// $date = new DateTime($tgliuran);
// $iuran= $date->format('d-m-Y');
//
// // $tglmasuk= $fetch['tgl_reg'];
//// $date = new DateTime($tglmasuk);
//// $tglberkas= $date->format('d-m-Y');
//
// $tgldaf= $fetch['tgl_daf'];
// $date = new DateTime($tgldaf);
// $tgldaftar= $date->format('d-m-Y');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['noinv']?></td>
<td><?php echo $fetch['tglinv']?></td>
<td><?php echo $fetch['nmlead']?></td>
<td><?php echo $fetch['telp']?></td>
<td><?php echo $fetch['status']?></td>
<td data-header='Periode'><?php echo $fetch['periode'] ?></td>
<td data-header='Periode'><?php echo $fetch['tgl_bayar'] ?></td>
<td data-header='Tanggal Awal Iuran'><?php echo $fetch['tgl_awal'] ?></td>
<td data-header='Tanggal Akhir Iuran'><?php echo $fetch['tgl_akhir'] ?></td>
<td data-header='Nominal'><span class='merah'><?php echo $fetch['nominal'] ?></span></td>
<td>
<a href="../files/<?php echo $fetch['gambar']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<img src="../files/<?php echo $fetch['gambar']; ?>" style="width:100%;"/> </a>
<br>
<a href="../anggota/kwitansi/<?php echo $fetch['gambar']; ?>" title="Bukti Trans User" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<img src="../anggota/kwitansi/<?php echo $fetch['gambar']; ?>" style="width:100%;"/> </a>
</td>
<td><a class='btn btn-success btn-success' href='valid_iuran.php?npm=<?php echo $fetch['npm']; ?>&noinv=<?php echo $fetch['noinv']; ?>'>Validasi </a></td>
<td><a class='btn btn-success btn-warning' href='bantu_bayar_iur.php?npm=<?php echo $fetch['npm']; ?>&noinv=<?php echo $fetch['noinv']; ?>'>Bantu revisi </a></td>
<td><a class='btn btn-danger btn-warning' href='del_iur.php?npm=<?php echo $fetch['npm']; ?>&id=<?php echo $fetch['id_tagihan']; ?>'>Hapus Duplikat </a></td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<?php include "footer.php";?>
</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>