401,6 → 401,7 |
$requete .= $this->creerSousRequeteRechercheParCriteres($criteres); |
} |
} |
$requete = rtrim($requete,' AND ) '); |
$requete = rtrim($requete, 'AND '); |
$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : |
'c.ci_meta_date_ajout DESC').' '."LIMIT $this->start,$this->limit "; |
451,7 → 452,7 |
} |
|
private function creerSousRequeteMotsCles($mot_cle) { |
$requete = ' ( '; |
$requete = ''; |
if (preg_match('/.*OU.*/', $mot_cle)) { |
$requete = $this->creerSousRequeteMotsClesOu($mot_cle); |
} else if (preg_match('/.*ET.*/', $mot_cle)) { |
462,11 → 463,12 |
'cmc_id_mot_cle_general = '.$this->bdd->quote($this->encoderMotCle($mot_cle)); |
$elements = $this->executerRequete($prerequete); |
if ($elements != false && count($elements) > 0) { |
$requete = ' ( '; |
foreach ($elements as $occurence) { |
$requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '. |
$this->bdd->quote($occurence['cmc_id_proprietaire']).' ) OR '; |
} |
} |
}echo $requete; |
} |
$requete = rtrim($requete,' OR ').' ) AND '; |
return $requete; |
473,8 → 475,7 |
} |
|
private function creerSousRequeteMotsClesOu($mot_cle) { |
$requete = ' ( '; |
|
$requete = ''; |
$tab_mots_cles = explode('OU', $mot_cle); |
$where = ''; |
foreach ($tab_mots_cles as $mot) { |
486,6 → 487,7 |
$prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where "; |
$elements = $this->executerRequete($prerequete);//print_r($elements); |
if ($elements != false && count($elements) > 0) { |
$requete = ' ( '; |
foreach ($elements as $occurence) { |
$requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '. |
$this->bdd->quote($occurence['cmc_id_proprietaire']).' ) OR '; |
495,7 → 497,7 |
} |
|
private function creerSousRequeteMotsClesEt($mot_cle) { |
$requete = ' ( '; |
$requete = ''; |
$where = ''; |
$champs = 'a.cmc_id_proprietaire , '; |
$table = ''; |
518,6 → 520,7 |
$prerequete = "SELECT $champs FROM $table WHERE $where "; |
$elements = $this->executerRequete($prerequete);//print_r($elements); |
if ($elements != false && count($elements) > 0) { |
$requete = ' ( '; |
foreach ($elements as $occurence) { |
$requete .= ' ('; |
for ($j = 'a'; $j < $i; $j++) { |