예제 #1
0
 /**
  * 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);
     }
 }
예제 #3
0
 /**
  * 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()]);
 }
예제 #5
0
 /**
  * @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;
 }
예제 #6
0
 /**
  * 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()]);
 }