CRUD: currency columun

[blondie63]

How can i set a column to show a currency fields with correct format for Italy ?

i'm using BackPack v6

Thanks for help :)

[karandatwani92]

Hey @blondie63

Please try the available options of the number column.
OR You'll need to create a custom column if it doesn't fit your needs.

• Command to create new column type php artisan backpack:column currency
• Guide on Creating a Custom Column Type

[blondie63]

I've set my column so:

        $this->crud->addColumn('importo', [
            'label' => 'Importo',
            'type' => 'number',
            'prefix'        => '€ ',
            'suffix'        => ' EUR',
            'decimals'      => 2,
            'dec_point'     => ',',
            'thousands_sep' => '.',
        ]);

but the result is this:

I cleared the cache but nothing, it doesn't respect the formatting. What can I check?

[karandatwani92]

Hey @blondie63

I find your code working for me:

CRUD::column([
            'name' => 'total',
            'label' => 'Importo',
            'type' => 'number',
            'prefix'        => '€ ',
            'suffix'        => ' EUR',
            'decimals'      => 2,
            'dec_point'     => ',',
            'thousands_sep' => '.',
        ]);

The version I'm using:
backpack/crud: 6.5.2

Please re-check; I suspect there is something on your end.

[pxpm]

I think your column definition is wrong @blondie63

 $this->crud->addColumn([
            'name' => 'importo',
            'label' => 'Importo',
            'type' => 'number',
            'prefix'        => '€ ',
            'suffix'        => ' EUR',
            'decimals'      => 2,
            'dec_point'     => ',',
            'thousands_sep' => '.',
        ]);

Should work.

[blondie63]

Hi @pxpm what about right alignment ?

[pxpm]

Sorry @blondie63 , you should be able to align the column using css classes on the column wrapper.

[blondie63]

ok, but it could be a useful parameter to add as standard, what do you think?

[pxpm]

Sorry for the delay on response @blondie63

You mean something like: 'textAlign => 'right' in the column definition ? I think that's something that could be useful yes, but only if we can do it via column wrapper (we only need to change one file). If that requires changes in ALL columns, it may be more difficult to justify the effort for such small change.

Cheers

[blondie63]

ok anyway i've used column wrapper
Cheers