package | Default |
---|---|
inherited_from | \Zend\Db\Sql\Predicate\PredicateSet |
__construct(null|array $predicates= null
, string $defaultCombination= self::COMBINED_BY_AND
)
null
array
string
__get(string $name) : \Zend\Db\Sql\Predicate\Predicate
Overloads "or", "and", "nest", and "unnest"
string
\Zend\Db\Sql\Predicate\Predicate
addPredicate(\Zend\Db\Sql\Predicate\PredicateInterface $predicate, string $combination = null
) : \Zend\Db\Sql\Predicate\PredicateSet
\Zend\Db\Sql\Predicate\PredicateInterface
string
\Zend\Db\Sql\Predicate\PredicateSet
addPredicates(\Zend\Db\Sql\Predicate\PredicateInterface|\Closure|string|array $predicates, string $combination = self::OP_AND
) : \Zend\Db\Sql\Predicate\PredicateSet
\Zend\Db\Sql\Predicate\PredicateInterface
\Closure
string
array
string
\Zend\Db\Sql\Predicate\PredicateSet
andPredicate(\Zend\Db\Sql\Predicate\PredicateInterface $predicate) : \Zend\Db\Sql\Predicate\PredicateSet
\Zend\Db\Sql\Predicate\PredicateInterface
\Zend\Db\Sql\Predicate\PredicateSet
between(string $identifier, integer|float|string $minValue, integer|float|string $maxValue) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Between predicate
string
integer
float
string
integer
float
string
\Zend\Db\Sql\Predicate\Predicate
count() : integer
integer
equalTo(integer|float|boolean|string $left, integer|float|boolean|string $right, string $leftType= self::TYPE_IDENTIFIER
, string $rightType= self::TYPE_VALUE
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Operator predicate
integer
float
boolean
string
integer
float
boolean
string
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_IDENTIFIER {@see allowedTypes}
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_VALUE {@see allowedTypes}
\Zend\Db\Sql\Predicate\Predicate
expression($expression, $parameters) : \Zend\Db\Sql\Predicate\Predicate
fluent | This method is part of a fluent interface and will return the same instance |
---|
\Zend\Db\Sql\Predicate\Predicate
getExpressionData() : array
array
getPredicates() : array<mixed,\Zend\Db\Sql\Predicate\PredicateInterface>
array<mixed,\Zend\Db\Sql\Predicate\PredicateInterface>
greaterThan(integer|float|boolean|string $left, integer|float|boolean|string $right, string $leftType= self::TYPE_IDENTIFIER
, string $rightType= self::TYPE_VALUE
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Operator predicate
integer
float
boolean
string
integer
float
boolean
string
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_IDENTIFIER {@see allowedTypes}
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_VALUE {@see allowedTypes}
\Zend\Db\Sql\Predicate\Predicate
greaterThanOrEqualTo(integer|float|boolean|string $left, integer|float|boolean|string $right, string $leftType= self::TYPE_IDENTIFIER
, string $rightType= self::TYPE_VALUE
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Operator predicate
integer
float
boolean
string
integer
float
boolean
string
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_IDENTIFIER {@see allowedTypes}
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_VALUE {@see allowedTypes}
\Zend\Db\Sql\Predicate\Predicate
in(string $identifier, array|\Zend\Db\Sql\Select $valueSet = null
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes In predicate
string
array
\Zend\Db\Sql\Select
\Zend\Db\Sql\Predicate\Predicate
isNotNull(string $identifier) : \Zend\Db\Sql\Predicate\Predicate
Utilizes IsNotNull predicate
string
\Zend\Db\Sql\Predicate\Predicate
isNull(string $identifier) : \Zend\Db\Sql\Predicate\Predicate
Utilizes IsNull predicate
string
\Zend\Db\Sql\Predicate\Predicate
lessThan(integer|float|boolean|string $left, integer|float|boolean|string $right, string $leftType= self::TYPE_IDENTIFIER
, string $rightType= self::TYPE_VALUE
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Operator predicate
integer
float
boolean
string
integer
float
boolean
string
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_IDENTIFIER {@see allowedTypes}
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_VALUE {@see allowedTypes}
\Zend\Db\Sql\Predicate\Predicate
lessThanOrEqualTo(integer|float|boolean|string $left, integer|float|boolean|string $right, string $leftType= self::TYPE_IDENTIFIER
, string $rightType= self::TYPE_VALUE
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Operator predicate
integer
float
boolean
string
integer
float
boolean
string
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_IDENTIFIER {@see allowedTypes}
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_VALUE {@see allowedTypes}
\Zend\Db\Sql\Predicate\Predicate
like(string $identifier, string $like) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Like predicate
string
string
\Zend\Db\Sql\Predicate\Predicate
literal(string $literal) : \Zend\Db\Sql\Predicate\Predicate
Literal predicate, for parameters, use expression()
string
\Zend\Db\Sql\Predicate\Predicate
nest() : \Zend\Db\Sql\Predicate\Predicate
\Zend\Db\Sql\Predicate\Predicate
notEqualTo(integer|float|boolean|string $left, integer|float|boolean|string $right, string $leftType= self::TYPE_IDENTIFIER
, string $rightType= self::TYPE_VALUE
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes Operator predicate
integer
float
boolean
string
integer
float
boolean
string
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_IDENTIFIER {@see allowedTypes}
string
TYPE_IDENTIFIER or TYPE_VALUE by default TYPE_VALUE {@see allowedTypes}
\Zend\Db\Sql\Predicate\Predicate
notIn(string $identifier, array|\Zend\Db\Sql\Select $valueSet = null
) : \Zend\Db\Sql\Predicate\Predicate
Utilizes NotIn predicate
string
array
\Zend\Db\Sql\Select
\Zend\Db\Sql\Predicate\Predicate
notLike(string $identifier, string $notLike) : \Zend\Db\Sql\Predicate\Predicate
Utilizes In predicate
string
string
\Zend\Db\Sql\Predicate\Predicate
orPredicate(\Zend\Db\Sql\Predicate\PredicateInterface $predicate) : \Zend\Db\Sql\Predicate\PredicateSet
\Zend\Db\Sql\Predicate\PredicateInterface
\Zend\Db\Sql\Predicate\PredicateSet
predicate(\Zend\Db\Sql\Predicate\PredicateInterface $predicate) : \Zend\Db\Sql\Predicate\Predicate
Contrary to \addPredicate() this method respects formerly set AND / OR combination operator, thus allowing generic predicates to be used fluently within where chains as any other concrete predicate.
\Zend\Db\Sql\Predicate\PredicateInterface
\Zend\Db\Sql\Predicate\Predicate
setUnnest(\Zend\Db\Sql\Predicate\Predicate $predicate) : void
\Zend\Db\Sql\Predicate\Predicate
unnest() : \Zend\Db\Sql\Predicate\Predicate
\Zend\Db\Sql\Exception\RuntimeException |
---|
\Zend\Db\Sql\Predicate\Predicate
$AND : \Zend\Db\Sql\Predicate\Predicate
magic | |
---|---|
property |
$NEST : \Zend\Db\Sql\Predicate\Predicate
magic | |
---|---|
property |
$OR : \Zend\Db\Sql\Predicate\Predicate
magic | |
---|---|
property |
$UNNEST : \Zend\Db\Sql\Predicate\Predicate
magic | |
---|---|
property |
$and : \Zend\Db\Sql\Predicate\Predicate
magic | |
---|---|
property |
$or : \Zend\Db\Sql\Predicate\Predicate
magic | |
---|---|
property |
$defaultCombination
self::COMBINED_BY_AND
$nextPredicateCombineOperator
null
$predicates
array()
$unnest
null
COMBINED_BY_AND = 'AND'
COMBINED_BY_OR = 'OR'
OP_AND = 'AND'
OP_OR = 'OR'