Line 58... |
Line 58... |
58 |
|
58 |
|
Line 59... |
Line 59... |
59 |
$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
|
59 |
$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
|
60 |
|
60 |
|
61 |
$requete_selection_observations .= $sous_requete_recherche;
|
61 |
$requete_selection_observations .= $sous_requete_recherche;
|
62 |
$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
|
62 |
$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
|
- |
|
63 |
$requete_selection_observations .= $id_utilisateur == null ? ' ORDER BY id_observation, ordre ' : ' ORDER BY ordre ';
|
63 |
$requete_selection_observations .= ' ORDER BY id_observation, ordre ';
|
64 |
$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
|
64 |
$requete_selection_observations .= ($debut != 0 && $limite != 0) ? 'LIMIT '.$debut.','.$limite : '' ;
|
65 |
|
Line 65... |
Line 66... |
65 |
$resultats_observations = array();
|
66 |
$resultats_observations = array();
|
66 |
$resultats_observations = $this->executerRequete($requete_selection_observations);
|
67 |
$resultats_observations = $this->executerRequete($requete_selection_observations);
|