Attachment #151517 for bug #30719

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




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

=head2 illbatches

Type: has_many

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

=cut

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

=head2 illcomments

Type: has_many

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


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RUWvcq9kgQvACo14H/u9jQ

__PACKAGE__->has_many(
  "restrictions",




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

=head2 illbatches

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "illbatches",
  "Koha::Schema::Result::Illbatch",
  { "foreign.branchcode" => "self.branchcode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 illrequests

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GGYhqyTVMmaFo9hAY4Jy5w

__PACKAGE__->add_columns(
    '+pickup_location' => { is_boolean => 1 },




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

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

=head1 NAME

Koha::Schema::Result::Illbatch

=cut

use strict;
use warnings;

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

=head1 TABLE: C<illbatches>

=cut

__PACKAGE__->table("illbatches");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 name

  data_type: 'varchar'
  is_nullable: 0
  size: 100

=head2 backend

  data_type: 'varchar'
  is_nullable: 0
  size: 20

=head2 borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 50

=head2 statuscode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 20

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "name",
  { data_type => "varchar", is_nullable => 0, size => 100 },
  "backend",
  { data_type => "varchar", is_nullable => 0, size => 20 },
  "borrowernumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "branchcode",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 50 },
  "statuscode",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 20 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 UNIQUE CONSTRAINTS

=head2 C<u_illbatches__name>

=over 4

=item * L</name>

=back

=cut

__PACKAGE__->add_unique_constraint("u_illbatches__name", ["name"]);

=head1 RELATIONS

=head2 borrowernumber

Type: belongs_to

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

=cut

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

=head2 branchcode

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "branchcode",
  "Koha::Schema::Result::Branch",
  { branchcode => "branchcode" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "CASCADE",
  },
);

=head2 illrequests

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "illrequests",
  "Koha::Schema::Result::Illrequest",
  { "foreign.batch_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 statuscode

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "statuscode",
  "Koha::Schema::Result::IllbatchStatus",
  { code => "statuscode" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:22
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j4UhTuwaQnwWhjSd9j35tg


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




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

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

=head1 NAME

Koha::Schema::Result::IllbatchStatus

=cut

use strict;
use warnings;

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

=head1 TABLE: C<illbatch_statuses>

=cut

__PACKAGE__->table("illbatch_statuses");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 name

  data_type: 'varchar'
  is_nullable: 0
  size: 100

=head2 code

  data_type: 'varchar'
  is_nullable: 0
  size: 20

=head2 is_system

  data_type: 'integer'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "name",
  { data_type => "varchar", is_nullable => 0, size => 100 },
  "code",
  { data_type => "varchar", is_nullable => 0, size => 20 },
  "is_system",
  { data_type => "integer", is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 UNIQUE CONSTRAINTS

=head2 C<u_illbatchstatuses__code>

=over 4

=item * L</code>

=back

=cut

__PACKAGE__->add_unique_constraint("u_illbatchstatuses__code", ["code"]);

=head1 RELATIONS

=head2 illbatches

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "illbatches",
  "Koha::Schema::Result::Illbatch",
  { "foreign.statuscode" => "self.code" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:22
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LUHcLxj5W4tParGOEkVCdg


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

Lines 175-180 Backend id attached to request Link Here

(-)a/Koha/Schema/Result/Illrequest.pm (-3 / +32 lines)
175		175
176	The backend used to create request	176	The backend used to create request
177		177
		178	=head2 batch_id
		179
		180	data_type: 'integer'
		181	is_foreign_key: 1
		182	is_nullable: 1
		183
		184	Optional ID of batch that this request belongs to
		185
178	=cut	186	=cut
179		187
180	__PACKAGE__->add_columns(	188	__PACKAGE__->add_columns(
Lines 230-235 __PACKAGE__->add_columns( Link Here
230	{ data_type => "varchar", is_nullable => 1, size => 50 },	238	{ data_type => "varchar", is_nullable => 1, size => 50 },
231	"backend",	239	"backend",
232	{ data_type => "varchar", is_nullable => 1, size => 20 },	240	{ data_type => "varchar", is_nullable => 1, size => 20 },
		241	"batch_id",
		242	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
233	);	243	);
234		244
235	=head1 PRIMARY KEY	245	=head1 PRIMARY KEY
Lines 246-251 __PACKAGE__->set_primary_key("illrequest_id"); Link Here
246		256
247	=head1 RELATIONS	257	=head1 RELATIONS
248		258
		259	=head2 batch
		260
		261	Type: belongs_to
		262
		263	Related object: L<Koha::Schema::Result::Illbatch>
		264
		265	=cut
		266
		267	__PACKAGE__->belongs_to(
		268	"batch",
		269	"Koha::Schema::Result::Illbatch",
		270	{ id => "batch_id" },
		271	{
		272	is_deferrable => 1,
		273	join_type => "LEFT",
		274	on_delete => "SET NULL",
		275	on_update => "CASCADE",
		276	},
		277	);
		278
249	=head2 biblio	279	=head2 biblio
250		280
251	Type: belongs_to	281	Type: belongs_to
Lines 352-359 __PACKAGE__->belongs_to( Link Here
352	);	382	);
353		383
354		384
355	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-05-05 12:10:10	385	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:22
356	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1VhNc8tMnvCpBYaj90YOiQ	386	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i7xURQ9tMmQfW7wg1lAaEA
357		387
358	__PACKAGE__->has_many(	388	__PACKAGE__->has_many(
359	"comments",	389	"comments",
360	-

Return to bug 30719

Lines 1402-1407 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +17 lines)
1402	{ cascade_copy => 0, cascade_delete => 0 },	1402	{ cascade_copy => 0, cascade_delete => 0 },
1403	);	1403	);
1404		1404
		1405	=head2 illbatches
		1406
		1407	Type: has_many
		1408
		1409	Related object: L<Koha::Schema::Result::Illbatch>
		1410
		1411	=cut
		1412
		1413	__PACKAGE__->has_many(
		1414	"illbatches",
		1415	"Koha::Schema::Result::Illbatch",
		1416	{ "foreign.borrowernumber" => "self.borrowernumber" },
		1417	{ cascade_copy => 0, cascade_delete => 0 },
		1418	);
		1419
1405	=head2 illcomments	1420	=head2 illcomments
1406		1421
1407	Type: has_many	1422	Type: has_many
Lines 2103-2110 Composing rels: L</user_permissions> -> permission Link Here
2103	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");	2118	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
2104		2119
2105		2120
2106	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-06 15:46:57	2121	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:21
2107	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f6omVb7EtiysdaWTX3IRzg	2122	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RUWvcq9kgQvACo14H/u9jQ
2108		2123
2109	__PACKAGE__->has_many(	2124	__PACKAGE__->has_many(
2110	"restrictions",	2125	"restrictions",

Lines 692-697 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
692	{ cascade_copy => 0, cascade_delete => 0 },	692	{ cascade_copy => 0, cascade_delete => 0 },
693	);	693	);
694		694
		695	=head2 illbatches
		696
		697	Type: has_many
		698
		699	Related object: L<Koha::Schema::Result::Illbatch>
		700
		701	=cut
		702
		703	__PACKAGE__->has_many(
		704	"illbatches",
		705	"Koha::Schema::Result::Illbatch",
		706	{ "foreign.branchcode" => "self.branchcode" },
		707	{ cascade_copy => 0, cascade_delete => 0 },
		708	);
		709
695	=head2 illrequests	710	=head2 illrequests
696		711
697	Type: has_many	712	Type: has_many
Lines 918-925 __PACKAGE__->has_many( Link Here
918	);	933	);
919		934
920		935
921	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-11-08 17:35:26	936	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:21
922	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QPqXuEigMeIBb9NKMSkrNw	937	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GGYhqyTVMmaFo9hAY4Jy5w
923		938
924	__PACKAGE__->add_columns(	939	__PACKAGE__->add_columns(
925	'+pickup_location' => { is_boolean => 1 },	940	'+pickup_location' => { is_boolean => 1 },

Line 0 Link Here

(-)a/Koha/Schema/Result/Illbatch.pm (+190 lines)
		1	use utf8;
		2	package Koha::Schema::Result::Illbatch;
		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::Illbatch
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<illbatches>
		19
		20	=cut
		21
		22	__PACKAGE__->table("illbatches");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 name
		33
		34	data_type: 'varchar'
		35	is_nullable: 0
		36	size: 100
		37
		38	=head2 backend
		39
		40	data_type: 'varchar'
		41	is_nullable: 0
		42	size: 20
		43
		44	=head2 borrowernumber
		45
		46	data_type: 'integer'
		47	is_foreign_key: 1
		48	is_nullable: 1
		49
		50	=head2 branchcode
		51
		52	data_type: 'varchar'
		53	is_foreign_key: 1
		54	is_nullable: 1
		55	size: 50
		56
		57	=head2 statuscode
		58
		59	data_type: 'varchar'
		60	is_foreign_key: 1
		61	is_nullable: 1
		62	size: 20
		63
		64	=cut
65
66	__PACKAGE__->add_columns(
67	"id",
68	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
69	"name",
70	{ data_type => "varchar", is_nullable => 0, size => 100 },
71	"backend",
72	{ data_type => "varchar", is_nullable => 0, size => 20 },
73	"borrowernumber",
74	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
75	"branchcode",
76	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 50 },
77	"statuscode",
78	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 20 },
79	);
80
81	=head1 PRIMARY KEY
82
83	=over 4
84
85	=item * L</id>
86
87	=back
88
89	=cut
90
91	__PACKAGE__->set_primary_key("id");
92
93	=head1 UNIQUE CONSTRAINTS
94
95	=head2 C<u_illbatches__name>
96
97	=over 4
98
99	=item * L</name>
100
101	=back
102
103	=cut
104
105	__PACKAGE__->add_unique_constraint("u_illbatches__name", ["name"]);
106
107	=head1 RELATIONS
108
109	=head2 borrowernumber
110
111	Type: belongs_to
112
113	Related object: L<Koha::Schema::Result::Borrower>
114
115	=cut
116
117	__PACKAGE__->belongs_to(
118	"borrowernumber",
119	"Koha::Schema::Result::Borrower",
120	{ borrowernumber => "borrowernumber" },
121	{
122	is_deferrable => 1,
123	join_type => "LEFT",
124	on_delete => "SET NULL",
125	on_update => "CASCADE",
126	},
127	);
128
129	=head2 branchcode
130
131	Type: belongs_to
132
133	Related object: L<Koha::Schema::Result::Branch>
134
135	=cut
136
137	__PACKAGE__->belongs_to(
138	"branchcode",
139	"Koha::Schema::Result::Branch",
140	{ branchcode => "branchcode" },
141	{
142	is_deferrable => 1,
143	join_type => "LEFT",
144	on_delete => "SET NULL",
145	on_update => "CASCADE",
146	},
147	);
148
149	=head2 illrequests
150
151	Type: has_many
152
153	Related object: L<Koha::Schema::Result::Illrequest>
154
155	=cut
156
157	__PACKAGE__->has_many(
158	"illrequests",
159	"Koha::Schema::Result::Illrequest",
160	{ "foreign.batch_id" => "self.id" },
161	{ cascade_copy => 0, cascade_delete => 0 },
162	);
163
164	=head2 statuscode
165
166	Type: belongs_to
167
168	Related object: L<Koha::Schema::Result::IllbatchStatus>
169
170	=cut
171
172	__PACKAGE__->belongs_to(
173	"statuscode",
174	"Koha::Schema::Result::IllbatchStatus",
175	{ code => "statuscode" },
176	{
177	is_deferrable => 1,
178	join_type => "LEFT",
179	on_delete => "SET NULL",
180	on_update => "CASCADE",
181	},
182	);
183
184
185	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:22
186	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j4UhTuwaQnwWhjSd9j35tg
187
188
189	# You can replace this text with custom code or comments, and it will be preserved on regeneration
190	1;

Line 0 Link Here

(-)a/Koha/Schema/Result/IllbatchStatus.pm (+111 lines)
		1	use utf8;
		2	package Koha::Schema::Result::IllbatchStatus;
		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::IllbatchStatus
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<illbatch_statuses>
		19
		20	=cut
		21
		22	__PACKAGE__->table("illbatch_statuses");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 name
		33
		34	data_type: 'varchar'
		35	is_nullable: 0
		36	size: 100
		37
		38	=head2 code
		39
		40	data_type: 'varchar'
		41	is_nullable: 0
		42	size: 20
		43
		44	=head2 is_system
		45
		46	data_type: 'integer'
		47	is_nullable: 1
		48
		49	=cut
		50
		51	__PACKAGE__->add_columns(
		52	"id",
		53	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
		54	"name",
		55	{ data_type => "varchar", is_nullable => 0, size => 100 },
		56	"code",
		57	{ data_type => "varchar", is_nullable => 0, size => 20 },
		58	"is_system",
		59	{ data_type => "integer", is_nullable => 1 },
		60	);
		61
		62	=head1 PRIMARY KEY
		63
		64	=over 4
65
66	=item * L</id>
67
68	=back
69
70	=cut
71
72	__PACKAGE__->set_primary_key("id");
73
74	=head1 UNIQUE CONSTRAINTS
75
76	=head2 C<u_illbatchstatuses__code>
77
78	=over 4
79
80	=item * L</code>
81
82	=back
83
84	=cut
85
86	__PACKAGE__->add_unique_constraint("u_illbatchstatuses__code", ["code"]);
87
88	=head1 RELATIONS
89
90	=head2 illbatches
91
92	Type: has_many
93
94	Related object: L<Koha::Schema::Result::Illbatch>
95
96	=cut
97
98	__PACKAGE__->has_many(
99	"illbatches",
100	"Koha::Schema::Result::Illbatch",
101	{ "foreign.statuscode" => "self.code" },
102	{ cascade_copy => 0, cascade_delete => 0 },
103	);
104
105
106	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-28 11:24:22
107	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LUHcLxj5W4tParGOEkVCdg
108
109
110	# You can replace this text with custom code or comments, and it will be preserved on regeneration
111	1;