| Server IP : 185.124.137.38 / 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 = $_GET['npm'];
//$noreg = trim($_GET['noreg']);
//$noreko = $_GET['noreko'];
//$status = 'valid';
$sql=mysqli_query($konek, "SELECT * From h_anggota WHERE npm='$npm' ");
//
$e=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$tgl_awal=$e['awalmbstr'];
$tgl_akhir=$e['tgliuran'];
$awaltempo=$e['tgl_awal'];
$nmlead=$e['nmlead'];
//$nomiur=$e['nom_iur'];
$awaltempo=$e['awalmbstr'];
//mysqli_query($konek, "INSERT INTO d_iuran(npm,tgl_reg,nmlead,tgl_awal,tgl_akhir,nom_iur,jenis,nostr,mbstr,status,stat_ang,tglbayar_iur,npa,validasi,foto,noreg,nokwit,periode)
// values('$npm','$sekarang','$nmlead','$awaltgliuran','$tgliuran','$total5','iuran','$nostr',
// '$mbstr','update','anggota','$tglbayar','$npa','valid','$fotobaru2','$noreg','$noreg','$numBulan')");
//Nomor kwit/noreg
$day = 'ADM';
$dayList = array(
'ADM' => 'ADM',
'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);
//$noreg='1234';
$timeStart = strtotime("$tgl_awal");
$timeEnd = strtotime("$tgl_akhir");
// Menambah bulan ini + semua bulan pada tahun sebelumnya
$numBulan = 1 + (date("Y",$timeEnd)-date("Y",$timeStart))*12;
// menghitung selisih bulan
$numBulan += date("m",$timeEnd)-date("m",$timeStart);
//mysqli_query($konek,"INSERT INTO d_iuran (npm,noreg,tglbayar_iur,nmlead,stat_ang,jenis)
// SELECT npm,'$noreg',tglbayar_iur,nmlead,'anggota','iuran' FROM h_anggota WHERE npm ='$npm'");
$sql=mysqli_query($konek, "SELECT kat_nm,nominal FROM level WHERE kat_nm='bulanan'");
$u = mysqli_fetch_array($sql);
$nomiur=$u['nominal'];
$total5=$numBulan*$nomiur;
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)
SELECT
npm,'$noreg',tglbayar_iur,nmlead,'anggota','iuran','$tgl_awal','$tgl_akhir','$total5','$numBulan','valid','$noreg','1'
FROM h_anggota WHERE npm ='$npm'");
//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));
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','$nomiur','$tahun','valid')");
}
header("location:rev_iur2v.php?npm=$npm&noreg=$noreg");
?>