$idTransaksiBeli = mysql_insert_id(); 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());
if (mysql_num_rows($hasil) < 1) { mysql_query("INSERT INTO kategori_barang (namaKategoriBarang) VALUES ('" . $_POST["kategori{$ctr}"] . "')"); $hasil = mysql_query("SELECT LAST_INSERT_ID() FROM tmp_detail_beli"); $x = mysql_fetch_array($hasil); $idKategoriBarang = $x[0]; echo "<br />--- Menambahkan kategori barang: " . $_POST["kategori{$ctr}"] . " "; } else { $x = mysql_fetch_array($hasil); $idKategoriBarang = $x[idKategoriBarang]; } // cek apakah ada barcode ini di table barang ? $hasil = mysql_query("SELECT jumBarang, namaBarang FROM barang WHERE barcode='" . $_POST["barcode{$ctr}"] . "'"); $x = mysql_fetch_array($hasil); // jika ada - tambah quantity nya if (mysql_num_rows($hasil) > 0) { 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}"]);