ezsystems / ezpublish-kernel

use eZ\Publish\Core\Persistence\Legacy\URL\Query\CriterionHandler;

use eZ\Publish\Core\Persistence\Database\SelectQuery;

class Pattern implements CriterionHandler

{

    /**

     * {@inheritdoc}

     */

    public function accept(Criterion $criterion)

    {

        return $criterion instanceof Criterion\Pattern;

    }

    /**

     * {@inheritdoc}

     */

    public function handle(CriteriaConverter $converter, SelectQuery $query, Criterion $criterion)

    {

        /** @var Criterion\Pattern $criterion */

        return $query->expr->like(

            'url',

            $query->bindValue('%' . $criterion->pattern . '%')

        );

    }

}

use eZ\Publish\Core\Persistence\Legacy\URL\Query\CriterionHandler;

use eZ\Publish\Core\Persistence\Database\SelectQuery;

class Validity implements CriterionHandler

{

    /**

     * {@inheritdoc}

     */

    public function accept(Criterion $criterion)

    {

        return $criterion instanceof Criterion\Validity;

    }

    /**

     * {@inheritdoc}

     */

    public function handle(CriteriaConverter $converter, SelectQuery $query, Criterion $criterion)

    {

        /** @var Criterion\Validity $criterion */

        return $query->expr->eq(

            'is_valid',

            $query->bindValue((int) $criterion->isValid)

        );

    }

}