Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1000 Rev 1021
Line 381... Line 381...
381 
	/**
 381 
	/**
382 
	* Chargement depuis la bdd de toutes les liaisons entre images et observations
 382 
	* Chargement depuis la bdd de toutes les liaisons entre images et observations
383 
	* */
 383 
	* */
384 
	private function chargerLiaisons() {
 384 
	private function chargerLiaisons() {
Line 385... Line 385...
385
385
386 
		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte '.
 386 
		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte, dob.commentaire as dob_commentaire '.
387 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
 387 
						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
388 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
 388 
						   'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
389 
						   'ON doi.id_observation = dob.id_observation '.
 389 
						   'ON doi.id_observation = dob.id_observation '.
390 
						   'INNER JOIN del_utilisateur du '.
 390 
						   'INNER JOIN del_utilisateur du '.
Line 394... Line 394...
394 
		$requeteLiaisons .= $this->chargerClauseWhere();
 394 
		$requeteLiaisons .= $this->chargerClauseWhere();
395 
		$requeteLiaisons .= ' GROUP BY doi.id_observation';
 395 
		$requeteLiaisons .= ' GROUP BY doi.id_observation';
396 
		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';
 396 
		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';
397 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
 397 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
Line 398... Line -...
398
- 
 
399
398
400 
		return $this->bdd->recupererTous($requeteLiaisons);
 399 
		return $this->bdd->recupererTous($requeteLiaisons);
Line 401... Line 400...
401 
	}
 400 
	}
402
401