<html>
<head>
<title>Ingreso Solicitud</title>
<script LANGUAGE="JavaScript">
function ir(sitio)
{
document.location.href = sitio.options[sitio.selectedingreso_db].value
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.Estilo1 {color: #00CCFF}
-->
</style>
</head>
<body bgcolor="#14285f">
<body>
<p>
</p>
<?php include("formato.php"); ?>
<?php CabeceraPagina(); ?>
<h3 align="center" class="Estilo1"> INGRESO DE SOLICITUDES </h3>
<FORM ACTION="muestrafolio.php" method="get">
<TABLE>
<TR>
<TD width="129">NOMBRE SOLICITANTE: </TD>
<TD width="428"><INPUT NAME="nombre" TYPE="text" id="nombre" tabindex="1" SIZE="50" MAXLENGTH="100"></TD>
</TR>
<TR>
<TD>AREA:</TD>
<TD><?php
$link = mysql_connect("localhost", "root", "");
mysql_select_db("db_soporte", $link);
echo "<select name='area' id='area' onChange='ir(this.form.area)'>";
echo "<option>Seleccione Area</option>";
$result=mysql_query("SELECT * FROM tbl_area", $link)or die (mysql_error());
while ($row=mysql_fetch_array($result)) {
$idarea = $row["id_area"];
$desarea = $row["des_area"];
echo "<option value=\"$idearea\">$desarea</option>";
}
echo "</select>";
?>
</TD>
</TR>
<TR>
<TD>DIRECCION: </TD>
<TD><?php
echo "<select name='direccion' id='direccion'>";
echo "<option>Selecione Direccion</option>";
$idearea = $_REQUEST["variable"];
$results=mysql_query("SELECT * FROM tbl_direcciones WHERE id_area2 = '$idearea'", $link)or die (mysql_error());
while ($row=mysql_fetch_array($results)) {
$direccion= $row["des_direccion"];
$iddireccion = $row["id_direccion"];
echo "<option value=\"$iddireccion\">$direccion</option>";
}
echo "</select>";
?></TD>
</TR>
<TR>
<TD>UNIDAD / DEPTO. </TD>
<TD><?php
$link=mysql_connect("localhost","root", "");
$link1=mysql_select_db("db_soporte",$link);
$result=mysql_query("select * from tbl_unidades ORDER BY `id_unidad` ASC ");
echo '<select name="unidad"tabindex="4">';
//Generamos el menu desplegable
while ($row=mysql_fetch_array($result))
{echo '<option>'.$row["des_unidad"];}
echo "</select>";
mysql_free_result($result);
?></TD>
</TR>
<TR>
<TD>EDIFICIO</TD>
<TD>
<?php
$link=mysql_connect("localhost","root", "");
$link1=mysql_select_db("db_soporte",$link);
$result=mysql_query("select * from tbl_edificio ORDER BY `id_edificio` ASC ");
echo '<select name="edificio" tabindex="5">';
//Generamos el menu desplegable
while ($row=mysql_fetch_array($result))
{echo '<option>'.$row["des_edificio"];}
echo "</select>";
mysql_free_result($result);
?></TD>
</TR>
<TR>
<TD>PISO:</TD>
<TD><?php
$link=mysql_connect("localhost","root", "");
$link1=mysql_select_db("db_soporte",$link);
$result=mysql_query("select * from tbl_pisos ORDER BY `id_piso` ASC ");
echo '<select name="piso" tabindex="6">';
//Generamos el menu desplegable
while ($row=mysql_fetch_array($result))
{echo '<option>'.$row["des_piso"];}
echo "</select>";
mysql_free_result($result);
?></TD>
</TR>
<TR>
<TD>CORREO ELECTRONICO: </TD>
<TD><input name="correo" type="text" id="correo" tabindex="7" size="20" maxlength="30"></TD>
</TR>
<TR>
<TD>TIPO REQUERIMIENTO :</TD>
<TD><?php
$link=mysql_connect("localhost","root", "");
$link1=mysql_select_db("db_soporte",$link);
$result=mysql_query("select * from tbl_fallas ORDER BY `id_falla` ASC ");
echo '<select name="requerimiento" tabindex="8">';
//Generamos el menu desplegable
while ($row=mysql_fetch_array($result))
{echo '<option>'.$row["desc_falla"];}
echo "</select>";
mysql_free_result($result);
?></TD>
</TR>
<TR>
<TD>FONO / ANEXO : </TD>
<TD><input name="fono" type="text" id="fono" tabindex="9" size="10" maxlength="10"></TD>
</TR>
<TR>
<TD>FECHA SOLICITUD : </TD>
<TD><input name="fecha" type="text" id="fecha" tabindex="10" value="<?php echo date("d/m/Y")?>" readonly="true"></TD>
</TR>
<TR>
<TD>HORA SOLICITUD :</TD>
<TD><input name="hora" type="text" id="hora" tabindex="11" value="<?php echo date("H:i:s")?>" readonly="true"></TD>
</TR>
</TABLE>
<input type="submit" name="save" value="Grabar">
</FORM>
<?php PiePagina(); ?>
</body>
</html>