Bugzilla – Attachment 102882 Details for
Bug 22774
Add ability to limit the number of purchase suggestions a patron may submit in a specified time period
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22774: New systempreferences for suggestions added to sysprefs.sql
Bug-22774-New-systempreferences-for-suggestions-ad.patch (text/plain), 3.54 KB, created by
Katrin Fischer
on 2020-04-13 18:32:21 UTC
(
hide
)
Description:
Bug 22774: New systempreferences for suggestions added to sysprefs.sql
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2020-04-13 18:32:21 UTC
Size:
3.54 KB
patch
obsolete
>From cd0e2e8c5bd92ff7accd9c7b74516acbdc27460f Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Nazl=C4=B1=20=C3=87etin?= <nazli@devinim.com.tr> >Date: Fri, 21 Feb 2020 14:08:16 +0000 >Subject: [PATCH] Bug 22774: New systempreferences for suggestions added to > sysprefs.sql > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > .../data/mysql/atomicupdate/bug_22774.perl | 18 ++++++++++++++++++ > installer/data/mysql/sysprefs.sql | 2 ++ > .../en/modules/admin/preferences/opac.pref | 8 ++++++++ > 3 files changed, 28 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_22774.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_22774.perl b/installer/data/mysql/atomicupdate/bug_22774.perl >new file mode 100644 >index 0000000000..42f53400b6 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_22774.perl >@@ -0,0 +1,18 @@ >+$DBversion = '19.12.00.XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ # you can use $dbh here like: >+ # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" ); >+ $dbh->do( q{ >+ INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES >+ ('MaxTotalSuggestions','','Number of total suggestions','Free'), >+ ('NumberOfSuggestionDays','','days','Free') >+ }); >+ # or perform some test and warn >+ # if( !column_exists( 'biblio', 'biblionumber' ) ) { >+ # warn "There is something wrong"; >+ # } >+ >+ # Always end with this (adjust the bug info) >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 22774 - Limit Purchase Suggestion in a specified Time period)\n"; >+} >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index a15c4c6c95..a3791d50f0 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -321,6 +321,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('maxRecordsForFacets','20',NULL,NULL,'Integer'), > ('maxreserves','50','','Define maximum number of holds a patron can place','Integer'), > ('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'), >+('MaxTotalSuggestions','',NULL,'Number of total suggestions','Free'), >+('NumberOfSuggestionDays','',NULL,'days','Free'), > ('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'), > ('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'), > ('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'), >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >index c705a288c3..f860251f42 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref >@@ -710,6 +710,14 @@ OPAC: > - pref: MaxOpenSuggestions > class: integer > - "open suggestions. Leave empty for no limit. **Note: this setting does not affect anonymous suggestions" >+ - >+ - Number of total suggestions >+ - pref: MaxTotalSuggestions >+ class: integer >+ - "for" >+ - pref: NumberOfSuggestionDays >+ class: integer >+ - "days." > Privacy: > - > - pref: AnonSuggestions >-- >2.17.1
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 22774
:
95940
|
95941
|
97061
|
97070
|
97071
|
99045
|
99046
|
99380
|
99381
|
99382
|
100192
|
100193
|
100912
|
100913
|
101448
| 102882 |
102883
|
102884
|
102885
|
102886