source/Application/Controller/Admin/ListComponentAjax.php
protected function _getFilter()
    {
        $sQ = '';
        $oConfig = \OxidEsales\Eshop\Core\Registry::getConfig();
        $aFilter = $oConfig->getRequestParameter('aFilter');
        if (is_array($aFilter) && count($aFilter)) {
            $aCols = $this->_getVisibleColNames();
            $oDb = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
            $oStr = getStr();

            foreach ($aFilter as $sCol => $sValue) {
                // skipping empty filters
                if ($sValue === '') {
                    continue;
                }

                $iCol = (int) str_replace('_', '', $sCol);
                if (isset($aCols[$iCol])) {
                    if ($sQ) {
                        $sQ .= ' and ';
                    }

                    // escaping special characters
                    $sValue = str_replace(['%', '_'], ['\%', '\_'], $sValue);

                    // possibility to search in the middle ..
                    $sValue = $oStr->preg_replace('/^\*/', '%', $sValue);

                    $sQ .= $this->_getViewName($aCols[$iCol][1]) . '.' . $aCols[$iCol][0];
                    $sQ .= ' like ' . $oDb->Quote('%' . $sValue . '%') . ' ';
                }
            }
        }

        return $sQ;
    }
protected function _getFilter()
    {
        $sQ = '';
        $oConfig = \OxidEsales\Eshop\Core\Registry::getConfig();
        $aFilter = $oConfig->getRequestParameter('aFilter');
        if (is_array($aFilter) && count($aFilter)) {
            $aCols = $this->_getVisibleColNames();
            $oDb = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
            $oStr = getStr();

            foreach ($aFilter as $sCol => $sValue) {
                // skipping empty filters
                if ($sValue === '') {
                    continue;
                }

                $iCol = (int) str_replace('_', '', $sCol);
                if (isset($aCols[$iCol])) {
                    if ($sQ) {
                        $sQ .= ' and ';
                    }

                    // escaping special characters
                    $sValue = str_replace(['%', '_'], ['\%', '\_'], $sValue);

                    // possibility to search in the middle ..
                    $sValue = $oStr->preg_replace('/^\*/', '%', $sValue);

                    $sQ .= $this->_getViewName($aCols[$iCol][1]) . '.' . $aCols[$iCol][0];
                    $sQ .= ' like ' . $oDb->Quote('%' . $sValue . '%') . ' ';
                }
            }
        }

        return $sQ;
    }
protected function _getFilter ( ) { $ sQ = '' ; $ oConfig = \ OxidEsales \ Eshop \ Core \ Registry :: getConfig ( ) ; $ aFilter = $ oConfig -> getRequestParameter ( 'aFilter' ) ; if ( is_array ( $ aFilter ) && count ( $ aFilter ) ) { $ aCols = $ this -> _getVisibleColNames ( ) ; $ oDb = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) ; $ oStr = getStr ( ) ; foreach ( $ aFilter as $ sCol => $ sValue ) { // skipping empty filters if ( $ sValue === '' ) { continue ; } $ iCol = ( int ) str_replace ( '_' , '' , $ sCol ) ; if ( isset ( $ aCols [ $ iCol ] ) ) { if ( $ sQ ) { $ sQ .= ' and ' ; } // escaping special characters $ sValue = str_replace ( [ '%' , '_' ] , [ '\%' , '\_' ] , $ sValue ) ; // possibility to search in the middle .. $ sValue = $ oStr -> preg_replace ( '/^\*/' , '%' , $ sValue ) ; $ sQ .= $ this -> _getViewName ( $ aCols [ $ iCol ] [ 1 ] ) . '.' . $ aCols [ $ iCol ] [ 0 ] ; $ sQ .= ' like ' . $ oDb -> Quote ( '%' . $ sValue . '%' ) . ' ' ; } } } return $ sQ ; }
Returns part of SQL query for filtering DB data

@return string
Returns part of SQL query for filtering DB data