From 4633e0021c51017c92594f4049a1f2635caa2860 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Tue, 28 May 2019 14:47:35 +0000 Subject: [PATCH] Bug 22996: Add new preference BarcodeSeparators Content-Type: text/plain; charset=utf-8 Test plan: Run new install or upgrade. Check pref value. --- installer/data/mysql/atomicupdate/bug_22996.perl | 6 ++++++ installer/data/mysql/sysprefs.sql | 1 + .../intranet-tmpl/prog/en/modules/admin/preferences/tools.pref | 6 ++++++ 3 files changed, 13 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_22996.perl diff --git a/installer/data/mysql/atomicupdate/bug_22996.perl b/installer/data/mysql/atomicupdate/bug_22996.perl new file mode 100644 index 0000000000..c90d71b432 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_22996.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( q/INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES (?, ?, ?, ?, ?)/, undef, 'BarcodeSeparators','\s\r\n','','Splitting characters for barcodes','Free' ); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 22996 - Add pref BarcodeSeparators)\n"; +} diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index c8086043c9..3bb7f724ba 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -85,6 +85,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('BakerTaylorEnabled','0','','Enable or disable all Baker & Taylor features.','YesNo'), ('BakerTaylorPassword','','','Baker & Taylor Password for Content Cafe (external content)','Free'), ('BakerTaylorUsername','','','Baker & Taylor Username for Content Cafe (external content)','Free'), +('BarcodeSeparators','\\s\\r\\n','','Splitting characters for barcodes','Free'), ('BasketConfirmations','1','always ask for confirmation.|do not ask for confirmation.','When closing or reopening a basket,','Choice'), ('BatchCheckouts','0','','Enable or disable batch checkouts','YesNo'), ('BatchCheckoutsValidCategories','',NULL,'Patron categories allowed to checkout in a batch','Free'), diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/tools.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/tools.pref index 52dfd8509c..2e2356cd26 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/tools.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/tools.pref @@ -1,4 +1,10 @@ Tools: + Barcodes: + - + - Split barcodes on the following separator chars + - pref: BarcodeSeparators + default: '\s\r\n' + - "in batch item modification and inventory.
Note: Type \\r for carriage return, \\n for newline and \\s for whitespace. Possible candidates to include also are pipe char |, hyphen, comma, semicolon, dot, etc." Batch item: - - Process up to -- 2.11.0