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);
unset($detail);
}
// 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;
}
}
$qCek = "SELECT SUM(`jml`) FROM `penjualan` WHERE `id_konsumen` = '" . $_POST['konsumen'] . "' AND \n\t\t\t\t\t\t\t`tgl` = '" . $_POST['tgl'] . "' AND `id_barang` = '" . $_POST['barang'] . "';";
if ($resCek = $konsumen->runQuery($qCek)) {
$rsCek = $resCek->fetch_array();
if ($rsCek[0] != null) {
$arr['kuota'] = $arr['kuota'] - $rsCek[0];
}
}
$arr['tempo'] = $tglTempo;
