| 167,7 → 167,7 |
|---|
| switch ($this->ressources[2]) { |
| case 'catminat' : |
| $this->requete_condition[] = "catminat_code = ( SELECT catminat_code from ".$this->table_version[0]." WHERE " |
| ." num_nomen = ".$id." AND BDNT = '".$ref. "' ) "; |
| ." num_nomen = ".$id." AND BDNT = '".$ref. "' ) AND num_nomen != ".$id." "; |
| $this->champs_recherches = " catminat_code, num_nomen, BDNT, idiotaxon "; |
| break; |
| default : |
| 253,13 → 253,15 |
|---|
| $entete['limite'] = $this->limite_requete['limite']; |
| $entete['total'] = $this->total_resultat; |
| $entete['version'] = $this->version_projet; |
| $url = $this->formulerUrl($this->total_resultat, '/informations/'.$this->ressources[0].'/relations/catminat'); |
| if (isset($url['precedent']) && $url['precedent'] != '') { |
| $entete['href.precedent'] = $url['precedent']; |
| if ($this->limite_requete['limite'] != '*') { |
| $url = $this->formulerUrl($this->total_resultat, '/informations/'.$this->ressources[0].'/relations/catminat'); |
| if (isset($url['precedent']) && $url['precedent'] != '') { |
| $entete['href.precedent'] = $url['precedent']; |
| } |
| if (isset($url['suivant']) && $url['suivant'] != '') { |
| $entete['href.suivant'] = $url['suivant']; |
| } |
| } |
| if (isset($url['suivant']) && $url['suivant'] != '') { |
| $entete['href.suivant'] = $url['suivant']; |
| } |
| return $entete; |
| } |
| |
| 448,9 → 450,9 |
|---|
| public function assemblerLaRequete() { |
| $requete = ' SELECT '.$this->champs_recherches.' FROM '.$this->table.' ' |
| .$this->retournerRequeteCondition().' '; |
| if ($this->nb_ressources != 1) { |
| if ($this->nb_ressources != 1 ) { |
| $requete .= $this->delimiterResultatsRequete(); |
| } |
| } |
| return $requete; |
| } |
| |
| 469,16 → 471,18 |
|---|
| public function delimiterResultatsRequete() { |
| $this->calculerTotalResultat(); |
| $requete_limite = ''; |
| if (($this->limite_requete['depart'] <= $this->total_resultat) ){ |
| if (($this->limite_requete['limite'] + $this->limite_requete['depart'] ) |
| < $this->total_resultat ){ |
| $requete_limite = 'LIMIT '.$this->limite_requete['depart'].', ' |
| .$this->limite_requete['limite']; |
| if ($this->limite_requete['limite'] != '*') { |
| if ( ($this->limite_requete['depart'] <= $this->total_resultat)){ |
| if (($this->limite_requete['limite'] + $this->limite_requete['depart'] ) |
| < $this->total_resultat ){ |
| $requete_limite = 'LIMIT '.$this->limite_requete['depart'].', ' |
| .$this->limite_requete['limite']; |
| } |
| } else { |
| $e = "Erreur : la valeur pour le paramètre navigation.départ est supérieure". |
| " au nombre total de résultats."; |
| throw new Exception($e, RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE); |
| } |
| } else { |
| $e = "Erreur : la valeur pour le paramètre navigation.départ est supérieure". |
| " au nombre total de résultats."; |
| throw new Exception($e, RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE); |
| } |
| return $requete_limite; |
| } |