| 23,13 → 23,13 |
|---|
| private $format_image = 'XL'; |
| |
| private $criteres = array( |
| 'auteur' => 'c.ci_ce_utilisateur', |
| 'utilisateur' => 'c.ci_ce_utilisateur', |
| 'commune' => 'b.location', |
| 'departement' => 'b.id_location', |
| 'dept' => 'b.id_location', |
| 'taxon' => 'b.nom_ret', |
| 'commentaire' => 'c.ci_meta_comment', |
| 'date' => 'c.ci_meta_date', |
| 'mots-cles' => 'mots-cles'); |
| 'tag' => 'mots-cles'); |
| |
| /** |
| * Méthode appelée avec une requête de type GET. |
| 416,7 → 416,7 |
|---|
| if ($elements != false && count($elements) > 0) { |
| $contenu = $this->executerService($elements); |
| } else { |
| $this->messages[] = "Aucune image disponible."; |
| $this->messages[] = "Aucune image disponible.".$requete; |
| } |
| |
| return $contenu; |
| 457,7 → 457,7 |
|---|
| |
| private function creerSousRequeteMotsCles($mot_cle) { |
| $requete = ' ( '; |
| if (preg_match('/.*,.*/', $mot_cle)) { |
| if (preg_match('/.*OU.*/', $mot_cle)) { |
| $requete = $this->creerSousRequeteMotsClesOu($mot_cle); |
| } else if (preg_match('/.*ET.*/', $mot_cle)) { |
| $requete = $this->creerSousRequeteMotsClesEt($mot_cle); |
| 480,10 → 480,10 |
|---|
| private function creerSousRequeteMotsClesOu($mot_cle) { |
| $requete = ' ( '; |
| |
| $tab_mots_cles = explode(',', $mot_cle); |
| $tab_mots_cles = explode('OU', $mot_cle); |
| $where = ''; |
| foreach ($tab_mots_cles as $mot) { |
| $where .= 'cmc_id_mot_cle_general = '.$this->bdd->quote($this->encoderMotCle($mot)).' OR '; |
| $where .= 'cmc_id_mot_cle_general = '.$this->bdd->quote($this->encoderMotCle(trim($mot))).' OR '; |
| } |
| $where = rtrim($where,' OR '); |
| |
| 510,7 → 510,7 |
|---|
| foreach ($tab_mots_cles as $mot) { |
| $champs .= "$i.cmc_id_mot_cle_utilisateur as $i , "; |
| $table .= "cel_mots_cles_images $i , "; |
| $where .= "$i.cmc_id_mot_cle_general = ".$this->bdd->quote($this->encoderMotCle($mot)).' AND '; |
| $where .= "$i.cmc_id_mot_cle_general = ".$this->bdd->quote($this->encoderMotCle(trim($mot))).' AND '; |
| if ($i !== "a") { |
| $where .= " $i.cmc_id_proprietaire = ".$j.".cmc_id_proprietaire AND "; |
| $j++; |
| 520,11 → 520,11 |
|---|
| $where = rtrim($where,' AND '); $champs = rtrim($champs,' , '); $table = rtrim($table,' , '); |
| |
| // Construction de la requête |
| $prerequete = "SELECT $champs FROM $table WHERE $where "; |
| $prerequete = "SELECT $champs FROM $table WHERE $where "; |
| $elements = $this->executerRequete($prerequete);//print_r($elements); |
| if ($elements != false && count($elements) > 0) { |
| foreach ($elements as $occurence) { |
| $requete = ' ('; |
| $requete .= ' ('; |
| for ($j = 'a'; $j < $i; $j++) { |
| $requete .= 'ci_meta_mots_cles like "%'.$occurence[$j].'%" AND '; |
| } |