php - 如何向 Yii CDbCriteria select 添加条件？

Question

我使用这个代码。我想检查预算 < 0 是否选择它。

$criteria = new CDbCriteria;
$criteria->select = array('*', 'SUM(amount) as budget');
$criteria->group = 'user_id';
$debtors = Transactions::model()->findAll($criteria);

如何添加这个条件？

Answer 1

使用

$criteria = new CDbCriteria;
$criteria->select = array('*', 'SUM(amount) as budget');
$criteria->having = 'budget < 0 ' ;
$criteria->group = 'user_id';
$debtors = Transactions::model()->findAll($criteria);