| 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 * '; |
| |
| 86,9 → 86,9 |
|---|
| |
| $res_nb =& $this->executerRequete($requete_nb); |
| |
| $images = array(); |
| $images = array(); |
| |
| $total = 0; |
| $total = 0; |
| |
| foreach ($res as $row) { |
| $images[]= $row; |
| 127,10 → 127,15 |
|---|
| elseif($nom_valeur[0] == "c.ci_numero_page") |
| { |
| $this->start = $this->limite*$this->proteger($nom_valeur[1]) ; |
| } elseif($nom_valeur[0] == "c.ci_ce_utilisateur") |
| { |
| $requete .= 'c.ci_ce_utilisateur LIKE '.$this->proteger($nom_valeur[1].'%') ; |
| $requete .= ' AND '; |
| } |
| elseif($nom_valeur[0] == "c.ci_meta_mots_cles") |
| { |
| $requete .= $this->creerSousRequeteMotsCles($nom_valeur[1]); |
| $requete .= ' AND '; |
| } |
| elseif($nom_valeur[0] == "c.ci_meta_comment") |
| { |
| 139,13 → 144,13 |
|---|
| foreach($mots_comment_liste as $mot_comment) |
| { |
| $mot_comment = trim($mot_comment) ; |
| $requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($mot_comment).'%"' ; |
| $requete .= $nom_valeur[0].' LIKE '.$this->proteger($mot_comment.'%'); |
| $requete .= ' AND ' ; |
| } |
| } |
| elseif($nom_valeur[0] == "c.ci_meta_date") |
| { |
| $requete .= 'DATE_FORMAT( '.$nom_valeur[0].', \'%Y-%m-%d\' ) = "'.$this->proteger($nom_valeur[1]).'"' ; |
| $requete .= 'DATE_FORMAT( '.$nom_valeur[0].', \'%Y-%m-%d\' ) = '.$this->proteger($nom_valeur[1]) ; |
| $requete .= ' AND ' ; |
| } |
| elseif($nom_valeur[0] == "c.ci_id_tampon") |
| 160,15 → 165,15 |
|---|
| } |
| |
| $requete .= ' ('; |
| $requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ; |
| $requete .= $nom_valeur[0].' LIKE '.$this->proteger($nom_valeur[1].'%') ; |
| $requete .= ' OR ' ; |
| $requete .= 'b.nom_sel LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ; |
| $requete .= 'b.nom_sel LIKE '.$this->proteger($nom_valeur[1].'%') ; |
| $requete .= ') AND ' ; |
| |
| } else |
| { |
| $requete .= $nom_valeur[0].' = "'.$this->proteger($nom_valeur[1]) ; |
| $requete .= '" AND ' ; |
| $requete .= $nom_valeur[0].' = '.$this->proteger($nom_valeur[1]) ; |
| $requete .= ' AND ' ; |
| } |
| } |
| } |
| 190,22 → 195,25 |
|---|
| |
| $requete = ' ('; |
| |
| $requete .= 'b.nom_ret LIKE "'.$this->proteger($chaine_requete).'%"' ; |
| $requete .= 'b.nom_ret LIKE '.$this->proteger($chaine_requete.'%') ; |
| $requete .= ' OR ' ; |
| |
| $requete .= 'b.nom_sel LIKE "'.$this->proteger($chaine_requete).'%"' ; |
| $requete .= 'b.nom_sel LIKE '.$this->proteger($chaine_requete.'%') ; |
| $requete .= ' OR ' ; |
| |
| $requete .= 'b.location LIKE "'.$this->proteger($chaine_requete).'%" ' ; |
| $requete .= 'b.location LIKE '.$this->proteger($chaine_requete.'%') ; |
| $requete .= ' OR ' ; |
| |
| $requete .= 'b.id_location LIKE "'.$this->proteger($chaine_requete).'%" ' ; |
| $requete .= 'b.id_location LIKE '.$this->proteger($chaine_requete.'%') ; |
| $requete .= ' OR ' ; |
| |
| $requete .= $this->creerSousRequeteMotsCles($chaine_requete); |
| $requete .= ' OR ' ; |
| $requete_mots_cles .= $this->creerSousRequeteMotsCles($chaine_requete); |
| if(trim($requete_mots_cles) != '') { |
| $requete .= $requete_mots_cles; |
| $requete .= ' OR ' ; |
| } |
| |
| $requete .= 'c.ci_ce_utilisateur LIKE "'.$this->proteger($chaine_requete).'%" ' ; |
| $requete .= 'c.ci_ce_utilisateur LIKE '.$this->proteger($chaine_requete.'%') ; |
| |
| $requete .= ') '; |
| |
| 233,7 → 241,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); |
| 249,7 → 257,7 |
|---|
| } |
| } |
| } |
| $requete = rtrim($requete,' OR ').' AND '; |
| $requete = rtrim($requete,' OR '); |
| return $requete; |
| } |
| |
| 256,7 → 264,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 '; |