function transaksi_pembelian($tglTebus, $beaAdmin, $grandTotal, $idBank, $bukti, $jenisTarikan, $idKaryawan, $detail)
{
$tglTebus = $this->clearText($tglTebus);
$beaAdmin = $this->clearText($beaAdmin);
$grandTotal = $this->clearText($grandTotal);
$idBank = $this->clearText($idBank);
$bukti = $this->clearText($bukti);
$jenisTarikan = $this->clearText($jenisTarikan);
$idKaryawan = $this->clearText($idKaryawan);
$id = $this->autocode_pembelian($tglTebus);
$hasilBank = FALSE;
$hasilDetail = FALSE;
$query = "INSERT INTO `khusus_pembelian` VALUES('{$id}', '{$tglTebus}', '{$beaAdmin}', '{$grandTotal}', \n\t\t\t'{$idBank}', '{$bukti}', '{$jenisTarikan}', '{$idKaryawan}');";
if ($result = $this->runQuery($query)) {
$detailBeli = json_decode($detail, true);
foreach ($detailBeli as $item) {
if ($simpan = $this->runQuery("INSERT INTO `khusus_pembelian_detail` VALUES('{$id}', '" . $item['idLoading'] . "')")) {
$hasilDetail = TRUE;
} else {
$hasilDetail = FALSE;
break;
}
}
if ($hasilDetail) {
$bank = new bank_khusus();
$hasilBank = $bank->transaksi_tarik($idBank, $bukti, $tglTebus, "Pembelian " . $id, $grandTotal, 0, $idKaryawan, $jenisTarikan);
}
if ($hasilBank == TRUE && $hasilDetail == TRUE) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
if ($query = $barang->get_barang()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "' data-het='" . $rs['het'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
case "get-konsumen":
$konsumen = new konsumen();
if ($query = $konsumen->get_konsumen_khusus()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
case "get-bank":
$bank = new bank_khusus();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . " " . $rs['nomor_rekening'] . "</option>";
}
}
break;
case "get-kuota-harga":
$konsumen = new konsumen();
$arr = array();
if (isset($_POST['konsumen']) && $_POST['konsumen'] != "" && isset($_POST['barang']) && $_POST['barang'] != "" && isset($_POST['tgl']) && $_POST['tgl'] != "") {
if ($query = $konsumen->get_harga_jual_khusus($_POST['konsumen'])) {
$rs = $query->fetch_array();
$arr['status'] = TRUE;
if ($_POST['barang'] == "1") {
$arr['harga'] = $rs['harga_50kg_khusus'] != null ? $rs['harga_50kg_khusus'] : 0;
function penjualan_hapus($idPenjualan, $idKaryawan)
{
$idPenjualan = $this->clearText($idPenjualan);
$idKaryawan = $this->clearText($idKaryawan);
$bankRevisi = "";
$totalKasRevisi = 0;
$qFinal = "";
$qCekPenjualan = "SELECT * FROM `khusus_penjualan` WHERE `id` = '{$idPenjualan}';";
if ($resCekPenjualan = $this->runQuery($qCekPenjualan)) {
$rsCekPenjualan = $resCekPenjualan->fetch_array();
if ($rsCekPenjualan['jenis'] == "4") {
//cek penjualan jika tempo
$qCekPelunasan = "SELECT * FROM `khusus_pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
if ($resCekPelunasan = $this->runQuery($qCekPelunasan)) {
$rsCekPelunasan = $resCekPelunasan->fetch_array();
if ($rsCekPelunasan['jenis'] == "4") {
//cek pelunasan jika bg
if ($rsCekPelunasan['ambil_bg'] == "1") {
//cek pelunasan jika bg sudah diambil
$bankRevisi = $rsCekPelunasan['id_bank'];
$totalKasRevisi = $rsCekPelunasan['total_bayar'];
$qFinal .= "DELETE FROM `khusus_pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
} else {
//cek pelunasan jika bg belum diambil
$qFinal .= "DELETE FROM `khusus_pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
}
} elseif ($rsCekPelunasan['jenis'] == "2" || $rsCekPelunasan['jenis'] == "3") {
//cek pelunasan jika debet atau trf
$bankRevisi = $rsCekPelunasan['id_bank'];
$totalKasRevisi = $rsCekPelunasan['total_bayar'];
$qFinal .= "DELETE FROM `khusus_pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
} elseif ($rsCekPelunasan['jenis'] == "1") {
//cek pelunasan jika cash
if ($rsCekPelunasan['no_bukti'] == "") {
//cek pelunasan jika cash belum disetor
$qFinal .= "DELETE FROM `khusus_pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
} else {
//cek pelunasan jika cash sudah disetor
$bankRevisi = $rsCekPelunasan['id_bank'];
$totalKasRevisi = $rsCekPelunasan['total_bayar'];
$qFinal .= "DELETE FROM `khusus_pelunasan` WHERE `id_penjualan` = '{$idPenjualan}';";
}
}
}
$qFinal .= "DELETE FROM `khusus_penjualan` WHERE `id` = '{$idPenjualan}';";
} elseif ($rsCekPenjualan['jenis'] == "2" || $rsCekPenjualan['jenis'] == "3") {
//cek penjualan jika debet atau trf
$bankRevisi = $rsCekPenjualan['id_bank'];
$totalKasRevisi = $rsCekPenjualan['total_bayar'];
$qFinal .= "DELETE FROM `khusus_penjualan` WHERE `id` = '{$idPenjualan}';";
} elseif ($rsCekPenjualan['jenis'] == "1") {
//cek penjualan jika cash
if ($rsCekPenjualan['no_bukti'] == "") {
//cek penjualan jika cash belum disetor
$qFinal .= "DELETE FROM `khusus_penjualan` WHERE `id` = '{$idPenjualan}';";
} else {
//cek penjualan jika cash sudah disetor
$bankRevisi = $rsCekPenjualan['id_bank'];
$totalKasRevisi = $rsCekPenjualan['total_bayar'];
$qFinal .= "DELETE FROM `khusus_penjualan` WHERE `id` = '{$idPenjualan}';";
}
}
$qCekGudang = "SELECT * FROM `khusus_penjualan_acc_gudang` WHERE `id_penjualan` = '{$idPenjualan}';";
if ($resCekGudang = $this->runQuery($qCekGudang)) {
$rsCekGudang = $resCekGudang->fetch_array();
if ($rsCekGudang['acc_gudang'] == "1") {
$qFinal .= "UPDATE `khusus_barang` SET `stok_isi` = `stok_isi` + " . $rsCekPenjualan['jml'] . ", \n\t\t\t\t\t\t`stok_kosong` = `stok_kosong` - " . $rsCekPenjualan['jml'] . " WHERE `id` = '" . $rsCekPenjualan['id_barang'] . "';";
$qFinal .= "DELETE FROM `khusus_penjualan_acc_gudang` WHERE `id_penjualan` = '{$idPenjualan}';";
} else {
$qFinal .= "DELETE FROM `khusus_penjualan_acc_gudang` WHERE `id_penjualan` = '{$idPenjualan}';";
}
}
}
if ($result = $this->runMultipleQueries($qFinal)) {
if ($bankRevisi != "" && $totalKasRevisi != 0) {
$cbank = new bank_khusus();
$hasilBank = $cbank->transaksi_tarik($bankRevisi, "0000", date("Y-m-d"), "Revisi Transaksi Penjualan", $totalKasRevisi, 0, $idKaryawan, "1");
if ($hasilBank) {
return TRUE;
} else {
return FALSE;
}
} else {
return TRUE;
}
} else {
return FALSE;
}
}
function ambil_bg($idPelunasan, $tglBg, $totalBayar, $idBank, $bukti, $idKaryawan)
{
$idPelunasan = $this->clearText($idPelunasan);
$tglBg = $this->clearText($tglBg);
$totalBayar = $this->clearText($totalBayar);
$idBank = $this->clearText($idBank);
$bukti = $this->clearText($bukti);
$idKaryawan = $this->clearText($idKaryawan);
$query = "UPDATE `khusus_pelunasan` SET `ambil_bg` = '1' WHERE `id` = '{$idPelunasan}';";
if ($result = $this->runQuery($query)) {
$bank = new bank_khusus();
$hasilBank = $bank->transaksi_setor($idBank, $bukti, $tglBg, "Pencairan BG " . $bukti, $totalBayar, $idKaryawan);
if ($hasilBank) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
