Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 330 Rev 331
Line 300... Line 300...
300 
			'FROM cel_images AS ci'.
 300 
			'FROM cel_images AS ci'.
301 
			'	LEFT JOIN cel_obs_images AS coi  '.
 301 
			'	LEFT JOIN cel_obs_images AS coi  '.
302 
			'		ON (coi.coi_ce_image = ci.ci_id_image) '.
 302 
			'		ON (coi.coi_ce_image = ci.ci_id_image) '.
303 
			'	LEFT JOIN cel_inventory AS co '.
 303 
			'	LEFT JOIN cel_inventory AS co '.
304 
			'		ON (coi.coi_ce_observation = co.ordre AND coi.coi_ce_utilisateur = co.identifiant) '.
 304 
			'		ON (coi.coi_ce_observation = co.ordre AND coi.coi_ce_utilisateur = co.identifiant) '.
305 
			'WHERE co.transmission = 1 '.
 - 
 
306 
			"	AND co.num_nom_ret IN ($numNomListe) ".
 305 
			$this->formerRequeteConditions($numNomListe).
307 
			'GROUP BY id_img '.
 306 
			' GROUP BY id_img '.
- 
 
 307 
			$this->formerRequeteOrdre().
308 
			"LIMIT $depart,$limite ";
 308 
			"LIMIT $depart,$limite ";
Line 309... Line 309...
309 
 
 309 
 
310 
		$this->infosImages = $this->Bdd->recupererTous($requete);
 310 
		$this->infosImages = $this->Bdd->recupererTous($requete);
- 
 
 311 
	}
- 
 
 312
- 
 
 313 
	private function formerRequeteConditions($numNomListe) {
- 
 
 314 
		$where[] = " co.transmission = 1 AND co.num_nom_ret IN ($numNomListe) ";
- 
 
 315 
		if (isset($this->parametres['retour.tri']) && $this->parametres['retour.tri'] == 'date') {
- 
 
 316 
			$where[] = ' ci.ci_meta_date != "0000-00-00"';
- 
 
 317 
		}
- 
 
 318 
		return ' WHERE '.implode(' AND ', $where);
- 
 
 319 
	}
- 
 
 320
- 
 
 321 
	private function formerRequeteOrdre() {
- 
 
 322 
		$order = "";
- 
 
 323 
		if (isset($this->parametres['retour.tri']) && $this->parametres['retour.tri'] == 'date') {
- 
 
 324 
			$order = ' ORDER BY ci.ci_meta_date ASC ';
- 
 
 325 
		}
- 
 
 326 
		return $order;
- 
 
 327 
	}
Line 311... Line 328...
311 
	}
 328
312 
 
 329 
 
313 
	private function chargerNbreImagesTotal() {
 330 
	private function chargerNbreImagesTotal() {
314 
		$requete = 'SELECT FOUND_ROWS() AS nbre ';
 331 
		$requete = 'SELECT FOUND_ROWS() AS nbre ';