| Line 165... |
Line 165... |
| 165 |
|
165 |
|
| 166 |
/**
|
166 |
/**
|
| 167 |
* Retrouver les derniers votes image
|
167 |
* Retrouver les derniers votes image
|
| 168 |
* */
|
168 |
* */
|
| - |
|
169 |
private function getDerniersVotesImage() {
|
| 169 |
private function getDerniersVotesImage() {
|
170 |
$elements = array();
|
| - |
|
171 |
$idsTags = $this->getIdsDerniersVotesImage();
|
| 170 |
$idsTags = $this->getIdsDerniersVotesImage();
|
172 |
if (!empty($idsTags)) {
|
| 171 |
$idsTagsConcat = implode(', ', $idsTags);
|
173 |
$idsTagsConcat = implode(', ', $idsTags);
|
| 172 |
$requete = 'SELECT DISTINCT id_tag, tag, date, '.
|
174 |
$requete = 'SELECT DISTINCT id_tag, tag, date, '.
|
| 173 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '.
|
175 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, di.id_image, '.
|
| 174 |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '.
|
176 |
' duo.prenom AS auteur_prenom, duo.nom AS auteur_nom, duo.courriel AS auteur_courriel, '.
|
| 175 |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '.
|
177 |
' du.prenom AS tagueur_prenom, du.nom AS tagueur_nom, du.courriel AS tagueur_courriel '.
|
| 176 |
'FROM del_image_tag AS dit '.
|
178 |
'FROM del_image_tag AS dit '.
|
| 177 |
' INNER JOIN del_image AS di '.
|
179 |
' INNER JOIN del_image AS di '.
|
| 178 |
' ON ce_image = id_image '.
|
180 |
' ON ce_image = id_image '.
|
| 179 |
' INNER JOIN del_observation AS do '.
|
181 |
' INNER JOIN del_observation AS do '.
|
| 180 |
' ON di.ce_observation = do.id_observation '.
|
182 |
' ON di.ce_observation = do.id_observation '.
|
| 181 |
' LEFT JOIN del_utilisateur AS duo '.
|
183 |
' LEFT JOIN del_utilisateur AS duo '.
|
| 182 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
184 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
| 183 |
' LEFT JOIN del_utilisateur AS du '.
|
185 |
' LEFT JOIN del_utilisateur AS du '.
|
| 184 |
' ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '.
|
186 |
' ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '.
|
| 185 |
' = du.id_utilisateur '.
|
187 |
' = du.id_utilisateur '.
|
| 186 |
'WHERE actif = 1 '.
|
188 |
'WHERE actif = 1 '.
|
| 187 |
" AND id_tag IN ($idsTagsConcat) ".
|
189 |
" AND id_tag IN ($idsTagsConcat) ".
|
| 188 |
'ORDER BY date DESC '.
|
190 |
'ORDER BY date DESC '.
|
| 189 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
191 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
| 190 |
' -- '.__FILE__.' : '.__LINE__;
|
192 |
' -- '.__FILE__.' : '.__LINE__;
|
| - |
|
193 |
$elements = $this->bdd->recupererTous($requete);
|
| 191 |
$elements = $this->bdd->recupererTous($requete);
|
194 |
}
|
| 192 |
return $elements;
|
195 |
return $elements;
|
| Line 193... |
Line 196... |
| 193 |
}
|
196 |
}
|
| 194 |
|
197 |
|
| Line 204... |
Line 207... |
| 204 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
207 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
| 205 |
' -- '.__FILE__.' : '.__LINE__;
|
208 |
' -- '.__FILE__.' : '.__LINE__;
|
| 206 |
$resultats = $this->bdd->recupererTous($requete);
|
209 |
$resultats = $this->bdd->recupererTous($requete);
|
| Line 207... |
Line 210... |
| 207 |
|
210 |
|
| 208 |
$idsTags = array();
|
211 |
$idsTags = array();
|
| 209 |
if ($resultats != false && is_array($idsTags)) {
|
212 |
if ($resultats != false && is_array($resultats)) {
|
| 210 |
foreach ($resultats as $infos) {
|
213 |
foreach ($resultats as $infos) {
|
| 211 |
$idsTags[] = $infos['id_tag'];
|
214 |
$idsTags[] = $infos['id_tag'];
|
| 212 |
}
|
215 |
}
|
| 213 |
}
|
216 |
}
|