evoSearch — почему поиск, не видит ТВ?

Версия MODX: Все

Добрый день, всем!
Почему поиск, не видит ТВ ?
Мне необходимо, чтобы поиск искал ТВшки (артикулы и т.д.).
Ввел нужные мне ТВ в конфигурации, проиндексировал на всякий случай, но поиск их всеравно не видит…
joxi.ru/a2X97GxF1djN1A

Может что не так сделал?

Александр
12.10.18 в 12:10

Комментарии (5)

Алексей Либер 16.10.2018 16:38 #

Только сейчас увидел.
Скорее всего вы их не прописали в параметрах tvList и tvPrefix…

Александр 16.10.2018 17:47 #

Спасибо, за ответ! 
Я разобрался уже! 
Это из-за bLang-a пришлось немного плагин ковырнуть. 
ТВ теперь добавляются в плагине добавлять((( 
 
Но всё равно спасибо, за то что ответили!!!

Евгений 19.10.2018 13:14 #

можете показать как решили проблему? аналогичная ситуация что то не пойму

Александр 19.10.2018 13:43 #

Плагин и сниппет пришлось переписывать 
Сделай дубликаты на следующих файлах 

evoSearchCustom.snippet.php:

<?php
if(!defined('MODX_BASE_PATH')) die('What are you doing? Get out of here!');

$documents = '';
$output = '';
$noResult = isset($params['noResult']) ? $params['noResult'] : '[(__noResultFirst)] <u>[+stat_request+]</u> [(__noResultSecond)]';
$txt_original = '';

include_once('snippetCustom.class.php');
$min_length = (isset($params['minlength']) && (int)$params['minlength'] > 0) ? (int)$params['minlength'] : 2;
$eSS = new evoSearchSnippetCustom($modx, $params, $min_length);

if (isset($_GET[$eSS->search_field]) && $_GET[$eSS->search_field] != '') {
    $eSS->init();
    $eSS->prepareWords();
    $modx->setPlaceholder('stat_request', $eSS->Get('txt_original'));

    //получаем массив подходящих под условие поиска id
    $ids = $eSS->makeSearch();
    $ids[] = 120000000;
    if ($eSS->action == 'ids') {//работаем в режиме ids - сразу возвращаем ids
        $modx->setPlaceholder("evoSearchIDs", $ids);
        if ($eSS->params['output'] && $eSS->params['output'] == '1') {
            $output = implode(',', $ids);
        }
    } else {//работаем в полном режиме, возвращаем вместе с выводом результатов
        if (!empty($ids)) {
            $eSS->bulk_words_stemmer = array();
            foreach ($eSS->search_words as $v) {
                $eSS->bulk_words_stemmer[] = $eSS->stemmer->stem_word($v);
            }
            $DLparams = array(
                'documents' => implode(',', $ids),
                'sortType' => 'doclist',
                'showParent' => '1',
                'addWhereList' => 'c.searchable=1' . (isset($params['addWhereList']) ? ' AND ' . $params['addWhereList'] : '')
            );
            if ($eSS->params['extract'] == '1' && (!isset($params['prepare']) || $params['prepare'] == '')) {
                $DLparams['prepare'] = array($eSS, 'prepareExtractor');
            }

            $params = array_merge($params, $DLparams);
            $output .= $modx->runSnippet("DocLister", $params);
            if ($eSS->params['show_stat'] == '1') {
                $output = $eSS->getSearchResultInfo() . $output;
            }
        }
        $output = $output != '' ? $output : (!isset($_REQUEST[$eSS->search_field]) ? '' : '<div class="noResult">' . $eSS->parseNoresult($noResult) . '</div>');
    }
}
return $output;

Плагин: 
 
snippetCustom.class.php:

<br />
<?php 

class evoSearchSnippetCustom {

public $params = array();

//phpmorphy dir
public $phpmorphy_dir;

//dictionaries dir
public $dict_dir;

//min word length for search
public $min_length;

//using dictionaries array
public $dicts = array();

//поле содержащее информацию из поля content и других полей для поиска (pagetitle, TVs и т.п.)
public $ext_content_field;

//сформированный на основе $ext_content_field индекс из словоформ этого поля
public $ext_content_index_field;

//поисковая строка (оригинальная, пропущенная через escape $_GET['search']
public $txt_original = '';

//словоформы всех слов из поисковой строки, массив
public $txt_ext_array = array();

//словоформы всех слов из поисковой строки, строка. Слова разделены пробелами. Основной текст для организации полнотекстового поиска
public $txt_ext = array();


public function __construct($modx, $params)
{
    $this->modx = $modx;
    $this->params = $params;
    $this->search_field = isset($params['search_field']) ? $params['search_field'] : 'search';
    $this->phpmorphy_dir = MODX_BASE_PATH . 'assets/lib/phpmorphy';
    $this->dict_dir = $this->phpmorphy_dir . '/dicts';
    $this->dicts = array('rus', 'eng');
    
}

public function init($min_length = 2, $ext_content_field = 'content_with_tv', $ext_content_index_field = 'content_with_tv_index')
{
    $this->id = $this->params['id'];
    $this->content_table = $this->modx->getFullTableName("site_content");
    $this->search_table = $this->modx->getFullTableName("evosearch_table");
    $this->ext_content_field = $ext_content_field;
    $this->ext_content_index_field = $ext_content_index_field;
    $this->action = isset($this->params['action']) ? $this->params['action'] : '';
    $this->setDefault(
        array(
            'display' => '20',
            'show_stat' => '1',
            'extract' => '1',
            'statTpl' => '<div class="evoSearch_info">По запросу <b>[+stat_request+]</b> найдено всего <b>[+stat_total+]</b>. Показано <b>[+stat_display+]</b>, c [+stat_from+] по [+stat_to+]</div>',
            'rel' => '0.01',
            'min_length' => $min_length,
            'dedug' => '0'
            )
    );
    $this->min_length = $this->params['min_length'];
    $this->stemmer = $this->getStemmer();
    return $this;
}

public function setDefault($param, $default = '')
{
    if (is_array($param)) {
        foreach ($param as $p => $v) {
            $this->params[$p] = isset($this->params[$p]) ? $this->params[$p] : $v;
        }
    } else {
        $this->params[$param] = isset($this->params[$param]) ? $this->params[$param] : $default;
    }
    return $this;
}

public function makeWordsFromText($text)
{
    $words = array();
    $words = preg_replace('#\[.*\]#isU', '', $text);
    $words = str_replace(array('–', '»', '«', '↓', '→', '—'), array('', '', '', '', '', ''), $words);
    $words = preg_split('#\s|[,.:;!?"\'()]#', $text, -1, PREG_SPLIT_NO_EMPTY);
    return $words;
}

public function makeBulkWords($words, $upper = true)
{
    $bulk_words = array();
    foreach ($words as $v) {
        if (mb_strlen($v, "UTF-8") > $this->min_length) {
            $bulk_words[] = $upper ? mb_strtoupper($v, "UTF-8") : $v;
        }
    }
    return $bulk_words;
}

public function prepareWords()
{
    //string 
    //оригинальный запрос, очищенный от тегов
    $this->Set('txt_original', $this->sanitarTag($_GET[$this->search_field]), true);
    $this->original = $this->Get('txt_original');
    
    //array()
    //оригинальные слова из поиска длиннее min_length
    $this->search_words = $this->makeWordsFromText($this->Get('txt_original'));
    foreach ($this->search_words as $k => $word) {
        if (mb_strlen($word, "UTF-8") <= $this->min_length) {
            unset($this->search_words[$k]);
        }
    }
    
    //array()
    //те же слова в верхнем регистре
    $this->uppercase_search_words = $this->makeBulkWords($this->search_words);

    //нормализованные слова в базовой форме
    $this->baseform_search_words = array();
    $tmp = $this->Words2BaseForm(implode(' ', $this->uppercase_search_words));
    foreach ($tmp as $v) {
        if (is_array($v)) {
            foreach ($v as $v1) {
                if ($v1 && !empty($v1) && $v1 != '') {
                    $this->baseform_search_words[] = $v1;
                }
            }
        } else {
            if ($v && !empty($v) && $v != '') {
                $this->baseform_search_words[] = $v;
            }
        }
    }
}

//функция для prepare-сниппета DocLister (готовим данные для плейсхолдера [+extract+] в чанк вывода результатов DocLister
public function prepareExtractor($data)
{
    $data = $this->makeHighlight ($data);
    return $data;
}
//делаем подсветку на основе стеммера
public function makeHighlight ($data)
{
    if (is_array($this->bulk_words_stemmer) && !empty($this->bulk_words_stemmer)) {
        $input = implode('|', $this->bulk_words_stemmer);
        $input = str_replace(array('\\', '/'), array('', '\/'), $input);
        $pattern = '/(' . $input . ')([^\.\s\;\:"\'\(\)!?,]*)?/ius';
        $replacement = '<span class="evoSearch_highlight">$1$2</span>';
        if (isset($this->params['extract_with_tv']) && $this->params['extract_with_tv'] == '1') {
            $text = $this->getTextForHighlight($data[$this->ext_content_field]);
        } else{
            $text = $this->getTextForHighlight($data["content"]);
        }
        $pagetitle = $this->modx->stripTags($data["pagetitle"]);
        $data["extract"] = preg_replace($pattern, $replacement, $text);
        $data["pagetitle"] = preg_replace($pattern, $replacement, $pagetitle);
    }
    return $data;
}

//вырезаем нужный кусок текста нужной длины (примерно)
private function getTextForHighlight($text)
{
    $max_length = isset($this->params['maxlength']) && (int)$this->params['maxlength'] != 0 ? (int)$this->params['maxlength'] : 350;
    $limit = $max_length + 12;
    $text = $this->modx->stripTags($text);
    $pos = array();
    foreach ($this->bulk_words_stemmer as $word) {
        $pos[$word] = mb_strripos(mb_strtolower($text, 'UTF-8'), $word, 0, 'UTF-8');
    }
    foreach ($pos as $word => $position) {
        $length = mb_strlen($text, 'UTF-8');
        if ($position == 0 && $length > $limit) {
            $text = mb_substr($text, $position, $max_length, 'UTF-8') . ' ... ';
        } else if ($position < $max_length && $length > $limit) {
            $text = ' ... ' . mb_substr($text, $position, $max_length, 'UTF-8') . ' ... ';
        } else if ($position + $limit >= $length && $length > $limit) {
            $text = mb_substr($text, $position);
        } else if ($length > $limit){
            $text = ' ... ' . mb_substr($text, $position, $max_length, 'UTF-8') . ' ... ';
        } else {

        }
    }
    return $text;
}

public function Words2BaseForm($text)
{
    require_once($this->phpmorphy_dir . '/src/common.php');

    // set some options
    $opts = array(
        // storage type, follow types supported
        // PHPMORPHY_STORAGE_FILE - use file operations(fread, fseek) for dictionary access, this is very slow...
        // PHPMORPHY_STORAGE_SHM - load dictionary in shared memory(using shmop php extension), this is preferred mode
        // PHPMORPHY_STORAGE_MEM - load dict to memory each time when phpMorphy intialized, this useful when shmop ext. not activated. Speed same as for PHPMORPHY_STORAGE_SHM type
        'storage' => PHPMORPHY_STORAGE_MEM,
        // Extend graminfo for getAllFormsWithGramInfo method call
        'with_gramtab' => false,
        // Enable prediction by suffix
        'predict_by_suffix' => true, 
        // Enable prediction by prefix
        'predict_by_db' => true
    );
    
    $words = $this->makeWordsFromText($text);
    $bulk_words = $this->makeBulkWords($words);

    $w = array();
    foreach ($this->dicts as $dict) {
        // Create descriptor for dictionary located in $dir directory with russian language
        $dict_bundle = new phpMorphy_FilesBundle($this->dict_dir, $dict);
        // Create phpMorphy instance
        $morphy = new phpMorphy($dict_bundle, $opts);
        $tmp = $morphy->getBaseForm($bulk_words);
        $w = array_merge_recursive($w, $tmp);
    }
    return $w;
}

public function getStemmer()
{
    include_once('stemmer.class.php');
    return $stemmer = new Lingua_Stem_Ru();
}

public function Set($key, $value, $escape = false)
{
    if ($escape) {
        $this->{$key} = $this->modx->db->escape($value);
    } else {
        $this->{$key} = $value;
    }
}

public function Get($key, $default = '')
{
    return $this->{$key} ? $this->{$key} : $default ;
}

public function makeSearch()
{
    //возвращаем id ресурсов, отобранные по полнотекстовому поиску и отсортированные по релевантности
    $ids = array();
    $sql = $this->makeSearchSQL();


    //$sql2 = $this->makeSearchSQL('addlike');
    if ($this->params['debug'] == '1') {
        echo $sql . '<hr>';
        //echo $sql2 . '<hr>';
    }
    if ($sql != '') {
        $q = $this->modx->db->query($sql);
        while ($row = $this->modx->db->getRow($q)) {
            $ids[] = $row['docid'];
        }
    }
    if ($this->params['debug'] == '1') {
        echo 'найдены ' . implode(',', $ids) . '<hr>';
    }
    if (empty($ids)) {//ничего не найдено, возможно требуется дополнительный поиск по like
        $sql = $this->makeSearchSQL('addlike');
        if ($this->params['debug'] == '1') {
            echo $sql . '<hr>';
        }
        if ($sql != '') {
            $q = $this->modx->db->query($sql);
            while ($row = $this->modx->db->getRow($q)) {
                $ids[] = $row['docid'];
            }
        }
        if ($this->params['debug'] == '1') {
            echo 'найдены ' . implode(',', $ids) . '<hr>';
        }
    }
    return $ids;
}

public function makeSearchSQL($type = 'fulltext')
{

    switch ($type) {
        case 'fulltext':
            $sql = $this->buildFulltextSQL();
            break;
        case 'addlike':
            $sql = $this->buildAddLikeSQL();
        default:
            break;
    }
    return $sql;
}

public function buildFulltextSQL()
{
    global $modx;
    $lang = $modx->getConfig('_lang');

    $this->ext_content_field.= '_'.$lang;
    $this->ext_content_index_field.= '_'.$lang;



    $sql = '';
    if ($this->original != '' || !empty($this->baseform_search_words)) {
        $txt_original = $this->original;
        $search = $txt_original . ' ' . implode(' ', $this->baseform_search_words);
        $sql = "SELECT docid, IF(`pagetitle_$lang` LIKE '%" . $txt_original . "%', 2, 0) as pt, IF(`" . $this->ext_content_field . "` LIKE '%" . $txt_original . "%', 1, 0) as ct, (MATCH(" . $this->ext_content_field . "," . $this->ext_content_index_field . ") AGAINST('" . $search . "')) as rel FROM " . $this->search_table . " WHERE IF(`pagetitle_$lang` LIKE '%" . $txt_original . "%', 2, 0)>0 OR IF(`" . $this->ext_content_field . "` LIKE '%" . $txt_original . "%', 1, 0)>0 OR (MATCH(" . $this->ext_content_field . "," . $this->ext_content_index_field . ") AGAINST('" . $search . "')) > " . $this->params['rel'] . " ORDER BY pt DESC, (MATCH(" . $this->ext_content_field . "," . $this->ext_content_index_field . ") AGAINST('" . $search . "')) DESC, ct DESC";
    }
    return $sql;
}

public function buildAddLikeSQL()
{
    //ищем вхождение всех слов в заголовок либо в поле content_with_tv
    $sql = '';
    $addPagetitle = $this->makeAddLikeCond('pagetitle', ' ');
    $addContent = $this->makeAddLikeCond($this->ext_content_field, 'OR');
    if ($addPagetitle != '' && $addContent != '') {
        $sql = "SELECT docid, IF(" . $addPagetitle . ", 2,0) as rel FROM " . $this->search_table . " WHERE " . $addPagetitle . " " . $addContent . " ORDER BY rel DESC";
    }
    return $sql;
} 

public function makeStringFromQuery($q, $serapator = ',', $field = 'id')
{
    $out = array();
    while ($row = $this->modx->db->getRow($q)) {
        $out[] = $row[$field];
    }
    return implode($serapator, $out);
}

public function getSearchResultInfo()
{
    $out = '';
    $DL_id = isset($this->params['id']) && !empty($this->params['id']) ? $this->params['id'] . '.' : '';
    $count = $this->modx->getPlaceholder($DL_id . 'count');
    $display = $this->modx->getPlaceholder($DL_id . 'display');
    $current = $this->modx->getPlaceholder($DL_id . 'current');
    $from = ($current - 1) * $this->params['display'] + 1;
    $to = $from - 1 + $display;
    if ($count && $count != '0' && $count != '') {
        $out .= $this->parseTpl(
                     array('[+stat_request+]', '[+stat_total+]', '[+stat_display+]', '[+stat_from+]', '[+stat_to+]'),
                     array($this->Get('txt_original'), $count, $display, $from, $to),
                     $this->params['statTpl']
                    );
    }
    $this->setPlaceholders(
        array(
            'stat_total' => $count, 
            'stat_display' => $display,
            'stat_from' => $from,
            'stat_to' => $to,
            'stat_tpl' => $out,
            'stat_request' => $this->Get('txt_original')
        )
    );
    return $out;
}

public function parseTpl($arr1, $arr2, $tpl)
{
    return str_replace($arr1, $arr2, $tpl);
}

public function sanitarTag($data)
{
        return is_scalar($data) ? str_replace(
            array('[', '%5B', ']', '%5D', '{', '%7B', '}', '%7D'),
            array('', '', '', '', '', '', '', ''),
            htmlspecialchars($data, ENT_COMPAT, 'UTF-8', false)
        ) : '';
}

public function setPlaceholders($data = array())
{
    if (is_array($data)) {
        foreach ($data as $name => $value) {
            $this->modx->setPlaceholder($name, $value);
        }
    }
}

public function parseNoresult($noResult)
{
    return $this->parseTpl(array('[+stat_request+]'), array($this->Get('txt_original')), $noResult);
}


public function makeAddLikeCond($search_field = 'pagetitle', $separator = 'AND', $inner_separator = 'AND')
{
    $out = '';
    foreach ($this->search_words as $word) {
        $word = mb_strtolower($word, "UTF-8");
        $tmp[] = " LOWER(`" . $search_field . "`) REGEXP '" . $word . "'";
    }
    if (!empty($tmp)) {
        $out = implode(' ' . trim($inner_separator) . ' ', $tmp);
    }
    if (!empty($out)) {
        $out = ' ' . $separator . ' (' . $out . ')';
    }
    return $out;
}

}//class end

evoSearchCustom.plugin.php:

<?php
if(!defined('MODX_BASE_PATH')) die('What are you doing? Get out of here!');

$e = $modx->Event;
if ($e->name == 'OnDocFormSave') {
	include_once('pluginCustom.class.php');
	$eSP = new evoSearchPluginCustom($modx, $e->params);
    //проверяем наличие и создаем при необходимости нужные поля и индекса
	$eSP->prepareRun();
    //теперь начинаем работу
	$sql = $eSP->makeSQLForSelectWords();

	$q = $modx->db->query($sql);


	while ($row = $modx->db->getRow($q)) {

		$contentRu = $eSP->injectTVs($row['id'], '','pagetitle_ru,introtext_ru,content_ru,number_article');
		$wordsRu = $eSP->Words2BaseForm(mb_strtoupper($contentRu, 'UTF-8'));

		$contentEn = $eSP->injectTVs($row['id'], '','pagetitle_en,introtext_en,content_en,number_article');
		$wordsEn = $eSP->Words2BaseForm(mb_strtoupper($contentEn, 'UTF-8'));

		$pagetitleRu = $modx->runSnippet('DocInfo',['field'=>'pagetitle_ru','docid'=>$row['id');
		$pagetitleEn = $modx->runSnippet('DocInfo',['field'=>'pagetitle_en','docid'=>$row['id');


		$fields = array(

			'content_with_tv_ru'=>$modx->db->escape($contentRu),
			'content_with_tv_index_ru'=>$modx->db->escape($wordsRu),

			'content_with_tv_en'=>$modx->db->escape($contentEn),
			'content_with_tv_index_en'=>$modx->db->escape($wordsEn  ),
			'docid' => $row['id'],

			'pagetitle_ru' => isset($pagetitleRu) ? $modx->db->escape($pagetitleRu) : '',
			'pagetitle_en' => isset($pagetitleEn) ? $modx->db->escape($pagetitleEn) : '',

			'table' => $eSP->content_table_name
		);

		$S = $modx->getFullTableName('evosearch_table');
		$searchId = $modx->db->getValue($modx->db->select('id',$S,'docid = '.$row['id']));
       // var_dump($searchId);

		if(empty($searchId)){
			$modx->db->insert($fields,$S);
		}
		else{
			$modx->db->update($fields,$S,'id = '.$searchId);
		}

//        $up = $eSP->updateSearchTable($fields);
//      echo   $modx->db->getLastError();

//        var_dump($up);
		//die();
	}
    //удалим строки индексов для исключенных шаблонов и ресурсов
	$eSP->emptyExcluded();
}

pluginCustom.class.php:

<?php
if(!defined('MODX_BASE_PATH')) die('What are you doing? Get out of here!');

class evoSearchPluginCustom {

public $params = array();

//phpmorphy dir
public $phpmorphy_dir;

//dictionaries dir
public $dict_dir;

//min word length for search
public $min_length;

//using dictionaries array
public $dicts = array();

//поле содержащее информацию из поля content и других полей для поиска (pagetitle, TVs и т.п.)
public $ext_content_field;

//сформированный на основе $ext_content_field индекс из словоформ этого поля
public $ext_content_index_field;

public function __construct($modx, $params, $min_length = 2, $ext_content_field = 'content_with_tv', $ext_content_index_field = 'content_with_tv_index', $search_table = 'evosearch_table', $content_table = 'site_content', $search_fields = 'pagetitle,longtitle,description,introtext,content')
{
    $this->modx = $modx;
    $this->params = $params;
    $this->phpmorphy_dir = MODX_BASE_PATH . 'assets/lib/phpmorphy';
    $this->dict_dir = $this->phpmorphy_dir . '/dicts';
    $this->min_length = $min_length;
    $this->dicts = $this->getDicts($this->params['dicts']);
    $this->id = $this->params['id'];
    $this->content_table_name = $content_table;
    $this->content_table = $this->modx->getFullTableName($this->content_table_name);
    $this->ext_content_field = $ext_content_field;
    $this->ext_content_index_field = $ext_content_index_field;
    $this->search_table = $this->modx->getFullTableName($search_table);
    $this->search_fields = $this->cleanIn($search_fields);
}

public function getDicts($dicts)
{
    return explode(',', $this->cleanIn($dicts));
}

public function Words2BaseForm($text)
{
    require_once($this->phpmorphy_dir . '/src/common.php');

    // set some options
    $opts = array(
        // storage type, follow types supported
        // PHPMORPHY_STORAGE_FILE - use file operations(fread, fseek) for dictionary access, this is very slow...
        // PHPMORPHY_STORAGE_SHM - load dictionary in shared memory(using shmop php extension), this is preferred mode
        // PHPMORPHY_STORAGE_MEM - load dict to memory each time when phpMorphy intialized, this useful when shmop ext. not activated. Speed same as for PHPMORPHY_STORAGE_SHM type
        'storage' => PHPMORPHY_STORAGE_MEM,
        // Extend graminfo for getAllFormsWithGramInfo method call
        'with_gramtab' => false,
        // Enable prediction by suffix
        'predict_by_suffix' => true, 
        // Enable prediction by prefix
        'predict_by_db' => true
    );
    
    $words = $this->makeWordsFromText($text);
    $bulk_words = $this->makeBulkWords($words);

    $fullList = array();
    foreach ($this->dicts as $dict) {
        // Create descriptor for dictionary located in $dir directory with russian language
        $dict_bundle = new phpMorphy_FilesBundle($this->dict_dir, $dict);
        
        // Create phpMorphy instance
        $morphy = new phpMorphy($dict_bundle, $opts);
        
        //get base form for all words
		$base_form = array();
		foreach ($bulk_words as $bulk_word) {
			$base_form[] = $morphy->getBaseForm($bulk_word);
		}
        
        if ( is_array($base_form) && count($base_form) ) {
            foreach ( $base_form as $k => $v ) {
                if ( is_array($v) ) {
                    foreach ( $v as $v1 ) {
                        if ( strlen($v1) > $this->min_length ) {
                            $fullList[] = $v1;
                        }
                    }
                }
            }
        }
    }
    //$words = join(' ', array_keys($fullList));
    $words = implode(' ', $fullList);
    return $words;
}

public function cleanIn($text, $quote = false)
{
    $out = $text;
    if (!$quote) {
        $out = str_replace(', ', ',', trim($text));
    }
    return $out;
}


public function makeSQLForSelectWords ()
{
    $where = ' AND id IN(' . $this->id . ')';
    $order = ' ORDER BY id ASC ';
    $limit = ' LIMIT 0,1';
    if (isset($this->params['reindex']) && (int)$this->params['reindex'] != 0) {
        $where = '';
        $limit = ' LIMIT ' . (isset($this->params['offset']) ? (int)$this->params['offset'] : 0) . ',' . (isset($this->params['rowsperonce']) ? (int)$this->params['rowsperonce'] : 1);
    }
    $where .= ($this->params['unpublished'] == '0' ? ' AND published=1 ' : '');
    $where .= ($this->params['deleted'] == '0' ? ' AND deleted=0 ' : '');
    $where .= ($this->params['excludeTmpls'] != '' ? ' AND template NOT IN(' . $this->params['excludeTmpls'] . ') ' : '');
    $where .= ($this->params['excludeIDs'] != '' ? ' AND id NOT IN(' . $this->params['excludeIDs'] . ') ' : '');
    $sql = "SELECT id," . $this->search_fields . " FROM " . $this->content_table . " WHERE searchable = 1" . $where . $order . $limit;
    return $sql;
}

public function emptyExcluded()
{
    if (isset($this->params['reindex']) && (int)$this->params['reindex'] != 0) {
        $where = '';
        $ids = array();
        $where = ($this->params['excludeTmpls'] != '' ? ' template IN(' . $this->cleanIn($this->params['excludeTmpls']) . ') ' : '');
        $where = $where . ($this->params['excludeIDs'] != '' ? ($where != '' ? ' OR ' : '') . ' id IN(' . $this->cleanIn($this->params['excludeIDs']) . ') ' : '');
        if ($where != '') {
            $q = $this->modx->db->select("id" , $this->content_table , $where);
            while ($row = $this->modx->db->getRow($q)) {
                $ids[] = $row['id'];
            }
        }
        if (!empty($ids)) {
            $del = $this->modx->db->delete(
                $this->search_table,
                "docid IN(" . implode(',', $ids) . ") AND `table`='" . $this->content_table_name . "'"
            );
        }
    }
}

public function makeWordsFromText($text)
{
    $words = array();
    $words = preg_replace('#\[.*\]#isU', '', $text);
    $words = str_replace(array('–', '»', '«', '↓', '→', '—'), array('', '', '', '', '', ''), $words);
    $words = preg_split('#\s|[,.:;!?"\'()]#', $text, -1, PREG_SPLIT_NO_EMPTY);
    return $words;
}

public function makeBulkWords($words, $upper = true)
{
    $bulk_words = array();
    foreach ($words as $v) {
        if (strlen($v) > $this->min_length) {
            //$bulk_words[] = $upper ? strtoupper($v) : $v;
            $bulk_words[] = $v;
        }
    }
    return $bulk_words;
}

public function injectTVs($id, $content,$tvNames)
{
    $tvs = array();
    if ($tvNames != '') {
        $TvNames = explode(',', $tvNames);

        $TvValues = $this->modx->getTemplateVarOutput($TvNames, $id);
        $TvElements = $this->modx->getTemplateVars($TvNames, 'name,elements', $id, 'all');
        if (!empty($TvElements) && !empty($TvValues)) {

            foreach ($TvElements as $k => $el) {
                $tv_name = $el['name'];

                if (stristr($el['elements'], 'getParamsFromTree') === FALSE) {
                    $tvs[] = str_replace('||', ' ', $TvValues[$tv_name]);
                } else {
                    $docs = str_replace('||', ',', $TvValues[$tv_name]);
                    if ($docs && $docs != '') {
                        $q = $this->modx->db->query("SELECT id,pagetitle FROM " . $this->content_table . " WHERE id IN(" . $docs . ")");
                        while ($row = $this->modx->db->getRow($q)) {
                            $tvs[] = $row['pagetitle'];
                        }
                    }
                }
            }
        }
    }
    $content .= !empty($tvs) ? ' ' . implode(' ', $tvs) . ' ' : '';

    return $content;
}

private function checkColumnExists($columnname, $table)
{
    $columns = $this->modx->db->getTableMetaData($table);
    return isset($columns[$columnname]);
}

private function createSearchTable()
{
    $sql = '
        CREATE TABLE IF NOT EXISTS ' . $this->modx->getFullTableName('evosearch_table') . ' (
            `id` int(10) NOT NULL AUTO_INCREMENT,
            `docid` int(10) NOT NULL,
            `table` varchar(255) NOT NULL,
            `pagetitle` varchar(255) NOT NULL,
            `' . $this->ext_content_field . '` mediumtext NOT NULL,
            `' . $this->ext_content_index_field . '` mediumtext NOT NULL,
            PRIMARY KEY (`id`),
            UNIQUE KEY `docid_table` (`docid`,`table`),
            FULLTEXT KEY `content_index` (`' . $this->ext_content_field . '`,`' . $this->ext_content_index_field . '`),
            FULLTEXT KEY `pagetitle` (`pagetitle`)
        ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    ';

    $this->modx->db->query($sql);
    //$sql = "ALTER TABLE " . $this->content_table . " ADD FULLTEXT(`pagetitle`)";
    //$this->modx->db->query($sql);
}

public function prepareRun()
{
    $this->createSearchTable();
}

public function updateSearchTable($fields)
{
    $up = false;
    if (!empty($fields)) {
        $keys = '`' . implode('`,`', array_keys($fields)) . '`';
        $values = "'" . implode("','", array_values($fields)) . "'";
        $sql = "INSERT INTO " . $this->search_table . " (" . $keys . ") VALUES (" . $values . ") ON DUPLICATE KEY UPDATE `" . $this->ext_content_field . "`='" . $fields[$this->ext_content_field] . "', `" . $this->ext_content_index_field . "`='" . $fields[$this->ext_content_index_field] . "', `pagetitle`='" . $fields['pagetitle'] . "'";
        $up = $this->modx->db->query($sql);
    }
    return $up;
}

}

Теперь вызов будет у тебя через [!evoSearchCustom!] 
Ну и пути в админке замени на… Сustom или как ты там его назовешь 
+ база данных копия и замени это: 
joxi.ru/xAeK8OJhpxGl0m 
 
Пробуй, должно работать

Александр 19.10.2018 13:45 #

Поиск будет работать, только на языке, на котором ты находишься…

Для добавления комментариев вы должны авторизоваться или зарегистрироваться.