Attachment #141441 for bug #31028

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




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

=head2 catalog_concerns

Type: has_many

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

=cut

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

=head2 club_holds

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-08-16 12:51:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fN4HjHPivAcycZICptbfmg

__PACKAGE__->has_many(
  "biblioitem",




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

=head2 catalog_concerns_reporters

Type: has_many

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

=cut

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

=head2 catalog_concerns_resolvers

Type: has_many

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

=cut

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

=head2 categorycode

Type: belongs_to




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

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

=head1 NAME

Koha::Schema::Result::CatalogConcern

=cut

use strict;
use warnings;

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

=head1 TABLE: C<catalog_concerns>

=cut

__PACKAGE__->table("catalog_concerns");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key

=head2 biblio_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

id of biblio record the report concerns

=head2 reporter_id

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

id of the patron who reported the concern

=head2 reported_date

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

date and time this concern was reported

=head2 message

  data_type: 'text'
  is_nullable: 0

concern message content

=head2 resolver_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

id of the user who resolved the concern

=head2 resolved_date

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date and time this concern was resolved

=head2 resolution_message

  data_type: 'text'
  is_nullable: 1

resolution message content

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "biblio_id",
  { data_type => "integer", is_foreign_key => 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,
  },
  "message",
  { 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,
  },
  "resolution_message",
  { data_type => "text", 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, 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",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-08-16 12:51:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6J4cyyPvysbR2ZBd7o1hyw


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

Return to bug 31028

Lines 255-260 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
255	{ cascade_copy => 0, cascade_delete => 0 },	255	{ cascade_copy => 0, cascade_delete => 0 },
256	);	256	);
257		257
		258	=head2 catalog_concerns
		259
		260	Type: has_many
		261
		262	Related object: L<Koha::Schema::Result::CatalogConcern>
		263
		264	=cut
		265
		266	__PACKAGE__->has_many(
		267	"catalog_concerns",
		268	"Koha::Schema::Result::CatalogConcern",
		269	{ "foreign.biblio_id" => "self.biblionumber" },
		270	{ cascade_copy => 0, cascade_delete => 0 },
		271	);
		272
258	=head2 club_holds	273	=head2 club_holds
259		274
260	Type: has_many	275	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-08-16 12:51:38
560	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QmW8BVyUx2F2MAp6ZG45mg	575	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fN4HjHPivAcycZICptbfmg
561		576
562	__PACKAGE__->has_many(	577	__PACKAGE__->has_many(
563	"biblioitem",	578	"biblioitem",

Lines 1177-1182 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (+30 lines)
1177	{ cascade_copy => 0, cascade_delete => 0 },	1177	{ cascade_copy => 0, cascade_delete => 0 },
1178	);	1178	);
1179		1179
		1180	=head2 catalog_concerns_reporters
		1181
		1182	Type: has_many
		1183
		1184	Related object: L<Koha::Schema::Result::CatalogConcern>
		1185
		1186	=cut
		1187
		1188	__PACKAGE__->has_many(
		1189	"catalog_concerns_reporters",
		1190	"Koha::Schema::Result::CatalogConcern",
		1191	{ "foreign.reporter_id" => "self.borrowernumber" },
		1192	{ cascade_copy => 0, cascade_delete => 0 },
		1193	);
		1194
		1195	=head2 catalog_concerns_resolvers
		1196
		1197	Type: has_many
		1198
		1199	Related object: L<Koha::Schema::Result::CatalogConcern>
		1200
		1201	=cut
		1202
		1203	__PACKAGE__->has_many(
		1204	"catalog_concerns_resolvers",
		1205	"Koha::Schema::Result::CatalogConcern",
		1206	{ "foreign.resolver_id" => "self.borrowernumber" },
		1207	{ cascade_copy => 0, cascade_delete => 0 },
		1208	);
		1209
1180	=head2 categorycode	1210	=head2 categorycode
1181		1211
1182	Type: belongs_to	1212	Type: belongs_to

Line 0 Link Here

(-)a/Koha/Schema/Result/CatalogConcern.pm (-1 / +195 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::CatalogConcern;
		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::CatalogConcern
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<catalog_concerns>
		19
		20	=cut
		21
		22	__PACKAGE__->table("catalog_concerns");
		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 biblio_id
		35
		36	data_type: 'integer'
		37	is_foreign_key: 1
		38	is_nullable: 0
		39
		40	id of biblio record the report concerns
		41
		42	=head2 reporter_id
		43
		44	data_type: 'integer'
		45	default_value: 0
		46	is_foreign_key: 1
		47	is_nullable: 0
		48
		49	id of the patron who reported the concern
		50
		51	=head2 reported_date
		52
		53	data_type: 'timestamp'
		54	datetime_undef_if_invalid: 1
		55	default_value: current_timestamp
		56	is_nullable: 0
		57
		58	date and time this concern was reported
		59
		60	=head2 message
		61
		62	data_type: 'text'
		63	is_nullable: 0
		64
		65	concern message content
66
67	=head2 resolver_id
68
69	data_type: 'integer'
70	is_foreign_key: 1
71	is_nullable: 1
72
73	id of the user who resolved the concern
74
75	=head2 resolved_date
76
77	data_type: 'datetime'
78	datetime_undef_if_invalid: 1
79	is_nullable: 1
80
81	date and time this concern was resolved
82
83	=head2 resolution_message
84
85	data_type: 'text'
86	is_nullable: 1
87
88	resolution message content
89
90	=cut
91
92	__PACKAGE__->add_columns(
93	"id",
94	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
95	"biblio_id",
96	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
97	"reporter_id",
98	{
99	data_type => "integer",
100	default_value => 0,
101	is_foreign_key => 1,
102	is_nullable => 0,
103	},
104	"reported_date",
105	{
106	data_type => "timestamp",
107	datetime_undef_if_invalid => 1,
108	default_value => \"current_timestamp",
109	is_nullable => 0,
110	},
111	"message",
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	"resolution_message",
122	{ data_type => "text", 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	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
152	);
153
154	=head2 reporter
155
156	Type: belongs_to
157
158	Related object: L<Koha::Schema::Result::Borrower>
159
160	=cut
161
162	__PACKAGE__->belongs_to(
163	"reporter",
164	"Koha::Schema::Result::Borrower",
165	{ borrowernumber => "reporter_id" },
166	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
167	);
168
169	=head2 resolver
170
171	Type: belongs_to
172
173	Related object: L<Koha::Schema::Result::Borrower>
174
175	=cut
176
177	__PACKAGE__->belongs_to(
178	"resolver",
179	"Koha::Schema::Result::Borrower",
180	{ borrowernumber => "resolver_id" },
181	{
182	is_deferrable => 1,
183	join_type => "LEFT",
184	on_delete => "CASCADE",
185	on_update => "CASCADE",
186	},
187	);
188
189
190	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-08-16 12:51:38
191	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6J4cyyPvysbR2ZBd7o1hyw
192
193
194	# You can replace this text with custom code or comments, and it will be preserved on regeneration
195	1;