| Server IP : 88.223.91.199 / 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_nonanggota WHERE npm='$npm' ");
////
//$e=mysqli_fetch_array($sql);
//
////$npm= isset($e['npm']) ? $e['npm'] : null;
//
//
//$tgl_awal=$e['tgl_reg'];
//
//$tgl_akhir=$e['mbstr'];
//$awaltempo=$e['tgl_reg'];
//$nmlead=$e['nmlead'];
////$nomiur=$e['nom_iur'];
//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_pembinaan ");
$data = mysqli_fetch_array($query);
$kodeBarang = $data['kodeTerbesar'];
$urutan = (int) substr($kodeBarang, -4, 4);
$urutan++;
$huruf = $dayList[$day];
$waktu=date('dmy');
$noreg= $huruf.$waktu."PEMB".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;
//input otomatis data iuran
//non anggota type 1 dan 3 bayar iuran type 2 hanyarekom saja di registrasi
mysqli_query($konek,"INSERT INTO d_pembinaan (npm,noreg,tglbayar_iur,nmlead,stat_ang,jenis,tgl_awal,tgl_akhir,nom_iur,periode,validasi,pembinaan,revisi,type,perihal)
SELECT
npm,'$noreg',tgl_bayar,nmlead,'non','pembinaan',tgl_awal,mbstr,biuran,periode,'valid',biuran,'1',type,perihal FROM b_inv3 WHERE npm='$npm' AND stat_ang='non' AND validasi='valid' and type='1' Or type='3' ");
//mysqli_query($konek,"INSERT INTO d_pembinaan (npm,noreg,tglbayar_iur,nmlead,stat_ang,jenis,tgl_awal,tgl_akhir,nom_iur,periode,validasi,nokwit)
// SELECT
// npm,'$noreg',tglbayar_iur,nmlead,'anggota','iuran','$tgl_awal','$tgl_akhir','$total5','$numBulan','valid','$noreg'
// 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));
$sql=mysqli_query($konek, "SELECT * From b_inv3 WHERE npm='$npm' and validasi='valid' ");
//
$b=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$periode = $b['periode'];
$awaltempo= $b['tgl_awal'];
$nmlead= $b['nmlead'];
$type= $b['type'];
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_bulannon(noreg,npm,nama,jatuhtempo,bulan,jumlah,tahun,status)
values('$noreg','$npm','$nmlead','$jatuhtempo','$bulan','$nomiur','$tahun','valid')");
}
header("location:rev_iur2vnon.php?npm=$npm&noreg=$noreg");
?>