| Server IP : 153.92.12.177 / 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";
//variabel untuk menampung inputan dari form
$npm = $_POST['npm'];
//$noreg = $_POST['noreg'];
$ket = $_POST['note'];
$periode = $_POST['periode'];
$nmlead = $_POST['nmlead'];
$alamat = $_POST['alamat'];
$nostr = $_POST['nostr'];
$tglinv = $_POST['tglinv'];
$transaksi = $_POST['transaksi'];
$nominal = $_POST['nominal'];
$awaliur1 = $_POST['awaliur'];
$akhiriur1 = $_POST['akhiriur'];
$npa = $_POST['npa'];
$mbstr1 = $_POST['mbstr'];
//$iuran = $_POST['iuran'];
$awaliur = date('Y-m-d', strtotime($awaliur1)); // Hasil Ymd
$akhiriur = date('Y-m-d', strtotime($akhiriur1)); // Hasil Ymd
$mbstr = date('Y-m-d', strtotime($mbstr1)); // Hasil Ymd
////mencari selisih bulan
//
////$date = date("Y-m-d");
////$timeStart = strtotime("2022-01-01");
////$timeEnd = strtotime("$date");
//// Menambah bulan ini + semua bulan pada tahun sebelumnya
//$numBulan = 1 + (date("Y",$akhiriur)-date("Y",$awaliur))*12;
//// menghitung selisih bulan
//$numBulan += date("m",$timeEnd)-date("m",$timeStart);
//
//echo $numBulan;
//$sqlKelas = mysqli_query($konek, "select * from level where tingkat='$tingkat'");
// while($k=mysqli_fetch_array($sqlKelas)){
// $nominal= $k['nominal'];
// }
$day = 'IVT';
$dayList = array(
'IVT' => 'IVT',
'AGD' => 'AGD',
'Allegria' => 'ALG'
);
//$query = mysqli_query($konek, "SELECT max(substr(noinv,-6,6)) as kodeTerbesar FROM b_inv3 ");
//$data = mysqli_fetch_array($query);
//$kodeBarang = $data['kodeTerbesar'];
$today = date("my");
// $query = mysqli_query($konek, "SELECT max(noinv) AS last FROM b_inv3 WHERE noinv LIKE '$today%'");
$query = mysqli_query($konek, "SELECT max(substr(noinv,-6,6)) AS last FROM b_inv ");
$data = mysqli_fetch_array($query);
$lastNoBayar = $data['last'];
$lastNoUrut = substr($lastNoBayar, -6, 6);
$nextNoUrut = $lastNoUrut + 1;
$nextNoBayar = "IUR".$today.sprintf('%06s', $nextNoUrut);
//$update = mysqli_query($konek, "UPDATE h_registrasi SET lunas='proses',tgliuran='$tgliuran',nominal='$nominal' WHERE npm='$npm'");
$update = mysqli_query($konek, "UPDATE h_anggota SET tunggakan='proses' WHERE npm='$npm' ");
mysqli_query($konek, "INSERT INTO b_inv(npm,noinv,tglinv,nmlead,alamat,nostr,nominal,status,keterangan,transaksi,tgl_awal,tgl_akhir,npa,mbstr,periode)
values('$npm','$nextNoBayar','$tglinv','$nmlead','$alamat','$nostr','$nominal','proses','$ket','$transaksi','$awaliur','$akhiriur','$npa','$mbstr','$periode')");
//insert ke d iuran
mysqli_query($konek, "INSERT INTO d_iuran(npm,nmlead,tgl_bayar,nostr,nominal,tgl_awal,tgl_akhir,npa,jenis, status,mbstr,periode,noinv)
values('$npm','$nmlead','$tglinv','$nostr','$nominal','$awaliur','$akhiriur','$npa','$bayar','iuran','nonvalid','$mbstr','$periode','$nextNoBayar')");
header("location:krm_inv.php?npm=$npm&noinv=$nextNoBayar");
?>