$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];