Keyword Filter

KeywordFilter.php

<?php

namespace Docudex\Bundle\DocumentBundle\Search\Filter\Doctrine;

use Doctrine\ORM\Query\Expr;
use Doctrine\ORM\QueryBuilder;
use Docudex\Bundle\DocumentBundle\Search\Filter\FilterInterface;

/**
 * Keyword Filter
 *
 * @author Mohammad Emran Hasan <phpfour@gmail.com>
 */
class KeywordFilter implements FilterInterface
{
    public function filter($constraints, QueryBuilder $qb)
    {
        $qb->innerJoin('DocudexDocumentBundle:Version', 'v', Expr\Join::WITH, 'v = d.latestVersion');

        $qb->andWhere(
            $qb->expr()->orX(
                $qb->expr()->like('v.title', ':title'),
                $qb->expr()->like('v.description', ':description')
            ))
            ->setParameter('title', '%' . $constraints['keyword'] . '%')
            ->setParameter('description', '%' . $constraints['keyword'] . '%');
    }
}