Viewing file: cdp1.php (5.62 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Solicitud de CDP (Certificados de Disponibilidad Presupuestal)</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
textarea {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
background-color: #FFFAD7;
}
-->
</style>
<style type="text/css">
<!--
select {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
background-color: #FFFFFF;
}
-->
</style>
</head>
<body topmargin="0">
<table width="100%" border="0" cellpadding="8">
<tr>
<td width="30%"> </td>
<td width="40%"><img src="cdp.gif" width="600" height="80"></td>
<td width="30%"> </td>
</tr>
<tr>
<td width="30%"> </td>
<td width="40%"><form name="form1" method="post" action="reqcdp2.php">
<table width="100%" border="0" cellpadding="4" bgcolor="#E6F2FF">
<tr><?php
require('conexion2.php');
$stmt = ociparse($c1,"SELECT DEPENDENCIA
FROM SIA_CONTACTO
WHERE USUARIO = '$user'");
$result = OCIExecute($stmt);
while (OCIFetchInto($stmt, $value)) {
$dep = $value[0];
}
?>
<td width="55%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Dependencia:</strong>
<?php echo $dep; ?>
<input name="dep" type="hidden" id="user2" value="<?php echo $dep; ?>">
</font></td>
<td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Usuario:</strong>
<?php echo $user; ?>
<input name="user" type="hidden" id="user" value="<?php echo $user; ?>">
</font></td>
</tr>
<tr>
<td colspan="3" bgcolor="#F4F4F4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>1.
Datos Básicos del CDP</strong></font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Objeto:</font></td>
<td width="15%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Vigencia:
</font></td>
<td width="30%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<select name="vigencia" id="vigencia">
<?php
require('conexion2.php');
require('hoy.php');
$stmt = ociparse($c1,"SELECT ANO, PLAN_PRESUPUESTO_ID
FROM SIA_PLAN_PRESUPUESTO
WHERE ACTIVA = 'S'
ORDER BY ANO");
$result = OCIExecute($stmt);
if ($result == false) {
?>
<option value="0">Sin Datos</option>
<?php
}else{
while (OCIFetchInto($stmt, $value)) {
$ano = $value[0];
$ppid = $value[1];
if ($ano == $year) {
?>
<option value="<?php echo $ano; ?>" selected><?php echo $ano; ?></option>
<?php
}else{
?>
<option value="<?php echo $ano; ?>"><?php echo $ano; ?></option>
<?php
}
}
}
?>
</select>
</font></td>
</tr>
<tr>
<td colspan="3"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<textarea name="objeto" cols="95" rows="4" id="objeto"></textarea>
</font></div></td>
</tr>
<tr>
<td colspan="3"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Actividad:
</strong> </font></td>
</tr>
<tr>
<td colspan="3" bgcolor="#B3D7FF"> <div align="left"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<select name="actividad" id="actividad">
<?php
require('conexion2.php');
$stmt = ociparse($c1,"SELECT CODIGO_DEPENDENCIA
FROM SIA_CONTACTO
WHERE USUARIO = '$user'");
$result = OCIExecute($stmt);
while (OCIFetchInto($stmt, $value)) {
$dep = $value[0];
}
//////////////////////////////////////////////////////////////
$stmt = ociparse($c1,"SELECT PLAN_ACTIVIDADES_ID, NOMBRE
FROM SIA_PLAN_ACTIVIDADES
WHERE CODIGO_DEPENDENCIA = $dep");
$result = OCIExecute($stmt);
if ($result == false) {
?>
<option value="0">Sin Datos</option>
<?php
}else{
while (OCIFetchInto($stmt, $value)) {
$nom = $value[1];
$nom = substr($nom, 0, 115);
$paid = $value[0];
?>
<option value="<?php echo $paid; ?>"><?php echo $nom; ?></option>
<?php
}
}
?>
</select>
</font></div></td>
</tr>
<tr>
<td colspan="3"><div align="center">
<input type="submit" name="Submit" value="Continuar">
</div></td>
</tr>
</table>
</form></td>
<td width="30%"> </td>
</tr>
<tr>
<td width="30%"> </td>
<td width="40%"><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Todos
los Derechos Reservados para el <br>
<font color="#006699">Departamento Técnico Administrativo del Medio
Ambiente, </font><br>
DAMA<br>
<strong>2004 - 2005</strong></font></div></td>
<td width="30%"> </td>
</tr>
</table>
</body>
</html>
|