| Server IP : 88.223.91.32 / 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']);
//$noreko = $_GET['noreko'];
//$status = 'valid';
$sql=mysqli_query($konek, "SELECT * From h_regang WHERE npm='$npm' ");
//
$e=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$tgl_daf=$e['tgl_daf'];
//$noreg =$e['noreg'];
$update3 = mysqli_query($konek, "UPDATE b_inv3 SET tgl_awal='$tgl_daf' WHERE npm= '$npm' AND stat_ang='AB'");
//input otomatis data iuran
mysqli_query($konek,"INSERT INTO d_iuran (npm,noreg,tglbayar_iur,nmlead,stat_ang,jenis,tgl_awal,tgl_akhir,nom_iur,periode,validasi,nokwit,revisi,tgl_reg)
SELECT
npm,noreg,tgl_bayar,nmlead,'AB','iuran','$tgl_daf',tgliuran,pembinaan,periode,'valid',noreg,'1','$tgl_daf' FROM b_inv3 WHERE npm ='$npm' AND stat_ang='AB'");
// 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
$sql=mysqli_query($konek, "SELECT * From b_inv3 WHERE npm='$npm' AND stat_ang='AB' and perihal='anggota_baru' ");
//
$b=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$periode = $b['periode'];
$awaltempo= $tgl_daf;
//$awaltgliuran=$b['tgl_awal'];
$iuran = $b['iuran'];
//$npa =$b['npa'];
$nmlead =$b['nmlead'];
//cari tahun
//$tahun=date("Y",strtotime($awaltgliuran));
$noreg=$b['noreg'];
for($i=0; $i<$periode; $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','$iuran','$tahun','valid')");
}
header("location:rev_iur2vAB.php?noreg=$noreg&npm=$npm ");
?>