<?PHP
session_start();
header("Cache-control: private"); // Arregla IE 6
//*******Datos de Conexion Base de Datos************
include("conexion.php");
$FECHA =date("Y-m-d");
?>
<!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>Codigo</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 ; ");
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 ; ");
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 Ubicacion</strong> </center></td>
<td><center><strong>Producto</strong></center></td>
<td><center><strong>Descripcion</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><p><strong>bases</strong></p> </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>