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