Пример #1
0
                    updatePedido($decoded->pedido);
                } else {
                    if ($decoded->function == 'updatePedidoDetalle') {
                        updatePedidoDetalle($decoded->pedido_detalle);
                    } else {
                        if ($decoded->function == 'updateStock') {
                            updateStock($decoded->stock);
                        } else {
                            if ($decoded->function == 'removePedido') {
                                removePedido($decoded->pedido_id);
                            } else {
                                if ($decoded->function == 'removePedidoDetalle') {
                                    removePedidoDetalle($decoded->pedido_detalle_id);
                                } else {
                                    if ($decoded->function == 'removeStock') {
                                        removeStock($decoded->stock_id);
                                    } else {
                                        if ($decoded->function == 'trasladar') {
                                            trasladar($decoded->origen_id, $decoded->destino_id, $decoded->producto_id, $decoded->cantidad);
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
} else {
    $function = $_GET["function"];
Пример #2
0
<?php

/**
 * Created by PhpStorm.
 * User: Buddhi
 * Date: 12/28/2015
 * Time: 4:59 PM
 */
if (file_exists('../mysql_connector.php')) {
    include '../mysql_connector.php';
}
if (isset($_POST['remove'])) {
    removeStock($_POST['stockId']);
    header('Location: http://localhost/PharmacyDB/adminpanel.php?option=4');
}
function removeStock($stockId)
{
    $link = getConnection();
    $sql = "DELETE FROM fstock WHERE StockId='" . $stockId . "'";
    $resultset = mysqli_query($link, $sql);
    mysqli_close($link);
    return $resultset;
}
function isItemInStock($medicineid)
{
    $link = getConnection();
    $sql = "SELECT Quantity FROM fstock WHERE MedicineId = '" . $medicineid . "'";
    $totalQuantity = 0;
    $resultset = mysqli_query($link, $sql);
    $quantity = "OUT OF STOCK";
    if ($resultset != null) {