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