Yii2 GridView column data display with comma separation format

Question

I am using Kartik GridView in yii2 project.

When I specify column format as decimal it shows the output as 112,233,335.

I want this number as 11,22,33,335.

How can I do so ? I also want page summery for this column in the same comma separated format.

and your code? you can use yii2 [asDecimal()](http://www.yiiframework.com/doc-2.0/yii-i18n-formatter.html#asDecimal()-detail) — Insane Skull, Jan 04 '18 at 11:55
you should use Masked-input, look at this: http://demos.krajee.com/masked-input — Patrick Arguello, Jan 04 '18 at 21:58

score 0 · Answer 1 · answered Jan 04 '18 at 17:20

0

you can set it :

['format'=>'number', 'decimals'=>2, 'decPoint'=>'.', 'thousandSep'=>',']

change 2 to which you desire .

answered Jan 04 '18 at 17:20

kiamoz

714
1
7
18

score 0 · Answer 2 · answered Jan 05 '18 at 05:44

the following code worked for me:

        'pageSummaryFunc' => function ($data) { 
            array_walk($data, function (&$v) {
                $v = intval(preg_replace('/[^\d.]/', '', $v));
            });
            return General::getInrFormat(array_sum($data));
        },

In this code I specify what to display and how to calculate page_summary for the column. getInrFormat() is my own function which returns the numeric value in indian currency format.

Yii2 GridView column data display with comma separation format

2 Answers2