Line 62... |
Line 62... |
62 |
$info['imagesLiees'] =(int) $this->executerRequete($requete, 'Column');
|
62 |
$info['imagesLiees'] =(int) $this->executerRequete($requete, 'Column');
|
Line 63... |
Line 63... |
63 |
|
63 |
|
64 |
$requete = $this->construireRequeteNbreObsLiees();
|
64 |
$requete = $this->construireRequeteNbreObsLiees();
|
Line 65... |
Line 65... |
65 |
$info['observationsLiees'] = (int) $this->executerRequete($requete, 'Column');
|
65 |
$info['observationsLiees'] = (int) $this->executerRequete($requete, 'Column');
|
Line 66... |
Line 66... |
66 |
|
66 |
|
67 |
$info['moyImagesParObs'] = ($info['observationsLiees'] > 0 ? round($info['imagesLiees']/$info['observationsLiees'], 4) : '');
|
67 |
$info['moyImagesParObs'] = ($info['observationsLiees'] > 0 ? round($info['imagesLiees']/$info['observationsLiees'], 2) : '');
|
- |
|
68 |
|
- |
|
69 |
$requete = $this->construireRequeteNbreObsParCommune();
|
- |
|
70 |
$info['communes'] = ($resultats = $this->executerRequete($requete)) ? count($resultats) : '' ;
|
- |
|
71 |
$info['observationsParCommunesMin'] = 1000;
|
- |
|
72 |
$info['observationsParCommunesMax'] = 0;
|
- |
|
73 |
$info['observationsParCommunesTotal'] = 0;
|
- |
|
74 |
foreach ($resultats as $resultat) {
|
- |
|
75 |
if ($resultat['nbre'] < $info['observationsParCommunesMin']) {
|
- |
|
76 |
$info['observationsParCommunesMin'] = $resultat['nbre'];
|
- |
|
77 |
}
|
- |
|
78 |
if ($resultat['nbre'] > $info['observationsParCommunesMax']) {
|
- |
|
79 |
$info['observationsParCommunesMax'] = $resultat['nbre'];
|
- |
|
80 |
}
|
Line 68... |
Line 81... |
68 |
|
81 |
$info['observationsParCommunesTotal'] += $resultat['nbre'];
|
69 |
$requete = $this->construireRequeteNbreObsParCommune();
|
82 |
}
|
Line 70... |
Line 83... |
70 |
$info['communes'] = ($resultat = $this->executerRequete($requete)) ? count($resultat) : '' ;
|
83 |
$info['observationsParCommunesMoyenne'] = round($info['observationsParCommunesTotal'] / $info['communes'], 2);
|