| Line 14... |
Line 14... |
| 14 |
"COUNT(guid) AS nb_observations FROM {$this->source}_tapir WHERE ".$this->construireWhereTaxon()." ".
|
14 |
"COUNT(guid) AS nb_observations FROM {$this->source}_tapir WHERE ".$this->construireWhereTaxon()." ".
|
| 15 |
"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
|
15 |
"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
|
| 16 |
"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
|
16 |
"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
|
| 17 |
"GROUP BY Floor(lieu_station_latitude*10)/10, Floor(lieu_station_longitude*10)/10 ".
|
17 |
"GROUP BY Floor(lieu_station_latitude*10)/10, Floor(lieu_station_longitude*10)/10 ".
|
| 18 |
"ORDER BY lat DESC, lng ASC";
|
18 |
"ORDER BY lat DESC, lng ASC";
|
| 19 |
//echo $requete.'<br>';
|
- |
|
| 20 |
return $bdd->recupererTous($requete);
|
19 |
return $bdd->recupererTous($requete);
|
| 21 |
}
|
20 |
}
|
| Line 22... |
Line 21... |
| 22 |
|
21 |
|
| 23 |
final protected function construireWhereTaxon() {
|
22 |
final protected function construireWhereTaxon() {
|