Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1922 Rev 1924
Line 106... Line 106...
106 
	private function getIdsImages() {
 106 
	private function getIdsImages() {
107 
		$whereClause = $this->getClauseWhere();
 107 
		$whereClause = $this->getClauseWhere();
108 
		$depart = $this->navigation->getDepart();
 108 
		$depart = $this->navigation->getDepart();
109 
		$limite = $this->navigation->getLimite();
 109 
		$limite = $this->navigation->getLimite();
Line 110... Line 110...
110 
 
 110 
 
111 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS di.id_image '.
 111 
		$requete = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS di.id_image '.
112 
			'FROM del_image AS di '.
 112 
			'FROM del_image AS di '.
113 
			'	LEFT JOIN del_image_stat AS ds ON (di.id_image = ds.ce_image) '.
 113 
			'	LEFT JOIN del_image_stat AS ds ON (di.id_image = ds.ce_image) '.
114 
			"$whereClause ".
 114 
			"$whereClause ".
115 
			'ORDER BY moyenne DESC, id_image DESC '.
 115 
			'ORDER BY moyenne DESC, id_image DESC '.
Line 140... Line 140...
140 
	}
 140 
	}
Line 141... Line 141...
141 
 
 141 
 
142 
	private function chargerInfos() {
 142 
	private function chargerInfos() {
Line 143... Line 143...
143 
		$idImgsConcat = implode(',', $this->idsImagesOrdonnees);
 143 
		$idImgsConcat = implode(',', $this->idsImagesOrdonnees);
144 
 
 144 
 
145 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS '.
 145 
		$requete = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS '.
146 
			'di.id_image, di.mots_cles_texte AS mots_cles_texte_image, '.
 146 
			'di.id_image, di.mots_cles_texte AS mots_cles_texte_image, '.
147 
			'do.id_observation, nom_referentiel, nom_ret, '.
 147 
			'do.id_observation, nom_referentiel, nom_ret, '.
148 
			'nom_ret_nn, nt, famille, ce_zone_geo, zone_geo, date_observation, '.
 148 
			'nom_ret_nn, nt, famille, ce_zone_geo, zone_geo, date_observation, '.