Attachment 26728 Details for Bug 7413 – Bug 7413: Add issuingrules.norenewalbefore to database

[patch] Bug 7413: Add issuingrules.norenewalbefore to database

Bug-7413-Add-issuingrulesnorenewalbefore-to-databa.patch (text/plain), 2.70 KB, created by Brendan Gallagher on 2014-04-01 21:56:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Brendan Gallagher

Created: 2014-04-01 21:56:30 UTC

Size: 2.70 KB

patch

obsolete

>From 935636c8724dd5169d734e51a3d9c7bc690fa8a3 Mon Sep 17 00:00:00 2001
>From: =?UTF-8?q?Holger=20Mei=C3=9Fner?= <h.meissner.82@web.de>
>Date: Wed, 12 Feb 2014 16:53:06 +0100
>Subject: [PATCH] Bug 7413: Add issuingrules.norenewalbefore to database
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>Currently multiple renewals can be done in immediate succsession.
>To optionally prevent this, a new parameter "No renewal before"
>is introduced.
>
>This patch adds issuingrules.norenewalbefore to the database.
>Default value is NULL.
>
>To test:
>1) Run installer/data/mysql/updatedatabase.pl
>2) Create a SQL report like:
>   SELECT * FROM issuingrules
>3) Confirm that norenewalbefore was added after renewalperiod.
>
>Sponsored-by: Hochschule fÃ¼r Gesundheit (hsg), Germany
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com>
>---
> installer/data/mysql/kohastructure.sql |    1 +
> installer/data/mysql/updatedatabase.pl |    9 +++++++++
> 2 files changed, 10 insertions(+)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 3cf9c65..3b12e1b 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1155,6 +1155,7 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules
>   `hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before)
>   `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
>   `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit
>+  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit
>   `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
>   `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
>   overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 062ecc1..971e71d 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8083,6 +8083,15 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.15.00.XXX";
>+if(CheckVersion($DBversion)) {
>+    $dbh->do(q{
>+        ALTER TABLE issuingrules ADD norenewalbefore int(4) default NULL AFTER renewalperiod
>+    });
>+    print "Upgrade to $DBversion done (Bug 7413: Allow OPAC renewal x days before due date)\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 7413: 24685 | 24686 | 24687 | 24688 | 24689 | 24926 | 24927 | 24928 | 24929 | 24930 | 25166 | 25247 | 25248 | 25249 | 25250 | 25251 | 25252 | 25855 | 25856 | 25857 | 25858 | 25859 | 25860 | 26726 | 26727 | 26728 | 26729 | 26730 | 26731 | 26732 | 26733