1,8 → 1,7 |
<?php |
|
Class InventoryImageListPublic extends Cel { |
class InventoryImageListPublic extends Cel { |
|
private $criteres = array('mots-cles' => 'c.ci_meta_mots_cles', |
private $criteres = array('tag' => 'c.ci_meta_mots_cles', |
'auteur' => 'c.ci_ce_utilisateur', |
'commune' => 'b.location', |
'dept' => 'b.id_location', |
50,6 → 49,7 |
$this->limit = $_GET['limit']; |
} |
|
|
// Construction de la requĂȘte |
$requete_debut = 'SELECT * '; |
|
233,7 → 233,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); |
256,7 → 256,7 |
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->proteger($this->encoderMotCle($mot)).' OR '; |