Subversion Repositories eFlore/Applications.del

Rev

Rev 2008 | Rev 2157 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2008 Rev 2146
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;
Line 262... Line 262...
262
				}
262
				}
263
			}
263
			}
264
		}
264
		}
265
		return $whereAuteur;
265
		return $whereAuteur;
266
	}
266
	}
267
}
-
 
268
267
}
-
 
268