38,7 → 38,7 |
|
protected function recupererSynonymesEtSousEspeces() { |
$requete = |
"SELECT num_nom, nom_sci, nom_complet, num_taxonomique FROM bdtfx_v1_01 WHERE hierarchie LIKE '%-{$this->taxon['num_nom']}-%' ". |
"SELECT num_nom, nom_sci, num_taxonomique FROM bdtfx_v1_01 WHERE hierarchie LIKE '%-{$this->taxon['num_nom']}-%' ". |
"OR num_taxonomique = {$this->taxon['num_taxonomique']}"; |
return $this->bdd->recupererTous($requete); |
} |
99,7 → 99,7 |
$this->bdd->requeter("USE ".Config::get('bdd_nom')); |
$requete = |
"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ". |
"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ". |
"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage()." ". |
"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']; |
108,16 → 108,13 |
return $stations; |
} |
|
private function construireWhereTaxonMoissonnage($source) { |
private function construireWhereTaxonMoissonnage() { |
$nomRang = $this->obtenirNomRang(); |
$criteres = array(); |
|
$nom = ($source == "baznat") ? implode('%',explode(' ',$this->taxon['nom_complet'] )) : $this->taxon['nom_sci'] ; |
$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($nom); |
$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($this->taxon['nom_sci']."%"); |
if ($this->nomRang == 'espece' || $this->nomRang == 'sous_espece') { |
foreach ($this->taxons as $sousTaxon) { |
$nom = ($source == "baznat") ? implode('%',explode(' ',$sousTaxon['nom_complet'] )) : $sousTaxon['nom_sci']; |
$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($nom); |
$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($sousTaxon['nom_sci']."%"); |
} |
} elseif ($this->nomRang == 'famille') { |
foreach ($this->genres as $genre) { |