| Line 100... |
Line 100... |
| 100 |
$requete =
|
100 |
$requete =
|
| 101 |
"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".
|
101 |
"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".
|
| 102 |
"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage()." ".
|
102 |
"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage()." ".
|
| 103 |
"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
|
103 |
"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
|
| 104 |
"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
|
104 |
"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
|
| 105 |
"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date";
|
105 |
"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ".$_SERVER['REQUEST_URI'];
|
| 106 |
$stations = $this->bdd->recupererTous($requete);
|
106 |
$stations = $this->bdd->recupererTous($requete);
|
| 107 |
$this->rechercherInfosCommune($stations);
|
107 |
$this->rechercherInfosCommune($stations);
|
| 108 |
return $stations;
|
108 |
return $stations;
|
| 109 |
}
|
109 |
}
|