From ca446288d861bbacfeb45d09f58cef8d07db5811 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 --- 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 669074aa50..ec4abc7207 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.34.1