Attachment 37607 Details for Bug 11759 – Bug 11759: Batch checkout - DB changes

[patch] Bug 11759: Batch checkout - DB changes

Bug-11759-Batch-checkout---DB-changes.patch (text/plain), 3.24 KB, created by Jonathan Druart on 2015-04-09 08:32:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2015-04-09 08:32:30 UTC

Size: 3.24 KB

patch

obsolete

>From 147c57561363439694c8d0711bac8d934caf4971 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@biblibre.com>
>Date: Fri, 14 Feb 2014 11:25:54 +0100
>Subject: [PATCH] Bug 11759: Batch checkout - DB changes
>
>Add the new pref batch_checkouts in DB.
>---
> installer/data/mysql/sysprefs.sql                                | 1 +
> installer/data/mysql/updatedatabase.pl                           | 9 +++++++++
> .../prog/en/modules/admin/preferences/circulation.pref           | 6 ++++++
> 3 files changed, 16 insertions(+)
>
>diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
>index 1e07e3c..16d163b 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -63,6 +63,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('BakerTaylorPassword','','','Baker & Taylor Password for Content Cafe (external content)','Free'),
> ('BakerTaylorUsername','','','Baker & Taylor Username for Content Cafe (external content)','Free'),
> ('BasketConfirmations','1','always ask for confirmation.|do not ask for confirmation.','When closing or reopening a basket,','Choice'),
>+('batch_checkouts','',NULL,'Allow patron categories allowed to checkout in a batch','Free'),
> ('BiblioAddsAuthorities','0',NULL,'If ON, adding a new biblio will check for an existing authority record and create one on the fly if one doesn\'t exist','YesNo'),
> ('BiblioDefaultView','normal','normal|marc|isbd','Choose the default detail view in the catalog; choose between normal, marc or isbd','Choice'),
> ('BlockExpiredPatronOpacActions','1',NULL,'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis','YesNo'),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 78e79d3..77d315f 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -9978,6 +9978,15 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.19.00.XXX";
>+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
>+    $dbh->do(q|
>+        INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES
>+        ('batch_checkouts','','','Allow patron categories allowed to checkout in a batch','Free')
>+    |);
>+    print "Upgrade to $DBversion done (Bug 11759: Add batch_checkouts system preference)\n";
>+    SetVersion($DBversion);
>+}
> 
> # DEVELOPER PROCESS, search for anything to execute in the db_update directory
> # SEE bug 13068
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>index a16f231..c1e86ba 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
>@@ -695,3 +695,9 @@ Circulation:
>                   yes: Use
>                   no: "Don't use"
>             - course reserves
>+    Batch checkout:
>+        -
>+            - "Allow some patron categories to checkout in a batch"
>+            - pref: batch_checkouts
>+            - "(list of patron category separated with a pipe '|')"
>+
>-- 
>2.1.0

Actions: View | Diff | Splinter Review

Attachments on bug 11759: 25255 | 25256 | 25257 | 25258 | 25260 | 25620 | 26442 | 26455 | 26806 | 26807 | 26808 | 26809 | 26810 | 26811 | 26813 | 26814 | 26815 | 26833 | 26854 | 27613 | 37603 | 37604 | 37605 | 37606 | 37607 | 37608 | 37609 | 37610 | 37611 | 37612 | 37613 | 37614 | 37650 | 37653 | 41692 | 41693 | 41694 | 41695 | 41696 | 41697 | 41698 | 41735 | 41736 | 41737 | 41738 | 41739 | 41740 | 41741 | 43626 | 43627