<?php
session_start();
require_once "library/koneksi.php";
require_once "library/fungsi_standar.php";
$a = "SELECT * FROM jual";
$b = "SELECT inc FROM jual ORDER BY inc DESC LIMIT 1";
$inc = penambahan($a, $b);
if (isset($_POST['run']) and $_POST['run'] == "form2") {
$cekQty = "SELECT * FROM stok WHERE barang_nama='{$_POST['pilih_barang']}'";
$qcekQty = mysql_query($cekQty);
$dcekQty = mysql_fetch_array($qcekQty);
if (!empty($_POST['qty']) and !empty($_POST['harga'])) {
//ambil dari stok
$buah = "SELECT * FROM stok WHERE barang_nama='{$_POST['pilih_barang']}'";
$qbuah = mysql_query($buah);
$dbuah = mysql_fetch_array($qbuah);
$sisa_qty = $dbuah['qty'] - $_POST['qty'];
if ($sisa_qty >= 0) {
//insert ke temp_beli_detail
$harga_total = $_POST['qty'] * $_POST['harga'];
$input = "INSERT INTO temp_jual_detail(jual_id, barang_id, barang_nama, kategori, qty, satuan, harga_satuan, harga_total)\n\t\t\tVALUES('JL-{$inc}', '{$dbuah['barang_id']}', '{$_POST['pilih_barang']}', '{$dbuah['kategori']}', '{$_POST['qty']}', 'box', \n\t\t\t'{$_POST['harga']}', '{$harga_total}')";
mysql_query($input);
//update tabel stok
$upstok = "UPDATE stok SET qty='{$sisa_qty}' WHERE barang_id='{$dbuah['barang_id']}'";
mysql_query($upstok);
} else {
echo "\n\t\t\t<script type=text/javascript>";
echo "alert('Qty yang diambil melebihi stok')";
echo "</script>";
}
}
function penambahan($a, $b)
{
return $a + $b;
}
function login($username, $password)
{
// 1. sanitazie arguments
// 2. validate argumenets
// 3. prepare statements
// 4. excute sql
// if ok, start session, return true
// else return false
}
function logout()
{
// destroy session
// redirect to main page
}
$user_list = array('nasrul', 'hazim', 'mohamad', 'mahdin', 'othman', 'ahmad');
$name = 'nasrul bin hazim bin mohamad bin mahdin bin othman bin ahmad';
// p(join(' bin ', $user_list));
// p(implode(' bin ', $user_list));
// p(count($user_list));
// var_dump(explode(' bin ', $name));
$result_a = penambahan(1, 1);
$result_b = penambahan(1, 10);
// p($result_a);
// p($result_b);
?>
