';
echo $ligne;
$ligne = '
Point de mesure |
Type de données |
Date de début |
Date de fin |
Nombre de mesures
ou d\'analyses |
';
echo $ligne;
$selse = "select distinct se.id,se.nom
from site_exp se
join pointdemesure pdm on (pdm.site_exp_id=se.id)
order by 1 desc
;";
$qse = pg_query($hydras,$selse);
while ($rowse = pg_fetch_row($qse))
{
$se = $rowse[0];
switch ($se)
{
case 1:
//kerbernez
$fond= '#ecefde';
break;
case 2:
//naizin
$fond= '#d0ddf5';
break;
}
$selca = "select distinct ca.id,ca.nom
from pointdemesure p
join caracteristique ca on (ca.id = caracteristique_id)
where site_exp_id = $se
order by 1
;";
$ligne ='
'.$rowse[1].' |
';
echo $ligne;
$qca = pg_query($hydras,$selca);
while ($rowca = pg_fetch_row($qca))
{
$ca = $rowca[0];
switch ($se)
{
case 1:
switch ($ca)
{
case 1:
$fond= '#7d9f97';$wmc='KBZ.wmc';
break;
case 2:
$fond= '#97afa9';$wmc='KBZ.wmc';
break;
case 3:
$fond= '#beddd5';$wmc='KBZ.wmc';
break;
case 4:
$fond= '#cff1e9';$wmc='KBZ.wmc';
break;
}
break;
case 2:
switch ($ca)
{
case 1:
$fond= '#7792ca';$wmc='exuNZN.wmc';
break;
case 2:
$fond= '#85aae1';$wmc='piezoNZN.wmc';
break;
case 3:
$fond= '#8394b8';$wmc='NZN.wmc';
break;
case 4:
$fond= '#a6bce9';$wmc='meteoNZN.wmc';
break;
}
break;
}
$ligne = '
'.$rowca[1].' |
';
echo $ligne;
$selpm=" select location_id,nom
from pointdemesure
where site_exp_id=$se
and caracteristique_id=$ca
order by nom
; ";
$qpm = pg_query($hydras,$selpm);
$pm=0;
while ($rowpm = pg_fetch_row($qpm))
{
$location_id = $rowpm[0];
$ligne = '
|
'.$rowpm[1].'
|
';
echo $ligne;
$seldate=" select r.name,min (to_char(datedeb,'dd/mm/YY')) as ddeb,
max(to_char(datefin,'dd/mm/YY')) as dfin,
max(n)
from suivihydras h
join data_type dt on (dt.element_id = h.data_type_id)
join regroupement r on (r.id = dt.regroupement_id)
where h.location_id =$location_id
group by r.name
; ";
$qdate= pg_query($hydras,$seldate);
while ($rowdate = pg_fetch_row($qdate))
{
$ligne = ' '.$rowdate[0].' |
'.$rowdate[1].' |
'.$rowdate[2].' |
'.$rowdate[3].' |
| ';
echo $ligne;
}
// laisse une ligne blanche
$ligne = '';
echo $ligne;
}
}
$ligne = ' ';
echo $ligne;
}
$ligne = ' ';
echo $ligne;
pg_close ($hydras);
?>
| |