Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 813 Rev 814
Line 390... Line 390...
390 
		$requete = 'SELECT * '.
 390 
		$requete = 'SELECT * '.
391 
			'FROM cel_obs_images a '.
 391 
			'FROM cel_obs_images a '.
392 
			'	INNER JOIN cel_inventory b '.
 392 
			'	INNER JOIN cel_inventory b '.
393 
			'		ON (a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant) '.
 393 
			'		ON (a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant) '.
394 
			'	INNER JOIN cel_images c '.
 394 
			'	INNER JOIN cel_images c '.
395 
			'		ON (a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur) '.
395 
			'		ON (a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur) '.
396 
			'WHERE b.transmission = 1 '.
 396 
			'WHERE '.(($this->etreFluxAdmin()) ? '' : ' b.transmission = 1  AND ').
397 
			'	AND b.identifiant = c.ci_ce_utilisateur '.
 397 
			'	b.identifiant = c.ci_ce_utilisateur '.
398 
			'	AND ';
 398 
			'	AND ';
Line 399... Line 399...
399
399
400 
		if ($this->estUneRechercheGenerale()) {
 400 
		if ($this->estUneRechercheGenerale()) {
401 
			$chaine_requete = $_GET['recherche'];
 401 
			$chaine_requete = $_GET['recherche'];
Line 408... Line 408...
408 
		}
 408 
		}
409 
		$requete = str_replace(' AND ) ',' ', $requete);
 409 
		$requete = str_replace(' AND ) ',' ', $requete);
410 
		$requete = rtrim($requete, 'AND ');
 410 
		$requete = rtrim($requete, 'AND ');
411 
		$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  :
411 
		$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  :
412 
			'c.ci_meta_date_ajout DESC').' '."LIMIT $this->start,$this->limit ";
 412 
			'c.ci_meta_date_ajout DESC').' '."LIMIT $this->start,$this->limit ";
413
- 
 
414 
		$elements = $this->executerRequete($requete);
 413 
		$elements = $this->executerRequete($requete);
Line 415... Line 414...
415 
 
 414 
 
416 
		// Création du contenu
 415 
		// Création du contenu
417 
		if ($elements != false && count($elements) > 0) {
 416 
		if ($elements != false && count($elements) > 0) {