Subversion Repositories eFlore/Applications.cel

Rev

Rev 1162 | 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