Problem with decimal format (EUR) (,)

Hello im using this mask function to format the input field to give me the exact format how i want it.

       TextInput::make('final_price')
                        ->label('Uiteindelijke kosten (excl. btw)')
                        ->numeric()                      
                        ->mask(fn(Forms\Components\TextInput\Mask $mask) => $mask
                        ->patternBlocks([
                            'money' => fn (Mask $mask) => $mask
                                ->numeric()
                                ->thousandsSeparator('.')
                                ->decimalSeparator(',')
                                ->decimalPlaces(2)
                                ->padFractionalZeros()
                                ->normalizeZeros(false),
                        ])
                        ->pattern("€ money")

       TextInput::make('final_price')
                        ->label('Uiteindelijke kosten (excl. btw)')
                        ->numeric()                      
                        ->mask(fn(Forms\Components\TextInput\Mask $mask) => $mask
                        ->patternBlocks([
                            'money' => fn (Mask $mask) => $mask
                                ->numeric()
                                ->thousandsSeparator('.')
                                ->decimalSeparator(',')
                                ->decimalPlaces(2)
                                ->padFractionalZeros()
                                ->normalizeZeros(false),
                        ])
                        ->pattern("€ money")

this is working fine, but the problem is when i save it.
The database has a decimal field.

if i save the field [1st picture]
1500

and the 2nd picture is after i saved it
150.000

I know this has to do with the formatting but i couldnt found a way to fix this, can anyone help me.

Solution

 protected function MaximumPriceExcVat(): Attribute
    {
        return Attribute::make(
            get: fn ($value) => price($value,2),
        );
    }

 protected function MaximumPriceExcVat(): Attribute
    {
        return Attribute::make(
            get: fn ($value) => price($value,2),
        );
    }

Jump to solution

Filament•3y ago•

27 replies

Zakhaev

Problem with decimal format (EUR) (,)

Hello im using this mask function to format the input field to give me the exact format how i want it.

       TextInput::make('final_price')
                        ->label('Uiteindelijke kosten (excl. btw)')
                        ->numeric()                      
                        ->mask(fn(Forms\Components\TextInput\Mask $mask) => $mask
                        ->patternBlocks([
                            'money' => fn (Mask $mask) => $mask
                                ->numeric()
                                ->thousandsSeparator('.')
                                ->decimalSeparator(',')
                                ->decimalPlaces(2)
                                ->padFractionalZeros()
                                ->normalizeZeros(false),
                        ])
                        ->pattern("€ money")

       TextInput::make('final_price')
                        ->label('Uiteindelijke kosten (excl. btw)')
                        ->numeric()                      
                        ->mask(fn(Forms\Components\TextInput\Mask $mask) => $mask
                        ->patternBlocks([
                            'money' => fn (Mask $mask) => $mask
                                ->numeric()
                                ->thousandsSeparator('.')
                                ->decimalSeparator(',')
                                ->decimalPlaces(2)
                                ->padFractionalZeros()
                                ->normalizeZeros(false),
                        ])
                        ->pattern("€ money")

Solution

 protected function MaximumPriceExcVat(): Attribute
    {
        return Attribute::make(
            get: fn ($value) => price($value,2),
        );
    }

 protected function MaximumPriceExcVat(): Attribute
    {
        return Attribute::make(
            get: fn ($value) => price($value,2),
        );
    }

Jump to solution

Problem with decimal format (EUR) (,)

Problem with decimal format (EUR) (,)

Similar Threads

Similar Threads

Similar Threads