Subversion Repositories eFlore/Projets.eflore-projets

					$this->genererChpHierarchie();

				case 'genererChpHierarchie' :

					$this->genererChpHierarchie();

					break;

	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);

		}

	}