item.php

См. документацию.

<?php
 
class CSearchItem extends CDBResult
{
    function GetList($arOrder = [], $arFilter = [], $arSelect = [])
    {
        global $DB;
 
        $strSearchContentAlias = 'sc';
        $sqlSelect = [];
        $sqlOrder = [];
        $sqlWhere = '';
 
        if (!is_array($arSelect))
        {
            $arSelect = [];
        }
 
        if (is_array($arOrder))
        {
            foreach ($arOrder as $key => $ord)
            {
                $ord = mb_strtoupper($ord) <> 'ASC' ? 'DESC' : 'ASC';
                $key = mb_strtoupper($key);
                switch ($key)
                {
                case 'ID':
                    $sqlOrder[$key] = $strSearchContentAlias . '.' . $key . ' ' . $ord;
                    $arSelect[] = 'ID';
                    break;
                }
            }
        }
 
        $arSelect[] = 'ID';
        $arSelect[] = 'SITE_ID';
        $arSelect[] = 'MODULE_ID';
        $arSelect[] = 'ITEM_ID';
        $arSelect[] = 'PARAM1';
        $arSelect[] = 'PARAM2';
 
        foreach ($arSelect as $field)
        {
            $field = mb_strtoupper($field);
            switch ($field)
            {
            case 'ID':
            case 'MODULE_ID':
            case 'ITEM_ID':
            case 'BODY':
            case 'PARAM1':
            case 'PARAM2':
            case 'CUSTOM_RANK':
            case 'USER_ID':
            case 'ENTITY_TYPE_ID':
            case 'ENTITY_ID':
            case 'TITLE':
            case 'TAGS':
                $sqlSelect[$field] = $strSearchContentAlias . '.' . $field;
                break;
            case 'URL':
                $sqlSelect[$field] = $strSearchContentAlias . '.' . $field;
                $sqlSelect['SITE_URL'] = 'scsite.' . $field . ' SITE_URL';
                break;
            case 'SITE_ID':
                $sqlSelect['SITE_ID'] = 'scsite.' . $field;
                break;
            }
        }
 
        if (is_array($arFilter))
        {
            $obQueryWhere = new CSQLWhere;
            $obQueryWhere->SetFields([
                'MODULE_ID' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.MODULE_ID',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => false,
                ],
                'ITEM_ID' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.ITEM_ID',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => false,
                ],
                'PARAM1' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.PARAM1',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => false,
                ],
                'PARAM2' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.PARAM2',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => false,
                ],
                'USER_ID' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.USER_ID',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'int',
                    'JOIN' => false,
                ],
                'ENTITY_TYPE_ID' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.ENTITY_TYPE_ID',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => false,
                ],
                'ENTITY_ID' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.ENTITY_ID',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => false,
                ],
                'DATE_FROM' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.DATE_FROM',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'datetime',
                    'JOIN' => false,
                ],
                'DATE_TO' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.DATE_TO',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'datetime',
                    'JOIN' => false,
                ],
                'DATE_CHANGE' => [
                    'TABLE_ALIAS' => $strSearchContentAlias,
                    'FIELD_NAME' => $strSearchContentAlias . '.DATE_CHANGE',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'datetime',
                    'JOIN' => false,
                ],
                'SITE_ID' => [
                    'TABLE_ALIAS' => 'scsite',
                    'FIELD_NAME' => 'scsite.SITE_ID',
                    'MULTIPLE' => 'N',
                    'FIELD_TYPE' => 'string',
                    'JOIN' => true,
                ],
            ]);
            $sqlWhere = $obQueryWhere->GetQuery($arFilter);
        }
 
        $strSql = 'SELECT
            ' . implode(', ', $sqlSelect) . '
            FROM
                b_search_content ' . $strSearchContentAlias . '
                INNER JOIN b_search_content_site scsite on scsite.SEARCH_CONTENT_ID = ' . $strSearchContentAlias . '.ID
            ' . ($sqlWhere ? 'WHERE ' . $sqlWhere : '') . '
            ' . (!empty($sqlOrder) ? 'ORDER BY ' . implode(', ', $sqlOrder) : '') . '
        ';
 
        $res = $DB->Query($strSql);
        $res = new CSearchItem($res);
        return $res;
    }
 
    function Fetch()
    {
        static $arSite = [];
 
        $r = parent::Fetch();
        if ($r)
        {
            $site_id = $r['SITE_ID'];
            if (!isset($arSite[$site_id]))
            {
                $rsSite = CSite::GetList('', '', ['ID' => $site_id]);
                $arSite[$site_id] = $rsSite->Fetch();
            }
            $r['DIR'] = $arSite[$site_id]['DIR'];
            $r['SERVER_NAME'] = $arSite[$site_id]['SERVER_NAME'];
 
            if ($r['SITE_URL'] <> '')
            {
                $r['URL'] = $r['SITE_URL'];
            }
 
            if (mb_substr($r['URL'], 0, 1) == '=')
            {
                foreach (GetModuleEvents('search', 'OnSearchGetURL', true) as $arEvent)
                {
                    $newUrl = ExecuteModuleEventEx($arEvent, [$r]);
                    if (isset($newUrl))
                    {
                        $r['URL'] = $newUrl;
                    }
                }
            }
 
            $r['URL'] = str_replace(
                ['#LANG#', '#SITE_DIR#', '#SERVER_NAME#'],
                [$r['DIR'], $r['DIR'], $r['SERVER_NAME']],
                $r['URL']
            );
            $r['URL'] = preg_replace("'(?<!:)/+'s", '/', $r['URL']);
 
            unset($r['SITE_URL']);
        }
 
        return $r;
    }
}