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

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
Lines 345-350 __PACKAGE__->has_many( Link Here
345
  { cascade_copy => 0, cascade_delete => 0 },
345
  { cascade_copy => 0, cascade_delete => 0 },
346
);
346
);
347
347
348
=head2 recalls
349
350
Type: has_many
351
352
Related object: L<Koha::Schema::Result::Recall>
353
354
=cut
355
356
__PACKAGE__->has_many(
357
  "recalls",
358
  "Koha::Schema::Result::Recall",
359
  { "foreign.biblionumber" => "self.biblionumber" },
360
  { cascade_copy => 0, cascade_delete => 0 },
361
);
362
348
=head2 reserves
363
=head2 reserves
349
364
350
Type: has_many
365
Type: has_many
Lines 481-488 __PACKAGE__->has_many( Link Here
481
);
496
);
482
497
483
498
484
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
499
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-16 15:07:22
485
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nmmsZusHYNAMimE9sImSNg
500
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KlCVdQ0AS/z0+nfLaRYifA
486
501
487
__PACKAGE__->has_many(
502
__PACKAGE__->has_many(
488
  "biblioitem",
503
  "biblioitem",
(-)a/Koha/Schema/Result/Borrower.pm (-2 / +17 lines)
Lines 1534-1539 __PACKAGE__->has_many( Link Here
1534
  { cascade_copy => 0, cascade_delete => 0 },
1534
  { cascade_copy => 0, cascade_delete => 0 },
1535
);
1535
);
1536
1536
1537
=head2 recalls
1538
1539
Type: has_many
1540
1541
Related object: L<Koha::Schema::Result::Recall>
1542
1543
=cut
1544
1545
__PACKAGE__->has_many(
1546
  "recalls",
1547
  "Koha::Schema::Result::Recall",
1548
  { "foreign.borrowernumber" => "self.borrowernumber" },
1549
  { cascade_copy => 0, cascade_delete => 0 },
1550
);
1551
1537
=head2 reserves
1552
=head2 reserves
1538
1553
1539
Type: has_many
1554
Type: has_many
Lines 1865-1872 Composing rels: L</aqorder_users> -> ordernumber Link Here
1865
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1880
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1866
1881
1867
1882
1868
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
1883
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-16 15:07:22
1869
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Q9AXeEJckLl7CX6E40DUBw
1884
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wZdpzEBUXOHrvPsocJK4Xw
1870
1885
1871
__PACKAGE__->add_columns(
1886
__PACKAGE__->add_columns(
1872
    '+anonymized'    => { is_boolean => 1 },
1887
    '+anonymized'    => { is_boolean => 1 },
(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
Lines 781-786 __PACKAGE__->has_many( Link Here
781
  { cascade_copy => 0, cascade_delete => 0 },
781
  { cascade_copy => 0, cascade_delete => 0 },
782
);
782
);
783
783
784
=head2 recalls
785
786
Type: has_many
787
788
Related object: L<Koha::Schema::Result::Recall>
789
790
=cut
791
792
__PACKAGE__->has_many(
793
  "recalls",
794
  "Koha::Schema::Result::Recall",
795
  { "foreign.branchcode" => "self.branchcode" },
796
  { cascade_copy => 0, cascade_delete => 0 },
797
);
798
784
=head2 repeatable_holidays
799
=head2 repeatable_holidays
785
800
786
Type: has_many
801
Type: has_many
Lines 887-894 __PACKAGE__->has_many( Link Here
887
);
902
);
888
903
889
904
890
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
905
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-16 15:07:22
891
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Uu8m3hyDhM50oTSeNTJbdg
906
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GfjD82y0TUe9/ui9TguiRg
892
907
893
__PACKAGE__->add_columns(
908
__PACKAGE__->add_columns(
894
    '+pickup_location' => { is_boolean => 1 }
909
    '+pickup_location' => { is_boolean => 1 }
(-)a/Koha/Schema/Result/Branchtransfer.pm (-6 / +8 lines)
Lines 103-117 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"]}
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'
114
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve"]}
112
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","Recall","CancelRecall"]}
115
  is_nullable: 1
113
  is_nullable: 1
116
114
117
what triggered the transfer cancellation
115
what triggered the transfer cancellation
Lines 185-190 __PACKAGE__->add_columns( Link Here
185
        "Reserve",
183
        "Reserve",
186
        "LostReserve",
184
        "LostReserve",
187
        "CancelReserve",
185
        "CancelReserve",
186
        "Recall",
187
        "CancelRecall",
188
      ],
188
      ],
189
    },
189
    },
190
    is_nullable => 1,
190
    is_nullable => 1,
Lines 203-208 __PACKAGE__->add_columns( Link Here
203
        "Reserve",
203
        "Reserve",
204
        "LostReserve",
204
        "LostReserve",
205
        "CancelReserve",
205
        "CancelReserve",
206
        "Recall",
207
        "CancelRecall",
206
      ],
208
      ],
207
    },
209
    },
208
    is_nullable => 1,
210
    is_nullable => 1,
Lines 269-276 __PACKAGE__->belongs_to( Link Here
269
);
271
);
270
272
271
273
272
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-03-03 13:47:35
274
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-16 15:07:22
273
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pL0dO9OUwImy2rv7Md3AyA
275
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7Q5TRxyj9b4ugLVIMqaLvQ
274
276
275
sub koha_object_class {
277
sub koha_object_class {
276
    'Koha::Item::Transfer';
278
    'Koha::Item::Transfer';
(-)a/Koha/Schema/Result/Item.pm (-2 / +17 lines)
Lines 774-779 __PACKAGE__->has_many( Link Here
774
  { cascade_copy => 0, cascade_delete => 0 },
774
  { cascade_copy => 0, cascade_delete => 0 },
775
);
775
);
776
776
777
=head2 recalls
778
779
Type: has_many
780
781
Related object: L<Koha::Schema::Result::Recall>
782
783
=cut
784
785
__PACKAGE__->has_many(
786
  "recalls",
787
  "Koha::Schema::Result::Recall",
788
  { "foreign.itemnumber" => "self.itemnumber" },
789
  { cascade_copy => 0, cascade_delete => 0 },
790
);
791
777
=head2 reserves
792
=head2 reserves
778
793
779
Type: has_many
794
Type: has_many
Lines 850-857 __PACKAGE__->has_many( Link Here
850
);
865
);
851
866
852
867
853
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
868
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-16 15:07:23
854
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U5Tm2JfUnfhACRDJ4SpFgQ
869
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E/5AFrX54GsbFB2KsjDcnw
855
870
856
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
871
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
857
872
(-)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-03-16 15:07:23
269
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DLirrY6PrHtHJ9ZtuR04Cw
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