From 41d24731981cd472b017cb8e867d9708b650d1fb Mon Sep 17 00:00:00 2001
From: Matthias Le Gac <matthias.le-gac@inlibro.com>
Date: Thu, 22 Feb 2024 15:33:25 -0500
Subject: [PATCH] Bug 35169: add bug_35169.pl for DB

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 .../data/mysql/atomicupdate/bug_35169.pl      | 23 +++++++++++++++++++
 .../admin/preferences/circulation.pref        |  1 -
 2 files changed, 23 insertions(+), 1 deletion(-)
 create mode 100755 installer/data/mysql/atomicupdate/bug_35169.pl

diff --git a/installer/data/mysql/atomicupdate/bug_35169.pl b/installer/data/mysql/atomicupdate/bug_35169.pl
new file mode 100755
index 0000000000..6ca2a0f294
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_35169.pl
@@ -0,0 +1,23 @@
+use Modern::Perl;
+
+return {
+    bug_number  => "35169",
+    description => "Add new system preferences for longoverdue.pl borrowers categories",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        # Do you stuffs here
+        $dbh->do(
+            q{
+            INSERT INTO systempreferences (variable, value, options, explanation, type) VALUES
+            ('DefaultLongOverdueBorrowerCategories', '', NULL, NULL, NULL),
+            ('DefaultLongOverdueSkipBorrowerCategories', '', NULL, NULL, NULL);
+        }
+        );
+
+        # sysprefs
+        say $out "Added new system preference 'DefaultLongOverdueBorrowerCategories'";
+        say $out "Added new system preference 'DefaultLongOverdueSkipBorrowerCategories'";
+    },
+};
\ No newline at end of file
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
index dbc2306bd2..c9b6e36593 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
@@ -459,7 +459,6 @@ Circulation:
             - <br>WARNING — This preference will be active only if DefaultLongOverdueSkipBorrowerCategories is empty.
             - "<br><strong>NOTE:</strong> This system preference requires the <code>misc/cronjobs/longoverdue.pl</code> cronjob. Ask your system administrator to schedule it."
 
-
         -
             - pref: DefaultLongOverdueSkipBorrowerCategories
               choices: patron-categories
-- 
2.20.1