没有命名空间的类 yii yii\base yii\behaviors yii\caching yii\captcha yii\console yii\console\controllers yii\console\widgets yii\data yii\db yii\db\conditions yii\db\cubrid yii\db\cubrid\conditions yii\db\mssql yii\db\mssql\conditions yii\db\mysql yii\db\oci yii\db\oci\conditions yii\db\pgsql yii\db\sqlite yii\db\sqlite\conditions yii\di yii\filters yii\filters\auth yii\grid yii\helpers yii\i18n yii\log yii\mail yii\mutex yii\rbac yii\rest yii\test yii\validators yii\web yii\widgets

Class yii\db\conditions\BetweenColumnsCondition

继承yii\db\conditions\BetweenColumnsCondition
实现yii\db\conditions\ConditionInterface
可用版本自2.0.14
源码 https://github.com/yiichina/yii2/blob/api/framework/db/conditions/BetweenColumnsCondition.php

BetweenColumnCondition 类表示 BETWEEN 条件 其中值在两个列中间。比如:

new BetweenColumnsCondition(42, 'BETWEEN', 'min_value', 'max_value')
// Will be built to:
// 42 BETWEEN min_value AND max_value

还有更加复杂的例子:

new BetweenColumnsCondition(
   new Expression('NOW()'),
   'NOT BETWEEN',
   (new Query)->select('time')->from('log')->orderBy('id ASC')->limit(1),
   'update_time'
);

// Will be built to:
// NOW() NOT BETWEEN (SELECT time FROM log ORDER BY id ASC LIMIT 1) AND update_time

方法详情

__construct() 公共 方法

使用 BETWEEN 运算符创建条件

public void __construct($value, $operator, $intervalStartColumn, $intervalEndColumn)
$value
$operator string

要使用的运算符(例如:BETWEEN or NOT BETWEEN

$intervalStartColumn string|yii\db\ExpressionInterface

作为间隔开头的列名称或表达式

$intervalEndColumn string|yii\db\ExpressionInterface

作为间隔结尾的列名称或表达式

fromArrayDefinition() 公共 静态 方法

按照 文档:查询构建器 - 操作符格式 文档中的描述, 以数组定义创建对象。

public static $this fromArrayDefinition($operator, $operands)
$operator string

操作符大写。

$operands array

相应操作数的数组。

throws yii\base\InvalidArgumentException

如果已给出错误的操作数,则抛出 InvalidArgumentException 异常。

getIntervalEndColumn() 公共 方法

public string|yii\db\ExpressionInterface|yii\db\Query getIntervalEndColumn()
getIntervalStartColumn() 公共 方法

public string|yii\db\ExpressionInterface|yii\db\Query getIntervalStartColumn()
getOperator() 公共 方法

public string getOperator()
getValue() 公共 方法

public mixed getValue()