Line 174... |
Line 174... |
174 |
$table = Config::get('tables.donnees');
|
174 |
$table = Config::get('tables.donnees');
|
175 |
$requete = "SELECT num_nomen, ve_lumiere, ve_temperature, ve_continentalite, ve_humidite_atmos, ".
|
175 |
$requete = "SELECT num_nomen, ve_lumiere, ve_temperature, ve_continentalite, ve_humidite_atmos, ".
|
176 |
"ve_humidite_edaph, ve_reaction_sol, ve_nutriments_sol, ve_salinite, ve_texture_sol, ve_mat_org_sol ".
|
176 |
"ve_humidite_edaph, ve_reaction_sol, ve_nutriments_sol, ve_salinite, ve_texture_sol, ve_mat_org_sol ".
|
177 |
"FROM $table WHERE BDNT = 'BDTFX' ".
|
177 |
"FROM $table WHERE BDNT = 'BDTFX' ".
|
178 |
" AND num_nomen != 0 ".
|
178 |
" AND num_nomen != 0 ".
|
179 |
" AND (ve_lumiere != '' OR ve_mat_org_sol != '' OR ve_temperature != '' ".
|
179 |
" AND !(ve_lumiere = '' and ve_mat_org_sol = '' and ve_temperature = '' and ve_continentalite = '' ".
|
180 |
" OR ve_continentalite != '' OR ve_humidite_atmos != '' OR ve_humidite_edaph != '' ".
|
180 |
" and ve_humidite_atmos = '' and ve_humidite_edaph = '' and ve_nutriments_sol = '' and ve_salinite = ''".
|
181 |
" OR ve_nutriments_sol != '' OR ve_salinite != '' OR ve_texture_sol != '' OR ve_reaction_sol != '' )";
|
181 |
" and ve_texture_sol = '' and ve_reaction_sol = '')";
|
182 |
$resultat = $this->Bdd->recupererTous($requete);
|
182 |
$resultat = $this->Bdd->recupererTous($requete);
|
183 |
foreach ($resultat as $res) {
|
183 |
foreach ($resultat as $res) {
|
184 |
$this->donnees_initiales[$res['num_nomen']] = array(
|
184 |
$this->donnees_initiales[$res['num_nomen']] = array(
|
185 |
've_lumiere' => array('min' => $res['ve_lumiere'], 'max' => $res['ve_lumiere']),
|
185 |
've_lumiere' => array('min' => $res['ve_lumiere'], 'max' => $res['ve_lumiere']),
|
186 |
've_temperature' => array('min' => $res['ve_temperature'], 'max' => $res['ve_temperature']),
|
186 |
've_temperature' => array('min' => $res['ve_temperature'], 'max' => $res['ve_temperature']),
|