| 55,10 → 55,9 |
|---|
| |
| $requete_selection_observations .= $sous_requete_recherche; |
| $requete_selection_observations = rtrim($requete_selection_observations, 'AND '); |
| $requete_selection_observations .= $id_utilisateur == null ? ' ORDER BY id_observation ' : ' ORDER BY '.$tri.' '.$tri_dir; |
| $requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ; |
| |
| $this->requete_selection_observations = $requete_selection_observations; |
| $this->requete_selection_observations = $requete_selection_observations;print_r($requete_selection_observations);exit; |
| return $this; |
| } |
| |
| 79,7 → 78,7 |
|---|
| } |
| $requete .= $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres); |
| $requete = rtrim($requete, 'AND '); |
| $resultat = Cel::db()->requeter($requete);//print_r($requete);exit; |
| $resultat = Cel::db()->requeter($requete);print_r($requete);exit; |
| $nb_obs = ($resultat && is_array($resultat) && count($resultat) > 0) ? $resultat[0]['nb_obs'] : '0'; |
| return $nb_obs; |
| } |