| 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);
|