From 4723bfc7d2b8a1a406e3f13dc356b679a91607e4 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 Signed-off-by: Rebecca Coert Signed-off-by: Emily Lamancusa --- .../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 0000000000..e7bb87df63 --- /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 682b9fb950..0cd7bfc333 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