php - Yii，单一关系中的双重标准

Question

我对关系中相同字段的第二个标准有疑问

$criteria->with = array( 'Rel1',
                         'Rel1.Rel2' => ['alias'=>'attrType']);
$criteria->condition = 'Type=:type';
// first condition with Re1.value and Rel2.name - without second works fine
$criteria->addCondition("attrType.name='start' AND Rel1.value <= NOW()");

// second criteria with Re1.value and Rel2.name
$criteria->addCondition("attrType.name='end' AND Rel1.value > NOW()");

$criteria->order = 'Rel1.value DESC';

$criteria->params = [':type'=> 22];
$result = SomeModel::model()->findAll($criteria);

如果没有第二个条件，我有多个带有开始名称和结束名称的记录。如果我以第二个条件运行，我会找到 0 条记录。请帮助:/

Answer 1

您的混合条件将如下所示:

attrType.name='start' AND attrType.name='end' AND 
    Rel1.value <= NOW() AND Rel1.value > NOW()

这部分Rel1.value <= NOW() AND Rel1.value > NOW()始终为假