| Server IP : 91.108.119.162 / 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';
//$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'];
$mbstr = $d['mbstr'];
// $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'];
// $alamat = $d['alamat'];
// $status = $d['status'];
$ket = 'Inv baru';
$tingkat = $d['level'];
$kode = $d['kode'];
//$iuran = $d['iuran'];
}
$tglval = date('Y-m-d');
if($kode=='1'){
if($validasi='valid'){
$status = "lunas";
// mysqli_query($konek, "UPDATE h_registrasi SET iuran='$tgliuran',tgliuran='$tgliuran',pinv='$status',nominal='$sisa',lunas='$status',iustat='$status' WHERE npm='$npm' AND noreg='$noreg'");
mysqli_query($konek, "UPDATE h_anggota SET tgliuran='$tgliuran',b_iuran='lunas' 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:bayar_adm.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);
//$update = mysqli_query($konek, "UPDATE h_registrasi SET lunas='proses',tgliuran='$tgliuran',nominal='$nominal' WHERE npm='$npm'");
// mysqli_query($konek, "UPDATE h_registrasi SET pinv='tagihan',iuran='$iuran' 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_inv(npm,noreg,noinv,tglinv,nmlead,tglexp,tgliuran,nominal,status,keterangan,level)
values('$npm','$noreg','$kodeid','$tglinv','$nmlead','$iuran','$tgliuran','$nominal','tagihan','$ket','$tingkat')");
}
}else {
$status = "lunas";
mysqli_query($konek, "UPDATE h_anggota SET b_str='lunas',mbstr='$mbstr' 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:bayar_adm.php?npm=$npm&noreg=$noreg&id=$id");
}
?>