| Server IP : 185.124.137.173 / 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 "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 12px Tahoma, Geneva, sans-serif;
}
table tr {
font: normal 12px Tahoma, Geneva, sans-serif;
}
#button-blue{
font-family: 'Montserrat', Arial, Helvetica, sans-serif;
float:left;
width: 100%;
border: #fbfbfb solid 4px;
cursor:pointer;
background-color: #3498db;
color:white;
font-size:16px;
padding-top:22px;
padding-bottom:22px;
-webkit-transition: all 0.3s;
-moz-transition: all 0.3s;
transition: all 0.3s;
margin-top:-4px;
font-weight:500;
height: 50px;
}
#button-blue:hover{
background-color: rgba(0,0,0,0);
color: #0493bd;
}
/* 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 "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">
<center><h4>Pembayaran p2kb Cabang </h4><center>
<br>
<table class="table table-bordered" id="dataTable" width="80%" cellspacing="0">
<thead>
<tr>
<th>No</th>
<th>Nama</th>
<th>No Inv</th>
<th>Total Bayar</th>
<th>p2kb Cabang</th>
<th>Iuran</th>
<th>Tgl Bayar</th>
<th>Bukti Trans</th>
<th>Status</th>
<th>Keterangan</th>
<th>Validasi</th>
<th>Inv</th>
<th>Cek</th>
</tr>
</thead>
<tbody >
<?php
$hari = date('Y-m-d');
//require 'config.php';
// $row = $konek->query("SELECT * FROM b_inv3 where validasi='' and noreg='$_GET[noreg]' ") or die(mysqli_error());
$row = $konek->query("SELECT b_inv3.*, h_registrasi.stat_ang FROM b_inv3,h_registrasi where h_registrasi.noreg=b_inv3.noreg AND b_inv3.validasi='' and b_inv3.noreg='$_GET[noreg]' group by b_inv3.noreg DESC ") 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'];
?>
<tr>
<form method="post" action="v_invadmp2kb.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['noinv']?>
<br>
Keterangan:
<?php echo $fetch['keterangan']?> </td>
<td><span class='merah'><?php echo $fetch['bayarall']?></span></td>
<?php
IF($fetch['stat_ang']=='non' ){
?>
<td><span class='merah'><?php echo $fetch['brekom']?></span></td>
<?php
}else{
?>
<td><span class='merah'><?php echo $fetch['nominal']?></span></td>
<?php
}
?>
<td><span class='merah'><?php echo $fetch['biuran']?></span></td>
<td><?php echo $fetch['tgl_bayar']?></td>
<td>
<?php
if($fetch['stat_ang'] <> 'non'){
?>
<a href="../anggota/files/<?php echo $fetch['gambar']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<img src="../anggota/files/<?php echo $fetch['gambar']; ?>" style="width:100%;"/> </a>
<?php
}else{
?>
<a href="../nonanggota/files/<?php echo $fetch['gambar']; ?>" title="Foto Bukti!" class="MagicZoom" rel="zoom-id:zoom;opacity-reverse:true; ">
<img src="../nonanggota/files/<?php echo $fetch['gambar']; ?>" style="width:100%;"/> </a>
<?php
}
?>
<br>
</p>
<a href="downloadtrs.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 type="SUBMIT" name="SUBMIT" class="btn btn-danger" value="Validasi" >
</form>
</td>
<?php
}else{
?>
<td ><?php echo "-" ?></td>
<?php
}
?>
<td data-header='Status' align='center' >
<?php
IF($fetch['status'] == 'finish'){
?>
<a class='btn btn-danger btn-sm' href='invoice.php?npm=<?php echo $fetch['npm']; ?>'>kirim ulang Invoice</a>
<?php
}else{
echo "-";
}
?>
</td>
<td><a class='btn btn-success btn-sm' href='edt_note.php?&noreg=<?php echo $fetch['noreg']; ?>&npm=<?php echo $fetch['npm']; ?>'>Edit Ket</a> </td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
<br><br><br>
<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_inv3 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 -->
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
//variabel untuk menampung inputan dari form
$id = $_POST['id'];
$npm = $_GET['npm'];
$noreg = $_GET['noreg'];
$nmlead = $_POST['nmlead'];
$tahap = $_POST['tahap']+1;
$dokumen = $_POST['doc'];
$keterangan = $_POST['ket'];
$status = $_POST['status'];
$tgl_cek = $_POST['tgl_cek'];
$tgl_reg = $_POST['tgl_reg'];
$ktp = $_POST['ktp'];
$sir = $_POST['sir'];
$foto = $_POST['foto'];
// simpan inputan user ke variabel
// $userInput = array('ket' => $data);
if($npm ==''){
echo "Form Belum lengkap Pilih Status....";
$nmlead=$userInput['ket'];
}else{
//mysqli_query($konek, "INSERT INTO d_reg(kota,tujuan,npm,tanggal,nmlead,telp,email,jmin,jmbls,keterangan,sumber,project)
// values('$kota','$tujuan','$npm','$tanggal','$nmlead','$telp','$email','$jmin','$jmbls','$ket','$sumber','$project')");
//mysqli_query($konek, "INSERT INTO d_progres(npm,noreg,tgl_cek,tgl_reg,nmlead,tahap,dokumen,status,keterangan)
// values('$npm','$noreg','$tgl_cek','$tgl_reg','$nmlead','$tahap','$dokumen','$status','$keterangan')");
$update = mysqli_query($konek, "UPDATE d_progres SET foto='$foto', sir='$sir',ktp='$ktp',data='chek',status='$status',keterangan='$keterangan',tgl_cek='$tgl_cek' WHERE id_tagihan='$id'");
//$update = mysqli_query($konek, "UPDATE d_reg SET kode='$data',type='$type',harga='$harga',cara_byr='$cara_byr',informasi='$catatan' WHERE d_reg.id_tagihan= '$_GET[id]'");
header('location:index.php');
//echo "$id";
if(!$update){
echo "Update data gagal...";
}else{
header('location:index.php');
}
}
}
?>
</div>
<head>
<script type="text/javascript" src="chartjs/Chart.js"></script>
</head>
<?php
$produk = mysqli_query($konek,"select ahli,count(ahli) as jumlah from d_praktek group by ahli ");
while($row = mysqli_fetch_array($produk)){
$nama_produk[] = $row['ahli'];
$total[] = $row['jumlah'];
//$query = mysqli_query($koneksi,"select count(nmlead) as jumlah from d_reg where npm='2001001' group by nmlead ");
//$row = $query->fetch_array();
//$jumlah_produk[] = $row['jumlah'];
}
?>
</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>