Bugzilla – Attachment 12337 Details for
Bug 7751
Decrease loan period on items with a high number of holds
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Supplementary Patch (db update to add sysprefs)
0001-Bug-7751-Add-sysprefs-for-high-holds-feature.patch (text/plain), 3.23 KB, created by
Colin Campbell
on 2012-09-19 10:43:20 UTC
(
hide
)
Description:
Supplementary Patch (db update to add sysprefs)
Filename:
MIME Type:
Creator:
Colin Campbell
Created:
2012-09-19 10:43:20 UTC
Size:
3.23 KB
patch
obsolete
>From 202743ceb25f8400ac5e48794610155a554fb2d3 Mon Sep 17 00:00:00 2001 >From: Colin Campbell <colin.campbell@ptfs-europe.com> >Date: Wed, 19 Sep 2012 11:33:39 +0100 >Subject: [PATCH] Bug 7751 Add sysprefs for high holds feature > >Add the sysprefs for the feature which allows >loan periods on high demand items to be reduced > >Also fixes a typo Paul spotted in the syspref text > >Feature sponsored by Staffordshire University Library >--- > installer/data/mysql/updatedatabase.pl | 10 ++++++++++ > .../prog/en/modules/admin/preferences/circulation.pref | 2 +- > 2 files changed, 11 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 5d6f7db..54d0762 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5848,6 +5848,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > WHEN 5 THEN 'ACC' > END;"); > $dbh->do("ALTER TABLE reports_dictionary DROP area;"); >+ > $dbh->do("ALTER TABLE reports_dictionary ADD KEY dictionary_area_idx (report_area);"); > > $dbh->do("ALTER TABLE saved_sql ADD report_area varchar(6) DEFAULT NULL;"); >@@ -5859,6 +5860,15 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > SetVersion($DBversion); > } > >+$DBversion ="3.09.00.XXX"; >+if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { >+ $dbh->do(q|INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('decreaseLoanHighHolds', NULL, '', 'Decreases the loan period for items with number of holds above the threshold specified in decreaseLoanHighHoldsValue', 'YesNo')|); >+ $dbh->do(q|INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('decreaseLoanHighHoldsValue', NULL, '', 'Specifies a threshold for the minimum number of holds needed to trigger a reduction in loan duration (used with decreaseLoanHighHolds)', 'Integer')|); >+ $dbh->do(q|INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('decreaseLoanHighHoldsDuration', NULL, '', 'Specifies a number of days that a loan is reduced to when used in conjunction with decreaseLoanHighHolds', 'Integer')|); >+ print "Upgrade to $DBversion done (Add decreaseLoanHighHolds, decreaseLoanHighHoldsValue and decreaseLoanHighHoldsDuration sysprefs`)\n"; >+ SetVersion($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >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 531b878..f36025d 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 >@@ -422,7 +422,7 @@ Circulation: > - A loan should be reduced by decreaseLoanHighHoldsDuration when > - pref: decreaseLoanHighHoldsValue > class: integer >- - holds have been places (if decreaseLoanHighHolds is enables) >+ - holds have been placed (if decreaseLoanHighHolds is enables) > Fines Policy: > - > - Calculate fines based on days overdue >-- >1.7.12.464.g83379df >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 7751
:
8313
|
8314
|
8315
|
9801
|
9803
|
9804
|
9810
|
9811
|
9812
|
9834
|
10040
|
10199
|
10204
|
11477
|
11672
|
11676
|
12337
|
12345
|
12528
|
12643
|
12786
|
12787
|
12802
|
12803