$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}"]);
