Bugzilla – Attachment 95431 Details for
Bug 23590
Add the ability to change the manager of a suggestion and notify the new manager
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23590: DBIC Changes
Bug-23590-DBIC-Changes.patch (text/plain), 3.57 KB, created by
Séverine Queune
on 2019-11-14 16:16:25 UTC
(
hide
)
Description:
Bug 23590: DBIC Changes
Filename:
MIME Type:
Creator:
Séverine Queune
Created:
2019-11-14 16:16:25 UTC
Size:
3.57 KB
patch
obsolete
>From b88a4ccd910d292a7a5ac31683f80dc24f022b37 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 14 Nov 2019 16:44:52 +0100 >Subject: [PATCH] Bug 23590: DBIC Changes >MIME-Version: 1.0 >Content-Type: text/plain; charset=UTF-8 >Content-Transfer-Encoding: 8bit > >Signed-off-by: Séverine QUEUNE <severine.queune@bulac.fr> >--- > Koha/Schema/Result/Borrower.pm | 19 +++++++++++++++++-- > Koha/Schema/Result/Suggestion.pm | 40 ++++++++++++++++++++++++++++++++++++++-- > 2 files changed, 55 insertions(+), 4 deletions(-) > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index f7224cc..a169f82 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -1459,6 +1459,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 suggestions_lastmodificationbies >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Suggestion> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "suggestions_lastmodificationbies", >+ "Koha::Schema::Result::Suggestion", >+ { "foreign.lastmodificationby" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 suggestions_managedbies > > Type: has_many >@@ -1635,8 +1650,8 @@ Composing rels: L</aqorder_users> -> ordernumber > __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-10 14:31:00 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GjJLIOViIFRm185Yjl9vYA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-11-14 15:44:37 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k/fQoZD8MLNdsPJXyhlXdw > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm >index 2086d98..f049f89 100644 >--- a/Koha/Schema/Result/Suggestion.pm >+++ b/Koha/Schema/Result/Suggestion.pm >@@ -77,6 +77,18 @@ __PACKAGE__->table("suggestions"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+=head2 lastmodificationby >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 lastmodificationdate >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ > =head2 STATUS > > accessor: 'status' >@@ -228,6 +240,10 @@ __PACKAGE__->add_columns( > { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > "rejecteddate", > { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "lastmodificationby", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "lastmodificationdate", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, > "STATUS", > { > accessor => "status", >@@ -379,6 +395,26 @@ __PACKAGE__->belongs_to( > }, > ); > >+=head2 lastmodificationby >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "lastmodificationby", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "lastmodificationby" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "CASCADE", >+ }, >+); >+ > =head2 managedby > > Type: belongs_to >@@ -440,8 +476,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-11 12:56:41 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UsG/gxLa0HMMbcpbscV29Q >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-11-14 15:44:38 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qZuiiZgd+ry97OSngYckSA > > > # You can replace this text with custom content, and it will be preserved on regeneration >-- >2.1.4
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 23590
:
95162
|
95163
|
95164
|
95165
|
95166
|
95167
|
95168
|
95169
|
95317
|
95318
|
95319
|
95320
|
95321
|
95322
|
95323
|
95324
|
95398
|
95399
|
95407
|
95408
|
95420
|
95421
|
95422
|
95423
|
95424
|
95425
|
95426
|
95427
|
95428
|
95429
|
95430
|
95431
|
95487
|
95488
|
95489
|
95490
|
95491
|
95492
|
95493
|
95494
|
95495
|
95496
|
95497
|
95498
|
98119
|
98120
|
98121
|
98122
|
98123
|
98124
|
98126
|
98127
|
98128
|
98129
|
98130
|
98131
|
98240
|
98267
|
98268
|
98279
|
100788
|
100789
|
100790
|
100791
|
100792
|
100793
|
100794
|
100795
|
100796
|
100797
|
100798
|
100799
|
100800
|
100801
|
100802
|
100803
|
100804
|
100846
|
100847
|
100848
|
100849
|
100850
|
100851
|
100852
|
100853
|
101539
|
101548
|
101588
|
101589
|
101590
|
101591
|
101592
|
101593
|
101594
|
101595
|
101596
|
101597
|
101598
|
101599
|
101600
|
101601
|
101602
|
101603
|
101604
|
101605
|
101606
|
101695