[faraz]

Bagaimana membuat footer yang isinya total dari kolom-kolom di atasnya di cgridview?

[faraz]

Ternyata cukup simple dulur...
tinggal tambahin di model nya
public function getSearchCriteria(){

$criteria=new CDbCriteria;

$criteria->compare('id',$this->id);
$criteria->compare('nama',$this->nama,true);
$criteria->compare('nilai',$this->nilai,true);
return $criteria;
}

public function getTotals()
{
$criteria=$this->getSearchCriteria();
$criteria->select='SUM(nilai)';
return $this->commandBuilder->createFindCommand($this->getTableSchema(),$criteria)->queryScalar();
}
di view:
'footer'=>'Total: '.number_format($model->getTotals()),

[infoxbos]

 faraz, on 27 June 2012 - 10:51 PM, said:

Ternyata cukup simple dulur...
tinggal tambahin di model nya
public function getSearchCriteria(){

$criteria=new CDbCriteria;

$criteria->compare('id',$this->id);
$criteria->compare('nama',$this->nama,true);
$criteria->compare('nilai',$this->nilai,true);
return $criteria;
}

public function getTotals()
{
$criteria=$this->getSearchCriteria();
$criteria->select='SUM(nilai)';
return $this->commandBuilder->createFindCommand($this->getTableSchema(),$criteria)->queryScalar();
}
di view:
'footer'=>'Total: '.number_format($model->getTotals()),

Terimakasih mas bos atas ilmunya. Sukses ane bisa totalin kolom nya.
Trimakasih master

[ahmadroni]

mungkin disini dapat jadi tambahan referensi..
http://www.yiiframew...coming-from-db/

[mbahsomo]

Wah keren, perlu di coba tuh