From cd0e2e8c5bd92ff7accd9c7b74516acbdc27460f Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Nazl=C4=B1=20=C3=87etin?= 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 Signed-off-by: Katrin Fischer --- .../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