$sql = "update tmp_detail_jual set hargaJual={$hj} where uid={$uid}"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows() > 0) { if (!cekDiskonAdmin($uid)) { } $response = array('sukses' => true); echo json_encode($response); //echo '{sukses: true}'; } elseif (mysql_affected_rows() < 0) { echo json_encode(array('sukses' => false)); } } } elseif ($module === 'diskon' && $act === "getbarcodeinfo") { if (isset($_GET['barcode'])) { $barcode = $_GET['barcode']; $hasil = cekBarang($barcode); echo $hasil['namaBarang'] . ' :: Rp. ' . number_format($hasil['hargaJual'], 0, ',', '.'); } } elseif ($module === 'hargabanded' && $act === 'getnamabarang') { if (isset($_GET['term'])) { $namaBarang = $_GET['term']; echo $term; $sql = "SELECT barcode, namaBarang FROM barang where namaBarang like '%{$namaBarang}%' ORDER BY IFNULL(NULLIF(nonAktif,'0'),0), namaBarang ASC"; $hasil = mysql_query($sql); $barangs = array(); while ($barang = mysql_fetch_array($hasil, MYSQL_ASSOC)) { $barangs[] = array('id' => $barang['barcode'], 'label' => $barang['namaBarang'], 'value' => $barang['namaBarang']); } echo json_encode($barangs); } } elseif ($module == 'inputreturbeli2' and $act == 'simpan') {
</tr> <tr> <td></td> <td></td> <td> <?php //HS tombol "Tambah Barang" akan memunculkan form dialog jQuery echo "\t<form method=POST action='?module=pembelian_barang&act=carisupplier&action=cek&idSupplier=" . $_SESSION['idSupplier'] . "'>\n\t\t<input type=\"button\" id=\"tambahbarang\" accesskey='b' value='(b) Tambah Barang Baru' />\n\t\t<input type='hidden' name='xppn' value='{$_POST['xppn']}'>\n\t\t</form> <br />"; ?> </td> </tr> </table> <?php if ($_GET[action] == 'cek') { // =============================================================================================================== $barang = cekBarang($_POST[barcode]); //tambahan untuk harga banded $query = "SELECT qty, harga FROM harga_banded WHERE barcode = '{$_POST['barcode']}'"; $hasil = mysql_query($query); $hargaBanded = mysql_fetch_array($hasil, MYSQL_ASSOC); if (!$barang) { echo "Data belum ada !"; break; } } ?> <script> function RecalcHargaBarangLama() { var HargaBeli = 0; var HargaJual = 0; var Subtotal = parseInt(document.getElementById("xsubtotal").value);
}); }); $(function () { $('#tanggal_sampai').appendDtpicker({ "closeOnSelected": true, 'locale': 'id', 'dateFormat': 'DD-MM-YYYY', "dateOnly": true }); }); </script> <?php break; case 'kartustok2': if (isset($_POST['barcode'])) { $barang = cekBarang($_POST['barcode']); $tanggal = $_POST['tanggal']; // print_r($barang); $kartuStok = kartuStok($barang['barcode'], $tanggal); $saldoAwal = $kartuStok['saldo']; $mutasi = $kartuStok['mutasi']; ?> <h2>Kartu Stok <small><?php echo $tanggal['dari'] . ' s.d ' . $tanggal['sampai']; ?> </small></h2> <h3><?php echo $barang['namaBarang']; ?> <small><?php echo $barang['barcode'];
function tambahBarangRetur($barcode, $jumBarang) { //cekBarangTempJual($idBarang); $dataAda = cekBarang($barcode); if ($dataAda != 0) { $jumlah = 0; if ($jumBarang == 0) { $jumlah = 1; } else { $jumlah = $jumBarang; } $tgl = date("Y-m-d H:i:s"); $jualBarang = mysql_query("SELECT * FROM barang WHERE barcode = '{$barcode}'") or die(mysql_error()); $jual = mysql_fetch_array($jualBarang); // cari hargaBeli & idBarang nya $sql = "SELECT * FROM detail_beli WHERE isSold = 'N' AND barcode = '{$barcode}' ORDER BY idTransaksiBeli ASC LIMIT 1"; //echo $sql; $hasil = mysql_query($sql); $detilBarang = mysql_fetch_array($hasil); if (mysql_num_rows($hasil) > 0) { $hargaBeli = $detilBarang[hargaBeli]; $idBarang = $detilBarang[idBarang]; } else { // not supposed to ever happen, but just to be safe.... //fixme: kalau seluruh stok barang sudah habis (sehingga jadi masuk ke blok ini) // -- coba lagi dengan record terakhir utk barang ybs di detail_beli, walaupun isSold=Y $hargaBeli = 0; $idBarang = 0; } // simpan transaksi di tmp_detail_jual $sql = "INSERT into tmp_detail_retur_barang (tglTransaksi,\n barcode,jumBarang,hargaBeli,hargaJual,username, idBarang)\n VALUES('{$tgl}','{$barcode}',\n '{$jumlah}','{$hargaBeli}','{$jual['hargaJual']}','{$_SESSION['uname']}', {$idBarang})"; //echo $sql; mysql_query($sql) or die(mysql_error()); } else { echo "Barang tidak ada"; } }