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

(-)a/Koha/Schema/Result/Issue.pm (-4 / +4 lines)
Lines 86-92 __PACKAGE__->table("issues"); Link Here
86
86
87
  data_type: 'varchar'
87
  data_type: 'varchar'
88
  is_nullable: 1
88
  is_nullable: 1
89
  size: 16
89
  size: 32
90
90
91
=head2 timestamp
91
=head2 timestamp
92
92
Lines 143-149 __PACKAGE__->add_columns( Link Here
143
  "auto_renew",
143
  "auto_renew",
144
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
144
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
145
  "auto_renew_error",
145
  "auto_renew_error",
146
  { data_type => "varchar", is_nullable => 1, size => 16 },
146
  { data_type => "varchar", is_nullable => 1, size => 32 },
147
  "timestamp",
147
  "timestamp",
148
  {
148
  {
149
    data_type => "timestamp",
149
    data_type => "timestamp",
Lines 230-237 __PACKAGE__->belongs_to( Link Here
230
);
230
);
231
231
232
232
233
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-29 15:31:46
233
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-26 17:45:37
234
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/T5nt8qhlT6ocUG6A9JNIw
234
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KbaJdrP97aSR5zgr/Z1V1w
235
235
236
__PACKAGE__->belongs_to(
236
__PACKAGE__->belongs_to(
237
    "borrower",
237
    "borrower",
(-)a/Koha/Schema/Result/OldIssue.pm (-2 / +10 lines)
Lines 81-86 __PACKAGE__->table("old_issues"); Link Here
81
  default_value: 0
81
  default_value: 0
82
  is_nullable: 1
82
  is_nullable: 1
83
83
84
=head2 auto_renew_error
85
86
  data_type: 'varchar'
87
  is_nullable: 1
88
  size: 32
89
84
=head2 timestamp
90
=head2 timestamp
85
91
86
  data_type: 'timestamp'
92
  data_type: 'timestamp'
Lines 135-140 __PACKAGE__->add_columns( Link Here
135
  { data_type => "tinyint", is_nullable => 1 },
141
  { data_type => "tinyint", is_nullable => 1 },
136
  "auto_renew",
142
  "auto_renew",
137
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
143
  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
144
  "auto_renew_error",
145
  { data_type => "varchar", is_nullable => 1, size => 32 },
138
  "timestamp",
146
  "timestamp",
139
  {
147
  {
140
    data_type => "timestamp",
148
    data_type => "timestamp",
Lines 207-214 __PACKAGE__->belongs_to( Link Here
207
);
215
);
208
216
209
217
210
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-23 13:04:51
218
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-26 17:45:37
211
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9GdzytyInRcFZns/q0qb3Q
219
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:st1nw6s5av9YpGu5WndwFw
212
220
213
221
214
# You can replace this text with custom content, and it will be preserved on regeneration
222
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/installer/data/mysql/atomicupdate/bug_XXXXX.sql (+23 lines)
Line 0 Link Here
1
ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
2
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
3
4
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals', 
5
"Dear [% borrower.firstname %] [% borrower.surname %],
6
[% IF checkout.auto_renew_error %]
7
The following item [% biblio.title %] has not been correctly renewed
8
[% IF checkout.auto_renew_error == 'too_many' %]
9
You have reach the maximum of checkouts possible.
10
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
11
This item is on hold for another patron.
12
[% ELSIF checkout.auto_renew_error == 'restriction' %]
13
You are currently restricted.
14
[% ELSIF checkout.auto_renew_error == 'overdue' %]
15
You have overdues.
16
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
17
It\'s too late to renew this checkout.
18
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
19
You have too much unpaid fines.
20
[% END %]
21
[% ELSE %]
22
The following item [% biblio.title %] as correctly been renewed.
23
[% END %]", 'email');
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 1164-1169 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1164
  `return` varchar(4) default NULL,
1164
  `return` varchar(4) default NULL,
1165
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1165
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1166
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1166
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1167
  `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1167
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1168
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1168
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1169
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1169
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1170
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
Lines 1667-1672 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1667
  `return` varchar(4) default NULL,
1668
  `return` varchar(4) default NULL,
1668
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1669
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1669
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1670
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1671
  `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1670
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1672
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1671
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1673
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1672
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1674
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1673
- 

Return to bug 15705