Bugzilla – Attachment 188569 Details for
Bug 40504
ILL requests should have ability to assign staff to manage
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 40504: dbic
Bug-40504-dbic.patch (text/plain), 3.14 KB, created by
Pedro Amorim
on 2025-10-29 16:22:25 UTC
(
hide
)
Description:
Bug 40504: dbic
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-10-29 16:22:25 UTC
Size:
3.14 KB
patch
obsolete
>From 201467f21bc44ce1b36e602c861f14af2de831dc Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@openfifth.co.uk> >Date: Wed, 15 Oct 2025 09:09:51 +0000 >Subject: [PATCH] Bug 40504: dbic > >Signed-off-by: Jeremy Evans <Jeremy.Evans@ukhsa.gov.uk> >--- > Koha/Schema/Result/Borrower.pm | 19 ++++++++++++++++-- > Koha/Schema/Result/Illrequest.pm | 34 ++++++++++++++++++++++++++++++-- > 2 files changed, 49 insertions(+), 4 deletions(-) > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 1e1fa11cd42..eac1cc91b2a 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -1496,6 +1496,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 illrequests_managedbies >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequests_managedbies", >+ "Koha::Schema::Result::Illrequest", >+ { "foreign.managedby" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 issues > > Type: has_many >@@ -2197,8 +2212,8 @@ Composing rels: L</user_permissions> -> permission > __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-07-10 07:11:31 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XFOe2X4k2DUziaNS5pWd/Q >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-14 15:51:05 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cELj/xwqMZyT5j6lIhGRQA > > __PACKAGE__->belongs_to( > "library", >diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm >index e7293afa597..8f6347ee04d 100644 >--- a/Koha/Schema/Result/Illrequest.pm >+++ b/Koha/Schema/Result/Illrequest.pm >@@ -40,6 +40,14 @@ ILL request number > > Patron associated with request > >+=head2 managedby >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+Staff member manager of request >+ > =head2 biblio_id > > data_type: 'integer' >@@ -202,6 +210,8 @@ __PACKAGE__->add_columns( > }, > "borrowernumber", > { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "managedby", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "biblio_id", > { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "deleted_biblio_id", >@@ -370,6 +380,26 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 managedby >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "managedby", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "managedby" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "CASCADE", >+ }, >+); >+ > =head2 status_alias > > Type: belongs_to >@@ -391,8 +421,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-03-07 16:59:58 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+LJD6O0ZLhsml2/43CSgBg >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-14 15:51:05 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qHLdWJzaN0G3l/MauUId8g > > __PACKAGE__->has_many( > "comments", >-- >2.39.5
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 40504
:
187906
|
187907
|
187908
|
187909
|
187910
|
187911
|
187912
|
187913
|
187914
|
187915
|
188365
|
188563
|
188565
|
188566
|
188567
|
188568
|
188569
|
188570
|
188571
|
188572
|
188573
|
188574
|
188624
|
188625
|
188935
|
188936