Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3776 Rev 3791
Line 366... Line 366...
366 
        return $tableau_criteres_pour_bdd;
 366 
        return $tableau_criteres_pour_bdd;
367 
    }
 367 
    }
Line 368... Line 368...
368
368
369 
    private function creerSousRequeteRechercheGenerale($chaine_requete) {
 369 
    private function creerSousRequeteRechercheGenerale($chaine_requete) {
370 
        $requete = '';
 370 
        $requete = '';
371 
        $chaine_requete = Cel::deb()->proteger($chaine_requete);
 371 
        $chaine_requete = Cel::deb()->proteger($chaine_requete.'%');
372 
        if (trim($chaine_requete) != '') {
 372 
        if (trim($chaine_requete) != '') {
373 
            $chaine_requete = strtolower($chaine_requete);
 373 
            $chaine_requete = strtolower($chaine_requete);
374 
            $chaine_requete = str_replace(' ', '_', $chaine_requete);
 374 
            $chaine_requete = str_replace(' ', '_', $chaine_requete);
375 
            $requete = ' ('.
 375 
            $requete = ' ('.
376 
                'nom_ret LIKE "'.$chaine_requete.'%"'.
 376 
                'nom_ret LIKE '.$chaine_requete.
377 
                ' OR '.
 377 
                ' OR '.
378 
                'nom_sel LIKE "'.$chaine_requete.'%"'.
 378 
                'nom_sel LIKE '.$chaine_requete.
379 
                ' OR '.
 379 
                ' OR '.
380 
                'zone_geo LIKE "'.$chaine_requete.'%" '.
 380 
                'zone_geo LIKE '.$chaine_requete.
381 
                ' OR '.
 381 
                ' OR '.
382 
                'ce_zone_geo LIKE "'.$chaine_requete.'%" '.
 382 
                'ce_zone_geo LIKE '.$chaine_requete.
383 
                ' OR '.
 383 
                ' OR '.
384 
                'ce_zone_geo LIKE "'.$chaine_requete.'%" '.
 384 
                'ce_zone_geo LIKE '.$chaine_requete.
385 
                ' OR '.
 385 
                ' OR '.
386 
                'courriel_utilisateur LIKE "'.$chaine_requete.'%" '.
 386 
                'courriel_utilisateur LIKE '.$chaine_requete.
387 
                ' OR '.
 387 
                ' OR '.
388 
                'mots_cles_texte LIKE "'.$chaine_requete.'%" '.
 388 
                'mots_cles_texte LIKE '.$chaine_requete.
389 
                ') ';
 389 
                ') ';
390 
        }
 390 
        }
391 
        return $requete;
 391 
        return $requete;