Attachment #165667 for bug #35657

View | Details | Raw Unified | Return to bug 35657
Collapse All | Expand All




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 ticket_updates_assignees

Type: has_many

Related object: L<Koha::Schema::Result::TicketUpdate>

=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<Koha::Schema::Result::Ticket>

=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

__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");


# 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",

Lines 80-85 ticket details Link Here

(-)a/Koha/Schema/Result/Ticket.pm (-2 / +32 lines)
80		80
81	current status of the ticket	81	current status of the ticket
82		82
		83	=head2 assignee_id
		84
		85	data_type: 'integer'
		86	is_foreign_key: 1
		87	is_nullable: 1
		88
		89	id of the user who this ticket is assigned to
		90
83	=head2 resolver_id	91	=head2 resolver_id
84		92
85	data_type: 'integer'	93	data_type: 'integer'
Lines 136-141 __PACKAGE__->add_columns( Link Here
136	{ data_type => "text", is_nullable => 0 },	144	{ data_type => "text", is_nullable => 0 },
137	"status",	145	"status",
138	{ data_type => "varchar", is_nullable => 1, size => 80 },	146	{ data_type => "varchar", is_nullable => 1, size => 80 },
		147	"assignee_id",
		148	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
139	"resolver_id",	149	"resolver_id",
140	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	150	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
141	"resolved_date",	151	"resolved_date",
Lines 162-167 __PACKAGE__->set_primary_key("id"); Link Here
162		172
163	=head1 RELATIONS	173	=head1 RELATIONS
164		174
		175	=head2 assignee
		176
		177	Type: belongs_to
		178
		179	Related object: L<Koha::Schema::Result::Borrower>
		180
		181	=cut
		182
		183	__PACKAGE__->belongs_to(
		184	"assignee",
		185	"Koha::Schema::Result::Borrower",
		186	{ borrowernumber => "assignee_id" },
		187	{
		188	is_deferrable => 1,
		189	join_type => "LEFT",
		190	on_delete => "CASCADE",
		191	on_update => "CASCADE",
		192	},
		193	);
		194
165	=head2 biblio	195	=head2 biblio
166		196
167	Type: belongs_to	197	Type: belongs_to
Lines 233-240 __PACKAGE__->has_many( Link Here
233	);	263	);
234		264
235		265
236	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-22 14:51:40	266	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
237	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lcKWaA+k/0lw5/6JrFhB1A	267	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CluP2ZCuByEcC3E0tLoOkA
238		268
239		269
240	# You can replace this text with custom code or comments, and it will be preserved on regeneration	270	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 48-53 id of catalog ticket the update relates to Link Here

(-)a/Koha/Schema/Result/TicketUpdate.pm (-3 / +32 lines)
48		48
49	id of the user who logged the update	49	id of the user who logged the update
50		50
		51	=head2 assignee_id
		52
		53	data_type: 'integer'
		54	is_foreign_key: 1
		55	is_nullable: 1
		56
		57	id of the user who this ticket was assigned to at this update
		58
51	=head2 public	59	=head2 public
52		60
53	data_type: 'tinyint'	61	data_type: 'tinyint'
Lines 94-99 __PACKAGE__->add_columns( Link Here
94	is_foreign_key => 1,	102	is_foreign_key => 1,
95	is_nullable => 0,	103	is_nullable => 0,
96	},	104	},
		105	"assignee_id",
		106	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
97	"public",	107	"public",
98	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	108	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
99	"date",	109	"date",
Lines 123-128 __PACKAGE__->set_primary_key("id"); Link Here
123		133
124	=head1 RELATIONS	134	=head1 RELATIONS
125		135
		136	=head2 assignee
		137
		138	Type: belongs_to
		139
		140	Related object: L<Koha::Schema::Result::Borrower>
		141
		142	=cut
		143
		144	__PACKAGE__->belongs_to(
		145	"assignee",
		146	"Koha::Schema::Result::Borrower",
		147	{ borrowernumber => "assignee_id" },
		148	{
		149	is_deferrable => 1,
		150	join_type => "LEFT",
		151	on_delete => "CASCADE",
		152	on_update => "CASCADE",
		153	},
		154	);
		155
126	=head2 ticket	156	=head2 ticket
127		157
128	Type: belongs_to	158	Type: belongs_to
Lines 154-161 __PACKAGE__->belongs_to( Link Here
154	);	184	);
155		185
156		186
157	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-22 14:51:40	187	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
158	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5fRHoeJ8uIAnOmxll7BsnA	188	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rhHYbmjhy+D3+h4nu3TuPw
159		189
160	__PACKAGE__->add_columns( '+public' => { is_boolean => 1 }, );	190	__PACKAGE__->add_columns( '+public' => { is_boolean => 1 }, );
161		191
162	-

Return to bug 35657

Lines 2002-2007 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +32 lines)
2002	{ cascade_copy => 0, cascade_delete => 0 },	2002	{ cascade_copy => 0, cascade_delete => 0 },
2003	);	2003	);
2004		2004
		2005	=head2 ticket_updates_assignees
		2006
		2007	Type: has_many
		2008
		2009	Related object: L<Koha::Schema::Result::TicketUpdate>
		2010
		2011	=cut
		2012
		2013	__PACKAGE__->has_many(
		2014	"ticket_updates_assignees",
		2015	"Koha::Schema::Result::TicketUpdate",
		2016	{ "foreign.assignee_id" => "self.borrowernumber" },
		2017	{ cascade_copy => 0, cascade_delete => 0 },
		2018	);
		2019
		2020	=head2 tickets_assignees
		2021
		2022	Type: has_many
		2023
		2024	Related object: L<Koha::Schema::Result::Ticket>
		2025
		2026	=cut
		2027
		2028	__PACKAGE__->has_many(
		2029	"tickets_assignees",
		2030	"Koha::Schema::Result::Ticket",
		2031	{ "foreign.assignee_id" => "self.borrowernumber" },
		2032	{ cascade_copy => 0, cascade_delete => 0 },
		2033	);
		2034
2005	=head2 tickets_reporters	2035	=head2 tickets_reporters
2006		2036
2007	Type: has_many	2037	Type: has_many
Lines 2158-2165 Composing rels: L</user_permissions> -> permission Link Here
2158	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");	2188	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
2159		2189
2160		2190
2161	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06	2191	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
2162	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PcGXqEI1ULB+Uoclqfbxig	2192	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U1id9VAmZO9i6P+D97N0yA
2163		2193
2164	__PACKAGE__->has_many(	2194	__PACKAGE__->has_many(
2165	"restrictions",	2195	"restrictions",