Subversion Repositories eFlore/Applications.cel

Rev

Rev 1598 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1598 Rev 1631
Line 12... Line 12...
12 
 * @version   SVN: <svn_id>
 12 
 * @version   SVN: <svn_id>
13 
 * @link      /doc/jrest/
 13 
 * @link      /doc/jrest/
14 
 */
 14 
 */
15 
class RechercheObservation extends Cel {
 15 
class RechercheObservation extends Cel {
Line -... Line 16...
- 
 
 16 
 
- 
 
 17 
	public $requete_selection_observations;
16 
 
 18 
 
17 
	public function obtenirIdObservationsPourOrdre($id_utilisateur, $ordre) {
 19 
	public function obtenirIdObservationsPourOrdre($id_utilisateur, $ordre) {
Line 18... Line 20...
18 
		$requete_selection_id = 'SELECT id_observation FROM cel_obs WHERE ordre ';
 20 
		$requete_selection_id = 'SELECT id_observation FROM cel_obs WHERE ordre ';
19 
 
 21 
 
Line 53... Line 55...
53 
		$requete_selection_observations .= $sous_requete_recherche;
 55 
		$requete_selection_observations .= $sous_requete_recherche;
54 
		$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
 56 
		$requete_selection_observations = rtrim($requete_selection_observations, 'AND ');
55 
		$requete_selection_observations .= $id_utilisateur == null ? ' ORDER BY id_observation, ordre ' : ' ORDER BY ordre ';
 57 
		$requete_selection_observations .= $id_utilisateur == null ? ' ORDER BY id_observation, ordre ' : ' ORDER BY ordre ';
56 
		$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
 58 
		$requete_selection_observations .= ($debut == 0 && $limite == 0) ? '' : ' LIMIT '.$debut.','.$limite ;
Line 57... Line -...
57 
 
 - 
 
58 
		$resultats_observations = array();
 59 
 
- 
 
 60 
		$this->requete_selection_observations = $requete_selection_observations;
- 
 
 61 
		return $this;
Line -... Line 62...
- 
 
 62 
	}
59 
		$resultats_observations = $this->executerRequete($requete_selection_observations);
 63 
 
- 
 
 64 
	public function get() {
60 
 
 65 
		if(!$this->requete_selection_observations) return FALSE;
Line 61... Line 66...
61 
		return $resultats_observations;
 66 
		return $this->executerRequete($this->requete_selection_observations);
62 
	}
 67 
	}