| 15,6 → 15,20 |
|---|
| class RechercheObservation extends Cel { |
| |
| public $requete_selection_observations; |
| public static $tris_possibles = array( |
| "nom_referentiel", |
| "nom_sel", |
| "certitude", |
| "nom_ret", |
| "famille", |
| "abondance", |
| "phenologie", |
| "transmission", |
| "ce_zone_geo", |
| "altitude", |
| "date_observation", |
| "ordre" |
| ); |
| |
| public function obtenirIdObservationsPourOrdre($id_utilisateur, $ordre) { |
| $requete_selection_id = 'SELECT id_observation FROM cel_obs WHERE ordre '; |
| 50,9 → 64,9 |
|---|
| $requete_selection_observations .= 'WHERE '; |
| } |
| |
| $tri = (isset($criteres['tri'])) ? $criteres['tri'] : 'ordre'; |
| $tri = (isset($criteres['tri']) && in_array($criteres['tri'], self::$tris_possibles)) ? $criteres['tri'] : 'ordre'; |
| unset($criteres['tri']); |
| $tri_dir = (isset($criteres['tri_dir'])) ? $criteres['tri_dir'] : 'ASC'; |
| $tri_dir = (isset($criteres['tri_dir']) && in_array($criteres['tri_dir'], array('ASC', 'DESC'))) ? $criteres['tri_dir'] : 'ASC'; |
| unset($criteres['tri_dir']); |
| |
| // très mauvaise solution, mais qui permet au moins d'effectuer des requêtes complexes, sans modifier l'API |