| 97,6 → 97,8 |
|---|
| return "(".implode(' OR ',array_unique($criteres)).")"; |
| } |
| |
| |
| |
| public function recupererStationsMoissonnage($source) { |
| $this->bdd->requeter("USE ".Config::get('bdd_nom')); |
| $requete = |
| 110,6 → 112,18 |
|---|
| return $stations; |
| } |
| |
| public function recupererStationsVigieFlore() { |
| $this->bdd->requeter("USE ".Config::get('bdd_nom')); |
| $requete = |
| "SELECT DISTINCTROW lieu_commune_code_insee AS commune, Floor(lieu_station_longitude*10)/10 as lng, Floor(lieu_station_latitude*10)/10 as lat, observation_date AS date, observateur_nom_complet AS auteur ". |
| "FROM vigie_flore_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ". |
| "AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ". |
| "AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ". |
| " ORDER BY lat DESC, lng ASC, lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI']; |
| $stations = $this->bdd->recupererTous($requete); |
| return $stations; |
| } |
| |
| private function construireWhereTaxonMoissonnage($source) { |
| $nomRang = $this->obtenirNomRang(); |
| $criteres = array(); |