Using Aggregate Values In Cgridview Using Cactivedataprovider

Yii 1.1 General Discussion
1

dear friends I want to display the total number of medicines does the order has in the grid view using active data provider… like this

$data->totalMedicines

but I got the error

I count this value in criteria as

…

‘select’=>’ count(medicine) AS totalMedicines’,

…

help me

2

Hello Dear !!!

Just define " totalMedicines " property in ur Model Class like this





public $totalMedicines;
3

your solution is here…

please see it…

http://www.yiiframework.com/forum/index.php/topic/46074-implement-sum-query/page__p__216820__fromsearch__1#entry216820

4

I saw your reply…,

I did like this in the criteria and pass it to cactivedataprovider except I dont have such a variable like the above

$TotalDt is this really works? does the summed value stored to this variable? …

5

Yes in my provious comment it’s work fine…please try it…and stored the value on varible so please wirte a query and pass the criteria…so it’s work fine and return the $TotalDt

for example…


$sumDT =  DayaTampungS1::model()->findAll($criteria);

print_r(count($sumDT));