PHP pembelian Examples

Example #1

File: pembelian.php Project: rifkyzulfikarf/en-sgj

<?php

if (isset($_POST['apa']) && $_POST['apa'] != "") {
    include 'modules/model/class.pembelian.php';
    $pembelian = new pembelian();
    switch ($_POST['apa']) {
        case "get-barang":
            include 'modules/model/class.barang.php';
            $barang = new barang();
            if ($query = $barang->get_barang()) {
                while ($rs = $query->fetch_array()) {
                    echo "<option value='" . $rs['id'] . "' data-harga='" . $rs['harga_beli'] . "'>" . $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-spbe":
            include 'modules/model/class.spbe.php';
            $spbe = new spbe();
            if ($query = $spbe->get_spbe_barang_by_barang($_POST['barang'])) {
                while ($rs = $query->fetch_array()) {
                    echo "<option value='" . $rs['id'] . "' data-ship='" . $rs['ship_to'] . "' data-sold='" . $rs['sold_to'] . "'>" . $rs['nama_spbe'] . "</option>";
                }
            }

Example #2

File: hapus_pembelian.php Project: rifkyzulfikarf/en-sgj

<?php

if (isset($_POST['apa']) && $_POST['apa'] != "") {
    include 'modules/model/class.pembelian.php';
    $pembelian = new pembelian();
    switch ($_POST['apa']) {
        case "get-request":
            $collect = array();
            if ($query = $pembelian->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` = '2' \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-tebus":
            $collect = array();
            if (isset($_POST['id']) && $_POST['id'] != "") {
                if ($query = $pembelian->get_pembelian_by_id($_POST['id'])) {
                    while ($rs = $query->fetch_array()) {
                        $detail = array();
                        array_push($detail, $rs["tgl_tebus"]);
                        array_push($detail, $rs["no_lo"]);
                        array_push($detail, $rs["no_sa"]);