File "Registros.php"

Full Path: C:/wamp64/www/INVENTALMACEN/Registros.php
File size: 5.71 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?PHP
session_start();
header("Cache-control: private"); // Arregla IE 6

//*******Datos de Conexion Base de Datos************
include("conexion.php");
$FECHA = date("Y-m-d");
$doc = $_SESSION['dcto'];


 
// Set character set to UTF-8
$conexion->set_charset("utf8");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>RegistrosInventarios</title>
</head>

<body>
<form class="form-horizontal" method="post">
<center>
  <p><strong>Control de Registros Inventario General AVICAMPO PEREIRA</strong></p>
  <p>Parametros de Consulta</p>
  <table width="536" border="1" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
    <tr>
      <td height="140">
        <table width="271" border="0" cellspacing="0">
          <tr>
            <td width="140" height="34"><strong>Consecutivo </strong></td>
            <td width="121">
              <label for="CON"><strong>
                <select name="CON" id="CON">
                  <?PHP
                  $tabla = $conexion->query("SELECT * FROM documento;");
                  while ($row_consulta_form = $tabla->fetch_array()) {
                    $NOMBREP = $row_consulta_form['dcto'];
                    echo '<option value="'.$NOMBREP.'">'.$NOMBREP.'</option>';
                  }
                  ?>
                </select>
              </strong></label>
            </td>
          </tr>
        </table>
        <table width="271" border="0" cellspacing="0">
          <tr>
            <td width="133" height="35"><strong>Ubicación</strong></td>
            <td width="128">
              <label for="CON4"></label>
              <select name="CON4" id="CON4">
                <option>Todas</option>
                <?PHP
                $tabla = $conexion->query("SELECT * FROM ubicacion ;");
                while ($row_consulta_form = $tabla->fetch_array()) {
                  $ubi = $row_consulta_form['ubicacion'];
                  echo '<option value="'.$ubi.'">'.$ubi.'</option>';
                }
                ?>
              </select>
            </td>
          </tr>
        </table>
        <table width="271" border="0" cellspacing="0">
          <tr>
            <td width="137" height="34"><strong>Código</strong></td>
            <td width="124">
              <label for="CON5"></label>
              <select name="CON5" id="CON5">
                <option>Todos</option>
                <?PHP
                $tabla = $conexion->query("SELECT DISTINCT CODPROD, NPROD FROM mvdcto WHERE TPDCTO='$doc';");
                while ($row_consulta_form = $tabla->fetch_array()) {
                  $NOMBREP = $row_consulta_form['CODPROD'];
                  $DESCRIPCION = $row_consulta_form['NPROD'];
                  echo '<option value="'.$NOMBREP.'">'.$NOMBREP."-".$DESCRIPCION.'</option>';
                }
                ?>
              </select>
            </td>
          </tr>
        </table>
        <table width="271" border="0" cellspacing="0">
          <tr>
            <td width="141" height="33"><strong>Planillador</strong></td>
            <td width="120">
              <label for="CON6"></label>
              <select name="CON6" id="CON6">
                <option>Todos</option>
                <?PHP
                $tabla = $conexion->query("SELECT DISTINCT PLANILLADOR FROM mvdcto WHERE TPDCTO='$doc';");
                while ($row_consulta_form = $tabla->fetch_array()) {
                  $NOMBREP = $row_consulta_form['PLANILLADOR'];
                  echo '<option value="'.$NOMBREP.'">'.$NOMBREP.'</option>';
                }
                ?>
              </select>
            </td>
          </tr>
        </table>
		        <table width="271" border="0" cellspacing="0">
          <tr>
            <td width="141" height="33"><strong>Usuario</strong></td>
            <td width="120">
              <label for="CON6"></label>
              <select name="CON6" id="CON6">
                <option>Todos</option>
                <?PHP
                $tabla = $conexion->query("SELECT DISTINCT USUARIO FROM mvdcto WHERE TPDCTO='$doc';");
                while ($row_consulta_form = $tabla->fetch_array()) {
                  $USERT = $row_consulta_form['USUARIO'];
                  echo '<option value="'.$USERT.'">'.$USERT.'</option>';
                }
                ?>
              </select>
            </td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
  <p>
    <input type="submit" name="enviar" id="enviar" value="***CONSULTAR INFORMACIÓN***" formmethod="post" formaction="Registros11.php" />
  </p>
  <table width="848" border="1" cellpadding="0" cellspacing="0">
    <tr bgcolor="#CCCCCC">
      <td><center><strong>Cod Ubicación</strong></center></td>
      <td><center><strong>Producto</strong></center></td>
      <td><center><strong>Descripción</strong></center></td>
      <td><center><strong>Kilos</strong></center></td>
      <td><center><strong>Unids</strong></center></td>
      <td><center><strong>Canastas</strong></center></td>
      <td><center><strong>Cajas</strong></center></td>
      <td><center><strong>Bultos</strong></center></td>
      <td><center><strong>Bases</strong></center></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</center>
</form>
</body>
</html>