how to format a column as currency in GridView(yii)?

Question

Hello everyone and thanks for reading . I was wondering how i could format a number into a currency or just simply attach € at the end. I am working in a gridview on the admin page in the yii framework. i have this as eg

'columns'=>array(
        'title',
            array(
                'name'=>'cost',
                'value'=>'$data->cost',
            )

score 8 · Accepted Answer · answered May 13 '13 at 13:15

8

The Yii way would be to use Yii's existing currency formatter, like this:

array(
      'name'=>'cost',
      'value'=>'Yii::app()->numberFormatter->formatCurrency($data->cost, "EUR")',
     )

answered May 13 '13 at 13:15

adamors

2,672
5
32
45

yhea this is what i was looking for , this is the yii way – Gunnit May 13 '13 at 13:18
1

In Yii2 we have: Yii::$app->formatter->asCurrency() – Rahul Jun 06 '18 at 12:17

score 2 · Answer 2 · answered May 12 '13 at 18:00

You can use php functions and some static text in value. Example:

'columns'=>array(
        'title',
            array(
                'name'=>'cost',
                'value'=>'$data->cost . " €" ',
            )

If you need to use this kind of formatting even more, I suggest to write a custom function to controller or extend CFormatter with custom currency function and use it as value. Please ead the yii homepage manual below. http://www.yiiframework.com/wiki/278/cgridview-render-customized-complex-datacolumns/

score 1 · Answer 3 · edited May 23 '17 at 11:45

1

I use php's money_format() to get the correct formatting.

It could look like this:

'columns'=>array(
    'title',
        array(
            'name'=>'cost',
            'value'=>'money_format("%!i", $data->cost)',
        )

You can specify a currency by setting locale before calling money_format(), like this:

setlocale(LC_MONETARY, 'ja_JP');

ja_JP is for japanese yen, used just as an example. More here.

edited May 23 '17 at 11:45

Community

1
1

answered May 13 '13 at 03:24

ippi

9,857
2
39
50

I call it in my SiteController. public function init(){ setlocale(LC_MONETARY, 'ja_JP'); } but you can call it pretty much anywhere as long as it's executed before money_format(). Personally, I think this *should* be set by YII when you set another language in your config. – ippi May 13 '13 at 09:56
This solution works on the server, but if you use Windows on the localhost , than you receive "Fatal error: Call to undefined function money_format()". See e.g.: http://stackoverflow.com/questions/6369887/alternative-to-money-format-function-in-php-on-windows-platform – Antonín Slejška Mar 04 '16 at 13:11

how to format a column as currency in GridView(yii)?

3 Answers3