public function delete($id)
{
konsumen::destroy($id);
return redirect(url("/members"));
}
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.konsumen.php';
$konsumen = new konsumen();
switch ($_POST['apa']) {
case 'get-konsumen':
if ($query = $konsumen->get_pangkalan()) {
echo "<option value='%'>Semua</option>";
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
case "get-kuota":
$collect = array();
if (isset($_POST['id']) && $_POST['id'] != "" && isset($_POST['tglAwal']) && $_POST['tglAwal'] != "" && isset($_POST['tglAkhir']) && $_POST['tglAkhir'] != "") {
if ($query = $konsumen->get_kuota_jual($_POST['id'], $_POST['tglAwal'], $_POST['tglAkhir'])) {
while ($rs = $query->fetch_array()) {
$qCek = "SELECT SUM(jml) FROM penjualan WHERE id_konsumen = '" . $rs["id_konsumen"] . "' AND tgl = '" . $rs['tgl'] . "' AND id_barang = '1';";
if ($resCek = $konsumen->runQuery($qCek)) {
$rsCek = $resCek->fetch_array();
$jumlahTerambil = $rsCek[0];
}
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["tgl"]);
array_push($detail, $rs["jml_alokasi"]);
array_push($detail, $jumlahTerambil);
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-ubah-data' data-id='" . $rs['id'] . "' \n\t\t\t\t\t\t\t\t\t\tdata-kuota='" . $rs['jml_alokasi'] . "' data-tgl='" . $rs['tgl'] . "' data-nama='" . $rs['nama'] . "'>\n\t\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\t<button type='button' class='btn btn-sm btn-danger' id='btn-hapus-data' data-id='" . $rs['id'] . "'>\n\t\t\t\t\t\t\t\t\t\t<i class='fa fa-trash-o'></i></button>");
array_push($collect, $detail);
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.penjualan.php';
$penjualan = new penjualan();
switch ($_POST['apa']) {
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-konsumen":
$konsumen = new konsumen();
if ($query = $konsumen->get_konsumen()) {
echo "<option value='%'>Semua</option>";
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
}
}
if ($query = $konsumen->get_konsumen_khusus()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
}
}
break;
case "get-bank":
$bank = new bank_khusus();
if ($query = $bank->get_bank()) {
while ($rs = $query->fetch_array()) {
echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . " " . $rs['nomor_rekening'] . "</option>";
}
}
break;
case "get-kuota-harga":
$konsumen = new konsumen();
$arr = array();
if (isset($_POST['konsumen']) && $_POST['konsumen'] != "" && isset($_POST['barang']) && $_POST['barang'] != "" && isset($_POST['tgl']) && $_POST['tgl'] != "") {
if ($query = $konsumen->get_harga_jual_khusus($_POST['konsumen'])) {
$rs = $query->fetch_array();
$arr['status'] = TRUE;
if ($_POST['barang'] == "1") {
$arr['harga'] = $rs['harga_50kg_khusus'] != null ? $rs['harga_50kg_khusus'] : 0;
$arr['kuota'] = 0;
}
}
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Harap isi data dengan lengkap..";
}
echo json_encode($arr);
// if ($query = $konsumen->get_konsumen()) {
// while ($rs = $query->fetch_array()) {
// echo "<option value='".$rs['id']."'>".$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-kuota-harga":
$konsumen = new konsumen();
$arr = array();
if (isset($_POST['konsumen']) && $_POST['konsumen'] != "" && isset($_POST['barang']) && $_POST['barang'] != "" && isset($_POST['tgl']) && $_POST['tgl'] != "") {
if ($query = $konsumen->get_harga_jual($_POST['konsumen'])) {
$rs = $query->fetch_array();
$arr['status'] = TRUE;
$add_days = $rs['waktu_tempo'];
$tglTempo = date('Y-m-d', strtotime($_POST['tgl']) + 24 * 3600 * $add_days);
if ($_POST['barang'] == "1") {
$arr['harga'] = $rs['harga_3kg'] != null ? $rs['harga_3kg'] : 0;
if ($kuota = $konsumen->get_kuota_jual($_POST['konsumen'], $_POST['tgl'], $_POST['tgl'])) {
if ($kuota->num_rows > 0) {
$rsKuota = $kuota->fetch_array();
$arr['kuota'] = $rsKuota['jml_alokasi'] != null ? $rsKuota['jml_alokasi'] : 0;
} else {
$arr['kuota'] = 0;
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.konsumen.php';
$konsumen = new konsumen();
switch ($_POST['apa']) {
case "get-harga-jual":
$collect = array();
if ($query = $konsumen->get_konsumen_khusus()) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, "Rp " . number_format($rs["harga_50kg_khusus"], 0, ",", "."));
array_push($detail, "<button type='button' class='btn btn-sm btn-primary' id='btn-ubah-data' data-id='" . $rs["id"] . "' \n\t\t\t\t\t\t\t\tdata-50kgkhusus='" . $rs["harga_50kg_khusus"] . "'><i class='fa fa-pencil'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "ubah-harga-jual":
$arr = array();
if (isset($_POST['txt-id']) && $_POST['txt-id'] != "" && isset($_POST['txt-50kg-khusus']) && $_POST['txt-50kg-khusus'] != "") {
if ($result = $konsumen->set_harga_jual_khusus($_POST['txt-id'], $_POST['txt-50kg-khusus'])) {
$arr['status'] = TRUE;
$arr['msg'] = "Data tersimpan..";
} else {
$arr['status'] = FALSE;
$arr['msg'] = "Gagal menyimpan..";
}
} else {
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.konsumen.php';
$konsumen = new konsumen();
switch ($_POST['apa']) {
case "get-konsumen":
$collect = array();
if ($query = $konsumen->get_konsumen()) {
while ($rs = $query->fetch_array()) {
if ($rs["pangkalan"] == "1") {
$pangkalan = "Ya";
} else {
$pangkalan = "Bukan";
}
$detail = array();
array_push($detail, $rs["nama"]);
array_push($detail, $rs["pic"]);
array_push($detail, $rs["alamat"]);
array_push($detail, $rs["telepon"]);
array_push($detail, $pangkalan);
array_push($detail, $rs["waktu_tempo"]);
array_push($detail, number_format($rs["harga_3kg"], 0, ",", "."));
array_push($detail, number_format($rs["harga_12kg"], 0, ",", "."));
array_push($detail, number_format($rs["harga_12kg_bg"], 0, ",", "."));
array_push($detail, number_format($rs["harga_50kg"], 0, ",", "."));
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\t\tdata-alamat='" . $rs["alamat"] . "' data-telp='" . $rs["telepon"] . "' data-tempo='" . $rs["waktu_tempo"] . "' \n\t\t\t\t\t\t\t\t\t\t\tdata-3kg='" . $rs["harga_3kg"] . "' data-12kg='" . $rs["harga_12kg"] . "' data-bg='" . $rs["harga_12kg_bg"] . "' \n\t\t\t\t\t\t\t\t\t\t\tdata-50kg='" . $rs["harga_50kg"] . "'><i class='fa fa-pencil'></i></button> \n\t\t\t\t\t\t\t\t\t\t\t<button type='button' class='btn btn-sm btn-danger' id='btn-hapus-konsumen' data-id='" . $rs["id"] . "'><i class='fa fa-trash-o'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
