From 2be3096c7ba12c7ccc51d3011b8319eeb0a281ed Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 29 Dec 2023 11:05:42 +0000 Subject: [PATCH] Bug 35657: Schema update Content-Type: text/plain; charset=utf-8 Signed-off-by: Paul Derscheid Signed-off-by: Marcel de Rooy --- Koha/Schema/Result/Borrower.pm | 34 ++++++++++++++++++++++++++++-- Koha/Schema/Result/Ticket.pm | 30 ++++++++++++++++++++++++++ Koha/Schema/Result/TicketUpdate.pm | 30 ++++++++++++++++++++++++++ 3 files changed, 92 insertions(+), 2 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 3657c03c32..1b1da2fdcc 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -2002,6 +2002,36 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 ticket_updates_assignees + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "ticket_updates_assignees", + "Koha::Schema::Result::TicketUpdate", + { "foreign.assignee_id" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 tickets_assignees + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "tickets_assignees", + "Koha::Schema::Result::Ticket", + { "foreign.assignee_id" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 tickets_reporters Type: has_many @@ -2158,8 +2188,8 @@ Composing rels: L -> permission __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PcGXqEI1ULB+Uoclqfbxig +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U1id9VAmZO9i6P+D97N0yA __PACKAGE__->has_many( "restrictions", diff --git a/Koha/Schema/Result/Ticket.pm b/Koha/Schema/Result/Ticket.pm index 949d1d0888..375099237b 100644 --- a/Koha/Schema/Result/Ticket.pm +++ b/Koha/Schema/Result/Ticket.pm @@ -80,6 +80,14 @@ ticket details current status of the ticket +=head2 assignee_id + + data_type: 'integer' + is_foreign_key: 1 + is_nullable: 1 + +id of the user who this ticket is assigned to + =head2 resolver_id data_type: 'integer' @@ -136,6 +144,8 @@ __PACKAGE__->add_columns( { data_type => "text", is_nullable => 0 }, "status", { data_type => "varchar", is_nullable => 1, size => 80 }, + "assignee_id", + { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "resolver_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "resolved_date", @@ -162,6 +172,26 @@ __PACKAGE__->set_primary_key("id"); =head1 RELATIONS +=head2 assignee + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "assignee", + "Koha::Schema::Result::Borrower", + { borrowernumber => "assignee_id" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "CASCADE", + on_update => "CASCADE", + }, +); + =head2 biblio Type: belongs_to diff --git a/Koha/Schema/Result/TicketUpdate.pm b/Koha/Schema/Result/TicketUpdate.pm index d987e6a628..9d99db80f8 100644 --- a/Koha/Schema/Result/TicketUpdate.pm +++ b/Koha/Schema/Result/TicketUpdate.pm @@ -48,6 +48,14 @@ id of catalog ticket the update relates to id of the user who logged the update +=head2 assignee_id + + data_type: 'integer' + is_foreign_key: 1 + is_nullable: 1 + +id of the user who this ticket was assigned to at this update + =head2 public data_type: 'tinyint' @@ -94,6 +102,8 @@ __PACKAGE__->add_columns( is_foreign_key => 1, is_nullable => 0, }, + "assignee_id", + { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "public", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "date", @@ -123,6 +133,26 @@ __PACKAGE__->set_primary_key("id"); =head1 RELATIONS +=head2 assignee + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "assignee", + "Koha::Schema::Result::Borrower", + { borrowernumber => "assignee_id" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "CASCADE", + on_update => "CASCADE", + }, +); + =head2 ticket Type: belongs_to -- 2.30.2