From 49229bb6f727ac410d7601f572c2d90f4968c3f7 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Mon, 24 Feb 2025 20:32:47 +0000 Subject: [PATCH] Bug 38108: Add system preference AlwaysShowHoldingsTableFilters --- .../data/mysql/atomicupdate/bug_38108.pl | 21 +++++++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 22 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_38108.pl diff --git a/installer/data/mysql/atomicupdate/bug_38108.pl b/installer/data/mysql/atomicupdate/bug_38108.pl new file mode 100755 index 00000000000..e7bb87df630 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_38108.pl @@ -0,0 +1,21 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_success say_info); + +return { + bug_number => "38108", + description => "Add AlwaysShowHoldingsTableFilters system preference", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do( + q{ + INSERT IGNORE INTO systempreferences (`variable`,`value`,`options`,`explanation`,`type`) + VALUES ('AlwaysShowHoldingsTableFilters','0','','Option to always show filters when loading the holdings table','YesNo') + } + ); + + # sysprefs + say $out "Added new system preference 'AlwaysShowHoldingsTableFilters'"; + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 682b9fb950b..0cd7bfc333a 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -56,6 +56,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('AlternateHoldingsField','',NULL,'The MARC field/subfield that contains alternate holdings information for bibs taht do not have items attached (e.g. 852abchi for libraries converting from MARC Magician).','free'), ('AlternateHoldingsSeparator','',NULL,'The string to use to separate subfields in alternate holdings displays.','free'), ('AlwaysLoadCheckoutsTable','0','','Option to always load the checkout table','Yes/No'), +('AlwaysShowHoldingsTableFilters','0','','Option to always show filters when loading the holdings table','Yes/No'), ('AmazonAssocTag','','','See: http://aws.amazon.com','free'), ('AmazonCoverImages','0','','Display Cover Images in staff interface from Amazon Web Services','YesNo'), ('AmazonLocale','US','US|CA|DE|FR|IN|JP|UK','Use to set the Locale of your Amazon.com Web Services','Choice'), -- 2.39.5