session_start();
include "..//index.php";
$ActiveUser = $_SESSION['user'];
if ($_SESSION["password"] != "alm") {
header("Location: ..//index.php");
exit();
}
$order = $_GET['order'];
include "conexion.php";
if ($order == "ID")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY ID DESC");
}
elseif ($order == "nombre")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY Articulo ASC");
}
elseif ($order == "marca")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY marca ASC");
}
elseif ($order == "modelo")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY modelo ASC");
}
elseif ($order == "cant")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY Cantidad ASC");
}
elseif ($order == "dep")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY Ubicacion ASC");
}
elseif ($order == "precio")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY Precio ASC");
}
elseif ($order == "prov")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY Proveedor ASC");
}
elseif ($order == "cod")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY Codigo ASC");
}
elseif ($order == "codfab")
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY CodFab ASC");
}
else
{
$result=mysqli_query($conexion, "SELECT * FROM stock ORDER BY ID DESC");
}
echo"