Subversion Repositories eFlore/Applications.cel

Rev

Rev 1366 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1366 Rev 1386
Line 53... Line 53...
53 
		$requete_recherche_images .= $sous_requete_recherche;
 53 
		$requete_recherche_images .= $sous_requete_recherche;
Line 54... Line 54...
54
54
Line 55... Line 55...
55 
		$requete_recherche_images .= ' ORDER BY ci.ordre LIMIT '.$debut.','.$limite ;
 55 
		$requete_recherche_images .= ' ORDER BY ci.ordre LIMIT '.$debut.','.$limite ;
56 
 
 56 
 
Line 57... Line 57...
57 
		$resultats_images = array();
 57 
		$resultats_images = array();
58 
		$resultats_images = $this->requeter($requete_recherche_images);
 58 
		$resultats_images = $this->executerRequete($requete_recherche_images);
Line 59... Line 59...
59
59
Line 76... Line 76...
76 
		$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
 76 
		$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
Line 77... Line 77...
77
77
78 
		$requete_recherche_images .= $sous_requete_recherche;
 78 
		$requete_recherche_images .= $sous_requete_recherche;
Line 79... Line 79...
79 
		$nb_images = 0;
 79 
		$nb_images = 0;
Line 80... Line 80...
80 
 
 80 
 
81 
		$resultat_requete_nombre_images = $this->requeter($requete_recherche_images);
 81 
		$resultat_requete_nombre_images = $this->executerRequete($requete_recherche_images);
82
82
Line 106... Line 106...
106
106
Line 107... Line 107...
107 
	public function obtenirInformationsObservationsAssociees($id_utilisateur, $id_image) {
 107 
	public function obtenirInformationsObservationsAssociees($id_utilisateur, $id_image) {
Line 108... Line 108...
108
108
Line 109... Line 109...
109 
		$requete_table_liaison = 'SELECT id_observation FROM cel_obs_images WHERE id_image = '.$id_image;
 109 
		$requete_table_liaison = 'SELECT id_observation FROM cel_obs_images WHERE id_image = '.$id_image;
Line 110... Line 110...
110
110
111 
		$resultats_liaisons_images = $this->requeter($requete_table_liaison);
 111 
		$resultats_liaisons_images = $this->executerRequete($requete_table_liaison);
Line 118... Line 118...
118 
		$ids_obs = rtrim($ids_obs,',');
118 
		$ids_obs = rtrim($ids_obs,',');
119 
		$infos_obs = '';
 119 
		$infos_obs = '';
Line 120... Line 120...
120 
 
 120 
 
121 
		if(trim($ids_obs) != '') {
 121 
		if(trim($ids_obs) != '') {
122 
			$requete_obs_liees = 'SELECT * FROM cel_obs WHERE id_observation IN  ('.$ids_obs.') AND ce_utilisateur ="'.$id_utilisateur.'"';
 122 
			$requete_obs_liees = 'SELECT * FROM cel_obs WHERE id_observation IN  ('.$ids_obs.') AND ce_utilisateur ="'.$id_utilisateur.'"';
Line 123... Line 123...
123 
			$resultat_obs_liees = $this->requeter($requete_obs_liees);
 123 
			$resultat_obs_liees = $this->executerRequete($requete_obs_liees);
124 
 
 124 
 
125 
			foreach($resultat_obs_liees as $obs_liee)
 125 
			foreach($resultat_obs_liees as $obs_liee)
126 
			{
 126 
			{
Line 142... Line 142...
142 
			}
 142 
			}
Line 143... Line 143...
143
143
Line 144... Line 144...
144 
			switch($nom) {
 144 
			switch($nom) {
145
145
146 
				case "mots_cles";
 146 
				case "mots_cles";
Line 147... Line 147...
147 
					$sous_requete .= 'ci.mots_cles_texte LIKE '.$this->proteger('%'.$valeur.'%').' AND ';
147 
					$sous_requete .= $this->creerSousRequeteMotsCles($valeur);
148 
				break;
 148 
				break;
149
149
Line 276... Line 276...
276 
		}
 276 
		}
Line 277... Line 277...
277
277
278 
		return $requete_recherche_date;
 278 
		return $requete_recherche_date;
Line 279... Line -...
279 
	}
 - 
 
280
279 
	}
281 
   	//TODO a refaire
 280
- 
 
 281 
	private function creerSousRequeteMotsCles($mot_cle) {
- 
 
 282 
	$requete = '';
- 
 
 283 
		if (preg_match('/.*OU.*/', $mot_cle)) {
- 
 
 284 
			$mots_cles_tab = explode('OU',$mot_cle);
282 
    private function fabriquerSousRequeteMotsClesOu($mot_cle) {
 285 
			foreach($mots_cles_tab as $mot_cle_item) {
- 
 
 286 
				$requete .= '(ci.mots_cles_texte LIKE '.$this->proteger('%'.$mot_cle_item.'%').') OR ';
- 
 
 287 
			}
- 
 
 288 
			$requete = '('.rtrim($requete,'OR ').')';
- 
 
 289 
		} else if (preg_match('/.*ET.*/', $mot_cle)) {
- 
 
 290 
			$mots_cles_tab = explode('ET',$mot_cle);
283
291 
			foreach($mots_cles_tab as $mot_cle_item) {
- 
 
 292 
				$requete .= '(ci.mots_cles_texte LIKE '.$this->proteger('%'.$mot_cle_item.'%').') AND ';
284 
    }
 293 
			}
285
294 
			$requete = '('.rtrim($requete, 'AND ').') ';
286 
	//TODO a refaire
 295 
		} else {
- 
 
 296 
			$requete = "(ci.mots_cles_texte LIKE ".$this->proteger('%'.$mot_cle.'%').') ';
287 
	private function fabriquerSousRequeteMotsClesEt($mot_cle) {
 297 
		}
Line 288... Line 298...
288
298 
		return $requete;
289 
    }
 299 
	}
290 
 
 300 
 
291 
    public function formaterPourEnvoiCel($tableau_images) {
 301 
    public function formaterPourEnvoiCel($tableau_images) {
Line 306... Line 316...
306
316
307 
    	$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_image '.
 317 
    	$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_image '.
308 
    									   'FROM cel_images_mots_cles '.
 318 
    									   'FROM cel_images_mots_cles '.
Line 309... Line 319...
309 
    									   'WHERE id_image = '.$id_image;
319 
    									   'WHERE id_image = '.$id_image;
310
320
Line 311... Line 321...
311 
    	return $this->requeter($requete_selection_mots_cles);
 321 
    	return $this->executerRequete($requete_selection_mots_cles);
312 
    }
 322 
    }