Subversion Repositories eFlore/Applications.cel

Rev

Rev 2031 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2031 Rev 2057
Line 10... Line 10...
10 
	public function __construct($mode) {
 10 
	public function __construct($mode) {
11 
		parent::__construct();
 11 
		parent::__construct();
12 
		$this->mode = $mode;
 12 
		$this->mode = $mode;
Line 13... Line 13...
13
13
14 
		if($mode == 'obs') {
 14 
		if($mode == 'obs') {
15 
			$this->table_liaison = 'cel_obs_tags_path_liaison';
 15 
			$this->table_liaison = 'cel_mots_cles_obs_liaison';
16 
			$this->table_mots_cles = 'cel_obs_tags_path';
 - 
 
17 
			$this->champ_id_element_lie = 'id_obs';
 16 
			$this->table_mots_cles = 'cel_arbre_mots_cles_obs';
18 
		} else {
 17 
		} else {
19 
			$this->table_liaison = 'cel_images_tags_path_liaison';
 18 
			$this->table_liaison = 'cel_mots_cles_images_liaison';
20 
			$this->table_mots_cles = 'cel_images_tags_path';
 - 
 
21 
			$this->champ_id_element_lie = 'id_image';
 19 
			$this->table_mots_cles = 'cel_arbre_mots_cles_images';
22 
		}
 20 
		}
Line 23... Line 21...
23 
	}
 21 
	}
24
22
Line 34... Line 32...
34
32
Line 35... Line 33...
35 
	public function obtenirMotsClesOriginaux() {
 33 
	public function obtenirMotsClesOriginaux() {
36
34
37 
		if($this->mode == 'obs') {
 35 
		if($this->mode == 'obs') {
38 
			$requete_arbre = "SELECT id_mot_cle_obs as id_mot_cle, ce_mot_cle_obs_parent as parent, id_utilisateur, mot_cle ".
 36 
			$requete_arbre = "SELECT id_mot_cle_obs as id_mot_cle, ce_mot_cle_obs_parent as parent, id_utilisateur, mot_cle ".
39 
								"FROM cel_mots_cles_obs ORDER BY id_utilisateur, niveau";
 37 
								"FROM cel_mots_cles_obs WHERE niveau != 0 ORDER BY id_utilisateur, niveau";
40 
		} else {
 38 
		} else {
41 
			$requete_arbre = "SELECT id_mot_cle_image as id_mot_cle, ce_mot_cle_image_parent as parent, id_utilisateur, mot_cle ".
 39 
			$requete_arbre = "SELECT id_mot_cle_image as id_mot_cle, ce_mot_cle_image_parent as parent, id_utilisateur, mot_cle ".
Line 42... Line 40...
42 
								"FROM cel_mots_cles_images ORDER BY id_utilisateur, niveau";
 40 
								"FROM cel_mots_cles_images WHERE niveau != 0 ORDER BY id_utilisateur, niveau";
43 
		}
 41 
		}
44 
 
 42 
 
Line 45... Line 43...
45 
		$mots_cles = $this->recupererTous($requete_arbre);
43 
		$mots_cles = $this->recupererTous($requete_arbre);
46 
		return $mots_cles;
 44 
		return $mots_cles;
47 
	}
 45 
	}
48
46
49 
	public function obtenirLiaisonsMotsClesOriginaux() {
 47 
	public function obtenirLiaisonsMotsClesOriginaux() {
50 
		if($this->mode == 'obs') {
 48 
		if($this->mode == 'obs') {
51 
			$requete_liaisons = "SELECT comc.id_observation as id_element_lie, comc.id_mot_cle_obs as id_mot_cle, id_utilisateur as id_utilisateur ".
 49 
			$requete_liaisons = "SELECT comc.id_observation as id_element_lie, comc.id_mot_cle_obs as id_mot_cle, id_utilisateur as id_utilisateur ".
52 
															"FROM cel_obs_mots_cles_srv comc ".
 50 
															"FROM cel_obs_mots_cles comc ".
53 
															"INNER JOIN cel_obs o ON o.id_observation = comc.id_observation ";
 51 
															"INNER JOIN cel_obs o ON o.id_observation = comc.id_observation ";
54 
		} else {
 52 
		} else {
55 
			$requete_liaisons = "SELECT comc.id_image as id_element_lie, comc.id_mot_cle_image as id_mot_cle, o.ce_utilisateur as id_utilisateur ".
 53 
			$requete_liaisons = "SELECT comc.id_image as id_element_lie, comc.id_mot_cle_image as id_mot_cle, o.ce_utilisateur as id_utilisateur ".
56 
																		"FROM cel_images_mots_cles_srv comc ".
 54 
																		"FROM cel_images_mots_cles comc ".
57 
																		"INNER JOIN cel_images_srv o ON o.id_image = comc.id_image ";
 55 
																		"INNER JOIN cel_images o ON o.id_image = comc.id_image ";
Line 58... Line 56...
58 
		}
 56 
		}
59 
		$liaisons = $this->recupererTous($requete_liaisons);
 57 
		$liaisons = $this->recupererTous($requete_liaisons);
60 
		return $liaisons;
 58 
		return $liaisons;
Line 61... Line 59...
61 
	}
 59 
	}
62
60
63 
	public function insererMotsCles($mots_cles) {
 61 
	public function insererMotsCles($mots_cles) {
64 
		$requete_insertion_mots_cles = "INSERT INTO ".$this->table_mots_cles." (chemin, id_utilisateur, tag) ".
 62 
		$requete_insertion_mots_cles = "INSERT INTO ".$this->table_mots_cles." (chemin, id_utilisateur, mot_cle) ".
65 
						                     			" VALUES ";
 63 
						                     			" VALUES ";
66
64
67 
		foreach($mots_cles as $cle => $mot_cle) {
 65 
		foreach($mots_cles as $cle => $mot_cle) {
Line 68... Line 66...
68 
			$requete_insertion_mots_cles .= "(".
 66 
			$requete_insertion_mots_cles .= "(".
69 
			$this->proteger($mot_cle['chemin']).", ".
 67 
			$this->proteger($mot_cle['chemin']).", ".
70 
			$this->proteger($mot_cle['id_utilisateur']).", ".
 68 
			$this->proteger($mot_cle['id_utilisateur']).", ".
Line 71... Line 69...
71 
			$this->proteger($mot_cle['tag'])." ".
 69 
			$this->proteger($mot_cle['mot_cle'])." ".
72 
							"), ";
 70 
							"), ";
73 
		}
 71 
		}
74
72
Line 75... Line 73...
75 
		$requete_insertion_mots_cles = rtrim($requete_insertion_mots_cles, ", ");
 73 
		$requete_insertion_mots_cles = rtrim($requete_insertion_mots_cles, ", ");
76 
		return $this->requeter($requete_insertion_mots_cles);
 74 
		return $this->requeter($requete_insertion_mots_cles);
77 
	}
 75 
	}
78
76
79 
	public function obtenirInfosNouveauxMotsCles() {
 77 
	public function obtenirInfosNouveauxMotsCles() {
Line 80... Line 78...
80 
		$requete = "SELECT id_tag, id_utilisateur, chemin FROM ".$this->table_mots_cles;
 78 
		$requete = "SELECT id_mot_cle, id_utilisateur, chemin FROM ".$this->table_mots_cles;
81 
		return $this->recupererTous($requete);
 79 
		return $this->recupererTous($requete);
82 
	}
 80 
	}
83
81
84 
	public function insererLiaisonsMotsCles($mots_cles, $liaisons, $correspondances) {
 82 
	public function insererLiaisonsMotsCles($mots_cles, $liaisons, $correspondances) {
85 
		$requete_insertion_liaisons = "INSERT INTO ".$this->table_liaison." (id_element_lie, id_tag) ".
 83 
		$requete_insertion_liaisons = "INSERT INTO ".$this->table_liaison." (id_element_lie, id_mot_cle) ".
86 
												      " VALUES ";
 84 
												      " VALUES ";
87 
		$lier = false;
 85 
		$lier = false;
88 
		$mot_cles_inexistants = 0;
 86 
		$mot_cles_inexistants = 0;
89
87
90 
		foreach($liaisons as &$liaison_mot_cle) {
 88 
		foreach($liaisons as &$liaison_mot_cle) {