Attachment 27635 Details for Bug 7673 – Bug 7673: DB Changes - add system preferences

[patch] Bug 7673: DB Changes - add system preferences

Bug-7673-DB-Changes---add-system-preferences.patch (text/plain), 2.97 KB, created by Jonathan Druart on 2014-04-25 14:55:01 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2014-04-25 14:55:01 UTC

Size: 2.97 KB

patch

obsolete

>From 74b6a8d3402ab10a83b962191d5a2e8ec087c386 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@biblibre.com>
>Date: Fri, 25 Apr 2014 16:29:07 +0200
>Subject: [PATCH] Bug 7673: DB Changes - add system preferences
>
>This patch the 2 system preferences SubfieldsToAllowForRestrictedEdition
>and SubfieldsToAllowForRestrictedBatchmod.
>---
> installer/data/mysql/updatedatabase.pl                   |   14 ++++++++++++++
> .../prog/en/modules/admin/preferences/cataloguing.pref   |    6 ++++++
> 2 files changed, 20 insertions(+)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 8917081..53a8b94 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8202,6 +8202,20 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.15.00.XXX";
>+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
>+    $dbh->do(q{
>+        INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('SubfieldsToAllowForRestrictedEdition','','Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j','','Free');
>+    });
>+
>+    $dbh->do(q{
>+        INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('SubfieldsToAllowForRestrictedBatchmod','','Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j','','Free');
>+    });
>+
>+    print "Upgrade to $DBversion done (Bug 7673: Adds new systemp preference SubfieldsToAllowForRestrictedEdition and SubfieldsToAllowForRestrictedBatchmod)\n";
>+    SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref
>index 169aec4..df60bcc 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/cataloguing.pref
>@@ -109,6 +109,12 @@ Cataloging:
>             - pref: UNIMARCField100Language
>               class: short
>             - as default language in the UNIMARC field 100 when creating a new record or in the field plugin.
>+        -
>+            - 'Define a list of subfields for which edition is authorized when edit_items_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j'
>+            - pref: SubfieldsToAllowForRestrictedEdition
>+        -
>+            - 'Define a list of subfields for which edition is authorized when items_batchmod_restricted permission is enabled, separated by spaces. Example: 995$f 995$h 995$j'
>+            - pref: SubfieldsToAllowForRestrictedBatchmod
>     Display:
>         -
>             - 'Separate multiple displayed authors, series or subjects with '
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 7673: 8714 | 9857 | 10360 | 12102 | 13004 | 16225 | 16239 | 16368 | 16371 | 23266 | 23267 | 23270 | 23271 | 26008 | 26009 | 26704 | 26705 | 26722 | 27631 | 27632 | 27633 | 27634 | 27635 | 27636 | 27637 | 27638 | 27640 | 27641 | 28007 | 28008 | 28009 | 28010 | 28011 | 28012 | 28013 | 28014 | 28015 | 29550 | 30910 | 30911 | 30912 | 30913 | 30914 | 30915 | 30916 | 30917 | 30918 | 30919 | 31010 | 31011 | 31012 | 31013 | 31015 | 31016 | 31017 | 31019 | 32200 | 32201 | 32215 | 32217 | 32219 | 32220 | 32222 | 32224 | 32225 | 32226 | 32227 | 32228 | 32928 | 32962 | 32993 | 33487