Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 995 Rev 1162
Line 98... Line 98...
98 
		foreach($tableau_observations as &$observation) {
 98 
		foreach($tableau_observations as &$observation) {
99 
			$observation['ce_zone_geo'] = $this->convertirCodeZoneGeoVersCodeInsee($observation['ce_zone_geo']);
 99 
			$observation['ce_zone_geo'] = $this->convertirCodeZoneGeoVersCodeInsee($observation['ce_zone_geo']);
100 
			$ids_mots_cles = $this->getIdsMotsClesObservation($observation['id_observation']);
 100 
			$ids_mots_cles = $this->getIdsMotsClesObservation($observation['id_observation']);
101 
			$mots_cles_chaine = '';
 101 
			$mots_cles_chaine = '';
102 
			foreach($ids_mots_cles as $id_mot_cle) {
 102 
			foreach($ids_mots_cles as $id_mot_cle) {
103 
				$mots_cles_chaine .= $id_mot_cle['id_mot_cle_utilisateur'].';';
 103 
				$mots_cles_chaine .= $id_mot_cle['id_mot_cle_obs'].';';
104 
			}
 104 
			}
105 
			$mots_cles_chaine = rtrim($mots_cles_chaine,';');
 105 
			$mots_cles_chaine = rtrim($mots_cles_chaine,';');
106 
			$observation['mots_cles'] = $mots_cles_chaine;
 106 
			$observation['mots_cles'] = $mots_cles_chaine;
107 
		}
 107 
		}
Line 108... Line 108...
108
108
109 
		return $tableau_observations;
 109 
		return $tableau_observations;
Line 110... Line 110...
110 
	}
 110 
	}
Line 111... Line 111...
111
111
112 
	private function getIdsMotsClesObservation($id_observation) {
 112 
	private function getIdsMotsClesObservation($id_observation) {
113
113
Line 114... Line 114...
114 
		$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_utilisateur '.
 114 
		$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_obs '.
115 
									   'FROM cel_obs_mots_cles '.
 115 
									   'FROM cel_obs_mots_cles '.