| Line 185... |
Line 185... |
| 185 |
private function getIdsDerniersCommentaires() {
|
185 |
private function getIdsDerniersCommentaires() {
|
| 186 |
$clauseWhere = $this->chargerClauseWhere();
|
186 |
$clauseWhere = $this->chargerClauseWhere();
|
| 187 |
$requete = 'SELECT DISTINCT dc.id_commentaire '.
|
187 |
$requete = 'SELECT DISTINCT dc.id_commentaire '.
|
| 188 |
'FROM del_commentaire AS dc '.
|
188 |
'FROM del_commentaire AS dc '.
|
| 189 |
' INNER JOIN del_observation AS dob ON (dc.ce_observation = dob.id_observation) '.
|
189 |
' INNER JOIN del_observation AS dob ON (dc.ce_observation = dob.id_observation) '.
|
| 190 |
' LEFT JOIN del_utilisateur AS duo ON (dob.ce_utilisateur = duo.id_utilisateur) '.
|
- |
|
| 191 |
'WHERE proposition_initiale != 1 '.
|
190 |
'WHERE proposition_initiale != 1 '.
|
| - |
|
191 |
'AND dc.date >= DATE_ADD(CURDATE(), INTERVAL -7 DAY) '.
|
| 192 |
($clauseWhere != '' ? "AND $clauseWhere " : '').
|
192 |
($clauseWhere != '' ? "AND $clauseWhere " : '').
|
| 193 |
'ORDER BY dc.date DESC '.
|
193 |
'ORDER BY dc.date DESC '.
|
| 194 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
194 |
'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().' '.
|
| 195 |
' -- '.__FILE__.' : '.__LINE__;
|
195 |
' -- '.__FILE__.' : '.__LINE__;
|
| 196 |
//echo $requete;
|
196 |
//echo $requete;
|