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; |