Пример #1
0
        ?>
            </td>
            <?php 
        echo "</tr>";
    }
    echo "</table>";
}
if (session_status() == PHP_SESSION_NONE) {
    session_start();
}
require_once "../config.php";
require_once ROOT_PATH . "/opendb.php";
require_once ROOT_PATH . TEMPLATES_PATH . "/header.php";
require_once "crud.php";
require_once "show.php";
require_once "../permissions.php";
if (Can_Do_Inventory() && isset($_POST['list_delete_btn'])) {
    $key = $_POST['inventorynum'];
    $key_array = array('inventorynum' => $_POST['inventorynum']);
    RowDelete($database, 'inventory_items', $key_array);
}
if (isset($_POST['create_btn'])) {
    unset($_POST['create_btn']);
    RowCreate($database, 'inventory_items', $_POST);
}
if (Can_Do_Inventory()) {
    $result = TableRetrieve($database, "inventory_items");
    MemberTableShow($result);
} else {
    echo "Insufficient permissions.";
}
Пример #2
0
<?php 
if (isset($_POST['submit'])) {
    $tid = getNextID($database, 'transaction', 'transactionid') + 2;
    $quantity = $_POST['quantityDrop'];
    $transDate = date("20y-m-d");
    $inventoryNum = 0;
    // get inventory num from $resultItem
    foreach ($resultItem as $row => $value) {
        if ($itemValue == $value["name"]) {
            $inventoryNum = $value["inventorynum"];
        }
    }
    $membId = 0;
    $total = $price * $quantity;
    //echo $memberValue." itemNum=" . $inventoryNum . " itemvalue = ".$itemValue." tid = ".$tid." total = ".$total;
    $namesArr = preg_split("/[\\s,]+/", $memberValue);
    $firstName = $namesArr[0];
    $lastName = $namesArr[1];
    $query = "SELECT memberid FROM member WHERE firstname = '" . $firstName . "' AND lastname = '" . $lastName . "'";
    $membId = mysqli_query($database, $query) or die(mysqli_error($database));
    $rez = mysqli_fetch_assoc($membId);
    $membId = $rez['memberid'];
    //echo "    memberid = " . $membId;
    $value_array = array('transactionid' => $tid, 'date' => $transDate, 'memberid' => $membId, 'inventorynum' => $inventoryNum, 'amount' => $quantity, 'totals' => $total, 'cashierid' => $_SESSION['memberid']);
    RowCreate($database, "transaction", $value_array);
    header("Location: transactionList.php");
}
//}
?>

Пример #3
0
<?php

if (session_status() == PHP_SESSION_NONE) {
    session_start();
}
require_once "../config.php";
require_once ROOT_PATH . "/opendb.php";
require_once ROOT_PATH . TEMPLATES_PATH . "/header.php";
require_once "crud.php";
require_once "../permissions.php";
if (isset($_POST['create_btn'])) {
    unset($_POST['create_btn']);
    RowCreate($database, 'member', $_POST);
}
if (Can_Create_Members()) {
    $currDate = date("20y-m-d");
    ?>
        <form method="post" action="<?php 
    $_PHP_SELF;
    ?>
" >
         <table border='0' >
             <tr>
                 <td>
                     <b>Member ID:</b>
                 </td>
                 <td>
                     <input type='text' name='memberid' value="<?php 
    echo isset($_POST['memberid']) ? $_POST['memberid'] : '';
    ?>
">