PHP狮身人面像，使用或在setFilter()中使用

Question

以下是我的sphinx的提取代码。我们有一个名为TypeID的过滤器，用于比较局类型。现在，我添加了一个名为AltTypeid的过滤器。现在，我必须比较类typeID和alttypeid的相同值，例如typeid = 6或alttypeid = 6。

我尝试过几种解决方案，但没有人在起作用。我遵循了此链接上的解决方案：https：//sphx.org/forum/view.html?id=13474，但它也无法正常工作。

protected function fetch() {
        $this->_searchCriteria->orders = $this->sort;
        $this->pagination->validateCurrentPage = false;
        $this->_searchCriteria->paginator = $this->pagination;
        $this->_searchCriteria->query.=" profileTypePlaceholderTexxxxxt";
        Yii::app()->search->SetLimits($this->pagination->offset, $this->pagination->limit);
        Yii::app()->search->SetFieldWeights($this->_fieldWeights);
        if ($this->_searchCriteria->query)
            Yii::app()->search->setMatchMode(SPH_MATCH_ALL);
        else
            Yii::app()->search->setMatchMode(SPH_MATCH_FULLSCAN);
        Yii::app()->search->setFieldWeights(array(
            'primary_comp' => 100,
            'premium' => 80,
            'standard' => 60,
            'free' => 40,
            'comp' => 20,
            'title' => 5,
            'description' => 5,
        ));
        //Yii::app()->search->SetSortMode(SPH_SORT_EXTENDED, '@weight DESC');
        Yii::app()->search->SetSortMode(SPH_SORT_EXTENDED,'@weight DESC, random DESC');

        foreach ($this->_searchCriteria->filters as $filter) {
            if ($filter[0] == 'range')
                Yii::app()->search->SetFilterFloatRange($filter[1], (float) $filter[2] + 0.01, (float) $filter[3]);
            else
                Yii::app()->search->SetFilter($filter[0], array($filter[1]));
        }
        $results = Yii::app()->search->Query($this->_searchCriteria->query, $this->_searchCriteria->from);
        $this->_data = array();
        $this->_keys = array();
        $this->_itemCount = $results['total'];
        $this->pagination->itemCount = $this->_itemCount;
        if ($this->_itemCount) {
            $this->_populateItems($results['matches']);
        }
    }

Answer 1

坦率地将两个值放在同一狮身人面表attrbute中，似乎最简单。MVA非常适合！

可以做几种方法，但只是...

sql_query = SELECT id,title, CONCAT_WS(',',typeId,altTypeId) AS typeids FROM ... 
sql_attr_multi = uint typeids from field

然后只是

->SetFilter('typeids', array(6));

从任一列找到结果。

---

否则，如果真的只想在查询时间进行操作，则类似于

if ($filter[0] == 'typeid') {
    Yii::app()->search->SetSelect("*, (typeid = {$filter[1]} OR altTypeId = {$filter[1]}) AS myfilter");
    Yii::app()->search->SetFilter('myfilter', array(1));
} else ...