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

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
Lines 375-380 __PACKAGE__->has_many( Link Here
375
  { cascade_copy => 0, cascade_delete => 0 },
375
  { cascade_copy => 0, cascade_delete => 0 },
376
);
376
);
377
377
378
=head2 recalls
379
380
Type: has_many
381
382
Related object: L<Koha::Schema::Result::Recall>
383
384
=cut
385
386
__PACKAGE__->has_many(
387
  "recalls",
388
  "Koha::Schema::Result::Recall",
389
  { "foreign.biblionumber" => "self.biblionumber" },
390
  { cascade_copy => 0, cascade_delete => 0 },
391
);
392
378
=head2 reserves
393
=head2 reserves
379
394
380
Type: has_many
395
Type: has_many
Lines 526-533 __PACKAGE__->has_many( Link Here
526
);
541
);
527
542
528
543
529
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-20 12:00:15
544
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
530
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:troBZEbpX+2RhgH2jptVZQ
545
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6YO2t5VoWcG/tM+8uOP/wg
531
546
532
__PACKAGE__->has_many(
547
__PACKAGE__->has_many(
533
  "biblioitem",
548
  "biblioitem",
(-)a/Koha/Schema/Result/Borrower.pm (+15 lines)
Lines 1559-1564 __PACKAGE__->has_many( Link Here
1559
  { cascade_copy => 0, cascade_delete => 0 },
1559
  { cascade_copy => 0, cascade_delete => 0 },
1560
);
1560
);
1561
1561
1562
=head2 recalls
1563
1564
Type: has_many
1565
1566
Related object: L<Koha::Schema::Result::Recall>
1567
1568
=cut
1569
1570
__PACKAGE__->has_many(
1571
  "recalls",
1572
  "Koha::Schema::Result::Recall",
1573
  { "foreign.borrowernumber" => "self.borrowernumber" },
1574
  { cascade_copy => 0, cascade_delete => 0 },
1575
);
1576
1562
=head2 reserves
1577
=head2 reserves
1563
1578
1564
Type: has_many
1579
Type: has_many
(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
Lines 761-766 __PACKAGE__->has_many( Link Here
761
  { cascade_copy => 0, cascade_delete => 0 },
761
  { cascade_copy => 0, cascade_delete => 0 },
762
);
762
);
763
763
764
=head2 recalls
765
766
Type: has_many
767
768
Related object: L<Koha::Schema::Result::Recall>
769
770
=cut
771
772
__PACKAGE__->has_many(
773
  "recalls",
774
  "Koha::Schema::Result::Recall",
775
  { "foreign.branchcode" => "self.branchcode" },
776
  { cascade_copy => 0, cascade_delete => 0 },
777
);
778
764
=head2 repeatable_holidays
779
=head2 repeatable_holidays
765
780
766
Type: has_many
781
Type: has_many
Lines 867-874 __PACKAGE__->has_many( Link Here
867
);
882
);
868
883
869
884
870
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-19 14:20:11
885
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2022-02-15 02:16:34
871
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v83MNP0UpFzlnax8rSQWSA
886
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PR2GOpldAnNtyB2DRLsE9g
872
887
873
__PACKAGE__->add_columns(
888
__PACKAGE__->add_columns(
874
    '+pickup_location' => { is_boolean => 1 },
889
    '+pickup_location' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Branchtransfer.pm (-6 / +5 lines)
Lines 103-113 any comments related to the transfer Link Here
103
=head2 reason
103
=head2 reason
104
104
105
  data_type: 'enum'
105
  data_type: 'enum'
106
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","TransferCancellation"]}
106
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","Recall","CancelRecall"]}
107
  is_nullable: 1
107
  is_nullable: 1
108
108
109
what triggered the transfer
110
111
=head2 cancellation_reason
109
=head2 cancellation_reason
112
110
113
  data_type: 'enum'
111
  data_type: 'enum'
Lines 185-191 __PACKAGE__->add_columns( Link Here
185
        "Reserve",
183
        "Reserve",
186
        "LostReserve",
184
        "LostReserve",
187
        "CancelReserve",
185
        "CancelReserve",
188
        "TransferCancellation",
186
        "Recall",
187
        "CancelRecall",
189
      ],
188
      ],
190
    },
189
    },
191
    is_nullable => 1,
190
    is_nullable => 1,
Lines 272-279 __PACKAGE__->belongs_to( Link Here
272
);
271
);
273
272
274
273
275
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-06-08 08:13:08
274
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
276
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+ABUZOo6IHbiRH1LTy3t+A
275
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:APOPxPO4uRpPHgSEhXbnTw
277
276
278
sub koha_object_class {
277
sub koha_object_class {
279
    'Koha::Item::Transfer';
278
    'Koha::Item::Transfer';
(-)a/Koha/Schema/Result/Item.pm (-2 / +17 lines)
Lines 789-794 __PACKAGE__->has_many( Link Here
789
  { cascade_copy => 0, cascade_delete => 0 },
789
  { cascade_copy => 0, cascade_delete => 0 },
790
);
790
);
791
791
792
=head2 recalls
793
794
Type: has_many
795
796
Related object: L<Koha::Schema::Result::Recall>
797
798
=cut
799
800
__PACKAGE__->has_many(
801
  "recalls",
802
  "Koha::Schema::Result::Recall",
803
  { "foreign.itemnumber" => "self.itemnumber" },
804
  { cascade_copy => 0, cascade_delete => 0 },
805
);
806
792
=head2 reserves
807
=head2 reserves
793
808
794
Type: has_many
809
Type: has_many
Lines 865-872 __PACKAGE__->has_many( Link Here
865
);
880
);
866
881
867
882
868
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-08-27 08:42:21
883
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
869
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SjZn3haOtUZWu1jrMigjNQ
884
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yRbholcHil9qRF5t+83jdA
870
885
871
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
886
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
872
887
(-)a/Koha/Schema/Result/Recall.pm (-1 / +273 lines)
Line 0 Link Here
0
- 
1
use utf8;
2
package Koha::Schema::Result::Recall;
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::Recall
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<recalls>
19
20
=cut
21
22
__PACKAGE__->table("recalls");
23
24
=head1 ACCESSORS
25
26
=head2 recall_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 borrowernumber
33
34
  data_type: 'integer'
35
  default_value: 0
36
  is_foreign_key: 1
37
  is_nullable: 0
38
39
=head2 recalldate
40
41
  data_type: 'datetime'
42
  datetime_undef_if_invalid: 1
43
  is_nullable: 1
44
45
=head2 biblionumber
46
47
  data_type: 'integer'
48
  default_value: 0
49
  is_foreign_key: 1
50
  is_nullable: 0
51
52
=head2 branchcode
53
54
  data_type: 'varchar'
55
  is_foreign_key: 1
56
  is_nullable: 1
57
  size: 10
58
59
=head2 cancellationdate
60
61
  data_type: 'datetime'
62
  datetime_undef_if_invalid: 1
63
  is_nullable: 1
64
65
=head2 recallnotes
66
67
  data_type: 'mediumtext'
68
  is_nullable: 1
69
70
=head2 priority
71
72
  data_type: 'smallint'
73
  is_nullable: 1
74
75
=head2 status
76
77
  data_type: 'varchar'
78
  is_nullable: 1
79
  size: 1
80
81
=head2 timestamp
82
83
  data_type: 'timestamp'
84
  datetime_undef_if_invalid: 1
85
  default_value: current_timestamp
86
  is_nullable: 0
87
88
=head2 itemnumber
89
90
  data_type: 'integer'
91
  is_foreign_key: 1
92
  is_nullable: 1
93
94
=head2 waitingdate
95
96
  data_type: 'datetime'
97
  datetime_undef_if_invalid: 1
98
  is_nullable: 1
99
100
=head2 expirationdate
101
102
  data_type: 'datetime'
103
  datetime_undef_if_invalid: 1
104
  is_nullable: 1
105
106
=head2 old
107
108
  data_type: 'tinyint'
109
  is_nullable: 1
110
111
=head2 item_level_recall
112
113
  data_type: 'tinyint'
114
  default_value: 0
115
  is_nullable: 0
116
117
=cut
118
119
__PACKAGE__->add_columns(
120
  "recall_id",
121
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
122
  "borrowernumber",
123
  {
124
    data_type      => "integer",
125
    default_value  => 0,
126
    is_foreign_key => 1,
127
    is_nullable    => 0,
128
  },
129
  "recalldate",
130
  {
131
    data_type => "datetime",
132
    datetime_undef_if_invalid => 1,
133
    is_nullable => 1,
134
  },
135
  "biblionumber",
136
  {
137
    data_type      => "integer",
138
    default_value  => 0,
139
    is_foreign_key => 1,
140
    is_nullable    => 0,
141
  },
142
  "branchcode",
143
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
144
  "cancellationdate",
145
  {
146
    data_type => "datetime",
147
    datetime_undef_if_invalid => 1,
148
    is_nullable => 1,
149
  },
150
  "recallnotes",
151
  { data_type => "mediumtext", is_nullable => 1 },
152
  "priority",
153
  { data_type => "smallint", is_nullable => 1 },
154
  "status",
155
  { data_type => "varchar", is_nullable => 1, size => 1 },
156
  "timestamp",
157
  {
158
    data_type => "timestamp",
159
    datetime_undef_if_invalid => 1,
160
    default_value => \"current_timestamp",
161
    is_nullable => 0,
162
  },
163
  "itemnumber",
164
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
165
  "waitingdate",
166
  {
167
    data_type => "datetime",
168
    datetime_undef_if_invalid => 1,
169
    is_nullable => 1,
170
  },
171
  "expirationdate",
172
  {
173
    data_type => "datetime",
174
    datetime_undef_if_invalid => 1,
175
    is_nullable => 1,
176
  },
177
  "old",
178
  { data_type => "tinyint", is_nullable => 1 },
179
  "item_level_recall",
180
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
181
);
182
183
=head1 PRIMARY KEY
184
185
=over 4
186
187
=item * L</recall_id>
188
189
=back
190
191
=cut
192
193
__PACKAGE__->set_primary_key("recall_id");
194
195
=head1 RELATIONS
196
197
=head2 biblionumber
198
199
Type: belongs_to
200
201
Related object: L<Koha::Schema::Result::Biblio>
202
203
=cut
204
205
__PACKAGE__->belongs_to(
206
  "biblionumber",
207
  "Koha::Schema::Result::Biblio",
208
  { biblionumber => "biblionumber" },
209
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
210
);
211
212
=head2 borrowernumber
213
214
Type: belongs_to
215
216
Related object: L<Koha::Schema::Result::Borrower>
217
218
=cut
219
220
__PACKAGE__->belongs_to(
221
  "borrowernumber",
222
  "Koha::Schema::Result::Borrower",
223
  { borrowernumber => "borrowernumber" },
224
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
225
);
226
227
=head2 branchcode
228
229
Type: belongs_to
230
231
Related object: L<Koha::Schema::Result::Branch>
232
233
=cut
234
235
__PACKAGE__->belongs_to(
236
  "branchcode",
237
  "Koha::Schema::Result::Branch",
238
  { branchcode => "branchcode" },
239
  {
240
    is_deferrable => 1,
241
    join_type     => "LEFT",
242
    on_delete     => "CASCADE",
243
    on_update     => "CASCADE",
244
  },
245
);
246
247
=head2 itemnumber
248
249
Type: belongs_to
250
251
Related object: L<Koha::Schema::Result::Item>
252
253
=cut
254
255
__PACKAGE__->belongs_to(
256
  "itemnumber",
257
  "Koha::Schema::Result::Item",
258
  { itemnumber => "itemnumber" },
259
  {
260
    is_deferrable => 1,
261
    join_type     => "LEFT",
262
    on_delete     => "CASCADE",
263
    on_update     => "CASCADE",
264
  },
265
);
266
267
268
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
269
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3OJBkRJzqxZpuRp0GYGixw
270
271
272
# You can replace this text with custom code or comments, and it will be preserved on regeneration
273
1;

Return to bug 19532