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 stockpapelera ORDER BY ID DESC"); } elseif ($order == "nombre") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY Articulo ASC"); } elseif ($order == "marca") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY marca ASC"); } elseif ($order == "modelo") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY modelo ASC"); } elseif ($order == "cant") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY Cantidad ASC"); } elseif ($order == "dep") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY Ubicacion ASC"); } elseif ($order == "precio") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY Precio ASC"); } elseif ($order == "prov") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY Proveedor ASC"); } elseif ($order == "cod") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY Codigo ASC"); } elseif ($order == "codfab") { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY CodFab ASC"); } else { $result=mysqli_query($conexion, "SELECT * FROM stockpapelera ORDER BY ID DESC"); } echo"
| ID | Articulo | Marca | Modelo | Cantidad | Deposito | Precio | Proveedor | COD | COD Fabrica | "; while($row=mysqli_fetch_row($result)){ $rows[0] = $row[0]; $rows[1] = $row[1]; $rows[2] = $row[2]; $rows[3] = $row[3]; $rows[4] = $row[4]; $rows[5] = $row[5]; $rows[6] = $row[6]; $rows[7] = $row[7]; $Nombre = $rows[1]." ".$row[12]." ".$row[13]; if ((int)$rows[2] > 0) { $color = 'lightgreen'; } elseif ((int)$rows[2] == 0) { $color = 'darksalmon'; }//||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| "; } echo " | $rows[0] | $rows[1] | $row[12] | $row[13] | $rows[2] | $rows[3] | $rows[5] | $rows[6] | $rows[4] | $rows[7] | ![]() |
";
if ($_SESSION['level'] == "Admin")
{
echo "![]() | ";
}
echo "