From eeb81d97946848b99611ff2207b441e3b6c3f42d Mon Sep 17 00:00:00 2001
From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Date: Fri, 2 Jun 2023 08:39:19 +0000
Subject: [PATCH] Bug 34587: Add publisher and publisher_id to usage_titles
 schema and KohaTables

Signed-off-by: Jessica Zairo <jzairo@bywatersolutions.com>
Signed-off-by: Michaela Sieber <michaela.sieber@kit.edu>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 Koha/Schema/Result/ErmUsageTitle.pm           |  4 ++--
 .../ERM/UsageStatisticsReportBuilder.vue      | 20 +++++++++++++++++++
 .../ERM/UsageStatisticsTitlesList.vue         | 12 +++++++++++
 3 files changed, 34 insertions(+), 2 deletions(-)

diff --git a/Koha/Schema/Result/ErmUsageTitle.pm b/Koha/Schema/Result/ErmUsageTitle.pm
index f86750ba48..93fdb38f30 100644
--- a/Koha/Schema/Result/ErmUsageTitle.pm
+++ b/Koha/Schema/Result/ErmUsageTitle.pm
@@ -198,8 +198,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-08-02 16:27:18
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2ChttNyhXjVRUWg0nCfg8A
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-06-01 16:24:08
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Pd0jk01S8AGLjLWoLGWwZA
 
 
 sub koha_object_class {
diff --git a/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsReportBuilder.vue b/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsReportBuilder.vue
index cf1ffdf561..f930411289 100644
--- a/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsReportBuilder.vue
+++ b/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsReportBuilder.vue
@@ -340,6 +340,26 @@ export default {
                         orderable: true,
                     },
                 },
+                publisher: {
+                    name: "Publisher",
+                    active: false,
+                    column: {
+                        title: __("Publisher"),
+                        data: "publisher",
+                        searchable: true,
+                        orderable: true,
+                    },
+                },
+                publisher_id: {
+                    name: "Publisher ID",
+                    active: false,
+                    column: {
+                        title: __("Publisher ID"),
+                        data: "publisher_id",
+                        searchable: true,
+                        orderable: true,
+                    },
+                },
                 online_issn: {
                     name: "Online ISSN",
                     active: false,
diff --git a/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsTitlesList.vue b/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsTitlesList.vue
index c29c2ea2a3..0f2a8b3a1c 100644
--- a/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsTitlesList.vue
+++ b/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/UsageStatisticsTitlesList.vue
@@ -66,6 +66,18 @@ export default {
                     searchable: true,
                     orderable: true,
                 },
+                {
+                    title: __("Publisher"),
+                    data: "publisher",
+                    searchable: true,
+                    orderable: true,
+                },
+                {
+                    title: __("Publisher ID"),
+                    data: "publisher_id",
+                    searchable: true,
+                    orderable: true,
+                },
                 {
                     title: __("DOI"),
                     data: "title_doi",
-- 
2.39.5