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 |