if ($_POST[tipePembayaran] == '2') { mysql_query("INSERT INTO hutang(idTransaksiBeli,nominal,tglBayar,\n username,last_update)\n VALUES('{$idTransaksiBeli}','{$_POST['tot_pembayaran']}',\n '{$_POST['tglBayar']}','{$_SESSION['uname']}','{$tgl}')") or die(mysql_error()); } $sql = "SELECT * FROM tmp_detail_beli WHERE idSupplier = '" . $_POST['idSupplier'] . "'\n\t\t\tAND username = '******'uname'] . "' AND idBarang != 0"; $dataBarang = mysql_query($sql) or die(mysql_error()); //echo $sql; while ($simpan = mysql_fetch_array($dataBarang)) { $sql_simpan = "INSERT INTO detail_beli(idTransaksiBeli,barcode,\n tglExpire,jumBarang,jumBarangAsli,hargaBeli,username,idBarang)\n VALUES('{$idTransaksiBeli}','{$simpan['barcode']}',\n '{$simpan['tglExpire']}',{$simpan['jumBarang']},{$simpan['jumBarang']},'{$simpan['hargaBeli']}','{$_SESSION['uname']}','{$simpan['idBarang']}')"; //echo $sql_simpan; mysql_query($sql_simpan) or die(mysql_error()); $jumlahAkhir = 0; $jumBarang = mysql_query("SELECT jumBarang FROM barang WHERE barcode = '" . $simpan['barcode'] . "'") or die(mysql_error()); $jumlah = mysql_fetch_array($jumBarang); $jumlahAkhir = $jumlah[jumBarang] + $simpan[jumBarang]; if (cekHargaJualBerubah($simpan['barcode'], $simpan['hargaJual'])) { hargaJualBerubah($simpan['barcode']); } mysql_query("UPDATE barang SET jumBarang = '{$jumlahAkhir}',\n hargaJual = '{$simpan['hargaJual']}' WHERE barcode = '{$simpan['barcode']}'") or die(mysql_error()); // harga banded $hb = mysql_query("SELECT barcode, qty, harga_satuan FROM tmp_harga_banded WHERE barcode = '{$simpan['barcode']}'"); $tmpHargaBanded = mysql_fetch_array($hb, MYSQL_ASSOC); // print_r($tmpHargaBanded); $sql = "INSERT INTO harga_banded (barcode, qty, harga) " . "VALUES('{$simpan['barcode']}',{$tmpHargaBanded['qty']},{$tmpHargaBanded['harga_satuan']}) " . "ON DUPLICATE KEY UPDATE qty={$tmpHargaBanded['qty']}, harga={$tmpHargaBanded['harga_satuan']} "; if ($tmpHargaBanded) { mysql_query($sql) or die(mysql_error()); } } mysql_query("DELETE FROM tmp_detail_beli where idSupplier = '{$_SESSION['idSupplier']}' and username = '******'uname']}'") or die(mysql_error()); // hapus harga banded mysql_query("DELETE FROM tmp_harga_banded WHERE supplier_id = '{$_SESSION['idSupplier']}' and user_name = '{$_SESSION['uname']}'") or die(mysql_error()); releaseSupplier();
if (cekHargaJualBerubah($_POST["barcode{$ctr}"], $_POST["rrp{$ctr}"])) { hargaJualBerubah($_POST["barcode{$ctr}"]); } $sql = "UPDATE barang SET jumBarang=" . ($x[jumBarang] + $_POST["jumlah{$ctr}"]) . ",\n\t\t\t\t\t\t\t\tidKategoriBarang = {$idKategoriBarang},\n\t\t\t\t\t\t\t\tidSatuanBarang = {$idSatuanBarang}, "; // PENTING: SUPPLIER TIDAK DIUBAH JIKA BARANG ADA // berdasarkan hasil meeting dengan P Dani, P Eko, P Herry, 20140211 //idSupplier = $idSupplier, $sql .= "hargaJual = " . $_POST["rrp{$ctr}"] . "\n\t\t\t\t\t\t\tWHERE barcode='" . $_POST["barcode{$ctr}"] . "'"; $hasil = mysql_query($sql); echo "<br />=== Barcode sudah ada: di <u>Database</u>: <b>{$x['namaBarang']}</b>,\n\t\t\t\t\t\t\tdi <u>Invoice</u>: <b>" . $_POST["namabarang{$ctr}"] . "</b>"; echo "<br />### Update data barang: {$sql} - " . $_POST["namabarang{$ctr}"] . " <br />"; // jika tidak - bikin 1 recordnya } else { $sql = "INSERT INTO barang (idBarang, namaBarang, idKategoriBarang, idSatuanBarang, jumBarang, hargaJual,\n\t\t\t\t\t\t\t\t\t last_update, idSupplier, barcode, username, idRak)\n\t\t\t\t\t\tVALUES ({$idBarang}, '" . $_POST["namabarang{$ctr}"] . "', {$idKategoriBarang}, {$idSatuanBarang},\n\t\t\t\t\t\t\t" . $_POST["jumlah{$ctr}"] . ", " . $_POST["rrp{$ctr}"] . ", '{$tgl}',\n\t\t\t\t\t\t\t{$idSupplier}, '" . $_POST["barcode{$ctr}"] . "', '{$_SESSION['uname']}', '999')"; $hasil = mysql_query($sql); hargaJualBerubah($_POST["barcode{$ctr}"]); echo "<br />### Menambahkan data barang: {$sql} <br />"; } // hitung total $totalInvoice = $totalInvoice + $_POST["jumlah{$ctr}"] * $_POST["harga{$ctr}"]; // tambahkan counter $ctr++; } // while ($ctr <= $_POST[count]) { // update nilai invoice di table transaksibeli $hasil = mysql_query("UPDATE transaksibeli SET nominal={$totalInvoice} WHERE idTransaksiBeli={$idTransaksiBeli}"); // laporkan jumlah record yang kita proses echo "<br /><h2>Jumlah item di invoice ini: " . ($ctr - 1) . " <br />\n\t\tTotal Pembelian : Rp " . uang($totalInvoice) . "</h2><br />Selesai."; break; case "buatrpo1": // ===============================================================================================================