Viewing file: aire_oab.php (12.79 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php require('conexion4.php'); ?>
<?php include('aire_posiciones.php'); ?>
<? include('oab_redaire_contam.php'); ?>
<? require('fechanew2.php') ?>
<? include('redaire_fechas.php'); ?>
<? include('redaire_browser.php'); ?>
<?
//$kons= consulta diaria (PM10, PST, S02) o máxima horaria (NO2, O3, CO)
if ($contam==10 or $contam==3 or $contam==1 or $contam==89){
$kons="select distinct medias_diarias.estacion_id, medias_diarias.valor, estacion_nom,
codigo, direccion, observaciones, municipios.municipio_nom
from medias_diarias, estaciones_magnitudes, estaciones, municipios
where medias_diarias.magnitud_indx=estaciones_magnitudes.magnitud_indx
and medias_diarias.estacion_id=estaciones_magnitudes.estacion_id and estaciones.estacion_id = medias_diarias.estacion_id
and municipios.municipio_id=estaciones.municipio_id
and estaciones_magnitudes.magnitud_id=$contam and medias_diarias.fecha='$fcons' order by codigo desc";
}else{
$kons="select medias_horarias.estacion_id, max(medias_horarias.valor) maximo,
substr(fn_datos_esta(medias_horarias.estacion_id),1,32)nombre_estacion,
substr(fn_datos_esta(medias_horarias.estacion_id),33,8) codigo_estacion,
substr(fn_datos_esta(medias_horarias.estacion_id),40,256) direccion,
substr(fn_datos_esta(medias_horarias.estacion_id),296,256) observaciones,
fn_desc_muni(substr(fn_datos_esta(medias_horarias.estacion_id),551,3)) municipio
from medias_horarias, estaciones_magnitudes, FLAGS_DATOS
where medias_horarias.magnitud_indx=estaciones_magnitudes.magnitud_indx
and medias_horarias.estacion_id=estaciones_magnitudes.estacion_id
AND medias_horarias.FLAG =FLAGS_DATOS.FLAG_ID AND FLAGS_DATOS.VALIDO = 'S'
and estaciones_magnitudes.magnitud_id=$contam and medias_horarias.fecha>'$fcons' and medias_horarias.fecha<='$fcons2'
group by medias_horarias.estacion_id";
}
?>
<? $stmt = ociparse($c1, $kons); ?>
<?
// Para saber cuántos elementos tiene un array
$result = OCIExecute($stmt);
$nrows = OCIFetchStatement($stmt, $result);
//echo "RESULTADO ".$nrows;
$result = OCIExecute($stmt);
$numm = 0;
while (OCIFetchInto($stmt, $value)) {
$cod_estacion = $value[3];
$vali = strtr($value[1], "," , ".");
$nomext=$value[2];
$estacionid = $value[0];
$codX[$value[0]] = $cod_estacion;
$mival[$value[0]]= $vali;
$mivar[$value[0]]= $estacionid;
$minombre[$value[0]]= $nomext;
$codigo[$value[0]]= $cod_estacion;
$direccion=$value[4];
$dirx[$value[0]]= $direccion;
$observaciones=$value[5];
$obsx[$value[0]]= $observaciones;
$localidad=$value[6];
$locx[$value[0]]= $localidad;
}
?>
<html>
<head>
<? include ('desplegables.js'); ?>
<style type="text/css">
<!--
#LayerX {
position:absolute;
width:120;
height:100;
z-index:1;
left: 10;
top: 120;
}
.dhtmlgoodies_answer{ border:1px solid <?php echo $row_rscategoria['color2']; ?>;
background-color:<?php echo $row_rscategoria['color1']; ?>;
width:200px;
/* End layout CSS */
visibility:hidden;
height:0px;
overflow:hidden;
position:relative;
}
-->
</style>
<style type="text/css">
<!--
.texto {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
text-decoration: none;
}
input {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #666666;
background-color: #F4F4F4;
}
select {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #666666;
background-color: #F4F4F4;
}
-->
</style>
<STYLE type="text/css">
A:link {text-decoration:none;color:#666666;}
A:visited {text-decoration:none;color:#666666;}
A:active {text-decoration:none;color:#666666;}
A:hover {text-decoration:underline;color:#660000;}
.texsmall {
font-family: Verdana;
font-size: 11px;
text-decoration: none;
}
</STYLE>
<title>Red de Calidad del Aire - <? echo $nombrec;?></title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_showHideLayers() { //v6.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v;
}
}
function MM_setTextOfLayer(objName,x,newText, color) { //v4.01
if ((obj=MM_findObj(objName))!=null) with (obj)
if (document.layers) {document.write((newText)); document.close();}
else innerHTML = unescape(newText);
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<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 bgcolor="#FFFFFF">
<div id="MENU" style="position:absolute; left:10px; top:0px; width:240px; height:50px; z-index:3">
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><a href="/php/oab_2006pm10.php?acc=igual&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('PM10','','/php/redaire/b10.jpg',1)"><img src="/php/redaire/a10.jpg" alt="PM10" name="PM10" width="40" height="25" border="0"></a></td>
<td><a href="/php/oab_2006pst.php?acc=igual&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('PST','','/php/redaire/b3.jpg',1)"><img src="/php/redaire/a3.jpg" alt="PST" name="PST" width="40" height="25" border="0"></a></td>
<td><a href="/php/oab_2006so2.php?acc=igual&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('SO2','','/php/redaire/b1.jpg',1)"><img src="/php/redaire/a1.jpg" alt="SO2" name="SO2" width="40" height="25" border="0"></a></td>
<td><a href="/php/oab_2006no2.php?acc=igual&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('NO2','','/php/redaire/b8.jpg',1)"><img src="/php/redaire/a8.jpg" alt="NO2" name="NO2" width="40" height="25" border="0"></a></td>
<td><a href="/php/oab_2006co.php?acc=igual&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('CO','','/php/redaire/b6.jpg',1)"><img src="/php/redaire/a6.jpg" alt="CO" name="CO" width="40" height="25" border="0"></a></td>
<td><a href="/php/oab_2006o3.php?acc=igual&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('O3','','/php/redaire/b14.jpg',1)"><img src="/php/redaire/a14.jpg" alt="O3" name="O3" width="40" height="25" border="0"></a></td>
</tr>
</table>
</div>
<?
if ($nrows>0){
?>
<div id="PROMDIA" style="position:absolute; left:20px; top:470px; width:185px; height:60px; z-index:103; background-color: #F7F7F7; layer-background-color: #F7F7F7; border: 1px none #000000;">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class='texto'>Promedio diario de <strong><? echo $nombrec;?> </strong>para <? echo $lmes." ".$mday;?><strong><? echo " ".number_format($valorsem, 1, '.', '')." ".$unidadm; ?></strong> <br>
<br></td>
</tr>
</table>
</div>
<div id="MAPABASE" style="position:absolute; left:240; top:0; width:223px; height:494px; z-index:0; visibility: visible;"><img src="/jaime/oab/images/mapabase2.jpg" width="270" height="536"></div>
<div id='ff' style='position:absolute; left:0px; top:60px; width:266px; height:400px; z-index:6; background-color: #E3F1FD; layer-background-color: #9966FF; border: 1px none #003399; visibility: hidden;'></div>
<?
$nux=0;/////Tenía problemas y no mostraba El Bosque - Estacion 1/// el valor original era 1
do {
$vali = ($mival[$nux]);
$nomext=($minombre[$nux]);
$coddigo=($codigo[$nux]);
$dir=($dirx[$nux]);
$obs=($obsx[$nux]);
$loc=($locx[$nux]);
//$codx = $cod_estacion[$value[$nux]];
require('2006_aireColor.php');
//$left = ((40*$nux+50)/2);
//$top= ($nux*20+50);
if (isset ($mivar[$nux])) {
$valorF=$posicion[$nux] [2];
echo "<div id='Layer".$nux."' style='position:absolute; left:".($posicion[$nux] [0]-206)."px; top:".($posicion[$nux][1]-2-$posicionbola)."px; width:25px; height:25px;
z-index:1000; layer-background-color: #000000; '>
<p onMouseOver=\"MM_setTextOfLayer('ff','','<span class=\'simple\'>Estación $coddigo - $nomext<br>$dir - $loc<br><br></span>$mensaje<br><br><span class=\'valor\'>$vali $unidadm</span>')\"><img src=".$colbola." width='25' height='25' alt ='Estación $coddigo\n$nomext' onMouseOver=\"MM_showHideLayers('ff','','show')\" onMouseOut=\"MM_showHideLayers('ff','','hide')\"></p></div>";
// echo $mival[$nux];
$nux++;
}else {
// echo "";
$nux++; }
} while ($nux < 35);
//echo "FECHA: ".$fcons;?>
<div id="CONVENCIONES" style="position:absolute; left:0px; top:200px; width:250px; height:138px; z-index:2; visibility: visible;">
<img src="redaire/colores/conv<? echo $nombrec; ?>.gif" width="250" height="180"></div>
<?
}else{
?>
<div id="MENSAJE_NO" style="position:absolute; left:86px; top:188px; width:311px; height:58px; z-index:7; background-color: #D5FFFF; layer-background-color: #D5FFFF; border: 1px none #000000; visibility: visible;">
<div align="center"><strong>No existen datos registrados para el día <?php echo $mday; ?>
de <?php echo $lmes; ?> de <?php echo $year; ?> contaminante <? echo $nombrec?>.</strong></div>
</div>
<? }
?>
<div id="FECHAS" style="position:absolute; left:0; top:380px; width:207px; height:90px; z-index:5; visibility: visible;">
<table width="100%" border="0" cellpadding="4">
<tr>
<td><p><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Datos
para el día <?php echo $wda; ?><br>
<strong><font color="#336699" size="2"><img src="in.gif" width="8" height="8">
<?php echo $mday; ?> de <?php echo $lmes; ?> de <?php echo $year; ?>.</font></strong>
</font></p></td>
</tr>
<tr>
<td><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#F4F4F4">
<tr>
<td><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="fizq.gif" width="9" height="12"><a href="#">
</a></font></div></td>
<td valign="middle"> <div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><a href="<? echo $destino?>?acc=prev&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>">Día
Anterior</a> <strong> <font face="Arial, Helvetica, sans-serif">I</font></strong>
<a href="<? echo $destino;?>?acc=next&diax=<?php echo $mday; ?>&mesx=<?php echo $montho; ?>&anox=<?php echo $year; ?>">
Día Siguiente</a></font></div></td>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="fder.gif" width="9" height="12"></font></td>
</tr>
</table></td>
</tr>
</table>
</div>
<div id="IMAGEN" style="position:absolute; left:252px; top:0px; width:253px; height:46px; z-index:104">
<img src="/jaime/oab/images/redaire/a<? echo $contam; ?>.gif" width="250" height="44">
</div>
<? include('oab_pie.php'); ?>
</body>
</html>
|