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

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
Lines 325-330 __PACKAGE__->has_many( Link Here
325
  { cascade_copy => 0, cascade_delete => 0 },
325
  { cascade_copy => 0, cascade_delete => 0 },
326
);
326
);
327
327
328
=head2 display_items
329
330
Type: has_many
331
332
Related object: L<Koha::Schema::Result::DisplayItem>
333
334
=cut
335
336
__PACKAGE__->has_many(
337
  "display_items",
338
  "Koha::Schema::Result::DisplayItem",
339
  { "foreign.biblionumber" => "self.biblionumber" },
340
  { cascade_copy => 0, cascade_delete => 0 },
341
);
342
328
=head2 erm_eholdings_titles
343
=head2 erm_eholdings_titles
329
344
330
Type: has_many
345
Type: has_many
Lines 641-648 __PACKAGE__->has_many( Link Here
641
);
656
);
642
657
643
658
644
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-12-18 12:10:28
659
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-15 08:07:04
645
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QXaEHXqH2ApC+F22zo7gXA
660
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W2YtMTEXGHxwDI0ra1D/mw
646
661
647
__PACKAGE__->has_many(
662
__PACKAGE__->has_many(
648
  "biblioitem",
663
  "biblioitem",
(-)a/Koha/Schema/Result/Branch.pm (-2 / +32 lines)
Lines 680-685 __PACKAGE__->has_many( Link Here
680
  { cascade_copy => 0, cascade_delete => 0 },
680
  { cascade_copy => 0, cascade_delete => 0 },
681
);
681
);
682
682
683
=head2 displays
684
685
Type: has_many
686
687
Related object: L<Koha::Schema::Result::Display>
688
689
=cut
690
691
__PACKAGE__->has_many(
692
  "displays",
693
  "Koha::Schema::Result::Display",
694
  { "foreign.display_branch" => "self.branchcode" },
695
  { cascade_copy => 0, cascade_delete => 0 },
696
);
697
698
=head2 displays_display_holding_branches
699
700
Type: has_many
701
702
Related object: L<Koha::Schema::Result::Display>
703
704
=cut
705
706
__PACKAGE__->has_many(
707
  "displays_display_holding_branches",
708
  "Koha::Schema::Result::Display",
709
  { "foreign.display_holding_branch" => "self.branchcode" },
710
  { cascade_copy => 0, cascade_delete => 0 },
711
);
712
683
=head2 edifact_eans
713
=head2 edifact_eans
684
714
685
Type: has_many
715
Type: has_many
Lines 996-1003 __PACKAGE__->has_many( Link Here
996
);
1026
);
997
1027
998
1028
999
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-03 13:13:25
1029
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-23 14:05:29
1000
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HiH1QNlDqKcq9GeM85Pu0A
1030
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g7lwQkToOnQvOJjSsn90AA
1001
1031
1002
__PACKAGE__->has_many(
1032
__PACKAGE__->has_many(
1003
    "additional_field_values",
1033
    "additional_field_values",
(-)a/Koha/Schema/Result/Display.pm (+274 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::Display;
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::Display
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<displays>
19
20
=cut
21
22
__PACKAGE__->table("displays");
23
24
=head1 ACCESSORS
25
26
=head2 display_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
unique id for the display
33
34
=head2 display_name
35
36
  data_type: 'varchar'
37
  is_nullable: 1
38
  size: 255
39
40
the name of the display
41
42
=head2 start_date
43
44
  data_type: 'date'
45
  datetime_undef_if_invalid: 1
46
  is_nullable: 1
47
48
the start date of the display (optional)
49
50
=head2 end_date
51
52
  data_type: 'date'
53
  datetime_undef_if_invalid: 1
54
  is_nullable: 1
55
56
the end date of the display (optional)
57
58
=head2 enabled
59
60
  data_type: 'tinyint'
61
  default_value: 1
62
  is_nullable: 0
63
64
determines whether the display is active
65
66
=head2 display_location
67
68
  data_type: 'varchar'
69
  is_nullable: 1
70
  size: 80
71
72
the shelving location for the display (optional)
73
74
=head2 display_code
75
76
  data_type: 'varchar'
77
  is_nullable: 1
78
  size: 80
79
80
the collection code for the display (optional)
81
82
=head2 display_branch
83
84
  data_type: 'varchar'
85
  is_foreign_key: 1
86
  is_nullable: 1
87
  size: 10
88
89
a new home branch for the item to have while on display (optional)
90
91
=head2 display_holding_branch
92
93
  data_type: 'varchar'
94
  is_foreign_key: 1
95
  is_nullable: 1
96
  size: 10
97
98
a new holding branch for the item to have while on display (optional)
99
100
=head2 display_itype
101
102
  data_type: 'varchar'
103
  is_foreign_key: 1
104
  is_nullable: 1
105
  size: 10
106
107
a new itype for the item to have while on display (optional)
108
109
=head2 staff_note
110
111
  data_type: 'mediumtext'
112
  is_nullable: 1
113
114
staff note for the display
115
116
=head2 public_note
117
118
  data_type: 'mediumtext'
119
  is_nullable: 1
120
121
public note for the display
122
123
=head2 display_days
124
125
  data_type: 'integer'
126
  is_nullable: 1
127
128
default number of days items will remain on display
129
130
=head2 display_return_over
131
132
  data_type: 'enum'
133
  default_value: 'no'
134
  extra: {list => ["yes - any library","yes - except at home library","no"]}
135
  is_nullable: 0
136
137
should the item be removed from the display when it is returned
138
139
=cut
140
141
__PACKAGE__->add_columns(
142
  "display_id",
143
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
144
  "display_name",
145
  { data_type => "varchar", is_nullable => 1, size => 255 },
146
  "start_date",
147
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
148
  "end_date",
149
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
150
  "enabled",
151
  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
152
  "display_location",
153
  { data_type => "varchar", is_nullable => 1, size => 80 },
154
  "display_code",
155
  { data_type => "varchar", is_nullable => 1, size => 80 },
156
  "display_branch",
157
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
158
  "display_holding_branch",
159
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
160
  "display_itype",
161
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
162
  "staff_note",
163
  { data_type => "mediumtext", is_nullable => 1 },
164
  "public_note",
165
  { data_type => "mediumtext", is_nullable => 1 },
166
  "display_days",
167
  { data_type => "integer", is_nullable => 1 },
168
  "display_return_over",
169
  {
170
    data_type => "enum",
171
    default_value => "no",
172
    extra => {
173
      list => ["yes - any library", "yes - except at home library", "no"],
174
    },
175
    is_nullable => 0,
176
  },
177
);
178
179
=head1 PRIMARY KEY
180
181
=over 4
182
183
=item * L</display_id>
184
185
=back
186
187
=cut
188
189
__PACKAGE__->set_primary_key("display_id");
190
191
=head1 RELATIONS
192
193
=head2 display_branch
194
195
Type: belongs_to
196
197
Related object: L<Koha::Schema::Result::Branch>
198
199
=cut
200
201
__PACKAGE__->belongs_to(
202
  "display_branch",
203
  "Koha::Schema::Result::Branch",
204
  { branchcode => "display_branch" },
205
  {
206
    is_deferrable => 1,
207
    join_type     => "LEFT",
208
    on_delete     => "CASCADE",
209
    on_update     => "CASCADE",
210
  },
211
);
212
213
=head2 display_holding_branch
214
215
Type: belongs_to
216
217
Related object: L<Koha::Schema::Result::Branch>
218
219
=cut
220
221
__PACKAGE__->belongs_to(
222
  "display_holding_branch",
223
  "Koha::Schema::Result::Branch",
224
  { branchcode => "display_holding_branch" },
225
  {
226
    is_deferrable => 1,
227
    join_type     => "LEFT",
228
    on_delete     => "CASCADE",
229
    on_update     => "CASCADE",
230
  },
231
);
232
233
=head2 display_items
234
235
Type: has_many
236
237
Related object: L<Koha::Schema::Result::DisplayItem>
238
239
=cut
240
241
__PACKAGE__->has_many(
242
  "display_items",
243
  "Koha::Schema::Result::DisplayItem",
244
  { "foreign.display_id" => "self.display_id" },
245
  { cascade_copy => 0, cascade_delete => 0 },
246
);
247
248
=head2 display_itype
249
250
Type: belongs_to
251
252
Related object: L<Koha::Schema::Result::Itemtype>
253
254
=cut
255
256
__PACKAGE__->belongs_to(
257
  "display_itype",
258
  "Koha::Schema::Result::Itemtype",
259
  { itemtype => "display_itype" },
260
  {
261
    is_deferrable => 1,
262
    join_type     => "LEFT",
263
    on_delete     => "CASCADE",
264
    on_update     => "CASCADE",
265
  },
266
);
267
268
269
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-29 13:35:51
270
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mzpC+5bt7kie1FjMxakfoQ
271
272
273
# You can replace this text with custom code or comments, and it will be preserved on regeneration
274
1;
(-)a/Koha/Schema/Result/DisplayItem.pm (+182 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::DisplayItem;
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::DisplayItem
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<display_items>
19
20
=cut
21
22
__PACKAGE__->table("display_items");
23
24
=head1 ACCESSORS
25
26
=head2 display_item_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
primary key
33
34
=head2 display_id
35
36
  data_type: 'integer'
37
  is_foreign_key: 1
38
  is_nullable: 0
39
40
foreign key to link to displays.display_id
41
42
=head2 itemnumber
43
44
  data_type: 'integer'
45
  is_foreign_key: 1
46
  is_nullable: 1
47
48
items.itemnumber for the item on display
49
50
=head2 biblionumber
51
52
  data_type: 'integer'
53
  is_foreign_key: 1
54
  is_nullable: 1
55
56
biblio.biblionumber for the bibliographic record on display
57
58
=head2 date_added
59
60
  data_type: 'date'
61
  datetime_undef_if_invalid: 1
62
  is_nullable: 1
63
64
the date the item was added to the display
65
66
=head2 date_remove
67
68
  data_type: 'date'
69
  datetime_undef_if_invalid: 1
70
  is_nullable: 1
71
72
the date the item should be removed from the display
73
74
=cut
75
76
__PACKAGE__->add_columns(
77
  "display_item_id",
78
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
79
  "display_id",
80
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
81
  "itemnumber",
82
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
83
  "biblionumber",
84
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
85
  "date_added",
86
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
87
  "date_remove",
88
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
89
);
90
91
=head1 PRIMARY KEY
92
93
=over 4
94
95
=item * L</display_item_id>
96
97
=back
98
99
=cut
100
101
__PACKAGE__->set_primary_key("display_item_id");
102
103
=head1 UNIQUE CONSTRAINTS
104
105
=head2 C<display_items_uniq>
106
107
=over 4
108
109
=item * L</display_id>
110
111
=item * L</itemnumber>
112
113
=back
114
115
=cut
116
117
__PACKAGE__->add_unique_constraint("display_items_uniq", ["display_id", "itemnumber"]);
118
119
=head1 RELATIONS
120
121
=head2 biblionumber
122
123
Type: belongs_to
124
125
Related object: L<Koha::Schema::Result::Biblio>
126
127
=cut
128
129
__PACKAGE__->belongs_to(
130
  "biblionumber",
131
  "Koha::Schema::Result::Biblio",
132
  { biblionumber => "biblionumber" },
133
  {
134
    is_deferrable => 1,
135
    join_type     => "LEFT",
136
    on_delete     => "CASCADE",
137
    on_update     => "CASCADE",
138
  },
139
);
140
141
=head2 display
142
143
Type: belongs_to
144
145
Related object: L<Koha::Schema::Result::Display>
146
147
=cut
148
149
__PACKAGE__->belongs_to(
150
  "display",
151
  "Koha::Schema::Result::Display",
152
  { display_id => "display_id" },
153
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
154
);
155
156
=head2 itemnumber
157
158
Type: belongs_to
159
160
Related object: L<Koha::Schema::Result::Item>
161
162
=cut
163
164
__PACKAGE__->belongs_to(
165
  "itemnumber",
166
  "Koha::Schema::Result::Item",
167
  { itemnumber => "itemnumber" },
168
  {
169
    is_deferrable => 1,
170
    join_type     => "LEFT",
171
    on_delete     => "CASCADE",
172
    on_update     => "CASCADE",
173
  },
174
);
175
176
177
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-15 08:07:04
178
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uKlpm8iZfGnGRJPmQKUO2w
179
180
181
# You can replace this text with custom code or comments, and it will be preserved on regeneration
182
1;
(-)a/Koha/Schema/Result/Item.pm (-2 / +25 lines)
Lines 710-715 __PACKAGE__->has_many( Link Here
710
  { cascade_copy => 0, cascade_delete => 0 },
710
  { cascade_copy => 0, cascade_delete => 0 },
711
);
711
);
712
712
713
=head2 display_items
714
715
Type: has_many
716
717
Related object: L<Koha::Schema::Result::DisplayItem>
718
719
=cut
720
721
__PACKAGE__->has_many(
722
  "display_items",
723
  "Koha::Schema::Result::DisplayItem",
724
  { "foreign.itemnumber" => "self.itemnumber" },
725
  { cascade_copy => 0, cascade_delete => 0 },
726
);
727
713
=head2 hold_fill_target
728
=head2 hold_fill_target
714
729
715
Type: might_have
730
Type: might_have
Lines 991-998 __PACKAGE__->might_have( Link Here
991
);
1006
);
992
1007
993
1008
994
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-04-28 16:41:47
1009
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-15 08:07:04
995
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hGbnnGBWKaKzsVipsyN7ww
1010
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VketnoTyGAI2v9LPYgpwpQ
996
1011
997
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
1012
__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
998
1013
Lines 1068-1073 __PACKAGE__->has_many( Link Here
1068
# Relationship with bundled items
1083
# Relationship with bundled items
1069
__PACKAGE__->many_to_many( bundle_items => 'item_bundles_hosts', 'item' );
1084
__PACKAGE__->many_to_many( bundle_items => 'item_bundles_hosts', 'item' );
1070
1085
1086
# Relationship with display items
1087
__PACKAGE__->has_many(
1088
  "display_items",
1089
  "Koha::Schema::Result::DisplayItem",
1090
  { "foreign.itemnumber" => "self.itemnumber" },
1091
  { cascade_copy => 0, cascade_delete => 0 },
1092
);
1093
1071
__PACKAGE__->might_have(
1094
__PACKAGE__->might_have(
1072
  "last_returned_by",
1095
  "last_returned_by",
1073
  "Koha::Schema::Result::ItemsLastBorrower",
1096
  "Koha::Schema::Result::ItemsLastBorrower",
(-)a/Koha/Schema/Result/Itemtype.pm (-2 / +17 lines)
Lines 279-284 __PACKAGE__->has_many( Link Here
279
  { cascade_copy => 0, cascade_delete => 0 },
279
  { cascade_copy => 0, cascade_delete => 0 },
280
);
280
);
281
281
282
=head2 displays
283
284
Type: has_many
285
286
Related object: L<Koha::Schema::Result::Display>
287
288
=cut
289
290
__PACKAGE__->has_many(
291
  "displays",
292
  "Koha::Schema::Result::Display",
293
  { "foreign.display_itype" => "self.itemtype" },
294
  { cascade_copy => 0, cascade_delete => 0 },
295
);
296
282
=head2 itemtypes
297
=head2 itemtypes
283
298
284
Type: has_many
299
Type: has_many
Lines 360-367 __PACKAGE__->has_many( Link Here
360
);
375
);
361
376
362
377
363
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-20 19:06:37
378
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-23 15:28:32
364
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T/3QdCb353e+qBkN4as7Bg
379
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VPPDv7J9Bx/ldgiKsAhAew
365
380
366
__PACKAGE__->add_columns(
381
__PACKAGE__->add_columns(
367
    '+automatic_checkin'            => { is_boolean => 1 },
382
    '+automatic_checkin'            => { is_boolean => 1 },
(-)a/Koha/Schema/Result/LibraryGroup.pm (-3 / +12 lines)
Lines 111-116 Use this group to identify libraries as pick up location for holds Link Here
111
111
112
Use this group to identify libraries as part of float group
112
Use this group to identify libraries as part of float group
113
113
114
=head2 ft_display_group
115
116
  data_type: 'tinyint'
117
  default_value: 0
118
  is_nullable: 0
119
120
Use this group to identify libraries that can share display items
121
114
=head2 created_on
122
=head2 created_on
115
123
116
  data_type: 'timestamp'
124
  data_type: 'timestamp'
Lines 153-158 __PACKAGE__->add_columns( Link Here
153
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
161
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
154
  "ft_local_float_group",
162
  "ft_local_float_group",
155
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
163
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
164
  "ft_display_group",
165
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
156
  "created_on",
166
  "created_on",
157
  {
167
  {
158
    data_type => "timestamp",
168
    data_type => "timestamp",
Lines 266-273 __PACKAGE__->belongs_to( Link Here
266
);
276
);
267
277
268
278
269
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-04-28 16:41:47
279
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-10-15 08:07:04
270
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CkZe+3Qm2ZlmoSmXBGChag
280
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vJU7IJYCgYXrghYG+VtGxg
271
281
272
=head2 koha_object_class
282
=head2 koha_object_class
273
283
274
- 

Return to bug 14962