while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "' data-harga='" . $rs['harga_beli'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
case "get-bank":
$bank = new bank();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . " " . $rs['nomor_rekening'] . "</option>";
}
}
break;
case "get-spbe":
include 'modules/model/class.spbe.php';
$spbe = new spbe();
if ($query = $spbe->get_spbe_barang_by_barang($_POST['barang'])) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "' data-ship='" . $rs['ship_to'] . "' data-sold='" . $rs['sold_to'] . "'>" . $rs['nama_spbe'] . "</option>";
}
}
break;
case "simpan":
$arr = array();
if (isset($_POST['tgl']) && $_POST['tgl'] != "" && isset($_POST['lo']) && $_POST['lo'] != "" && isset($_POST['sa']) && $_POST['sa'] != "" && isset($_POST['barang']) && $_POST['barang'] != "" && isset($_POST['harga']) && $_POST['harga'] != "" && isset($_POST['jml']) && $_POST['jml'] != "" && isset($_POST['pajak']) && $_POST['pajak'] != "" && isset($_POST['diskon']) && $_POST['diskon'] != "" && isset($_POST['beaadmin']) && $_POST['beaadmin'] != "" && isset($_POST['total']) && $_POST['total'] != "" && isset($_POST['bank']) && $_POST['bank'] != "" && isset($_POST['jenis']) && $_POST['jenis'] != "" && isset($_POST['bukti']) && $_POST['bukti'] != "" && isset($_POST['spbe']) && $_POST['spbe'] != "") {
if ($result = $pembelian->transaksi_pembelian($_POST['tgl'], $_POST['lo'], $_POST['sa'], $_POST['barang'], $_POST['jml'], $_POST['harga'], $_POST['pajak'], $_POST['diskon'], $_POST['beaadmin'], $_POST['total'], $_POST['bank'], $_POST['bukti'], $_POST['jenis'], d_code($_SESSION['en-data']), $_POST['spbe'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Transaksi sukses tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.spbe.php';
$spbe = new spbe();
switch ($_POST['apa']) {
case "get-data":
$collect = array();
if ($query = $spbe->get_spbe_barang()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama_spbe"]);
array_push($detail, $rs["nama_barang"]);
array_push($detail, $rs["ship_to"]);
array_push($detail, $rs["sold_to"]);
array_push($detail, "<button type='button' class='btn btn-sm btn-danger' id='btn-hapus' data-id='" . $rs["id"] . "'><i class='fa fa-trash-o'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "tambah":
$arr = array();
if (isset($_POST['cmb-spbe']) && $_POST['cmb-spbe'] != "" && isset($_POST['cmb-barang']) && $_POST['cmb-barang'] != "" && isset($_POST['txt-ship']) && $_POST['txt-ship'] != "" && isset($_POST['txt-sold']) && $_POST['txt-sold'] != "") {
if ($result = $spbe->tambah_barang($_POST['cmb-spbe'], $_POST['cmb-barang'], $_POST['txt-ship'], $_POST['txt-sold'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.spbe.php';
$spbe = new spbe();
switch ($_POST['apa']) {
case "get-spbe":
$collect = array();
if ($query = $spbe->get_spbe()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-ubah-data' data-id='" . $rs["id"] . "' data-nama='" . $rs["nama"] . "'>\n\t\t\t\t\t\t\t\t\t<i class='fa fa-pencil'></i></button> \n\t\t\t\t\t\t\t\t\t<button type='button' class='btn btn-sm btn-danger' id='btn-hapus-spbe' data-id='" . $rs["id"] . "'><i class='fa fa-trash-o'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "tambah-spbe":
$arr = array();
if (isset($_POST['txt-nama']) && $_POST['txt-nama'] != "") {
if ($result = $spbe->tambah($_POST['txt-nama'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
} else {
$arr['status'] = FALSE;
