[Koha-bugs] [Bug 24724] Add plugin hook for new SQL report export formats

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24724

--- Comment #1 from paxed <pasi.kallinen at koha-suomi.fi> ---
Created attachment 99574
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=99574&action=edit
Bug 24724: Add plugin hook for new SQL report export formats

This adds plugin hooks for adding new export formats for
SQL reports.

The plugin should implement two new methods:
- sql_report_get_export_formats
    Takes no parameters.
    Should return an array ref of hashes, with the following keys:
      shortname => 'dump',
      name => 'Name of this format',
      type => 'text/plain'
- sql_report_process_data
    Takes 3 parameters: format, headers, and data.
    - format is string the shortname from one of the hashes in
      sql_report_get_export_formats.
    - headers is array ref of strings, column names of the data.
    - data is the data as returned by perl DBI fetchall_arrayref()

Test plan:
1) Enable plugins, and install the example plugin for the bug
2) Create a new SQL report, eg. "SELECT * FROM BORROWERS LIMIT 30"
3) Run the report - you should see two new entries in the "Download"
   button: "Perl data dump (.dump)" and "HTML table (.htm)"
4) Download the new formats, and inspect the file contents that
   they look correct
5) Test the other entries in the download-button and that they work

-- 
You are receiving this mail because:
You are watching all bug changes.