View | Details | Raw Unified | Return to bug 22774
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_22774.perl (-11 / +4 lines)
Lines 1-18 Link Here
1
$DBversion = '19.12.00.XXX'; # will be replaced by the RM
1
$DBversion = '19.12.00.XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    # you can use $dbh here like:
3
4
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
5
    $dbh->do( q{
4
    $dbh->do( q{
6
            INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES
5
            INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES
7
                ('MaxTotalSuggestions','','Number of total suggestions','Free'),
6
                ('MaxTotalSuggestions','','Number of total suggestions used for time limit with NumberOfSuggestionDays','Free'),
8
                ('NumberOfSuggestionDays','','days','Free')
7
                ('NumberOfSuggestionDays','','Number of days that will be used to determine the MaxTotalSuggestions limit','Free')
9
            });
8
            });
10
    # or perform some test and warn
11
    # if( !column_exists( 'biblio', 'biblionumber' ) ) {
12
    #    warn "There is something wrong";
13
    # }
14
9
15
    # Always end with this (adjust the bug info)
10
    NewVersion( $DBversion, 22774, "Limit purchase suggestion in a specified time period");
16
    SetVersion( $DBversion );
17
    print "Upgrade to $DBversion done (Bug 22774 - Limit Purchase Suggestion in a specified Time period)\n";
18
}
11
}
(-)a/installer/data/mysql/sysprefs.sql (-2 / +2 lines)
Lines 321-328 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
321
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
321
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
322
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
322
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
323
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
323
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
324
('MaxTotalSuggestions','',NULL,'Number of total suggestions','Free'),
324
('MaxTotalSuggestions','',NULL,'Number of total suggestions used for time limit with NumberOfSuggestionDays','Free'),
325
('NumberOfSuggestionDays','',NULL,'days','Free'),
326
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
325
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
327
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
326
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
328
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
327
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
Lines 344-349 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
344
('NovelistSelectStaffProfile','',NULL,'Novelist Select user Profile for staff client','free'),
343
('NovelistSelectStaffProfile','',NULL,'Novelist Select user Profile for staff client','free'),
345
('NovelistSelectStaffView','tab','tab|above|below','Where to display Novelist Select content in the staff client','Choice'),
344
('NovelistSelectStaffView','tab','tab|above|below','Where to display Novelist Select content in the staff client','Choice'),
346
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
345
('NovelistSelectView','tab','tab|above|below|right','Where to display Novelist Select content','Choice'),
346
('NumberOfSuggestionDays','',NULL,'Number of days that will be used to determine the MaxTotalSuggestions limit','Free'),
347
('numReturnedItemsToShow','20',NULL,'Number of returned items to show on the check-in page','Integer'),
347
('numReturnedItemsToShow','20',NULL,'Number of returned items to show on the check-in page','Integer'),
348
('NumSavedReports', '20', NULL, 'By default, show this number of saved reports.', 'Integer'),
348
('NumSavedReports', '20', NULL, 'By default, show this number of saved reports.', 'Integer'),
349
('numSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
349
('numSearchResults','20',NULL,'Specify the maximum number of results to display on a page of results','Integer'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-3 / +2 lines)
Lines 711-720 OPAC: Link Here
711
              class: integer
711
              class: integer
712
            - "open suggestions. Leave empty for no limit. **Note: this setting does not affect anonymous suggestions"
712
            - "open suggestions. Leave empty for no limit. **Note: this setting does not affect anonymous suggestions"
713
        -
713
        -
714
            - Number of total suggestions
714
            - Number of total suggestions allowed
715
            - pref: MaxTotalSuggestions
715
            - pref: MaxTotalSuggestions
716
              class: integer
716
              class: integer
717
            - "for"
717
            - "in"
718
            - pref: NumberOfSuggestionDays
718
            - pref: NumberOfSuggestionDays
719
              class: integer
719
              class: integer
720
            - "days."
720
            - "days."
721
- 

Return to bug 22774