| 35,6 → 35,7 |
|---|
| $this->genererChpNomSciHtml(); |
| $this->genererChpFamille(); |
| $this->genererDonneesTestMultiVersion(); |
| $this->genererChpHierarchie(); |
| break; |
| case 'chargerStructureSql' : |
| $this->chargerStructureSql(); |
| 48,6 → 49,9 |
|---|
| case 'genererChpFamille' : |
| $this->genererChpFamille(); |
| break; |
| case 'genererChpHierarchie' : |
| $this->genererChpHierarchie(); |
| break; |
| case 'genererDonneesTestMultiVersion' : |
| $this->genererDonneesTestMultiVersion(); |
| break; |
| 202,7 → 206,7 |
|---|
| |
| $this->remplirChpFamille($noms); |
| } |
| |
| |
| private function preparerTablePrChpFamille() { |
| $requete = "SHOW COLUMNS FROM {$this->table} LIKE 'famille' "; |
| $resultat = $this->getBdd()->recuperer($requete); |
| 235,6 → 239,54 |
|---|
| } |
| echo "\n"; |
| } |
| |
| private function genererChpHierarchie() { |
| $this->initialiserGenerationChamps(); |
| $this->preparerTablePrChpHierarchie(); |
| $table = Config::get('tables.bdtfx'); |
| |
| $requete = "UPDATE $table SET hierarchie = NULL "; |
| $mise_a_jour = $this->getBdd()->requeter($requete); |
| |
| $requete_hierarchie = "SELECT num_nom, num_nom_retenu, num_tax_sup FROM ".$table." ORDER BY rang DESC"; |
| |
| $resultat = $this->getBdd()->recupererTous($requete_hierarchie); |
| $num_nom_a_num_sup = array(); |
| foreach($resultat as &$taxon) { |
| $num_nom_a_num_sup[$taxon['num_nom']] = $taxon['num_tax_sup']; |
| } |
| $chemin_taxo = ""; |
| foreach($resultat as &$taxon) { |
| $chemin_taxo = $this->traiterHierarchieNumTaxSup($taxon['num_nom_retenu'], $num_nom_a_num_sup).'-'; |
| $requete = "UPDATE $table SET hierarchie = ".$this->getBdd()->proteger($chemin_taxo)." WHERE num_nom = ".$taxon['num_nom']." "; |
| $mise_a_jour = $this->getBdd()->requeter($requete); |
| $this->afficherAvancement("Insertion de la hierarchie taxonomique en cours"); |
| } |
| echo "\n"; |
| } |
| |
| private function traiterHierarchieNumTaxSup($num_nom_retenu, &$num_nom_a_num_sup) { |
| $chaine_hierarchie = ""; |
| if(isset($num_nom_a_num_sup[$num_nom_retenu])) { |
| $num_tax_sup = $num_nom_a_num_sup[$num_nom_retenu]; |
| $chaine_hierarchie = '-'.$num_tax_sup; |
| if($num_tax_sup != 0 && $num_tax_sup != '') { |
| $chaine_hierarchie = $this->traiterHierarchieNumTaxSup($num_tax_sup, $num_nom_a_num_sup).$chaine_hierarchie; |
| } |
| } |
| return $chaine_hierarchie; |
| } |
| |
| private function preparerTablePrChpHierarchie() { |
| $requete = "SHOW COLUMNS FROM {$this->table} LIKE 'hierarchie' "; |
| $resultat = $this->getBdd()->recuperer($requete); |
| if ($resultat === false) { |
| $requete = "ALTER TABLE {$this->table} ". |
| 'ADD hierarchie VARCHAR(1000) '. |
| 'CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL '; |
| $this->getBdd()->requeter($requete); |
| } |
| } |
| |
| private function genererDonneesTestMultiVersion() { |
| $contenuSql = $this->recupererContenu(Config::get('chemins.structureSqlTest')); |