| Line 45... |
Line 45... |
| 45 |
|
45 |
|
| 46 |
private function insererDonneesRangSup() {
|
46 |
private function insererDonneesRangSup() {
|
| 47 |
$table = Config::get('tables.rang_sup');
|
47 |
$table = Config::get('tables.rang_sup');
|
| 48 |
$requete_truncate = 'TRUNCATE TABLE '.$table;
|
48 |
$requete_truncate = 'TRUNCATE TABLE '.$table;
|
| - |
|
49 |
$this->Bdd->requeter($requete_truncate);
|
| 49 |
$this->Bdd->requeter($requete_truncate);
|
50 |
$i = 0;
|
| 50 |
foreach ($this->valeurs_insertion as $nn => $valeurs){
|
51 |
foreach ($this->valeurs_insertion as $nn => $valeurs){
|
| 51 |
$requete = "INSERT INTO $table VALUES('',$nn, 'bdtfx', '{$valeurs['ve_lumiere']['min']}', ".
|
52 |
$requete = "INSERT INTO $table VALUES({$i},$nn, 'bdtfx', '{$valeurs['ve_lumiere']['min']}', ".
|
| 52 |
"'{$valeurs['ve_lumiere']['max']}','{$valeurs['ve_temperature']['min']}',".
|
53 |
"'{$valeurs['ve_lumiere']['max']}','{$valeurs['ve_temperature']['min']}',".
|
| 53 |
"'{$valeurs['ve_temperature']['max']}','{$valeurs['ve_continentalite']['min']}',".
|
54 |
"'{$valeurs['ve_temperature']['max']}','{$valeurs['ve_continentalite']['min']}',".
|
| 54 |
"'{$valeurs['ve_continentalite']['max']}','{$valeurs['ve_humidite_atmos']['min']}',".
|
55 |
"'{$valeurs['ve_continentalite']['max']}','{$valeurs['ve_humidite_atmos']['min']}',".
|
| 55 |
"'{$valeurs['ve_humidite_atmos']['max']}','{$valeurs['ve_humidite_edaph']['min']}',".
|
56 |
"'{$valeurs['ve_humidite_atmos']['max']}','{$valeurs['ve_humidite_edaph']['min']}',".
|
| Line 58... |
Line 59... |
| 58 |
"'{$valeurs['ve_nutriments_sol']['max']}','{$valeurs['ve_salinite']['min']}',".
|
59 |
"'{$valeurs['ve_nutriments_sol']['max']}','{$valeurs['ve_salinite']['min']}',".
|
| 59 |
"'{$valeurs['ve_salinite']['max']}','{$valeurs['ve_texture_sol']['min']}',".
|
60 |
"'{$valeurs['ve_salinite']['max']}','{$valeurs['ve_texture_sol']['min']}',".
|
| 60 |
"'{$valeurs['ve_texture_sol']['max']}','{$valeurs['ve_mat_org_sol']['min']}',".
|
61 |
"'{$valeurs['ve_texture_sol']['max']}','{$valeurs['ve_mat_org_sol']['min']}',".
|
| 61 |
"'{$valeurs['ve_mat_org_sol']['max']}');";
|
62 |
"'{$valeurs['ve_mat_org_sol']['max']}');";
|
| 62 |
$this->Bdd->requeter($requete);
|
63 |
$this->Bdd->requeter($requete);
|
| - |
|
64 |
$i++;
|
| 63 |
$this->message->afficherAvancement('Insertion des valeurs pour les rangs supérieurs en cours');
|
65 |
$this->message->afficherAvancement('Insertion des valeurs pour les rangs supérieurs en cours');
|
| 64 |
}
|
66 |
}
|
| 65 |
}
|
67 |
}
|