Yii：按日期计算汇总

Question

I have a simple model in Yii 1.1:

Expense

amount: int
date: string

How do I compute an aggregate by date using build-in Yii capabilities?

In other words I would like to get a result of the following query using Yii:

SELECT
  date, SUM(amount) AS dateAmount

FROM
  tbl_expense

GROUP BY
  date

ORDER BY
  date DESC

Answer 1

I have explored 2 ways for executing query,

First:

$list= Yii::app()->db->createCommand('SELECT date, SUM(amount) AS dateAmount
FROM tbl_expense
GROUP BY date
ORDER BY date DESC')->queryAll();
var_dump($list->getData());

Second: (Normally used to provide dataprovider to Gridview and Listview)

$select = "SELECT date, SUM(amount) AS dateAmount
FROM tbl_expense
GROUP BY date
ORDER BY date DESC";

$dataProvider=new CSqlDataProvider($select,
array(
    'pagination'=>false,
    'params'=>$sqlParam
   )
);
var_dump($dataProvider->getData());