How To Multiply Values On A Cgridview?

NewMeem · September 5, 2013, 11:47am

Hi…everyone…

Im trying to create a cgridview column which computes the total amount of two values Qty and UnitPrice…problem is…i dont know how???

glad to see the answers

$this->widget(‘zii.widgets.grid.CGridView’, array(

					'id'=&gt;'so-detail-grid',


					'dataProvider'=&gt;&#036;mod-&gt;getAllRelDocNo(&#036;dn),


					'filter'=&gt;&#036;mod,


					'columns'=&gt;array(


						'Qty',


						'UnitMeas',


						'ItemDesc',


						'CurSign',


					'UnitPrice',


					'War_Parts',


						'War_Labor',


						'War_Onsite',


						              array('name'=&gt;'..','value'=&gt;Qty*UnitPrice),


						


						array(


					  'class'=&gt;'CButtonColumn',


					  'viewButtonUrl'=&gt;'Yii::app()-&gt;createUrl(&#092;'sodetail/view&amp;id=&#092;'. &#036;data-&gt;DetailNo)',


					  'updateButtonUrl'=&gt;'Yii::app()-&gt;createUrl(&#092;'sodetail/update&amp;id=&#092;'. &#036;data-&gt;DetailNo)',


					  'deleteButtonUrl'=&gt;'Yii::app()-&gt;createUrl(&#092;'sodetail/delete&amp;id=&#092;'. &#036;data-&gt;DetailNo)',


					),


					),


				)); ?&gt;

Ankit_Modi · September 5, 2013, 12:10pm

you cam fetch the total on getAllRelDocNo function otherwise you can call custome function on value


array(


'name'=>'firstname',


'header'=>'Name',


'value'=>'Users::model()->gettotal()',


),


public function gettotal(){

  //write a query

}

NewMeem · September 5, 2013, 12:11pm

Thanks it works

Maggie Q:

you cam fetch the total on getAllRelDocNo function otherwise you can call custome function on value
array(


'name'=>'firstname',


'header'=>'Name',


'value'=>'Users::model()->gettotal()',


),
public function gettotal(){

  //write a query

}