Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1581 Rev 1646
Line 50... Line 50...
50 
		// Pré traitement des paramêtres
 50 
		// Pré traitement des paramêtres
51 
		$p = $this->pretraiterParametresUrl($param);
 51 
		$p = $this->pretraiterParametresUrl($param);
Line 52... Line 52...
52
52
53 
		// Construction de la requête
 53 
		// Construction de la requête
54 
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' cs_id_structure, cs_ville, cs_nom, '.
 54 
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' cs_id_structure, cs_ville, cs_nom, '.
55 
					'	cc_id_collection, cc_nom '.
 55 
					'cs_code_postal, cs_latitude, cs_longitude, cc_id_collection, cc_nom '.
56 
					$this->construireFromEtWhere($p).
 56 
					$this->construireFromEtWhere($p).
57 
					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'cs_ville ASC, cs_nom ASC, cc_nom ASC').' '.
 57 
					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'cs_ville ASC, cs_nom ASC, cc_nom ASC').' '.
Line 58... Line 58...
58 
					"LIMIT $this->start, $this->limit ";
 58 
					"LIMIT $this->start, $this->limit ";