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) {
break;
}
$jumBarangDetail = getJumBarangDetailPembelian($dbeli['idDetailBeli']);
if ($sisa > $jumBarangDetail) {
$sql = "UPDATE detail_beli SET jumBarang=0, isSold='Y' WHERE idDetailBeli = {$dbeli['idDetailBeli']}";
mysql_query($sql) or die('Gagal update detail_beli, error:' . mysql_error());
$sisa -= $jumBarangDetail;
// Masih ada sisa, lanjutkan ke detail_beli selanjutnya
} else {
$jumBarangDetailB = $jumBarangDetail - $sisa;
$sql = "UPDATE detail_beli SET jumBarang={$jumBarangDetailB}";
if ($jumBarangDetailB == 0) {
$sql .= ", isSold='Y'";
}
$sql .= " WHERE idDetailBeli = {$dbeli['idDetailBeli']}";
mysql_query($sql) or die('Gagal update detail_beli, error:' . mysql_error());
$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];
mysql_query("UPDATE barang SET jumBarang = {$jumBarangBaru} WHERE idBarang = '{$penjualan['idBarang']}'") or die(mysql_error());
