PHP product::get_product方法代码示例

$date = date("Y-m-d");
$time = date("h:i:sa");
if (isset($num)) {
    $row = $objBuyer->get_buyer($num);
    if ($row == null) {
        $objBuyer->add_buyer($num, $name, 1);
    } else {
        //do discount stuff
    }
    $more = TRUE;
    $i = 0;
    $totalcost = 0;
    while ($more) {
        if (isset($_REQUEST['pcode' . $i]) && $_REQUEST['pcode' . $i] != "") {
            //get selling price of product
            $row = $objProduct->get_product($_REQUEST['pcode' . $i]);
            $sp = $row['selling_price'];
            //add to transaction products
            $objTransp->add_transaction_product($_REQUEST['pcode' . $i], $_REQUEST['quant' . $i], $date, $time, $num, "obed.nsiah");
            //reduce product quantity
            $objProduct->decrease_stock_level($_REQUEST['pcode' . $i], $_REQUEST['quant' . $i]);
            $totalcost += $_REQUEST['quant' . $i] * $sp;
        } else {
            $more = FALSE;
        }
        $i++;
    }
    $objTrans->add_transaction($date, $time, $num, "obed.nsiah", $totalcost);
    if ($totalcost > 500) {
        //send sms about 10% discount;
    }

    $product_id = $_GET['delete'];
    $terminallist->delete_item_list($product_id);
    return 'sucess';
}
// Terminal Add Function
if (isset($_POST['action']) && $_POST['action'] == 'add') {
    $product_qty = $_POST['latestqty'];
    $terminallist->add_item_list($product_qty);
    return 'sucess';
}
// Terminal Switch Function
if (isset($_POST['action']) && $_POST['action'] == 'switch') {
    $id = $_POST['id'];
    unset($_SESSION['terminal_list']);
    $_SESSION['terminal_list'] = $_SESSION['hold_session'][$id];
    unset($_SESSION['hold_session'][$id]);
    $_SESSION['faizan'] = 1;
    return 'sucess';
}
// Get Single Product Detail for Add Product in Warehouse Page
if (isset($_POST['action']) && $_POST['action'] == 'getproductdetail') {
    $getproduct = $_POST['getproduct'];
    header('Content-Type: application/json');
    echo json_encode($product->get_product($getproduct));
}
// Get Single Product Detail for Add Product in Inventory Page
if (isset($_POST['action']) && $_POST['action'] == 'getwarehouseproductdetail') {
    $getproduct = $_POST['getproduct'];
    header('Content-Type: application/json');
    echo json_encode($warehouse->get_products_detail($getproduct));
}

session_start();
if (isset($_GET['selected_pID'])) {
    if (!empty($_GET['selected_pID'])) {
        $products = new product($_GET['selected_pID']);
        $subcategory = new Subcategory($products->scID);
        $data['cID'] = $subcategory->cID;
        $data['pro'] = (array) $products;
        $data = json_encode($data);
        echo $data;
        exit;
    }
}
if (isset($_GET['selected_scID'])) {
    if (!empty($_GET['selected_scID'])) {
        $products = new product();
        $data = $products->get_product($_GET['selected_scID']);
    }
}
if (isset($_POST['edit_ok'])) {
    $isValid = True;
    if (isset($_POST['insert_pName'])) {
        if (empty($_POST['insert_pName'])) {
            $isValid = False;
            $arrErrors[] = 'insert_pName';
        } else {
            $product = new product($_POST['pID']);
            if ($_POST['insert_pName'] != $product->pName) {
                $isExist = $product->isUniqueName($_POST['insert_pName']);
                if ($isExist) {
                    $arrErrors['isUnique'] = 'this product name already exist';
                    $isValid = False;

			<li><a href="inventory.php">Inventory</a></li>
			<li class="active">Add Inventory Products</li>
		</ol>

		<div class="panel panel-info">
		  <div class="panel-heading">
			<h3><?php 
echo isset($_GET['id']) ? 'Update' : 'Add';
?>
 Inventory Products</h3>
		  </div>
		  <div class="panel-body">
			<!-- BEGIN DATA TABLE -->
			<?php 
$product = new product();
$all_product = $product->get_product();
$warehouse = new warehouse();
$all_product_warehouse = $warehouse->get_products();
$inventory = new inventory();
$ID = isset($_GET['id']) ? $_GET['id'] : NULL;
if (isset($_POST['add_inventory'])) {
    // Update old record
    if (isset($ID)) {
        $results = $inventory->inv_update($_POST, $ID);
    } else {
        // Insert new
        $results = $inventory->inv_insert($_POST);
    }
    if ($results) {
        echo '<div class="alert alert-success alert-block fade in alert-dismissable">
				  <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>

<?php

require_once 'header.php';
?>
<section>
	<hr/>
	<div class="container">
		<div class="row">
			<div class="tableHeading">
				<p class="nomargin alignCenter">View Products</p>
			</div>
			<div class="col-md-12">	
				<?php 
$product = new product();
$results = $product->get_product();
if ($results) {
    ?>
				<table border="1" cellpadding="5" cellspacing="0" class="table table-hover tableView">
					<tr>
						<th>Product Name</th>
						<th>Product Supplier</th>
						<th>Product Cost</th>
						<th>Product Price</th>
						<th>Product GST</th>
						<th>Action</th>
					</tr>
						<?php 
    foreach ($results as $res) {
        echo '<tr>';
        echo '<td>' . $res->p_name . '</td>';
        echo '<td>' . $res->p_supplier . '</td>';

function get_product()
{
    include_once 'product.php';
    $barcode = $_GET['barcode'];
    $obj = new product();
    if (!$obj->connect()) {
        $json = '{"status":2, "products":{}, "message":"Failed to connect to the database."}';
        echo $json;
        exit;
    }
    if ($obj->get_product($barcode)) {
        $row = $obj->fetch();
        $json = '{"status": 0, "products":' . json_encode($row) . ', "message": "Found product."}';
        echo $json;
    } else {
        $json = '{"status":1, "products":{}, "message":"Sorry we could not execute that."}';
        echo $json;
    }
}