| 20,6 → 20,32 |
|---|
| */ |
| class RechercheObservation extends Cel { |
| |
| public function obtenirIdObservationsPourOrdre($id_utilisateur, $ordre) { |
| |
| $requete_selection_id = 'SELECT id_observation FROM cel_obs WHERE ordre '; |
| |
| if(is_array($ordre)) { |
| $ordre = array_map(array($this,'proteger'), $ordre); |
| $requete_selection_id .= ' IN ('.implode(',',$ordre).') '; |
| } else { |
| $requete_selection_id .= ' = '.$this->proteger($ordre).' '; |
| } |
| |
| $requete_selection_id = ' AND ce_utilisateur = '.$this->proteger($id_utilisateur); |
| $requete_selection_id = ' ORDER BY id_observation'; |
| |
| $resultat_ids = $this->requeter($requete_selection_id); |
| |
| $ids = array(); |
| if(is_array($resultat_ids)) { |
| foreach ($resultat_ids as $resultat) { |
| $ids[] = $resultat['id_observation']; |
| } |
| } |
| |
| return $ids; |
| } |
| |
| public function rechercherObservations($id_utilisateur = null, $criteres = array(), $numero_page = 0, $taille_page = 50) { |
| |
| $requete_selection_observations = 'SELECT * FROM cel_obs '; |