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

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +17 lines)
Lines 1402-1407 __PACKAGE__->has_many( Link Here
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",
(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
Lines 692-697 __PACKAGE__->has_many( Link Here
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 },
(-)a/Koha/Schema/Result/Illbatch.pm (+200 lines)
Line 0 Link Here
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;
(-)a/Koha/Schema/Result/IllbatchStatus.pm (+117 lines)
Line 0 Link Here
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;
(-)a/Koha/Schema/Result/Illrequest.pm (-3 / +32 lines)
Lines 182-187 Backend id attached to request Link Here
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