Attachment 158242 Details for Bug 35131 – Bug 35131: Add new system preference and DBRev

[patch] Bug 35131: Add new system preference and DBRev

Bug-35131-Add-new-system-preference-and-DBRev.patch (text/plain), 2.68 KB, created by Owen Leonard on 2023-11-02 11:00:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Owen Leonard

Created: 2023-11-02 11:00:45 UTC

Size: 2.68 KB

patch

obsolete

>From 583266102cdfa84503129aaf9330c0c0c8d492d4 Mon Sep 17 00:00:00 2001
>From: Lucas Gass <lucas@bywatersolutions.com>
>Date: Mon, 23 Oct 2023 15:15:55 +0000
>Subject: [PATCH] Bug 35131: Add new system preference and DBRev
>
>Signed-off-by: Owen Leonard <oleonard@myacpl.org>
>---
> installer/data/mysql/atomicupdate/bug_35131.pl | 15 +++++++++++++++
> installer/data/mysql/mandatory/sysprefs.sql    |  1 +
> 2 files changed, 16 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_35131.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_35131.pl b/installer/data/mysql/atomicupdate/bug_35131.pl
>new file mode 100755
>index 0000000000..729a54707d
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_35131.pl
>@@ -0,0 +1,15 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => 35131,
>+    description => "Add preference ShowBarcodeOnPatronRecord",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        $dbh->do(q{
>+INSERT IGNORE INTO systempreferences (`variable`, `value`, `options`, `explanation`, `type` ) VALUES
>+('ShowBarcodeOnPatronRecord', '0', '|0|Code39|COOP2of5|EAN13|EAN8|IATA2of5|Industrial2of5|ITF|Matrix2of5|NW7|QRcode|UPCA|UPCE', 'Show a patron carnumber as a barcode on the patron record ', 'Choice')
>+        });
>+        say $out "Added new system preference 'ShowBarcodeOnPatronRecord'";
>+    },
>+};
>diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql
>index 50ab4e1521..93ca31bf5a 100644
>--- a/installer/data/mysql/mandatory/sysprefs.sql
>+++ b/installer/data/mysql/mandatory/sysprefs.sql
>@@ -685,6 +685,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('MaxComponentRecords', '300', '','Max number of component records to display','Integer'),
> ('ShowHeadingUse', '0', NULL, 'Show whether authority record contains an established heading that conforms to descriptive cataloguing rules, and can therefore be used as a main/added entry, or subject, or series title', 'YesNo'),
> ('showLastPatron','0','','If ON, enables the last patron feature in the intranet','YesNo'),
>+('ShowBarcodeOnPatronRecord','|0|Code39|COOP2of5|EAN13|EAN8|IATA2of5|Industrial2of5|ITF|Matrix2of5|NW7|QRcode|UPCA|UPCE','0','Show a patron\'s carnumber as a barcode on the patron record','Choice'),
> ('showLastPatronCount', '10', '', 'How many patrons should showLastPatron remember', 'Integer'),
> ('ShowPatronImageInWebBasedSelfCheck','0','','If ON, displays patron image when a patron uses web-based self-checkout','YesNo'),
> ('ShowReviewer','full','none|full|first|surname|firstandinitial|username','Choose how a commenter\'s identity is presented alongside comments in the OPAC','Choice'),
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 35131: 157674 | 157675 | 157676 | 157936 | 158242 | 158243 | 158244 | 159459 | 159460 | 159461 | 159462