| Server IP : 88.223.91.242 / 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'];
$npm = $_POST['npm'];
$validasi = $_POST['validasi'];
$tglakhir = $_POST['tglakhir'];
$tglawal = $_POST['tglawal'];
$noinv = $_POST['noinv'];
$tglval = date('Y-m-d');
mysqli_query($konek, "UPDATE h_anggota SET b_iuran='',tunggakan='lunas',tgliuran='$tglakhir',
awalmbstr='$tglawal'
WHERE npm='$npm'");
mysqli_query($konek, "UPDATE b_inv SET keterangan='$ket',validasi='$validasi',status='lunas' WHERE id_tagihan='$id' ");
//update d_iuran, unvalid iuran sebelumya dan validkan yg baru
//input kedalam d_iuran
$sql=mysqli_query($konek, "SELECT * From b_inv WHERE id_tagihan='$id' ");
//
$e=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$npa =$e['npa'];
$nmlead =$e['nmlead'];
$mbstr =$e['mbstr'];
$tglbayar = $e['tgl_bayar'];
$nominal = $e['nominal'];
$total5 = $e['bayar'];
$gambar = $e['gambar'];
$periode = $e['periode'];
$tglawal = $e['tgl_awal'];
$tglakhir = $e['tgl_akhir'];
$noinv = $e['noinv'];
$bulanan = $e['bulanan'];
$awaltempo = $e['tgl_awal'];
$numBulan = $e['periode'];
//Nomor kwit/noreg
$day = 'REK';
$dayList = array(
'REK' => 'REK',
'AGD' => 'AGD',
'Allegria' => 'ALG'
);
$query = mysqli_query($konek, "SELECT max(substr(noreg,-4,4)) as kodeTerbesar FROM d_iuran ");
$data = mysqli_fetch_array($query);
$kodeBarang = $data['kodeTerbesar'];
$urutan = (int) substr($kodeBarang, -4, 4);
$urutan++;
$huruf = $dayList[$day];
$waktu=date('dmy');
$noreg= $huruf.$waktu."IUR".sprintf("%04s", $urutan);
mysqli_query($konek, "UPDATE h_anggota SET tgliuran='$tglakhir' WHERE npm='$npm'");
$sekarang = date('Y-m-d');
mysqli_query($konek, "INSERT INTO d_iuran(npm,tgl_reg,nmlead,tgl_awal,tgl_akhir,nom_iur,jenis,mbstr,status,stat_ang,tglbayar_iur,npa,validasi,foto,noreg,nokwit,periode,nominal)
values('$npm','$sekarang','$nmlead','$tglawal','$tglakhir','$total5','iuran',
'$mbstr','update','anggota','$tglbayar','$npa','valid','$gambar','$noreg','$noinv','$periode','$bulanan')");
//Buat buku piutang
// Membuat Array untuk menampung bulan bahasa indonesia
$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'
);
//Buat catatan pemb
//$spp='30000';
// $tahun=date("Y",strtotime($awaltgliuran));
// $awaltempo= $_POST['awaltgliuran'];
for($i=0; $i<$numBulan; $i++){
//membuat tanggal jatuh tempo nya setiap tanggal 10
$jatuhtempo = date("Y-m-d", strtotime("+$i month", strtotime($awaltempo)));
$bulan = $bulanIndo[date('m', strtotime($jatuhtempo))]." ".date('Y',strtotime($jatuhtempo));
$tahun=date("Y",strtotime($jatuhtempo));
mysqli_query($konek, "INSERT INTO d_bulan(noreg,npm,nama,jatuhtempo,bulan,jumlah,tahun,status)
values('$noreg','$npm','$nmlead','$jatuhtempo','$bulan','$bulanan','$tahun','valid')");
}
$query="UPDATE h_anggota SET tgliuran='$tglakhir' WHERE npm='$npm'"; //blm berhasil ubah ke db
$sql=mysqli_query($konek, $query);
if($sql){
echo "<script>alert('Data Iuran Anggota Berhasil Di update'); window.location='vld_invbyr.php?npm=$npm'</script>";
// echo "<script>alert('Data Iuran Anggota Berhasil Di update');window.history.go(-1);</script>";
}else{
die("Update Iuran data gagal".mysqli_connect_error());
}
//// header("location:data_byriur.php?npm=$npm");
//header("location:vld_invbyr.php?npm=$npm");