Subversion Repositories Sites.obs-saisons.fr

   	}

		private function getAnneeMinimumObservation() {

			$requete_annee_min_obs = 'SELECT MIN(YEAR(oo_date)) as min_annee FROM ods_observations '.

														'WHERE oo_date != "0000-00-00"';

			$resultat_min_annee_obs = $this->executerRequete($requete_annee_min_obs);

			return !empty($resultat_min_annee_obs) ? $resultat_min_annee_obs[0]['min_annee'] : Date('Y');

		}

		private function getAnneesAyantObservations() {

			$requete_annee_min_obs = 'SELECT DISTINCT YEAR(oo_date) as annee FROM ods_observations '.

														'WHERE oo_date != "0000-00-00" AND YEAR(oo_date) <= "'.date('Y').'" '.

														'ORDER BY annee DESC';

			$resultat_annees_ayant_obs = $this->executerRequete($requete_annee_min_obs);

			$annees_ayant_obs = [];

			foreach($resultat_annees_ayant_obs as $res_annee_ayant_obs) {

				$annees_ayant_obs[] = $res_annee_ayant_obs['annee'];

			}