Bugzilla – Attachment 9957 Details for
Bug 6557
biblioitems.totalissues unused
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 6557: Syspref to control total issue counting
Bug-6557-Syspref-to-control-total-issue-counting.patch (text/plain), 4.08 KB, created by
Jared Camins-Esakov
on 2012-06-06 15:39:39 UTC
(
hide
)
Description:
Bug 6557: Syspref to control total issue counting
Filename:
MIME Type:
Creator:
Jared Camins-Esakov
Created:
2012-06-06 15:39:39 UTC
Size:
4.08 KB
patch
obsolete
>From 8b2af5f0698e24d7df121458dc1081b6294a0999 Mon Sep 17 00:00:00 2001 >From: Jared Camins-Esakov <jcamins@cpbibliography.com> >Date: Thu, 17 May 2012 20:05:29 -0400 >Subject: [PATCH] Bug 6557: Syspref to control total issue counting >Content-Type: text/plain; charset="UTF-8" > >Because updating the total issues count associated with a bibliographic >record on issue could cause a significant load on the server, this >commit adds the syspref UpdateTotalIssuesOnCirc (which defaults to OFF >to match existing behavior). The syspref has the following description: > > Do/Do not update a bibliographic record's total issues count whenever > an item is issued (WARNING! This increases server load significantly; > if performance is a concern, use the update_totalissues.pl cron job > to update the total issues count). > >This patch to Koha was sponsored by the Arcadia Public Library and the >Arcadia Public Library Foundation in honor of Jackie Faust-Moreno, late >director of the Arcadia Public Library. >--- > installer/data/mysql/sysprefs.sql | 1 + > installer/data/mysql/updatedatabase.pl | 7 +++++++ > .../en/modules/admin/preferences/circulation.pref | 6 ++++++ > 3 files changed, 14 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 2ffe2df..60cd64b 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -365,3 +365,4 @@ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ( > INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacBrowseResults','1','Disable/enable browsing and paging search results from the OPAC detail page.',NULL,'YesNo'); > INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SvcMaxReportRows','10','Maximum number of rows to return via the report web service.',NULL,'Integer'); > INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights','Choice'); >+INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UpdateTotalIssuesOnCirc','0','Whether to update the totalissues field in the biblio on each circ.',NULL,'YesNo'); >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 51a6486..e1e5bba 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5307,6 +5307,13 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > SetVersion ($DBversion); > } > >+$DBversion = "3.09.00.XXX"; >+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { >+ $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UpdateTotalIssuesOnCirc','0','Whether to update the totalissues field in the biblio on each circ.',NULL,'YesNo');"); >+ print "Upgrade to $DBversion done (Add syspref UpdateTotalIssuesOnCirc)\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 471aa0e..e790944 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 >@@ -103,6 +103,12 @@ Circulation: > - pref: NoticeCSS > class: url > - on Notices. (This should be a complete URL, starting with <code>http://</code>) >+ - >+ - pref: UpdateTotalIssuesOnCirc >+ choices: >+ yes: Do >+ no: "Do not" >+ - update a bibliographic record's total issues count whenever an item is issued (WARNING! This increases server load significantly; if performance is a concern, use the update_totalissues.pl cron job to update the total issues count). > Checkout Policy: > - > - pref: AllowNotForLoanOverride >-- >1.7.2.5
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 6557
:
9765
|
9766
|
9767
|
9957
|
9958
|
9959
|
9961
|
9962
|
9963
|
9964
|
9965
|
9966
|
9986
|
10561
|
10562