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());