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>
|