32,7 → 32,11 |
|
private function recupererDonneesBaseflor() { |
$table = Config::get('tables.donnees'); |
$requete = "SELECT cle, num_nomen, BDNT FROM $table ;"; |
$requete = "SELECT cle, num_nomen, BDNT FROM $table WHERE num_nomen != 0 ". |
" AND num_nomen != 0 ". |
" AND !(ve_lumiere = '' and ve_mat_org_sol = '' and ve_temperature = '' and ve_continentalite = '' ". |
" and ve_humidite_atmos = '' and ve_humidite_edaph = '' and ve_nutriments_sol = '' and ve_salinite = ''". |
" and ve_texture_sol = '' and ve_reaction_sol = '')"; |
$resultat = $this->Bdd->recupererTous($requete); |
$this->valeurs_insertion['baseflor'] = $resultat; |
$this->valeurs_insertion['rangSup'] = $resultat; |
46,6 → 50,7 |
|
} |
|
|
private function insererDonneesIndex() { |
$table = Config::get('tables.index'); |
$requete_truncate = 'TRUNCATE TABLE '.$table; |
54,14 → 59,17 |
foreach ($this->valeurs_insertion as $tab => $res){ |
if ($tab == 'baseflor') { |
foreach ($res as $valeurs ) { |
if ($valeurs['num_nomen'] != 0) { |
$requete = "INSERT INTO $table VALUES({$i},{$valeurs['cle']},null,'".strtolower($valeurs['BDNT']).".nn:{$valeurs['num_nomen']}')"; |
$this->Bdd->requeter($requete); |
$i++; |
$this->message->afficherAvancement('Insertion des valeurs issues de baseflor en cours'); |
} |
} |
} else { |
foreach ($res as $valeurs ) { |
$requete = "INSERT INTO $table VALUES({$i},null,{$valeurs['cle']},'{$valeurs['bdnt']}.nn{$valeurs['num_nomen']}')"; |
if ($valeurs['num_nomen'] != 0) { |
$requete = "INSERT INTO $table VALUES({$i},null,{$valeurs['cle']},'{$valeurs['bdnt']}.nn:{$valeurs['num_nomen']}')"; |
$this->Bdd->requeter($requete); |
$i++; |
$this->message->afficherAvancement('Insertion des valeurs issues des rangs supérieurs en cours'); |
69,6 → 77,7 |
} |
} |
} |
} |
|
} |
?> |