Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1698 Rev 1699
Line 47... Line 47...
47
47
48 
		// Pré traitement des paramêtres
 48 
		// Pré traitement des paramêtres
Line 49... Line 49...
49 
		$p = $this->pretraiterParametresUrl($param);
 49 
		$p = $this->pretraiterParametresUrl($param);
50 
 
 50 
 
51 
        $fromClause = $whereClause = $joinClause = array();
 51 
        $fromClause = $whereClause = $joinClause = array();
52 
        self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause).
 52 
        self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause);
53
53 
 
54 
		// Construction de la requête
 54 
		// Construction de la requête
55 
		$requete = sprintf(
 55 
		$requete = sprintf(
56 
            'SELECT %s cs_id_structure, cs_ville, cs_nom, cs_code_postal, cs_latitude, cs_longitude, cc_id_collection, cc_nom'
 56 
            'SELECT %s cs_id_structure, cs_ville, cs_nom, cs_code_postal, cs_latitude, cs_longitude, cc_id_collection, cc_nom'
Line 57... Line 57...
57 
            . ' FROM %s %s'
 57 
            . ' FROM %s %s'
Line 58... Line 58...
58 
            . ' WHERE %s ORDER BY %s LIMIT %d, %d -- %s:%d',
 58 
            . ' WHERE %s ORDER BY %s %s -- %s:%d',
59 
 
 59 
 
Line 60... Line 60...
60 
            $this->distinct ? 'DISTINCT' : '',
 60 
            $this->distinct ? 'DISTINCT' : '',
61 
 
 61 
 
- 
 
 62 
            implode(',', $fromClause),
62 
            implode(',', $fromClause),
 63 
            implode(' ', $joinClause),
63 
            implode(' ', $joinClause),
 64 
 
Line 64... Line 65...
64 
 
 65 
            $whereClause ? implode(" AND ", $whereClause) : TRUE,
65 
            $whereClause ? implode(" AND ", $whereClause) : TRUE,
 66 
            is_null($this->orderby) ? 'cs_ville ASC, cs_nom ASC, cc_nom ASC' : $this->orderby,
Line 95... Line 96...
95
96
96 
		// Pré traitement des paramêtres
 97 
		// Pré traitement des paramêtres
Line 97... Line 98...
97 
		$p = $this->pretraiterParametresUrl($param);
 98 
		$p = $this->pretraiterParametresUrl($param);
98 
 
 99 
 
Line 99... Line 100...
99 
        $fromClause = $whereClause = $joinClause = array();
 100 
        $fromClause = $whereClause = $joinClause = array();
100 
        self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause).
 101 
        self::construireFromEtWhere($p, $fromClause, $joinClause, $whereClause);
101 
 
 102 
 
102 
		// Construction de la requête
 103 
		// Construction de la requête