Subversion Repositories eFlore/Applications.del

Rev

Rev 2095 | Show entire file | Ignore 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;
Line 262... Line 262...
262 
				}
 262 
				}
263 
			}
 263 
			}
264 
		}
 264 
		}
265 
		return $whereAuteur;
 265 
		return $whereAuteur;
266 
	}
 266 
	}
267 
}
 - 
 
268 

            267
            
}

          

          

            -
            
 

            268