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

(-)a/installer/data/mysql/atomicupdate/bug_15705.sql (+23 lines)
Line 0 Link Here
1
ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;
2
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(32) 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 1751-1756 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1751
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1751
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1752
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1752
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1753
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1753
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1754
  `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1754
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1755
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1755
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1756
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1756
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1757
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
Lines 1781-1786 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1781
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1782
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1782
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1783
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1783
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1784
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1785
  `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1784
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1786
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1785
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1787
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1786
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1788
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1787
- 

Return to bug 15705