Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 1151 | Rev 1153 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1151 Rev 1152
Line 191... Line 191...
191 
				'IF(ISNULL(nom_es), 0, 1) as nom_es_present, '.
 191 
				'IF(ISNULL(nom_es), 0, 1) as nom_es_present, '.
192 
				'IF(ISNULL(intitule), 0, 1) as intitule_present, '.
 192 
				'IF(ISNULL(intitule), 0, 1) as intitule_present, '.
193 
				'IF(ISNULL(nom), 0, 1) as nom_present ';
 193 
				'IF(ISNULL(nom), 0, 1) as nom_present ';
Line 194... Line 194...
194
194
195 
		$ordre = 'nom_present DESC, nom_fr_present DESC, nom_fr_present DESC, '.
 195 
		$ordre = 'nom_present DESC, nom_fr_present DESC, nom_fr_present DESC, '.
Line 196... Line 196...
196 
				 'nom_es_present DESC, intitule_present DESC, niveau DESC';
 196 
				 'nom_es_present DESC, intitule_present DESC, niveau ASC';
197
197
198 
		$niveau_str = array();
 198 
		$niveau_str = array();
199 
		if($niveaux != null) {
 199 
		if($niveaux != null) {
Line 214... Line 214...
214 
						(!empty($pays_str) ? $pays_str.' AND ' : "").
214 
						(!empty($pays_str) ? $pays_str.' AND ' : "").
215 
						"(nom LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
 215 
						"(nom LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
216 
						"intitule LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
 216 
						"intitule LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
217 
						"nom_fr LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
 217 
						"nom_fr LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
218 
						"nom_en LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
 218 
						"nom_en LIKE ".$this->bdd->proteger($masque_fmt).' OR '.
219 
						"nom_es LIKE ".$this->bdd->proteger($masque_fmt).') AND '.
219 
						"nom_es LIKE ".$this->bdd->proteger($masque_fmt).') '.
220 
			"ORDER BY ".$ordre." LIMIT ".$limite;
 220 
			"ORDER BY ".$ordre." LIMIT ".$limite;
Line 221... Line 221...
221 
 
 221 
 
222 
		$resultat = $this->bdd->recupererTous($requete);
 222 
		$resultat = $this->bdd->recupererTous($requete);
223 
		if (empty($resultat)) {
 223 
		if (empty($resultat)) {