Line 278... |
Line 278... |
278 |
' INNER JOIN del_observation AS do '.
|
278 |
' INNER JOIN del_observation AS do '.
|
279 |
' ON doi.id_observation = do.id_observation '.
|
279 |
' ON doi.id_observation = do.id_observation '.
|
280 |
' LEFT JOIN del_utilisateur AS duo '.
|
280 |
' LEFT JOIN del_utilisateur AS duo '.
|
281 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
281 |
' ON do.ce_utilisateur = duo.id_utilisateur '.
|
282 |
' LEFT JOIN del_utilisateur AS du '.
|
282 |
' LEFT JOIN del_utilisateur AS du '.
|
283 |
' ON CAST(dit.ce_utilisateur AS UNSIGNED) = du.id_utilisateur '.
|
283 |
' ON if((CHAR_LENGTH(dit.ce_utilisateur) <> 32),CAST(dit.ce_utilisateur AS unsigned),0) '.
|
- |
|
284 |
' = du.id_utilisateur '.
|
284 |
'WHERE actif = 1 '.
|
285 |
'WHERE actif = 1 '.
|
285 |
$this->chargerClauseWhere().' '.
|
286 |
$this->chargerClauseWhere().' '.
|
286 |
'ORDER BY date DESC '.
|
287 |
'ORDER BY date DESC '.
|
287 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
|
288 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite();
|
288 |
$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
|
289 |
$elements = $this->gestionBdd->getBdd()->recupererTous($requete);
|