Bugzilla – Attachment 129142 Details for
Bug 27946
Add a charge per article request to patron categories
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 27946: DBIC schema changes [DO NOT PUSH]
Bug-27946-DBIC-schema-changes-DO-NOT-PUSH.patch (text/plain), 3.18 KB, created by
Kyle M Hall (khall)
on 2022-01-07 12:14:31 UTC
(
hide
)
Description:
Bug 27946: DBIC schema changes [DO NOT PUSH]
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2022-01-07 12:14:31 UTC
Size:
3.18 KB
patch
obsolete
>From 4b90e60c730d92819f210dc64107beae277cfbf1 Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Mon, 8 Nov 2021 15:31:42 -0300 >Subject: [PATCH] Bug 27946: DBIC schema changes [DO NOT PUSH] > >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > Koha/Schema/Result/Accountline.pm | 19 ++++++++++++++-- > Koha/Schema/Result/ArticleRequest.pm | 34 ++++++++++++++++++++++++++-- > 2 files changed, 49 insertions(+), 4 deletions(-) > >diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm >index 47edfcf4e4b..7630f3d4a3b 100644 >--- a/Koha/Schema/Result/Accountline.pm >+++ b/Koha/Schema/Result/Accountline.pm >@@ -240,6 +240,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 article_requests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::ArticleRequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "article_requests", >+ "Koha::Schema::Result::ArticleRequest", >+ { "foreign.debit_id" => "self.accountlines_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 borrowernumber > > Type: belongs_to >@@ -381,8 +396,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MBdnk+5gD5TMX/ZOqEf3kA >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-10-27 16:31:24 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cdyoy7MLvk3m3mepmt0z0A > > =head2 library > >diff --git a/Koha/Schema/Result/ArticleRequest.pm b/Koha/Schema/Result/ArticleRequest.pm >index ee317ad34f9..d602f1c31cc 100644 >--- a/Koha/Schema/Result/ArticleRequest.pm >+++ b/Koha/Schema/Result/ArticleRequest.pm >@@ -126,6 +126,14 @@ __PACKAGE__->table("article_requests"); > > optional authorised value AR_CANCELLATION > >+=head2 debit_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+Debit line with cost for article scan request >+ > =head2 created_on > > data_type: 'timestamp' >@@ -200,6 +208,8 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "cancellation_reason", > { data_type => "varchar", is_nullable => 1, size => 80 }, >+ "debit_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "created_on", > { > data_type => "timestamp", >@@ -281,6 +291,26 @@ __PACKAGE__->belongs_to( > }, > ); > >+=head2 debit >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Accountline> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "debit", >+ "Koha::Schema::Result::Accountline", >+ { accountlines_id => "debit_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "CASCADE", >+ }, >+); >+ > =head2 itemnumber > > Type: belongs_to >@@ -302,8 +332,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-10-15 09:05:08 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U4C1bwfCj048twrT3yRD6Q >+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-10-27 16:31:24 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BXZSJpfb/iXZFpNK0JgUsg > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 27946
:
120144
|
120145
|
120146
|
120147
|
122522
|
122529
|
122530
|
122531
|
122532
|
122552
|
123503
|
123504
|
123505
|
123506
|
123507
|
128660
|
128661
|
128662
|
128663
|
128664
|
128665
|
128868
|
128869
|
128870
|
128871
|
128872
|
128873
|
129141
|
129142
|
129143
|
129144
|
129145
|
129146
|
129147
|
129171
|
129172
|
129173
|
129174
|
129175
|
129176
|
129177