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 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() {
|