| 1,8 → 1,7 |
|---|
| <?php |
| /** |
| * |
| * /opt/lampp/bin/php -d memory_limit=3500M ~/web/eflore-projets/scripts/cli.php baseflor/Baseflor_rang_sup_insertion |
| * -a insererDonnees |
| * |
| * @author Mathilde SALTHUN-LASSALLE <mathilde@tela-botanica.org> |
| * |
| * |
| 20,10 → 19,12 |
|---|
| private $nn_courant; |
| private $nn_superieur; |
| private $champs_ecologiques = array(); |
| private $Bdd; |
| |
| |
| public function __construct(Conteneur $conteneur) { |
| public function __construct(Conteneur $conteneur, Bdd $bdd) { |
| $this->conteneur = $conteneur; |
| $this->Bdd = $bdd; |
| $this->efloreCommun = $conteneur->getEfloreCommun(); |
| $this->message = $conteneur->getMessages(); |
| $this->outils = $conteneur->getOutils(); |
| 32,7 → 33,7 |
|---|
| |
| public function insererDonnees(){ |
| echo "Chargement de la structure en cours \n" ; |
| $this->efloreCommun->chargerStructureSql('chemins.rang_sup_sql'); |
| $this->efloreCommun->chargerFichierSql('chemins.rang_sup_sql'); |
| echo "Récupération des données de baseflor en cours \n"; |
| $this->recupererDonneesInitiales(); |
| echo "Calcul des valeurs pour les rangs supérieurs en cours \n"; |
| 45,9 → 46,9 |
|---|
| private function insererDonneesRangSup() { |
| $table = Config::get('tables.rang_sup'); |
| $requete_truncate = 'TRUNCATE TABLE '.$table; |
| $this->efloreCommun->getBdd()->requeter($requete_truncate); |
| $this->Bdd->requeter($requete_truncate); |
| foreach ($this->valeurs_insertion as $nn => $valeurs){ |
| $requete = "INSERT INTO $table VALUES($nn, 'bdtfx', '{$valeurs['ve_lumiere']['min']}', ". |
| $requete = "INSERT INTO $table VALUES('',$nn, 'bdtfx', '{$valeurs['ve_lumiere']['min']}', ". |
| "'{$valeurs['ve_lumiere']['max']}','{$valeurs['ve_temperature']['min']}',". |
| "'{$valeurs['ve_temperature']['max']}','{$valeurs['ve_continentalite']['min']}',". |
| "'{$valeurs['ve_continentalite']['max']}','{$valeurs['ve_humidite_atmos']['min']}',". |
| 58,7 → 59,7 |
|---|
| "'{$valeurs['ve_salinite']['max']}','{$valeurs['ve_texture_sol']['min']}',". |
| "'{$valeurs['ve_texture_sol']['max']}','{$valeurs['ve_mat_org_sol']['min']}',". |
| "'{$valeurs['ve_mat_org_sol']['max']}');"; |
| $this->efloreCommun->getBdd()->requeter($requete); |
| $this->Bdd->requeter($requete); |
| $this->message->afficherAvancement('Insertion des valeurs pour les rangs supérieurs en cours'); |
| } |
| } |
| 160,7 → 161,7 |
|---|
| $requete = 'SELECT A.num_nom AS nn, B.num_tax_sup AS nn_sup, A.rang '. |
| "FROM $table A JOIN $table B ON (A.num_nom_retenu = B.num_nom) ". |
| 'WHERE B.num_nom = B.num_nom_retenu '; |
| $resultat = $this->efloreCommun->getBdd()->recupererTous($requete); |
| $resultat = $this->Bdd->recupererTous($requete); |
| foreach ($resultat as $res) { |
| $this->infos_taxon[$res['nn']] = array('nn_sup' => $res['nn_sup'], 'rang' => $res['rang'] ); |
| } |
| 176,7 → 177,7 |
|---|
| " AND (ve_lumiere != '' OR ve_mat_org_sol != '' OR ve_temperature != '' ". |
| " OR ve_continentalite != '' OR ve_humidite_atmos != '' OR ve_humidite_edaph != '' ". |
| " OR ve_nutriments_sol != '' OR ve_salinite != '' OR ve_texture_sol != '' OR ve_reaction_sol != '' )"; |
| $resultat = $this->efloreCommun->getBdd()->recupererTous($requete); |
| $resultat = $this->Bdd->recupererTous($requete); |
| foreach ($resultat as $res) { |
| $this->donnees_initiales[$res['num_nomen']] = array( |
| 've_lumiere' => array('min' => $res['ve_lumiere'], 'max' => $res['ve_lumiere']), |