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