49,13 → 49,13 |
$p = $this->pretraiterParametresUrl($param); |
|
$fromClause = $whereClause = $joinClause = array(); |
self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause). |
self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause); |
|
// Construction de la requête |
$requete = sprintf( |
'SELECT %s cs_id_structure, cs_ville, cs_nom, cs_code_postal, cs_latitude, cs_longitude, cc_id_collection, cc_nom' |
. ' FROM %s %s' |
. ' WHERE %s ORDER BY %s LIMIT %d, %d -- %s:%d', |
. ' WHERE %s ORDER BY %s %s -- %s:%d', |
|
$this->distinct ? 'DISTINCT' : '', |
|
64,7 → 64,8 |
|
$whereClause ? implode(" AND ", $whereClause) : TRUE, |
is_null($this->orderby) ? 'cs_ville ASC, cs_nom ASC, cc_nom ASC' : $this->orderby, |
$this->start, $this->limit, |
|
$this->limit != -1 ? "LIMIT {$this->start}, {$this->limit}" : "", |
__FILE__, __LINE__); |
|
|
97,7 → 98,7 |
$p = $this->pretraiterParametresUrl($param); |
|
$fromClause = $whereClause = $joinClause = array(); |
self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause). |
self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause); |
|
// Construction de la requête |
// Il est important de compter le nombre d'association structure-collection différentes pour obtenir le bon nombre |