From a6a9d3ad1bb113d24a18a66d3d4e255d9478b4f1 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 Signed-off-by: Andrew Fuerste Henry --- installer/data/mysql/atomicupdate/bug_23208.pl | 15 +++++++++++++++ installer/data/mysql/mandatory/sysprefs.sql | 1 + 2 files changed, 16 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 00000000000..9d9b1bd9c42 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_23208.pl @@ -0,0 +1,15 @@ +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 669074aa506..ec4abc7207a 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -288,6 +288,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'), ('HidePersonalPatronDetailOnCirculation', 0, '', 'Hide patrons phone number, email address, street address and city in the circulation page','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