Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1894 Rev 1897
Line 150... Line 150...
150 
			$observateur = $info['observateur_prenom'].' '.$info['observateur_nom'];
 150 
			$observateur = $info['observateur_prenom'].' '.$info['observateur_nom'];
151 
		}
 151 
		}
152 
		return $observateur;
 152 
		return $observateur;
153 
	}
 153 
	}
Line -... Line 154...
- 
 
 154 
 
- 
 
 155 
 
154 
 
 156 
 
155 
	/**
 157 
	/**
156 
	 * Retrouver les derniers votes image
 158 
	 * Retrouver les derniers votes image
157 
	 * */
 159 
	 * */
158 
	private function getDerniersVotesImage() {
 160 
	private function getDerniersVotesImage() {
- 
 
 161 
		$idsVotes = $this->getIdsDerniersVotesImage();
159 
		$clauseWhere = $this->chargerClauseWhere();
 162 
		$idsVotesConcat = implode(', ', $idsVotes);
160 
		$requete =  'SELECT DISTINCT id_vote, ce_image, valeur, divo.date AS date_vote, '.
 163 
		$requete =  'SELECT id_vote, ce_image, valeur, divo.date AS date_vote, '.
161 
				'	duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '.
 164 
				'	duo.prenom AS observateur_prenom, duo.nom AS observateur_nom, '.
162 
				'	duv.prenom AS votant_prenom, duv.nom AS votant_nom, '.
 165 
				'	duv.prenom AS votant_prenom, duv.nom AS votant_nom, '.
163 
				'	do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '.
 166 
				'	do.id_observation, do.nom_sel, do.zone_geo, do.date_observation, dip.intitule '.
164 
				'FROM del_image_vote AS divo '.
 167 
				'FROM del_image_vote AS divo '.
Line 171... Line 174...
171 
				'	LEFT JOIN del_utilisateur AS duo '.
 174 
				'	LEFT JOIN del_utilisateur AS duo '.
172 
				'		ON do.ce_utilisateur = duo.id_utilisateur '.
 175 
				'		ON do.ce_utilisateur = duo.id_utilisateur '.
173 
				'	LEFT JOIN del_utilisateur AS duv '.
 176 
				'	LEFT JOIN del_utilisateur AS duv '.
174 
				'		ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '.
 177 
				'		ON if((CHAR_LENGTH(divo.ce_utilisateur) <> 32),CAST(divo.ce_utilisateur AS unsigned),0) '.
175 
				'			= duv.id_utilisateur '.
 178 
				'			= duv.id_utilisateur '.
176 
				($clauseWhere != '' ? "WHERE $clauseWhere " : '').
 179 
				"WHERE id_vote IN ($idsVotesConcat) ".
177 
				'ORDER BY divo.date DESC '.
 180 
				'ORDER BY divo.date DESC '.
178 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().
 181 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().
179 
				' -- '.__FILE__.' : '.__LINE__;
 182 
				' -- '.__FILE__.' : '.__LINE__;
180 
 
 - 
 
181 
		$elements = $this->bdd->recupererTous($requete);
 183 
		$elements = $this->bdd->recupererTous($requete);
182 
		return $elements;
 184 
		return $elements;
183 
	}
 185 
	}
Line -... Line 186...
- 
 
 186 
 
- 
 
 187 
	/**
- 
 
 188 
	 * Retrouver les ids des derniers votes image
- 
 
 189 
	 * */
- 
 
 190 
	private function getIdsDerniersVotesImage() {
- 
 
 191 
		$clauseWhere = $this->chargerClauseWhere();
- 
 
 192 
		$requete =  'SELECT DISTINCT id_vote '.
- 
 
 193 
				'FROM del_image_vote '.
- 
 
 194 
				($clauseWhere != '' ? "WHERE $clauseWhere " : '').
- 
 
 195 
				'ORDER BY date DESC '.
- 
 
 196 
				'LIMIT '.$this->navigation->getDepart().','.$this->navigation->getLimite().
- 
 
 197 
				' -- '.__FILE__.' : '.__LINE__;
- 
 
 198 
		$resultats = $this->bdd->recupererTous($requete);
- 
 
 199 
 
- 
 
 200 
		$idsVotes = array();
- 
 
 201 
		if ($resultats != false && is_array($idsVotes)) {
- 
 
 202 
			foreach ($resultats as $infos) {
- 
 
 203 
				$idsVotes[] = $infos['id_vote'];
- 
 
 204 
			}
- 
 
 205 
		}
- 
 
 206 
		return $idsVotes;
- 
 
 207 
	}
184 
 
 208 
 
185 
	private function chargerClauseWhere() {
 209 
	private function chargerClauseWhere() {
186 
		$where = array();
 210 
		$where = array();
187 
		$filtres = $this->navigation->getFiltre();
 211 
		$filtres = $this->navigation->getFiltre();
188 
		if (!empty($filtres)) {
 212 
		if (!empty($filtres)) {