| 664,7 → 664,7 |
|---|
| (!$this->etreNull($tag_sql) ? "AND ($tag_sql) " : ''). |
| 'ORDER BY utilisateur ASC, ci.ordre ASC'; |
| //$this->debug[] = $requete; |
| //die($requete); |
| die($requete); |
| $elements_tag = $this->executerRequete($requete); |
| |
| $requete_tag = array(); |
| 704,7 → 704,7 |
|---|
| private function getSqlWhereMotsCles($tag) { |
| $sql = null; |
| $mots_cles = $this->decomposerParametreTag($tag); |
| $requete_projet = $this->getSqlWhereMotsClesImages($mots_cles['motsClesEncodesProteges']); |
| $requete_projet = $this->getSqlWhereMotsClesImages($mots_cles); |
| $sql = $requete_projet; |
| //$this->debug[] = $sql; |
| return $sql; |
| 715,10 → 715,10 |
|---|
| */ |
| private function getSqlWhereMotsClesImages($mots_cles_encodes) { |
| $where_mots_cles_images = array(); |
| foreach ($mots_cles_encodes as $mot_cle_encode) { |
| foreach ($mots_cles_encodes['motsClesEncodesProteges'] as $mot_cle_encode) { |
| $where_mots_cles_images[] = "ci.mots_cles_texte LIKE $mot_cle_encode"; |
| } |
| $where_mots_cles_images = implode(' OR ', $where_mots_cles_images); |
| $where_mots_cles_images = implode(' '.$mots_cles_encodes['type'].' ', $where_mots_cles_images); |
| return $where_mots_cles_images; |
| } |
| |
| 738,7 → 738,6 |
|---|
| foreach ($mots_cles['motsCles'] as $mot) { |
| $mots_cles['motsClesEncodesProteges'][] = $this->bdd->quote('%'.$mot.'%'); |
| } |
| //print_r($mots_cles); exit; |
| $this->debug[] = $mots_cles; |
| return $mots_cles; |
| } |