| 187,8 → 187,8 |
|---|
| $requete = 'SELECT DISTINCT dc.id_commentaire '. |
| 'FROM del_commentaire AS dc '. |
| ' INNER JOIN del_observation AS dob ON (dc.ce_observation = dob.id_observation) '. |
| ' LEFT JOIN del_utilisateur AS duo ON (dob.ce_utilisateur = duo.id_utilisateur) '. |
| 'WHERE proposition_initiale != 1 '. |
| 'AND dc.date >= DATE_ADD(CURDATE(), INTERVAL -7 DAY) '. |
| ($clauseWhere != '' ? "AND $clauseWhere " : ''). |
| 'ORDER BY dc.date DESC '. |
| 'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '. |
| 264,4 → 264,4 |
|---|
| } |
| return $whereAuteur; |
| } |
| } |
| } |