| 37,6 → 37,27 |
|---|
| |
| } |
| |
| 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']; |
| } |
| |
| return $annees_ayant_obs; |
| } |
| |
| private function getObservationsPourStation($params) { |
| |
| $id_station = isset($params[0]) ? $params[0] : ''; |
| 234,7 → 255,7 |
|---|
| $requete_suppression_observation = 'DELETE FROM ods_observations '. |
| 'WHERE oo_id_observation = '.$this->proteger($donnees_obs_a_inserer['id_observation']).' '. |
| 'AND oo_absence_evenement = 1'; |
| |
| |
| $this->executerRequeteSimple($requete_suppression_observation); |
| } else { |
| $requete_modification_observation = 'UPDATE ods_observations '. |