Subversion Repositories eFlore/Applications.cel

	private $flux = array();

	private $flux = array();

	private $format_image = 'XL';

	private $format_image = 'XL';

		'commune' => 'b.location', 

		'commune' => 'b.zone_geo', 

		'commentaire' => 'c.ci_meta_comment',

		'commentaire' => 'c.commentaire',

		'date' => 'c.ci_meta_date',

		'date' => 'c.date_prise_de_vue',

		'tag' => 'tag',

		'tag' => 'tag',

		'projet' => 'projet');

		'projet' => 'projet');

			'	INNER JOIN cel_inventory AS b '.

			'	INNER JOIN cel_inventory AS b '.

			'		ON (a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant) '.

			'		ON (a.coi_ce_observation = b.ordre AND a.coi_ce_utilisateur = b.identifiant) '.

			'	INNER JOIN cel_images AS c '.

			'	INNER JOIN cel_images AS c '.

			'		ON (a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur) '. 

			'		ON (a.coi_ce_image = c.ci_id_image AND a.coi_ce_utilisateur = c.ci_ce_utilisateur) '. 

			'WHERE b.identifiant = c.ci_ce_utilisateur '.

			'WHERE b.identifiant = c.ci_ce_utilisateur '.

			'	AND ';

			'	AND ';

		if ($this->estUneRechercheGenerale()) {

		if ($this->estUneRechercheGenerale()) {

			$chaine_requete = $_GET['recherche'];

			$chaine_requete = $_GET['recherche'];

		$where = '';

		$where = '';

		$champs = 'a.cmc_id_proprietaire , ';

		$champs = 'a.cmc_id_proprietaire , ';

		$table = '';

		$table = '';

		$i = "a"; $j = "a";

		$i = "a"; $j = "a";

		$tab_mots_cles = explode("ET", $mot_cle); 

		foreach ($tab_mots_cles as $mot) {

		foreach ($tab_mots_cles as $mot) {

			$champs .= "$i.cmc_id_mot_cle_utilisateur as $i , ";

			$champs .= "$i.cmc_id_mot_cle_utilisateur as $i , ";

			$table .= "cel_mots_cles_obs $i , ";

			$table .= "cel_mots_cles_obs $i , ";

			$where .= "$i.cmc_id_mot_cle_general = ".$this->bdd->quote($this->encoderMotCle(trim($mot))).' AND ';

			$where .= "$i.cmc_id_mot_cle_general = ".$this->bdd->quote($this->encoderMotCle(trim($mot))).' AND ';