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>
require_once 'include/pedido.class.php'; $db = new phpDB(); $db->connect(); $query1 = ''; if ($_SESSION['user_bd13']->rol == '1') { $query1 = "SELECT * from pedidos WHERE rut = \$1"; $db->exec($query1, array($_SESSION['user_bd13']->rut)); } elseif ($_SESSION['user_bd13']->rol == '0') { $query1 = "SELECT * from pedidos"; $db->exec($query1, array()); } $pedidos = array(); $plato_pedidos = array(array()); $index = 0; do { $rs1 = $db->fobject(); $pedido = new pedido($rs1->id_pedidos, $rs1->rut, $rs1->fecha); $pedidos[$index] = $pedido; $index++; } while ($db->nextRow()); foreach ($pedidos as $key => $value) { $id = $value->getID(); $query2 = "SELECT * from plato_pedidos WHERE id_pedidos = '{$id}'"; $db->exec($query2, array()); $platos = array(array()); $i = 0; do { $rs2 = $db->fobject(); $platos[$i] = array($rs2->id_plato, $rs2->cantidad); $i++; } while ($db->nextRow());
$db = new phpDB(); $db->connect(); $query = "SELECT * FROM plato"; $db->exec($query, array()); $calegorias_arr = array(); $index = 0; ?> <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_plato; ?> </td> </tr> <?php } while ($db->nextRow()); ?> </tbody> </table> </div> <?php $query2 = "SELECT * FROM categoria";
<?php require_once "../include/db.php"; # Permite la comunicación con la bd # Se hace la conexión a la BD # $db = new phpDB(); # La variable $db guarda la referencia a la BD $db->connect(); # Se hacen distintas cosas dependiendo del valor del parámetro "action" # if ($_GET['action'] == 'login') { $query = "SELECT * FROM usuario WHERE rut = \$1 and password = \$2"; $db->exec($query, array(RUT_formatear($_POST['rut']), $_POST['password'])); # Si hay un resultado, el login fue correcto # if ($db->numRows() == 1) { session_start(); $_SESSION['user_bd13'] = $db->fobject(); $db->close(); if ($_SESSION['user_bd13']->rol == '0') { header('Location: ../login_cajero.php'); } else { header('Location: ../index.php'); # Redirecciona a /index.php } } else { header('Location: ../login.php?error=true'); # Redirecciona al login con error } } else { if ($_GET['action'] == 'logout') { $db->close(); session_start();