Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 748 → Rev 749

/trunk/jrest/services/CelSyndicationImage.php
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++) {