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

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +32 lines)
Lines 1258-1263 __PACKAGE__->has_many( Link Here
1258
  { cascade_copy => 0, cascade_delete => 0 },
1258
  { cascade_copy => 0, cascade_delete => 0 },
1259
);
1259
);
1260
1260
1261
=head2 curbside_pickups_borrowernumbers
1262
1263
Type: has_many
1264
1265
Related object: L<Koha::Schema::Result::CurbsidePickup>
1266
1267
=cut
1268
1269
__PACKAGE__->has_many(
1270
  "curbside_pickups_borrowernumbers",
1271
  "Koha::Schema::Result::CurbsidePickup",
1272
  { "foreign.borrowernumber" => "self.borrowernumber" },
1273
  { cascade_copy => 0, cascade_delete => 0 },
1274
);
1275
1276
=head2 curbside_pickups_staged_by
1277
1278
Type: has_many
1279
1280
Related object: L<Koha::Schema::Result::CurbsidePickup>
1281
1282
=cut
1283
1284
__PACKAGE__->has_many(
1285
  "curbside_pickups_staged_by",
1286
  "Koha::Schema::Result::CurbsidePickup",
1287
  { "foreign.staged_by" => "self.borrowernumber" },
1288
  { cascade_copy => 0, cascade_delete => 0 },
1289
);
1290
1261
=head2 discharges
1291
=head2 discharges
1262
1292
1263
Type: has_many
1293
Type: has_many
Lines 1989-1996 Composing rels: L</user_permissions> -> permission Link Here
1989
__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
2019
__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
1990
2020
1991
2021
1992
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-07-05 12:41:19
2022
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-07-07 12:48:35
1993
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e5ZH2Ise5JLYRXrq22L9rw
2023
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iffysIl9TxAnXVzpWiUJuw
1994
2024
1995
__PACKAGE__->has_many(
2025
__PACKAGE__->has_many(
1996
  "extended_attributes",
2026
  "extended_attributes",
(-)a/Koha/Schema/Result/Branch.pm (-2 / +32 lines)
Lines 611-616 __PACKAGE__->has_many( Link Here
611
  { cascade_copy => 0, cascade_delete => 0 },
611
  { cascade_copy => 0, cascade_delete => 0 },
612
);
612
);
613
613
614
=head2 curbside_pickup_policy
615
616
Type: might_have
617
618
Related object: L<Koha::Schema::Result::CurbsidePickupPolicy>
619
620
=cut
621
622
__PACKAGE__->might_have(
623
  "curbside_pickup_policy",
624
  "Koha::Schema::Result::CurbsidePickupPolicy",
625
  { "foreign.branchcode" => "self.branchcode" },
626
  { cascade_copy => 0, cascade_delete => 0 },
627
);
628
629
=head2 curbside_pickups
630
631
Type: has_many
632
633
Related object: L<Koha::Schema::Result::CurbsidePickup>
634
635
=cut
636
637
__PACKAGE__->has_many(
638
  "curbside_pickups",
639
  "Koha::Schema::Result::CurbsidePickup",
640
  { "foreign.branchcode" => "self.branchcode" },
641
  { cascade_copy => 0, cascade_delete => 0 },
642
);
643
614
=head2 desks
644
=head2 desks
615
645
616
Type: has_many
646
Type: has_many
Lines 882-889 __PACKAGE__->has_many( Link Here
882
);
912
);
883
913
884
914
885
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2022-03-28 22:07:59
915
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-27 11:58:43
886
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kpv55lV6FRGoxxu5nufXhg
916
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1m1v0sml/1gBHxAkQl8BaA
887
917
888
__PACKAGE__->add_columns(
918
__PACKAGE__->add_columns(
889
    '+pickup_location' => { is_boolean => 1 },
919
    '+pickup_location' => { is_boolean => 1 },
(-)a/Koha/Schema/Result/CurbsidePickup.pm (+211 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::CurbsidePickup;
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::CurbsidePickup
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<curbside_pickups>
19
20
=cut
21
22
__PACKAGE__->table("curbside_pickups");
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 borrowernumber
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 branchcode
39
40
  data_type: 'varchar'
41
  is_foreign_key: 1
42
  is_nullable: 0
43
  size: 10
44
45
=head2 scheduled_pickup_datetime
46
47
  data_type: 'datetime'
48
  datetime_undef_if_invalid: 1
49
  is_nullable: 0
50
51
=head2 staged_datetime
52
53
  data_type: 'datetime'
54
  datetime_undef_if_invalid: 1
55
  is_nullable: 1
56
57
=head2 staged_by
58
59
  data_type: 'integer'
60
  is_foreign_key: 1
61
  is_nullable: 1
62
63
=head2 arrival_datetime
64
65
  data_type: 'datetime'
66
  datetime_undef_if_invalid: 1
67
  is_nullable: 1
68
69
=head2 delivered_datetime
70
71
  data_type: 'datetime'
72
  datetime_undef_if_invalid: 1
73
  is_nullable: 1
74
75
=head2 delivered_by
76
77
  data_type: 'integer'
78
  is_nullable: 1
79
80
=head2 notes
81
82
  data_type: 'text'
83
  is_nullable: 1
84
85
=cut
86
87
__PACKAGE__->add_columns(
88
  "id",
89
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
90
  "borrowernumber",
91
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
92
  "branchcode",
93
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
94
  "scheduled_pickup_datetime",
95
  {
96
    data_type => "datetime",
97
    datetime_undef_if_invalid => 1,
98
    is_nullable => 0,
99
  },
100
  "staged_datetime",
101
  {
102
    data_type => "datetime",
103
    datetime_undef_if_invalid => 1,
104
    is_nullable => 1,
105
  },
106
  "staged_by",
107
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
108
  "arrival_datetime",
109
  {
110
    data_type => "datetime",
111
    datetime_undef_if_invalid => 1,
112
    is_nullable => 1,
113
  },
114
  "delivered_datetime",
115
  {
116
    data_type => "datetime",
117
    datetime_undef_if_invalid => 1,
118
    is_nullable => 1,
119
  },
120
  "delivered_by",
121
  { data_type => "integer", is_nullable => 1 },
122
  "notes",
123
  { data_type => "text", is_nullable => 1 },
124
);
125
126
=head1 PRIMARY KEY
127
128
=over 4
129
130
=item * L</id>
131
132
=back
133
134
=cut
135
136
__PACKAGE__->set_primary_key("id");
137
138
=head1 RELATIONS
139
140
=head2 borrowernumber
141
142
Type: belongs_to
143
144
Related object: L<Koha::Schema::Result::Borrower>
145
146
=cut
147
148
__PACKAGE__->belongs_to(
149
  "borrowernumber",
150
  "Koha::Schema::Result::Borrower",
151
  { borrowernumber => "borrowernumber" },
152
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
153
);
154
155
=head2 branchcode
156
157
Type: belongs_to
158
159
Related object: L<Koha::Schema::Result::Branch>
160
161
=cut
162
163
__PACKAGE__->belongs_to(
164
  "branchcode",
165
  "Koha::Schema::Result::Branch",
166
  { branchcode => "branchcode" },
167
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
168
);
169
170
=head2 curbside_pickup_issues
171
172
Type: has_many
173
174
Related object: L<Koha::Schema::Result::CurbsidePickupIssue>
175
176
=cut
177
178
__PACKAGE__->has_many(
179
  "curbside_pickup_issues",
180
  "Koha::Schema::Result::CurbsidePickupIssue",
181
  { "foreign.curbside_pickup_id" => "self.id" },
182
  { cascade_copy => 0, cascade_delete => 0 },
183
);
184
185
=head2 staged_by
186
187
Type: belongs_to
188
189
Related object: L<Koha::Schema::Result::Borrower>
190
191
=cut
192
193
__PACKAGE__->belongs_to(
194
  "staged_by",
195
  "Koha::Schema::Result::Borrower",
196
  { borrowernumber => "staged_by" },
197
  {
198
    is_deferrable => 1,
199
    join_type     => "LEFT",
200
    on_delete     => "SET NULL",
201
    on_update     => "CASCADE",
202
  },
203
);
204
205
206
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-27 11:58:44
207
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8gt7Vqurdid0rwmBMPI5yg
208
209
210
# You can replace this text with custom code or comments, and it will be preserved on regeneration
211
1;
(-)a/Koha/Schema/Result/CurbsidePickupIssue.pm (+96 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::CurbsidePickupIssue;
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::CurbsidePickupIssue
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<curbside_pickup_issues>
19
20
=cut
21
22
__PACKAGE__->table("curbside_pickup_issues");
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 curbside_pickup_id
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 issue_id
39
40
  data_type: 'integer'
41
  is_nullable: 0
42
43
=head2 reserve_id
44
45
  data_type: 'integer'
46
  is_nullable: 0
47
48
=cut
49
50
__PACKAGE__->add_columns(
51
  "id",
52
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
53
  "curbside_pickup_id",
54
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
55
  "issue_id",
56
  { data_type => "integer", is_nullable => 0 },
57
  "reserve_id",
58
  { data_type => "integer", is_nullable => 0 },
59
);
60
61
=head1 PRIMARY KEY
62
63
=over 4
64
65
=item * L</id>
66
67
=back
68
69
=cut
70
71
__PACKAGE__->set_primary_key("id");
72
73
=head1 RELATIONS
74
75
=head2 curbside_pickup
76
77
Type: belongs_to
78
79
Related object: L<Koha::Schema::Result::CurbsidePickup>
80
81
=cut
82
83
__PACKAGE__->belongs_to(
84
  "curbside_pickup",
85
  "Koha::Schema::Result::CurbsidePickup",
86
  { id => "curbside_pickup_id" },
87
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
88
);
89
90
91
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-27 11:58:44
92
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U8r/RLbAi1yGXexYWUYjtQ
93
94
95
# You can replace this text with custom code or comments, and it will be preserved on regeneration
96
1;
(-)a/Koha/Schema/Result/CurbsidePickupOpeningSlot.pm (+117 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::CurbsidePickupOpeningSlot;
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::CurbsidePickupOpeningSlot
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<curbside_pickup_opening_slots>
19
20
=cut
21
22
__PACKAGE__->table("curbside_pickup_opening_slots");
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 curbside_pickup_policy_id
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 day
39
40
  data_type: 'tinyint'
41
  is_nullable: 0
42
43
=head2 start_hour
44
45
  data_type: 'integer'
46
  is_nullable: 0
47
48
=head2 start_minute
49
50
  data_type: 'integer'
51
  is_nullable: 0
52
53
=head2 end_hour
54
55
  data_type: 'integer'
56
  is_nullable: 0
57
58
=head2 end_minute
59
60
  data_type: 'integer'
61
  is_nullable: 0
62
63
=cut
64
65
__PACKAGE__->add_columns(
66
  "id",
67
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
68
  "curbside_pickup_policy_id",
69
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
70
  "day",
71
  { data_type => "tinyint", is_nullable => 0 },
72
  "start_hour",
73
  { data_type => "integer", is_nullable => 0 },
74
  "start_minute",
75
  { data_type => "integer", is_nullable => 0 },
76
  "end_hour",
77
  { data_type => "integer", is_nullable => 0 },
78
  "end_minute",
79
  { data_type => "integer", is_nullable => 0 },
80
);
81
82
=head1 PRIMARY KEY
83
84
=over 4
85
86
=item * L</id>
87
88
=back
89
90
=cut
91
92
__PACKAGE__->set_primary_key("id");
93
94
=head1 RELATIONS
95
96
=head2 curbside_pickup_policy
97
98
Type: belongs_to
99
100
Related object: L<Koha::Schema::Result::CurbsidePickupPolicy>
101
102
=cut
103
104
__PACKAGE__->belongs_to(
105
  "curbside_pickup_policy",
106
  "Koha::Schema::Result::CurbsidePickupPolicy",
107
  { id => "curbside_pickup_policy_id" },
108
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
109
);
110
111
112
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-27 11:58:44
113
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5kzC0AAB9LL0gR+FFnmYgw
114
115
116
# You can replace this text with custom code or comments, and it will be preserved on regeneration
117
1;
(-)a/Koha/Schema/Result/CurbsidePickupPolicy.pm (-1 / +152 lines)
Line 0 Link Here
0
- 
1
use utf8;
2
package Koha::Schema::Result::CurbsidePickupPolicy;
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::CurbsidePickupPolicy
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<curbside_pickup_policy>
19
20
=cut
21
22
__PACKAGE__->table("curbside_pickup_policy");
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 branchcode
33
34
  data_type: 'varchar'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
  size: 10
38
39
=head2 enabled
40
41
  data_type: 'tinyint'
42
  default_value: 0
43
  is_nullable: 0
44
45
=head2 enable_waiting_holds_only
46
47
  data_type: 'tinyint'
48
  default_value: 0
49
  is_nullable: 0
50
51
=head2 pickup_interval
52
53
  data_type: 'integer'
54
  default_value: 0
55
  is_nullable: 0
56
57
=head2 patrons_per_interval
58
59
  data_type: 'integer'
60
  default_value: 0
61
  is_nullable: 0
62
63
=head2 patron_scheduled_pickup
64
65
  data_type: 'tinyint'
66
  default_value: 0
67
  is_nullable: 0
68
69
=cut
70
71
__PACKAGE__->add_columns(
72
  "id",
73
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
74
  "branchcode",
75
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
76
  "enabled",
77
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
78
  "enable_waiting_holds_only",
79
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
80
  "pickup_interval",
81
  { data_type => "integer", default_value => 0, is_nullable => 0 },
82
  "patrons_per_interval",
83
  { data_type => "integer", default_value => 0, is_nullable => 0 },
84
  "patron_scheduled_pickup",
85
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
86
);
87
88
=head1 PRIMARY KEY
89
90
=over 4
91
92
=item * L</id>
93
94
=back
95
96
=cut
97
98
__PACKAGE__->set_primary_key("id");
99
100
=head1 UNIQUE CONSTRAINTS
101
102
=head2 C<branchcode>
103
104
=over 4
105
106
=item * L</branchcode>
107
108
=back
109
110
=cut
111
112
__PACKAGE__->add_unique_constraint("branchcode", ["branchcode"]);
113
114
=head1 RELATIONS
115
116
=head2 branchcode
117
118
Type: belongs_to
119
120
Related object: L<Koha::Schema::Result::Branch>
121
122
=cut
123
124
__PACKAGE__->belongs_to(
125
  "branchcode",
126
  "Koha::Schema::Result::Branch",
127
  { branchcode => "branchcode" },
128
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
129
);
130
131
=head2 curbside_pickup_opening_slots
132
133
Type: has_many
134
135
Related object: L<Koha::Schema::Result::CurbsidePickupOpeningSlot>
136
137
=cut
138
139
__PACKAGE__->has_many(
140
  "curbside_pickup_opening_slots",
141
  "Koha::Schema::Result::CurbsidePickupOpeningSlot",
142
  { "foreign.curbside_pickup_policy_id" => "self.id" },
143
  { cascade_copy => 0, cascade_delete => 0 },
144
);
145
146
147
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-06-27 11:58:44
148
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RyZGROB1+g3kb2bo6mwrUQ
149
150
151
# You can replace this text with custom code or comments, and it will be preserved on regeneration
152
1;

Return to bug 30650