Subversion Repositories eFlore/Applications.del

Rev

Rev 759 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 759 Rev 760
Line 259... Line 259...
259
259
260 
	/**
 260 
	/**
261 
	* Charger les votes pour chaque image
 261 
	* Charger les votes pour chaque image
262 
	* */
 262 
	* */
263 
	private function chargerVotes($images) {
 - 
 
264
- 
 
265
- 
 
266
263 
	private function chargerVotes($images) {
267 
			$requeteVotes = 'SELECT * FROM '.
 264 
			$requeteVotes = 'SELECT v.*, p.* FROM '.
- 
 
 265 
								$this->gestionBdd->formaterTable('del_image_vote', 'v').
- 
 
 266 
								' INNER JOIN del_image_protocole p '.
268 
			                $this->gestionBdd->formaterTable('del_image_vote').
 267 
									'ON v.ce_protocole = p.id_protocole '.
269 
			                'WHERE '.$this->chargerClauseWhereVotes();
 268 
							'WHERE '.$this->chargerClauseWhereVotes();
Line 270... Line 269...
270 
			$resultatsVotes = $this->bdd->recupererTous($requeteVotes);
 269 
			$resultatsVotes = $this->bdd->recupererTous($requeteVotes);
271
270
Line 272... Line 271...
272
271
273 
			//TODO : faire une méthode formater vote
 272 
			//TODO : faire une méthode formater vote
274 
			$votes = $this->formaterVotes($resultatsVotes);
 273 
			$votes = $this->formaterVotes($resultatsVotes);
275
274
276 
			foreach ($images as $id => $image) {
 275 
			foreach ($images as $id => $image) {
Line 277... Line 276...
277 
				if (isset($votes[$image['id_image']])) {
 276 
				if (isset($votes[$image['id_image']])) {
278 
					$images[$id]['votes'] = $votes[$image['id_image']];
 277 
					$images[$id]['protocoles votes'] = $votes[$image['id_image']];
Line 279... Line 278...
279 
				}
 278 
				}
280 
			}
 279 
			}
281
280
282 
		return $images;
 281 
		return $images;
283 
	}
 282 
	}
284
283
285 
	private function chargerClauseWhereVotes() {
 284 
	private function chargerClauseWhereVotes() {
286 
		if (sizeof($this->imageIds) > 0) {
 285 
		if (sizeof($this->imageIds) > 0) {
287 
			$chaineImageIds = implode(',', $this->imageIds);
 286 
			$chaineImageIds = implode(',', $this->imageIds);
288 
			$where[] = 'ce_image  IN ('.$chaineImageIds.')';
 287 
			$where[] = 'v.ce_image  IN ('.$chaineImageIds.')';
Line 289... Line 288...
289 
		}
 288 
		}
Line 320... Line 319...
320 
	private function formaterVotes($votes) {
 319 
	private function formaterVotes($votes) {
321 
		$retour = array();
 320 
		$retour = array();
322 
		foreach ($votes as $vote) {
 321 
		foreach ($votes as $vote) {
323 
			$retour_vote = array();
 322 
			$retour_vote = array();
324 
			foreach ($vote as $param=>$valeur) {
 323 
			foreach ($vote as $param=>$valeur) {
- 
 
 324 
				if (strpos($this->mappingVotes[$param], 'protocole.') === 0) {
- 
 
 325 
					$retour_protocole[$this->mappingVotes[$param]] = $valeur;
- 
 
 326 
				} else {
325 
				$retour_vote[$this->mappingVotes[$param]] = $valeur;
 327 
					$retour_vote[$this->mappingVotes[$param]] = $valeur;
- 
 
 328 
				}
- 
 
 329 
			}
- 
 
 330 
			if (!isset($retour[$vote['ce_image']][$vote['ce_protocole']])) {
- 
 
 331 
				$retour[$vote['ce_image']][$vote['ce_protocole']] = $retour_protocole;
326 
			}
 332 
			}
327 
			$retour[$vote['ce_image']][$vote['ce_protocole']][$vote['id_vote']] = $retour_vote;
 333 
			$retour[$vote['ce_image']][$vote['ce_protocole']]['votes'][$vote['id_vote']] = $retour_vote;
328 
		}
 334 
		}
Line 329... Line 335...
329
335
330 
		return $retour;
 336 
		return $retour;