| Server IP : 88.222.222.224 / Your IP : 216.73.216.217 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 : |
session_start();
<?php include "koneksi.php";
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['status']<>"login"){
header("location:location:../login.php");
}
?>
<!-- proses edit data -->
<?php
include "koneksi.php";
//variabel untuk menampung inputan dari form
//$id = $_POST['id'];
$npm = $_POST['npm'];
$noreg = $_POST['noreg'];
$nmlead = $_POST['nmlead'];
$tahap = $_POST['tahap'];
$note = $_POST['note'];
$keterangan = $_POST['ket'];
$status2 = $_POST['status2'];
$tglcek = $_POST['tglcek'];
//$perihal = $_POST['perihal'];
//$alamat = $_POST['alamat'];
// $nostr = $_POST['nostr'];
$mbstr = $_POST['mbstr'];
$stat_ang = $_POST['stat_ang'];
$tglreg = $_POST['tglreg'];
$sql = mysqli_query($konek, "select * from h_registrasi WHERE noreg='$noreg'");
$dm=mysqli_fetch_array($sql);
$kotamt=$dm['kotamt'];
$perihal=$dm['perihal'];
$stat_ang=$dm['stat_ang'];
// Jika status tidak finish hanya tambah progres
if($status2<>'finish'){
mysqli_query($konek, "INSERT INTO d_progres(npm,noreg,tahap,status2,keterangan,status,tgl_cek,note)
values('$npm','$noreg','$tahap','$status2','$keterangan','proses','$tglcek','$note')
");
$update = mysqli_query($konek, "UPDATE h_registrasi SET tahap='$tahap',status2='$status2',status='$status2',tgl_cek='$tglcek' WHERE noreg='$noreg'");
if($stat_ang=='non'){
$update = mysqli_query($konek, "UPDATE h_nonanggota SET pengajuan='1',tgliuran='$mbstr',tgl_reg='$tglreg' WHERE npm='$npm'");
}
}else{
mysqli_query($konek, "INSERT INTO d_progres(npm,noreg,tahap,status2,keterangan,status,tgl_cek,note)
values('$npm','$noreg','$tahap','$status2','$keterangan','proses','$tglcek','$note')
");
$update = mysqli_query($konek, "UPDATE h_registrasi SET tahap='$tahap',status2='$status2',status='$status2',tgl_cek='$tglcek' WHERE noreg='$noreg'");
if($stat_ang=='non'){
$update = mysqli_query($konek, "UPDATE h_nonanggota SET pengajuan='1',tgliuran='$mbstr',tgl_reg='$tglreg' WHERE npm='$npm'");
}
$update3 = mysqli_query($konek, "UPDATE b_inv3 SET finish='1',tgl_awal='$tglreg' WHERE noreg= '$noreg'");
if($perihal=='mutasi'){
// $sql = mysqli_query($konek, "select * from h_registrasi WHERE noreg='$noreg'");
// $dm=mysqli_fetch_array($sql);
// $kotamt=$dm['kotamt'];
$update = mysqli_query($konek, "UPDATE h_anggota SET status='nonaktif', keterangan='$kotamt',jenis='$perihal',kotamt='$kotamt' WHERE npm='$npm'");
}
if($stat_ang=='non'){
//Input otomatis ke d_iuran untuk buat data biaya pembinaan
//input otomatis data iuran
mysqli_query($konek,"INSERT INTO d_pembinaan (npm,noreg,tglbayar_iur,nmlead,stat_ang,jenis,tgl_awal,tgl_akhir,nom_iur,periode,validasi,pembinaan)
SELECT
npm,noreg,tgl_bayar,nmlead,'non','pembinaan',tgl_awal,tgliuran,biuran,periode,'valid',biuran 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;
$periode = $b['periode'];
$awaltempo= $b['tgl_awal'];
$npa =$e['npa'];
$nmlead =$b['nmlead'];
//$total5=$numBulan*$nomiur;
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));
//cari tahun
//$tahun=date("Y",strtotime($awaltgliuran));
$sql=mysqli_query($konek, "SELECT kat_nm,nominal FROM level WHERE kat_nm='bulanan'");
$u = mysqli_fetch_array($sql);
$nomiur=$u['nominal'];
mysqli_query($konek, "INSERT INTO d_bulannon(noreg,npm,nama,jatuhtempo,bulan,jumlah,tahun,status)
values('$noreg','$npm','$nmlead','$jatuhtempo','$bulan','$nomiur','$tahun','valid')");
}
}
mysqli_query($konek, "DELETE FROM d_prakang WHERE npm='$npm' ");
$sql = mysqli_query($konek, "select * from d_praktek WHERE npm='$npm' and noreg='$noreg'");
while($dp=mysqli_fetch_array($sql)){
mysqli_query($konek, "INSERT INTO d_prakang(npm,nmlead,praktek,status,wilker,hari,jam1,telp,alamat,ahli,sip)
values('$npm','$nmlead','$dp[praktek]','valid','$dp[wilker]','$dp[hari]','$dp[jam1]','$dp[telp]','$dp[alamat]','$dp[ahli]','$dp[sip]')");
//header("location:sendwa_finish.php?noreg=$noreg&npm=$npm&status2=$status2");
//kirim ke wa
//$npm = $_GET['npm'];
//$noreg = $_GET['noreg'];
// $tgl = date('Y-m-d');
//
$query = mysqli_query($konek, "SELECT * FROM h_registrasi where noreg='$noreg'");
$data = mysqli_fetch_array($query);
$npa = $data['npa'];
$noreko = $data['noreko'];
$nmlead = $data['nmlead'];
$status = $data['status2'];
$npm = $data['npm'];
$perihal = $data['perihal'];
$telp = $data['telp'];
// // test ke no pribadi
// $telp = '6287821522214';
//$npm = 'IDI0123456';
//$noreko = '0123456';
//$status = 'finish';
//$perihal = 'rekomedasi_Dokter Spesialis';
define('ROOT', 'http://idikotabandung.com/IDI/');
$web2 = ROOT."login.php?npm=$npm" ;
// define('ROOT', 'http://idikotabandung.com/');
//
// //$web = ROOT."login.php?npm=$npm" ;
//
//$web = ROOT."logo.png" ;
//$web='https://is3.cloudhost.id/alatwa.com/assets/img/background-alatwa-com-free-trial-7-days.png';
$web='https://idikotabandung.com/registrasi/image/aps.jpg';
$header = array(
"Content-Type: application/json",
// "Authorization: 1e6b5ee17374261fab972cc85aa1d958"
"Authorization: 92dfc535e4d2f2466543947fb63f3e1a"
);
$data = array(
"device" => "888397525616",
"phone" => "$telp",
"message" => "
Terimakasih sudah mengajukan Surat rekomendasi ONLINE
Nama : $nmlead
No Rekom: *$noreko*
Status : *$status*
Tujuan : *$perihal*
Untuk Informasi pengajuan Rekom SIP Kontak Ibu Nisa Wa Only: +62 813 1334 6867
Step untuk mendownlaod Surat Rekom anda:
a. Login kembali ke Dashboard anda di WEB IDI Kota Bandung
b. Atau dengan Click langsung Link dibawah :
$web2
",
"url" => "$web"
);
$param_post = json_encode($data, JSON_PRETTY_PRINT);
$post = curl_init("https://app.alatwa.com/api/send/message/media");
//$post = curl_init("https://app.alatwa.com/api/send/message/text");
curl_setopt($post, CURLOPT_HTTPHEADER, $header);
curl_setopt($post, CURLOPT_POST, 1);
curl_setopt($post, CURLOPT_POSTFIELDS, $param_post);
curl_setopt($post, CURLOPT_RETURNTRANSFER, true);
curl_setopt($post, CURLOPT_CONNECTTIMEOUT, 0);
curl_setopt($post, CURLOPT_TIMEOUT, 5);
$response = curl_exec($post);
curl_close($post);
echo $response;
}
}
header("location:upd_sip2.php?noreg=$noreg&npm=$npm&status2=$status2");
//echo "$id";
//header("location:sendwa_finish.php?noreg=$noreg&npm=$npm&status2=$status2");
?>