| Server IP : 84.32.84.242 / Your IP : 216.73.216.217 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{
background: #dedede;
font-family: 'Helvetica', arial, sans-serif;
font-size: 10px;
}
.table th,
.table td {
padding: 5px 5px;
font-size:10px;
}
table {
margin: 0 auto;
border-collapse: collapse;
}
tbody {
color: #000;
}
table td {
padding: 5px 5px;
border: 1px solid #e0e0e0;
font: normal 12px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 10px Tahoma, Geneva, sans-serif;
}
#button-blue{
font-family: 'Montserrat', Arial, Helvetica, sans-serif;
float:left;
width: 100%;
height: 40px;
border: #fbfbfb solid 4px;
cursor:pointer;
background-color: #3498db;
color:white;
font-size:12px;
padding:3px;
-webkit-transition: all 0.3s;
-moz-transition: all 0.3s;
transition: all 0.3s;
margin-left:3px;
font-weight:700;
}
#button-blue:hover{
background-color: rgba(0,0,0,0);
color: #0493bd;
}
.submit:hover {
color: #3498db;
}
.ease {
width: 0px;
height: 80px;
background-color: #fbfbfb;
-webkit-transition: .3s ease;
-moz-transition: .3s ease;
-o-transition: .3s ease;
-ms-transition: .3s ease;
transition: .3s ease;
}
.submit:hover .ease{
width:100%;
background-color:#EEE;
}
/* 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 "sidebar004.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">
<center><h4>Data Anggota Baru </h4><center>
<br>
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th>No</th>
<th>Nama</th>
<th>Nominal</th>
<th>Total Periode Byr</th>
<th>Bayar</th>
<th>Periode byr</th>
<th>Periode sisa</th>
<th>Tgl Bayar</th>
<th>Bukti Trans</th>
<th>Status</th>
<th>Keterangan</th>
<th>Validasi</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM b_inv3 where status <>'lunas' and noreg='$_GET[noreg]' ") 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['tglexp'];
// $date = new DateTime($tgliuran);
// $iuran= $date->format('d-m-Y');
// $sisa= $fetch['nominal']-$fetch['bayar'];
$sisa= $fetch['bayar'];
?>
<tr>
<form method="post" action="v_invbaru.php" enctype="multipart/form-data">
<?php
$name = explode('/', $fetch['gambar']);
?>
<td><?php echo $no ?>
<input type='hidden' type="" name="id" value="<?php echo $fetch['id_tagihan']; ?>" readonly>
<input type='hidden' type="" name="noreg" value="<?php echo $fetch['noreg']; ?>" readonly>
</td>
<td><?php echo $fetch['nmlead']?></td>
<td><?php echo $fetch['nominal']?></td>
<td><?php echo $fetch['periode']?></td>
<td><span class='merah'><?php echo $fetch['bayar']?></span></td>
<td><?php echo $fetch['perbyr']?></td>
<td><?php echo $fetch['persisa']?></td>
<td><?php echo $fetch['tgl_bayar']?></td>
<td>
<?php
if($fetch['gambar'] <> ''){
?>
<br>
<center><a href="../baru/files/<?php echo $fetch['gambar']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<img src="../baru/files/<?php echo $fetch['gambar']; ?>" style="width:100%;"/></center>
<br>
<?php
}else{
echo "-";
}
?>
<br>
<a href="downloadbaru.php?file=<?php echo $fetch['gambar'];?>" class="btn btn-primary"><span class="glyphicon glyphicon-download"></span> Download File</a>
</td>
<td data-header='Status'><label>
<select name='validasi'>
<option value="valid">Valid</option>
<option value="unvalid">Tidak Valid</option>
</select>
</label></td>
<td>
<textarea name="ket" rows="6" class="form-control"></textarea>
</td>
<?php
IF($fetch['status']=='bayar' ){
?>
<td>
<input class="form-control" type="SUBMIT" name="SUBMIT" id="button-blue" value="Validasi" >
</form>
</td>
<?php
}else{
?>
<td ><?php echo "-" ?></td>
<?php
}
?>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<br><br><br>
<center><h4>Data Anggota Sudah bayar Invoice </h4><center>
<br><br>
<table class="demo-table responsive">
<thead>
<tr>
<th>No</th>
<th>No Invoice</th>
<th>No reg</th>
<th>Nama</th>
<th>Bayar</th>
<th>Exp Berikutnya</th>
<th>Status</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM b_inv3 where validasi ='x' AND level='anggota_baru' ") 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');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['noinv']?></td>
<td><?php echo $fetch['noreg']?></td>
<td><?php echo $fetch['nmlead']?></td>
<td><?php echo $fetch['nominal']?></td>
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<td data-header='Masa berlaku Iuran'><span class='merah'><?php echo $iuran; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku Iuran'><?php echo $iuran ?></td>
<?php
}
?>
<td><?php echo $fetch['validasi']?></td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<center><h4>Data Anggota Unvalid </h4><center>
<br><br>
<table class="demo-table responsive">
<thead>
<tr>
<th>No</th>
<th>No Invoice</th>
<th>No reg</th>
<th>Nama</th>
<th>Bayar</th>
<th>Exp Berikutnya</th>
<th>Status</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
$row = $konek->query("SELECT * FROM b_inv where validasi ='unvalid' ") 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');
?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $fetch['noinv']?></td>
<td><?php echo $fetch['noreg']?></td>
<td><?php echo $fetch['nmlead']?></td>
<td><?php echo $fetch['nominal']?></td>
<?php
IF($fetch['tgliuran'] < $hari ){
?>
<td data-header='Masa berlaku Iuran'><span class='merah'><?php echo $iuran; ?></span></td>
<?php
}else{
?>
<td data-header='Masa berlaku Iuran'><?php echo $iuran ?></td>
<?php
}
?>
<td><?php echo $fetch['validasi']?></td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</div>
<!-- proses edit data -->
</div>
</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>