From cdfcb527f9a768dd2e6f35a639d66e21e5aea081 Mon Sep 17 00:00:00 2001
From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Date: Thu, 24 Oct 2024 14:00:15 +0000
Subject: [PATCH] Bug 38256: DBIC files

(cherry picked from commit c3ce31be20b5e593b4793eb500ae1183d9773e8b)
---
 Koha/Schema/Result/Aqbookseller.pm         | 15 ++++++++++
 Koha/Schema/Result/ErmUsageDataProvider.pm | 34 ++++++++++++++++++++--
 2 files changed, 47 insertions(+), 2 deletions(-)

diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm
index 8b52c7b92c8..4ee68a1f931 100644
--- a/Koha/Schema/Result/Aqbookseller.pm
+++ b/Koha/Schema/Result/Aqbookseller.pm
@@ -474,6 +474,21 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 erm_usage_data_providers
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::ErmUsageDataProvider>
+
+=cut
+
+__PACKAGE__->has_many(
+  "erm_usage_data_providers",
+  "Koha::Schema::Result::ErmUsageDataProvider",
+  { "foreign.vendor_id" => "self.id" },
+  { cascade_copy => 0, cascade_delete => 0 },
+);
+
 =head2 invoiceprice
 
 Type: belongs_to
diff --git a/Koha/Schema/Result/ErmUsageDataProvider.pm b/Koha/Schema/Result/ErmUsageDataProvider.pm
index 6ab2ce6f410..e4351a50238 100644
--- a/Koha/Schema/Result/ErmUsageDataProvider.pm
+++ b/Koha/Schema/Result/ErmUsageDataProvider.pm
@@ -150,6 +150,14 @@ report types provided by the harvester
 
 platform if provider requires it
 
+=head2 vendor_id
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
+foreign key to aqbooksellers
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -185,6 +193,8 @@ __PACKAGE__->add_columns(
   { data_type => "varchar", is_nullable => 1, size => 255 },
   "service_platform",
   { data_type => "varchar", is_nullable => 1, size => 80 },
+  "vendor_id",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 );
 
 =head1 PRIMARY KEY
@@ -337,9 +347,29 @@ __PACKAGE__->has_many(
   { cascade_copy => 0, cascade_delete => 0 },
 );
 
+=head2 vendor
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::Aqbookseller>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "vendor",
+  "Koha::Schema::Result::Aqbookseller",
+  { id => "vendor_id" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "SET NULL",
+    on_update     => "CASCADE",
+  },
+);
+
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-09-27 15:57:24
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YyiiRHSl3tJTzuLsoy9oPw
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-24 10:43:00
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A3fbITzckWWhFnS0Yeclpg
 
 # __PACKAGE__->add_columns(
 #     '+active' => { is_boolean => 1 }
-- 
2.39.3 (Apple Git-146)