Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1171 Rev 1173
Line 191... Line 191...
191 
						   'ON du.id_utilisateur = di.ce_utilisateur '.
 191 
						   'ON du.id_utilisateur = di.ce_utilisateur '.
192 
						   'LEFT JOIN del_image_vote dvote '.
 192 
						   'LEFT JOIN del_image_vote dvote '.
193 
						   'ON doi.id_image = dvote.ce_image '.
 193 
						   'ON doi.id_image = dvote.ce_image '.
194 
							($this->parametres['masque.protocole'] != null ? 'AND dvote.ce_protocole = '.$this->parametres['masque.protocole'].' ' : ' ');
 194 
							($this->parametres['masque.protocole'] != null ? 'AND dvote.ce_protocole = '.$this->parametres['masque.protocole'].' ' : ' ');
195 
		$requeteLiaisons .= 'GROUP BY dvote.ce_image '.
 195 
		$requeteLiaisons .= 'GROUP BY dvote.ce_image '.
196 
							($this->parametres['masque.valeur_vote_min'] != null ? 'HAVING AVG(dvote.valeur) >= '.$this->parametres['masque.valeur_vote_min'].' ' : ' ').
 196 
							($this->parametres['masque.valeur_vote_min'] != null && $this->parametres['masque.valeur_vote_min'] != 0 ? 'HAVING AVG(dvote.valeur) >= '.$this->parametres['masque.valeur_vote_min'].' ' : ' ').
197 
							'ORDER BY moyenne_votes';
 197 
							'ORDER BY moyenne_votes';
198 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
 198 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
Line 199... Line 199...
199 
 
 199 
 
200 
		return $this->bdd->recupererTous($requeteLiaisons);
 200 
		return $this->bdd->recupererTous($requeteLiaisons);