Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 2414 Rev 2436
Line 55... Line 55...
55 
		return $mots_cles;
 55 
		return $mots_cles;
56 
	}
 56 
	}
Line 57... Line 57...
57 
 
 57 
 
58 
	public function obtenirLiaisonsMotsClesOriginaux() {
 58 
	public function obtenirLiaisonsMotsClesOriginaux() {
59 
		if ($this->mode == 'obs') {
 59 
		if ($this->mode == 'obs') {
60 
			$requete = "SELECT comc.id_observation as id_element_lie, comc.id_mot_cle_obs as id_mot_cle, id_utilisateur as id_utilisateur ".
 60 
			$requete = "SELECT comc.id_observation AS id_element_lie, comc.id_mot_cle_obs AS id_mot_cle, id_utilisateur AS id_utilisateur ".
61 
				"FROM cel_obs_mots_cles comc ".
 61 
				"FROM cel_obs_mots_cles comc ".
62 
				"INNER JOIN cel_obs o ON o.id_observation = comc.id_observation ";
 62 
				"INNER JOIN cel_obs o ON o.id_observation = comc.id_observation ";
63 
		} else {
 63 
		} else {
64 
			$requete = "SELECT comc.id_image as id_element_lie, comc.id_mot_cle_image as id_mot_cle, o.ce_utilisateur as id_utilisateur ".
 64 
			$requete = "SELECT comc.id_image AS id_element_lie, comc.id_mot_cle_image AS id_mot_cle, o.ce_utilisateur AS id_utilisateur ".
65 
				"FROM cel_images_mots_cles comc ".
 65 
				"FROM cel_images_mots_cles comc ".
66 
				"INNER JOIN cel_images o ON o.id_image = comc.id_image ";
 66 
				"INNER JOIN cel_images o ON o.id_image = comc.id_image ";
67 
		}
 67 
		}
68 
		$liaisons = $this->recupererTous($requete);
 68 
		$liaisons = $this->recupererTous($requete);