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 '; |
} |