Attachment 175779 Details for Bug 38290 – Bug 38290: Add a column for library group visibility

[patch] Bug 38290: Add a column for library group visibility

Bug-38290-Add-a-column-for-library-group-visibilit.patch (text/plain), 3.40 KB, created by Matt Blenkinsop on 2024-12-19 16:30:24 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Matt Blenkinsop

Created: 2024-12-19 16:30:24 UTC

Size: 3.40 KB

patch

obsolete

>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)

Actions: View | Diff | Splinter Review

Attachments on bug 38290: 175155 | 175156 | 175157 | 175158 | 175159 | 175160 | 175161 | 175779 | 175780 | 175781 | 175782 | 175783 | 175784 | 175785 | 175786 | 175787