| Server IP : 185.124.137.82 / Your IP : 216.73.217.31 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/anggota/ |
Upload File : |
<?php
include "header2.php";
// filter data yang diinputkan
// $nmlead = filter_input(INPUT_POST, 'nmlead', FILTER_SANITIZE_STRING);
// $username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING);
// $email = filter_input(INPUT_POST, 'email', FILTER_VALIDATE_EMAIL);
//variabel untuk menampung inputan dari form
$noreg = $_POST['noreg'];
$npm = $_POST['npm'];
$npa = $_POST['npa'];
$tgl_reg = $_POST['tglreg'];
$nmlead = $_POST['nmlead'];
$alamat = $_POST['alamat'];
$telp = $_POST['telp'];
$nostr = $_POST['nostr'];
$ahli = $_POST['ahli'];
$tgliuran = $_POST['iuran'];
$mbstr = $_POST['mbstr'];
$perihal = $_POST['level'];
$hari = date('Y-m-d');
$note = 'Cek Kelengkapan Data Pemohon, Upload dokumen,Tempat Praktek dan Pembayaran';
$alamatmt = $_POST['alamatmt'];
$kotamt = $_POST['kotamt'];
$ktp = $_POST['ktp'];
$kodeid = $_POST['noreg'];
// cek apabila submit tidak valid
$_SESSION['submit'] = true;
if (!$_SESSION['submit']){
echo "<center> <strong>form sudah disubmit sebelumnya!</strong></center>";
if ($perihal=='mutasi'||$perihal=='kehilangan' ){
header("location:updownnon.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli");
}elseif ($perihal=='rekomendasi_SIP_PPDS_II'){
header("location:updown.php?npm=$npmnmlead=$nmlead&noreg=$kodeid&ahli=$ahli");
}else {
// mysqli_query($konek,"INSERT INTO d_praktek SELECT * FROM d_prakang WHERE npm='$npm'");
header("location:d_praktek.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli");
}
header("location:d_praktek.php?npm=$npm&nmlead=$nmlead&ahli=$ahli&view=$view");
}else {
// mengubah session menjadi false setelah submit sukses step 3
$_SESSION['submit'] = false;
// $day = 'REK';
// $dayList = array(
// 'REK' => 'REK',
// 'AGD' => 'AGD',
// 'Allegria' => 'ALG'
// );
//
// $query = mysqli_query($konek, "SELECT max(substr(noreg,-4,4)) as kodeTerbesar FROM h_registrasi ");
// $data = mysqli_fetch_array($query);
// $kodeBarang = $data['kodeTerbesar'];
//
// $urutan = (int) substr($kodeBarang, -4, 4);
//
// $urutan++;
//
// $huruf = $dayList[$day];
// $waktu=date('dmy');
// $kodeid= $huruf.$waktu."IDB".sprintf("%04s", $urutan);
// $_SESSION['kodeid']=$kodeid;
// $_SESSION['noreg']=$kodeid;
$_SESSION['npm']=$npm;
$sqlSiswa = mysqli_query($konek, "SELECT * FROM h_registrasi ");
$ceknik=mysqli_num_rows ($sqlSiswa);
$dcek=mysqli_fetch_array($sqlSiswa);
$view2 = isset($dcek['nmlead']) ? $dcek['nmlead'] : null;
$cksales= $dcek['nmlead'];
$sql = mysqli_query($konek, "SELECT * FROM h_anggota where npm='$npm'");
$cedbk=mysqli_num_rows ($sql);
$db=mysqli_fetch_array($sql);
$npmdb = isset($db['npm']) ? $db['npm'] : null;
//query insert dijalankan
// simpan inputan user ke variabel
$userInput = array('nmlead' => $nmlead);
if($tgliuran<$hari){
$iexp ="expired";
}else{
$iexp ="lunas";
}
if($mbstr<$hari){
$mbexp ="expired";
}else{
$mbexp ="valid";
}
// //hanya bisa satu kali dengan no sama
// // mysqli_query($konek,"INSERT INTO d_praktek SELECT * FROM d_prakang WHERE npm='IDB251121000004'");
// // mysqli_query($konek,"UPDATE d_praktek SET noreg='$_SESSION[kodeid]' where npm='IDB251121000004' and noreg=''");
// mysqli_query($konek, "INSERT INTO h_registrasi(npm,tgl_reg,nmlead,tahap,noreg,status,data,iuran,alamat,nostr,mbstr,ahli,status2,mbstatus,iustat,pinv,perihal,adm,telp,level,ktp,npa,alamatmt,kotamt) values('$npm','$tgl_reg','$nmlead','1','$kodeid','proses','New','$tgliuran','$alamat','$nostr','$mbstr','$ahli','proses','$mbexp','$iexp','$iexp','$perihal','proses','$telp','$perihal','$ktp','$npa','$alamatmt','$kotamt')");
mysqli_query($konek,"UPDATE h_registrasi SET
tgl_reg='$tgl_reg',
nmlead='$nmlead',
tahap='1',
status='proses',
data='New',
iuran='$tgliuran',
alamat='$alamat',
nostr='$nostr',
mbstr='$mbstr',
ahli='$ahli',
status2='proses',
mbstatus='$mbexp',
iustat='$iexp',
pinv='$iexp',
perihal='$perihal',
adm='proses',
telp='$telp',
level='$perihal',
ktp='$ktp',
npa='$npa',
alamatmt='$alamatmt',
kotamt='$kotamt'
where npm='$npm' and noreg='$noreg' ");
mysqli_query($konek, "INSERT INTO d_progres(npm,tgl_reg,nmlead,tahap,noreg,status,data,iuran,nostr,mbstr,status2,note)
values('$npm','$tgl_reg','$nmlead','1','$kodeid','proses','New','$tgliuran','$nostr','$mbstr','proses','$note')");
// mysqli_query($konek,"UPDATE peserta SET noreg='$kodeid' where npm='$npm' and validasi='proses' ");
mysqli_query($konek,"UPDATE peserta SET noreg='$kodeid',validasi='valid',data='New' where npm='$npm' ");
mysqli_query($konek, "DELETE FROM peserta WHERE npm='$npm' AND data='syarat' ");
mysqli_query($konek, "DELETE FROM h_registrasi WHERE npm='$npm' AND data='syarat' ");
if ($perihal=='mutasi' ||$perihal=='kehilangan'){
mysqli_query($konek,"UPDATE h_registrasi SET adm='lunas' where npm='$npm' and noreg='$kodeid' ");
//isi data praktek dari data anggota yg valid dariari d_prakang, jika sudag valid rekomen copy pratek ke prakang untuk update
}
if ($perihal=='mutasi' || $perihal=='kehilangan'){
header("location:updownnon.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli");
}elseif ($perihal=='rekomendasi_SIP_PPDS_II'){
header("location:updown.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli");
}else{
header("location:d_praktek.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli");
}
// header("location:d_praktek.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli&view=$view");
// header("location:data_prak1.php?npm=$npm&nmlead=$nmlead&noreg=$kodeid&ahli=$ahli&view=$view");
}
?>