Subversion Repositories eFlore/Applications.cel

Rev

Rev 995 | 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 '.