<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.pinjam_tabung.php';
$peminjaman = new pinjam_tabung();
switch ($_POST['apa']) {
case "get-pinjaman":
$collect = array();
if (isset($_POST['konsumen']) && $_POST['konsumen'] != "") {
$query = "SELECT `barang`.`nama`, `pinjaman_tabung`.* FROM `pinjaman_tabung` \n\t\t\t\t\tINNER JOIN `barang` ON (`pinjaman_tabung`.`id_barang` = `barang`.`id`) \n\t\t\t\t\tWHERE `pinjaman_tabung`.`id_konsumen` LIKE '" . $_POST['konsumen'] . "' AND \n\t\t\t\t\t`pinjaman_tabung`.`jml_kembali` < `pinjaman_tabung`.`jml_pinjam`;";
if ($qData = $peminjaman->runQuery($query)) {
while ($rs = $qData->fetch_array()) {
$jenis = $rs['jenis_pinjaman'] == "1" ? "Permanen" : "Sementara";
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["jml_pinjam"]);
array_push($detail, $jenis);
array_push($detail, $rs["tgl_pinjam"]);
array_push($detail, $rs["tgl_kembali"]);
array_push($detail, "<button class='btn btn-sm btn-primary' id='btn-show-kembali' data-id='" . $rs['id'] . "' \n\t\t\t\t\t\t\tdata-jenis='" . $rs['jenis_pinjaman'] . "'><i class='fa fa-share'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
}
echo json_encode(array("aaData" => $collect));
break;
case "simpan":
$arr = array();
if (isset($_POST['txt-id']) && $_POST['txt-id'] != "" && isset($_POST['txt-jenis']) && $_POST['txt-jenis'] != "" && isset($_POST['dp-kembali']) && $_POST['dp-kembali'] != "" && isset($_POST['txt-jumlah']) && $_POST['txt-jumlah'] != "") {
if ($result = $peminjaman->kembali($_POST['txt-id'], $_POST['txt-jenis'], $_POST['dp-kembali'], $_POST['txt-jumlah'])) {
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.pinjam_tabung.php';
$peminjaman = new pinjam_tabung();
switch ($_POST['apa']) {
case "get-pinjaman":
$collect = array();
if (isset($_POST['konsumen']) && $_POST['konsumen'] != "") {
$query = "SELECT `barang`.`nama`, `pinjaman_tabung`.* FROM `pinjaman_tabung` \n\t\t\t\t\tINNER JOIN `barang` ON (`pinjaman_tabung`.`id_barang` = `barang`.`id`) \n\t\t\t\t\tWHERE `pinjaman_tabung`.`id_konsumen` LIKE '" . $_POST['konsumen'] . "';";
if ($query = $peminjaman->runQuery($query)) {
while ($rs = $query->fetch_array()) {
if ($rs['id_gudang_pinjam'] == null) {
$tombol = "<button type='button' class='btn btn-sm btn-primary' id='btn-show-out' \n\t\t\t\t\t\t\t\t\t\tdata-id='" . $rs["id"] . "' data-idbarang='" . $rs["id_barang"] . "' data-jml='" . $rs["jml_pinjam"] . "'>\n\t\t\t\t\t\t\t\t\t\t<i class='fa fa-check'></i></button>";
} else {
$tombol = "<button type='button' class='btn btn-sm btn-primary' id='btn-show-in' \n\t\t\t\t\t\t\t\t\t\tdata-id='" . $rs["id"] . "' data-idbarang='" . $rs["id_barang"] . "' data-jml='" . $rs["jml_kembali"] . "'>\n\t\t\t\t\t\t\t\t\t\t<i class='fa fa-check'></i></button>";
}
if ($rs['id_gudang_pinjam'] != null && $rs['id_gudang_kembali'] != null) {
$tombol = "";
}
$detail = array();
array_push($detail, $rs["tgl_pinjam"]);
array_push($detail, $rs["jml_pinjam"]);
array_push($detail, $rs["tgl_kembali"]);
array_push($detail, $rs["jml_kembali"]);
array_push($detail, $tombol);
array_push($collect, $detail);
unset($detail);
}
}
}
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.pinjam_tabung.php';
$peminjaman = new pinjam_tabung();
switch ($_POST['apa']) {
case "simpan":
$arr = array();
if (isset($_POST['tglpinjam']) && $_POST['tglpinjam'] != "" && isset($_POST['barang']) && $_POST['barang'] != "" && isset($_POST['konsumen']) && $_POST['konsumen'] != "" && isset($_POST['jumlah']) && $_POST['jumlah'] != "" && isset($_POST['jenis']) && $_POST['jenis'] != "") {
if ($result = $peminjaman->pinjam($_POST['konsumen'], $_POST['barang'], $_POST['tglpinjam'], $_POST['tglkembali'], $_POST['jenis'], $_POST['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;
}
}
