Subversion Repositories Sites.obs-saisons.fr

Rev

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

Rev 207 Rev 210
Line 121... Line 121...
121 
    								    'WHERE oe_id_espece IN '.
 121 
    								    'WHERE oe_id_espece IN '.
122 
    								    	'( '.
 122 
    								    	'( '.
123 
    								   			'SELECT oi_ce_espece FROM ods_individus '.
123 
    								   			'SELECT oi_ce_espece FROM ods_individus '.
124 
    								   				'WHERE oi_ce_station = '.$this->proteger($id_station).
 124 
    								   				'WHERE oi_ce_station = '.$this->proteger($id_station).
125 
    										') '.
 125 
    										') '.
126 
    									'ORDER BY oe_ce_type';
 126 
    									'ORDER BY oe_ce_type, oe_nom_vernaculaire';
Line 127... Line 127...
127 
 
 127 
 
Line 128... Line 128...
128
128
Line 136... Line 136...
136 
	    return $especes_pour_station;
 136 
	    return $especes_pour_station;
137 
    }
 137 
    }
Line 138... Line 138...
138
138
Line 139... Line 139...
139 
    private function getEspecesParType() {
 139 
    private function getEspecesParType() {
140
140
Line 141... Line 141...
141 
    	$requete_toute_espece = 'SELECT * FROM ods_especes ORDER BY oe_ce_type';
 141 
    	$requete_toute_espece = 'SELECT * FROM ods_especes ORDER BY oe_ce_type, oe_nom_vernaculaire';
Line 142... Line 142...
142 
    	$liste_espece = $this->executerRequete($requete_toute_espece);
 142 
    	$liste_espece = $this->executerRequete($requete_toute_espece);
Line 165... Line 165...
165 
	    return $especes_par_type;
 165 
	    return $especes_par_type;
166 
    }
 166 
    }
Line 167... Line 167...
167
167
Line 168... Line 168...
168 
	public function getToutesEspeces() {
 168 
	public function getToutesEspeces() {
169
169
Line 170... Line 170...
170 
    	$requete_toute_espece = 'SELECT * FROM ods_especes';
 170 
    	$requete_toute_espece = 'SELECT * FROM ods_especes ORDER BY oe_nom_vernaculaire';
Line 171... Line 171...
171 
    	$liste_espece = $this->executerRequete($requete_toute_espece);
 171 
    	$liste_espece = $this->executerRequete($requete_toute_espece);