| Server IP : 91.108.119.104 / 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';
// include 'header.php';
include 'koneksi.php';
//$id = $_GET['id'];
//$npm = trim($_GET['npm']);
//$noreg = trim($_GET['noreg']);
//$tgliuran = ($_GET['tgliuran']);
//$sisa = $_GET['sisa'];
//$status = 'lunas';
//$supervisor= $_GET['supervisor'];
// mysqli_query($konek, "update h_registrasi SET pinv='$status',lunas='$status',iuran='$tgliuran' WHERE npm='$npm' AND noreg='$noreg' ");
//mysqli_query($konek, "UPDATE b_inv SET status='$status' WHERE npm='$npm' AND noreg='$noreg' ");
//header("location:invoice.php?noreg=$noreg&npm=$npm ");
?>
<?php
//variabel untuk menampung inputan dari form
$id = $_POST['id'];
$ket = $_POST['ket'];
$noreg = $_POST['noreg'];
//$tgliuran = ($_GET['tgliuran']);
//$sisa = $_GET['sisa'];
$validasi = ($_POST['validasi']);
$sql = mysqli_query($konek, "select * from b_inv3 WHERE id_tagihan='$id'");
$no=1;
$total =0;
while($d=mysqli_fetch_array($sql)){
$iuran = $d['tglexp'];
$ket = $d['keterangan'];
$nmlead = $d['nmlead'];
$noinv = $d['noinv'];
$level = $d['level'];
$npm = $d['npm'];
$tgliuran = $d['tgliuran'];
$sisa = $d['nominal']-$d['bayar'];
$npm = $d['npm'];
$noreg = $d['noreg'];
$hari = date('Y-m-d');
$tglinv = date('Y-m-d');
$nmlead = $d['nmlead'];
$tglexp = $d['tglexp'];
$biuran = $d['biuran'];
// $status = $d['status'];
$ket = 'Inv baru';
$tingkat = $d['level'];
$periode = $d['periode'];
}
//$nostr = $_POST['nostr'];
//$tglinv = $_POST['tglinv'];
//$nominal = $sisa;
//$tglexp = $tgliuran;
//$iuran = $_POST['iuran'];
$tglval = date('Y-m-d');
if($validasi =='valid'){
$status = "lunas";
mysqli_query($konek, "UPDATE h_registrasi SET adm='$status',status2='valid' WHERE npm='$npm' AND noreg='$noreg'");
//mysqli_query($konek, "update h_registrasi SET pinv='$status',lunas='$status',iuran='$tgliuran' WHERE npm='$npm' AND noreg='$noreg' ");
//mysqli_query($konek, "UPDATE h_anggota SET tgliuran='$tgliuran' WHERE npm='$npm'");
mysqli_query($konek, "UPDATE b_inv3 SET status='$status',
tglval='$tglval',validasi='valid' WHERE npm='$npm' AND id_tagihan='$id' ");
if ($biuran==0){
}else{
mysqli_query($konek, "UPDATE h_nonanggota SET tgliuran='$tgliuran' WHERE npm='$npm' ");
}
header("location:upd_sip2.php?npm=$npm&noreg=$noreg&id=$id");
}else {
//
// $sqlKelas = mysqli_query($konek, "select * from level where tingkat='$tingkat'");
// while($k=mysqli_fetch_array($sqlKelas)){
// $nominal= $k['nominal'];
// }
//
//
//
//
//
// $day = 'INV';
//
// $dayList = array(
// 'INV' => 'INV',
// 'AGD' => 'AGD',
// 'Allegria' => 'ALG'
// );
//
//$query = mysqli_query($konek, "SELECT max(noinv) as kodeTerbesar FROM b_inv3 ");
//$data = mysqli_fetch_array($query);
//$kodeBarang = $data['kodeTerbesar'];
//
//
//$urutan = (int) substr($kodeBarang, -3, 3);
//$urutan++;
//$huruf = $dayList[$day];
//$kodeid= $huruf . sprintf("%03s", $urutan);
mysqli_query($konek, "UPDATE h_registrasi SET adm='proses' WHERE noreg='$noreg'");
mysqli_query($konek, "DELETE FROM b_inv3 WHERE noreg='$noreg' ");
// mysqli_query($konek, "UPDATE b_inv3 SET ket='$ket',validasi='$validasi' WHERE id_tagihan='$id' ");
//
// mysqli_query($konek, "INSERT INTO b_inv3(npm,noreg,noinv,tglinv,nmlead,nominal,status,keterangan,level)
// values('$npm','$noreg','$kodeid','$tglinv','$nmlead','$nominal','tagihan','$ket','$tingkat')");
header("location:upd_sip2.php?npm=$npm&noreg=$noreg&id=$id");
}
?>