107,7 → 107,7 |
"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ". |
"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ". |
"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI']; |
$stations = $this->bdd->recupererTous($requete); |
$stations = $this->bdd->recupererTous($requete); |
$this->rechercherInfosCommune($stations); |
return $stations; |
} |
132,9 → 132,16 |
"nom_scientifique_complet LIKE ".$this->bdd->proteger($this->taxon['nom_sci']) ; |
if ($this->nomRang == 'espece' || $this->nomRang == 'sous_espece') { |
foreach ($this->taxons as $sousTaxon) { |
$criteres[] = (in_array($source, array("baznat", "ifn", "vigie_flore"))) ? |
if ($source == "sophy") { |
if ($sousTaxon['num_nom'] = $sousTaxon['num_nom_retenu']) { |
$criteres[] = |
"nom_scientifique_complet LIKE ".$this->bdd->proteger($sousTaxon['nom_sci']) ; |
} |
} else { |
$criteres[] = (in_array($source, array("baznat", "ifn", "vigie_flore"))) ? |
"num_nom = ".$sousTaxon['num_nom'] : |
"nom_scientifique_complet LIKE ".$this->bdd->proteger($sousTaxon['nom_sci']) ; |
} |
} |
} elseif ($this->nomRang == 'famille') { |
foreach ($this->genres as $genre) { |
142,6 → 149,7 |
} |
} |
return "(".implode(' OR ',array_unique($criteres)).")"; |
|
} |
|
private function rechercherInfosCommune(& $stations) { |