Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3790 → Rev 3791

/trunk/jrest/services/CelSyndicationObservation.php
368,24 → 368,24
private function creerSousRequeteRechercheGenerale($chaine_requete) {
$requete = '';
$chaine_requete = Cel::deb()->proteger($chaine_requete);
$chaine_requete = Cel::deb()->proteger($chaine_requete.'%');
if (trim($chaine_requete) != '') {
$chaine_requete = strtolower($chaine_requete);
$chaine_requete = str_replace(' ', '_', $chaine_requete);
$requete = ' ('.
'nom_ret LIKE "'.$chaine_requete.'%"'.
'nom_ret LIKE '.$chaine_requete.
' OR '.
'nom_sel LIKE "'.$chaine_requete.'%"'.
'nom_sel LIKE '.$chaine_requete.
' OR '.
'zone_geo LIKE "'.$chaine_requete.'%" '.
'zone_geo LIKE '.$chaine_requete.
' OR '.
'ce_zone_geo LIKE "'.$chaine_requete.'%" '.
'ce_zone_geo LIKE '.$chaine_requete.
' OR '.
'ce_zone_geo LIKE "'.$chaine_requete.'%" '.
'ce_zone_geo LIKE '.$chaine_requete.
' OR '.
'courriel_utilisateur LIKE "'.$chaine_requete.'%" '.
'courriel_utilisateur LIKE '.$chaine_requete.
' OR '.
'mots_cles_texte LIKE "'.$chaine_requete.'%" '.
'mots_cles_texte LIKE '.$chaine_requete.
') ';
}
return $requete;