[Koha-bugs] [Bug 33028] The decimal separator 'comma' and its consequences on the calculation of fines (crons)

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33028

--- Comment #25 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
To test:

* Set CurrencyFormat to FR
* Enable UseRecalls
* Administration > circulation and fine rules
* Add a new rule:
  * Fine amount: 0.10
  * Fine charging interval: 1  
  * Overdue fines cap: 1.50
  * Recall overdue fine amount: 1.10
* Save rule
* Verify that both Overdue fines cap and recall overdue fine amount show 
  formatted with comma as: 1,50, 1,10
* Edit rule
  * Fine amount: 0.10 - OK!
  * Fine charging interval: 1  
  * Overdue fines cap: 1,50 - NOT OK!
  * Recall overdue fine amount: 1,10 - NOT OK!
* Save rule
* With SQL:

select * from circulation_rules where rule_name in
("fine","overduefinescap","recall_overdue_fine");

+----+------------+--------------+----------+---------------------+------------+
| id | branchcode | categorycode | itemtype | rule_name           | rule_value
|
+----+------------+--------------+----------+---------------------+------------+
|  9 | NULL       | NULL         | NULL     | fine                | 0.10      
|
| 11 | NULL       | NULL         | NULL     | overduefinescap     | 1,50      
|
| 32 | NULL       | NULL         | NULL     | recall_overdue_fine | 1,10      
|
+----+------------+--------------+----------+---------------------+------------+

So the problem is, that you will save false values unnoticed that will cause
errors.

You cannot tell wrong and right values apart in the table, because all values
show formatted, if correct in the database or not.

-- 
You are receiving this mail because:
You are watching all bug changes.