if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["nomor_rekening"]);
array_push($detail, "Rp " . number_format($rs["saldo"], 2, ",", "."));
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-setor' data-id='" . $rs["id"] . "'>\n\t\t\t\t\t\t\t\t\t<i class='fa fa-plus'></i> Setor Dana</button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "setor-dana":
$arr = array();
if (isset($_POST['txt-idbank']) && $_POST['txt-idbank'] != "" && isset($_POST['txt-bukti']) && $_POST['txt-bukti'] != "" && isset($_POST['txt-tglsetor']) && $_POST['txt-tglsetor'] != "" && isset($_POST['txt-keterangan']) && $_POST['txt-keterangan'] != "" && isset($_POST['txt-jumlah']) && $_POST['txt-jumlah'] != "") {
if ($result = $bank->transaksi_setor($_POST['txt-idbank'], $_POST['txt-bukti'], $_POST['txt-tglsetor'], $_POST['txt-keterangan'], $_POST['txt-jumlah'], d_code($_SESSION['en-data']))) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Harap isi data dengan lengkap..";
}
echo json_encode($arr);
break;
}
}
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 `pelunasan` SET `ambil_bg` = '1' WHERE `id` = '{$idPelunasan}';";
if ($result = $this->runQuery($query)) {
$bank = new bank();
$hasilBank = $bank->transaksi_setor($idBank, $bukti, $tglBg, "Pencairan BG " . $bukti, $totalBayar, $idKaryawan);
if ($hasilBank) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
function setor_bank($id, $bank, $bukti, $total, $idKaryawan)
{
$id = $this->clearText($id);
$bank = $this->clearText($bank);
$bukti = $this->clearText($bukti);
$total = $this->clearText($total);
$idKaryawan = $this->clearText($idKaryawan);
$tgl = date("Y-m-d");
$prefixID = substr($id, 0, 3);
if ($prefixID == "EPP") {
$query = "UPDATE `pelunasan` SET `id_bank` = '{$bank}', `no_bukti` = '{$bukti}' WHERE `id` = '{$id}';";
$keterangan = "Setoran Pelunasan " . $id;
} else {
$query = "UPDATE `penjualan` SET `id_bank` = '{$bank}', `no_bukti` = '{$bukti}' WHERE `id` = '{$id}';";
$keterangan = "Setoran Penjualan " . $id;
}
if ($result = $this->runQuery($query)) {
$cbank = new bank();
$hasilBank = $cbank->transaksi_setor($bank, $bukti, $tgl, $keterangan, $total, $idKaryawan);
if ($hasilBank) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
