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

(-)a/installer/data/mysql/atomicupdate/bug23685.pl (+21 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
3
4
return {
5
    bug_number  => "23685",
6
    description => "Add prefs GuidedReportsExportLimit and ReportingAllowsODS_Export",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        # sysprefs
12
        $dbh->do(
13
            q{
14
            INSERT IGNORE INTO systempreferences ( variable, value, options, explanation, type ) VALUES
15
            ('GuidedReportsExportLimit',NULL,NULL,'Limit for reporting downloads (if not empty)','Integer'),
16
            ('ReportingAllowsODS_Export',1,NULL,'Shows or hides ODS download in Reporing','YesNo');
17
        }
18
        );
19
        say $out "Added new system preferences: GuidedReportsExportLimit and ReportingAllowsODS_Export";
20
    },
21
};
(-)a/installer/data/mysql/mandatory/sysprefs.sql (-1 / +2 lines)
Lines 292-297 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
292
('GoogleOpenIDConnectDefaultBranch',  '','','This branch code will be used to create Google OpenID Connect patrons.','Textarea'),
292
('GoogleOpenIDConnectDefaultBranch',  '','','This branch code will be used to create Google OpenID Connect patrons.','Textarea'),
293
('GoogleOpenIDConnectDefaultCategory','','','This category code will be used to create Google OpenID Connect patrons.','Textarea'),
293
('GoogleOpenIDConnectDefaultCategory','','','This category code will be used to create Google OpenID Connect patrons.','Textarea'),
294
('GoogleOpenIDConnectDomain', '', NULL, 'Restrict Google OpenID Connect to this domain (or subdomains of this domain). Leave blank for all Google domains', 'Free'),
294
('GoogleOpenIDConnectDomain', '', NULL, 'Restrict Google OpenID Connect to this domain (or subdomains of this domain). Leave blank for all Google domains', 'Free'),
295
('GuidedReportsExportLimit',NULL,NULL,'Limit for reporting downloads (if not empty)','Integer'),
295
('hide_marc','0',NULL,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'),
296
('hide_marc','0',NULL,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)','YesNo'),
296
('hidelostitems','0','','If ON, disables display of\"lost\" items in OPAC.','YesNo'),
297
('hidelostitems','0','','If ON, disables display of\"lost\" items in OPAC.','YesNo'),
297
('HidePatronName','0','','If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'),
298
('HidePatronName','0','','If this is switched on, patron\'s cardnumber will be shown instead of their name on the holds and catalog screens','YesNo'),
Lines 655-660 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
655
('RenewalSendNotice','0','',NULL,'YesNo'),
656
('RenewalSendNotice','0','',NULL,'YesNo'),
656
('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'),
657
('RenewSerialAddsSuggestion','0',NULL,'If ON, adds a new suggestion at serial subscription renewal','YesNo'),
657
('RentalFeesCheckoutConfirmation', '0', NULL , 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'),
658
('RentalFeesCheckoutConfirmation', '0', NULL , 'Allow user to confirm when checking out an item with rental fees.', 'YesNo'),
659
('ReportingAllowsODS_Export',1,NULL,'Shows or hides ODS download in Reporing','YesNo'),
658
('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'),
660
('ReplytoDefault','',NULL,'Use this email address as the replyto in emails','Free'),
659
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
661
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
660
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
662
('RequireCashRegister','0',NULL,'Require a cash register when collecting a payment','YesNo'),
661
- 

Return to bug 23685