/neaticketwebapp/lib/form3tickets.php

<?php



$clase = new connect;

$clase->dbConnects();



/* capturar variable por método GET */

if (isset($_GET['pos']))

  $ini=$_GET['pos'];

else

  $ini=1; 



$url = basename($_SERVER ["PHP_SELF"]);

$limit_end = 15;

$init = ($ini-1) * $limit_end;



?>





    <div class="container">

    <!-- <h2>Lista de usuarios</h2> -->



        <div class="jumbotron">

            <h1>Buscador de <strong>Tickets</strong></h1>



        <!-- Table -->

        <div class="table-responsive">

            <table class="table">



                <?php

                $funcion = $campo = $valor = "";

                

                $mail_tienda = $_SESSION['email'];

                //$cif_empresa = $_SESSION['cif_empresa'];

                $nombre_marca = $_SESSION['nombre_marca'];

                

                if(isset($_GET['mailCliente'])){

                    $funcion = '';

                    $campo = 'mailCliente';

                    $valor = $_GET['mailCliente'];

                    $volver = "index_usersNew.php";



                    //$result = mysql_query("SELECT * FROM TICKETS WHERE cliente = '$email' AND mail_tienda = '$mail_tienda' ORDER BY fecha DESC, hora DESC");    

                    //$result = mysql_query("SELECT * FROM TICKETS WHERE cliente = '$email' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE cif_empresa = '$cif_empresa') ORDER BY fecha DESC, hora DESC"); 

                    $sql = "SELECT * FROM TICKETS WHERE cliente = '$valor' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ORDER BY fecha DESC, hora DESC"; 

                    $count = "SELECT COUNT(*) FROM TICKETS WHERE cliente = '$valor' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ORDER BY fecha DESC, hora DESC";                  

                }

                            

                if(isset($_GET['BuscarCliente'])){

                    $funcion = 'BuscarCliente';

                    $campo = 'emailCliente';

                    $valor = $_GET['emailCliente'];

                    $volver = "index2TicketsEmp.php";



                    //$result = mysql_query("SELECT * FROM TICKETS WHERE cliente = '$email' AND mail_tienda = '$mail_tienda' ORDER BY fecha DESC, hora DESC");

                    $sql = "SELECT * FROM TICKETS WHERE cliente LIKE '$valor%' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ORDER BY fecha DESC, hora DESC"; 

                    $count = "SELECT COUNT(*) FROM TICKETS WHERE cliente LIKE '$valor%' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ORDER BY fecha DESC, hora DESC"; 



                }

                if(isset($_GET['BuscarTicket'])){



                    $funcion = 'BuscarTicket';

                    $campo = 'num_ticket';

                    $valor = $_GET['num_ticket'];

                    $volver = "index2TicketsEmp.php";



                    //$result = mysql_query("SELECT * FROM TICKETS WHERE num_ticket = '$ticket' AND mail_tienda = '$mail_tienda' ");

                    //$result = mysql_query("SELECT * FROM TICKETS WHERE num_ticket = '$ticket' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE cif_empresa = '$cif_empresa') ");

                    $sql = "SELECT * FROM TICKETS WHERE num_ticket = '$valor' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ";

                    $count = "SELECT COUNT(*) FROM TICKETS WHERE num_ticket = '$valor' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ";



                }

                if(isset($_GET['BuscarFecha'])){



                    $funcion = 'BuscarFecha';

                    $campo = 'fecha_ticket';

                    $valor = $_GET['fecha_ticket'];

                    $volver = "index2TicketsEmp.php";



                    //$result = mysql_query("SELECT * FROM TICKETS WHERE fecha = '$fecha' AND mail_tienda = '$mail_tienda' ORDER BY fecha DESC, hora DESC");

                    //$result = mysql_query("SELECT * FROM TICKETS WHERE fecha = '$fecha' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE cif_empresa = '$cif_empresa') ORDER BY fecha DESC, hora DESC");

                    $sql = "SELECT * FROM TICKETS WHERE fecha = '$valor' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ORDER BY fecha DESC, hora DESC";

                    $count = "SELECT COUNT(*) FROM TICKETS WHERE fecha = '$valor' AND mail_tienda IN (SELECT mail FROM TIENDAS WHERE nombre_marca = '$nombre_marca') ORDER BY fecha DESC, hora DESC";



                }

                    

                $sql .= " LIMIT $init, $limit_end";

                $result = mysql_query($sql);

                

                if ($row = mysql_fetch_array($result)){



                    $num = $con->query($count);

                    $x = $num->fetch_array();

                    $total = ceil($x[0]/$limit_end);

                    

                    echo "<thead><tr>

                            <td><strong>TICKET</strong></td>

                            <td><strong>CLIENTE</strong></td>                                                                                                                                       

                            <td><strong>FECHA</strong></td>

                            <td><strong>HORA</strong></td>

                            <td><strong>TIENDA</strong></td>   

                            <td><strong>CAJA</strong></td>

                            <td><strong>CAJERO</strong></td>

                            <td><strong>PVP</strong></td>

                            <td><strong>ESTADO</strong></td>

                            <td></td>

                            </tr></thead>";

                    do {

                        $date = date("d/m/Y", strtotime($row['fecha']));

                        //mostramos solo con el nombre en el mail de la tienda

                        $caracter   = '@';

                        $posicion = strpos($row['mail_tienda'], $caracter);

                        $nom_tienda = substr($row['mail_tienda'], 0, $posicion);



                        echo '<tr><td>'.$row['num_ticket'].'</td>';

                        echo '<td>'.$row['cliente'].'</td>';

                        echo '<td>'.$date.'</td>';

                        echo '<td>'.$row['hora'].'</td>';

                        echo '<td>'.$nom_tienda.'</td>';                        

                        echo '<td>'.$row['caja'].'</td>';

                        echo '<td>'.$row['cajero'].'</td>';

                        echo '<td>'.$row['total'].'</td>';

                        echo '<td>'.$row['estado'].'</td>';

                        

                        if ($row['fichero'] != "")

                            echo '<td><a href="'.$row['fichero'].'" target="blank" class="typcn typcn-zoom-in"></a></td></tr>';

                        else

                            echo '<td><a href="ticketPdf_ok_1.php?id='.$row['id'].'&tipo=2" target="blank" class="typcn typcn-zoom-in"></a></td></tr>';                



                    } while ($row = mysql_fetch_array($result));



                } else {

                    echo "¡ No se ha encontrado ningún registro !";

                    

                }



                ?>

            </table>

            <div class="row">

                <div class="col-md-8"></div>

                <div class="col-md-4">



                <?php

                if ($total > 1){

                    /* numeración de registros [importante]*/

                    echo '<ul class="pagination">';

                    /****************************************/

                    if(($ini - 1) == 0){

                      echo "<li><a href='#'>&laquo;</a></li>";

                    }else{

                      echo "<li><a href='$url?pos=".($ini-1)."&$campo=$valor&$funcion'><b>&laquo;</b></a></li>";  

                    }

                    /****************************************/

                    $fin = $ini +4;

                    if($fin >= $total)

                        $fin = $total;

                    

                    for($k= $ini; $k <= $fin; $k++){

                      if($ini == $k){

                        echo "<li class='active'><a href='#'><b>".$k."</b></a></li>";

                      }else{

                        echo "<li><a href='$url?pos=$k&$campo=$valor&$funcion'>".$k."</a></li>";

                      }

                    }

                    /****************************************/

                    if($ini == $total){

                      echo "<li><a href='#'>&raquo;</a></li>";

                    }else{

                      echo "<li><a href='$url?pos=".($ini+1)."&$campo=$valor&$funcion='><b>&raquo;</b></a></li>";

                    }

                    /*******************END*******************/

                    echo "</ul>";

                }

                ?>

                </div>

            </div>

        </div>



                <!-- <input class='btn2 btn btn-default btn-success' type='submit' value='Actualizar' name='B2'> -->

                <div class="form-group"><br>

                    <a href="<?php echo $volver; ?>"><button name="boton2" id="boton2" type="button" class="btn">

                    <span class="typcn typcn-arrow-left"></span> Volver</button></a>

                </div>



        </div>

    </div>