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

(-)a/Koha/Schema/Result/Biblio.pm (-26 / +11 lines)
Lines 315-346 __PACKAGE__->has_many( Link Here
315
  { cascade_copy => 0, cascade_delete => 0 },
315
  { cascade_copy => 0, cascade_delete => 0 },
316
);
316
);
317
317
318
=head2 items
318
=head2 holds
319
319
320
Type: has_many
320
Type: has_many
321
321
322
Related object: L<Koha::Schema::Result::Item>
322
Related object: L<Koha::Schema::Result::Hold>
323
323
324
=cut
324
=cut
325
325
326
__PACKAGE__->has_many(
326
__PACKAGE__->has_many(
327
  "items",
327
  "holds",
328
  "Koha::Schema::Result::Item",
328
  "Koha::Schema::Result::Hold",
329
  { "foreign.biblionumber" => "self.biblionumber" },
329
  { "foreign.biblio_id" => "self.biblionumber" },
330
  { cascade_copy => 0, cascade_delete => 0 },
330
  { cascade_copy => 0, cascade_delete => 0 },
331
);
331
);
332
332
333
=head2 old_reserves
333
=head2 items
334
334
335
Type: has_many
335
Type: has_many
336
336
337
Related object: L<Koha::Schema::Result::OldReserve>
337
Related object: L<Koha::Schema::Result::Item>
338
338
339
=cut
339
=cut
340
340
341
__PACKAGE__->has_many(
341
__PACKAGE__->has_many(
342
  "old_reserves",
342
  "items",
343
  "Koha::Schema::Result::OldReserve",
343
  "Koha::Schema::Result::Item",
344
  { "foreign.biblionumber" => "self.biblionumber" },
344
  { "foreign.biblionumber" => "self.biblionumber" },
345
  { cascade_copy => 0, cascade_delete => 0 },
345
  { cascade_copy => 0, cascade_delete => 0 },
346
);
346
);
Lines 360-380 __PACKAGE__->has_many( Link Here
360
  { cascade_copy => 0, cascade_delete => 0 },
360
  { cascade_copy => 0, cascade_delete => 0 },
361
);
361
);
362
362
363
=head2 reserves
364
365
Type: has_many
366
367
Related object: L<Koha::Schema::Result::Reserve>
368
369
=cut
370
371
__PACKAGE__->has_many(
372
  "reserves",
373
  "Koha::Schema::Result::Reserve",
374
  { "foreign.biblionumber" => "self.biblionumber" },
375
  { cascade_copy => 0, cascade_delete => 0 },
376
);
377
378
=head2 reviews
363
=head2 reviews
379
364
380
Type: has_many
365
Type: has_many
Lines 496-503 __PACKAGE__->has_many( Link Here
496
);
481
);
497
482
498
483
499
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-02-03 10:03:26
484
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 20:48:09
500
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YVZN5K/K1v7Kj2yYGwT2CQ
485
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N7iCWBcFJ/LxHQdGs8ewTw
501
486
502
__PACKAGE__->has_many(
487
__PACKAGE__->has_many(
503
  "biblioitem",
488
  "biblioitem",
(-)a/Koha/Schema/Result/Borrower.pm (-32 / +17 lines)
Lines 1214-1219 __PACKAGE__->has_many( Link Here
1214
  { cascade_copy => 0, cascade_delete => 0 },
1214
  { cascade_copy => 0, cascade_delete => 0 },
1215
);
1215
);
1216
1216
1217
=head2 holds
1218
1219
Type: has_many
1220
1221
Related object: L<Koha::Schema::Result::Hold>
1222
1223
=cut
1224
1225
__PACKAGE__->has_many(
1226
  "holds",
1227
  "Koha::Schema::Result::Hold",
1228
  { "foreign.patron_id" => "self.borrowernumber" },
1229
  { cascade_copy => 0, cascade_delete => 0 },
1230
);
1231
1217
=head2 housebound_profile
1232
=head2 housebound_profile
1218
1233
1219
Type: might_have
1234
Type: might_have
Lines 1424-1444 __PACKAGE__->has_many( Link Here
1424
  { cascade_copy => 0, cascade_delete => 0 },
1439
  { cascade_copy => 0, cascade_delete => 0 },
1425
);
1440
);
1426
1441
1427
=head2 old_reserves
1428
1429
Type: has_many
1430
1431
Related object: L<Koha::Schema::Result::OldReserve>
1432
1433
=cut
1434
1435
__PACKAGE__->has_many(
1436
  "old_reserves",
1437
  "Koha::Schema::Result::OldReserve",
1438
  { "foreign.borrowernumber" => "self.borrowernumber" },
1439
  { cascade_copy => 0, cascade_delete => 0 },
1440
);
1441
1442
=head2 opac_news
1442
=head2 opac_news
1443
1443
1444
Type: has_many
1444
Type: has_many
Lines 1544-1564 __PACKAGE__->has_many( Link Here
1544
  { cascade_copy => 0, cascade_delete => 0 },
1544
  { cascade_copy => 0, cascade_delete => 0 },
1545
);
1545
);
1546
1546
1547
=head2 reserves
1548
1549
Type: has_many
1550
1551
Related object: L<Koha::Schema::Result::Reserve>
1552
1553
=cut
1554
1555
__PACKAGE__->has_many(
1556
  "reserves",
1557
  "Koha::Schema::Result::Reserve",
1558
  { "foreign.borrowernumber" => "self.borrowernumber" },
1559
  { cascade_copy => 0, cascade_delete => 0 },
1560
);
1561
1562
=head2 return_claims_borrowernumbers
1547
=head2 return_claims_borrowernumbers
1563
1548
1564
Type: has_many
1549
Type: has_many
Lines 1875-1882 Composing rels: L</aqorder_users> -> ordernumber Link Here
1875
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1860
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1876
1861
1877
1862
1878
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00
1863
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 20:48:09
1879
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IKPb4912o8oCHtmFAi6FPQ
1864
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X0M9kJAk7bO5oFOHXUorKQ
1880
1865
1881
__PACKAGE__->add_columns(
1866
__PACKAGE__->add_columns(
1882
    '+anonymized'    => { is_boolean => 1 },
1867
    '+anonymized'    => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Branch.pm (-17 / +17 lines)
Lines 631-636 __PACKAGE__->has_many( Link Here
631
  { cascade_copy => 0, cascade_delete => 0 },
631
  { cascade_copy => 0, cascade_delete => 0 },
632
);
632
);
633
633
634
=head2 holds
635
636
Type: has_many
637
638
Related object: L<Koha::Schema::Result::Hold>
639
640
=cut
641
642
__PACKAGE__->has_many(
643
  "holds",
644
  "Koha::Schema::Result::Hold",
645
  { "foreign.pickup_library_id" => "self.branchcode" },
646
  { cascade_copy => 0, cascade_delete => 0 },
647
);
648
634
=head2 illrequests
649
=head2 illrequests
635
650
636
Type: has_many
651
Type: has_many
Lines 796-816 __PACKAGE__->has_many( Link Here
796
  { cascade_copy => 0, cascade_delete => 0 },
811
  { cascade_copy => 0, cascade_delete => 0 },
797
);
812
);
798
813
799
=head2 reserves
800
801
Type: has_many
802
803
Related object: L<Koha::Schema::Result::Reserve>
804
805
=cut
806
807
__PACKAGE__->has_many(
808
  "reserves",
809
  "Koha::Schema::Result::Reserve",
810
  { "foreign.branchcode" => "self.branchcode" },
811
  { cascade_copy => 0, cascade_delete => 0 },
812
);
813
814
=head2 special_holidays
814
=head2 special_holidays
815
815
816
Type: has_many
816
Type: has_many
Lines 887-894 __PACKAGE__->has_many( Link Here
887
);
887
);
888
888
889
889
890
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
890
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-27 19:57:36
891
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Uu8m3hyDhM50oTSeNTJbdg
891
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:scFksQ0UIScBex3j6VU8bw
892
892
893
__PACKAGE__->add_columns(
893
__PACKAGE__->add_columns(
894
    '+pickup_location' => { is_boolean => 1 }
894
    '+pickup_location' => { is_boolean => 1 }
(-)a/Koha/Schema/Result/ClubHoldsToPatronHold.pm (-5 / +5 lines)
Lines 128-141 __PACKAGE__->belongs_to( Link Here
128
128
129
Type: belongs_to
129
Type: belongs_to
130
130
131
Related object: L<Koha::Schema::Result::Reserve>
131
Related object: L<Koha::Schema::Result::Hold>
132
132
133
=cut
133
=cut
134
134
135
__PACKAGE__->belongs_to(
135
__PACKAGE__->belongs_to(
136
  "hold",
136
  "hold",
137
  "Koha::Schema::Result::Reserve",
137
  "Koha::Schema::Result::Hold",
138
  { reserve_id => "hold_id" },
138
  { id => "hold_id" },
139
  {
139
  {
140
    is_deferrable => 1,
140
    is_deferrable => 1,
141
    join_type     => "LEFT",
141
    join_type     => "LEFT",
Lines 160-167 __PACKAGE__->belongs_to( Link Here
160
);
160
);
161
161
162
162
163
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-08-04 18:43:05
163
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 11:40:08
164
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KjJWzFhPwQk0SZqrHQ4Alw
164
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7BEtGibjktT8MUPfLlY9Lw
165
165
166
sub koha_objects_class {
166
sub koha_objects_class {
167
    'Koha::Club::Hold::PatronHolds';
167
    'Koha::Club::Hold::PatronHolds';
(-)a/Koha/Schema/Result/Desk.pm (-6 / +6 lines)
Lines 89-112 __PACKAGE__->belongs_to( Link Here
89
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
89
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
90
);
90
);
91
91
92
=head2 reserves
92
=head2 holds
93
93
94
Type: has_many
94
Type: has_many
95
95
96
Related object: L<Koha::Schema::Result::Reserve>
96
Related object: L<Koha::Schema::Result::Hold>
97
97
98
=cut
98
=cut
99
99
100
__PACKAGE__->has_many(
100
__PACKAGE__->has_many(
101
  "reserves",
101
  "holds",
102
  "Koha::Schema::Result::Reserve",
102
  "Koha::Schema::Result::Hold",
103
  { "foreign.desk_id" => "self.desk_id" },
103
  { "foreign.desk_id" => "self.desk_id" },
104
  { cascade_copy => 0, cascade_delete => 0 },
104
  { cascade_copy => 0, cascade_delete => 0 },
105
);
105
);
106
106
107
107
108
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
108
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-27 19:57:36
109
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7qeCP25arGQpM4xxnTmWbw
109
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PkVcz/kbAu/zfbtztuJX9Q
110
110
111
111
112
# You can replace this text with custom code or comments, and it will be preserved on regeneration
112
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Item.pm (-32 / +17 lines)
Lines 694-699 __PACKAGE__->belongs_to( Link Here
694
  },
694
  },
695
);
695
);
696
696
697
=head2 holds
698
699
Type: has_many
700
701
Related object: L<Koha::Schema::Result::Hold>
702
703
=cut
704
705
__PACKAGE__->has_many(
706
  "holds",
707
  "Koha::Schema::Result::Hold",
708
  { "foreign.item_id" => "self.itemnumber" },
709
  { cascade_copy => 0, cascade_delete => 0 },
710
);
711
697
=head2 homebranch
712
=head2 homebranch
698
713
699
Type: belongs_to
714
Type: belongs_to
Lines 759-794 __PACKAGE__->has_many( Link Here
759
  { cascade_copy => 0, cascade_delete => 0 },
774
  { cascade_copy => 0, cascade_delete => 0 },
760
);
775
);
761
776
762
=head2 old_reserves
763
764
Type: has_many
765
766
Related object: L<Koha::Schema::Result::OldReserve>
767
768
=cut
769
770
__PACKAGE__->has_many(
771
  "old_reserves",
772
  "Koha::Schema::Result::OldReserve",
773
  { "foreign.itemnumber" => "self.itemnumber" },
774
  { cascade_copy => 0, cascade_delete => 0 },
775
);
776
777
=head2 reserves
778
779
Type: has_many
780
781
Related object: L<Koha::Schema::Result::Reserve>
782
783
=cut
784
785
__PACKAGE__->has_many(
786
  "reserves",
787
  "Koha::Schema::Result::Reserve",
788
  { "foreign.itemnumber" => "self.itemnumber" },
789
  { cascade_copy => 0, cascade_delete => 0 },
790
);
791
792
=head2 return_claims
777
=head2 return_claims
793
778
794
Type: has_many
779
Type: has_many
Lines 850-857 __PACKAGE__->has_many( Link Here
850
);
835
);
851
836
852
837
853
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
838
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-27 19:57:36
854
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U5Tm2JfUnfhACRDJ4SpFgQ
839
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WuEFNsbl8eRji9xY1b2MdA
855
840
856
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
841
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
857
842
(-)a/Koha/Schema/Result/Itemtype.pm (-31 / +16 lines)
Lines 252-298 __PACKAGE__->has_many( Link Here
252
  { cascade_copy => 0, cascade_delete => 0 },
252
  { cascade_copy => 0, cascade_delete => 0 },
253
);
253
);
254
254
255
=head2 itemtypes
255
=head2 holds
256
256
257
Type: has_many
257
Type: has_many
258
258
259
Related object: L<Koha::Schema::Result::Itemtype>
259
Related object: L<Koha::Schema::Result::Hold>
260
260
261
=cut
261
=cut
262
262
263
__PACKAGE__->has_many(
263
__PACKAGE__->has_many(
264
  "itemtypes",
264
  "holds",
265
  "Koha::Schema::Result::Itemtype",
265
  "Koha::Schema::Result::Hold",
266
  { "foreign.parent_type" => "self.itemtype" },
266
  { "foreign.item_type" => "self.itemtype" },
267
  { cascade_copy => 0, cascade_delete => 0 },
267
  { cascade_copy => 0, cascade_delete => 0 },
268
);
268
);
269
269
270
=head2 itemtypes_branches
270
=head2 itemtypes
271
271
272
Type: has_many
272
Type: has_many
273
273
274
Related object: L<Koha::Schema::Result::ItemtypesBranch>
274
Related object: L<Koha::Schema::Result::Itemtype>
275
275
276
=cut
276
=cut
277
277
278
__PACKAGE__->has_many(
278
__PACKAGE__->has_many(
279
  "itemtypes_branches",
279
  "itemtypes",
280
  "Koha::Schema::Result::ItemtypesBranch",
280
  "Koha::Schema::Result::Itemtype",
281
  { "foreign.itemtype" => "self.itemtype" },
281
  { "foreign.parent_type" => "self.itemtype" },
282
  { cascade_copy => 0, cascade_delete => 0 },
282
  { cascade_copy => 0, cascade_delete => 0 },
283
);
283
);
284
284
285
=head2 old_reserves
285
=head2 itemtypes_branches
286
286
287
Type: has_many
287
Type: has_many
288
288
289
Related object: L<Koha::Schema::Result::OldReserve>
289
Related object: L<Koha::Schema::Result::ItemtypesBranch>
290
290
291
=cut
291
=cut
292
292
293
__PACKAGE__->has_many(
293
__PACKAGE__->has_many(
294
  "old_reserves",
294
  "itemtypes_branches",
295
  "Koha::Schema::Result::OldReserve",
295
  "Koha::Schema::Result::ItemtypesBranch",
296
  { "foreign.itemtype" => "self.itemtype" },
296
  { "foreign.itemtype" => "self.itemtype" },
297
  { cascade_copy => 0, cascade_delete => 0 },
297
  { cascade_copy => 0, cascade_delete => 0 },
298
);
298
);
Lines 317-340 __PACKAGE__->belongs_to( Link Here
317
  },
317
  },
318
);
318
);
319
319
320
=head2 reserves
321
322
Type: has_many
323
324
Related object: L<Koha::Schema::Result::Reserve>
325
326
=cut
327
328
__PACKAGE__->has_many(
329
  "reserves",
330
  "Koha::Schema::Result::Reserve",
331
  { "foreign.itemtype" => "self.itemtype" },
332
  { cascade_copy => 0, cascade_delete => 0 },
333
);
334
335
320
336
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-04-22 09:12:04
321
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 20:48:10
337
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/kFAnQQ7q1KaLJ9h7vk0vg
322
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c6EdLE+NviawpsphjoDDsw
338
323
339
__PACKAGE__->add_columns(
324
__PACKAGE__->add_columns(
340
    '+rentalcharge_hourly_calendar' => { is_boolean => 1 },
325
    '+rentalcharge_hourly_calendar' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/OldReserve.pm (-281 / +55 lines)
Lines 25-411 __PACKAGE__->table("old_reserves"); Link Here
25
25
26
=head2 reserve_id
26
=head2 reserve_id
27
27
28
  data_type: 'integer'
28
  data_type: 'tinyint'
29
  is_nullable: 0
29
  is_nullable: 0
30
30
31
primary key
32
33
=head2 borrowernumber
31
=head2 borrowernumber
34
32
35
  data_type: 'integer'
33
  data_type: 'tinyint'
36
  is_foreign_key: 1
34
  is_nullable: 0
37
  is_nullable: 1
38
39
foreign key from the borrowers table defining which patron this hold is for
40
35
41
=head2 reservedate
36
=head2 reservedate
42
37
43
  data_type: 'date'
38
  data_type: 'tinyint'
44
  datetime_undef_if_invalid: 1
39
  is_nullable: 0
45
  is_nullable: 1
46
47
the date the hold was places
48
40
49
=head2 biblionumber
41
=head2 biblionumber
50
42
51
  data_type: 'integer'
43
  data_type: 'tinyint'
52
  is_foreign_key: 1
44
  is_nullable: 0
53
  is_nullable: 1
54
55
foreign key from the biblio table defining which bib record this hold is on
56
45
57
=head2 branchcode
46
=head2 branchcode
58
47
59
  data_type: 'varchar'
48
  data_type: 'tinyint'
60
  is_nullable: 1
49
  is_nullable: 0
61
  size: 10
62
63
foreign key from the branches table defining which branch the patron wishes to pick this hold up at
64
50
65
=head2 desk_id
51
=head2 desk_id
66
52
67
  data_type: 'integer'
53
  data_type: 'tinyint'
68
  is_nullable: 1
54
  is_nullable: 0
69
70
foreign key from the desks table defining which desk the patron should pick this hold up at
71
72
=head2 notificationdate
73
74
  data_type: 'date'
75
  datetime_undef_if_invalid: 1
76
  is_nullable: 1
77
78
currently unused
79
80
=head2 reminderdate
81
82
  data_type: 'date'
83
  datetime_undef_if_invalid: 1
84
  is_nullable: 1
85
86
currently unused
87
55
88
=head2 cancellationdate
56
=head2 cancellationdate
89
57
90
  data_type: 'date'
58
  data_type: 'tinyint'
91
  datetime_undef_if_invalid: 1
59
  is_nullable: 0
92
  is_nullable: 1
93
94
the date this hold was cancelled
95
60
96
=head2 cancellation_reason
61
=head2 cancellation_reason
97
62
98
  data_type: 'varchar'
63
  data_type: 'tinyint'
99
  is_nullable: 1
64
  is_nullable: 0
100
  size: 80
101
102
optional authorised value CANCELLATION_REASON
103
65
104
=head2 reservenotes
66
=head2 reservenotes
105
67
106
  data_type: 'longtext'
68
  data_type: 'tinyint'
107
  is_nullable: 1
69
  is_nullable: 0
108
109
notes related to this hold
110
70
111
=head2 priority
71
=head2 priority
112
72
113
  data_type: 'smallint'
73
  data_type: 'tinyint'
114
  default_value: 1
115
  is_nullable: 0
74
  is_nullable: 0
116
75
117
where in the queue the patron sits
118
119
=head2 found
76
=head2 found
120
77
121
  data_type: 'varchar'
78
  data_type: 'tinyint'
122
  is_nullable: 1
79
  is_nullable: 0
123
  size: 1
124
125
a one letter code defining what the status is of the hold is after it has been confirmed
126
80
127
=head2 timestamp
81
=head2 timestamp
128
82
129
  data_type: 'timestamp'
83
  data_type: 'tinyint'
130
  datetime_undef_if_invalid: 1
131
  default_value: current_timestamp
132
  is_nullable: 0
84
  is_nullable: 0
133
85
134
the date and time this hold was last updated
135
136
=head2 itemnumber
86
=head2 itemnumber
137
87
138
  data_type: 'integer'
88
  data_type: 'tinyint'
139
  is_foreign_key: 1
89
  is_nullable: 0
140
  is_nullable: 1
141
142
foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
143
90
144
=head2 waitingdate
91
=head2 waitingdate
145
92
146
  data_type: 'date'
93
  data_type: 'tinyint'
147
  datetime_undef_if_invalid: 1
94
  is_nullable: 0
148
  is_nullable: 1
149
150
the date the item was marked as waiting for the patron at the library
151
95
152
=head2 expirationdate
96
=head2 expirationdate
153
97
154
  data_type: 'date'
98
  data_type: 'tinyint'
155
  datetime_undef_if_invalid: 1
99
  is_nullable: 0
156
  is_nullable: 1
157
158
the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
159
100
160
=head2 lowestPriority
101
=head2 lowestPriority
161
102
162
  accessor: 'lowest_priority'
103
  accessor: 'lowest_priority'
163
  data_type: 'tinyint'
104
  data_type: 'tinyint'
164
  default_value: 0
165
  is_nullable: 0
105
  is_nullable: 0
166
106
167
has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
168
169
=head2 suspend
107
=head2 suspend
170
108
171
  data_type: 'tinyint'
109
  data_type: 'tinyint'
172
  default_value: 0
173
  is_nullable: 0
110
  is_nullable: 0
174
111
175
in this hold suspended (1 for yes, 0 for no)
176
177
=head2 suspend_until
112
=head2 suspend_until
178
113
179
  data_type: 'datetime'
114
  data_type: 'tinyint'
180
  datetime_undef_if_invalid: 1
115
  is_nullable: 0
181
  is_nullable: 1
182
183
the date this hold is suspended until (NULL for infinitely)
184
116
185
=head2 itemtype
117
=head2 itemtype
186
118
187
  data_type: 'varchar'
119
  data_type: 'tinyint'
188
  is_foreign_key: 1
120
  is_nullable: 0
189
  is_nullable: 1
190
  size: 10
191
192
If record level hold, the optional itemtype of the item the patron is requesting
193
121
194
=head2 item_level_hold
122
=head2 item_level_hold
195
123
196
  data_type: 'tinyint'
124
  data_type: 'tinyint'
197
  default_value: 0
198
  is_nullable: 0
125
  is_nullable: 0
199
126
200
Is the hpld placed at item level
201
202
=head2 non_priority
127
=head2 non_priority
203
128
204
  data_type: 'tinyint'
129
  data_type: 'tinyint'
205
  default_value: 0
206
  is_nullable: 0
130
  is_nullable: 0
207
131
208
Is this a non priority hold
209
210
=cut
132
=cut
211
133
212
__PACKAGE__->add_columns(
134
__PACKAGE__->add_columns(
213
  "reserve_id",
135
  "reserve_id",
214
  { data_type => "integer", is_nullable => 0 },
136
  { data_type => "tinyint", is_nullable => 0 },
215
  "borrowernumber",
137
  "borrowernumber",
216
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
138
  { data_type => "tinyint", is_nullable => 0 },
217
  "reservedate",
139
  "reservedate",
218
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
140
  { data_type => "tinyint", is_nullable => 0 },
219
  "biblionumber",
141
  "biblionumber",
220
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
142
  { data_type => "tinyint", is_nullable => 0 },
221
  "branchcode",
143
  "branchcode",
222
  { data_type => "varchar", is_nullable => 1, size => 10 },
144
  { data_type => "tinyint", is_nullable => 0 },
223
  "desk_id",
145
  "desk_id",
224
  { data_type => "integer", is_nullable => 1 },
146
  { data_type => "tinyint", is_nullable => 0 },
225
  "notificationdate",
226
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
227
  "reminderdate",
228
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
229
  "cancellationdate",
147
  "cancellationdate",
230
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
148
  { data_type => "tinyint", is_nullable => 0 },
231
  "cancellation_reason",
149
  "cancellation_reason",
232
  { data_type => "varchar", is_nullable => 1, size => 80 },
150
  { data_type => "tinyint", is_nullable => 0 },
233
  "reservenotes",
151
  "reservenotes",
234
  { data_type => "longtext", is_nullable => 1 },
152
  { data_type => "tinyint", is_nullable => 0 },
235
  "priority",
153
  "priority",
236
  { data_type => "smallint", default_value => 1, is_nullable => 0 },
154
  { data_type => "tinyint", is_nullable => 0 },
237
  "found",
155
  "found",
238
  { data_type => "varchar", is_nullable => 1, size => 1 },
156
  { data_type => "tinyint", is_nullable => 0 },
239
  "timestamp",
157
  "timestamp",
240
  {
158
  { data_type => "tinyint", is_nullable => 0 },
241
    data_type => "timestamp",
242
    datetime_undef_if_invalid => 1,
243
    default_value => \"current_timestamp",
244
    is_nullable => 0,
245
  },
246
  "itemnumber",
159
  "itemnumber",
247
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
160
  { data_type => "tinyint", is_nullable => 0 },
248
  "waitingdate",
161
  "waitingdate",
249
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
162
  { data_type => "tinyint", is_nullable => 0 },
250
  "expirationdate",
163
  "expirationdate",
251
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
164
  { data_type => "tinyint", is_nullable => 0 },
252
  "lowestPriority",
165
  "lowestPriority",
253
  {
166
  { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
254
    accessor      => "lowest_priority",
255
    data_type     => "tinyint",
256
    default_value => 0,
257
    is_nullable   => 0,
258
  },
259
  "suspend",
167
  "suspend",
260
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
168
  { data_type => "tinyint", is_nullable => 0 },
261
  "suspend_until",
169
  "suspend_until",
262
  {
170
  { data_type => "tinyint", is_nullable => 0 },
263
    data_type => "datetime",
264
    datetime_undef_if_invalid => 1,
265
    is_nullable => 1,
266
  },
267
  "itemtype",
171
  "itemtype",
268
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
172
  { data_type => "tinyint", is_nullable => 0 },
269
  "item_level_hold",
173
  "item_level_hold",
270
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
174
  { data_type => "tinyint", is_nullable => 0 },
271
  "non_priority",
175
  "non_priority",
272
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
176
  { data_type => "tinyint", is_nullable => 0 },
273
);
274
275
=head1 PRIMARY KEY
276
277
=over 4
278
279
=item * L</reserve_id>
280
281
=back
282
283
=cut
284
285
__PACKAGE__->set_primary_key("reserve_id");
286
287
=head1 RELATIONS
288
289
=head2 biblionumber
290
291
Type: belongs_to
292
293
Related object: L<Koha::Schema::Result::Biblio>
294
295
=cut
296
297
__PACKAGE__->belongs_to(
298
  "biblionumber",
299
  "Koha::Schema::Result::Biblio",
300
  { biblionumber => "biblionumber" },
301
  {
302
    is_deferrable => 1,
303
    join_type     => "LEFT",
304
    on_delete     => "SET NULL",
305
    on_update     => "SET NULL",
306
  },
307
);
308
309
=head2 borrowernumber
310
311
Type: belongs_to
312
313
Related object: L<Koha::Schema::Result::Borrower>
314
315
=cut
316
317
__PACKAGE__->belongs_to(
318
  "borrowernumber",
319
  "Koha::Schema::Result::Borrower",
320
  { borrowernumber => "borrowernumber" },
321
  {
322
    is_deferrable => 1,
323
    join_type     => "LEFT",
324
    on_delete     => "SET NULL",
325
    on_update     => "SET NULL",
326
  },
327
);
328
329
=head2 itemnumber
330
331
Type: belongs_to
332
333
Related object: L<Koha::Schema::Result::Item>
334
335
=cut
336
337
__PACKAGE__->belongs_to(
338
  "itemnumber",
339
  "Koha::Schema::Result::Item",
340
  { itemnumber => "itemnumber" },
341
  {
342
    is_deferrable => 1,
343
    join_type     => "LEFT",
344
    on_delete     => "SET NULL",
345
    on_update     => "SET NULL",
346
  },
347
);
177
);
348
178
349
=head2 itemtype
350
351
Type: belongs_to
352
353
Related object: L<Koha::Schema::Result::Itemtype>
354
179
355
=cut
180
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-19 14:50:01
356
181
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8lk8geAXvaDPVo9jW8Tv8Q
357
__PACKAGE__->belongs_to(
358
  "itemtype",
359
  "Koha::Schema::Result::Itemtype",
360
  { itemtype => "itemtype" },
361
  {
362
    is_deferrable => 1,
363
    join_type     => "LEFT",
364
    on_delete     => "SET NULL",
365
    on_update     => "SET NULL",
366
  },
367
);
368
369
370
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
371
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aVQsdX811LswCsWyBqkSbQ
372
373
__PACKAGE__->belongs_to(
374
  "item",
375
  "Koha::Schema::Result::Item",
376
  { itemnumber => "itemnumber" },
377
  {
378
    is_deferrable => 1,
379
    join_type     => "LEFT",
380
    on_delete     => "CASCADE",
381
    on_update     => "CASCADE",
382
  },
383
);
384
385
__PACKAGE__->belongs_to(
386
  "biblio",
387
  "Koha::Schema::Result::Biblio",
388
  { biblionumber => "biblionumber" },
389
  {
390
    is_deferrable => 1,
391
    join_type     => "LEFT",
392
    on_delete     => "CASCADE",
393
    on_update     => "CASCADE",
394
  },
395
);
396
397
__PACKAGE__->add_columns(
398
    '+item_level_hold' => { is_boolean => 1 },
399
    '+lowestPriority'  => { is_boolean => 1 },
400
    '+suspend'         => { is_boolean => 1 },
401
    '+non_priority'    => { is_boolean => 1 }
402
);
403
182
404
sub koha_object_class {
405
    'Koha::Old::Hold';
406
}
407
sub koha_objects_class {
408
    'Koha::Old::Holds';
409
}
410
183
184
# You can replace this text with custom code or comments, and it will be preserved on regeneration
411
1;
185
1;
(-)a/Koha/Schema/Result/Reserve.pm (-353 / +53 lines)
Lines 25-484 __PACKAGE__->table("reserves"); Link Here
25
25
26
=head2 reserve_id
26
=head2 reserve_id
27
27
28
  data_type: 'integer'
28
  data_type: 'tinyint'
29
  is_auto_increment: 1
30
  is_nullable: 0
29
  is_nullable: 0
31
30
32
primary key
33
34
=head2 borrowernumber
31
=head2 borrowernumber
35
32
36
  data_type: 'integer'
33
  data_type: 'tinyint'
37
  default_value: 0
38
  is_foreign_key: 1
39
  is_nullable: 0
34
  is_nullable: 0
40
35
41
foreign key from the borrowers table defining which patron this hold is for
42
43
=head2 reservedate
36
=head2 reservedate
44
37
45
  data_type: 'date'
38
  data_type: 'tinyint'
46
  datetime_undef_if_invalid: 1
39
  is_nullable: 0
47
  is_nullable: 1
48
49
the date the hold was placed
50
40
51
=head2 biblionumber
41
=head2 biblionumber
52
42
53
  data_type: 'integer'
43
  data_type: 'tinyint'
54
  default_value: 0
55
  is_foreign_key: 1
56
  is_nullable: 0
44
  is_nullable: 0
57
45
58
foreign key from the biblio table defining which bib record this hold is on
59
60
=head2 branchcode
46
=head2 branchcode
61
47
62
  data_type: 'varchar'
48
  data_type: 'tinyint'
63
  is_foreign_key: 1
49
  is_nullable: 0
64
  is_nullable: 1
65
  size: 10
66
67
foreign key from the branches table defining which branch the patron wishes to pick this hold up at
68
50
69
=head2 desk_id
51
=head2 desk_id
70
52
71
  data_type: 'integer'
53
  data_type: 'tinyint'
72
  is_foreign_key: 1
54
  is_nullable: 0
73
  is_nullable: 1
74
75
foreign key from the desks table defining which desk the patron should pick this hold up at
76
77
=head2 notificationdate
78
79
  data_type: 'date'
80
  datetime_undef_if_invalid: 1
81
  is_nullable: 1
82
83
currently unused
84
85
=head2 reminderdate
86
87
  data_type: 'date'
88
  datetime_undef_if_invalid: 1
89
  is_nullable: 1
90
91
currently unused
92
55
93
=head2 cancellationdate
56
=head2 cancellationdate
94
57
95
  data_type: 'date'
58
  data_type: 'tinyint'
96
  datetime_undef_if_invalid: 1
59
  is_nullable: 0
97
  is_nullable: 1
98
99
the date this hold was cancelled
100
60
101
=head2 cancellation_reason
61
=head2 cancellation_reason
102
62
103
  data_type: 'varchar'
63
  data_type: 'tinyint'
104
  is_nullable: 1
64
  is_nullable: 0
105
  size: 80
106
107
optional authorised value CANCELLATION_REASON
108
65
109
=head2 reservenotes
66
=head2 reservenotes
110
67
111
  data_type: 'longtext'
68
  data_type: 'tinyint'
112
  is_nullable: 1
69
  is_nullable: 0
113
114
notes related to this hold
115
70
116
=head2 priority
71
=head2 priority
117
72
118
  data_type: 'smallint'
73
  data_type: 'tinyint'
119
  default_value: 1
120
  is_nullable: 0
74
  is_nullable: 0
121
75
122
where in the queue the patron sits
123
124
=head2 found
76
=head2 found
125
77
126
  data_type: 'varchar'
78
  data_type: 'tinyint'
127
  is_nullable: 1
79
  is_nullable: 0
128
  size: 1
129
130
a one letter code defining what the status is of the hold is after it has been confirmed
131
80
132
=head2 timestamp
81
=head2 timestamp
133
82
134
  data_type: 'timestamp'
83
  data_type: 'tinyint'
135
  datetime_undef_if_invalid: 1
136
  default_value: current_timestamp
137
  is_nullable: 0
84
  is_nullable: 0
138
85
139
the date and time this hold was last updated
140
141
=head2 itemnumber
86
=head2 itemnumber
142
87
143
  data_type: 'integer'
88
  data_type: 'tinyint'
144
  is_foreign_key: 1
89
  is_nullable: 0
145
  is_nullable: 1
146
147
foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with
148
90
149
=head2 waitingdate
91
=head2 waitingdate
150
92
151
  data_type: 'date'
93
  data_type: 'tinyint'
152
  datetime_undef_if_invalid: 1
94
  is_nullable: 0
153
  is_nullable: 1
154
155
the date the item was marked as waiting for the patron at the library
156
95
157
=head2 expirationdate
96
=head2 expirationdate
158
97
159
  data_type: 'date'
98
  data_type: 'tinyint'
160
  datetime_undef_if_invalid: 1
99
  is_nullable: 0
161
  is_nullable: 1
162
163
the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
164
100
165
=head2 lowestPriority
101
=head2 lowestPriority
166
102
167
  accessor: 'lowest_priority'
103
  accessor: 'lowest_priority'
168
  data_type: 'tinyint'
104
  data_type: 'tinyint'
169
  default_value: 0
170
  is_nullable: 0
105
  is_nullable: 0
171
106
172
=head2 suspend
107
=head2 suspend
173
108
174
  data_type: 'tinyint'
109
  data_type: 'tinyint'
175
  default_value: 0
176
  is_nullable: 0
110
  is_nullable: 0
177
111
178
=head2 suspend_until
112
=head2 suspend_until
179
113
180
  data_type: 'datetime'
114
  data_type: 'tinyint'
181
  datetime_undef_if_invalid: 1
115
  is_nullable: 0
182
  is_nullable: 1
183
116
184
=head2 itemtype
117
=head2 itemtype
185
118
186
  data_type: 'varchar'
119
  data_type: 'tinyint'
187
  is_foreign_key: 1
120
  is_nullable: 0
188
  is_nullable: 1
189
  size: 10
190
191
If record level hold, the optional itemtype of the item the patron is requesting
192
121
193
=head2 item_level_hold
122
=head2 item_level_hold
194
123
195
  data_type: 'tinyint'
124
  data_type: 'tinyint'
196
  default_value: 0
197
  is_nullable: 0
125
  is_nullable: 0
198
126
199
Is the hpld placed at item level
200
201
=head2 non_priority
127
=head2 non_priority
202
128
203
  data_type: 'tinyint'
129
  data_type: 'tinyint'
204
  default_value: 0
205
  is_nullable: 0
130
  is_nullable: 0
206
131
207
Is this a non priority hold
208
209
=cut
132
=cut
210
133
211
__PACKAGE__->add_columns(
134
__PACKAGE__->add_columns(
212
  "reserve_id",
135
  "reserve_id",
213
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
136
  { data_type => "tinyint", is_nullable => 0 },
214
  "borrowernumber",
137
  "borrowernumber",
215
  {
138
  { data_type => "tinyint", is_nullable => 0 },
216
    data_type      => "integer",
217
    default_value  => 0,
218
    is_foreign_key => 1,
219
    is_nullable    => 0,
220
  },
221
  "reservedate",
139
  "reservedate",
222
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
140
  { data_type => "tinyint", is_nullable => 0 },
223
  "biblionumber",
141
  "biblionumber",
224
  {
142
  { data_type => "tinyint", is_nullable => 0 },
225
    data_type      => "integer",
226
    default_value  => 0,
227
    is_foreign_key => 1,
228
    is_nullable    => 0,
229
  },
230
  "branchcode",
143
  "branchcode",
231
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
144
  { data_type => "tinyint", is_nullable => 0 },
232
  "desk_id",
145
  "desk_id",
233
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
146
  { data_type => "tinyint", is_nullable => 0 },
234
  "notificationdate",
235
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
236
  "reminderdate",
237
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
238
  "cancellationdate",
147
  "cancellationdate",
239
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
148
  { data_type => "tinyint", is_nullable => 0 },
240
  "cancellation_reason",
149
  "cancellation_reason",
241
  { data_type => "varchar", is_nullable => 1, size => 80 },
150
  { data_type => "tinyint", is_nullable => 0 },
242
  "reservenotes",
151
  "reservenotes",
243
  { data_type => "longtext", is_nullable => 1 },
152
  { data_type => "tinyint", is_nullable => 0 },
244
  "priority",
153
  "priority",
245
  { data_type => "smallint", default_value => 1, is_nullable => 0 },
154
  { data_type => "tinyint", is_nullable => 0 },
246
  "found",
155
  "found",
247
  { data_type => "varchar", is_nullable => 1, size => 1 },
156
  { data_type => "tinyint", is_nullable => 0 },
248
  "timestamp",
157
  "timestamp",
249
  {
158
  { data_type => "tinyint", is_nullable => 0 },
250
    data_type => "timestamp",
251
    datetime_undef_if_invalid => 1,
252
    default_value => \"current_timestamp",
253
    is_nullable => 0,
254
  },
255
  "itemnumber",
159
  "itemnumber",
256
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
160
  { data_type => "tinyint", is_nullable => 0 },
257
  "waitingdate",
161
  "waitingdate",
258
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
162
  { data_type => "tinyint", is_nullable => 0 },
259
  "expirationdate",
163
  "expirationdate",
260
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
164
  { data_type => "tinyint", is_nullable => 0 },
261
  "lowestPriority",
165
  "lowestPriority",
262
  {
166
  { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
263
    accessor      => "lowest_priority",
264
    data_type     => "tinyint",
265
    default_value => 0,
266
    is_nullable   => 0,
267
  },
268
  "suspend",
167
  "suspend",
269
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
168
  { data_type => "tinyint", is_nullable => 0 },
270
  "suspend_until",
169
  "suspend_until",
271
  {
170
  { data_type => "tinyint", is_nullable => 0 },
272
    data_type => "datetime",
273
    datetime_undef_if_invalid => 1,
274
    is_nullable => 1,
275
  },
276
  "itemtype",
171
  "itemtype",
277
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
172
  { data_type => "tinyint", is_nullable => 0 },
278
  "item_level_hold",
173
  "item_level_hold",
279
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
174
  { data_type => "tinyint", is_nullable => 0 },
280
  "non_priority",
175
  "non_priority",
281
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
176
  { data_type => "tinyint", is_nullable => 0 },
282
);
283
284
=head1 PRIMARY KEY
285
286
=over 4
287
288
=item * L</reserve_id>
289
290
=back
291
292
=cut
293
294
__PACKAGE__->set_primary_key("reserve_id");
295
296
=head1 RELATIONS
297
298
=head2 biblionumber
299
300
Type: belongs_to
301
302
Related object: L<Koha::Schema::Result::Biblio>
303
304
=cut
305
306
__PACKAGE__->belongs_to(
307
  "biblionumber",
308
  "Koha::Schema::Result::Biblio",
309
  { biblionumber => "biblionumber" },
310
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
311
);
177
);
312
178
313
=head2 borrowernumber
314
315
Type: belongs_to
316
317
Related object: L<Koha::Schema::Result::Borrower>
318
319
=cut
320
321
__PACKAGE__->belongs_to(
322
  "borrowernumber",
323
  "Koha::Schema::Result::Borrower",
324
  { borrowernumber => "borrowernumber" },
325
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
326
);
327
328
=head2 branchcode
329
330
Type: belongs_to
331
332
Related object: L<Koha::Schema::Result::Branch>
333
179
334
=cut
180
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-19 14:50:01
335
181
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iAJVTUfqX6QT29xY+QxPnA
336
__PACKAGE__->belongs_to(
337
  "branchcode",
338
  "Koha::Schema::Result::Branch",
339
  { branchcode => "branchcode" },
340
  {
341
    is_deferrable => 1,
342
    join_type     => "LEFT",
343
    on_delete     => "CASCADE",
344
    on_update     => "CASCADE",
345
  },
346
);
347
348
=head2 club_holds_to_patron_holds
349
350
Type: has_many
351
352
Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>
353
354
=cut
355
356
__PACKAGE__->has_many(
357
  "club_holds_to_patron_holds",
358
  "Koha::Schema::Result::ClubHoldsToPatronHold",
359
  { "foreign.hold_id" => "self.reserve_id" },
360
  { cascade_copy => 0, cascade_delete => 0 },
361
);
362
363
=head2 desk
364
365
Type: belongs_to
366
367
Related object: L<Koha::Schema::Result::Desk>
368
369
=cut
370
182
371
__PACKAGE__->belongs_to(
372
  "desk",
373
  "Koha::Schema::Result::Desk",
374
  { desk_id => "desk_id" },
375
  {
376
    is_deferrable => 1,
377
    join_type     => "LEFT",
378
    on_delete     => "SET NULL",
379
    on_update     => "CASCADE",
380
  },
381
);
382
383
=head2 itemnumber
384
385
Type: belongs_to
386
387
Related object: L<Koha::Schema::Result::Item>
388
389
=cut
390
391
__PACKAGE__->belongs_to(
392
  "itemnumber",
393
  "Koha::Schema::Result::Item",
394
  { itemnumber => "itemnumber" },
395
  {
396
    is_deferrable => 1,
397
    join_type     => "LEFT",
398
    on_delete     => "CASCADE",
399
    on_update     => "CASCADE",
400
  },
401
);
402
403
=head2 itemtype
404
405
Type: belongs_to
406
407
Related object: L<Koha::Schema::Result::Itemtype>
408
409
=cut
410
411
__PACKAGE__->belongs_to(
412
  "itemtype",
413
  "Koha::Schema::Result::Itemtype",
414
  { itemtype => "itemtype" },
415
  {
416
    is_deferrable => 1,
417
    join_type     => "LEFT",
418
    on_delete     => "CASCADE",
419
    on_update     => "CASCADE",
420
  },
421
);
422
423
424
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
425
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BlMb2M0MEmFuTiMSSBEseg
426
427
__PACKAGE__->belongs_to(
428
  "item",
429
  "Koha::Schema::Result::Item",
430
  { itemnumber => "itemnumber" },
431
  {
432
    is_deferrable => 1,
433
    join_type     => "LEFT",
434
    on_delete     => "CASCADE",
435
    on_update     => "CASCADE",
436
  },
437
);
438
439
__PACKAGE__->belongs_to(
440
  "biblio",
441
  "Koha::Schema::Result::Biblio",
442
  { biblionumber => "biblionumber" },
443
  {
444
    is_deferrable => 1,
445
    join_type     => "LEFT",
446
    on_delete     => "CASCADE",
447
    on_update     => "CASCADE",
448
  },
449
);
450
451
__PACKAGE__->belongs_to(
452
  "patron",
453
  "Koha::Schema::Result::Borrower",
454
  { "foreign.borrowernumber" => "self.borrowernumber" },
455
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
456
);
457
458
__PACKAGE__->add_columns(
459
    '+item_level_hold' => { is_boolean => 1 },
460
    '+lowestPriority'  => { is_boolean => 1 },
461
    '+suspend'         => { is_boolean => 1 },
462
    '+non_priority'    => { is_boolean => 1 }
463
);
464
465
sub koha_object_class {
466
    'Koha::Hold';
467
}
468
sub koha_objects_class {
469
    'Koha::Holds';
470
}
471
472
__PACKAGE__->belongs_to(
473
  "itembib",
474
  "Koha::Schema::Result::Item",
475
  { biblionumber => "biblionumber" },
476
  {
477
    is_deferrable => 1,
478
    join_type     => "LEFT",
479
    on_delete     => "CASCADE",
480
    on_update     => "CASCADE",
481
  },
482
);
483
183
184
# You can replace this text with custom code or comments, and it will be preserved on regeneration
484
1;
185
1;
485
- 

Return to bug 25260