From 7ec65c20fc45246f65a7f7babda88da227c11529 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 311c8f4f03f..4a50515ee3c 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -504,6 +504,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`),
@@ -4328,6 +4329,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.3 (Apple Git-146)