Trying to display Price with ',' decimal Seperation

[nordic-digit]

Hello,

I am trying to pass the price using the TextInput->mask method with the Repeater Component via a HasMany Relationship. Everything works fine when saving, but when I open the edit mask, the price is always displayed incorrectly. I am trying to use the German notation (, for decimal separation and . for thousand separation). Here is the following code:

Forms\Components\TextInput::make('price.price_c2h')
    ->columnSpan(6)
    ->mask(fn ($mask) => $mask->patternBlocks([
        'money' => fn (Mask $mask) => $mask
            ->numeric()
            ->decimalSeparator(',')
            ->mapToDecimalSeparator(['.'])
            ->decimalPlaces(2)
            ->padFractionalZeros()
    ])
        ->pattern('money')
    )
    ->suffix('€')

Saved in the database:
{"price_c2h":"234.34"}

Output in the form after reloading the mask:
23434,00

I would appreciate any help or guidance on how to resolve this issue. Thank you.

[pboivin]

Hi @nordic-digit, I'm not sure if this is related but I had a similar issue when I started using Laravel Money. Do you have any kind of special casts on this field on your model?

[nordic-digit]

I just cast the price json to an array

[nordic-digit]

I have found out that there is a general problem with the output when setting the decimal separator to a comma. As a test, I replaced the JSON with a decimal field and the problem is the same. It is stored correctly in the database, but the output is incorrect.

[nordic-digit]

nothing? Guess i'll open an issue if noone knows a workaround

[pboivin]

This is strange... I'm not able to reproduce this issue. Here's an example that works for me :

        return TextInput::make($name)
            ->label($label)
            ->numeric()
            ->mask(
                fn (TextInput\Mask $mask) => $mask
                    ->numeric()
                    ->decimalSeparator(',')
                    ->mapToDecimalSeparator(['.'])
                    ->decimalPlaces(2)
                    ->padFractionalZeros()
            )
            ->minValue(0)
            ->maxValue(5)
            ->suffix(' / 5')
            ->required();

I've also tried with ->patternBlocks() and ->pattern(). It seems to work. I'm using a double column type in the database.

[nordic-digit]

Maybe it's because i am using a Repeater which belongs to a HasMany relationship? I'll try it tomorrow without repeater and relationship.

[nordic-digit]

ok either way i still got the problem. one of my coworkers has the same. This is weird. I even copy paste your code but it didn't help

[andrewdwallo]

I have the same problem as well. Commas can't be used as the decimal separator. It pads two extra zeros to the end of the value unless the amount of cents is zero. So, for example, 70,00 Euros will work but not 70,25 Euros.

[pekka]

I have the same problem in a repeater (serving a JSON field) where I'm showing a text field with the following mask

 $item->mask(fn (TextInput\Mask $mask) => $mask
      ->patternBlocks([
        'money' => fn (Mask $mask) => $mask
            ->numeric()
            ->thousandsSeparator('.')
            ->decimalSeparator(',')
            ->mapToDecimalSeparator(['.'])
            ->decimalPlaces(2)
            ->padFractionalZeros()
            ->normalizeZeros(false)
          ,
    ])->pattern('money'));

The price from this JSON

[{"type": "2", "price": "222.55", "status": "ACTIVE", "period_end": null, "period_start": null, "rebate_group": "23", "special_offer": null}]

is rendered thus:

[BillyBouman-2B-IT]

The following comes close to what is to be expected:

Forms\Components\TextInput::make('amount')
    ->label(\__('common.amount'))
    ->mask(fn (TextInput\Mask $mask) => $mask
        ->patternBlocks([
            'money' => fn (TextInput\Mask $mask) => $mask
                ->numeric()
                ->thousandsSeparator('.')
                ->decimalSeparator(','),
        ])
        ->pattern('€money')
    )
    ->required()
    ->numeric()
    ->afterStateHydrated(function (TextInput $component, $state) {
        $component->state(\str_replace('.', ',', $state));
    }),

Only part that isn't working correctly with above code is 123.00 which is being displayed as 123. All values that contain decimals are displayed as expected.

Notably is that the column version behaves perfectly:

\Filament\Tables\Columns\TextColumn::make('amount')
    ->label(\__('common.amount'))
    ->searchable()
    ->sortable()
    ->money('EUR'),

[pekka]

Fantastic, thank you!

[BillyBouman-2B-IT]

There is a problem with the code I supplied. Upon editing an existing record and saving without editing it says the value must be a number.

[BillyBouman-2B-IT]

The "must be a number" was caused by the following part which converted it to string, hence, must be a number:

->afterStateHydrated(function (TextInput $component, $state) {
    $component->state(\str_replace('.', ',', $state));
}),

The following works flawlessly at this moment:

Forms\Components\TextInput::make('amount')
    ->label(\__('common.amount'))
    ->required()
    ->prefix('€')
    ->numeric(),

[pekka]

Thank you! Will try this out and report back if any other issues arise.