Call Function In Cgridview

rohan70422 · September 24, 2012, 9:26am

I am newbie to YII. This is my CgridView. The function (TblPaid::model()->alreadyPaidUpto(arg1,arg2)) called three times in adjacent columns of same CgidView. I want to call the funtion once and reuse the result in other two columns. Could someone please give me a hint?, Thanks.

$this->widget(‘SpecialGridView’, array(

    'id'=&gt;'tbl-deposit-grid',


    'dataProvider'=&gt;&#036;model-&gt;balanceSearch(&#036;dateReport,&#036;category,&#036;officeID),


    'extraparam'=&gt; &#036;dateReport,


    //'filter'=&gt;&#036;model,


    'columns'=&gt;array(


            //'category',


            array('name'=&gt;'category', 'headerHtmlOptions'=&gt;array('width'=&gt;'50px')),


            //'account',


            array('name'=&gt;'account', 'headerHtmlOptions'=&gt;array('width'=&gt;'120px')),


            //'officeID',


            array('name'=&gt;'officeID', 'header'=&gt;'Office', 'type'=&gt;'raw', 'value'=&gt;'(empty(&#036;data-&gt;office))? &#036;data-&gt;officeID: &#036;data-&gt;office-&gt;office','headerHtmlOptions'=&gt;array('width'=&gt;'120px')),


            //'receiptNo',


            array('name'=&gt;'id', 'headerHtmlOptions'=&gt;array('width'=&gt;'90px')),


            //'dateReceived',


            array('name'=&gt;'dateReceived', 'headerHtmlOptions'=&gt;array('width'=&gt;'70px')),


            //'amount',


            array(


                    'name'=&gt;'amount','headerHtmlOptions'=&gt;array('width'=&gt;'80px'),


                    'value'=&gt;'number_format(&#036;data-&gt;amount,2)', 'htmlOptions'=&gt;array('style'=&gt;'text-align: right'),


            ),


            array('name'=&gt;'Paid upto this Date',


            'value'=&gt;'number_format((TblPaid::model()-&gt;alreadyPaidUpto(&#036;data-&gt;id, &#036;this-&gt;grid-&gt;extraparam)),2)','htmlOptions'=&gt;array('style'=&gt;'text-align: right'),


            ),


            array('name'=&gt;'Balance',


            'value'=&gt;'number_format(&#036;data-&gt;amount-(TblPaid::model()-&gt;alreadyPaidUpto(&#036;data-&gt;id, &#036;this-&gt;grid-&gt;extraparam)),2)','htmlOptions'=&gt;array('style'=&gt;'text-align: right'),


            ),


            //


            array(


                    'header'=&gt;'Running Balance',


                    'class'=&gt;'RunningTotalColumn',


                    'value'=&gt;'&#036;data-&gt;amount-(TblPaid::model()-&gt;alreadyPaidUpto(&#036;data-&gt;id, &#036;this-&gt;grid-&gt;extraparam))',


                    'htmlOptions'=&gt;array('style'=&gt;'text-align: right'),


            ),


            //'receivedBy',


            array('name'=&gt;'receivedBy', 'headerHtmlOptions'=&gt;array('width'=&gt;'200px')),


            //'type',


            array('name'=&gt;'type', 'headerHtmlOptions'=&gt;array('width'=&gt;'80px')),


            //'comment',


            //array('name'=&gt;'comment', 'headerHtmlOptions'=&gt;array('width'=&gt;'110px')),


    ),

));

zaccaria · September 24, 2012, 11:30am

The solution is to call the function three times as you do right now.

Save the result in the model itself like that:


protected $_alreadyPaidUpto=array();


public function alreadyPaidUpto($arg1,$arg2)

{

   if (!isset($this->_alreadyPaidUpto[$arg1][$arg2])){

       //calculate the value and set:

       $this->_alreadyPaidUpto[$arg1][$arg2]=$calculatedValue;

   }

   return $this->_alreadyPaidUpto[$arg1][$arg2];

}

In this way you are sure that the function is called only once.

This helps you keeping the view simple and moving logic in the model.

rohan70422 · September 25, 2012, 4:16am

zaccaria:

The solution is to call the function three times as you do right now.

Save the result in the model itself like that:
protected $_alreadyPaidUpto=array();


public function alreadyPaidUpto($arg1,$arg2)

{

   if (!isset($this->_alreadyPaidUpto[$arg1][$arg2])){

       //calculate the value and set:

       $this->_alreadyPaidUpto[$arg1][$arg2]=$calculatedValue;

   }

   return $this->_alreadyPaidUpto[$arg1][$arg2];

}
In this way you are sure that the function is called only once.

This helps you keeping the view simple and moving logic in the model.

Thanks a lot for the very helpful answer