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);
break;
case "simpan":
$arr = array();
if (isset($_POST['tgl']) && $_POST['tgl'] != "" && isset($_POST['sales']) && $_POST['sales'] != "" && isset($_POST['barang']) && $_POST['barang'] != "" && isset($_POST['konsumen']) && $_POST['konsumen'] != "" && isset($_POST['jml']) && $_POST['jml'] != "" && isset($_POST['hargaJual']) && $_POST['hargaJual'] != "" && isset($_POST['het']) && $_POST['het'] != "" && isset($_POST['total']) && $_POST['total'] != "" && isset($_POST['jenis']) && $_POST['jenis'] != "" && isset($_POST['nota']) && $_POST['nota'] != "") {
$qCek = "SELECT COUNT(`id`) FROM `khusus_penjualan` WHERE `no_nota` = '" . $_POST['nota'] . "'";
if ($resCek = $penjualan->runQuery($qCek)) {
$rsCek = $resCek->fetch_array();
if ($rsCek[0] > 0) {
$arr['status'] = FALSE;
$arr['msg'] = "Penjualan dengan nomor nota tersebut sudah ada..";
} else {
if ($_POST['jenis'] == '4') {
$tempo = $_POST['tempo'];
$bank = "0";
$bukti = "-";
$totalBayar = 0;
} else {
$tempo = '0000-00-00';
$bank = $_POST['bank'];
$bukti = $_POST['bukti'];
$totalBayar = $_POST['total'];
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.penjualan_khusus.php';
$penjualan = new penjualan_khusus();
switch ($_POST['apa']) {
case "get-request":
$collect = array();
if ($query = $penjualan->runQuery("SELECT `request_hapus`.*, `karyawan`.`nama` FROM `request_hapus` \n\t\t\t\tINNER JOIN `karyawan` ON(`request_hapus`.`id_karyawan` = `karyawan`.`id`) WHERE `jenis` = '4' \n\t\t\t\tAND `is_proses` = '0' AND `request_hapus`.`hapus` = '0';")) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["tgl"]);
array_push($detail, $rs["nama"]);
array_push($detail, $rs["id_hapus"]);
array_push($detail, $rs["keterangan"]);
array_push($detail, "<button class='btn btn-sm btn-primary' id='btn-cek' data-id='" . $rs['id_hapus'] . "'>\n\t\t\t\t\t\t\t<i class='fa fa-search'></i></button>\n\t\t\t\t\t\t\t<button class='btn btn-sm btn-danger' id='btn-hapus-req' data-id='" . $rs['id'] . "'>\n\t\t\t\t\t\t\t<i class='fa fa-trash-o'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
echo json_encode(array("aaData" => $collect));
break;
case "get-penjualan":
$collect = array();
if (isset($_POST['id']) && $_POST['id'] != "") {
$qJual = "SELECT `khusus_penjualan`.*, `konsumen`.`nama` AS `nama_konsumen`, \n\t\t\t\t\t\t\t`khusus_penjualan_acc_gudang`.`acc_gudang`, `khusus_pelunasan`.`id_bank`, `khusus_pelunasan`.`id_bank` AS `idbanklunas` FROM `khusus_penjualan`\n\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`khusus_penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\tINNER JOIN `khusus_penjualan_acc_gudang` ON (`khusus_penjualan`.`id` = `khusus_penjualan_acc_gudang`.`id_penjualan`) \n\t\t\t\t\t\t\tLEFT JOIN `khusus_pelunasan` ON (`khusus_penjualan`.`id` = `khusus_pelunasan`.`id_penjualan`) \n\t\t\t\t\t\t\tWHERE `khusus_penjualan`.`id` = '" . $_POST['id'] . "';";
if ($query = $penjualan->runQuery($qJual)) {
while ($rs = $query->fetch_array()) {
if ($rs["id_barang"] == "1") {
$namaBarang = "LPG 50Kg Khusus";
} else {
<?php
if (isset($_POST['apa']) && $_POST['apa'] != "") {
include 'modules/model/class.penjualan_khusus.php';
$penjualan = new penjualan_khusus();
switch ($_POST['apa']) {
case "get-penjualan":
$collect = array();
if (isset($_POST['tgl']) && $_POST['tgl'] != "" && isset($_POST['jenis']) && $_POST['jenis'] != "") {
if ($_POST['jenis'] == '1') {
$qJual = "SELECT `khusus_penjualan`.`id`, `khusus_penjualan`.`no_nota`, `khusus_penjualan`.`jml`, `khusus_penjualan`.`total_bayar`,\n\t\t\t\t\t\t\t\t`konsumen`.`nama` AS `nama_konsumen` \n\t\t\t\t\t\t\t\tFROM `khusus_penjualan` \n\t\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`khusus_penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\t\tWHERE `khusus_penjualan`.`tgl` = '" . $_POST['tgl'] . "' AND `khusus_penjualan`.`jenis` = '1' AND `khusus_penjualan`.`no_bukti` = '';";
} else {
$qJual = "SELECT `khusus_pelunasan`.`id`, `khusus_penjualan`.`no_nota`, `khusus_penjualan`.`jml`, `khusus_pelunasan`.`total_bayar`,\n\t\t\t\t\t\t\t\t`konsumen`.`nama` AS `nama_konsumen` \n\t\t\t\t\t\t\t\tFROM `khusus_pelunasan` \n\t\t\t\t\t\t\t\tINNER JOIN `khusus_penjualan` ON (`khusus_pelunasan`.`id_penjualan` = `khusus_penjualan`.`id`) \n\t\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`khusus_penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\t\tWHERE `khusus_pelunasan`.`tgl` = '" . $_POST['tgl'] . "' AND `khusus_pelunasan`.`jenis` = '1' AND `khusus_pelunasan`.`no_bukti` = '';";
}
if ($query = $penjualan->runQuery($qJual)) {
while ($rs = $query->fetch_array()) {
$detail = array();
array_push($detail, $rs["id"]);
array_push($detail, $rs["no_nota"]);
array_push($detail, $rs["nama_konsumen"]);
array_push($detail, $rs["jml"]);
array_push($detail, "Rp " . number_format($rs["total_bayar"], 0, ",", "."));
array_push($detail, "<button class='btn btn-sm btn-primary' id='btn-show-setor' data-id='" . $rs['id'] . "' \n\t\t\t\t\t\t\t\t\t\tdata-total='" . $rs['total_bayar'] . "'>\n\t\t\t\t\t\t\t\t\t\t<i class='fa fa-mail-forward'></i></button>");
array_push($collect, $detail);
unset($detail);
}
}
}
echo json_encode(array("aaData" => $collect));
break;
case "get-bank":
