$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') {
$sql = "SELECT * FROM tmp_edit_detail_retur_beli";
$queryAwal = mysql_query($sql);
$username = $_SESSION['uname'];
$idSupplier = $_SESSION['idSupplier'];
$last_update = date("Y-m-d");
while ($barangRetur = mysql_fetch_array($queryAwal)) {
$jumBarangDetail = getJumBarangDetailPembelian($barangRetur['idDetailBeli']);
$jumBarangDetailBaru = $jumBarangDetail - $barangRetur['jumRetur'];
$jumBarangDiBarang = getJumBarangDiBarang(null, $barangRetur['barcode']);
$jumBarangBaru = $jumBarangDiBarang - $barangRetur['jumRetur'];
// update nota pembelian
if ($jumBarangDetailBaru >= 0) {
$sql = "UPDATE detail_beli SET jumBarang = {$jumBarangDetailBaru}";
if ($jumBarangDetailBaru == 0) {
$sql .= ", isSold='Y'";
}
$sql .= " WHERE idDetailBeli = {$barangRetur['idDetailBeli']}";
mysql_query($sql) or die(mysql_error());
} else {
// Jika < 0, berarti cari detail_beli
$sisa = $barangRetur['jumRetur'];
$query = mysql_query("SELECT * FROM detail_beli WHERE barcode='{$barangRetur['barcode']}' and isSold='N' ORDER BY idDetailBeli");
while ($dbeli = mysql_fetch_array($query)) {
if ($sisa == 0) {
}
// update transaksibeli
mysql_query("UPDATE transaksibeli SET last_update = '{$last_update}', nominal = {$nominal}\n WHERE idTransaksiBeli = '{$_POST['idNota']}'") or die(mysql_error());
// hapus data temporary
mysql_query("DELETE FROM tmp_edit_detail_retur_beli WHERE idTransaksiBeli = '{$_POST['idNota']}'") or die(mysql_error());
header('location:media.php?module=pembelian_barang');
} elseif ($module == 'editlaporanpembelian' and $act == 'inputtemp') {
// ====================================================================================
mysql_query("INSERT INTO tmp_edit_detail_beli(idDetailBeli,idTransaksiBeli,idBarang,tglExpire,jumBarang,hargaBeli)\n SELECT detail_beli.idDetailBeli,detail_beli.idTransaksiBeli,detail_beli.idBarang,detail_beli.tglExpire,\n detail_beli.jumBarang,detail_beli.hargaBeli\n from detail_beli,barang where barang.idBarang = detail_beli.idBarang AND detail_beli.idTransaksiBeli = '{$_POST['idNota']}' AND detail_beli.idTransaksiBeli != 0") or die(mysql_error());
header('location:media.php?module=pembelian_barang&act=editlaporan&idnota=' . $_POST[idNota]);
} elseif ($module == 'editlaporanpembelian' and $act == 'simpanedit') {
// -----------------------------------------------------------------------------------
// echo "Edit nota $_POST[idNota]";
$query = mysql_query("SELECT idDetailBeli, idBarang,tglExpire,jumBarang,hargaBeli FROM tmp_edit_detail_beli WHERE idTransaksiBeli = '{$_POST['idNota']}'") or die(mysql_error());
while ($tmpEdit = mysql_fetch_array($query)) {
$jumBarang = getJumBarangDiBarang($tmpEdit[idDetailBeli]);
$jumBarangDetail = getJumBarangDetailPembelian($tmpEdit[idDetailBeli]);
$jumBarangEdit = $jumBarangDetail - $tmpEdit[jumBarang];
$jumBarangBaru = $jumBarang + $jumBarangEdit;
mysql_query("UPDATE detail_beli SET tglExpire = '{$tmpEdit['tglExpire']}', jumBarang = '{$tmpEdit['jumBarang']}', hargaBeli = '{$tmpEdit['hargaBeli']}'\n WHERE idDetailBeli = '{$tmpEdit['idDetailBeli']}'") or die(mysql_error());
mysql_query("UPDATE barang SET jumBarang = '{$jumBarangBaru}'\n WHERE idBarang = '{$tmpEdit['idBarang']}'") or die(mysql_error());
}
mysql_query("DELETE FROM tmp_edit_detail_beli WHERE idTransaksiBeli = '{$_POST['idNota']}'") or die(mysql_error());
header('location:media.php?module=pembelian_barang&act=detaillaporan&idnota=' . $_POST[idNota]);
} elseif ($module == 'laporanpenjualan' and $act == 'hapuslaporan') {
// echo "Kasir : $_POST[kasir], No Nota : $_POST[idNota]";
$query = mysql_query("SELECT idBarang, jumBarang FROM detail_jual WHERE idTransaksiJual = '{$_POST['idNota']}'") or die(mysql_error());
while ($penjualan = mysql_fetch_array($query)) {
$queryBarang = mysql_query("SELECT jumBarang FROM barang WHERE idBarang = '{$penjualan['idBarang']}'") or die(mysql_error());
$jum = mysql_fetch_array($queryBarang);
$jumBarangBaru = $jum[jumBarang] + $penjualan[jumBarang];
