Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1881 Rev 1888
Line 532... Line 532...
532 
	public function definirOrdreSqlAppliImg() {
 532 
	public function definirOrdreSqlAppliImg() {
533 
		$ordre = $this->parametres['ordre'];
 533 
		$ordre = $this->parametres['ordre'];
Line 534... Line 534...
534 
 
 534 
 
535 
		switch ($this->parametres['tri']) {
 535 
		switch ($this->parametres['tri']) {
536 
			case 'moyenne-arithmetique' :
 536 
			case 'moyenne-arithmetique' :
537 
				$this->addOrderBy("dis.moyenne $ordre, dis.nb_votes $ordre, id_image DESC");
 537 
				$this->addOrderBy("dis.moyenne $ordre, dis.nb_votes $ordre, id_image $ordre");
538 
				break;
 538 
				break;
539 
			case 'points' :
 539 
			case 'points' :
540 
				$this->addOrderBy("dis.nb_points $ordre, dis.moyenne $ordre, dis.nb_votes $ordre, id_image DESC");
 540 
				$this->addOrderBy("dis.nb_points $ordre, dis.moyenne $ordre, dis.nb_votes $ordre, id_image $ordre");
541 
				break;
 541 
				break;
542 
			case 'tags' :
 542 
			case 'tags' :
543 
				$this->addOrderBy("dis.nb_tags $ordre, id_image DESC");
 543 
				$this->addOrderBy("dis.nb_tags $ordre, id_image $ordre");
544 
				break;
 544 
				break;
545 
			case 'date_observation' :
 545 
			case 'date_observation' :
546 
				$this->addOrderBy("date_observation $ordre, ce_observation $ordre");
 546 
				$this->addOrderBy("date_observation $ordre, ce_observation $ordre");
547 
				break;
 547 
				break;
Line 632... Line 632...
632 
			$images[$imgId]['protocoles_votes'][$protoId]['votes'][$vote['vote.id']] = $vote;
 632 
			$images[$imgId]['protocoles_votes'][$protoId]['votes'][$vote['vote.id']] = $vote;
633 
		}
 633 
		}
634 
	}
 634 
	}
Line 635... Line 635...
635 
 
 635 
 
636 
	public function getTotalLignesTrouvees() {
 636 
	public function getTotalLignesTrouvees() {
637 
		$resultat = $this->bdd->recuperer('SELECT FOUND_ROWS() AS nbre');
 637 
		$resultat = $this->bdd->recuperer('SELECT FOUND_ROWS() AS nbre -- '.__FILE__.':'.__LINE__);
638 
		return intval($resultat['nbre']);
 638 
		return intval($resultat['nbre']);
639 
	}
 639 
	}
640 
}
 640 
}