"; if ($buscar=="false" or !$buscar){ echo "

Filtros

Tipo de Busqueda
Termino a Buscar

"; echo " \n"; exit; } elseif ($buscar == "true") { $terminobusqueda = $_POST['terminobusqueda']; if (isset($_POST['orden'])) { $Orden = $_POST['orden']; } else { $Orden = "Articulo"; } $tipo = $_POST['tipo']; echo "

Resultados de: $terminobusqueda

"; if ($tipo == "dep") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Ubicacion LIKE '%$terminobusqueda%' ORDER BY $Orden"); } elseif ($tipo == "prod") { if (strlen($terminobusqueda) > 4) { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE MATCH(Articulo) AGAINST ('\"%$terminobusqueda%\"' IN BOOLEAN MODE) ORDER BY $Orden"); } else { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Articulo LIKE '%$terminobusqueda%' ORDER BY $Orden"); } } elseif ($tipo == "cant") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Cantidad = '%$terminobusqueda%' ORDER BY $Orden"); } elseif ($tipo == "mix") { if (strlen($terminobusqueda) > 4) { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE MATCH(Articulo, Marca, Modelo) AGAINST ('+\"%$terminobusqueda%\"*' IN BOOLEAN MODE) ORDER BY $Orden"); $row_cnt = mysqli_num_rows($result); if ($row_cnt <= 0) { dumpLog($row_cnt); dumpLog($terminobusqueda); $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Articulo LIKE '%$terminobusqueda%' OR Modelo LIKE '%$terminobusqueda%' OR Marca LIKE '%$terminobusqueda%'ORDER BY $Orden"); } } else { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Articulo LIKE '%$terminobusqueda%' OR Modelo LIKE '%$terminobusqueda%' OR Marca LIKE '%$terminobusqueda%'ORDER BY $Orden"); } } elseif ($tipo == "precio") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Precio LIKE '%$terminobusqueda%' ORDER BY $Orden"); } elseif ($tipo == "codfab") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE CodFab LIKE '%$terminobusqueda%' ORDER BY $Orden"); } elseif ($tipo == "cod") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE Codigo LIKE '%$terminobusqueda%' ORDER BY $Orden"); } elseif ($tipo == "modelo") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE modelo LIKE '%$terminobusqueda%' ORDER BY $Orden"); } elseif ($tipo == "marca") { $result = mysqli_query($conexion, "SELECT * FROM stock WHERE marca LIKE '%$terminobusqueda%' ORDER BY $Orden"); } echo " "; while ($row=mysqli_fetch_row($result)) { $Nombre = $row[1]; if ($row[1] != "" and $row[0] != 0) { echo ""; } } echo "
$row[0] $row[1] - $row[12] $row[13] $row[2] $row[3] $row[5] $row[6] $row[4] $row[7] $row[12] $row[13]


Listado de Stock Menu Principal Nueva Busqueda
"; } if (! $result) { echo "No se han encontrado productos!

Listado de Stock Menu Principal Nueva Busqueda
"; } include "cerrar_conexion.php"; echo ""; ?>