Attachment #63143 for bug #15705

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




ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item [% biblio.title %] has not been correctly renewed
[% IF checkout.auto_renew_error == 'too_many' %]
You have reach the maximum of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdues.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this checkout.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
You have too much unpaid fines.
[% END %]
[% ELSE %]
The following item [% biblio.title %] as correctly been renewed.
[% END %]", 'email');

Return to bug 15705

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_15705.sql (+23 lines)
	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');

Lines 1751-1756 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
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	-