<?php
include '../../config/config.php';
mysql_close();
$link = mysqli_connect($server, $username, $password) or die("Koneksi gagal");
mysqli_select_db($link, $database) or die("Database tidak bisa dibuka");
$clientIP = $_SERVER['REMOTE_ADDR'];
if ($_POST['tambah']) {
$barcode = $_POST['barcode'];
tambahBarang($link, $clientIP, $barcode);
} elseif ($_POST['hapus']) {
$barcode = $_POST['barcode'];
hapusBarang($link, $clientIP, $barcode);
} elseif ($_GET['refresh']) {
refreshDetail($link, $clientIP);
} elseif ($_GET['gettotal']) {
getTotal($link, $clientIP);
} elseif ($_POST['selesai']) {
selesai($link, $clientIP);
} elseif ($_POST['cekharga']) {
cekHarga($link, $_POST['barcode']);
}
/**
* Tambah barang self checkout, qty selalu 1, karena tidak ada input qty di user interface :)
* @param mysqli $link myqli link
* @param string $clientIP ip address v4 dari client ybs
* @param string $barcode barcode barang
*/
function tambahBarang($link, $clientIP, $barcode)
{
if ($barcode != '') {
</script>
<?php
//fixme : perlu validasi input
// # tidak boleh kosong jumlah barang
// # tidak boleh kosong harga beli
// # tidak boleh kosong harga jual
// bisa pakai fasilitas dari jQuery : http://www.position-absolute.com/articles/jquery-form-validator-because-form-validation-is-a-mess/
if ($_GET[action] == 'tambah') {
// =============================================================================================================
//fixme: item dg barcode "0" pasti selalu ikut terinput - cek dari log query MySQL
$true = cekBarangTemp($_SESSION[idSupplier], $_POST[barcode]);
if ($_POST[barcode] != 0) {
if ($true != 0) {
tambahBarangAda($_SESSION[idSupplier], $_POST[barcode], $_POST[jumBarang]);
} else {
tambahBarang($_SESSION[idSupplier], $_POST[barcode], $_POST[jumBarang], $_POST[hargaBeliBaru], $_POST[hargaJualBaru], $_POST[tglExpire]);
}
// harga banded
if (isset($_POST['qtyBanded']) && isset($_POST['hargaBandedSatuan'])) {
$qty = $_POST['qtyBanded'];
$barcode = $_POST['barcode'];
$harga = $_POST['hargaBandedSatuan'];
if ($qty > 0) {
$sql = "INSERT INTO tmp_harga_banded (barcode, user_name, supplier_id, qty, harga_satuan) " . "VALUES('{$barcode}','{$_SESSION['uname']}','{$_SESSION['idSupplier']}', {$qty},{$harga}) " . "ON DUPLICATE KEY UPDATE qty={$qty}, harga_satuan={$harga} ";
} else {
$sql = "DELETE FROM tmp_harga_banded WHERE barcode = '{$barcode}' AND user_name='{$_SESSION['uname']}'";
}
mysql_query($sql) or die(mysql_error());
}
}
}
