| Server IP : 2.57.91.57 / 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 'koneksi.php';
// include 'header.php';
include '../koneksi.php';
$id = $_GET['id'];
$npm = trim($_GET['npm']);
$noreg = trim($_GET['noreg']);
$noreko = $_GET['noreko'];
$status = 'valid';
//$supervisor= $_GET['supervisor'];
mysqli_query($konek, "update h_regang SET verifikasi1='$status',status2='finish',status='finish' WHERE id_tagihan='$id' ");
// mysqli_query($konek, "update h_regang SET verifikasi1='$status',status='finish' WHERE id_tagihan='$id' ");
//Insert jadi Anggota
// $query = mysqli_query($konek, "SELECT * FROM h_regang WHERE id_tagihan='$id' ");
// $data = mysqli_fetch_array($query);
// $tgliuran = $data['tgliuran'];
// $periode = $data['periode'];
//nomor KTA sudah cetak suratketerangan
mysqli_query($konek,"INSERT INTO h_anggota (npm,tgl_daf,nmlead,status,alamat,ahli,telp,gambar,barcode,tempatlahir,tanggallahir,warganegara,agama,gender,ktp,email,tgliuran,periode,gdepan,gbelakang,npa,nostr,mbstr,ab,registrasi,nosurat_ab,mbstr2)
SELECT npm,tgl_daf,nmlead,'aktif',alamat,ahli,telp,gambar,barcode,tempatlahir,tgllahir,warganegara,agama,gender,ktp,email,tgliuran,periode,gdepan,gbelakang,npa,nostr,mbstr,'1','2',noreko,mbstr2 FROM h_regang WHERE noreg ='$noreg'");
$update = mysqli_query($konek, "UPDATE mahasiswa SET level='user', active='2',anggota='1' WHERE npm= '$npm'");
// $update2 = mysqli_query($konek, "UPDATE h_anggota pt, h_regang p SET pt.nostr = p.nostr,pt.noreg= p.noreg WHERE pt.npm = p.npm ");
// $update2 = mysqli_query($konek, "UPDATE h_anggota pt, h_regang p SET pt.barcode = p.npm'.png' WHERE pt.npm = p.npm ");
$sql=mysqli_query($konek, "SELECT * From h_regang WHERE noreg='$noreg' ");
//
$e=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$tgl_daf =$e['tgl_daf'];
$update3 = mysqli_query($konek, "UPDATE b_inv3 SET finish='1',tgl_awal='$tgl_daf',biuran=pembinaan WHERE noreg= '$noreg'");
//input otomatis data iuran
mysqli_query($konek,"INSERT INTO d_iuran (npm,noreg,tglbayar_iur,nmlead,stat_ang,jenis,tgl_awal,tgl_akhir,nom_iur,periode,validasi,revisi,perihal,foto)
SELECT
npm,noreg,tgl_bayar,nmlead,'AB','iuran',tgl_awal,tgliuran,pembinaan,periode,'valid','1',perihal,gambar FROM b_inv3 WHERE noreg ='$noreg'");
// 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
$sql=mysqli_query($konek, "SELECT * From b_inv3 WHERE noreg='$noreg' ");
//
$b=mysqli_fetch_array($sql);
//$npm= isset($e['npm']) ? $e['npm'] : null;
$awaltgliuran =$b['tgl_awal'];
$iuran = $b['iuran'];
$periode = $b['periode'];
$npa =$e['npa'];
$nmlead =$b['nmlead'];
//cari tahun
//$tahun=date("Y",strtotime($awaltgliuran));
$awaltempo= $b['tgl_awal'];
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_bulan(noreg,npm,nama,jatuhtempo,bulan,jumlah,tahun,status)
values('$noreg','$npm','$nmlead','$jatuhtempo','$bulan','$iuran','$tahun','valid')");
}
header("location:stat_ang.php?noreg=$noreg&npm=$npm ");
?>