From 24fc4c10cbb914fdcc096bc56b0c201b6a4016bb Mon Sep 17 00:00:00 2001 From: Matt Blenkinsop 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 | 50 ++++++++++++++++++++++ 2 files changed, 65 insertions(+) diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm index 15d360329b3..dc066a36327 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 + +=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 1de0fc7ab38..19bc7312362 100644 --- a/Koha/Schema/Result/ErmUsageDataProvider.pm +++ b/Koha/Schema/Result/ErmUsageDataProvider.pm @@ -147,6 +147,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( @@ -182,6 +190,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 @@ -334,6 +344,46 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 vendor + +Type: belongs_to + +Related object: L + +=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", + }, +); + +=head2 vendor + +Type: belongs_to + +Related object: L + +=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 @ 2025-04-24 17:38:40 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ToAsyGMN6zZW/ffmCqE8XA -- 2.48.1