Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 452 | Rev 480 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 452 Rev 466
Line 47... Line 47...
47 
			$this->table = $version;
47 
			$this->table = $version;
48 
			$this->recupererNomChamp($this->table);
48 
			$this->recupererNomChamp($this->table);
49 
			$this->traiterRessources();
49 
			$this->traiterRessources();
50 
			$requete = $this->assemblerLaRequete();
50 
			$requete = $this->assemblerLaRequete();
51 
			$resultat = $this->getBdd()->recupererTous($requete);
 51 
			$resultat = $this->getBdd()->recupererTous($requete);
52 
 
 - 
 
53 
			$versionResultat = $this->traiterResultat($resultat, $version, $requete);
 52 
			$versionResultat = $this->traiterResultat($resultat, $version, $requete);
54 
			if (count($this->table_version) > 1) {
 53 
			if (count($this->table_version) > 1) {
55 
				$resultats[$version] = $versionResultat;
 54 
				$resultats[$version] = $versionResultat;
56 
			} else {
 55 
			} else {
57 
				$resultats = $versionResultat;
 56 
				$resultats = $versionResultat;
58 
			}
 57 
			}
59 
		}
 58 
		}
60 
 
 - 
 
61 
		return $resultats;
 59 
	return $resultats;
62 
	}
 60 
	}
Line 63... Line 61...
63
61
Line 87... Line 85...
87 
						if ($valeur == "description") {
 85 
						if ($valeur == "description") {
88 
							$this->champs_recherches = "num_nomen, BDNT, chorologie, inflorescence,"
 86 
							$this->champs_recherches = "num_nomen, BDNT, chorologie, inflorescence,"
89 
							." sexualite, ordre_maturation, "
 87 
							." sexualite, ordre_maturation, "
90 
							."pollinisation, fruit, dissemination, couleur_fleur, macule, floraison, type_bio, "
 88 
							."pollinisation, fruit, dissemination, couleur_fleur, macule, floraison, type_bio, "
91 
						 	."form_vegetale ";
89 
						 	."form_vegetale ";
- 
 
 90 
						$this->requete_condition[] = "( chorologie != '' OR inflorescence != '' ".
- 
 
 91 
							"OR  sexualite != '' OR ordre_maturation != '' OR pollinisation != '' ".
- 
 
 92 
							"OR fruit != '' OR dissemination != '' OR couleur_fleur != '' OR macule != '' ".
- 
 
 93 
							"OR floraison != '' OR type_bio != '' OR form_vegetale != '' )";
92 
						}elseif ($valeur == "ecologie"){
 94 
						}elseif ($valeur == "ecologie"){
93 
							$this->champs_recherches = "num_nomen, BDNT, ve_lumiere , ve_temperature,"
 95 
							$this->champs_recherches = " num_nomen, BDNT, ve_lumiere , ve_temperature,"
94 
							." ve_continentalite, ve_humidite_atmos, ve_humidite_edaph, ve_reaction_sol,"
 96 
							." ve_continentalite, ve_humidite_atmos, ve_humidite_edaph, ve_reaction_sol,"
95 
							." ve_nutriments_sol, ve_salinite, ve_texture_sol, ve_mat_org_sol ";
 97 
							." ve_nutriments_sol, ve_salinite, ve_texture_sol, ve_mat_org_sol ";
- 
 
 98 
							$this->requete_condition[] = "( ve_lumiere  != '' OR ve_temperature != '' ".
- 
 
 99 
								"OR ve_continentalite != '' OR ve_humidite_atmos != '' ".
- 
 
 100 
								"OR ve_humidite_edaph != '' OR ve_reaction_sol != '' ".
- 
 
 101 
								"OR ve_nutriments_sol != '' OR ve_salinite != '' ".
- 
 
 102 
								"OR ve_texture_sol != '' OR ve_mat_org_sol != '' )";
96 
						}else {
 103 
						}else {
97 
							$e = 'Valeur de paramètre inconnue  pour \'test\'. ';
 104 
							$e = 'Valeur de paramètre inconnue  pour \'test\'. ';
98 
							$this->renvoyerErreur(RestServeur::HTTP_CODE_MAUVAISE_REQUETE, $e);
 105 
							$this->renvoyerErreur(RestServeur::HTTP_CODE_MAUVAISE_REQUETE, $e);
99 
						}
 106 
						}
100 
						break;
 107 
						break;
Line 363... Line 370...
363
370
Line 364... Line 371...
364
371
- 
 
 372 
//+--------------------------FONCTIONS D'ASSEMBLAGE DE LA REQUETE-------------------------------------------+
365 
//+--------------------------FONCTIONS D'ASSEMBLAGE DE LA REQUETE-------------------------------------------+
 373
366
374 
	public function assemblerLaRequete() {
367 
	public function assemblerLaRequete() {
 375 
 
- 
 
 376 
		$requete = 	' SELECT '.$this->champs_recherches.' FROM '.$this->table.' '
368 
		$requete = 	' SELECT '.$this->champs_recherches.' FROM '.$this->table.' '
 377 
		.$this->retournerRequeteCondition().' '
369 
		.$this->retournerRequeteCondition().' '
 378 
		.$this->delimiterResultatsRequete();
Line 392... Line 401...
392 
			$this->total_resultat = $res['nombre'];
 401 
			$this->total_resultat = $res['nombre'];
393 
		} else {
 402 
		} else {
394 
			$this->total_resultat = 0;
 403 
			$this->total_resultat = 0;
395 
			$e = 'Données introuvables dans la base';
 404 
			$e = 'Données introuvables dans la base';
396 
			$this->renvoyerErreur(RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE, $e);
 405 
			$this->renvoyerErreur(RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE, $e);
397 
			Debug::printr($requete);
 - 
 
398 
		}
 406 
		}
399 
	}
 407 
	}
Line 400... Line 408...
400
408
401 
	public function delimiterResultatsRequete() {
 409 
	public function delimiterResultatsRequete() {