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);
|