Attachment #142933 for bug #31028

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




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

=head2 tickets

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "tickets",
  "Koha::Schema::Result::Ticket",
  { "foreign.biblio_id" => "self.biblionumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 tmp_holdsqueues

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 21:15:33
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oP3RVSfCBrgu2MPMmZCrpw

__PACKAGE__->has_many(
  "biblioitem",




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

=head2 ticket_updates

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "ticket_updates",
  "Koha::Schema::Result::TicketUpdate",
  { "foreign.user_id" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 tickets_reporters

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "tickets_reporters",
  "Koha::Schema::Result::Ticket",
  { "foreign.reporter_id" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 tickets_resolvers

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "tickets_resolvers",
  "Koha::Schema::Result::Ticket",
  { "foreign.resolver_id" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 tmp_holdsqueues

Type: has_many

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


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 18:31:27
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:s2pNGPAHXoCtYrzH4TkXMw

__PACKAGE__->has_many(
  "extended_attributes",




use utf8;
package Koha::Schema::Result::Ticket;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::Ticket

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<tickets>

=cut

__PACKAGE__->table("tickets");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

=head2 reporter_id

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

id of the patron who reported the ticket

=head2 reported_date

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

date and time this ticket was reported

=head2 title

  data_type: 'text'
  is_nullable: 0

ticket title

=head2 body

  data_type: 'text'
  is_nullable: 0

ticket details

=head2 resolver_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of the user who resolved the ticket

=head2 resolved_date

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date and time this ticket was resolved

=head2 biblio_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of biblio linked

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "reporter_id",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "reported_date",
  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 0,
  },
  "title",
  { data_type => "text", is_nullable => 0 },
  "body",
  { data_type => "text", is_nullable => 0 },
  "resolver_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "resolved_date",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "biblio_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 biblio

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "biblio",
  "Koha::Schema::Result::Biblio",
  { biblionumber => "biblio_id" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 reporter

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "reporter",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "reporter_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 resolver

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "resolver",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "resolver_id" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 ticket_updates

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "ticket_updates",
  "Koha::Schema::Result::TicketUpdate",
  { "foreign.ticket_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 21:15:34
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Nm+y1BHJicrpeq3kuU1VA


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;




use utf8;
package Koha::Schema::Result::TicketUpdate;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::TicketUpdate

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<ticket_updates>

=cut

__PACKAGE__->table("ticket_updates");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

=head2 ticket_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

id of catalog ticket the update relates to

=head2 user_id

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

id of the user who logged the update

=head2 public

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

boolean flag to denote whether this update is public

=head2 date

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

date and time this update was logged

=head2 message

  data_type: 'text'
  is_nullable: 0

update message content

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "ticket_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "user_id",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "public",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "date",
  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 0,
  },
  "message",
  { data_type => "text", is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 ticket

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "ticket",
  "Koha::Schema::Result::Ticket",
  { id => "ticket_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 user

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "user",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "user_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 18:31:28
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8YG3jhlqbHWptc28pvBmrg


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;

Return to bug 31028

Lines 525-530 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
525	{ cascade_copy => 0, cascade_delete => 0 },	525	{ cascade_copy => 0, cascade_delete => 0 },
526	);	526	);
527		527
		528	=head2 tickets
		529
		530	Type: has_many
		531
		532	Related object: L<Koha::Schema::Result::Ticket>
		533
		534	=cut
		535
		536	__PACKAGE__->has_many(
		537	"tickets",
		538	"Koha::Schema::Result::Ticket",
		539	{ "foreign.biblio_id" => "self.biblionumber" },
		540	{ cascade_copy => 0, cascade_delete => 0 },
		541	);
		542
528	=head2 tmp_holdsqueues	543	=head2 tmp_holdsqueues
529		544
530	Type: has_many	545	Type: has_many
Lines 556-563 __PACKAGE__->has_many( Link Here
556	);	571	);
557		572
558		573
559	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-07-08 19:06:29	574	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 21:15:33
560	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QmW8BVyUx2F2MAp6ZG45mg	575	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oP3RVSfCBrgu2MPMmZCrpw
561		576
562	__PACKAGE__->has_many(	577	__PACKAGE__->has_many(
563	"biblioitem",	578	"biblioitem",

Lines 1902-1907 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +47 lines)
1902	{ cascade_copy => 0, cascade_delete => 0 },	1902	{ cascade_copy => 0, cascade_delete => 0 },
1903	);	1903	);
1904		1904
		1905	=head2 ticket_updates
		1906
		1907	Type: has_many
		1908
		1909	Related object: L<Koha::Schema::Result::TicketUpdate>
		1910
		1911	=cut
		1912
		1913	__PACKAGE__->has_many(
		1914	"ticket_updates",
		1915	"Koha::Schema::Result::TicketUpdate",
		1916	{ "foreign.user_id" => "self.borrowernumber" },
		1917	{ cascade_copy => 0, cascade_delete => 0 },
		1918	);
		1919
		1920	=head2 tickets_reporters
		1921
		1922	Type: has_many
		1923
		1924	Related object: L<Koha::Schema::Result::Ticket>
		1925
		1926	=cut
		1927
		1928	__PACKAGE__->has_many(
		1929	"tickets_reporters",
		1930	"Koha::Schema::Result::Ticket",
		1931	{ "foreign.reporter_id" => "self.borrowernumber" },
		1932	{ cascade_copy => 0, cascade_delete => 0 },
		1933	);
		1934
		1935	=head2 tickets_resolvers
		1936
		1937	Type: has_many
		1938
		1939	Related object: L<Koha::Schema::Result::Ticket>
		1940
		1941	=cut
		1942
		1943	__PACKAGE__->has_many(
		1944	"tickets_resolvers",
		1945	"Koha::Schema::Result::Ticket",
		1946	{ "foreign.resolver_id" => "self.borrowernumber" },
		1947	{ cascade_copy => 0, cascade_delete => 0 },
		1948	);
		1949
1905	=head2 tmp_holdsqueues	1950	=head2 tmp_holdsqueues
1906		1951
1907	Type: has_many	1952	Type: has_many
Lines 2028-2035 Composing rels: L</user_permissions> -> permission Link Here
2028	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");	2073	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
2029		2074
2030		2075
2031	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-03 18:03:21	2076	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 18:31:27
2032	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jqvQns/EYDe6ao4z32XKyg	2077	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:s2pNGPAHXoCtYrzH4TkXMw
2033		2078
2034	__PACKAGE__->has_many(	2079	__PACKAGE__->has_many(
2035	"extended_attributes",	2080	"extended_attributes",

Line 0 Link Here

(-)a/Koha/Schema/Result/TicketUpdate.pm (-1 / +152 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::TicketUpdate;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::TicketUpdate
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<ticket_updates>
		19
		20	=cut
		21
		22	__PACKAGE__->table("ticket_updates");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	primary key
		33
		34	=head2 ticket_id
		35
		36	data_type: 'integer'
		37	is_foreign_key: 1
		38	is_nullable: 0
		39
		40	id of catalog ticket the update relates to
		41
		42	=head2 user_id
		43
		44	data_type: 'integer'
		45	default_value: 0
		46	is_foreign_key: 1
		47	is_nullable: 0
		48
		49	id of the user who logged the update
		50
		51	=head2 public
		52
		53	data_type: 'tinyint'
		54	default_value: 0
		55	is_nullable: 0
		56
		57	boolean flag to denote whether this update is public
		58
		59	=head2 date
		60
		61	data_type: 'timestamp'
		62	datetime_undef_if_invalid: 1
		63	default_value: current_timestamp
		64	is_nullable: 0
		65
66	date and time this update was logged
67
68	=head2 message
69
70	data_type: 'text'
71	is_nullable: 0
72
73	update message content
74
75	=cut
76
77	__PACKAGE__->add_columns(
78	"id",
79	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
80	"ticket_id",
81	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
82	"user_id",
83	{
84	data_type => "integer",
85	default_value => 0,
86	is_foreign_key => 1,
87	is_nullable => 0,
88	},
89	"public",
90	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
91	"date",
92	{
93	data_type => "timestamp",
94	datetime_undef_if_invalid => 1,
95	default_value => \"current_timestamp",
96	is_nullable => 0,
97	},
98	"message",
99	{ data_type => "text", is_nullable => 0 },
100	);
101
102	=head1 PRIMARY KEY
103
104	=over 4
105
106	=item * L</id>
107
108	=back
109
110	=cut
111
112	__PACKAGE__->set_primary_key("id");
113
114	=head1 RELATIONS
115
116	=head2 ticket
117
118	Type: belongs_to
119
120	Related object: L<Koha::Schema::Result::Ticket>
121
122	=cut
123
124	__PACKAGE__->belongs_to(
125	"ticket",
126	"Koha::Schema::Result::Ticket",
127	{ id => "ticket_id" },
128	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
129	);
130
131	=head2 user
132
133	Type: belongs_to
134
135	Related object: L<Koha::Schema::Result::Borrower>
136
137	=cut
138
139	__PACKAGE__->belongs_to(
140	"user",
141	"Koha::Schema::Result::Borrower",
142	{ borrowernumber => "user_id" },
143	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
144	);
145
146
147	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 18:31:28
148	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8YG3jhlqbHWptc28pvBmrg
149
150
151	# You can replace this text with custom code or comments, and it will be preserved on regeneration
152	1;

Line 0 Link Here

(-)a/Koha/Schema/Result/Ticket.pm (+215 lines)
		1	use utf8;
		2	package Koha::Schema::Result::Ticket;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::Ticket
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<tickets>
		19
		20	=cut
		21
		22	__PACKAGE__->table("tickets");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	primary key
		33
		34	=head2 reporter_id
		35
		36	data_type: 'integer'
		37	default_value: 0
		38	is_foreign_key: 1
		39	is_nullable: 0
		40
		41	id of the patron who reported the ticket
		42
		43	=head2 reported_date
		44
		45	data_type: 'timestamp'
		46	datetime_undef_if_invalid: 1
		47	default_value: current_timestamp
		48	is_nullable: 0
		49
		50	date and time this ticket was reported
		51
		52	=head2 title
		53
		54	data_type: 'text'
		55	is_nullable: 0
		56
		57	ticket title
		58
		59	=head2 body
		60
		61	data_type: 'text'
		62	is_nullable: 0
		63
		64	ticket details
65
66	=head2 resolver_id
67
68	data_type: 'integer'
69	is_foreign_key: 1
70	is_nullable: 1
71
72	id of the user who resolved the ticket
73
74	=head2 resolved_date
75
76	data_type: 'datetime'
77	datetime_undef_if_invalid: 1
78	is_nullable: 1
79
80	date and time this ticket was resolved
81
82	=head2 biblio_id
83
84	data_type: 'integer'
85	is_foreign_key: 1
86	is_nullable: 1
87
88	id of biblio linked
89
90	=cut
91
92	__PACKAGE__->add_columns(
93	"id",
94	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
95	"reporter_id",
96	{
97	data_type => "integer",
98	default_value => 0,
99	is_foreign_key => 1,
100	is_nullable => 0,
101	},
102	"reported_date",
103	{
104	data_type => "timestamp",
105	datetime_undef_if_invalid => 1,
106	default_value => \"current_timestamp",
107	is_nullable => 0,
108	},
109	"title",
110	{ data_type => "text", is_nullable => 0 },
111	"body",
112	{ data_type => "text", is_nullable => 0 },
113	"resolver_id",
114	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
115	"resolved_date",
116	{
117	data_type => "datetime",
118	datetime_undef_if_invalid => 1,
119	is_nullable => 1,
120	},
121	"biblio_id",
122	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
123	);
124
125	=head1 PRIMARY KEY
126
127	=over 4
128
129	=item * L</id>
130
131	=back
132
133	=cut
134
135	__PACKAGE__->set_primary_key("id");
136
137	=head1 RELATIONS
138
139	=head2 biblio
140
141	Type: belongs_to
142
143	Related object: L<Koha::Schema::Result::Biblio>
144
145	=cut
146
147	__PACKAGE__->belongs_to(
148	"biblio",
149	"Koha::Schema::Result::Biblio",
150	{ biblionumber => "biblio_id" },
151	{
152	is_deferrable => 1,
153	join_type => "LEFT",
154	on_delete => "CASCADE",
155	on_update => "CASCADE",
156	},
157	);
158
159	=head2 reporter
160
161	Type: belongs_to
162
163	Related object: L<Koha::Schema::Result::Borrower>
164
165	=cut
166
167	__PACKAGE__->belongs_to(
168	"reporter",
169	"Koha::Schema::Result::Borrower",
170	{ borrowernumber => "reporter_id" },
171	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
172	);
173
174	=head2 resolver
175
176	Type: belongs_to
177
178	Related object: L<Koha::Schema::Result::Borrower>
179
180	=cut
181
182	__PACKAGE__->belongs_to(
183	"resolver",
184	"Koha::Schema::Result::Borrower",
185	{ borrowernumber => "resolver_id" },
186	{
187	is_deferrable => 1,
188	join_type => "LEFT",
189	on_delete => "CASCADE",
190	on_update => "CASCADE",
191	},
192	);
193
194	=head2 ticket_updates
195
196	Type: has_many
197
198	Related object: L<Koha::Schema::Result::TicketUpdate>
199
200	=cut
201
202	__PACKAGE__->has_many(
203	"ticket_updates",
204	"Koha::Schema::Result::TicketUpdate",
205	{ "foreign.ticket_id" => "self.id" },
206	{ cascade_copy => 0, cascade_delete => 0 },
207	);
208
209
210	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-24 21:15:34
211	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Nm+y1BHJicrpeq3kuU1VA
212
213
214	# You can replace this text with custom code or comments, and it will be preserved on regeneration
215	1;