@@ -, +, @@ sysprefs.sql --- .../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 --- a/installer/data/mysql/atomicupdate/bug_22774.perl +++ a/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"; +} --- a/installer/data/mysql/sysprefs.sql +++ a/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'), --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref +++ a/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 --