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: aqi.php (14.62 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | <?php require('conexion4.php'); $today = getdate(); $month = $today['month']; $montho = $today['mon']; $mday = $today['mday']; $year = $today['year']; $hour = $today['hours']; if ($hour < 15) { $acc = "prev"; $diax = $mday; $mesx = $montho; $anox = $year; } $sing = isset($acc); if ($sing == true) { $year = $anox; $montho = $mesx; $mday = $diax; } //echo $year; //echo $montho; //echo $mday; if ($sing == true) { $sh = 0; if ($acc == "next") { $tom = mktime(0,0,0,date("$montho") ,date("$mday")+1,date("$year")); $sh = 1; } if ($acc == "prev") { $tom = mktime(0,0,0,date("$montho") ,date("$mday")-1,date("$year")); $sh = 1; } if ($sh == 0) { $tom = mktime(0,0,0,$montho,$mday,$year); } //echo $tom; $today = getdate($tom); $montho = $today['mon']; $month = $today['month']; $mday = $today['mday']; $year = $today['year']; if ($montho < 10) { $montho = 0 . $montho; } if ($mday < 10) { $mday = 0 . $mday; } $fcons = $mday . "/" . $montho . "/" . $year; }else{ if ($montho < 10) { $montho = 0 . $montho; } if ($mday < 10) { $mday = 0 . $mday; } $fcons = $mday . "/" . $montho . "/" . $year; } require('fechanew2.php') ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Informe Diario de la Calidad del Aire de Bogotá...</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> </head> <body link="#0066CC" vlink="#0066CC" alink="#0066CC" topmargin="0"> <table width="100%" border="0" cellpadding="0"> <tr> <td width="30%"> </td> <td width="40%"><div id="Layer1" style="position:absolute; width:352px; height:524px; z-index:1"> <table width="100%" height="550" border="0" cellpadding="6"> <tr> <td height="25%"> </td> </tr> <tr> <td height="25%"> </td> </tr> <tr> <td height="20%"> <?php if ($hour < 15) { ?> <div id="Layer2" style="position:absolute; width:255px; height:103px; z-index:2"> <table width="134%" border="1" cellpadding="2" bordercolor="#CCCCCC"> <tr> <td bgcolor="#FFFFFF"> <div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#336699"><img src="in.gif" width="8" height="8"></font></strong></font> <font color="#FF9900" size="1" face="Verdana, Arial, Helvetica, sans-serif">Nota</font></strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">: Debido a que por la hora </font> aún no se registran datos suficientes para representar el día de hoy, se presentan los datos del día anterior.</font></div></td> </tr> </table> </div> <?php } ?> </td> </tr> <?php //echo $fcons; $stmt = ociparse($c1,"select distinct medias_diarias.estacion_id, medias_diarias.valor from medias_diarias, estaciones_magnitudes where medias_diarias.magnitud_indx=estaciones_magnitudes.magnitud_indx and medias_diarias.estacion_id=estaciones_magnitudes.estacion_id and estaciones_magnitudes.magnitud_id=10 and to_char(medias_diarias.fecha, 'dd/mm/yyyy')='$fcons'"); //echo $stmt; $result = OCIExecute($stmt); $num_filas = 0; while (OCIFetchInto($stmt, $value)) { $nextel = $value[0]; $stmt1 = ociparse($c1,"select codigo from estaciones where estacion_id = $nextel"); $result1 = OCIExecute($stmt1); while (OCIFetchInto($stmt1, $value1)) { $estacionid = $value1[0]; } $vali = $value[1]; //echo "<br>..."; //echo $vali; //echo "---"; //echo $estacionid; //echo "<br>"; require('color.php'); $val[$estacionid] = $vali; $fusion[$estacionid] = $col1; $num_filas++; } $pm10 = 0; $ul = 0; for ($i = 1; $i <= 14; $i++) { $compr = isset($val[$i]); if ($compr == false) { $val[$i] = 0; } $pm10 = $pm10 + $val[$i]; if ($val[$i] != 0) { $ul++; } } //echo $ul; $pm10 = $pm10 / $ul; $pm10 = round($pm10); if ($num_filas == 0) { require('fechanew2.php'); $pm10 = 0; $fic = 1; }else{ require('fechanew2.php'); $fic = 0; } $con = 0; ?> <?php //echo $fcons; $stmt = ociparse($c1,"select distinct medias_diarias.estacion_id, medias_diarias.valor from medias_diarias, estaciones_magnitudes where medias_diarias.magnitud_indx=estaciones_magnitudes.magnitud_indx and medias_diarias.estacion_id=estaciones_magnitudes.estacion_id and estaciones_magnitudes.magnitud_id=3 and to_char(medias_diarias.fecha, 'dd/mm/yyyy')='$fcons'"); //echo $stmt; $result = OCIExecute($stmt); $num_filas = 0; while (OCIFetchInto($stmt, $value6)) { $nextel = $value6[0]; $stmt1 = ociparse($c1,"select codigo from estaciones where estacion_id = $nextel"); $result1 = OCIExecute($stmt1); while (OCIFetchInto($stmt1, $value1)) { $estacionid = $value1[0]; } $vali6 = $value6[1]; //echo "<br>..."; //echo $vali; //echo "---"; //echo $estacionid; //echo "<br>"; require('colorpst.php'); $val6[$estacionid] = $vali6; $fusion6[$estacionid] = $col1; $num_filas++; } $pst = 0; $ul = 0; for ($i = 1; $i <= 14; $i++) { $compr = isset($val6[$i]); if ($compr == false) { $val6[$i] = 0; } $pst = $pst + $val6[$i]; if ($val6[$i] != 0) { $ul++; } } //echo $ul; //$pst = $pst / $ul; $pst = round($pst); if ($num_filas == 0) { require('fechanew2.php'); $pst = 0; $fic = 1; }else{ require('fechanew2.php'); $fic = 0; } $con = 0; ?> <?php //echo $fcons; $stmt = ociparse($c1,"select distinct medias_diarias.estacion_id, medias_diarias.valor from medias_diarias, estaciones_magnitudes where medias_diarias.magnitud_indx=estaciones_magnitudes.magnitud_indx and medias_diarias.estacion_id=estaciones_magnitudes.estacion_id and estaciones_magnitudes.magnitud_id=8 and to_char(medias_diarias.fecha, 'dd/mm/yyyy')='$fcons'"); //echo $stmt; $result = OCIExecute($stmt); $num_filas = 0; while (OCIFetchInto($stmt, $value7)) { $nextel = $value7[0]; $stmt1 = ociparse($c1,"select codigo from estaciones where estacion_id = $nextel"); $result1 = OCIExecute($stmt1); while (OCIFetchInto($stmt1, $value1)) { $estacionid = $value1[0]; } $vali7 = $value7[1]; //echo "<br>..."; //echo $vali; //echo "---"; //echo $estacionid; //echo "<br>"; require('colorno2.php'); $val7[$estacionid] = $vali7; $fusion7[$estacionid] = $col1; $num_filas++; } $no2 = 0; $ul = 0; for ($i = 1; $i <= 14; $i++) { $compr = isset($val7[$i]); if ($compr == false) { $val7[$i] = 0; } $no2 = $no2 + $val7[$i]; if ($val7[$i] != 0) { $ul++; } } //echo $ul; $no2 = $no2 / $ul; $no2 = round($no2); if ($num_filas == 0) { require('fechanew2.php'); $no2 = 0; $fic = 1; }else{ require('fechanew2.php'); $fic = 0; } $con = 0; ?> <?php //echo $fcons; $stmt = ociparse($c1,"select distinct medias_diarias.estacion_id, medias_diarias.valor from medias_diarias, estaciones_magnitudes where medias_diarias.magnitud_indx=estaciones_magnitudes.magnitud_indx and medias_diarias.estacion_id=estaciones_magnitudes.estacion_id and estaciones_magnitudes.magnitud_id=6 and to_char(medias_diarias.fecha, 'dd/mm/yyyy')='$fcons'"); //echo $stmt; $result = OCIExecute($stmt); $num_filas = 0; while (OCIFetchInto($stmt, $value8)) { $nextel = $value8[0]; $stmt1 = ociparse($c1,"select codigo from estaciones where estacion_id = $nextel"); $result1 = OCIExecute($stmt1); while (OCIFetchInto($stmt1, $value1)) { $estacionid = $value1[0]; } $vali8 = $value8[1]; //echo "<br>..."; //echo $vali; //echo "---"; //echo $estacionid; //echo "<br>"; require('colorco.php'); $val8[$estacionid] = $vali8; $fusion8[$estacionid] = $col1; $num_filas++; } $mono = 0; $ul = 0; for ($i = 1; $i <= 14; $i++) { $compr = isset($val8[$i]); if ($compr == false) { $val8[$i] = 0; } $mono = $mono + $val8[$i]; if ($val8[$i] != 0) { $ul++; } } //echo $ul; $mono = $mono / $ul; $mono = round($mono); if ($num_filas == 0) { require('fechanew2.php'); $mono = 0; $fic = 1; }else{ require('fechanew2.php'); $fic = 0; } $con = 0; ?> <?php //echo $fcons; $stmt = ociparse($c1,"select distinct medias_diarias.estacion_id, medias_diarias.valor from medias_diarias, estaciones_magnitudes where medias_diarias.magnitud_indx=estaciones_magnitudes.magnitud_indx and medias_diarias.estacion_id=estaciones_magnitudes.estacion_id and estaciones_magnitudes.magnitud_id=1 and to_char(medias_diarias.fecha, 'dd/mm/yyyy')='$fcons'"); //echo $stmt; $result = OCIExecute($stmt); $num_filas = 0; while (OCIFetchInto($stmt, $value9)) { $nextel = $value9[0]; $stmt1 = ociparse($c1,"select codigo from estaciones where estacion_id = $nextel"); $result1 = OCIExecute($stmt1); while (OCIFetchInto($stmt1, $value1)) { $estacionid = $value1[0]; } $vali9 = $value9[1]; //echo "<br>..."; //echo $vali; //echo "---"; //echo $estacionid; //echo "<br>"; require('colorso2.php'); $val9[$estacionid] = $vali9; $fusion9[$estacionid] = $col1; $num_filas++; } $so2 = 0; $ul = 0; for ($i = 1; $i <= 14; $i++) { $compr = isset($val9[$i]); if ($compr == false) { $val9[$i] = 0; } $so2 = $so2 + $val9[$i]; if ($val9[$i] != 0) { $ul++; } } //echo $ul; $so2 = $so2 / $ul; $so2 = round($so2); if ($num_filas == 0) { require('fechanew2.php'); $so2 = 0; $fic = 1; }else{ require('fechanew2.php'); $fic = 0; } $con = 0; ?> <tr> <td height="30%" valign="top"> <table width="100%" border="0" cellpadding="0"> <tr bgcolor="#006699"> <td colspan="2"> <div align="center"><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $fechapresentar; ?></b></font></div></td> </tr> <tr> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqibocalive1II.php?diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>&acc=1">Partículas Suspendidas Totales</a> <strong>(PST)</strong></font></td> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $pst; ?> µg/m3 </font> <?php $vali = $pst; require('colorpst.php'); $colores = $col1; ?> <img src="<?php echo $colores;?>" width="8" height="8"> </td> </tr> <tr> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqibocaliveII.php?diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>&acc=1">Partículas Menores a 10 Micras</a> <strong>(PM10)</strong></font></td> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $pm10; ?> µg/m3</font> <?php $vali = $pm10; require('color.php'); $colores = $col1; ?> <img src="<?php echo $colores;?>" width="8" height="8"> </td> </tr> <tr> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqibocalive2II.php?diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>&acc=1">Dióxido de Nitrogeno</a> <strong>(NO2)</strong></font></td> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $no2; ?> ppb</font> <?php $vali = $no2; require('colorno2.php'); $colores = $col1; ?> <img src="<?php echo $colores;?>" width="8" height="8"> </td> </tr> <tr> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqibocalive4II.php?diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>&acc=1">Dióxido de Azufre</a> <strong>(SO2)</strong></font></td> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $so2; ?> ppm</font> <?php $vali = $so2; require('colorso2.php'); $colores = $col1; ?> <img src="<?php echo $colores;?>" width="8" height="8"> </td> </tr> <tr> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqibocalive3II.php?diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>&acc=1">Monóxido de Carbono</a> <strong>(CO)</strong></font></td> <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $mono; ?> ppb </font> <?php $vali = $mono; require('colorco.php'); $colores = $col1; ?> <img src="<?php echo $colores;?>" width="8" height="8"> </td> </tr> </table></td> </tr> </table> </div> <img src="map2.jpg" width="709" height="522"></td> <td width="30%" valign="top"> </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 DAMA,<br> Alcaldía Mayor de Bogotá D.C. <strong>2005</strong><br> Sistema de Información Ambiental SIA-DAMA.<br> Contáctenos en <a href="mailto:redaire@dama.gov.co">redaire@dama.gov.co</a></font></div></td> <td width="30%"> </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 ]-- |