Attachment #172632 for bug #10190

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




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 overduerules_transport_types

Type: has_many

Related object: L<Koha::Schema::Result::OverduerulesTransportType>

=cut

__PACKAGE__->has_many(
  "overduerules_transport_types",
  "Koha::Schema::Result::OverduerulesTransportType",
  {
    "foreign.message_transport_type" => "self.message_transport_type",
  },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 borrower_message_preferences

Type: many_to_many

);


# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-08-15 11:53:13
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Bx96QiqHxZ9SNbgK8dSwMg


# You can replace this text with custom content, and it will be preserved on regeneration




use utf8;
package Koha::Schema::Result::Overduerule;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::Overduerule

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<overduerules>

=cut

__PACKAGE__->table("overduerules");

=head1 ACCESSORS

=head2 overduerules_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique identifier for the overduerules

=head2 branchcode

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

foreign key from the branches table to define which branch this rule is for (if blank it's all libraries)

=head2 categorycode

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

foreign key from the categories table to define which patron category this rule is for

=head2 delay1

  data_type: 'integer'
  is_nullable: 1

number of days after the item is overdue that the first notice is sent

=head2 letter1

  data_type: 'varchar'
  is_nullable: 1
  size: 20

foreign key from the letter table to define which notice should be sent as the first notice

=head2 debarred1

  data_type: 'varchar'
  default_value: 0
  is_nullable: 1
  size: 1

is the patron restricted when the first notice is sent (1 for yes, 0 for no)

=head2 delay2

  data_type: 'integer'
  is_nullable: 1

number of days after the item is overdue that the second notice is sent

=head2 debarred2

  data_type: 'varchar'
  default_value: 0
  is_nullable: 1
  size: 1

is the patron restricted when the second notice is sent (1 for yes, 0 for no)

=head2 letter2

  data_type: 'varchar'
  is_nullable: 1
  size: 20

foreign key from the letter table to define which notice should be sent as the second notice

=head2 delay3

  data_type: 'integer'
  is_nullable: 1

number of days after the item is overdue that the third notice is sent

=head2 letter3

  data_type: 'varchar'
  is_nullable: 1
  size: 20

foreign key from the letter table to define which notice should be sent as the third notice

=head2 debarred3

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

is the patron restricted when the third notice is sent (1 for yes, 0 for no)

=cut

__PACKAGE__->add_columns(
  "overduerules_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "branchcode",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
  "categorycode",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
  "delay1",
  { data_type => "integer", is_nullable => 1 },
  "letter1",
  { data_type => "varchar", is_nullable => 1, size => 20 },
  "debarred1",
  { data_type => "varchar", default_value => 0, is_nullable => 1, size => 1 },
  "delay2",
  { data_type => "integer", is_nullable => 1 },
  "debarred2",
  { data_type => "varchar", default_value => 0, is_nullable => 1, size => 1 },
  "letter2",
  { data_type => "varchar", is_nullable => 1, size => 20 },
  "delay3",
  { data_type => "integer", is_nullable => 1 },
  "letter3",
  { data_type => "varchar", is_nullable => 1, size => 20 },
  "debarred3",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</overduerules_id>

=back

=cut

__PACKAGE__->set_primary_key("overduerules_id");

=head1 UNIQUE CONSTRAINTS

=head2 C<overduerules_branch_cat>

=over 4

=item * L</branchcode>

=item * L</categorycode>

=back

=cut

__PACKAGE__->add_unique_constraint("overduerules_branch_cat", ["branchcode", "categorycode"]);

=head1 RELATIONS

=head2 overduerules_transport_types

Type: has_many

Related object: L<Koha::Schema::Result::OverduerulesTransportType>

=cut

__PACKAGE__->has_many(
  "overduerules_transport_types",
  "Koha::Schema::Result::OverduerulesTransportType",
  { "foreign.overduerules_id" => "self.overduerules_id" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pORigxtC5qztZWHI29mZ/g

sub koha_object_class {
    'Koha::OverdueRule';
}
sub koha_objects_class {
    'Koha::OverdueRules';
}

1;




use utf8;
package Koha::Schema::Result::OverduerulesTransportType;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::OverduerulesTransportType

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<overduerules_transport_types>

=cut

__PACKAGE__->table("overduerules_transport_types");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 letternumber

  data_type: 'integer'
  default_value: 1
  is_nullable: 0

=head2 message_transport_type

  data_type: 'varchar'
  default_value: 'email'
  is_foreign_key: 1
  is_nullable: 0
  size: 20

=head2 overduerules_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "letternumber",
  { data_type => "integer", default_value => 1, is_nullable => 0 },
  "message_transport_type",
  {
    data_type => "varchar",
    default_value => "email",
    is_foreign_key => 1,
    is_nullable => 0,
    size => 20,
  },
  "overduerules_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 message_transport_type

Type: belongs_to

Related object: L<Koha::Schema::Result::MessageTransportType>

=cut

__PACKAGE__->belongs_to(
  "message_transport_type",
  "Koha::Schema::Result::MessageTransportType",
  { message_transport_type => "message_transport_type" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 overduerule

Type: belongs_to

Related object: L<Koha::Schema::Result::Overduerule>

=cut

__PACKAGE__->belongs_to(
  "overduerule",
  "Koha::Schema::Result::Overduerule",
  { overduerules_id => "overduerules_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-31 15:44:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GV2VZ1kIA9Fl8pQd0qkrjg


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;
- 

Return to bug 10190

Lines 118-140 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/MessageTransportType.pm (-19 / +2 lines)
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 1-208 Link Here

(-)a/Koha/Schema/Result/Overduerule.pm (-208 lines)
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: 'varchar'
70	default_value: 0
71	is_nullable: 1
72	size: 1
73
74	is the patron restricted when the first notice is sent (1 for yes, 0 for no)
75
76	=head2 delay2
77
78	data_type: 'integer'
79	is_nullable: 1
80
81	number of days after the item is overdue that the second notice is sent
82
83	=head2 debarred2
84
85	data_type: 'varchar'
86	default_value: 0
87	is_nullable: 1
88	size: 1
89
90	is the patron restricted when the second notice is sent (1 for yes, 0 for no)
91
92	=head2 letter2
93
94	data_type: 'varchar'
95	is_nullable: 1
96	size: 20
97
98	foreign key from the letter table to define which notice should be sent as the second notice
99
100	=head2 delay3
101
102	data_type: 'integer'
103	is_nullable: 1
104
105	number of days after the item is overdue that the third notice is sent
106
107	=head2 letter3
108
109	data_type: 'varchar'
110	is_nullable: 1
111	size: 20
112
113	foreign key from the letter table to define which notice should be sent as the third notice
114
115	=head2 debarred3
116
117	data_type: 'integer'
118	default_value: 0
119	is_nullable: 1
120
121	is the patron restricted when the third notice is sent (1 for yes, 0 for no)
122
123	=cut
124
125	__PACKAGE__->add_columns(
126	"overduerules_id",
127	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
128	"branchcode",
129	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
130	"categorycode",
131	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
132	"delay1",
133	{ data_type => "integer", is_nullable => 1 },
134	"letter1",
135	{ data_type => "varchar", is_nullable => 1, size => 20 },
136	"debarred1",
137	{ data_type => "varchar", default_value => 0, is_nullable => 1, size => 1 },
138	"delay2",
139	{ data_type => "integer", is_nullable => 1 },
140	"debarred2",
141	{ data_type => "varchar", default_value => 0, is_nullable => 1, size => 1 },
142	"letter2",
143	{ data_type => "varchar", is_nullable => 1, size => 20 },
144	"delay3",
145	{ data_type => "integer", is_nullable => 1 },
146	"letter3",
147	{ data_type => "varchar", is_nullable => 1, size => 20 },
148	"debarred3",
149	{ data_type => "integer", default_value => 0, is_nullable => 1 },
150	);
151
152	=head1 PRIMARY KEY
153
154	=over 4
155
156	=item * L</overduerules_id>
157
158	=back
159
160	=cut
161
162	__PACKAGE__->set_primary_key("overduerules_id");
163
164	=head1 UNIQUE CONSTRAINTS
165
166	=head2 C<overduerules_branch_cat>
167
168	=over 4
169
170	=item * L</branchcode>
171
172	=item * L</categorycode>
173
174	=back
175
176	=cut
177
178	__PACKAGE__->add_unique_constraint("overduerules_branch_cat", ["branchcode", "categorycode"]);
179
180	=head1 RELATIONS
181
182	=head2 overduerules_transport_types
183
184	Type: has_many
185
186	Related object: L<Koha::Schema::Result::OverduerulesTransportType>
187
188	=cut
189
190	__PACKAGE__->has_many(
191	"overduerules_transport_types",
192	"Koha::Schema::Result::OverduerulesTransportType",
193	{ "foreign.overduerules_id" => "self.overduerules_id" },
194	{ cascade_copy => 0, cascade_delete => 0 },
195	);
196
197
198	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
199	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pORigxtC5qztZWHI29mZ/g
200
201	sub koha_object_class {
202	'Koha::OverdueRule';
203	}
204	sub koha_objects_class {
205	'Koha::OverdueRules';
206	}
207
208	1;

Lines 1-121 Link Here

(-)a/Koha/Schema/Result/OverduerulesTransportType.pm (-122 lines)
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
120	# You can replace this text with custom code or comments, and it will be preserved on regeneration
121	1;
122	-