Notice ACQORDERS shows aqorders.listprice with six decimal places
Hi In database field "aqorders.listprice" is given with six decimal places, thus a price would look like: 40.100000 To beautify this we have added the following in notice ACQORDERS which removed the last four decimal places [% "<<aqorders.listprice>>" FILTER remove('\d{4}$') %] so the price would look like: 40.10 Since the update to Koha 24.05.01 this does not work anymore, instead it shows again: 40.100000 We have also tested the following regex (which should limit the decimal places to two), but to no avail: [% "<<aqorders.listprice>>" FILTER remove('^(\d+\.\d{2})\d+$') %] Is there a way to get rid of the unwanted decimal places in the notices of Koha 24.05? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Use the "Price" template plugin At the top of the template, add: [%- USE Price -%] Then: [% order.listprice | $Price %] Le ven. 20 sept. 2024 à 11:07, Michael Kuhn <mik@adminkuhn.ch> a écrit :
Hi
In database field "aqorders.listprice" is given with six decimal places, thus a price would look like: 40.100000
To beautify this we have added the following in notice ACQORDERS which removed the last four decimal places
[% "<<aqorders.listprice>>" FILTER remove('\d{4}$') %]
so the price would look like: 40.10
Since the update to Koha 24.05.01 this does not work anymore, instead it shows again: 40.100000
We have also tested the following regex (which should limit the decimal places to two), but to no avail:
[% "<<aqorders.listprice>>" FILTER remove('^(\d+\.\d{2})\d+$') %]
Is there a way to get rid of the unwanted decimal places in the notices of Koha 24.05?
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Jonathan Many thanks for the hint! I found more about this syntax and table references in https://wiki.koha-community.org/wiki/Notices_with_Template_Toolkit Now our ACQORDER notice lokks something like this: [%- USE Price -%] [% FOREACH order IN orders %] <p><b>Author:</b> [% order.biblio.abstract %]<br> <b>Title:</b> [% order.biblio.title %]<br> <b>Publisher:</b> <<biblioitems.publishercode>><br> <b>Year:</b> [% order.biblio.copyrightdate %]<br> <b>ISBN:</b> <<biblioitems.isbn>><br> <b>Price:</b> € [% order.listprice | $Price %] </p> [% END %] Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch Am 23.09.24 um 10:35 schrieb Jonathan Druart:
Use the "Price" template plugin
At the top of the template, add: [%- USE Price -%]
Then: [% order.listprice | $Price %]
Le ven. 20 sept. 2024 à 11:07, Michael Kuhn <mik@adminkuhn.ch> a écrit :
Hi
In database field "aqorders.listprice" is given with six decimal places, thus a price would look like: 40.100000
To beautify this we have added the following in notice ACQORDERS which removed the last four decimal places
[% "<<aqorders.listprice>>" FILTER remove('\d{4}$') %]
so the price would look like: 40.10
Since the update to Koha 24.05.01 this does not work anymore, instead it shows again: 40.100000
We have also tested the following regex (which should limit the decimal places to two), but to no avail:
[% "<<aqorders.listprice>>" FILTER remove('^(\d+\.\d{2})\d+$') %]
Is there a way to get rid of the unwanted decimal places in the notices of Koha 24.05?
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Jonathan Druart -
Michael Kuhn