src/Bridge/Doctrine/Orm/Filter/RangeFilter.php
protected function addWhere(QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, $alias, $field, $operator, $value)
    {
        $valueParameter = $queryNameGenerator->generateParameterName($field);

        switch ($operator) {
            case self::PARAMETER_BETWEEN:
                $rangeValue = explode('..', $value);

                $rangeValue = $this->normalizeBetweenValues($rangeValue);
                if (null === $rangeValue) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%1$s.%2$s BETWEEN :%3$s_1 AND :%3$s_2', $alias, $field, $valueParameter))
                    ->setParameter(sprintf('%s_1', $valueParameter), $rangeValue[0])
                    ->setParameter(sprintf('%s_2', $valueParameter), $rangeValue[1]);

                break;
            case self::PARAMETER_GREATER_THAN:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s > :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
            case self::PARAMETER_GREATER_THAN_OR_EQUAL:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s >= :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
            case self::PARAMETER_LESS_THAN:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s < :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
            case self::PARAMETER_LESS_THAN_OR_EQUAL:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s <= :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
        }
    }
protected function addWhere(QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, $alias, $field, $operator, $value)
    {
        $valueParameter = $queryNameGenerator->generateParameterName($field);

        switch ($operator) {
            case self::PARAMETER_BETWEEN:
                $rangeValue = explode('..', $value);

                $rangeValue = $this->normalizeBetweenValues($rangeValue);
                if (null === $rangeValue) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%1$s.%2$s BETWEEN :%3$s_1 AND :%3$s_2', $alias, $field, $valueParameter))
                    ->setParameter(sprintf('%s_1', $valueParameter), $rangeValue[0])
                    ->setParameter(sprintf('%s_2', $valueParameter), $rangeValue[1]);

                break;
            case self::PARAMETER_GREATER_THAN:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s > :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
            case self::PARAMETER_GREATER_THAN_OR_EQUAL:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s >= :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
            case self::PARAMETER_LESS_THAN:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s < :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
            case self::PARAMETER_LESS_THAN_OR_EQUAL:
                $value = $this->normalizeValue($value, $operator);
                if (null === $value) {
                    return;
                }

                $queryBuilder
                    ->andWhere(sprintf('%s.%s <= :%s', $alias, $field, $valueParameter))
                    ->setParameter($valueParameter, $value);

                break;
        }
    }
protected function addWhere ( QueryBuilder $ queryBuilder , QueryNameGeneratorInterface $ queryNameGenerator , $ alias , $ field , $ operator , $ value ) { $ valueParameter = $ queryNameGenerator -> generateParameterName ( $ field ) ; switch ( $ operator ) { case self :: PARAMETER_BETWEEN : $ rangeValue = explode ( '..' , $ value ) ; $ rangeValue = $ this -> normalizeBetweenValues ( $ rangeValue ) ; if ( null === $ rangeValue ) { return ; } $ queryBuilder -> andWhere ( sprintf ( '%1$s.%2$s BETWEEN :%3$s_1 AND :%3$s_2' , $ alias , $ field , $ valueParameter ) ) -> setParameter ( sprintf ( '%s_1' , $ valueParameter ) , $ rangeValue [ 0 ] ) -> setParameter ( sprintf ( '%s_2' , $ valueParameter ) , $ rangeValue [ 1 ] ) ; break ; case self :: PARAMETER_GREATER_THAN : $ value = $ this -> normalizeValue ( $ value , $ operator ) ; if ( null === $ value ) { return ; } $ queryBuilder -> andWhere ( sprintf ( '%s.%s > :%s' , $ alias , $ field , $ valueParameter ) ) -> setParameter ( $ valueParameter , $ value ) ; break ; case self :: PARAMETER_GREATER_THAN_OR_EQUAL : $ value = $ this -> normalizeValue ( $ value , $ operator ) ; if ( null === $ value ) { return ; } $ queryBuilder -> andWhere ( sprintf ( '%s.%s >= :%s' , $ alias , $ field , $ valueParameter ) ) -> setParameter ( $ valueParameter , $ value ) ; break ; case self :: PARAMETER_LESS_THAN : $ value = $ this -> normalizeValue ( $ value , $ operator ) ; if ( null === $ value ) { return ; } $ queryBuilder -> andWhere ( sprintf ( '%s.%s < :%s' , $ alias , $ field , $ valueParameter ) ) -> setParameter ( $ valueParameter , $ value ) ; break ; case self :: PARAMETER_LESS_THAN_OR_EQUAL : $ value = $ this -> normalizeValue ( $ value , $ operator ) ; if ( null === $ value ) { return ; } $ queryBuilder -> andWhere ( sprintf ( '%s.%s <= :%s' , $ alias , $ field , $ valueParameter ) ) -> setParameter ( $ valueParameter , $ value ) ; break ; } }
Adds the where clause according to the operator.

@param string $alias
@param string $field
@param string $operator
@param string $value
Adds the where clause according to the operator .