Subversion Repositories eFlore/Applications.del

Rev

Rev 2095 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2095 Rev 2145
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;