From 062bae97b22074385ed247057c551eedb66abff5 Mon Sep 17 00:00:00 2001
From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Date: Tue, 29 Oct 2024 16:45:46 +0000
Subject: [PATCH] Bug 38290: Add a column for library group visibility

(cherry picked from commit a0a31abca79ae7c0e282211724eb995bd92e5b9b)
---
 .../bug_38290-add_library_group_filtering.pl  | 31 +++++++++++++++++++
 installer/data/mysql/kohastructure.sql        |  2 ++
 2 files changed, 33 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_38290-add_library_group_filtering.pl

diff --git a/installer/data/mysql/atomicupdate/bug_38290-add_library_group_filtering.pl b/installer/data/mysql/atomicupdate/bug_38290-add_library_group_filtering.pl
new file mode 100755
index 00000000000..8243e747344
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_38290-add_library_group_filtering.pl
@@ -0,0 +1,31 @@
+use Modern::Perl;
+use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
+
+return {
+    bug_number  => "38290",
+    description => "Add library group filtering",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        unless ( column_exists( 'aqbooksellers', 'lib_group_visibility' ) ) {
+            $dbh->do(
+                q{
+                    ALTER TABLE aqbooksellers
+                        ADD COLUMN `lib_group_visibility` varchar(255) NULL DEFAULT NULL
+                        COMMENT 'the library groups the vendor is visible to'
+                        AFTER language
+            }
+            );
+
+            say $out "Added new column 'aqbooksellers.lib_group_visibility'";
+        }
+
+        if ( !column_exists( 'library_groups', 'ft_acquisitions' ) ) {
+            $dbh->do(
+                "ALTER TABLE `library_groups` ADD COLUMN `ft_acquisitions` tinyint(1) NOT NULL DEFAULT 0 AFTER `ft_local_float_group`"
+            );
+        }
+
+    },
+};
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 1278addcae1..814ef8f97b5 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -503,6 +503,7 @@ CREATE TABLE `aqbooksellers` (
   `external_id` varchar(255) DEFAULT NULL COMMENT 'external id of the vendor',
   `payment_method` varchar(255) DEFAULT NULL COMMENT 'the payment method for the vendor',
   `language` varchar(255) DEFAULT NULL COMMENT 'the language for the vendor',
+  `lib_group_visibility` varchar(255) DEFAULT NULL COMMENT 'the library groups the vendor is visible to',
   PRIMARY KEY (`id`),
   KEY `listprice` (`listprice`),
   KEY `invoiceprice` (`invoiceprice`),
@@ -4366,6 +4367,7 @@ CREATE TABLE `library_groups` (
   `ft_search_groups_staff` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group for opac side search groups',
   `ft_local_hold_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as pick up location for holds',
   `ft_local_float_group` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group to identify libraries as part of float group',
+  `ft_acquisitions` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Use this group in the acquisitions module',
   `created_on` timestamp NULL DEFAULT NULL COMMENT 'Date and time of creation',
   `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date and time of last',
   PRIMARY KEY (`id`),
-- 
2.39.5 (Apple Git-154)