function deleteData($table_name, $id_val, $id_name = 'id')
{
//validasi input
if (empty($id_val)) {
return "Ada data yang kosong!";
}
$id_val = validasi($id_val);
//construct query
$query = "DELETE FROM " . $table_name . " WHERE " . $id_name . "='" . $id_val . "'";
//echo $query;
//proses query
$proses = mysql_query($query);
if (!$proses) {
return "Operasi gagal!";
}
}
<?php
require_once "./script/config.php";
require_once $site_path . "script/library.php";
cekSession();
$id = validasi($_GET[id]);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="shortcut icon" href="./design/favicon.ico">
<title><?php
echo $site_title;
?>
</title>
</head>
<body onload="body_onLoad()">
<div id="wrapper">
<div id="header">
<h1>Toko Kelontong Makmur</h1>
<p>jl. antah berantah no.1</p>
<p>No. Nota: <?php
echo $id;
?>
</p>
<p>Tanggal: <?php
echo date('d-m-Y');
?>
</p>
</div>
<div id="main">
require_once "./script/config.php";
require_once $site_path . "script/library.php";
// <<< CEK SESSION >>>
//klo udah login, redirect ke homepage
if (isLoggedIn()) {
header("location: " . $site_path . "index.php");
}
//inisialisasi data
$pesan = "";
// <<< PROSES METHOD POST >>>
if (!empty($_POST[action])) {
if (empty($_POST[username]) || empty($_POST[password])) {
$pesan = "Data ada yang kosong!";
} else {
$username = validasi($_POST[username]);
$password = md5($_POST[password]);
$query = "SELECT id, id_status, nama_lengkap FROM pengguna WHERE username='******' AND password='******'";
//echo $query;
$proses = mysql_query($query);
if (!$proses) {
$pesan = "Operasi gagal!";
} else {
if (mysql_num_rows($proses) == 0) {
$pesan = "Username atau Password tidak ditemukan!";
} else {
$hasil = mysql_fetch_array($proses);
//inisialisasi session
/*
session_register("id");
session_register("id_status");
$id = 0;
while ($hasil = mysql_fetch_array($proses)) {
echo "<tr><td>";
if ($id != $hasil[id]) {
$id = $hasil[id];
echo $id;
}
$harga = $hasil[harga_beli] * (100 + $hasil[persen_markup]) / 100;
echo "</td><td>{$hasil['kode']}</td><td>{$hasil['nama']}</td><td>{$harga}</td><td>{$hasil['jumlah']}</td><td>" . $harga * $hasil[jumlah] . "</td></tr>";
}
}
echo "</table>";
break;
case 'penjualan_per_periode':
$tgl_trans_awal = validasi($_GET[tgl_trans_awal]);
$tgl_trans_akhir = validasi($_GET[tgl_trans_akhir]);
echo "<h1>DAFTAR PENJUALAN PER-PERIODE</h1>";
echo "<div class=\"box\">Tanggal: " . convertDate($tgl_trans_awal) . " s/d " . convertDate($tgl_trans_akhir) . "</div>";
echo "<div class=\"box\">Tanggal Cetak: " . $tanggal . "</div>";
$query = "\tSELECT DATE(penjualan_umum.waktu) AS tanggal,\n\t\t\t\t\t\t\t\t\tpenjualan_umum.id AS id,\n\t\t\t\t\t\t\t\t\tbarang.kode AS kode,\n\t\t\t\t\t\t\t\t\tbarang.nama AS nama,\n\t\t\t\t\t\t\t\t\tbarang.harga_beli AS harga_beli,\n\t\t\t\t\t\t\t\t\tbarang.persen_markup AS persen_markup,\n\t\t\t\t\t\t\t\t\tpenjualan_detail.jumlah AS jumlah\n\t\t\t\t\t\t\t\tFROM penjualan_umum, penjualan_detail, barang\n\t\t\t\t\t\t\t\tWHERE barang.id = penjualan_detail.id_barang AND penjualan_detail.id_penjualan_umum = penjualan_umum.id AND DATE(penjualan_umum.waktu) >= '{$tgl_trans_awal}' AND DATE(penjualan_umum.waktu) <= '{$tgl_trans_akhir}'";
//echo $query;
$proses = mysql_query($query);
echo "<table>\n\t\t\t\t\t<tr><th>Tanggal</th><th>Id Transaksi</th><th>Kode Barang</th><th>Nama Barang</th><th>Harga Jual(Rp.)</th><th>Jumlah</th><th>Sub Total (Rp.)</th></tr>";
if ($proses) {
$id = 0;
$tgl_lama = 0;
while ($hasil = mysql_fetch_array($proses)) {
echo "<tr><td>";
if ($tgl_lama != $hasil[tanggal]) {
$tgl_lama = $hasil[tanggal];
echo convertDate($tgl_lama);
