} } elseif ($module == 'penjualan_barang' and $act == 'nomorkartuinput') { if (isset($_POST['nomor-kartu'])) { $return = array('sukses' => false); $nomorKartu = $_POST['nomor-kartu']; $result = mysql_query("select idCustomer from customer where nomor_kartu='{$nomorKartu}'"); $customer = mysql_fetch_array($result); if ($customer) { findCustomer($customer['idCustomer']); mysql_query("UPDATE tmp_detail_jual SET idCustomer = {$customer['idCustomer']} WHERE username = '******'uname']}'"); $query = mysql_query("SELECT barcode, sum(jumBarang) qty\n FROM tmp_detail_jual\n WHERE username = '******'uname']}' AND idCustomer = {$customer['idCustomer']}\n group by barcode"); // Hapus semuanya // Ulangi proses input while ($barang = mysql_fetch_array($query)) { mysql_query("delete from tmp_detail_jual where idCustomer={$customer['idCustomer']} " . "and barcode = '{$barang['barcode']}' " . "and username='******'uname']}'") or die('Gagal clean ' . mysql_error()); tambahBarangJual($barang['barcode'], $barang['qty']); } $return = array('sukses' => true); } } header('Content-type: application/json'); echo json_encode($return); } elseif ($module == 'penjualan_barang' and $act == 'get_harga_jual') { if (isset($_POST['barcode'])) { $result = mysql_query("select hargaJual from barang where barcode = '{$_POST['barcode']}'") or die('Gagal ambil harga jual, barang#' . $_POST['barcode'] . ', error: ' . mysql_error()); $barang = mysql_fetch_array($result); $return = array('sukses' => true, 'hargaJual' => $barang['hargaJual']); echo json_encode($return); } } elseif ($module == 'buka_kasir' and $act == 'input') { // cari apakah kasir ini sedang aktif - jika ya, maka tolak
* */ $tambahBarang = 1; if (isset($_POST['jumBarang']) || isset($_GET['jumBarang'])) { $tambahBarang = isset($_POST['jumBarang']) ? $_POST['jumBarang'] : $_GET['jumBarang']; } $trueJual = cekBarangTempJual($_SESSION[idCustomer], $_POST[barcode]); // Jika barang sudah ada (hanya tambah kuantiti) maka tambahkan kuantitinya; if ($trueJual) { $jumBarang = $trueJual['jumBarang']; mysql_query("delete from tmp_detail_jual where idCustomer='{$_SESSION['idCustomer']}' " . "and barcode = '{$_POST['barcode']}' " . "and username='******'uname']}'") or die('Gagal clean ' . mysql_error()); $jumBarang += $tambahBarang; } else { $jumBarang = $tambahBarang; } tambahBarangJual($_POST['barcode'], $jumBarang, $hargaBarang); } $sql = "SELECT *\n FROM tmp_detail_jual tdj, barang b\n WHERE tdj.barcode = b.barcode AND tdj.idCustomer = '{$_SESSION['idCustomer']}' AND tdj.username = '******'uname']}'"; //echo $sql; $query = mysql_query($sql); $r = mysql_fetch_row($query); ?> <span style="color:red"> <?php echo $hapusGagal ? "Gagal hapus item, aktifkan Admin Mode terlebih dahulu!" : ''; echo $batalGagal ? "Gagal batal nota, aktifkan Admin Mode terlebih dahulu!" : ''; ?> </span> <hr /> <?php if ($r) {
var dropBox = document.getElementById("barcode"); if (dropBox != null) dropBox.focus(); </script> <?php if ($_GET[action] == 'tambah') { if ($_GET[barcode]) { $_POST[barcode] = $_GET[barcode]; } $trueJual = cekBarangTempJual($_SESSION[idCustomer], $_POST[barcode]); // echo "$trueJual"; if ($trueJual != 0) { tambahBarangJualAda($_SESSION[idCustomer], $_POST[barcode], $_POST[jumBarang]); } else { tambahBarangJual($_POST[barcode], $_POST[jumBarang]); } } $sql = "SELECT *\n FROM tmp_detail_jual tdj, barang b\n WHERE tdj.barcode = b.barcode AND tdj.idCustomer = '{$_SESSION['idCustomer']}' AND tdj.username = '******'uname']}'"; //echo $sql; $query = mysql_query($sql); $r = mysql_fetch_row($query); ?> <hr /> <?php if ($r) { //echo "Ada $r[0] data"; ?> <table class="tabel daftar-pembelian"> <tr> <th>Barcode</th>
header('location:media.php?module=' . $module); } elseif ($module == 'penjualan_barang' and $act == 'selfcheckoutinput') { if (isset($_POST['sc-id'])) { $scId = $_POST['sc-id']; $result = mysql_query("select * from self_checkout_detail where self_checkout_uid={$scId}"); while ($barang = mysql_fetch_array($result)) { $trueJual = cekBarangTempJual($_SESSION[idCustomer], $barang['barcode']); // Jika barang sudah ada (hanya tambah kuantiti) maka tambahkan kuantitinya; if ($trueJual) { $jumBarang = $trueJual['jumBarang']; mysql_query("delete from tmp_detail_jual where idCustomer='{$_SESSION['idCustomer']}' " . "and barcode = '{$barang['barcode']}' " . "and username='******'uname']}'") or die('Gagal clean ' . mysql_error()); $jumBarang += $barang['qty']; } else { $jumBarang = $barang['qty']; } tambahBarangJual($barang['barcode'], $jumBarang); } } } elseif ($module == 'penjualan_barang' and $act == 'get_harga_jual') { if (isset($_POST['barcode'])) { $result = mysql_query("select hargaJual from barang where barcode = '{$_POST['barcode']}'") or die('Gagal ambil harga jual, barang#' . $_POST['barcode'] . ', error: ' . mysql_error()); $barang = mysql_fetch_array($result); $return = array('sukses' => true, 'hargaJual' => $barang['hargaJual']); echo json_encode($return); } } elseif ($module == 'buka_kasir' and $act == 'input') { // cari apakah kasir ini sedang aktif - jika ya, maka tolak $sql = "SELECT * FROM kasir WHERE idUser={$_POST['idKasir']} AND tglTutupKasir IS NULL"; $hasil = mysql_query($sql); if (mysql_num_rows($hasil) > 0) { echo "Kasir ini sedang Aktif ! Silakan ditutup dulu.\n\t\t\t<p> </p>\n\t\t\t <a href=javascript:history.go(-1)><< Kembali</a>";