Software: Apache. PHP/5.5.15 uname -a: Windows NT SVR-DMZ 6.1 build 7600 (Windows Server 2008 R2 Enterprise Edition) i586 SYSTEM Safe-mode: OFF (not secure) C:\Extranet\phpscripts\ drwxrwxrwx |
Viewing file: repmetas5.php (10.09 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('hoy.php'); require('conexion2.php'); $stmt = ociparse($c1,"SELECT PLAN_PRESUPUESTO_ID FROM SIA_PLAN_PRESUPUESTO WHERE ANO = '$year'"); $result = OCIExecute($stmt); while (OCIFetchInto($stmt, $value)) { $presupuesto = $value[0]; } $stmt = ociparse($c1,"Select valor From Sia_plan_act_anos Where Plan_actividades_id = '$id' And Plan_presupuesto_id = '$presupuesto'"); $result = OCIExecute($stmt); while (OCIFetchInto($stmt, $value)) { $valorvigencia = $value[0]; $valorvigencia1 = number_format($valorvigencia); } $stmt = ociparse($c1,"Select valor,libera,valor_generado From Sia_plan_cdp_enc Where Plan_actividades_id = '$id' And Plan_presupuesto_id = '$presupuesto' and (estado = 'P' or estado = 'A')"); $result = OCIExecute($stmt); $suma = 0; while (OCIFetchInto($stmt, $value)) { $lib1 = @$value[1]; if ($lib1 == "S") { $suma = $suma + $value[2]; }else{ $suma = $suma + $value[0]; } } //echo $suma; $saldo = $valorvigencia - $suma; $sal = $saldo; $sum1 = $suma; $saldo = number_format($saldo); $suma = number_format($suma); // calcula el % $por = @(($sum1 * 100)/$valorvigencia); $por = number_format($por); ?> <?php require('conexion2.php'); $stmt = ociparse($c1,"select nombre,unidad,nombre_responsable,dependencia from sia_plan_actividades where plan_actividades_id=$id"); $result = OCIExecute($stmt); while (OCIFetchInto($stmt, $cur)) { $nom = $cur[0]; $uni = $cur[1]; $nomr = @$cur[2]; $depr = @$cur[3]; } 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="5" face="Verdana, Arial, Helvetica, sans-serif">Actividad: <font color="#FF9900"><?php echo $id; ?></font> <br> <font color="#999999" size="3"><strong><?php echo $nom; ?> </strong></font></font></p> <table width="550" border="0" cellspacing="0" cellpadding="4"> <tr bgcolor="#F3F3F3"> <td width="50%" colspan="3" 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="3" bgcolor="#F3F3F3"> <div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Responsable:</strong></font></div></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td colspan="3" bgcolor="#FFEADF"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $nomr; ?> / <?php echo $depr; ?></font></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td colspan="3" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Unidad:</strong></font></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td colspan="3"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $uni; ?></font></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td colspan="3" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>% Presupuestal Ejecutado:</strong></font></td> </tr> <tr valign="top" bgcolor="#FFFFFF"> <td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="10"> <tr> <td><font color="#66CC00" face="Arial, Helvetica, sans-serif"><strong> </strong></font> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td bgcolor="#F0FDFF"><font color="#66CC00" face="Arial, Helvetica, sans-serif"><strong> <?php for ($i = 1; $i <= $por; $i++) { echo "I"; } ?> </strong> <font size="2"><?php echo $por; ?>% Ejecutado</font></font></td> </tr> </table> </td> </tr> </table> </td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Valor para la vigencia: <font color="#66CCCC"><?php echo $year; ?></font></strong></font></td> <td bgcolor="#F3F3F3"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Valor Ejecutado:</font></strong></td> <td bgcolor="#F3F3F3"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Saldo:</font></strong></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td><font size="2" face="Arial, Helvetica, sans-serif">$ <?php echo $valorvigencia1; ?></font></td> <td><font size="2" face="Arial, Helvetica, sans-serif">$ <?php echo $suma; ?></font></td> <td bgcolor="#FFEADF"><font size="2" face="Arial, Helvetica, sans-serif">$ <?php echo $saldo; ?></font></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td colspan="3" bgcolor="#F3F3F3"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Certificados de Disp. Presupuestal generados para esta actividad:</strong></font></td> </tr> <tr valign="top" bgcolor="#FFFFE1"> <td colspan="3" 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">Consecutivo</font></strong></div></td> <td width="15%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Duración</font></strong></div></td> <td width="15%" bgcolor="#B0EFFD"> <div align="center"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Fecha Inicio</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">Objetivo</font></strong></div></td> </tr> <?php require('conexion2.php'); $stmt1 = ociparse($c1,"select objetivo,valor,documento,duracion,fecha_inicio,libera,valor_generado,plan_cdp_enc_id from sia_plan_cdp_enc where plan_actividades_id = $id"); $result1 = OCIExecute($stmt1); while (OCIFetchInto($stmt1, $cur1)) { $val = $cur1[1]; $cons = @$cur1[2]; $dura = @$cur1[3]; $fini = @$cur1[4]; $lib = @$cur1[5]; $val2 = @$cur1[6]; $cdpid = @$cur1[7]; $det_obj = @$cur1[0]; $det_obj1 = substr($det_obj, 0, 150); //echo $nextel; if ($lib == "S") { $val = $val2; $indi = "(L)"; }else{ $val = $val; $indi = ""; } $val = number_format($val); ?> <tr> <td width="15%" valign="top"><font size="2" face="Arial, Helvetica, sans-serif"><strong><?php echo $cons; ?></strong></font></td> <td width="15%" valign="top" bgcolor="#F0FDFF"> <div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $dura; ?> <font size="1">Meses</font></font></div></td> <td width="15%" valign="top" bgcolor="#FFF8E8"> <div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $fini; ?></font></div></td> <td width="15%" valign="top" bgcolor="#FFF8E8"> <div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $val; ?></font></div></td> <td width="40%"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $indi; ?></font> <font size="1" face="Arial, Helvetica, sans-serif"><a href="reqrepmetas6.php?id=<?php echo $cdpid;?>&pre=<?php echo $valorvigencia;?>"><?php echo $det_obj1; ?>...</a></font></td> </tr> <?php } ?> </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> |
:: Command execute :: | |
--[ c99shell v. 1.0 pre-release build #13 powered by Captain Crunch Security Team | http://ccteam.ru | Generation time: 0.0312 ]-- |