<?php if (isset($_POST['apa']) && $_POST['apa'] != "") { include 'modules/model/class.penjualan.php'; $penjualan = new penjualan(); switch ($_POST['apa']) { case "get-penjualan": $collect = array(); $qJual = "SELECT `penjualan_acc_gudang`.`id_penjualan`, `penjualan`.`tgl`, `penjualan`.`no_nota`, `penjualan`.`jml`, `barang`.`id` AS \n\t\t\t\t\t\t`id_barang`, `barang`.`nama` AS `nama_barang`, `konsumen`.`nama` AS `nama_konsumen`, \n\t\t\t\t\t\t`penjualan_acc_gudang`.`acc_gudang` FROM `penjualan_acc_gudang` \n\t\t\t\t\t\tINNER JOIN `penjualan` ON (`penjualan_acc_gudang`.`id_penjualan` = `penjualan`.`id`) \n\t\t\t\t\t\tINNER JOIN `barang` ON (`penjualan`.`id_barang` = `barang`.`id`) \n\t\t\t\t\t\tINNER JOIN `konsumen` ON (`penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\tWHERE `penjualan_acc_gudang`.`acc_gudang` IS NULL;"; if ($query = $penjualan->runQuery($qJual)) { while ($rs = $query->fetch_array()) { if ($rs['acc_gudang'] == null) { $acc = "Belum"; $button = "<button class='btn btn-primary btn-sm' id='btn-acc' data-id='" . $rs['id_penjualan'] . "' \n\t\t\t\t\t\t\t\t\tdata-barang='" . $rs['id_barang'] . "' data-jml='" . $rs['jml'] . "'><i class='fa fa-check'></i></button>"; } else { if ($rs['acc_gudang'] == "1") { $acc = "Ya"; $button = ""; } else { $acc = "Tidak"; $button = ""; } } $detail = array(); array_push($detail, $rs["id_penjualan"]); array_push($detail, $rs["tgl"]); array_push($detail, $rs["no_nota"]); array_push($detail, $rs["nama_konsumen"]); array_push($detail, $rs["nama_barang"]); array_push($detail, $rs["jml"]); array_push($detail, $acc);
<?php if (isset($_POST['apa']) && $_POST['apa'] != "") { include 'modules/model/class.penjualan.php'; $penjualan = new penjualan(); 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` = '1' \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 `penjualan`.*, `barang`.`nama` AS `nama_barang`, `konsumen`.`nama` AS `nama_konsumen`, \n\t\t\t\t\t\t\t`penjualan_acc_gudang`.`acc_gudang`, `pelunasan`.`id_bank`, `pelunasan`.`id_bank` AS `idbanklunas` FROM `penjualan`\n\t\t\t\t\t\t\tINNER JOIN `barang` ON (`penjualan`.`id_barang` = `barang`.`id`) \n\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\tINNER JOIN `penjualan_acc_gudang` ON (`penjualan`.`id` = `penjualan_acc_gudang`.`id_penjualan`) \n\t\t\t\t\t\t\tLEFT JOIN `pelunasan` ON (`penjualan`.`id` = `pelunasan`.`id_penjualan`) \n\t\t\t\t\t\t\tWHERE `penjualan`.`id` = '" . $_POST['id'] . "';"; if ($query = $penjualan->runQuery($qJual)) { while ($rs = $query->fetch_array()) { $detail = array(); array_push($detail, $rs["id"]); array_push($detail, $rs["no_nota"]);
$arr['harga'] = $rs['harga_12kg_bg'] != null ? $rs['harga_12kg_bg'] : 0; $arr['kuota'] = 0; $arr['tempo'] = $tglTempo; } } } 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 `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'; if ($_POST['barang'] == "1") { $bank = "1"; } else {