Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 2042 Rev 2043
Line 120... Line 120...
120
			$ids_mots_cles = $this->getIdsMotsClesObservation($observation['id_observation']);
120
			$ids_mots_cles = $this->getIdsMotsClesObservation($observation['id_observation']);
Line 121... Line 121...
121
 
121
 
122
			$ids[] = $observation['id_observation'];
122
			$ids[] = $observation['id_observation'];
123
			$mots_cles_chaine = '';
123
			$mots_cles_chaine = '';
124
			foreach ($ids_mots_cles as $id_mot_cle) {
124
			foreach ($ids_mots_cles as $id_mot_cle) {
125
				$mots_cles_chaine .= $id_mot_cle['id_mot_cle_obs'].';';
125
				$mots_cles_chaine .= $id_mot_cle['id_mot_cle'].';';
126
			}
126
			}
127
			$mots_cles_chaine = rtrim($mots_cles_chaine,';');
127
			$mots_cles_chaine = rtrim($mots_cles_chaine,';');
Line 128... Line 128...
128
			$observation['mots_cles'] = $mots_cles_chaine;
128
			$observation['mots_cles'] = $mots_cles_chaine;
Line 158... Line 158...
158
		}
158
		}
159
		return $retour;
159
		return $retour;
160
	}
160
	}
Line 161... Line 161...
161
 
161
 
162
	private function getIdsMotsClesObservation($id_observation) {
162
	private function getIdsMotsClesObservation($id_observation) {
163
		$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_obs '.
163
		$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle '.
164
			'FROM cel_obs_mots_cles '.
164
			'FROM cel_mots_cles_obs_liaison '.
165
			"WHERE id_observation = $id_observation ";
165
			"WHERE id_element_lie = $id_observation ";
166
		return Cel::db()->executerRequete($requete_selection_mots_cles);
166
		return Cel::db()->executerRequete($requete_selection_mots_cles);
Line 167... Line 167...
167
	}
167
	}
168
 
168