Line 105... |
Line 105... |
105 |
/**
|
105 |
/**
|
106 |
* Retrouver les derniers votes image
|
106 |
* Retrouver les derniers votes image
|
107 |
* */
|
107 |
* */
|
108 |
private function getDerniersVotesImage() {
|
108 |
private function getDerniersVotesImage() {
|
Line 109... |
Line 109... |
109 |
|
109 |
|
110 |
$requete = 'SELECT id_vote, prenom, nom, nom_sel, intitule, ce_image, valeur, do.id_observation as del_obs, divo.date as date_vote '.
|
110 |
$requete = 'SELECT DISTINCT id_vote, prenom, nom, nom_sel, intitule, ce_image, valeur, dob.id_observation as del_obs, divo.date as date_vote '.
|
- |
|
111 |
' FROM `del_image_vote` divo '.
|
- |
|
112 |
' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '.
|
111 |
' FROM `del_image_vote` divo '.
|
113 |
' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '.
|
112 |
' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
|
- |
|
113 |
' INNER JOIN del_obs_image doi ON ce_image = id_image '.
|
- |
|
114 |
' INNER JOIN del_observation do ON do.id_observation = doi.id_observation '.
|
114 |
' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
|
115 |
' INNER JOIN del_utilisateur ON do.ce_utilisateur = id_utilisateur '.
|
115 |
' INNER JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '.
|
116 |
$this->chargerClauseWhere()." ".
|
116 |
$this->chargerClauseWhere()." ".
|
117 |
' ORDER BY divo.date DESC '.
|
117 |
' ORDER BY divo.date DESC '.
|
118 |
' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
|
118 |
' LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
|
119 |
$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
|
119 |
$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
|