Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 945 Rev 949
Line 22... Line 22...
22
	private $flux = array();
22
	private $flux = array();
Line 23... Line 23...
23
	
23
	
Line 24... Line 24...
24
	private $format_image = 'XL';
24
	private $format_image = 'XL';
25
	
25
	
26
	private $criteres = array(
26
	private $criteres = array(
27
		'utilisateur' => 'c.ci_ce_utilisateur', 
27
		'utilisateur' => 'c.id_utilisateur', 
28
		'commune' => 'b.location', 
28
		'commune' => 'b.zone_geo', 
29
		'dept' => 'b.id_location',
29
		'dept' => 'b.id_zone_geo',
30
		'taxon' => 'b.nom_ret',
30
		'taxon' => 'b.nom_ret',
31
		'commentaire' => 'c.ci_meta_comment',
31
		'commentaire' => 'c.commentaire',
32
		'date' => 'c.ci_meta_date',
32
		'date' => 'c.date_prise_de_vue',
Line 33... Line 33...
33
		'tag' => 'tag',
33
		'tag' => 'tag',
34
		'projet' => 'projet');
34
		'projet' => 'projet');
Line 392... Line 392...
392
			'	INNER JOIN cel_inventory AS b '.
392
			'	INNER JOIN cel_inventory AS 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 AS c '.
394
			'	INNER JOIN cel_images AS 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.identifiant = c.ci_ce_utilisateur '.
396
			'WHERE b.identifiant = c.ci_ce_utilisateur '.
397
			(($this->etreFluxAdmin()) ? '' : ' b.transmission = 1  AND ').
397
			(($this->etreFluxAdmin()) ? '' : 'AND b.transmission = 1 ').
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 593... Line 593...
593
		$where = '';
593
		$where = '';
594
		$champs = 'a.cmc_id_proprietaire , ';
594
		$champs = 'a.cmc_id_proprietaire , ';
595
		$table = '';
595
		$table = '';
596
		$i = "a"; $j = "a";
596
		$i = "a"; $j = "a";
Line 597... Line 597...
597
		
597
		
-
 
598
		$tab_mots_cles = explode("ET", $mot_cle);
598
		$tab_mots_cles = explode("ET", $mot_cle); 
599
		 
599
		foreach ($tab_mots_cles as $mot) {
600
		foreach ($tab_mots_cles as $mot) {
600
			$champs .= "$i.cmc_id_mot_cle_utilisateur as $i , ";
601
			$champs .= "$i.cmc_id_mot_cle_utilisateur as $i , ";
601
			$table .= "cel_mots_cles_obs $i , ";
602
			$table .= "cel_mots_cles_obs $i , ";
602
			$where .= "$i.cmc_id_mot_cle_general = ".$this->bdd->quote($this->encoderMotCle(trim($mot))).' AND ';
603
			$where .= "$i.cmc_id_mot_cle_general = ".$this->bdd->quote($this->encoderMotCle(trim($mot))).' AND ';