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