/** * Apply fulltext filters * * @param DbCollection $collection * @param Filter $filter * @return void */ public function apply(DbCollection $collection, Filter $filter) { $columns = $this->getFulltextIndexColumns($collection, $collection->getMainTable()); if (!$columns) { return; } $collection->getSelect()->where('MATCH(' . implode(',', $columns) . ') AGAINST(?)', $filter->getValue()); }
/** * {@inheritdoc} */ public function addFilter(\Magento\Framework\Api\Filter $filter) { if (isset($this->addFilterStrategies[$filter->getField()])) { $this->addFilterStrategies[$filter->getField()]->addFilter($this->getCollection(), $filter->getField(), [$filter->getConditionType() => $filter->getValue()]); } else { parent::addFilter($filter); } }
/** * Apply fulltext filters * * @param Collection $collection * @param Filter $filter * @return void */ public function apply(Collection $collection, Filter $filter) { if (!$collection instanceof AbstractDb) { throw new \InvalidArgumentException('Database collection required.'); } /** @var SearchResult $collection */ $mainTable = $collection->getMainTable(); $columns = $this->getFulltextIndexColumns($collection, $mainTable); if (!$columns) { return; } $columns = $this->addTableAliasToColumns($columns, $collection, $mainTable); $collection->getSelect()->where('MATCH(' . implode(',', $columns) . ') AGAINST(?)', $filter->getValue()); }
/** * @inheritdoc */ public function addFilter(\Magento\Framework\Api\Filter $filter) { $this->getCollection()->addFieldToFilter($filter->getField(), [$filter->getConditionType() => $filter->getValue()]); }
/** * @param FeedInterface $feed * @param Filter $filter * @return bool */ private function isFeedMatchesFilter(FeedInterface $feed, Filter $filter) { switch (strtolower($filter->getField())) { case 'id': $isMatches = $filter->getValue() === $feed->getId(); break; case 'title': $isMatches = strpos($feed->getTitle(), $filter->getValue()) !== false; break; case 'description': $isMatches = strpos($feed->getDescription(), $filter->getValue()) !== false; break; default: $isMatches = false; break; } return $isMatches; }
/** * Apply regular filters like collection filters * * @param AbstractDb $collection * @param Filter $filter * @return void */ public function apply(AbstractDb $collection, Filter $filter) { $collection->addFieldToFilter($filter->getField(), [$filter->getConditionType() => $filter->getValue()]); }