Attachment 50345 Details for Bug 15705 – Bug 15705: DB Changes - Add [old_]issues.auto_renew_error and the AUTO_RENEWALS notice

[patch] Bug 15705: DB Changes - Add [old_]issues.auto_renew_error and the AUTO_RENEWALS notice

Bug-15705-DB-Changes---Add-oldissuesautorenewerror.patch (text/plain), 3.43 KB, created by Jonathan Druart on 2016-04-18 15:26:55 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-04-18 15:26:55 UTC

Size: 3.43 KB

patch

obsolete

>From 77c593e007289ec21624279c81388082c84b131a Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Fri, 29 Jan 2016 17:13:17 +0000
>Subject: [PATCH] Bug 15705: DB Changes - Add [old_]issues.auto_renew_error and
> the AUTO_RENEWALS notice
>
>---
> installer/data/mysql/atomicupdate/bug_XXXXX.sql | 23 +++++++++++++++++++++++
> installer/data/mysql/kohastructure.sql          |  2 ++
> 2 files changed, 25 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_XXXXX.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_XXXXX.sql b/installer/data/mysql/atomicupdate/bug_XXXXX.sql
>new file mode 100644
>index 0000000..f98566c
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_XXXXX.sql
>@@ -0,0 +1,23 @@
>+ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
>+ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(16) 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');
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index e7d8669..267f6e5 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1166,6 +1166,7 @@ CREATE TABLE `issues` ( -- information related to check outs or issues
>   `return` varchar(4) default NULL,
>   `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
>   `auto_renew` BOOLEAN default FALSE, -- automatic renewal
>+  `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
>   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
>   `issuedate` datetime default NULL, -- date the item was checked out or issued
>   `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
>@@ -1667,6 +1668,7 @@ CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r
>   `return` varchar(4) default NULL,
>   `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
>   `auto_renew` BOOLEAN default FALSE, -- automatic renewal
>+  `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
>   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
>   `issuedate` datetime default NULL, -- date the item was checked out or issued
>   `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
>-- 
>2.7.0

Actions: View | Diff | Splinter Review

Attachments on bug 15705: 47470 | 47471 | 47472 | 50336 | 50337 | 50338 | 50341 | 50342 | 50344 | 50345 | 50346 | 50680 | 50681 | 50682 | 50683 | 50732 | 50733 | 56756 | 56757 | 56758 | 56759 | 56760 | 56798 | 56799 | 56981 | 56983 | 57741 | 57742 | 57743 | 57744 | 57745 | 57746 | 57747 | 61080 | 61081 | 61082 | 61083 | 61084 | 61085 | 61086 | 61495 | 61496 | 61497 | 61498 | 61499 | 61500 | 61501 | 61739 | 62072 | 63036 | 63037 | 63138 | 63139 | 63140 | 63141 | 63142 | 63143 | 63144