| Server IP : 88.223.91.92 / 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/superadmin/ |
Upload File : |
<?php include "header.php"; ?>
<?php
// memulai session
// jika session belum dibuat, maka inisialisasi awal diberi nilai TRUE
if (!isset($_SESSION['submit'])) {
$_SESSION['submit'] = true;
}
//
?>
<style type="text/css">
<!--
.style2 {
font-size: 12px;
font-weight: bold;
}
.style3 {font-size: 12px}
-->
@import url(http://fonts.googleapis.com/css?family=Montserrat:400,700);
html{
background-size: cover;
height:100%;
}
#feedback-page{
text-align:center;
}
#form-main{
width:100%;
float:left;
padding-top:0px;
}
#form-div {
background-color:rgba(72,72,72,0.4);
padding-left:35px;
padding-right:35px;
padding-top:35px;
padding-bottom:50px;
width: 800px;
float: left;
left: 50%;
margin-top:30px;
margin-left: 100px;
-moz-border-radius: 7px;
-webkit-border-radius: 7px;
}
.feedback-input {
color:#3c3c3c;
font-family: Helvetica, Arial, sans-serif;
font-weight:500;
font-size: 18px;
border-radius: 0;
line-height: 22px;
background-color: #fbfbfb;
padding: 13px 13px 13px 54px;
margin-bottom: 10px;
width:100%;
-webkit-box-sizing: border-box;
-moz-box-sizing: border-box;
-ms-box-sizing: border-box;
box-sizing: border-box;
border: 3px solid rgba(0,0,0,0);
}
.feedback-input:focus{
background: #fff;
box-shadow: 0;
border: 3px solid #3498db;
color: #3498db;
outline: none;
padding: 13px 13px 13px 54px;
}
.focused{
color:#30aed6;
border:#30aed6 solid 3px;
}
/* Icons ---------------------------------- */
#name{
background-image: url(http://rexkirby.com/kirbyandson/images/name.svg);
background-size: 30px 30px;
background-position: 11px 8px;
background-repeat: no-repeat;
}
#name:focus{
background-image: url(http://rexkirby.com/kirbyandson/images/name.svg);
background-size: 30px 30px;
background-position: 8px 5px;
background-position: 11px 8px;
background-repeat: no-repeat;
}
#email{
background-image: url(http://rexkirby.com/kirbyandson/images/email.svg);
background-size: 30px 30px;
background-position: 11px 8px;
background-repeat: no-repeat;
}
#email:focus{
background-image: url(http://rexkirby.com/kirbyandson/images/email.svg);
background-size: 30px 30px;
background-position: 11px 8px;
background-repeat: no-repeat;
}
#comment{
background-image: url(http://rexkirby.com/kirbyandson/images/comment.svg);
background-size: 30px 30px;
background-position: 11px 8px;
background-repeat: no-repeat;
}
textarea {
width: 100%;
height: 150px;
line-height: 150%;
resize:vertical;
}
input:hover, textarea:hover,
input:focus, textarea:focus {
background-color:white;
}
#button-blue{
font-family: 'Montserrat', Arial, Helvetica, sans-serif;
float:left;
width: 100%;
border: #fbfbfb solid 4px;
cursor:pointer;
background-color: #3498db;
color:white;
font-size:24px;
padding-top:22px;
padding-bottom:22px;
-webkit-transition: all 0.3s;
-moz-transition: all 0.3s;
transition: all 0.3s;
margin-top:-4px;
font-weight:700;
}
#button-blue:hover{
background-color: rgba(0,0,0,0);
color: #0493bd;
}
.submit:hover {
color: #3498db;
}
.ease {
width: 0px;
height: 74px;
background-color: #fbfbfb;
-webkit-transition: .3s ease;
-moz-transition: .3s ease;
-o-transition: .3s ease;
-ms-transition: .3s ease;
transition: .3s ease;
}
.submit:hover .ease{
width:100%;
background-color:white;
}
@media only screen and (max-width: 580px) {
#form-div{
left: 3%;
margin-right: 3%;
width: 88%;
margin-left: 0;
padding-left: 3%;
padding-right: 3%;
}
</style>
<!-- Custom styles for this template-->
<link href="css/sb-admin-2.min.css" rel="stylesheet">
<!-- Custom styles for this page -->
<link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">
<?php
$sekarang = date('Y-m-d');
$npm=$_GET['npm'];
$bulan=$_GET['per'];
$kta=$_GET['kta'];
$bbulan=$_GET['bbulan'];
$pg=$_GET['pg'];
$iuran= ($bulan*$bbulan);
$iuran2 = date('Y-m-d', strtotime('+5 year', strtotime($sekarang)));
//$sqlEdit = mysqli_query($konek, "SELECT * FROM b_inv WHERE id_tagihan='$_GET[idnonspp]'");
//$sql=mysqli_query($konek, "SELECT h_regang.*, level.tingkat, level.nominal FROM h_regang JOIN level ON h_regang.tingkat = level.kat_nm WHERE tgliuran < '$sekarang' AND npm='$npm'");
$noreg=$_GET['noreg'];
$sql=mysqli_query($konek, "SELECT * FROM h_regang WHERE noreg='$noreg'");
$e=mysqli_fetch_array($sql);
//$bulan =$e['bulan'];
$npm =$e['npm'];
$mbstr3 =$e['mbstr2'];
$tgliuran =$e['tgliuran'];
// if($periode=='60'){
// $nominal='2120000';
//
// }else if($periode=='36') {
// $nominal='1400000' ;
// ;
// }else if($periode=='24') {
// $nominal ='1040000' ;
//
//
// }
?>
</form>
<!-- proses edit data -->
<div id="form-main">
<div id="form-div" class="px-3 py-5 bg-gradient-info text-white">
<div class="card-body">
<div class="row">
<div class="col-md-6">
<div class="form-group ">
<form method="post" action="" enctype="multipart/form-data">
<p class="name"> <input name="idnonspp" readonly type="hidden" class="form-control" value="<?php echo $e['id_tagihan']; ?>" />
<p class="name"> <input name="npm" type="hidden" readonly class="form-control" value="<?php echo $e['npm']; ?>" />
<p class="name"> <input name="noreg" type="hidden" readonly class="form-control" value="<?php echo $e['noreg']; ?>" />
<?php
// $date1 = date_create('2020-01-01');
// $date2 = date_create('2020-02-07');
//
//$interval = date_diff($date1, $date2);
//
//echo "Selisih: " . $interval->y . " years, " . $interval->m." months, ".$interval->d." days ";
//echo "Selisih: " .$interval->m." Bulan, ";
?>
<?php
//$tgl1 = new DateTime('2020-01-01');
//$tgl2 = new DateTime('2020-05-20');
//$jarak = $tgl2->diff($tgl1);
//
//echo $jarak->m;
?>
<?php
$date = date("Y-m-d");
//$timeStart = strtotime("2021-10-17");
//$timeEnd = strtotime("$date");
//// 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);
//
//echo $numBulan;
//echo $numBulan*30;
?>
<label for="tbayar">Tanggal Konfirmasi</label><br>
<input name="tbayar" readonly class="form-control" value="<?php echo $sekarang ?>" />
<input name="kta" readonly type="hidden" class="form-control" value="<?php echo $kta ?>" />
<input name="byr" readonly type="hidden" class="form-control" value="<?php echo $bbulan ?>" />
<input name="pg" readonly type="hidden" class="form-control" value="<?php echo $pg ?>" />
<input name="iuran" readonly type="hidden" class="form-control" value="<?php echo $iuran ?>" />
<input name="tgldaf" readonly type="hidden" class="form-control" value="<?php echo $e['tgl_daf']; ?>" />
<input name="mbstr3" readonly type="hidden" class="form-control" value="<?php echo $mbstr3 ?>" />
</p>
<label for="tbayar">Nama : </label><br> <input name="nmlead" readonly class="form-control" value="<?php echo $e['nmlead']; ?>" />
</p>
<label for="tbayar">AwalNomor STR </label><br>
<?php
if ($mbstr3=='2') {
?>
<td><?php echo '-'?></td>
<?php
}else{
?>
<input name="awalmbstr" readonly class="form-control" value="<?php echo $e['awalmbstr']; ?>" />
<?php
}
?>
</p>
<label for="tbayar">Akhir Nomor STR </label><br>
<?php
if ($mbstr3=='2') {
?>
<td><?php echo '-'?></td>
<?php
}else{
?>
<input name="mbstr" readonly class="form-control" value="<?php echo $e['mbstr']; ?>" />
<?php
}
?>
</p>
<label for="tbayar">Periode Sisa Bulan Masa NOSTR per Pengajuan berkas </label><br>
<td><input readonly class="form-control" type="text" name="periode" value="<?php echo $bulan ?>"/></td>
</p>
<label for="tbayar">Tanggal Akhir Iuran </label><br>
<td><input readonly class="form-control" type="text" name="tgliuran" value="<?php echo $tgliuran ?>"/></td>
</p>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
</p>
<label for="jumlah">Total Admistrasi IDR</label><br>
<input name="nominal" readonly class="form-control" value="<?php echo $_GET['bayar']; ?>" />
</p>
<label for="jumlah">Administrasi</label><br>
<input name="perihal" readonly class="form-control" value="anggota_baru" />
</p>
<label for="bayar" class="merah" ><b>Jumlah Bayar IDR</b></label><br>
<td><input class="form-control" type="text" name="bayar" value="<?php echo $_GET['bayar']; ?>"/></td>
</p>
<label for="bukti" class="merah">Keterangan : </label>
<?php
$mbstr2=$e['mbstr'];
$mbstr = date('d-m-Y', strtotime($mbstr2));
$kta = number_format($kta,0,",",".");
$pg = number_format($pg,0,",",".");
$iuran = number_format($iuran,0,",",".");
?>
<?php
if ($mbstr3=='2') {
?>
<textarea name="note" rows="3" class="form-control">Iuran 5 tahun Rp <?php echo $iuran ?> sd <?php echo $iuran2 ?>, KTA Rp <?php echo $kta ?> dan Pemeliharaan Gedung Rp <?php echo $pg ?> </textarea>
<?php
}else{
?>
<textarea name="note" rows="3" class="form-control">Iuran Rp <?php echo $iuran ?> sd <?php echo $tgliuran ?>, KTA Rp <?php echo $kta ?> dan Pemeliharaan Gedung Rp <?php echo $pg ?> </textarea>
<?php
}
?>
<p>
<br>
</p>
<p> </p>
<div class="submit">
<input type="submit" id="button-blue" value="Submit" />
<div class="ease"></div>
</div>
</form>
</div>
</div>
<script type="text/javascript">
<?php echo $jsArray; ?>
function changeValue(id){
document.getElementById('prd_name').value = prdName[id].name;
document.getElementById('prd_desc').value = prdName[id].desc;
};
</script>
<script>
function sum() {
var txtFirstNumberValue = document.getElementById('prd_desc').value;
var txtSecondNumberValue = document.getElementById('txt2').value;
var result = parseInt(txtFirstNumberValue) + parseInt(txtSecondNumberValue);
if (!isNaN(result)) {
document.getElementById('txt3').value = result;
}
}
</script>
<script type="text/javascript">
$(document).ready(function() {
$("#enable").click(function() {
$("#bayar").attr("disabled", false);
});
$("#disable").click(function() {
$("#bayar").attr("disabled", true);
});
});
</script>
<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
//variabel untuk menampung inputan dari form
$per = $_POST['periode'];
$npm = $_POST['npm'];
$noreg = $_POST['noreg'];
$tbayar = $_POST['tbayar'];
$nominal = $_POST['nominal'];
$bayar = $_POST['bayar'];
$nmlead = $_POST['nmlead'];
$perihal = 'anggota_baru';
$kode = '2';//kategori
$kta = $_POST['kta'];
$tgldaf = $_POST['tgldaf'];
$mbstr = $_POST['mbstr'];
$byr = $_POST['byr'];
$pgd = $_POST['pg'];
$iuran = $_POST['iuran'];
$note = $_POST['note'];
$tgliuran = $_POST['tgliuran'];
$mbstr3 = $_POST['mbstr3'];
$file = isset($_POST['file']) ? $_POST['file'] : null;
if ($mbstr3=='2') {
$mbstr=$tgliuran;
}
$_SESSION['submit'] = true;
if (!$_SESSION['submit']) {
echo "<center> <strong>form sudah disubmit sebelumnya!</strong></center>";
// $urutan--;
////$kodeid2= $huruf.$waktu."IDB".sprintf("%04s", $urutan);
//
header("location:status_reg?npm=$npm&ahli=$ahli&nmlead=$nmlead&noreg=$_SESSION[noreg]");
//
}else {
// mengubah session menjadi false setelah submit sukses
$_SESSION['submit'] = false;
//$bukti = $_POST['file'];
//$per = $_POST['periode'];
//$tglexp = $_POST['tglexp'];
$sql=mysqli_query($konek, "SELECT level.kat_nm, level.nominal,level.keterangan FROM level WHERE kategori='6'");
$d=mysqli_fetch_array($sql);
$bbulan=$d['bulan'];
//cari jika ada sisa
$sisa = $nominal-$bayar;
if($sisa=='0'){
$persisa='0';
$tglnext = $tgliuran;
$perbayar=$per;
}else{
//sisa bulan dari bayar min kta
//$bayariur=($bayar-$kta)/$byr;
$persisa=$sisa/$byr;
$perbayar=$per-$persisa;
//cari tgl expired mbstr kurang sisa bulan
$tglnext = date('Y-m-d', strtotime('-'.$persisa.'month', strtotime($tgliuran))); //kurang sisa bulan
}
//
//
// if($per =='36'){
// $tglnext = date('Y-m-d', strtotime('+36 month', strtotime($tbayar )));
// $perbyr ='36';
// $persisa ='24';
// }else if($per =='24') {
// $tglnext = date('Y-m-d', strtotime('+24 month', strtotime($tbayar )));
// $perbyr ='24';
// $persisa ='0';
// }else if($per =='60') {
// $tglnext = date('Y-m-d', strtotime('+60 month', strtotime($tbayar )));
// $perbyr ='60';
// $persisa ='0';
// }
//
//// //if($sisa =='0'){
//// // $status = "lunas";
//// // }else {
//// // $status = "sisa";
////
//// // $date = new DateTime($tgl3);
//// // $tglnext = $date->format('d-m-Y');
//
//buat perincian pembayaran anggota baru per bulan
// 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'
);
$query = mysqli_query($konek, "SELECT max(substr(noinv, -6, 6)) as kodeTerbesar FROM b_inv3");
$data = mysqli_fetch_array($query);
$kodeBarang = $data['kodeTerbesar'];
$urutan = (int) substr($kodeBarang, -6, 6);
$urutan++;
$huruf = "INV";
$waktu=date('dmy');
$nextNoBayar= $huruf.$waktu.sprintf("%06s", $urutan);
// $update = mysqli_query($konek, "UPDATE h_regang SET bayar='bayar',tgliuran='$tglnext',periode='$persisa' WHERE npm='$npm'");
$update = mysqli_query($konek, "UPDATE h_regang SET bayar='bayar',periode='$persisa' WHERE npm='$npm'");
mysqli_query($konek, "INSERT INTO b_inv3 (npm,noreg,tgl_bayar,status,bayar,nominal,nmlead,noinv,kode,perihal,periode,persisa,tgliuran,mbstr,iuran,kta,perbyr,pgd,keterangan,biuran,stat_ang,pembinaan)
values('$npm','$noreg','$tbayar','bayar','$bayar','$nominal','$nmlead','$nextNoBayar','$kode','$perihal','$per','$persisa','$tgliuran','$mbstr','$byr','$kta','$perbayar','$pgd','$note','0','AB','$iuran')");
echo "<script> document.location.href='bukti_regbaru.php?npm=$npm&noreg=$noreg'; </script>";
}
}
?>