From 4dfadba4bcb5df895e14acc945080f2315aeaa5b Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Tadeusz=20=E2=80=9Etadzik=E2=80=9D=20So=C5=9Bnierz?= Date: Wed, 11 Jun 2025 13:50:01 +0200 Subject: [PATCH] Bug 39610: Add SQL bits for ILLOpacMetadataFields Signed-off-by: Roman Dolny --- .../data/mysql/atomicupdate/bug_39610.pl | 20 +++++++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 21 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_39610.pl diff --git a/installer/data/mysql/atomicupdate/bug_39610.pl b/installer/data/mysql/atomicupdate/bug_39610.pl new file mode 100755 index 0000000000..b5e4e793fb --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_39610.pl @@ -0,0 +1,20 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_success); + +return { + bug_number => "39610", + description => "Add ILLOpacMetadataFields to systempreferences", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + $dbh->do( + q{ + INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES + ('ILLOpacMetadataFields','author|title',NULL,'Metadata fields to show in OPAC ILL table','multiple'); + } + ); + + say_success $out, "Added new system preference 'ILLOpacMetadataFields'"; + }, +}; diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 09b8afd6fd..220e178261 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -333,6 +333,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('ILLModuleDisclaimerByType','','','YAML defining disclaimer settings for each ILL request type','Textarea'), ('ILLModuleUnmediated','0','','If enabled, try to immediately progress newly placed ILL requests.','YesNo'), ('ILLOpacbackends',NULL,NULL,'ILL backends to enabled for OPAC initiated requests','multiple'), +('ILLOpacMetadataFields','author|title',NULL,'Metadata fields to show in OPAC ILL table','multiple'), ('ILLOpacUnauthenticatedRequest',NULL,NULL,'Can OPAC users place ILL requests without having to be logged in','YesNo'), ('ILLPartnerCode','IL','','Patrons from this patron category will be used as partners to place ILL requests with','free'), ('ILLRequestsTabs','','','Add customizable tabs to interlibrary loan requests list','Textarea'), -- 2.39.5