39,6 → 39,7 |
private $nomCourt; |
private $taxon; |
private $bdd = null; |
|
private $nomsChampsBdtfx = array('nn' => 'num_nom_retenu', 'nt' => 'num_taxonomique', 'ns' => 'nom_sci'); |
private $nomsChampsBdtxa = array('nn' => 'num_nom_retenu', 'nt' => 'num_tax', 'ns' => 'nom_sci'); |
private $champs; |
87,42 → 88,26 |
if (is_null($this->bdd)) { |
$this->bdd = new Bdd(); |
} |
$nomBdd = Config::get('bdd_eflore'); |
if (is_null($nomBdd)) { |
$nomBdd = Config::get('bdd_nom'); |
} |
$this->bdd->requeter("USE ".$nomBdd); |
return $this->bdd; |
} |
|
public function recupererTaxonsSousEspeces($listeNn = null) { |
public function recupererSynonymesEtSousEspeces() { |
$sousTaxons = array(); |
if (!is_null($this->taxon) && $this->taxon['rang'] == Config::get('rang.espece')) { |
if (is_null($listeNn)) { |
$listeNn = $this->taxon['nn']; |
} |
if (!is_null($this->taxon) && $this->taxon['rang'] >= Config::get('rang.espece')) { |
$requete = |
"SELECT ".$this->champs['nn']." AS nn, ".$this->champs['nt']." AS nt, ". |
$this->champs['ns']." AS nom, rang FROM ".$this->nomComplet." WHERE ". |
"num_tax_sup IN ({$listeNn}) AND num_nom=".$this->champs['nn']; |
$resultats = $this->getBdd()->recupererTous($requete); |
|
$nouvelleListeNn = ''; |
foreach ($resultats as $sousTaxon) { |
$sousTaxons[] = $sousTaxon; |
$nouvelleListeNn .= (strlen($nouvelleListeNn) == 0 ? '' : ',') . $sousTaxon['nn']; |
$this->champs['nt']."=".$this->taxon['nt']." OR hierarchie LIKE '%-".$this->champs['nn']."-%'"; |
$sousTaxons = $this->getBdd()->recupererTous($requete); |
} |
// recherche de sous taxons au niveau inferieur (parcours recursif de la methode) |
if (count($resultats) > 0) { |
$sousTaxons = array_merge($sousTaxons, $this->recupererTaxonsSousEspeces($nouvelleListeNn)); |
} |
} |
return $sousTaxons; |
} |
|
public function recupererTaxonsFamilles() { |
public function recupererGenres() { |
$sousTaxons = array(); |
if (!is_null($this->taxon) && $this->taxon['rang'] == Config::get('rang.genre')) { |
if (!is_null($this->taxon) && $this->taxon['rang'] == Config::get('rang.famille')) { |
$requete = |
"SELECT ".$this->champs['nn']." AS nn, ".$this->champs['nt']." AS nt, ". |
$this->champs['ns']." AS nom, rang FROM ".$this->nomComplet." WHERE ". |
149,10 → 134,13 |
return $tableau; |
} |
|
public function obtenirNumeroNomenclatural($nomScientifique) { |
public function obtenirNumeroNomenclatural($nomScientifique, $numeroNomenclatural = null) { |
$aProteger = $this->getBdd()->proteger(trim($nomScientifique) . '%'); |
$requete = "SELECT ".$this->champs['nn']." AS nn FROM ".$this->nomComplet." ". |
"WHERE ".$this->champs['ns']." LIKE ".$aProteger; |
if (!is_null($numeroNomenclatural) || strlen($numeroNomenclatural) > 0) { |
$requete .= " OR ".$this->champs['nn']."={$numeroNomenclatural}"; |
} |
$taxon = $this->getBdd()->recuperer($requete); |
if ($taxon == false) { |
$taxon = null; |
163,4 → 151,5 |
} |
|
} |
|
?> |