php - Yii 框架 : get sum by scope

Question

我的用户模型中有范围:

public function scopes()
{
    return array(
        'sumPrice'=>array(
             'select'=>'SUM(`price`)',
         ),
    );
}

我想在 Controller 中获取 sumPrice，但我不知道有什么方法可以做到这一点。我试过:

$sumPrice=User::model()->sumPrice(); //it returns empty record (user model filled by NULLs)

$sumPrice=User::model()->sumPrice()->count(); //it returns count records in user

$sumPrice=User::model()->sumPrice()->findAll(); //it returns all records in user

但是没有返回和的函数，那么如何得到它呢？

已解决:

$sumPrice = Yii::app()->db->createCommand('SELECT SUM(`price`) AS `sum` FROM `user`')->queryAll();
var_dump($sumPrice[0]['sum']);

Answer 1

您需要对事件记录进行统计查询，在模型上定义关系

 class Post extends CActiveRecord
 {
     public function relations()
     {
         return array(
             'commentCount'=>array(self::STAT, 'Comment', 'post_id'),
             'categoryCount'=>array(
                 self::STAT, 'Category', 'post_category(post_id, category_id)'
             ),
         );
     }
 }

Yiiframework