<?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()) {
$NOMBREP = $row_consulta_form['PLANILLADOR'];
echo '<option value="'.$NOMBREP.'">'.$NOMBREP.'</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> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</center>
</form>
</body>
</html>