Corrections pour une recherche des intervenants plus rapide

-éviter de surcharger le serveur en limitant à une recherche à la fois
-limiter la recherche au début de chaque critère possible

Merge request reports

Loading
+1 −1
Changes for module/Application/src/Processus/Intervenant/RechercheProcessus.php: 1 added line, 1 removed line.
Original line number Diff line number Diff line
@@ -165,7 +165,7 @@ class RechercheProcessus
            $cc = (int)$c;
            if (0 === $cc) {
                if ($sqlCri != '') $sqlCri .= ' AND ';
                $sqlCri .= 'critere LIKE q\'[%' . $c . '%]\'';
                $sqlCri .= 'instr(\' \' || critere ,\' ' . $c . '\') > 0';
            } else {
                $criCode = $cc;
            }
+9 −4
Changes for public/intervenant-recherche/widget.js: 9 added lines, 4 removed lines.
Original line number Diff line number Diff line
@@ -2,22 +2,26 @@
 *
 * @constructor
 */

$.widget("ose.intervenantRecherche", {

    rechercher: function (critere, stopFunc)
    {
        var that = this;

        if (critere.length > 1) {
        var disabled = that.getElementCritere().autocomplete( "option", "disabled" );
        if (critere.length > 1 && !disabled) {
            that.getElementCritere().autocomplete("disable");
            that.getElementRecherche().refresh({critere: critere}, function (response, status, xhr)
            {
                if (status == "error") {
                    var msg = "Désolé mais une erreur est survenue: ";
                    that.getElementRecherche().html(msg + xhr.status + " " + xhr.statusText + xhr.responseText);
                }
                that.getElementCritere().autocomplete();
                that.getElementCritere().autocomplete("enable");
                stopFunc();
            });
        }else{
            stopFunc();
        }
    },

@@ -29,7 +33,8 @@ $.widget("ose.intervenantRecherche", {
            source: function (event, stopFunc)
            {
                that.rechercher(event.term, stopFunc);
            }
            },
			minLength: 2
        });

        this.getElementCritere().focus();
Loading