Attachment #155432 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

Batch ID

=head2 name

  data_type: 'varchar'
  is_nullable: 0
  size: 100

Unique name of batch

=head2 backend

  data_type: 'varchar'
  is_nullable: 0
  size: 20

Name of batch backend

=head2 borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Patron associated with batch

=head2 branchcode

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

Branch associated with batch

=head2 statuscode

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

Status of batch

=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-09-08 13:49:29
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YKxQxJMKxdBP9X4+i0Rfzw

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

Status ID

=head2 name

  data_type: 'varchar'
  is_nullable: 0
  size: 100

Name of status

=head2 code

  data_type: 'varchar'
  is_nullable: 0
  size: 20

Unique, immutable code for status

=head2 is_system

  data_type: 'tinyint'
  is_nullable: 1

Is this status required for system operation

=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 => "tinyint", 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-09-08 13:49:29
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yo60FJ+kyRj8QuEMac8CFA

1;

Lines 182-187 Backend id attached to request Link Here

(-)a/Koha/Schema/Result/Illrequest.pm (-3 / +32 lines)
182		182
183	The backend used to create request	183	The backend used to create request
184		184
		185	=head2 batch_id
		186
		187	data_type: 'integer'
		188	is_foreign_key: 1
		189	is_nullable: 1
		190
		191	Optional ID of batch that this request belongs to
		192
185	=cut	193	=cut
186		194
187	__PACKAGE__->add_columns(	195	__PACKAGE__->add_columns(
Lines 239-244 __PACKAGE__->add_columns( Link Here
239	{ data_type => "varchar", is_nullable => 1, size => 50 },	247	{ data_type => "varchar", is_nullable => 1, size => 50 },
240	"backend",	248	"backend",
241	{ data_type => "varchar", is_nullable => 1, size => 20 },	249	{ data_type => "varchar", is_nullable => 1, size => 20 },
		250	"batch_id",
		251	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
242	);	252	);
243		253
244	=head1 PRIMARY KEY	254	=head1 PRIMARY KEY
Lines 255-260 __PACKAGE__->set_primary_key("illrequest_id"); Link Here
255		265
256	=head1 RELATIONS	266	=head1 RELATIONS
257		267
		268	=head2 batch
		269
		270	Type: belongs_to
		271
		272	Related object: L<Koha::Schema::Result::Illbatch>
		273
		274	=cut
		275
		276	__PACKAGE__->belongs_to(
		277	"batch",
		278	"Koha::Schema::Result::Illbatch",
		279	{ id => "batch_id" },
		280	{
		281	is_deferrable => 1,
		282	join_type => "LEFT",
		283	on_delete => "SET NULL",
		284	on_update => "CASCADE",
		285	},
		286	);
		287
258	=head2 biblio	288	=head2 biblio
259		289
260	Type: belongs_to	290	Type: belongs_to
Lines 361-368 __PACKAGE__->belongs_to( Link Here
361	);	391	);
362		392
363		393
364	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-06-05 16:11:04	394	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-09-08 13:51:09
365	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6b58Mo/KzvheZCurYvKu7A	395	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QS3E1jO/d797B0ADcjT0yQ
366		396
367	__PACKAGE__->has_many(	397	__PACKAGE__->has_many(
368	"comments",	398	"comments",
369	-

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 (+200 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	Batch ID
		33
		34	=head2 name
		35
		36	data_type: 'varchar'
		37	is_nullable: 0
		38	size: 100
		39
		40	Unique name of batch
		41
		42	=head2 backend
		43
		44	data_type: 'varchar'
		45	is_nullable: 0
		46	size: 20
		47
		48	Name of batch backend
		49
		50	=head2 borrowernumber
		51
		52	data_type: 'integer'
		53	is_foreign_key: 1
		54	is_nullable: 1
		55
		56	Patron associated with batch
		57
		58	=head2 branchcode
		59
		60	data_type: 'varchar'
		61	is_foreign_key: 1
		62	is_nullable: 1
		63	size: 50
		64
65	Branch associated with batch
66
67	=head2 statuscode
68
69	data_type: 'varchar'
70	is_foreign_key: 1
71	is_nullable: 1
72	size: 20
73
74	Status of batch
75
76	=cut
77
78	__PACKAGE__->add_columns(
79	"id",
80	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
81	"name",
82	{ data_type => "varchar", is_nullable => 0, size => 100 },
83	"backend",
84	{ data_type => "varchar", is_nullable => 0, size => 20 },
85	"borrowernumber",
86	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
87	"branchcode",
88	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 50 },
89	"statuscode",
90	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 20 },
91	);
92
93	=head1 PRIMARY KEY
94
95	=over 4
96
97	=item * L</id>
98
99	=back
100
101	=cut
102
103	__PACKAGE__->set_primary_key("id");
104
105	=head1 UNIQUE CONSTRAINTS
106
107	=head2 C<u_illbatches__name>
108
109	=over 4
110
111	=item * L</name>
112
113	=back
114
115	=cut
116
117	__PACKAGE__->add_unique_constraint("u_illbatches__name", ["name"]);
118
119	=head1 RELATIONS
120
121	=head2 borrowernumber
122
123	Type: belongs_to
124
125	Related object: L<Koha::Schema::Result::Borrower>
126
127	=cut
128
129	__PACKAGE__->belongs_to(
130	"borrowernumber",
131	"Koha::Schema::Result::Borrower",
132	{ borrowernumber => "borrowernumber" },
133	{
134	is_deferrable => 1,
135	join_type => "LEFT",
136	on_delete => "SET NULL",
137	on_update => "CASCADE",
138	},
139	);
140
141	=head2 branchcode
142
143	Type: belongs_to
144
145	Related object: L<Koha::Schema::Result::Branch>
146
147	=cut
148
149	__PACKAGE__->belongs_to(
150	"branchcode",
151	"Koha::Schema::Result::Branch",
152	{ branchcode => "branchcode" },
153	{
154	is_deferrable => 1,
155	join_type => "LEFT",
156	on_delete => "SET NULL",
157	on_update => "CASCADE",
158	},
159	);
160
161	=head2 illrequests
162
163	Type: has_many
164
165	Related object: L<Koha::Schema::Result::Illrequest>
166
167	=cut
168
169	__PACKAGE__->has_many(
170	"illrequests",
171	"Koha::Schema::Result::Illrequest",
172	{ "foreign.batch_id" => "self.id" },
173	{ cascade_copy => 0, cascade_delete => 0 },
174	);
175
176	=head2 statuscode
177
178	Type: belongs_to
179
180	Related object: L<Koha::Schema::Result::IllbatchStatus>
181
182	=cut
183
184	__PACKAGE__->belongs_to(
185	"statuscode",
186	"Koha::Schema::Result::IllbatchStatus",
187	{ code => "statuscode" },
188	{
189	is_deferrable => 1,
190	join_type => "LEFT",
191	on_delete => "SET NULL",
192	on_update => "CASCADE",
193	},
194	);
195
196
197	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-09-08 13:49:29
198	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YKxQxJMKxdBP9X4+i0Rfzw
199
200	1;

Line 0 Link Here

(-)a/Koha/Schema/Result/IllbatchStatus.pm (+117 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	Status ID
		33
		34	=head2 name
		35
		36	data_type: 'varchar'
		37	is_nullable: 0
		38	size: 100
		39
		40	Name of status
		41
		42	=head2 code
		43
		44	data_type: 'varchar'
		45	is_nullable: 0
		46	size: 20
		47
		48	Unique, immutable code for status
		49
		50	=head2 is_system
		51
		52	data_type: 'tinyint'
		53	is_nullable: 1
		54
		55	Is this status required for system operation
		56
		57	=cut
		58
		59	__PACKAGE__->add_columns(
		60	"id",
		61	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
		62	"name",
		63	{ data_type => "varchar", is_nullable => 0, size => 100 },
		64	"code",
65	{ data_type => "varchar", is_nullable => 0, size => 20 },
66	"is_system",
67	{ data_type => "tinyint", is_nullable => 1 },
68	);
69
70	=head1 PRIMARY KEY
71
72	=over 4
73
74	=item * L</id>
75
76	=back
77
78	=cut
79
80	__PACKAGE__->set_primary_key("id");
81
82	=head1 UNIQUE CONSTRAINTS
83
84	=head2 C<u_illbatchstatuses__code>
85
86	=over 4
87
88	=item * L</code>
89
90	=back
91
92	=cut
93
94	__PACKAGE__->add_unique_constraint("u_illbatchstatuses__code", ["code"]);
95
96	=head1 RELATIONS
97
98	=head2 illbatches
99
100	Type: has_many
101
102	Related object: L<Koha::Schema::Result::Illbatch>
103
104	=cut
105
106	__PACKAGE__->has_many(
107	"illbatches",
108	"Koha::Schema::Result::Illbatch",
109	{ "foreign.statuscode" => "self.code" },
110	{ cascade_copy => 0, cascade_delete => 0 },
111	);
112
113
114	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-09-08 13:49:29
115	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yo60FJ+kyRj8QuEMac8CFA
116
117	1;