Subversion Repositories eFlore/Applications.del

Rev

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

Rev 739 Rev 740
Line 182... Line 182...
182
						$where[] = ' '.$this->mappingFiltre['ns'].' LIKE '.$this->proteger($valeurMasque.' %');
182
						$where[] = ' '.$this->mappingFiltre['ns'].' LIKE '.$this->proteger($valeurMasque.' %');
183
						break;
183
						break;
184
					case 'tag' :
184
					case 'tag' :
185
						$where[] = " di.mots_cles_texte LIKE ".$this->proteger($valeurMasque);
185
						$where[] = " di.mots_cles_texte LIKE ".$this->proteger($valeurMasque);
186
						break;
186
						break;
-
 
187
					case 'espece' :
-
 
188
						$where[] = ' '.$this->mappingFiltre['espece'].' LIKE '.$this->proteger($valeurMasque.' %');
-
 
189
						break;
187
					default:
190
					default:
188
						$where[] = ' '.$this->mappingFiltre[$idMasque].' = '.$this->proteger($valeurMasque);
191
						$where[] = ' '.$this->mappingFiltre[$idMasque].' = '.$this->proteger($valeurMasque);
189
					break;
-
 
190
				}
192
				}
191
			}	
193
			}	
192
		}
194
		}
Line 193... Line 195...
193
		
195
		
Line 215... Line 217...
215
		$requeteLiaisons .= $this->chargerClauseWhere();
217
		$requeteLiaisons .= $this->chargerClauseWhere();
216
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
218
		$requeteLiaisons .=  ' GROUP BY doi.id_observation';
217
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
219
		$requeteLiaisons .= ' ORDER BY date_transmission DESC ';
218
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
220
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
Line 219... Line -...
219
		
-
 
220
		
221
		
221
		return $this->bdd->recupererTous($requeteLiaisons);
222
		return $this->bdd->recupererTous($requeteLiaisons);
Line 222... Line 223...
222
	}
223
	}
223
	
224