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

(-)a/Koha/Schema/Result/MessageTransportType.pm (-20 / +3 lines)
Lines 118-140 __PACKAGE__->has_many( Link Here
118
  { cascade_copy => 0, cascade_delete => 0 },
118
  { cascade_copy => 0, cascade_delete => 0 },
119
);
119
);
120
120
121
=head2 overduerules_transport_types
122
123
Type: has_many
124
125
Related object: L<Koha::Schema::Result::OverduerulesTransportType>
126
127
=cut
128
129
__PACKAGE__->has_many(
130
  "overduerules_transport_types",
131
  "Koha::Schema::Result::OverduerulesTransportType",
132
  {
133
    "foreign.message_transport_type" => "self.message_transport_type",
134
  },
135
  { cascade_copy => 0, cascade_delete => 0 },
136
);
137
138
=head2 borrower_message_preferences
121
=head2 borrower_message_preferences
139
122
140
Type: many_to_many
123
Type: many_to_many
Lines 150-157 __PACKAGE__->many_to_many( Link Here
150
);
133
);
151
134
152
135
153
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-05-02 18:04:32
136
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-08-15 11:53:13
154
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YpzL/dxDWq//5vqXfvHoVQ
137
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Bx96QiqHxZ9SNbgK8dSwMg
155
138
156
139
157
# You can replace this text with custom content, and it will be preserved on regeneration
140
# You can replace this text with custom content, and it will be preserved on regeneration
Lines 176-179 sub koha_objects_class { Link Here
176
  'Koha::Patron::MessagePreference::Transport::Types';
159
  'Koha::Patron::MessagePreference::Transport::Types';
177
}
160
}
178
161
179
1;
162
1;
(-)a/Koha/Schema/Result/Overduerule.pm (-225 lines)
Lines 1-225 Link Here
1
use utf8;
2
package Koha::Schema::Result::Overduerule;
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::Overduerule
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<overduerules>
19
20
=cut
21
22
__PACKAGE__->table("overduerules");
23
24
=head1 ACCESSORS
25
26
=head2 overduerules_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
unique identifier for the overduerules
33
34
=head2 branchcode
35
36
  data_type: 'varchar'
37
  default_value: (empty string)
38
  is_nullable: 0
39
  size: 10
40
41
foreign key from the branches table to define which branch this rule is for (if blank it's all libraries)
42
43
=head2 categorycode
44
45
  data_type: 'varchar'
46
  default_value: (empty string)
47
  is_nullable: 0
48
  size: 10
49
50
foreign key from the categories table to define which patron category this rule is for
51
52
=head2 delay1
53
54
  data_type: 'integer'
55
  is_nullable: 1
56
57
number of days after the item is overdue that the first notice is sent
58
59
=head2 letter1
60
61
  data_type: 'varchar'
62
  is_nullable: 1
63
  size: 20
64
65
foreign key from the letter table to define which notice should be sent as the first notice
66
67
=head2 debarred1
68
69
  data_type: 'tinyint'
70
  default_value: 0
71
  is_nullable: 1
72
73
is the patron restricted when the first notice is sent (1 for yes, 0 for no)
74
75
=head2 delay2
76
77
  data_type: 'integer'
78
  is_nullable: 1
79
80
number of days after the item is overdue that the second notice is sent
81
82
=head2 debarred2
83
84
  data_type: 'tinyint'
85
  default_value: 0
86
  is_nullable: 1
87
88
is the patron restricted when the second notice is sent (1 for yes, 0 for no)
89
90
=head2 letter2
91
92
  data_type: 'varchar'
93
  is_nullable: 1
94
  size: 20
95
96
foreign key from the letter table to define which notice should be sent as the second notice
97
98
=head2 delay3
99
100
  data_type: 'integer'
101
  is_nullable: 1
102
103
number of days after the item is overdue that the third notice is sent
104
105
=head2 letter3
106
107
  data_type: 'varchar'
108
  is_nullable: 1
109
  size: 20
110
111
foreign key from the letter table to define which notice should be sent as the third notice
112
113
=head2 debarred3
114
115
  data_type: 'tinyint'
116
  default_value: 0
117
  is_nullable: 1
118
119
is the patron restricted when the third notice is sent (1 for yes, 0 for no)
120
121
=cut
122
123
__PACKAGE__->add_columns(
124
  "overduerules_id",
125
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
126
  "branchcode",
127
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
128
  "categorycode",
129
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
130
  "delay1",
131
  { data_type => "integer", is_nullable => 1 },
132
  "letter1",
133
  { data_type => "varchar", is_nullable => 1, size => 20 },
134
  "debarred1",
135
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
136
  "delay2",
137
  { data_type => "integer", is_nullable => 1 },
138
  "debarred2",
139
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
140
  "letter2",
141
  { data_type => "varchar", is_nullable => 1, size => 20 },
142
  "delay3",
143
  { data_type => "integer", is_nullable => 1 },
144
  "letter3",
145
  { data_type => "varchar", is_nullable => 1, size => 20 },
146
  "debarred3",
147
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
148
);
149
150
=head1 PRIMARY KEY
151
152
=over 4
153
154
=item * L</overduerules_id>
155
156
=back
157
158
=cut
159
160
__PACKAGE__->set_primary_key("overduerules_id");
161
162
=head1 UNIQUE CONSTRAINTS
163
164
=head2 C<overduerules_branch_cat>
165
166
=over 4
167
168
=item * L</branchcode>
169
170
=item * L</categorycode>
171
172
=back
173
174
=cut
175
176
__PACKAGE__->add_unique_constraint("overduerules_branch_cat", ["branchcode", "categorycode"]);
177
178
=head1 RELATIONS
179
180
=head2 overduerules_transport_types
181
182
Type: has_many
183
184
Related object: L<Koha::Schema::Result::OverduerulesTransportType>
185
186
=cut
187
188
__PACKAGE__->has_many(
189
  "overduerules_transport_types",
190
  "Koha::Schema::Result::OverduerulesTransportType",
191
  { "foreign.overduerules_id" => "self.overduerules_id" },
192
  { cascade_copy => 0, cascade_delete => 0 },
193
);
194
195
196
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-05-06 16:22:12
197
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/1ZL98jFwZ5PyG4sYSziiA
198
199
__PACKAGE__->add_columns(
200
    '+debarred1' => { is_boolean => 1 },
201
    '+debarred2' => { is_boolean => 1 },
202
    '+debarred3' => { is_boolean => 1 },
203
);
204
205
=head2 koha_object_class
206
207
Missing POD for koha_object_class.
208
209
=cut
210
211
sub koha_object_class {
212
    'Koha::OverdueRule';
213
}
214
215
=head2 koha_objects_class
216
217
Missing POD for koha_objects_class.
218
219
=cut
220
221
sub koha_objects_class {
222
    'Koha::OverdueRules';
223
}
224
225
1;
(-)a/Koha/Schema/Result/OverduerulesTransportType.pm (-124 lines)
Lines 1-123 Link Here
1
use utf8;
2
package Koha::Schema::Result::OverduerulesTransportType;
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::OverduerulesTransportType
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<overduerules_transport_types>
19
20
=cut
21
22
__PACKAGE__->table("overduerules_transport_types");
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 letternumber
33
34
  data_type: 'integer'
35
  default_value: 1
36
  is_nullable: 0
37
38
=head2 message_transport_type
39
40
  data_type: 'varchar'
41
  default_value: 'email'
42
  is_foreign_key: 1
43
  is_nullable: 0
44
  size: 20
45
46
=head2 overduerules_id
47
48
  data_type: 'integer'
49
  is_foreign_key: 1
50
  is_nullable: 0
51
52
=cut
53
54
__PACKAGE__->add_columns(
55
  "id",
56
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
57
  "letternumber",
58
  { data_type => "integer", default_value => 1, is_nullable => 0 },
59
  "message_transport_type",
60
  {
61
    data_type => "varchar",
62
    default_value => "email",
63
    is_foreign_key => 1,
64
    is_nullable => 0,
65
    size => 20,
66
  },
67
  "overduerules_id",
68
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
69
);
70
71
=head1 PRIMARY KEY
72
73
=over 4
74
75
=item * L</id>
76
77
=back
78
79
=cut
80
81
__PACKAGE__->set_primary_key("id");
82
83
=head1 RELATIONS
84
85
=head2 message_transport_type
86
87
Type: belongs_to
88
89
Related object: L<Koha::Schema::Result::MessageTransportType>
90
91
=cut
92
93
__PACKAGE__->belongs_to(
94
  "message_transport_type",
95
  "Koha::Schema::Result::MessageTransportType",
96
  { message_transport_type => "message_transport_type" },
97
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
98
);
99
100
=head2 overduerule
101
102
Type: belongs_to
103
104
Related object: L<Koha::Schema::Result::Overduerule>
105
106
=cut
107
108
__PACKAGE__->belongs_to(
109
  "overduerule",
110
  "Koha::Schema::Result::Overduerule",
111
  { overduerules_id => "overduerules_id" },
112
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
113
);
114
115
116
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-31 15:44:38
117
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GV2VZ1kIA9Fl8pQd0qkrjg
118
119
__PACKAGE__->add_columns(
120
    '+letternumber' => { is_boolean => 0 },
121
);
122
123
1;
124
- 

Return to bug 10190