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 (+190 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
=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;
(-)a/Koha/Schema/Result/IllbatchStatus.pm (+111 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
=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;
(-)a/Koha/Schema/Result/Illrequest.pm (-1 / +30 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
261
- 

Return to bug 30719