Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 891 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 891 Rev 905
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']),