Line 53... |
Line 53... |
53 |
if(isset($criteres['sql_brut']) && !$autoriser_sql_brut) unset($criteres['sql_brut']);
|
53 |
if(isset($criteres['sql_brut']) && !$autoriser_sql_brut) unset($criteres['sql_brut']);
|
54 |
$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
|
54 |
$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
|
Line 55... |
Line 55... |
55 |
|
55 |
|
56 |
$requete_selection_observations .= $sous_requete_recherche;
|
56 |
$requete_selection_observations .= $sous_requete_recherche;
|
57 |
$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
|
- |
|
58 |
$requete_selection_observations .= $id_utilisateur == null ? ' ORDER BY id_observation ' : ' ORDER BY '.$tri.' '.$tri_dir;
|
57 |
$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
|
Line 59... |
Line 58... |
59 |
$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
|
58 |
$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
|
60 |
|
59 |
|
61 |
$this->requete_selection_observations = $requete_selection_observations;
|
60 |
$this->requete_selection_observations = $requete_selection_observations;print_r($requete_selection_observations);exit;
|
Line 62... |
Line 61... |
62 |
return $this;
|
61 |
return $this;
|
63 |
}
|
62 |
}
|
Line 77... |
Line 76... |
77 |
} else if(count($criteres) > 0) {
|
76 |
} else if(count($criteres) > 0) {
|
78 |
$requete .= 'WHERE ';
|
77 |
$requete .= 'WHERE ';
|
79 |
}
|
78 |
}
|
80 |
$requete .= $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
|
79 |
$requete .= $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
|
81 |
$requete = rtrim($requete, 'AND ');
|
80 |
$requete = rtrim($requete, 'AND ');
|
82 |
$resultat = Cel::db()->requeter($requete);//print_r($requete);exit;
|
81 |
$resultat = Cel::db()->requeter($requete);print_r($requete);exit;
|
83 |
$nb_obs = ($resultat && is_array($resultat) && count($resultat) > 0) ? $resultat[0]['nb_obs'] : '0';
|
82 |
$nb_obs = ($resultat && is_array($resultat) && count($resultat) > 0) ? $resultat[0]['nb_obs'] : '0';
|
84 |
return $nb_obs;
|
83 |
return $nb_obs;
|
85 |
}
|
84 |
}
|
Line 86... |
Line 85... |
86 |
|
85 |
|