Subversion Repositories eFlore/Applications.cel

Rev

Rev 1790 | Rev 2272 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1790 Rev 2143
Line 211... Line 211...
211 
			'FROM cel_obs '.
 211 
			'FROM cel_obs '.
212 
			(($this->etreFluxAdmin()) ? '' : 'WHERE transmission = 1 ').
 212 
			(($this->etreFluxAdmin()) ? '' : 'WHERE transmission = 1 ').
213 
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'date_modification DESC').' '.
 213 
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'date_modification DESC').' '.
214 
			"LIMIT $this->start,$this->limit ";
 214 
			"LIMIT $this->start,$this->limit ";
Line 215... Line 215...
215 
 
 215 
 
Line 216... Line 216...
216 
		$elements = Cel::db()->executerRequete($requete);
 216 
		$elements = Cel::db()->requeter($requete);
217 
 
 217 
 
218 
		// Création du contenu
 218 
		// Création du contenu
219 
		$contenu = $this->executerService($elements);
 219 
		$contenu = $this->executerService($elements);
Line 280... Line 280...
280 
		$requete = rtrim($requete, 'AND ');
 280 
		$requete = rtrim($requete, 'AND ');
281 
		$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  :
 281 
		$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  :
282 
			'date_modification DESC, zone_geo ASC').' '.
 282 
			'date_modification DESC, zone_geo ASC').' '.
283 
				"LIMIT $this->start,$this->limit ";
 283 
				"LIMIT $this->start,$this->limit ";
Line 284... Line 284...
284
284 
 
Line 285... Line 285...
285 
		$elements = Cel::db()->executerRequete($requete);
 285 
		$elements = Cel::db()->requeter($requete);
286 
 
 286 
 
287 
		// Création du contenu
 287 
		// Création du contenu
288 
		if ($elements != false && count($elements) > 0) {
 288 
		if ($elements != false && count($elements) > 0) {