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;