Viewing file: repmetas1.php (10.26 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Reporte Consolidado de Metas</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_callJS(jsStr) { //v2.0
return eval(jsStr)
}
//-->
</script>
</head>
<body text="#333333" link="#666666" vlink="#666666" alink="#666666">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%"> </td>
<?php
require('conexion2.php');
$stmt = ociparse($c1,"select codigo_proyecto,nombre_proyecto,nombre,indicador,unidad,descripcion,linea_base,valor_base,estrategia,nombre_gerente,dependencia from sia_plan_metas where plan_metas_id=$id");
$result = OCIExecute($stmt);
while (OCIFetchInto($stmt, $cur)) {
$codp = $cur[0];
$namp = $cur[1];
$nam = $cur[2];
$ind = @$cur[3];
$uni = @$cur[4];
$des = @$cur[5];
$des = str_replace("\n", "<br>", $des);
$linb = @$cur[6];
$linb = str_replace("\n", "<br>", $linb);
$valb = @$cur[7];
$valb = str_replace("\n", "<br>", $valb);
$est = @$cur[8];
$est = str_replace("\n", "<br>", $est);
$ger = @$cur[9];
$dep = @$cur[10];
}
require('hoy.php');
$stmt = ociparse($c1,"select plan_prog_enc_id,valor_prog from sia_plan_prog_enc where plan_metas_id=$id and ano=$year");
$result = OCIExecute($stmt);
while (OCIFetchInto($stmt, $cur)) {
$ppeid = $cur[0];
$valorprog = $cur[1];
//echo $nextel;
}
?>
<td width="34%"><p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Proyecto:
<font color="#FF9900"><?php echo $codp; ?></font> </strong></font><font size="5" face="Verdana, Arial, Helvetica, sans-serif"><br>
<font color="#999999" size="2"><strong><?php echo $namp; ?> </strong></font></font></p>
<p><strong><font color="#000000" size="4" face="Verdana, Arial, Helvetica, sans-serif">Meta:
</font></strong><font color="#999999" size="4" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $nam; ?>
</font></p>
<table width="550" border="0" cellspacing="0" cellpadding="4">
<tr bgcolor="#F3F3F3">
<td colspan="2" bgcolor="#FFFF99"><div align="right"><a href="#"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" onclick="MM_callJS('history.go(-1);')">Regresar</font></a></div></td>
</tr>
<tr bgcolor="#F3F3F3">
<td colspan="2" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Gerente
de la Meta:</strong></font></td>
</tr>
<tr bgcolor="#FFEADF">
<td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $ger; ?>
/ <?php echo $dep; ?></font></td>
</tr>
<tr bgcolor="#F3F3F3">
<td colspan="2" bgcolor="#F3F3F3"> <div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Indicador:</strong></font></div></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $ind; ?></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Unidad:</strong></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $uni; ?></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Descripción:</strong></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $des; ?></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Línea
base :</strong></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $linb; ?>
</font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Valor
base :</strong></font></td>
<td width="50%" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Valor
programado :</strong></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $valb; ?>
<?php echo $uni; ?></font></td>
<td><font size="2" face="Arial, Helvetica, sans-serif">(Se espera +)
<?php echo $valorprog; ?> <?php echo $uni; ?></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Estrategia:</strong></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $est; ?></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Desarrollo
de la meta:</strong></font></td>
</tr>
<tr valign="top" bgcolor="#FFFFE1">
<td colspan="2" bgcolor="#ECF5FF"> <table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr valign="top" bgcolor="#FFFFFF">
<td> <table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td width="15%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Mes</font></strong></div></td>
<td width="15%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">%
Prog.</font></strong></div></td>
<td width="15%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">%
Real</font></strong></div></td>
<td width="15%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Valor</font></strong></div></td>
<td width="40%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Estrategia</font></strong></div></td>
</tr>
<?php
require('conexion2.php');
$stmt1 = ociparse($c1,"select mes,desc_mes,pcte_prog,pcte_real,valor_real,estrategia from sia_plan_prog_det where plan_prog_enc_id = $ppeid order by mes");
$result1 = OCIExecute($stmt1);
$porreal = 0;
$valreal = 0;
while (OCIFetchInto($stmt1, $cur1)) {
$mes = $cur1[0];
$mes_desc = @$cur1[1];
$det_pp = @$cur1[2];
$det_pr = @$cur1[3];
$porreal = $porreal + $det_pr;
$det_val = @$cur1[4];
$valreal = $valreal + $det_val;
$det_est = @$cur1[5];
$det_est1 = substr($det_est, 0, 150);
//echo $nextel;
?>
<tr>
<td width="15%" valign="top"><font size="2" face="Arial, Helvetica, sans-serif"><strong><?php echo $mes_desc; ?></strong></font></td>
<td width="15%" valign="top" bgcolor="#F0FDFF"> <div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $det_pp; ?></font></div></td>
<td width="15%" valign="top" bgcolor="#FFF8E8"> <div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $det_pr; ?></font></div></td>
<td width="15%" valign="top" bgcolor="#FFF8E8"> <div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $det_val; ?></font></div></td>
<td width="40%"><font size="2" face="Arial, Helvetica, sans-serif" title="<?php echo $det_est;?>"><a href="#"><?php echo $det_est1; ?>...</a></font></td>
</tr>
<?php } ?>
<tr>
<td valign="middle">
<div align="right"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Acumulado:</font></strong></div></td>
<td valign="middle" bgcolor="#AAEEFD">
<div align="center"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">100%</font></strong></div></td>
<td valign="middle" bgcolor="#FFFFCC">
<div align="center"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $porreal; ?>%</font></strong></div></td>
<td valign="middle" bgcolor="#FFCCCC">
<div align="center"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $valreal; ?></font><font size="1" face="Arial, Helvetica, sans-serif">
<?php echo $uni; ?></font></strong></div></td>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
<td width="33%"> </td>
</tr>
<tr>
<td width="33%"> </td>
<td width="34%"><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Todos
los Derechos Reservados para el DAMA</strong><br>
<font color="#FF9900">Departamento Técnico Administrativo del Medio
Ambiente</font><br>
Este Informe es Automático<br>
2005</font></div></td>
<td width="33%"> </td>
</tr>
</table>
</body>
</html>
|