| 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 %s -- %s:%d', |
| . ' WHERE %s ORDER BY %s LIMIT %d, %d -- %s:%d', |
| |
| $this->distinct ? 'DISTINCT' : '', |
| |
| 64,8 → 64,7 |
|---|
| |
| $whereClause ? implode(" AND ", $whereClause) : TRUE, |
| is_null($this->orderby) ? 'cs_ville ASC, cs_nom ASC, cc_nom ASC' : $this->orderby, |
| |
| $this->limit != -1 ? "LIMIT {$this->start}, {$this->limit}" : "", |
| $this->start, $this->limit, |
| __FILE__, __LINE__); |
| |
| |
| 98,7 → 97,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 |