From 9dbd302f76568b8f5f967e80c570f2a4a4b3818c Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Fri, 26 Jan 2024 18:42:14 +0000 Subject: [PATCH] Bug 23208: Add system preference HoldRatioDefault --- installer/data/mysql/atomicupdate/bug_23208.pl | 16 ++++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 17 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_23208.pl diff --git a/installer/data/mysql/atomicupdate/bug_23208.pl b/installer/data/mysql/atomicupdate/bug_23208.pl new file mode 100755 index 0000000000..3422607160 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_23208.pl @@ -0,0 +1,16 @@ +use Modern::Perl; + +return { + bug_number => "23208", + description => "Add system preference HoldRatioDefault", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + # Do you stuffs here + $dbh->do(q{ + INSERT IGNORE INTO systempreferences (`variable`,`value`,`options`,`explanation`,`type`) + VALUES ('HoldRatioDefault','3','','Default value for the Hold ratio report','Integer') + }); + }, +}; + diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index 7295744c4c..0658e163b0 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -284,6 +284,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('HidePatronName','0','','If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'), ('hide_marc','0',NULL,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'), ('HoldFeeMode','not_always','any_time_is_placed|not_always|any_time_is_collected','Set the hold fee mode','Choice'), +('HoldRatioDefault','3','','Default value for the hold ratio reprt','Integer'), ('HoldsAutoFill','0',NULL,'If on, librarian will not be asked if hold should be filled, it will be filled automatically','YesNo'), ('HoldsAutoFillPrintSlip','0',NULL,'If on, hold slip print dialog will be displayed automatically','YesNo'), ('HoldsLog','0',NULL,'If ON, log create/cancel/suspend/resume actions on holds.','YesNo'), -- 2.30.2