Viewing file: cdp.php (15.1 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
$user="FELGAR";
?>
<!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="">
<table width="100%" border="0" cellpadding="4" bgcolor="#E6F2FF">
<tr>
<td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Dependencia:</strong>
Oficina de Planeación</font></td>
<td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Usuario:</strong>
<?php echo $user; ?></font></td>
</tr>
<tr>
<td colspan="4" bgcolor="#F4F4F4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>1.
Datos Básicos del CDP</strong></font></td>
</tr>
<tr>
<td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Objeto:</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Vigencia:
</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<select name="vigencia" id="vigencia">
<?php
require('conexion2.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];
?>
<option value="<?php echo $ppid; ?>"><?php echo $ano; ?></option>
<?php
}
}
?>
</select>
</font></td>
</tr>
<tr>
<td colspan="4"><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><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Valor:
</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="saldo" type="text" id="saldo" size="20">
</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Valor
de la Vigencia: </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield22" type="text" size="20">
</font></td>
</tr>
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Saldo:</font></td>
<td colspan="3"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield24" type="text" size="20">
</font></td>
</tr>
<tr>
<td colspan="4"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Actividad:
</strong> </font></td>
</tr>
<tr>
<td colspan="4" 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><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Documento:
</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="textfield4">
</font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Dependencia
<br>
del CDP: </font></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select3">
</select>
</font></td>
</tr>
<tr>
<td width="19%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Duración:
</font></td>
<td width="36%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="textfield5">
</font></td>
<td width="15%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Fecha
de Inicio <br>
Esperada:</font></td>
<td width="30%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></td>
</tr>
<tr>
<td width="19%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Categoría
del Gasto:</font></td>
<td width="36%"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<select name="categoria" id="categoria">
<?php
require('conexion2.php');
$stmt = ociparse($c1,"SELECT NOMBRE,PLAN_CATEGORIAS_ID
FROM SIA_PLAN_CATEGORIAS");
$result = OCIExecute($stmt);
if ($result == false) {
?>
<option value="0">Sin Datos</option>
<?php
}else{
while (OCIFetchInto($stmt, $value)) {
$nomc = $value[0];
$pcid = $value[1];
?>
<option value="<?php echo $pcid; ?>"><?php echo $nomc; ?></option>
<?php
}
}
?>
</select>
</font></td>
<td colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select4">
<option value="1">01</option>
<option value="2">02</option>
<option value="3">03</option>
<option value="4">04</option>
<option value="5">05</option>
<option value="6">06</option>
<option value="7">07</option>
<option value="8">08</option>
<option value="9">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="select5">
<option value="01">Enero</option>
<option value="02">Febrero</option>
<option value="03">Marzo</option>
<option value="04">Abril</option>
<option value="05">Mayo</option>
<option value="06">Junio</option>
<option value="07">Julio</option>
<option value="08">Agosto</option>
<option value="09">Septiembre</option>
<option value="10">Octubre</option>
<option value="11">Noviembre</option>
<option value="12">Diciembre</option>
</select>
<select name="select6">
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</select>
</font></td>
</tr>
<tr>
<td colspan="4" bgcolor="#F4F4F4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>2.
Detalle del CDP</strong></font></td>
</tr>
<tr>
<td colspan="4"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Metas
a las que apunta en el Plan de Desarrollo:</font></td>
</tr>
<tr>
<td colspan="4"><table width="100%" border="0" cellpadding="2">
<tr>
<td width="77%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="meta1" id="meta1">
<?php
require('conexion2.php');
$stmt2 = ociparse($c1,"SELECT PLAN_ACTIVIDADES_ID
FROM SIA_PLAN_CDP_ENC");
$result2 = OCIExecute($stmt2);
while (OCIFetchInto($stmt2, $value2)) {
$pai = $value2[0];
echo $pai;
echo "--";
if($pai=='96') {
$stmt = ociparse($c1,"SELECT NOMBRE_META,PLAN_METAS_ID,PCTE_PRG
FROM SIA_PLAN_METAS_ACT
WHERE PLAN_ACTIVIDADES_ID = '$pai'");
$result = OCIExecute($stmt);
if ($result == false) {
?>
<option value="0">Sin Datos</option>
<?php
}else{
while (OCIFetchInto($stmt, $value)) {
$nome = $value[0];
$nome = substr($nome, 0, 90);
$pmid = $value[1];
?>
<option value="<?php echo $pmid; ?>"><?php echo $nome; ?></option>
<?php
}
}}}
?>
</select>
</font></td>
<td width="23%"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield522" type="text" size="20">
</font></div></td>
</tr>
<tr>
<td width="77%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select8">
</select>
</font></td>
<td width="23%"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield523" type="text" size="20">
</font></div></td>
</tr>
<tr>
<td width="77%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select9">
</select>
</font></td>
<td width="23%"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield524" type="text" size="20">
</font></div></td>
</tr>
<tr>
<td width="77%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select10">
</select>
</font></td>
<td width="23%"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield525" type="text" size="20">
</font></div></td>
</tr>
<tr>
<td width="77%"><div align="right"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Total:</strong></font></div></td>
<td width="23%" bgcolor="#B3D7FF"> <div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="textfield526" type="text" size="20">
</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="4"><div align="center">
<input type="submit" name="Submit" value="Guardar el CDP">
</div></td>
</tr>
<tr>
<td colspan="4" bgcolor="#F4F4F4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>3.
Observaciones</strong></font></td>
</tr>
<tr>
<td colspan="4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></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>
|