Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1162 Rev 1295
Line 111... Line 111...
111
111
Line 112... Line 112...
112 
	private function getIdsMotsClesObservation($id_observation) {
 112 
	private function getIdsMotsClesObservation($id_observation) {
113
113
114 
		$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_obs '.
 114 
		$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_obs '.
Line 115... Line 115...
115 
									   'FROM cel_obs_mots_cles '.
 115 
									   'FROM cel_obs_mots_cles '.
116 
									   'WHERE id_observation = '.$id_observation;
116 
									   'WHERE id_observation = '.$id_observation;
Line 117... Line 117...
117
117
Line 171... Line 171...
171 
				break;
 171 
				break;
Line 172... Line 172...
172
172
173 
                case 'id_mots_cles':
 173 
                case 'id_mots_cles':
174 
                    $liste_mc = '"'.str_replace(';','","',$valeur).'"';
 174 
                    $liste_mc = '"'.str_replace(';','","',$valeur).'"';
175 
                    $sous_requete .= '' ;
175 
                    $sous_requete .= '' ;
176 
                    $sous_requete .= 'id_observation IN (SELECT id_observation FROM cel_obs_mots_cles WHERE id_mot_cle_utilisateur IN ('.$liste_mc.'))';
 176 
                    $sous_requete .= 'id_observation IN (SELECT id_observation FROM cel_obs_mots_cles WHERE id_mot_cle_obs IN ('.$liste_mc.'))';
177 
                    $sous_requete .= ' AND ' ;
 177 
                    $sous_requete .= ' AND ' ;
Line 178... Line 178...
178 
                break;
 178 
                break;
179
179