| Line 137... |
Line 137... |
| 137 |
if(@intval($this->parametres['masque.valeur_vote_min'])) $where[] = 'moyenne >= ' . intval($this->parametres['masque.valeur_vote_min']);
|
137 |
if(@intval($this->parametres['masque.valeur_vote_min'])) $where[] = 'moyenne >= ' . intval($this->parametres['masque.valeur_vote_min']);
|
| Line 138... |
Line 138... |
| 138 |
|
138 |
|
| 139 |
$limite = @min(intval($this->parametres['navigation.limite']), 1000);
|
139 |
$limite = @min(intval($this->parametres['navigation.limite']), 1000);
|
| Line -... |
Line 140... |
| - |
|
140 |
$limite = $limite ? $limite : 10; // 0 => 10
|
| - |
|
141 |
|
| 140 |
$limite = $limite ? $limite : 10; // 0 => 10
|
142 |
$whereClause = count($where) > 0 ? 'WHERE '.implode(' AND ', $where) : '';
|
| 141 |
|
143 |
|
| 142 |
$requeteLiaisons = sprintf(
|
144 |
$requeteLiaisons = sprintf(
|
| 143 |
'SELECT SQL_CALC_FOUND_ROWS %s ce_protocole, moyenne, nb_votes, nb_tags'
|
145 |
'SELECT SQL_CALC_FOUND_ROWS %s ce_protocole, moyenne, nb_votes, nb_tags'
|
| 144 |
// IF(LENGTH()) workaround pour la jointure sur tela_annuaire depuis un hash md5 casté
|
146 |
// IF(LENGTH()) workaround pour la jointure sur tela_annuaire depuis un hash md5 casté
|
| 145 |
. ' FROM v_del_image di LEFT JOIN del_utilisateur du ON du.id_utilisateur = IF(LENGTH(di.ce_utilisateur) > 5, 0, di.ce_utilisateur)'
|
147 |
. ' FROM v_del_image di LEFT JOIN del_utilisateur du ON du.id_utilisateur = IF(LENGTH(di.ce_utilisateur) > 5, 0, di.ce_utilisateur)'
|
| Line 146... |
Line 148... |
| 146 |
. ' LEFT JOIN del_image_stat ds ON di.id_image = ds.ce_image'
|
148 |
. ' LEFT JOIN del_image_stat ds ON di.id_image = ds.ce_image'
|
| 147 |
. ' WHERE %s GROUP BY id_image /* car plusieurs image pour obs, see PHP */ ORDER BY moyenne LIMIT %d, %d -- %s:%d',
|
149 |
. ' %s GROUP BY id_image ORDER BY moyenne LIMIT %d,%d -- %s:%d',
|
| 148 |
|
150 |
|
| 149 |
implode(', ',$champs),
|
151 |
implode(', ',$champs),
|
| 150 |
implode(' AND ', $where),
|
152 |
$whereClause,
|
| Line 151... |
Line 153... |
| 151 |
intval(@$this->parametres['navigation.depart']),
|
153 |
intval(@$this->parametres['navigation.depart']),
|