From a08362d5ab20a995eb859692bd6bae1e3e4c9118 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 Signed-off-by: Emily Lamancusa Signed-off-by: Katrin Fischer --- 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 0000000000..9d9b1bd9c4 --- /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 a5b6407304..bab297d872 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.39.5