| Server IP : 88.222.222.29 / Your IP : 216.73.217.31 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_inv2 WHERE id_tagihan='$id'");
$sql = mysqli_query($konek, "select * from b_inv3 WHERE id_tagihan='$id'");
$no=1;
$total =0;
while($d=mysqli_fetch_array($sql)){
$iuran = $d['tgliuran'];
$ket = $d['keterangan'];
$nmlead = $d['nmlead'];
$noinv = $d['noinv'];
$level = $d['level'];
$npm = $d['npm'];
$tgliuran = $d['tgliuran'];
$nominal = $d['nominal'];
$bayar = $d['bayar'];
$sisa = $d['nominal']-$d['bayar'];
$kta = $_POST['kta'];
$npm = $d['npm'];
$noreg = $d['noreg'];
$hari = date('Y-m-d');
$tglinv = date('Y-m-d');
$nmlead = $d['nmlead'];
$perihal = $d['perihal'];
$periode = $d['periode'];
$persisa = $d['persisa'];
$tbayar = $d['tgl_bayar'];
$byr = $d['iuran'];
$perbyr = $periode-$persisa;
// $alamat = $d['alamat'];
// $status = $d['status'];
$ket = 'Inv baru';
$tingkat = $d['level'];
//$iuran = $d['iuran'];
}
//$nostr = $_POST['nostr'];
//$tglinv = $_POST['tglinv'];
//$nominal = $sisa;
//$tglexp = $tgliuran;
//$iuran = $_POST['iuran'];
$tglval = date('Y-m-d');
if($validasi =='valid'){
$status = "lunas";
// $day = 'IAB';
//
// $dayList = array(
// 'IAB' => 'IAB',
// 'AGD' => 'AGD',
// 'Allegria' => 'ALG'
// );
//
//$query = mysqli_query($konek, "SELECT max(noinv) as kodeTerbesar FROM b_inv2 ");
//$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 iuran='$tgliuran',tgliuran='$tgliuran',pinv='$status',nominal='$sisa',lunas='$status',iustat='$status' WHERE npm='$npm' AND noreg='$noreg'");
mysqli_query($konek, "UPDATE h_regang SET bayar='lunas' WHERE npm='$npm'");
mysqli_query($konek, "UPDATE b_inv3 SET status='$status',
tglval='$tglval',validasi='valid' WHERE npm='$npm' AND id_tagihan='$id' ");
$bulanIndo = array(
'01' => 'Januari',
'02' => 'Februari',
'03' => 'Maret',
'04' => 'April',
'05' => 'Mei',
'06' => 'Juni',
'07' => 'Juli',
'08' => 'Agustus',
'09' => 'September',
'10' => 'Oktober',
'11' => 'November',
'12' => 'Desember'
);
//membuat tagihan (ambil banyak bulan $per periode bulan dimulai dari awal transaksi dan menyimpan tagihan di tabel iuran
for($i=0; $i<$perbyr; $i++){
//membuat tanggal jatuh tempo nya setiap tanggal 10
$jatuhtempo = date("Y-m-d", strtotime("+$i month", strtotime($tbayar)));
$bulan = $bulanIndo[date('m', strtotime($jatuhtempo))]." ".date('Y',strtotime($jatuhtempo));
mysqli_query($konek, "INSERT INTO iuran(npm,noreg,tgl_bayar,bulan,bayar,periode,nmlead,tgliuran,kta,perbayar,total,perihal)
values('$npm','$noreg','$jatuhtempo','$bulan','$byr','$periode','$nmlead','$tgliuran','$kta','$perbyr','$bayar','$perihal')");
}
header("location:stat_ang.php?npm=$npm&noreg=$noreg&id=$id");
// values('$npm','$noreg','$kodeid','$tglinv','$nmlead','$tglexp','$iuran','$alamat','$nostr','$nominal','tagihan','$ket')");
}else {
//mysqli_query($konek, "UPDATE h_regang SET bayar='proses' WHERE noreg='$noreg'");
mysqli_query($konek, "UPDATE b_inv3 SET validasi='non',keterangan='Kirim Ulang bukti Trans' WHERE id_tagihan='$id' ");
header("location:stat_ang.php?npm=$npm&noreg=$noreg&id=$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')");
}
?>