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

(-)a/installer/data/mysql/atomicupdate/bug_20679_-_add_reportRowsPerPage_syspref.sql (+1 lines)
Line 0 Link Here
1
INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('reportRowsPerPage', '1', NULL, 'Show/hide the rows per page dropdown when running a report', 'YesNo');
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 480-485 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
480
('RentalsInNoissuesCharge','1',NULL,'Rental charges block checkouts (added to noissuescharge).','YesNo'),
480
('RentalsInNoissuesCharge','1',NULL,'Rental charges block checkouts (added to noissuescharge).','YesNo'),
481
('ReplyToDefault','',NULL,'Use this email address as the replyto in emails','Free'),
481
('ReplyToDefault','',NULL,'Use this email address as the replyto in emails','Free'),
482
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
482
('ReportsLog','0',NULL,'If ON, log information about reports.','YesNo'),
483
('reportRowsPerPage', '1', NULL, 'Show/hide the rows per page dropdown when running a report', 'YesNo');
483
('RequestOnOpac','1',NULL,'If ON, globally enables patron holds on OPAC','YesNo'),
484
('RequestOnOpac','1',NULL,'If ON, globally enables patron holds on OPAC','YesNo'),
484
('RequireStrongPassword','1','','Require a strong login password for staff and patrons','YesNo'),
485
('RequireStrongPassword','1','','Require a strong login password for staff and patrons','YesNo'),
485
('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights','Choice'),
486
('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights','Choice'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/web_services.pref (+6 lines)
Lines 65-70 Web services: Link Here
65
            - pref: SvcMaxReportRows
65
            - pref: SvcMaxReportRows
66
              class: integer
66
              class: integer
67
            - rows of a report requested via the reports web service.
67
            - rows of a report requested via the reports web service.
68
        -
69
            - pref: reportRowsPerPage
70
              choices:
71
                yes: Show
72
                no: "Don't show"
73
            - rows per page option when running a report.
68
    IdRef:
74
    IdRef:
69
        -
75
        -
70
            - pref: IdRef
76
            - pref: IdRef
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt (-12 / +14 lines)
Lines 714-730 canned reports and writing custom SQL reports.</p> Link Here
714
        <input type="hidden" name="param_name" value="[% n | html %]"/>
714
        <input type="hidden" name="param_name" value="[% n | html %]"/>
715
    [% END %]
715
    [% END %]
716
716
717
    <label for="limit">Rows per page: </label>
717
    [% IF ( Koha.Preference('reportRowsPerPage') ) %]
718
    <select name="limit" id="limit">
718
        <label for="limit">Rows per page: </label>
719
        [% limits = [ 10, 20, 50, 100, 200, 300, 400, 500, 1000 ] %]
719
        <select name="limit" id="limit">
720
        [% FOREACH l IN limits %]
720
            [% limits = [ 10, 20, 50, 100, 200, 300, 400, 500, 1000 ] %]
721
                [% IF l == limit %]
721
            [% FOREACH l IN limits %]
722
                    <option value="[% l | html %]" selected="selected">[% l | html %]</option>
722
                    [% IF l == limit %]
723
                [% ELSE %]
723
                        <option value="[% l | html %]" selected="selected">[% l | html %]</option>
724
                    <option value="[% l | html %]">[% l | html %]</option>
724
                    [% ELSE %]
725
                [% END %]
725
                        <option value="[% l | html %]">[% l | html %]</option>
726
        [% END %]
726
                    [% END %]
727
    </select>
727
            [% END %]
728
        </select>
729
    [% END %]
730
728
</form>
731
</form>
729
732
730
<div class="pages">[% pagination_bar | $raw %]</div>
733
<div class="pages">[% pagination_bar | $raw %]</div>
731
- 

Return to bug 22145