Subversion Repositories Applications.referentiel

Rev

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

Rev 242 Rev 251
Line 85... Line 85...
85
		$p = $this->pretraiterParametresUrl($param);
85
		$p = $this->pretraiterParametresUrl($param);
86
		$referentiel = substr($p['ref'], 2, -2); 
86
		$referentiel = substr($p['ref'], 2, -2); 
Line 87... Line 87...
87
		
87
		
88
		// Construction de la requête		
88
		// Construction de la requête		
89
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' num_nom, nom_sci, auteur, annee, '.
89
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' num_nom, nom_sci, auteur, annee, '.
-
 
90
				'biblio_origine, nom_addendum, num_nom_retenu, presence, exclure_taxref'.
90
				'biblio_origine, nom_addendum, num_nom_retenu, presence FROM '.$referentiel.$this->construireWhere($p).
91
				' FROM '.$referentiel.$this->construireWhere($p).
91
				'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'num_nom ASC, nom_sci ASC').' '.
92
				'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'num_nom ASC, nom_sci ASC').' '.
Line 92... Line 93...
92
				"LIMIT $this->start, $this->limit ";
93
				"LIMIT $this->start, $this->limit ";
93
					
94