Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1506 Rev 1550
Line 396... Line 396...
396 
	}
 396 
	}
Line 397... Line 397...
397 
 
 397 
 
398 
	private function getServiceMultiCriteres() {
 398 
	private function getServiceMultiCriteres() {
399 
		$contenu = '';
 399 
		$contenu = '';
400 
		if (isset($_GET['debut'])) $this->start = $_GET['debut'];
 400 
		if (isset($_GET['debut'])) $this->start = $_GET['debut'];
- 
 
 401 
		if (isset($_GET['limite'])) $this->limit = $_GET['limite'];
- 
 
 402
Line 401... Line 403...
401 
		if (isset($_GET['limite'])) $this->limite = $_GET['limite'];
 403 
		$this->limit = ($this->limit < 1000) ? $this->limit : 1000;// Pour éviter les abus !
402 
 
 404 
 
403 
		if ($this->parametresSontDemandes()) {
 405 
		if ($this->parametresSontDemandes()) {
404 
			$requete = $this->creerRequeteAvecParametres();
 406 
			$requete = $this->creerRequeteAvecParametres();
Line 480... Line 482...
480 
		$requete = '';
 482 
		$requete = '';
481 
		foreach ($criteres as $pair) {
 483 
		foreach ($criteres as $pair) {
482 
			$nom_valeur = explode("=",$pair);
 484 
			$nom_valeur = explode("=",$pair);
483 
			if (sizeof($nom_valeur) != 0) {
 485 
			if (sizeof($nom_valeur) != 0) {
484 
				switch ($nom_valeur[0]) {
 486 
				switch ($nom_valeur[0]) {
485 
					case "ci_limite" : $this->limite = $this->bdd->quote($nom_valeur[1]); break;
 487 
					case "ci_limite" : $this->limit = $this->bdd->quote($nom_valeur[1]); break;
486 
					case "c.ci_numero_page" : $this->limite*$this->bdd->quote($nom_valeur[1]); break;
 488 
					case "c.ci_numero_page" : $this->limit*$this->bdd->quote($nom_valeur[1]); break;
487 
					case "c.commentaire" : $mots_comment_liste = explode(" " , $nom_valeur[1]);
 489 
					case "c.commentaire" : $mots_comment_liste = explode(" " , $nom_valeur[1]);
488 
						foreach($mots_comment_liste as $mot_comment) {
 490 
						foreach($mots_comment_liste as $mot_comment) {
489 
							$mot_comment = trim($mot_comment) ;
 491 
							$mot_comment = trim($mot_comment) ;
490 
							$requete .= $nom_valeur[0].' LIKE '.$this->bdd->quote('%'.$mot_comment.'%').' AND ';
 492 
							$requete .= $nom_valeur[0].' LIKE '.$this->bdd->quote('%'.$mot_comment.'%').' AND ';
491 
						}
 493 
						}