From ea47128e7898d01d14b975d59ee9a4a6a19ff130 Mon Sep 17 00:00:00 2001
From: Lucas Gass <lucas@bywatersolutions.com>
Date: Fri, 8 Mar 2024 21:04:53 +0000
Subject: [PATCH] Bug 15461: Add StaffLocationOnDetail system preference

---
 installer/data/mysql/atomicupdate/bug_15461.pl | 18 ++++++++++++++++++
 installer/data/mysql/mandatory/sysprefs.sql    |  1 +
 2 files changed, 19 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_15461.pl

diff --git a/installer/data/mysql/atomicupdate/bug_15461.pl b/installer/data/mysql/atomicupdate/bug_15461.pl
new file mode 100755
index 0000000000..d7ed32ee0c
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_15461.pl
@@ -0,0 +1,18 @@
+use Modern::Perl;
+
+return {
+    bug_number  => "15461",
+    description => "Add system preference StaffLocationOnDetail",
+    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 ('StaffLocationOnDetail','home','holding|home|both|column','In the staff interface, display the shelving location on its own column or under a library columns.','Choice')
+        });
+
+        say $out "Added new system preference 'StaffLocationOnDetail'";
+    },
+};
diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql
index 669074aa50..c312f56c84 100644
--- a/installer/data/mysql/mandatory/sysprefs.sql
+++ b/installer/data/mysql/mandatory/sysprefs.sql
@@ -722,6 +722,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
 ('StaffDetailItemSelection', '1', NULL, 'Enable item selection in record detail page', 'YesNo'),
 ('StaffHighlightedWords','1','','Highlight search terms on staff interface','YesNo'),
 ('StaffLangSelectorMode','footer','top|both|footer','Select the location to display the language selector in staff interface','Choice'),
+('StaffLocationOnDetail','home','holding|home|both|column','In the staff interface detail, display the shelving location on its own column or under a library columns.',  'Choice'),
 ('StaffLoginInstructions', '', NULL, 'HTML to go into the login box for the staff interface','Free'),
 ('StaffSearchResultsDisplayBranch','holdingbranch','holdingbranch|homebranch','Controls the display of the home or holding branch for staff search results','Choice'),
 ('StaffSerialIssueDisplayCount','3','','Number of serial issues to display per subscription in the staff interface','Integer'),
-- 
2.30.2