From aea90223d6f250d6f74e00244abbb3e0334107b5 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Thu, 28 Dec 2017 15:11:11 +0000 Subject: [PATCH] Bug 18736: Add OrderPriceRounding syspref Signed-off-by: Julian Maurice Signed-off-by: Marcel de Rooy Signed-off-by: Nick Clemens --- .../atomicupdate/bug18736_add_rounding_syspref.perl | 7 +++++++ installer/data/mysql/sysprefs.sql | 1 + .../prog/en/modules/admin/preferences/acquisitions.pref | 9 ++++++++- 3 files changed, 16 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug18736_add_rounding_syspref.perl diff --git a/installer/data/mysql/atomicupdate/bug18736_add_rounding_syspref.perl b/installer/data/mysql/atomicupdate/bug18736_add_rounding_syspref.perl new file mode 100644 index 0000000000..0f3c77f026 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug18736_add_rounding_syspref.perl @@ -0,0 +1,7 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # $dbh->do( "INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('OrderPriceRounding',NULL,'Local preference for rounding orders before calculations to ensure correct calculations','|nearest_cent','Choice')" ); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 18736 - Add syspref to control order rounding)\n"; +} diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index ca5256dc00..0b1a9c1cf7 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -433,6 +433,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('OpenLibraryCovers','0',NULL,'If ON Openlibrary book covers will be show','YesNo'), ('OpenLibrarySearch','0',NULL,'If Yes Open Library search results will show in OPAC','YesNo'), ('OrderPdfFormat','pdfformat::layout3pages','Controls what script is used for printing (basketgroups)','','free'), +('OrderPriceRounding','','|nearest_cent','Local preference for rounding orders before calculations to ensure correct calculations','Choice'), ('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo'), ('OverDriveClientKey','','Client key for OverDrive integration','30','Free'), ('OverDriveClientSecret','','Client key for OverDrive integration','30','YesNo'), diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref index 81aaa5056d..8f9082a987 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/acquisitions.pref @@ -83,7 +83,14 @@ Acquisitions: - "days. Example: [30] Sets purgation of suggestions for those older than 30 days." - "
WARNING: Leave this field empty if you don't want to activate this automatic feature." - "
NOTE: This system preference requires the misc/cronjobs/purge_suggestions.pl cronjob. Ask your system administrator to schedule it." - + - + - pref: OrderPriceRounding + default: '' + choices: + '': Don't round + nearest_cent: Round + - to nearest cent.
+ - Determines whether full precision values or rounded values should be used in price calculations - - pref: UseACQFrameworkForBiblioRecords default: no -- 2.39.5