| Server IP : 88.222.222.164 / 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'];
$ket = 'Inv baru';
$tingkat = $d['level'];
$tglbayar = $d['tgl_bayar'];
$biuran = $d['biuran'];
$periode = $d['periode'];
$nomiur = $d['biuran']/$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";
$sql = mysqli_query($konek,"select * from h_registrasi where npm='$npm' AND noreg ='$noreg'");
$dtt=mysqli_fetch_array($sql);
$type=$dtt['type'];
$nostr=$dtt['nostr'];
$mbstr=$dtt['mbstr'];
if ($type=='1') {
mysqli_query($konek, "UPDATE d_iuran SET tgl_bayar='$tglbayar', nominal='$biuran',status='valid',periode='$periode',nom_iur='$nomiur' WHERE npm='$npm' AND noreg='$noreg' ");
}
if ($type=='3') {
mysqli_query($konek,"UPDATE h_nonanggota SET
mbstr='$mbstr',
nostr='$nostr'
where npm='$npm' ");
//yg sebelumnya di nonvalidkan
mysqli_query($konek, "UPDATE d_iuran SET status='nonvalid' WHERE npm='$npm' AND noreg<>'$noreg' ");
mysqli_query($konek, "UPDATE d_iuran SET tgl_bayar='$tglbayar',nominal='$biuran',status='valid',periode='$periode',nom_iur='$nomiur' WHERE npm='$npm' AND noreg='$noreg' ");
}
mysqli_query($konek, "UPDATE h_registrasi SET adm='$status' 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' ");
header("location:upd_sipp2kb.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'];
// mengambil angka dari kode barang terbesar, menggunakan fungsi substr
// dan diubah ke integer dengan (int)
$urutan = (int) substr($kodeBarang, -3, 3);
// bilangan yang diambil ini ditambah 1 untuk menentukan nomor urut berikutnya
$urutan++;
// membentuk kode barang baru
// perintah sprintf("%03s", $urutan); berguna untuk membuat string menjadi 3 karakter
// misalnya perintah sprintf("%03s", 15); maka akan menghasilkan '015'
// angka yang diambil tadi digabungkan dengan kode huruf yang kita inginkan, misalnya BRG
//$huruf = substr("$project",0, 3);
$huruf = $dayList[$day];
$kodeid= $huruf . sprintf("%03s", $urutan);
mysqli_query($konek, "UPDATE h_registrasi SET adm='proses' WHERE noreg='$noreg'");
mysqli_query($konek, "UPDATE b_inv3 SET ket='$ket',validasi='$validasi' WHERE id_tagihan='$id' ");
// $update = mysqli_query($konek, "UPDATE h_registrasi SET noinv='$kodeid',tgliuran='$nextiuran',pinv='tagihan',nominal='$nominal' WHERE npm='$npm' AND noreg='$noreg'");
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')");
}
?>