From 294d6f54e5e57279168c042f76c209eb2b0e346e Mon Sep 17 00:00:00 2001 From: =?utf8?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 Signed-off-by: Martin Renvoize --- .../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 cb15cf9d31..52ff06a8f1 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -323,6 +323,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 485d17d79a..e8b6ed1927 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.20.1