Line 110... |
Line 110... |
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 '.
|
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 '.
|
111 |
' FROM `del_image_vote` divo '.
|
112 |
' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '.
|
112 |
' INNER JOIN del_obs_image doi ON divo.ce_image = doi.id_image '.
|
113 |
' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '.
|
113 |
' INNER JOIN del_observation dob ON dob.id_observation = doi.id_observation '.
|
114 |
' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
|
114 |
' INNER JOIN del_image_protocole ON ce_protocole = id_protocole '.
|
115 |
' INNER JOIN del_utilisateur ON dob.ce_utilisateur = id_utilisateur '.
|
115 |
' LEFT 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);
|
120 |
return $elements;
|
120 |
return $elements;
|