I am using dhtmlxConnector for Grid with Yii Framework. Generally it works but when I add grouping and sum in sql I cannot access the sum column:
$criteria=new CDbCriteria();
$criteria->select=array('*','MONTH(sell_date) AS month_extr','SUM(value) AS summed_value');
$criteria->condition='sell_date >= DATE_SUB(NOW() , INTERVAL 1 YEAR) AND id=' . $_GET['id'];
$criteria->group='MONTH(sell_date)';
$criteria->order=' MONTH(sell_date) DESC';
$data = Invoice::model()->findAll($criteria);
$grid = new GridConnector($data, "PHPYii");
$grid->configure("-", "id", 'month_extr,summed_value');
$grid->render();
I cannot see any values in the grid from the above. When I use any other column name from model - it works.
In model definition I added
public $month_extr;
public $summed_value;
Unfortunately it didn’t help.
Any ideas?