WebSVN – eFlore/Applications.cel – Diff – /branches/v1.5-cisaille/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',
							'famille' => 'b.famille');
 
	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_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")
					{
						$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 .= 'b.famille LIKE '.$this->proteger($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 .= ') ';
		
		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 ');
        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)/branches/v1.5-cisaille/jrest/services/InventoryImageListPublic.php @ 1134 – Rev 889 → 1362

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