function load()
{
$id_plat_cat = array();
$platos_cat = array();
$platos_obj = array();
$platos_obj_r = array();
$platos_rango = array();
$i = 0;
$j = 0;
$k = 0;
if (!isset($_POST) || !isset($_SESSION['user_bd13']) || $_SESSION['user_bd13']->rol != 1) {
header('Location: ../login.php');
exit;
} else {
$db = new phpDB();
$db->connect();
if (isset($_POST['filtro_busqueda_categ'])) {
$categoria = $_POST['categoria'];
$query = "SELECT * FROM categoria WHERE nombre_categoria LIKE '%{$categoria}%'";
$db->exec($query, array());
$rs1 = $db->fobject();
if (is_null($rs1)) {
echo '<div class="alert alert-info"> No hay resultados para la búsqueda</div>';
return;
} else {
do {
$id_plat_cat[$i] = $rs1->id_categoria;
$i++;
} while ($db->nextRow());
foreach ($id_plat_cat as $key => $value) {
$query2 = "SELECT * FROM plato WHERE id_categoria = '{$value}'";
$db->exec($query2, array());
do {
$rs2 = $db->fobject();
$platos_cat[$k] = $rs2->nombre_plato;
$platos_obj[$k] = $rs2;
$k++;
} while ($db->nextRow());
}
}
}
if (isset($_POST['filtro_busqueda_rango'])) {
$rango_start = $_POST['start'];
$rango_end = $_POST['end'];
if ($rango_start > $rango_end || $rango_start == 0 && $rango_end == 0) {
echo '<div class="alert alert-danger"> Se ingreso mal los rangos de búsqueda</div>';
return;
}
$query3 = "SELECT * FROM plato WHERE precio BETWEEN {$rango_start} AND {$rango_end}";
$db->exec($query3, array());
do {
$rs3 = $db->fobject();
$platos_rango[$j] = $rs3->nombre_plato;
$platos_obj_r[$j] = $rs3;
$j++;
} while ($db->nextRow());
}
if (isset($_POST['filtro_busqueda_categ']) && isset($_POST['filtro_busqueda_rango'])) {
$result = array();
$indice = 0;
foreach ($platos_obj as $key => $value) {
foreach ($platos_obj_r as $key2 => $value2) {
if ($value->id_plato == $value2->id_plato) {
$result[$indice] = $value;
$indice++;
}
}
}
//$result = array_intersect($platos_obj, $platos_obj_r);
?>
<div class="well table-responsive">
<table class="table table-hover">
<thead>
<tr>
<th>Nombre</th>
<th>Precio</th>
<th>Cantidad</th>
</tr>
</thead>
<tbody>
<?php
foreach ($result as $key => $pl) {
?>
<tr>
<td>
<button class="btn btn-link" data-toggle="modal" data-target="#myModal<?php
echo $pl->id_plato;
?>
">
<?php
echo $pl->nombre_plato;
?>
</button>
<?php
include 'modal_busqueda.php';
?>
</td>
<td> $
<?php
echo $pl->precio . "<br>";
?>
</td>
<td>
<form method="post" id ="cant<?php
echo $pl->id_plato;
?>
" action="handlers/add_carrito_handler.php?idprod=<?php
echo $pl->id_plato;
?>
&nombre=<?php
echo $pl->nombre_plato;
?>
&precio=<?php
echo $pl->precio;
?>
&dir=carta.php&descrip=<?php
echo str_replace(' ', '+', $pl->descripcion);
?>
">
<input type = "number" min = "1" max = "20" step = "1" value = "1" size = "3" name="cantidad">
<button type="submit" class="btn btn-success btn-xs">Agregar</button>
</form>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
} else {
if (!empty($platos_cat)) {
?>
<div class="well table-responsive">
<table class="table table-hover">
<thead>
<tr>
<th>Nombre</th>
<th>Precio</th>
<th>Cantidad</th>
</tr>
</thead>
<tbody>
<?php
foreach ($platos_cat as $key => $pl) {
?>
<tr>
<td>
<button class="btn btn-link" data-toggle="modal" data-target="#myModal<?php
echo $platos_obj[$key]->id_plato;
?>
">
<?php
echo $platos_obj[$key]->nombre_plato;
?>
</button>
<?php
include 'descripcionModal.php';
?>
</td>
<td> $
<?php
echo $platos_obj[$key]->precio . "<br>";
?>
</td>
<td>
<form method="post" id ="cant<?php
echo $platos_obj[$key]->id_plato;
?>
" action="handlers/add_carrito_handler.php?idprod=<?php
echo $platos_obj[$key]->id_plato;
?>
&nombre=<?php
echo $platos_obj[$key]->nombre_plato;
?>
&precio=<?php
echo $platos_obj[$key]->precio;
?>
&dir=carta.php&descrip=<?php
echo str_replace(' ', '+', $platos_obj[$key]->descripcion);
?>
">
<input type = "number" min = "1" max = "20" step = "1" value = "1" size = "3" name="cantidad">
<button type="submit" class="btn btn-success btn-xs">Agregar</button>
</form>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
} elseif (!empty($platos_rango)) {
?>
<div class="well table-responsive">
<table class="table table-hover">
<thead>
<tr>
<th>Nombre</th>
<th>Precio</th>
<th>Cantidad</th>
</tr>
</thead>
<tbody>
<?php
foreach ($platos_rango as $key => $pl) {
?>
<tr>
<td>
<button class="btn btn-link" data-toggle="modal" data-target="#myModal<?php
echo $platos_obj_r[$key]->id_plato;
?>
">
<?php
echo $platos_obj_r[$key]->nombre_plato;
?>
</button>
<?php
include 'descripcionModal.php';
?>
</td>
<td> $
<?php
echo $platos_obj_r[$key]->precio . "<br>";
?>
</td>
<td>
<form method="post" id ="cant<?php
echo $platos_obj_r[$key]->id_plato;
?>
" action="handlers/add_carrito_handler.php?idprod=<?php
echo $platos_obj_r[$key]->id_plato;
?>
&nombre=<?php
echo $platos_obj_r[$key]->nombre_plato;
?>
&precio=<?php
echo $platos_obj_r[$key]->precio;
?>
&dir=carta.php&descrip=<?php
echo str_replace(' ', '+', $platos_obj_r[$key]->descripcion);
?>
">
<input type = "number" min = "1" max = "20" step = "1" value = "1" size = "3" name="cantidad">
<button type="submit" class="btn btn-success btn-xs">Agregar</button>
</form>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
} else {
echo '<div class="alert alert-info"> Marque una opción de búsqueda para iniciar el proceso</div>';
}
}
}
}
<?php
$db = new phpDB();
$db->connect();
$query = "SELECT * FROM categoria";
$db->exec($query, array());
?>
<div class="table-responsive">
<table class="table table-hover table-bordered">
<tbody>
<?php
do {
$rs = $db->fobject();
?>
<tr>
<td class="capitalize"><?php
echo $rs->nombre_categoria;
?>
</td>
</tr>
<?php
} while ($db->nextRow());
?>
</tbody>
</table>
</div>
