$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";
}
}
