| Server IP : 88.222.222.23 / Your IP : 216.73.216.174 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/event/modules/data-nonreg/ |
Upload File : |
<?php
session_start();
// Panggil koneksi database.php untuk koneksi database
require_once "../../config/database.php";
// fungsi untuk pengecekan status login user
// jika user belum login, alihkan ke halaman login dan tampilkan pesan = 1
if (empty($_SESSION['username']) && empty($_SESSION['password'])){
echo "<meta http-equiv='refresh' content='0; url=index.php?alert=1'>";
}
// jika user sudah login, maka jalankan perintah untuk insert, update, dan delete
else {
if ($_GET['act']=='insert') {
// if (isset($_POST['simpan'])) {
// ambil data hasil submit dari form
// fungsi untuk membuat kode transaksi
$query_id = mysqli_query($mysqli, "SELECT RIGHT(kode_transaksi,7) as kode FROM d_absen
ORDER BY kode_transaksi DESC LIMIT 1")
or die('Ada kesalahan pada query tampil kode_transaksi : '.mysqli_error($mysqli));
$count = mysqli_num_rows($query_id);
if ($count <> 0) {
// mengambil data kode transaksi
$data_id = mysqli_fetch_assoc($query_id);
$kode = $data_id['kode']+1;
} else {
$kode = 1;
}
// buat kode_transaksi
$tahun = date("Y");
$buat_id = str_pad($kode, 7, "0", STR_PAD_LEFT);
$kode_transaksi = "DR-$tahun-$buat_id";
$tgl=date("Y-m-d");
// $kode_transaksi = mysqli_real_escape_string($mysqli, trim($_GET['kode_transaksi']));
// $tanggal = mysqli_real_escape_string($mysqli, trim($_POST['tanggal_keluar']));
// $exp = explode('-',$tanggal);
// $tanggal_keluar = $exp[2]."-".$exp[1]."-".$exp[0];
$kode_helm = mysqli_real_escape_string($mysqli, trim($_GET['npm']));
$npm = mysqli_real_escape_string($mysqli, trim($_GET['npm']));
// $total_stok = mysqli_real_escape_string($mysqli, trim($_POST['total_stok']));
$created_user = $_SESSION['id_user'];
$query = mysqli_query($mysqli, "SELECT * FROM h_anggota where npm='$kode_helm'")
or die('Ada kesalahan pada query tampil Data Masuk: '.mysqli_error($mysqli));
$data = mysqli_fetch_assoc($query);
$nmlead = mysqli_real_escape_string($mysqli, trim( $data['nmlead']));
// $harga_beli = str_replace('.', '', mysqli_real_escape_string($mysqli, trim( $data['harga_beli'])));
// $harga_jual = str_replace('.', '', mysqli_real_escape_string($mysqli, trim( $data['harga_jual'])));
$alamat = mysqli_real_escape_string($mysqli, trim( $data['alamat']));
$ahli = mysqli_real_escape_string($mysqli, trim( $data['ahli']));
$telp = mysqli_real_escape_string($mysqli, trim( $data['telp']));
$status = mysqli_real_escape_string($mysqli, trim( $data['status']));
$tgl = mysqli_real_escape_string($mysqli, trim($tgl));
$email = mysqli_real_escape_string($mysqli, trim( $data['email']));
$gambar = mysqli_real_escape_string($mysqli, trim( $data['gambar']));
$npa = mysqli_real_escape_string($mysqli, trim( $data['npa']));
$barcode = mysqli_real_escape_string($mysqli, trim( $data['barcode']));
$query = mysqli_query($mysqli, "SELECT * FROM h_acara where status= 'aktif'")
or die('Ada kesalahan pada query tampil Data Masuk: '.mysqli_error($mysqli));
$data2 = mysqli_fetch_assoc($query);
$acara = mysqli_real_escape_string($mysqli, trim( $data2['acara']));
$kdacara = mysqli_real_escape_string($mysqli, trim( $data2['kode_acara']));
// perintah query untuk menghapus data pada tabel obat
$query = mysqli_query($mysqli, "DELETE FROM d_dummyabs")
or die('Ada kesalahan pada query delete : '.mysqli_error($mysqli));
$query_id = mysqli_query($mysqli, "SELECT npm from d_absen where npm= '$kode_helm'")
or die('Ada kesalahan pada query tampil kode_transaksi : '.mysqli_error($mysqli));
$count = mysqli_num_rows($query_id);
if ($count <> 0) {
header("location: ../../main.php?module=data_jual&npm=$npm&alert=3");
} else {
// perintah query untuk menyimpan data ke tabel helm masuk
$query = mysqli_query($mysqli, "INSERT INTO d_absen(tanggal_transaksi,kode_transaksi,npm,nmlead,alamat,telp,acara,ahli,status,email,gambar,npa,barcode,kode_acara)
VALUES('$tgl','$kode_transaksi','$kode_helm','$nmlead','$alamat','$telp','$acara','$ahli','$status','$email','$gambar','$npa','$barcode','$kdacara')")
or die('Ada kesalahan pada query insert1 : '.mysqli_error($mysqli));
$query = mysqli_query($mysqli, "INSERT INTO d_dummyabs(tanggal_transaksi,kode_transaksi,npm,nmlead,alamat,telp,acara,ahli,status,email,gambar,npa,barcode,kode_acara)
VALUES('$tgl','$kode_transaksi','$kode_helm','$nmlead','$alamat','$telp','$acara','$ahli','$status','$email','$gambar','$npa','$barcode','$kdacara')")
or die('Ada kesalahan pada query insert1 : '.mysqli_error($mysqli));
// cek query
if ($query) {
// jika berhasil tampilkan pesan berhasil simpan data
header("location: ../../main.php?module=data_jual&npm=$npm&alert=1");
}
}
// // cek query
// if ($query) {
// // jika berhasil tampilkan pesan berhasil simpan data
// header("location: ../../main.php?module=data_jual&alert=1");
// }
}
elseif ($_GET['act']=='delete') {
if (isset($_GET['id'])) {
$id= $_GET['id'];
// perintah query untuk menghapus data pada tabel obat
$query = mysqli_query($mysqli, "DELETE FROM is_dumy WHERE id='$id'")
or die('Ada kesalahan pada query delete : '.mysqli_error($mysqli));
// cek hasil query
// jika berhasil tampilkan pesan berhasil delete data
header("location: ../../main.php?module=data_jual&npm=$npm&alert=3");
}
}
}
?>