| 55,7 → 55,7 |
|---|
| $requete_recherche_images .= ' ORDER BY ci.ordre LIMIT '.$debut.','.$limite ; |
| |
| $resultats_images = array(); |
| $resultats_images = $this->requeter($requete_recherche_images); |
| $resultats_images = $this->executerRequete($requete_recherche_images); |
| |
| return $resultats_images; |
| } |
| 78,7 → 78,7 |
|---|
| $requete_recherche_images .= $sous_requete_recherche; |
| $nb_images = 0; |
| |
| $resultat_requete_nombre_images = $this->requeter($requete_recherche_images); |
| $resultat_requete_nombre_images = $this->executerRequete($requete_recherche_images); |
| |
| if($resultat_requete_nombre_images && is_array($resultat_requete_nombre_images) && count($resultat_requete_nombre_images) > 0) { |
| $nb_images = $resultat_requete_nombre_images[0]['nb_images']; |
| 108,7 → 108,7 |
|---|
| |
| $requete_table_liaison = 'SELECT id_observation FROM cel_obs_images WHERE id_image = '.$id_image; |
| |
| $resultats_liaisons_images = $this->requeter($requete_table_liaison); |
| $resultats_liaisons_images = $this->executerRequete($requete_table_liaison); |
| |
| $ids_obs = ''; |
| |
| 120,7 → 120,7 |
|---|
| |
| if(trim($ids_obs) != '') { |
| $requete_obs_liees = 'SELECT * FROM cel_obs WHERE id_observation IN ('.$ids_obs.') AND ce_utilisateur ="'.$id_utilisateur.'"'; |
| $resultat_obs_liees = $this->requeter($requete_obs_liees); |
| $resultat_obs_liees = $this->executerRequete($requete_obs_liees); |
| |
| foreach($resultat_obs_liees as $obs_liee) |
| { |
| 144,7 → 144,7 |
|---|
| switch($nom) { |
| |
| case "mots_cles"; |
| $sous_requete .= 'ci.mots_cles_texte LIKE '.$this->proteger('%'.$valeur.'%').' AND '; |
| $sous_requete .= $this->creerSousRequeteMotsCles($valeur); |
| break; |
| |
| case "id_mots_cles"; |
| 278,15 → 278,25 |
|---|
| return $requete_recherche_date; |
| } |
| |
| //TODO a refaire |
| private function fabriquerSousRequeteMotsClesOu($mot_cle) { |
| |
| } |
| |
| //TODO a refaire |
| private function fabriquerSousRequeteMotsClesEt($mot_cle) { |
| |
| } |
| private function creerSousRequeteMotsCles($mot_cle) { |
| $requete = ''; |
| if (preg_match('/.*OU.*/', $mot_cle)) { |
| $mots_cles_tab = explode('OU',$mot_cle); |
| foreach($mots_cles_tab as $mot_cle_item) { |
| $requete .= '(ci.mots_cles_texte LIKE '.$this->proteger('%'.$mot_cle_item.'%').') OR '; |
| } |
| $requete = '('.rtrim($requete,'OR ').')'; |
| } else if (preg_match('/.*ET.*/', $mot_cle)) { |
| $mots_cles_tab = explode('ET',$mot_cle); |
| foreach($mots_cles_tab as $mot_cle_item) { |
| $requete .= '(ci.mots_cles_texte LIKE '.$this->proteger('%'.$mot_cle_item.'%').') AND '; |
| } |
| $requete = '('.rtrim($requete, 'AND ').') '; |
| } else { |
| $requete = "(ci.mots_cles_texte LIKE ".$this->proteger('%'.$mot_cle.'%').') '; |
| } |
| return $requete; |
| } |
| |
| public function formaterPourEnvoiCel($tableau_images) { |
| foreach($tableau_images as &$image) { |
| 308,7 → 318,7 |
|---|
| 'FROM cel_images_mots_cles '. |
| 'WHERE id_image = '.$id_image; |
| |
| return $this->requeter($requete_selection_mots_cles); |
| return $this->executerRequete($requete_selection_mots_cles); |
| } |
| |
| // TODO: fonction temporaire |