Subversion Repositories eFlore/Applications.del

	* */

	* */

	private function chargerLiaisons() {

	private function chargerLiaisons() {

		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS dob.id_observation, nom_sel, famille, ce_zone_geo, zone_geo, lieudit, station, milieu, date_observation, dob.mots_cles_texte, date_transmission, di.id_image, dob.ce_utilisateur, prenom, nom, courriel, nom_original, dob.commentaire as dob_commentaire, dob.nt, dob.nom_sel_nn '.

		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS dob.id_observation, nom_sel, famille, ce_zone_geo, zone_geo, lieudit, station, milieu, date_observation, dob.mots_cles_texte, date_transmission, di.id_image, dob.ce_utilisateur, prenom, nom, courriel, nom_original, dob.commentaire as dob_commentaire, dob.nt, dob.nom_sel_nn '.

						   'ON doi.id_observation = dob.id_observation '.

						   'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').

						   'LEFT JOIN del_utilisateur du '.

						   'LEFT JOIN del_utilisateur du '.

						   'INNER JOIN del_image di '.

						   'LEFT JOIN del_image di '.

						   'ON di.id_image = doi.id_image ';

		$requeteLiaisons .= $this->chargerClauseWhere();

		$requeteLiaisons .= $this->chargerClauseWhere();

		$requeteLiaisons .= ' GROUP BY doi.id_observation';

		$requeteLiaisons .= ' GROUP BY doi.id_observation';

		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';

		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';

		//echo $requeteLiaisons;exit;

		return $this->bdd->recupererTous($requeteLiaisons);

		return $this->bdd->recupererTous($requeteLiaisons);

	}

	}