コード例 #1
0
<?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 {
コード例 #2
0
ファイル: penjualan.php プロジェクト: rifkyzulfikarf/en-sgj
<?php

if (isset($_POST['apa']) && $_POST['apa'] != "") {
    include 'modules/model/class.penjualan_khusus.php';
    $penjualan = new penjualan_khusus();
    switch ($_POST['apa']) {
        case "get-sales":
            include 'modules/model/class.karyawan.php';
            $karyawan = new karyawan();
            if ($query = $karyawan->get_karyawan()) {
                while ($rs = $query->fetch_array()) {
                    echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
                }
            }
            break;
        case "get-barang":
            include 'modules/model/class.barang_khusus.php';
            $barang = new barang_khusus();
            if ($query = $barang->get_barang()) {
                while ($rs = $query->fetch_array()) {
                    echo "<option value='" . $rs['id'] . "' data-het='" . $rs['het'] . "'>" . $rs['nama'] . "</option>";
                }
            }
            break;
        case "get-konsumen":
            $konsumen = new konsumen();
            if ($query = $konsumen->get_konsumen_khusus()) {
                while ($rs = $query->fetch_array()) {
                    echo "<option value='" . $rs['id'] . "'>" . $rs['nama'] . "</option>";
                }
            }
コード例 #3
0
<?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'] != "") {
                $qJual = "SELECT `khusus_penjualan_acc_gudang`.`id_penjualan`, `khusus_penjualan`.`no_nota`, `khusus_penjualan`.`jml`, \n\t\t\t\t\t\t\t`khusus_barang`.`id` AS \n\t\t\t\t\t\t\t`id_barang`, `khusus_barang`.`nama` AS `nama_barang`, `konsumen`.`nama` AS `nama_konsumen`, \n\t\t\t\t\t\t\t`khusus_penjualan_acc_gudang`.`acc_gudang` FROM `khusus_penjualan_acc_gudang` \n\t\t\t\t\t\t\tINNER JOIN `khusus_penjualan` ON (`khusus_penjualan_acc_gudang`.`id_penjualan` = `khusus_penjualan`.`id`) \n\t\t\t\t\t\t\tINNER JOIN `khusus_barang` ON (`khusus_penjualan`.`id_barang` = `khusus_barang`.`id`) \n\t\t\t\t\t\t\tINNER JOIN `konsumen` ON (`khusus_penjualan`.`id_konsumen` = `konsumen`.`id`) \n\t\t\t\t\t\t\tWHERE `khusus_penjualan`.`tgl` = '" . $_POST['tgl'] . "';";
                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\t\tdata-barang='" . $rs['id_barang'] . "' data-jml='" . $rs['jml'] . "'><i class='fa fa-check'></i></button>\n\t\t\t\t\t\t\t\t\t\t<button class='btn btn-danger btn-sm' id='btn-tolak' data-id='" . $rs['id_penjualan'] . "' \n\t\t\t\t\t\t\t\t\t\tdata-barang='" . $rs['id_barang'] . "' data-jml='" . $rs['jml'] . "'><i class='fa fa-ban'></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["no_nota"]);
                        array_push($detail, $rs["nama_konsumen"]);
                        array_push($detail, $rs["nama_barang"]);
                        array_push($detail, $rs["jml"]);
                        array_push($detail, $acc);
コード例 #4
0
ファイル: setor-bank.php プロジェクト: rifkyzulfikarf/en-sgj
<?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":
コード例 #5
0
 function transaksi_penjualan($tgl, $idKonsumen, $idBarang, $jmlTabung, $hargaJual, $het, $totalJual, $totalHet, $totalBayar, $jenis, $tglTempo, $idBank, $noBukti, $idSales, $idKaryawan, $nota)
 {
     $tgl = $this->clearText($tgl);
     $idKonsumen = $this->clearText($idKonsumen);
     $idBarang = $this->clearText($idBarang);
     $jmlTabung = $this->clearText($jmlTabung);
     $hargaJual = $this->clearText($hargaJual);
     $het = $this->clearText($het);
     $totalJual = $this->clearText($totalJual);
     $totalHet = $this->clearText($totalHet);
     $totalBayar = $this->clearText($totalBayar);
     $jenis = $this->clearText($jenis);
     $tglTempo = $this->clearText($tglTempo);
     $idBank = $this->clearText($idBank);
     $noBukti = $this->clearText($noBukti);
     $idSales = $this->clearText($idSales);
     $idKaryawan = $this->clearText($idKaryawan);
     $nota = $this->clearText($nota);
     $id = $this->autocode_penjualan($tgl, $idBarang);
     $sparta = FALSE;
     if ($jenis != "4") {
         //tempo
         $tglTempo = "0000-00-00";
     }
     if ($idBarang == "1" && $hargaJual > $het) {
         $totalJual = $het * $jmlTabung;
         $totalHET = $totalJual;
         $totalBayar = $totalJual;
         $selisih = $hargaJual - $het;
         $totalJualKhusus = $selisih * $jmlTabung;
         $totalBayarKhusus = $totalJualKhusus;
         $sparta = TRUE;
         $query = "INSERT INTO `penjualan` VALUES('{$id}', '{$tgl}', '{$idKonsumen}', '{$idBarang}', '{$jmlTabung}', '{$het}', \n\t\t\t\t\t\t'{$het}', '{$totalJual}', '{$totalJual}', '{$totalBayar}', '{$jenis}', '{$tglTempo}', '{$idBank}', '{$noBukti}', \n\t\t\t\t\t\t'{$idSales}', '{$idKaryawan}', '{$nota}');";
     } else {
         $query = "INSERT INTO `penjualan` VALUES('{$id}', '{$tgl}', '{$idKonsumen}', '{$idBarang}', '{$jmlTabung}', '{$hargaJual}', \n\t\t\t\t\t\t'{$het}', '{$totalJual}', '{$totalHet}', '{$totalBayar}', '{$jenis}', '{$tglTempo}', '{$idBank}', '{$noBukti}', \n\t\t\t\t\t\t'{$idSales}', '{$idKaryawan}', '{$nota}');";
     }
     $query .= "INSERT INTO `penjualan_acc_gudang`(`id_penjualan`) VALUES('{$id}');";
     if ($result = $this->runMultipleQueries($query)) {
         if ($jenis == "2" || $jenis == "3") {
             $bank = new bank();
             $hasilBank = $bank->transaksi_setor($idBank, $noBukti, $tgl, "Penjualan " . $id, $totalJual, $idKaryawan);
         } else {
             $hasilBank = TRUE;
         }
         if ($sparta) {
             $penjualanKhusus = new penjualan_khusus();
             $hasilPenjualanKhusus = $penjualanKhusus->transaksi_penjualan($tgl, $idKonsumen, "2", $jmlTabung, $selisih, $het, $totalJualKhusus, $totalHet, $totalBayarKhusus, $jenis, $tglTempo, "1", $noBukti, $idSales, $idKaryawan, $nota);
         }
         if ($hasilBank) {
             return TRUE;
         } else {
             return FALSE;
         }
     } else {
         return FALSE;
     }
 }