Attachment 15834 Details for Bug 9722 – Bug 9722: Allow users to add notes when placing a hold in opac (dbrev)

[patch] Bug 9722: Allow users to add notes when placing a hold in opac (dbrev)

Bug-9722-Allow-users-to-add-notes-when-placing-a-h.patch (text/plain), 2.59 KB, created by Marcel de Rooy on 2013-03-04 06:52:34 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2013-03-04 06:52:34 UTC

Size: 2.59 KB

patch

obsolete

>From b84fbcf1beb8680a556e017c4ef74f81ddd92896 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Thu, 28 Feb 2013 08:53:36 +0100
>Subject: [PATCH] Bug 9722: Allow users to add notes when placing a hold in
> opac (dbrev)
>Content-Type: text/plain; charset="utf-8"
>
>Database revision for report 9722, adding new pref OpacShowHoldNotes.
>This development is part of a larger one (see umbrella report 9721).
>
>Test plan:
>Run [your server]/cgi-bin/koha/installer/install.pl?step=3&op=updatestructure
>Optionally, run a new install to test sysprefs.sql.
>Or:
>Edit sysprefs.sql, leave at least the last few lines including the new one.
>And run from command line:  mysql -p [yourdatabase] < [your-clone]/installer/data/mysql/sysprefs.sql
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> installer/data/mysql/sysprefs.sql      |    1 +
> installer/data/mysql/updatedatabase.pl |    9 +++++++++
> 2 files changed, 10 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index ca9b6bd..b320bda 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -416,3 +416,4 @@ INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES (
> INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('IntranetNumbersPreferPhrase','0', NULL, 'Control the use of phr operator in callnumber and standard number staff client searches', 'YesNo');
> INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UNIMARCField100Language', 'fre','UNIMARC field 100 default language',NULL,'short');
> INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('Persona',0,'Use Mozilla Persona for login','','YesNo');
>+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacShowHoldNotes',0,'Show hold notes on OPAC','','YesNo');
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 7e5e243..59d440b 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -6444,6 +6444,15 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.11.00.XXX";
>+if(CheckVersion($DBversion)) {
>+    $dbh->do(
>+"INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacShowHoldNotes',0,'Show hold notes on OPAC','','YesNo')"
>+    );
>+    print "Upgrade to $DBversion done (Bug 9722: Allow users to add notes when placing a hold in OPAC)\n";
>+    SetVersion($DBversion);
>+}
>+
> 
> =head1 FUNCTIONS
> 
>-- 
>1.7.7.6

Actions: View | Diff | Splinter Review

Attachments on bug 9722: 15752 | 15753 | 15806 | 15807 | 15808 | 15834 | 15836 | 17717 | 17718 | 17719 | 17726 | 18342 | 18343 | 18344