Feature #5423

Decimal separator for a Currency custom field

Added by blerohellec almost 7 years ago.

Status:NewStart date:07/20/2015
Priority:NormalDue date:
Assignee:-% Done:


Target version:-


v1.7 for GLPI 0.85

If I enter a custom field, typed Currency, with a comma (,) as decimal separator, I get an Sql error (extract hereafter).
It would be nice to manage the translation of the decimal separator to the correct value (a dot .) before insert into the db, just like it is done for amounts entered in the 'financial and admin information' tab.

SQL: UPDATE `glpi_plugin_customfields_monitors`
SET `typecurrency` = \'4,13\' WHERE `id` =\'1\'
Error: Incorrect decimal value: '4,13' for column 'typecurrency' at row 1
Backtrace :
inc/commondbtm.class.php:1108 CommonDBTM->updateInDB()
plugins/customfields/front/field.form.php:49 CommonDBTM->update()

Also available in: Atom PDF