WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/InventoryImageListPublic.php


<?php
 
class InventoryImageListPublic extends Cel {
		
	private $criteres = array('tag' => 'c.ci_meta_mots_cles', 
							'auteur' => 'c.ci_ce_utilisateur', 
							'commune' => 'b.location', 
							'dept' => 'b.id_location',
							'taxon' => 'b.nom_ret');
 
	function InventoryImageListPublic($config) {
		
		parent::__construct($config);
		
		$this->start = 0;
		$this->limit = 100;
		$this->distinct = true;
	}
 
	function getRessource() {
	
	}
 
	function getElement($uid)
	{				
		$criteres = array() ;
		
		if($uid[0] == '*') {		
			$criteres = array();		
		} else {
			
			if(!$this->estUneRechercheGenerale()) {
 
				$criteres = $this->traiterCriteres($_GET);
				
				if(empty($criteres)) {
					header("content-type: text/html");
					$images_json = json_encode(array());
					print $images_json;
					exit() ;
				}				
			}
		}
		
		if(isset($_GET['start'])) {
			$this->start = $_GET['start'];
		}
		
		if(isset($_GET['limit'])) {
			$this->limit = $_GET['limit'];
		}
		
		
		// Construction de la requête
		$requete_debut = 'SELECT * ';
		
		$requete_nb = 'SELECT COUNT(*) as nb_res ';
		
		$jointure = 'FROM cel_obs_images a '.
			'INNER JOIN cel_inventory b '.
				'ON a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant '.
			'INNER JOIN cel_images c '.
				'ON a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur '.  
			'WHERE b.transmission = 1 AND b.identifiant = c.ci_ce_utilisateur AND ';
		
		$requete_debut .= $jointure;
		$requete_nb .= $jointure;
		
		if($this->estUneRechercheGenerale()) {
			$chaine_requete = $_GET['recherche'];
			$requete = $this->creerSousRequeteRechercheGenerale($chaine_requete) ;
		} else {
			$criteres = $this->traiterCriteres($_GET) ;
			$requete = $this->creerSousRequeteRechercheParCriteres($criteres);
		}
	
		$requete_debut .= $requete;
		$requete_nb .= $requete;
			
		$requete_debut = rtrim($requete_debut,'AND ');
		$requete_nb = rtrim($requete_nb,'AND ');
		
		$requete_debut .= ' ORDER BY c.ci_meta_date_ajout DESC ';	
		$requete_debut .= "LIMIT $this->start,$this->limit ";
		
		$res = $this->executerRequete($requete_debut);
        
		$res_nb =& $this->executerRequete($requete_nb);
        
        $images = array();
        
        $total = 0;
        
		foreach ($res as $row) {
	    	$images[]= $row;
	    	$nb_res = $row['nb_res'];
    	}
    	
		foreach ($res_nb as $row) {
	    	$total= $row['nb_res'];
    	}
 
    	$resultat = array('total' => $total,'images' => $images);
    	
		$images_json = json_encode($resultat) ;
		
		$images_json = str_replace('\u0000','',$images_json);
 
		header("content-type: text/html") ;
		print $images_json ;
		exit() ;
	}
	
	private function creerSousRequeteRechercheParCriteres($criteres) {
		
		$requete = '';
		
		foreach($criteres as $pair)
			{
			$nom_valeur = explode("=",$pair) ;
 
			if(sizeof($nom_valeur) != 0)
			{
					if($nom_valeur[0] == "ci_limite")
					{
						$this->limite = $this->proteger($nom_valeur[1]) ;
					}
					elseif($nom_valeur[0] == "c.ci_numero_page")
					{
						$this->start = $this->limite*$this->proteger($nom_valeur[1]) ;
					}
					elseif($nom_valeur[0] == "c.ci_meta_mots_cles")
					{
						$requete .= $this->creerSousRequeteMotsCles($nom_valeur[1]);   
					}
					elseif($nom_valeur[0] == "c.ci_meta_comment")
					{
						$mots_comment_liste = explode(" " , $nom_valeur[1]) ;
 
						foreach($mots_comment_liste as $mot_comment)
						{
							$mot_comment = trim($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 .= ' AND ' ;
					}
					elseif($nom_valeur[0] == "c.ci_id_tampon")
					{
						$ids_tampon = rtrim($nom_valeur[1], ',') ;
						$requete .= 'c.ci_id_image IN ( '.$this->proteger($ids_tampon).')' ;
					}
					elseif($nom_valeur[0] == "b.nom_ret")
					{
						if($nom_valeur[1] == "indetermine") {
							$nom_valeur[1] = 'null';
						}
						
						$requete .= ' (';
						$requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ;
						$requete .= ' OR ' ;
						$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 = rtrim($requete,' AND ') ;
		
		return $requete;
	}
	
	private function creerSousRequeteRechercheGenerale($chaine_requete) {
		
		if(trim($chaine_requete) == '') {
			return '';
		}
		
		$chaine_requete = strtolower($chaine_requete);
		
		$chaine_requete = str_replace(' ','_',$chaine_requete);
		
		$requete = ' (';
	
		$requete .= 'b.nom_ret LIKE "'.$this->proteger($chaine_requete).'%"' ;
		$requete .= ' OR ' ;
		
		$requete .= 'b.nom_sel LIKE "'.$this->proteger($chaine_requete).'%"' ;
		$requete .= ' OR ' ;
 
		$requete .= 'b.location LIKE "'.$this->proteger($chaine_requete).'%" ' ;
		$requete .= ' OR ' ;
		
		$requete .= 'b.id_location LIKE "'.$this->proteger($chaine_requete).'%" ' ;
		$requete .= ' OR ' ;
		
		$requete .= $this->creerSousRequeteMotsCles($chaine_requete);      
		$requete .= ' OR ' ;
		
		$requete .= 'c.ci_ce_utilisateur LIKE "'.$this->proteger($chaine_requete).'%" ' ;
		
		$requete .= ') ';
		
		return $requete;
	}
	
	private function estUneRechercheGenerale() {
		return isset($_GET['recherche']);
	}
	
	private function traiterCriteres($tableau_criteres) {
		
		$tableau_criteres_pour_bdd = array();
				
		foreach($tableau_criteres as $nom_critere => $valeur_critere) {
		
			if(isset($this->criteres[$nom_critere])) {
				$tableau_criteres_pour_bdd[] = $this->criteres[$nom_critere].'='.$valeur_critere;
			}
		}
		
		return $tableau_criteres_pour_bdd;
	}
	
		
	private function creerSousRequeteMotsCles($mot_cle) {
        $requete = '';
        if (preg_match('/.*OU.*/', $mot_cle)) {
            $requete = $this->creerSousRequeteMotsClesOu($mot_cle);
        } else if (preg_match('/.*ET.*/', $mot_cle)) {
            $requete = $this->creerSousRequeteMotsClesEt($mot_cle);
        } else {       
            // Construction de la requête
            $prerequete =   "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where ".
                'cmc_id_mot_cle_general = '.$this->proteger($this->encoderMotCle($mot_cle));
            $elements = $this->executerRequete($prerequete);
            if ($elements != false && count($elements) > 0) {
                foreach ($elements as $occurence) {
                    $requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '.
                        $this->proteger($occurence['cmc_id_proprietaire']).' ) OR '; 
                }
            }
        }
        $requete = rtrim($requete,' OR ').' AND ';
        return $requete;
    }
   
    private function creerSousRequeteMotsClesOu($mot_cle) {
        $requete = '';
       
        $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 ';
        }
        $where = rtrim($where,' OR ');
       
        // Construction de la requête
        $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) {
            foreach ($elements as $occurence) {
                $requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '.
                    $this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';
            }
        }
        return $requete;
    }
	
	private function creerSousRequeteMotsClesEt($mot_cle) {
        $requete = '';
        $where = '';
        $champs = 'a.cmc_id_proprietaire , ';
        $table = '';
        $i = "a"; $j = "a";
       
        $tab_mots_cles = explode("ET", $mot_cle);
        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->proteger($this->encoderMotCle($mot)).' AND ';
            if ($i !== "a") {
                $where .= " $i.cmc_id_proprietaire = ".$j.".cmc_id_proprietaire AND ";
                $j++;
            }
            $i++;
        }
        $where = rtrim($where,' AND '); $champs = rtrim($champs,' , '); $table = rtrim($table,' , ');
       
        // Construction de la requête
        $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 = ' (';
                for ($j = 'a'; $j < $i; $j++) {
                    $requete .= 'ci_meta_mots_cles like "%'.$occurence[$j].'%" AND ';
                }
                $requete .= ' ci_ce_utilisateur = '.$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';
            }
        }
        return $requete;
    } 
}
?>

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/InventoryImageListPublic.php – Rev 761 → 874

Rev 761		Rev 874
1	`<?php`	1	`<?php`
2		-
3	`Class InventoryImageListPublic extends Cel {`	2	`class InventoryImageListPublic extends Cel {`
4		3
5	`private $criteres = array('mots-cles' => 'c.ci_meta_mots_cles',`	4	`private $criteres = array('tag' => 'c.ci_meta_mots_cles',`
6	`'auteur' => 'c.ci_ce_utilisateur',`	5	`'auteur' => 'c.ci_ce_utilisateur',`
7	`'commune' => 'b.location',`	6	`'commune' => 'b.location',`
8	`'dept' => 'b.id_location',`	7	`'dept' => 'b.id_location',`
9	`'taxon' => 'b.nom_ret');`	8	`'taxon' => 'b.nom_ret');`
10		9
11	`function InventoryImageListPublic($config) {`	10	`function InventoryImageListPublic($config) {`
12		11
13	`parent::__construct($config);`	12	`parent::__construct($config);`
14		13
15	`$this->start = 0;`	14	`$this->start = 0;`
16	`$this->limit = 100;`	15	`$this->limit = 100;`
17	`$this->distinct = true;`	16	`$this->distinct = true;`
18	`}`	17	`}`
19		18
20	`function getRessource() {`	19	`function getRessource() {`
21		20
22	`}`	21	`}`
23		22
24	`function getElement($uid)`	23	`function getElement($uid)`
25	`{`	24	`{`
26	`$criteres = array() ;`	25	`$criteres = array() ;`
27		26
28	`if($uid[0] == '*') {`	27	`if($uid[0] == '*') {`
29	`$criteres = array();`	28	`$criteres = array();`
30	`} else {`	29	`} else {`
31		30
32	`if(!$this->estUneRechercheGenerale()) {`	31	`if(!$this->estUneRechercheGenerale()) {`
33		32
34	`$criteres = $this->traiterCriteres($_GET);`	33	`$criteres = $this->traiterCriteres($_GET);`
35		34
36	`if(empty($criteres)) {`	35	`if(empty($criteres)) {`
37	`header("content-type: text/html");`	36	`header("content-type: text/html");`
38	`$images_json = json_encode(array());`	37	`$images_json = json_encode(array());`
39	`print $images_json;`	38	`print $images_json;`
40	`exit() ;`	39	`exit() ;`
41	`}`	40	`}`
42	`}`	41	`}`
43	`}`	42	`}`
44		43
45	`if(isset($_GET['start'])) {`	44	`if(isset($_GET['start'])) {`
46	`$this->start = $_GET['start'];`	45	`$this->start = $_GET['start'];`
47	`}`	46	`}`
48		47
49	`if(isset($_GET['limit'])) {`	48	`if(isset($_GET['limit'])) {`
50	`$this->limit = $_GET['limit'];`	49	`$this->limit = $_GET['limit'];`
51	`}`	50	`}`
-		51
52		52
53	`// Construction de la requête`	53	`// Construction de la requête`
54	`$requete_debut = 'SELECT * ';`	54	`$requete_debut = 'SELECT * ';`
55		55
56	`$requete_nb = 'SELECT COUNT(*) as nb_res ';`	56	`$requete_nb = 'SELECT COUNT(*) as nb_res ';`
57		57
58	`$jointure = 'FROM cel_obs_images a '.`	58	`$jointure = 'FROM cel_obs_images a '.`
59	`'INNER JOIN cel_inventory b '.`	59	`'INNER JOIN cel_inventory b '.`
60	`'ON a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant '.`	60	`'ON a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant '.`
61	`'INNER JOIN cel_images c '.`	61	`'INNER JOIN cel_images c '.`
62	`'ON a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur '.`	62	`'ON a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur '.`
63	`'WHERE b.transmission = 1 AND b.identifiant = c.ci_ce_utilisateur AND ';`	63	`'WHERE b.transmission = 1 AND b.identifiant = c.ci_ce_utilisateur AND ';`
64		64
65	`$requete_debut .= $jointure;`	65	`$requete_debut .= $jointure;`
66	`$requete_nb .= $jointure;`	66	`$requete_nb .= $jointure;`
67		67
68	`if($this->estUneRechercheGenerale()) {`	68	`if($this->estUneRechercheGenerale()) {`
69	`$chaine_requete = $_GET['recherche'];`	69	`$chaine_requete = $_GET['recherche'];`
70	`$requete = $this->creerSousRequeteRechercheGenerale($chaine_requete) ;`	70	`$requete = $this->creerSousRequeteRechercheGenerale($chaine_requete) ;`
71	`} else {`	71	`} else {`
72	`$criteres = $this->traiterCriteres($_GET) ;`	72	`$criteres = $this->traiterCriteres($_GET) ;`
73	`$requete = $this->creerSousRequeteRechercheParCriteres($criteres);`	73	`$requete = $this->creerSousRequeteRechercheParCriteres($criteres);`
74	`}`	74	`}`
75		75
76	`$requete_debut .= $requete;`	76	`$requete_debut .= $requete;`
77	`$requete_nb .= $requete;`	77	`$requete_nb .= $requete;`
78		78
79	`$requete_debut = rtrim($requete_debut,'AND ');`	79	`$requete_debut = rtrim($requete_debut,'AND ');`
80	`$requete_nb = rtrim($requete_nb,'AND ');`	80	`$requete_nb = rtrim($requete_nb,'AND ');`
81		81
82	`$requete_debut .= ' ORDER BY c.ci_meta_date_ajout DESC ';`	82	`$requete_debut .= ' ORDER BY c.ci_meta_date_ajout DESC ';`
83	`$requete_debut .= "LIMIT $this->start,$this->limit ";`	83	`$requete_debut .= "LIMIT $this->start,$this->limit ";`
84		84
85	`$res = $this->executerRequete($requete_debut);`	85	`$res = $this->executerRequete($requete_debut);`
86		86
87	`$res_nb =& $this->executerRequete($requete_nb);`	87	`$res_nb =& $this->executerRequete($requete_nb);`
88		88
89	`$images = array();`	89	`$images = array();`
90		90
91	`$total = 0;`	91	`$total = 0;`
92		92
93	`foreach ($res as $row) {`	93	`foreach ($res as $row) {`
94	`$images[]= $row;`	94	`$images[]= $row;`
95	`$nb_res = $row['nb_res'];`	95	`$nb_res = $row['nb_res'];`
96	`}`	96	`}`
97		97
98	`foreach ($res_nb as $row) {`	98	`foreach ($res_nb as $row) {`
99	`$total= $row['nb_res'];`	99	`$total= $row['nb_res'];`
100	`}`	100	`}`
101		101
102	`$resultat = array('total' => $total,'images' => $images);`	102	`$resultat = array('total' => $total,'images' => $images);`
103		103
104	`$images_json = json_encode($resultat) ;`	104	`$images_json = json_encode($resultat) ;`
105		105
106	`$images_json = str_replace('\u0000','',$images_json);`	106	`$images_json = str_replace('\u0000','',$images_json);`
107		107
108	`header("content-type: text/html") ;`	108	`header("content-type: text/html") ;`
109	`print $images_json ;`	109	`print $images_json ;`
110	`exit() ;`	110	`exit() ;`
111	`}`	111	`}`
112		112
113	`private function creerSousRequeteRechercheParCriteres($criteres) {`	113	`private function creerSousRequeteRechercheParCriteres($criteres) {`
114		114
115	`$requete = '';`	115	`$requete = '';`
116		116
117	`foreach($criteres as $pair)`	117	`foreach($criteres as $pair)`
118	`{`	118	`{`
119	`$nom_valeur = explode("=",$pair) ;`	119	`$nom_valeur = explode("=",$pair) ;`
120		120
121	`if(sizeof($nom_valeur) != 0)`	121	`if(sizeof($nom_valeur) != 0)`
122	`{`	122	`{`
123	`if($nom_valeur[0] == "ci_limite")`	123	`if($nom_valeur[0] == "ci_limite")`
124	`{`	124	`{`
125	`$this->limite = $this->proteger($nom_valeur[1]) ;`	125	`$this->limite = $this->proteger($nom_valeur[1]) ;`
126	`}`	126	`}`
127	`elseif($nom_valeur[0] == "c.ci_numero_page")`	127	`elseif($nom_valeur[0] == "c.ci_numero_page")`
128	`{`	128	`{`
129	`$this->start = $this->limite*$this->proteger($nom_valeur[1]) ;`	129	`$this->start = $this->limite*$this->proteger($nom_valeur[1]) ;`
130	`}`	130	`}`
131	`elseif($nom_valeur[0] == "c.ci_meta_mots_cles")`	131	`elseif($nom_valeur[0] == "c.ci_meta_mots_cles")`
132	`{`	132	`{`
133	`$requete .= $this->creerSousRequeteMotsCles($nom_valeur[1]);`	133	`$requete .= $this->creerSousRequeteMotsCles($nom_valeur[1]);`
134	`}`	134	`}`
135	`elseif($nom_valeur[0] == "c.ci_meta_comment")`	135	`elseif($nom_valeur[0] == "c.ci_meta_comment")`
136	`{`	136	`{`
137	`$mots_comment_liste = explode(" " , $nom_valeur[1]) ;`	137	`$mots_comment_liste = explode(" " , $nom_valeur[1]) ;`
138		138
139	`foreach($mots_comment_liste as $mot_comment)`	139	`foreach($mots_comment_liste as $mot_comment)`
140	`{`	140	`{`
141	`$mot_comment = trim($mot_comment) ;`	141	`$mot_comment = trim($mot_comment) ;`
142	`$requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($mot_comment).'%"' ;`	142	`$requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($mot_comment).'%"' ;`
143	`$requete .= ' AND ' ;`	143	`$requete .= ' AND ' ;`
144	`}`	144	`}`
145	`}`	145	`}`
146	`elseif($nom_valeur[0] == "c.ci_meta_date")`	146	`elseif($nom_valeur[0] == "c.ci_meta_date")`
147	`{`	147	`{`
148	`$requete .= 'DATE_FORMAT( '.$nom_valeur[0].', \'%Y-%m-%d\' ) = "'.$this->proteger($nom_valeur[1]).'"' ;`	148	`$requete .= 'DATE_FORMAT( '.$nom_valeur[0].', \'%Y-%m-%d\' ) = "'.$this->proteger($nom_valeur[1]).'"' ;`
149	`$requete .= ' AND ' ;`	149	`$requete .= ' AND ' ;`
150	`}`	150	`}`
151	`elseif($nom_valeur[0] == "c.ci_id_tampon")`	151	`elseif($nom_valeur[0] == "c.ci_id_tampon")`
152	`{`	152	`{`
153	`$ids_tampon = rtrim($nom_valeur[1], ',') ;`	153	`$ids_tampon = rtrim($nom_valeur[1], ',') ;`
154	`$requete .= 'c.ci_id_image IN ( '.$this->proteger($ids_tampon).')' ;`	154	`$requete .= 'c.ci_id_image IN ( '.$this->proteger($ids_tampon).')' ;`
155	`}`	155	`}`
156	`elseif($nom_valeur[0] == "b.nom_ret")`	156	`elseif($nom_valeur[0] == "b.nom_ret")`
157	`{`	157	`{`
158	`if($nom_valeur[1] == "indetermine") {`	158	`if($nom_valeur[1] == "indetermine") {`
159	`$nom_valeur[1] = 'null';`	159	`$nom_valeur[1] = 'null';`
160	`}`	160	`}`
161		161
162	`$requete .= ' (';`	162	`$requete .= ' (';`
163	`$requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ;`	163	`$requete .= $nom_valeur[0].' LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ;`
164	`$requete .= ' OR ' ;`	164	`$requete .= ' OR ' ;`
165	`$requete .= 'b.nom_sel LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ;`	165	`$requete .= 'b.nom_sel LIKE "%'.$this->proteger($nom_valeur[1]).'%"' ;`
166	`$requete .= ') AND ' ;`	166	`$requete .= ') AND ' ;`
167		167
168	`} else`	168	`} else`
169	`{`	169	`{`
170	`$requete .= $nom_valeur[0].' = "'.$this->proteger($nom_valeur[1]) ;`	170	`$requete .= $nom_valeur[0].' = "'.$this->proteger($nom_valeur[1]) ;`
171	`$requete .= '" AND ' ;`	171	`$requete .= '" AND ' ;`
172	`}`	172	`}`
173	`}`	173	`}`
174	`}`	174	`}`
175		175
176	`$requete = rtrim($requete,' AND ') ;`	176	`$requete = rtrim($requete,' AND ') ;`
177		177
178	`return $requete;`	178	`return $requete;`
179	`}`	179	`}`
180		180
181	`private function creerSousRequeteRechercheGenerale($chaine_requete) {`	181	`private function creerSousRequeteRechercheGenerale($chaine_requete) {`
182		182
183	`if(trim($chaine_requete) == '') {`	183	`if(trim($chaine_requete) == '') {`
184	`return '';`	184	`return '';`
185	`}`	185	`}`
186		186
187	`$chaine_requete = strtolower($chaine_requete);`	187	`$chaine_requete = strtolower($chaine_requete);`
188		188
189	`$chaine_requete = str_replace(' ','_',$chaine_requete);`	189	`$chaine_requete = str_replace(' ','_',$chaine_requete);`
190		190
191	`$requete = ' (';`	191	`$requete = ' (';`
192		192
193	`$requete .= 'b.nom_ret LIKE "'.$this->proteger($chaine_requete).'%"' ;`	193	`$requete .= 'b.nom_ret LIKE "'.$this->proteger($chaine_requete).'%"' ;`
194	`$requete .= ' OR ' ;`	194	`$requete .= ' OR ' ;`
195		195
196	`$requete .= 'b.nom_sel LIKE "'.$this->proteger($chaine_requete).'%"' ;`	196	`$requete .= 'b.nom_sel LIKE "'.$this->proteger($chaine_requete).'%"' ;`
197	`$requete .= ' OR ' ;`	197	`$requete .= ' OR ' ;`
198		198
199	`$requete .= 'b.location LIKE "'.$this->proteger($chaine_requete).'%" ' ;`	199	`$requete .= 'b.location LIKE "'.$this->proteger($chaine_requete).'%" ' ;`
200	`$requete .= ' OR ' ;`	200	`$requete .= ' OR ' ;`
201		201
202	`$requete .= 'b.id_location LIKE "'.$this->proteger($chaine_requete).'%" ' ;`	202	`$requete .= 'b.id_location LIKE "'.$this->proteger($chaine_requete).'%" ' ;`
203	`$requete .= ' OR ' ;`	203	`$requete .= ' OR ' ;`
204		204
205	`$requete .= $this->creerSousRequeteMotsCles($chaine_requete);`	205	`$requete .= $this->creerSousRequeteMotsCles($chaine_requete);`
206	`$requete .= ' OR ' ;`	206	`$requete .= ' OR ' ;`
207		207
208	`$requete .= 'c.ci_ce_utilisateur LIKE "'.$this->proteger($chaine_requete).'%" ' ;`	208	`$requete .= 'c.ci_ce_utilisateur LIKE "'.$this->proteger($chaine_requete).'%" ' ;`
209		209
210	`$requete .= ') ';`	210	`$requete .= ') ';`
211		211
212	`return $requete;`	212	`return $requete;`
213	`}`	213	`}`
214		214
215	`private function estUneRechercheGenerale() {`	215	`private function estUneRechercheGenerale() {`
216	`return isset($_GET['recherche']);`	216	`return isset($_GET['recherche']);`
217	`}`	217	`}`
218		218
219	`private function traiterCriteres($tableau_criteres) {`	219	`private function traiterCriteres($tableau_criteres) {`
220		220
221	`$tableau_criteres_pour_bdd = array();`	221	`$tableau_criteres_pour_bdd = array();`
222		222
223	`foreach($tableau_criteres as $nom_critere => $valeur_critere) {`	223	`foreach($tableau_criteres as $nom_critere => $valeur_critere) {`
224		224
225	`if(isset($this->criteres[$nom_critere])) {`	225	`if(isset($this->criteres[$nom_critere])) {`
226	`$tableau_criteres_pour_bdd[] = $this->criteres[$nom_critere].'='.$valeur_critere;`	226	`$tableau_criteres_pour_bdd[] = $this->criteres[$nom_critere].'='.$valeur_critere;`
227	`}`	227	`}`
228	`}`	228	`}`
229		229
230	`return $tableau_criteres_pour_bdd;`	230	`return $tableau_criteres_pour_bdd;`
231	`}`	231	`}`
232		232
233		233
234	`private function creerSousRequeteMotsCles($mot_cle) {`	234	`private function creerSousRequeteMotsCles($mot_cle) {`
235	`$requete = '';`	235	`$requete = '';`
236	`if (preg_match('/.,./', $mot_cle)) {`	236	`if (preg_match('/.OU./', $mot_cle)) {`
237	`$requete = $this->creerSousRequeteMotsClesOu($mot_cle);`	237	`$requete = $this->creerSousRequeteMotsClesOu($mot_cle);`
238	`} else if (preg_match('/.ET./', $mot_cle)) {`	238	`} else if (preg_match('/.ET./', $mot_cle)) {`
239	`$requete = $this->creerSousRequeteMotsClesEt($mot_cle);`	239	`$requete = $this->creerSousRequeteMotsClesEt($mot_cle);`
240	`} else {`	240	`} else {`
241	`// Construction de la requête`	241	`// Construction de la requête`
242	`$prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where ".`	242	`$prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where ".`
243	`'cmc_id_mot_cle_general = '.$this->proteger($this->encoderMotCle($mot_cle));`	243	`'cmc_id_mot_cle_general = '.$this->proteger($this->encoderMotCle($mot_cle));`
244	`$elements = $this->executerRequete($prerequete);`	244	`$elements = $this->executerRequete($prerequete);`
245	`if ($elements != false && count($elements) > 0) {`	245	`if ($elements != false && count($elements) > 0) {`
246	`foreach ($elements as $occurence) {`	246	`foreach ($elements as $occurence) {`
247	`$requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '.`	247	`$requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '.`
248	`$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';`	248	`$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';`
249	`}`	249	`}`
250	`}`	250	`}`
251	`}`	251	`}`
252	`$requete = rtrim($requete,' OR ').' AND ';`	252	`$requete = rtrim($requete,' OR ').' AND ';`
253	`return $requete;`	253	`return $requete;`
254	`}`	254	`}`
255		255
256	`private function creerSousRequeteMotsClesOu($mot_cle) {`	256	`private function creerSousRequeteMotsClesOu($mot_cle) {`
257	`$requete = '';`	257	`$requete = '';`
258		258
259	`$tab_mots_cles = explode(',', $mot_cle);`	259	`$tab_mots_cles = explode('OU', $mot_cle);`
260	`$where = '';`	260	`$where = '';`
261	`foreach ($tab_mots_cles as $mot) {`	261	`foreach ($tab_mots_cles as $mot) {`
262	`$where .= 'cmc_id_mot_cle_general = '.$this->proteger($this->encoderMotCle($mot)).' OR ';`	262	`$where .= 'cmc_id_mot_cle_general = '.$this->proteger($this->encoderMotCle($mot)).' OR ';`
263	`}`	263	`}`
264	`$where = rtrim($where,' OR ');`	264	`$where = rtrim($where,' OR ');`
265		265
266	`// Construction de la requête`	266	`// Construction de la requête`
267	`$prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where ";`	267	`$prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where ";`
268	`$elements = $this->executerRequete($prerequete);//print_r($elements);`	268	`$elements = $this->executerRequete($prerequete);//print_r($elements);`
269	`if ($elements != false && count($elements) > 0) {`	269	`if ($elements != false && count($elements) > 0) {`
270	`foreach ($elements as $occurence) {`	270	`foreach ($elements as $occurence) {`
271	`$requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '.`	271	`$requete .= '(ci_meta_mots_cles LIKE "%'.$occurence['cmc_id_mot_cle_utilisateur'].'%" AND ci_ce_utilisateur = '.`
272	`$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';`	272	`$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';`
273	`}`	273	`}`
274	`}`	274	`}`
275	`return $requete;`	275	`return $requete;`
276	`}`	276	`}`
277		277
278	`private function creerSousRequeteMotsClesEt($mot_cle) {`	278	`private function creerSousRequeteMotsClesEt($mot_cle) {`
279	`$requete = '';`	279	`$requete = '';`
280	`$where = '';`	280	`$where = '';`
281	`$champs = 'a.cmc_id_proprietaire , ';`	281	`$champs = 'a.cmc_id_proprietaire , ';`
282	`$table = '';`	282	`$table = '';`
283	`$i = "a"; $j = "a";`	283	`$i = "a"; $j = "a";`
284		284
285	`$tab_mots_cles = explode("ET", $mot_cle);`	285	`$tab_mots_cles = explode("ET", $mot_cle);`
286	`foreach ($tab_mots_cles as $mot) {`	286	`foreach ($tab_mots_cles as $mot) {`
287	`$champs .= "$i.cmc_id_mot_cle_utilisateur as $i , ";`	287	`$champs .= "$i.cmc_id_mot_cle_utilisateur as $i , ";`
288	`$table .= "cel_mots_cles_images $i , ";`	288	`$table .= "cel_mots_cles_images $i , ";`
289	`$where .= "$i.cmc_id_mot_cle_general = ".$this->proteger($this->encoderMotCle($mot)).' AND ';`	289	`$where .= "$i.cmc_id_mot_cle_general = ".$this->proteger($this->encoderMotCle($mot)).' AND ';`
290	`if ($i !== "a") {`	290	`if ($i !== "a") {`
291	`$where .= " $i.cmc_id_proprietaire = ".$j.".cmc_id_proprietaire AND ";`	291	`$where .= " $i.cmc_id_proprietaire = ".$j.".cmc_id_proprietaire AND ";`
292	`$j++;`	292	`$j++;`
293	`}`	293	`}`
294	`$i++;`	294	`$i++;`
295	`}`	295	`}`
296	`$where = rtrim($where,' AND '); $champs = rtrim($champs,' , '); $table = rtrim($table,' , ');`	296	`$where = rtrim($where,' AND '); $champs = rtrim($champs,' , '); $table = rtrim($table,' , ');`
297		297
298	`// Construction de la requête`	298	`// Construction de la requête`
299	`$prerequete = "SELECT $champs FROM $table WHERE $where ";`	299	`$prerequete = "SELECT $champs FROM $table WHERE $where ";`
300	`$elements = $this->executerRequete($prerequete);//print_r($elements);`	300	`$elements = $this->executerRequete($prerequete);//print_r($elements);`
301	`if ($elements != false && count($elements) > 0) {`	301	`if ($elements != false && count($elements) > 0) {`
302	`foreach ($elements as $occurence) {`	302	`foreach ($elements as $occurence) {`
303	`$requete = ' (';`	303	`$requete = ' (';`
304	`for ($j = 'a'; $j < $i; $j++) {`	304	`for ($j = 'a'; $j < $i; $j++) {`
305	`$requete .= 'ci_meta_mots_cles like "%'.$occurence[$j].'%" AND ';`	305	`$requete .= 'ci_meta_mots_cles like "%'.$occurence[$j].'%" AND ';`
306	`}`	306	`}`
307	`$requete .= ' ci_ce_utilisateur = '.$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';`	307	`$requete .= ' ci_ce_utilisateur = '.$this->proteger($occurence['cmc_id_proprietaire']).' ) OR ';`
308	`}`	308	`}`
309	`}`	309	`}`
310	`return $requete;`	310	`return $requete;`
311	`}`	311	`}`
312	`}`	312	`}`
313	`?>`	313	`?>`