| Line 158... |
Line 158... |
| 158 |
* Retrouver les derniers votes image
|
158 |
* Retrouver les derniers votes image
|
| 159 |
* */
|
159 |
* */
|
| 160 |
private function getDerniersVotesImage() {
|
160 |
private function getDerniersVotesImage() {
|
| 161 |
$idsVotes = $this->getIdsDerniersVotesImage();
|
161 |
$idsVotes = $this->getIdsDerniersVotesImage();
|
| 162 |
$idsVotesConcat = implode(', ', $idsVotes);
|
162 |
$idsVotesConcat = implode(', ', $idsVotes);
|
| 163 |
$requete = 'SELECT id_vote, ce_image, valeur, divo.date AS date_vote, '.
|
163 |
$requete = 'SELECT DISTINCT id_vote, ce_image, valeur, divo.date AS date_vote, '.
|
| 164 |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '.
|
164 |
' duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '.
|
| 165 |
' duv.prenom AS votant_prenom, duv.nom AS votant_nom, '.
|
165 |
' duv.prenom AS votant_prenom, duv.nom AS votant_nom, '.
|
| 166 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '.
|
166 |
' do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '.
|
| 167 |
'FROM del_image_vote AS divo '.
|
167 |
'FROM del_image_vote AS divo '.
|
| 168 |
' INNER JOIN del_image AS di '.
|
168 |
' INNER JOIN del_image AS di '.
|