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; } }
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; } }