38,9 → 38,8 |
|
protected function recupererSynonymesEtSousEspeces() { |
$requete = |
"SELECT num_nom, nom_sci, nom_complet, num_taxonomique FROM ".Config::get('bdd_table_referentiel'). |
" WHERE hierarchie LIKE '%-{$this->taxon['num_nom']}-%' ". |
"OR num_nom_retenu = {$this->taxon['num_nom_retenu']}"; |
"SELECT num_nom, nom_sci, nom_complet, 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); |
} |
|
47,8 → 46,7 |
protected function recupererGenres() { |
$this->bdd->requeter("USE ".Config::get('bdd_nom')); |
$requete = |
"SELECT num_nom, nom_sci, num_taxonomique FROM ".Config::get('bdd_table_referentiel'). |
" WHERE rang=220 AND num_tax_sup={$this->taxon['num_nom']}"; |
"SELECT num_nom, nom_sci, num_taxonomique FROM bdtfx_v1_01 WHERE rang=220 AND num_tax_sup={$this->taxon['num_nom']}"; |
return $this->bdd->recupererTous($requete); |
} |
|
58,7 → 56,7 |
"SELECT DISTINCTROW zone_geo AS commune, Date(date_observation) AS date, Floor(wgs84_latitude*10)/10 AS lat, ". |
"Floor(wgs84_longitude*10)/10 AS lng, courriel_utilisateur AS auteur ". |
"FROM cel_obs LEFT JOIN cel_zones_geo cz ON ce_zone_geo=id_zone_geo ". |
"WHERE ".$this->construireWhereTaxonFloradata()." AND transmission=1 AND nom_referentiel = '".Config::get('referentielsDispo')."' AND ". |
"WHERE ".$this->construireWhereTaxonFloradata()." AND transmission=1 AND ". |
"wgs84_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ". |
"AND wgs84_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ". |
"AND date_observation<>'0000-00-00 00-00-00' ORDER BY lat DESC, lng ASC, commune, date"; |
88,11 → 86,11 |
} elseif ($this->nomRang == 'genre') { |
$criteres[] = "nom_sel LIKE ".$this->bdd->proteger($this->taxon['nom_sci'].'%'); |
} else { |
$taxons = array($this->taxon['num_nom']); |
$taxons = array($this->taxon['num_taxonomique']); |
foreach ($this->taxons as $sousTaxon) { |
$taxons[] = $sousTaxon['num_nom']; |
$taxons[] = $sousTaxon['num_taxonomique']; |
} |
$criteres[] = "nom_sel_nn IN (".implode(',', array_unique($taxons)) .")"; |
$criteres[] = "nt IN (".implode(',', array_unique($taxons)) .")"; |
} |
return "(".implode(' OR ',array_unique($criteres)).")"; |
} |