| 49,7 → 49,6 |
|---|
| $this->traiterRessources(); |
| $requete = $this->assemblerLaRequete(); |
| $resultat = $this->getBdd()->recupererTous($requete); |
| |
| $versionResultat = $this->traiterResultat($resultat, $version, $requete); |
| if (count($this->table_version) > 1) { |
| $resultats[$version] = $versionResultat; |
| 57,8 → 56,7 |
|---|
| $resultats = $versionResultat; |
| } |
| } |
| |
| return $resultats; |
| return $resultats; |
| } |
| |
| |
| 89,10 → 87,19 |
|---|
| ." sexualite, ordre_maturation, " |
| ."pollinisation, fruit, dissemination, couleur_fleur, macule, floraison, type_bio, " |
| ."form_vegetale "; |
| $this->requete_condition[] = "( chorologie != '' OR inflorescence != '' ". |
| "OR sexualite != '' OR ordre_maturation != '' OR pollinisation != '' ". |
| "OR fruit != '' OR dissemination != '' OR couleur_fleur != '' OR macule != '' ". |
| "OR floraison != '' OR type_bio != '' OR form_vegetale != '' )"; |
| }elseif ($valeur == "ecologie"){ |
| $this->champs_recherches = "num_nomen, BDNT, ve_lumiere , ve_temperature," |
| $this->champs_recherches = " num_nomen, BDNT, ve_lumiere , ve_temperature," |
| ." ve_continentalite, ve_humidite_atmos, ve_humidite_edaph, ve_reaction_sol," |
| ." ve_nutriments_sol, ve_salinite, ve_texture_sol, ve_mat_org_sol "; |
| $this->requete_condition[] = "( ve_lumiere != '' OR ve_temperature != '' ". |
| "OR ve_continentalite != '' OR ve_humidite_atmos != '' ". |
| "OR ve_humidite_edaph != '' OR ve_reaction_sol != '' ". |
| "OR ve_nutriments_sol != '' OR ve_salinite != '' ". |
| "OR ve_texture_sol != '' OR ve_mat_org_sol != '' )"; |
| }else { |
| $e = 'Valeur de paramètre inconnue pour \'test\'. '; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_MAUVAISE_REQUETE, $e); |
| 365,9 → 372,11 |
|---|
| //+--------------------------FONCTIONS D'ASSEMBLAGE DE LA REQUETE-------------------------------------------+ |
| |
| public function assemblerLaRequete() { |
| |
| $requete = ' SELECT '.$this->champs_recherches.' FROM '.$this->table.' ' |
| .$this->retournerRequeteCondition().' ' |
| .$this->delimiterResultatsRequete(); |
| |
| return $requete; |
| } |
| |
| 394,7 → 403,6 |
|---|
| $this->total_resultat = 0; |
| $e = 'Données introuvables dans la base'; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE, $e); |
| Debug::printr($requete); |
| } |
| } |
| |