Bug 17282: Ability to create charts for SQL reports
authorAlex Arnaud <alex.arnaud@biblibre.com>
Mon, 24 Sep 2018 13:09:35 +0000 (13:09 +0000)
committerNick Clemens <nick@bywatersolutions.com>
Mon, 1 Oct 2018 13:56:35 +0000 (13:56 +0000)
commitedb627bcf275c037879622ec07d807d2186c98e0
tree5ec82bb86925123561c5b0a03fb7b3bc3b408a28
parent8b1bda9ed8507745b4002199d9aae95c2cbb31fb
Bug 17282: Ability to create charts for SQL reports

Add a form under report's result that allow to configure and draw a
chart (pie, bar, line and combination).

Pie: Usefull only for a two-column report's result

bar: Horizontal: Can be horizontal or vertical (check/uncheck
horizontal checkbox),
     Group: allows to group columns (stacked bar chart),
     Line: show some columns as line in a bar chart (combination)

line: line chart :)

This patch adds 2 new js libraries: d3js and c3js:
  - c3.min.css
  - c3.min.js
  - d3.min.js

Test plan:
- Apply this patch,
- execute a report,
- click on show chart settings button (in the tool bar),
- draw chart (click on draw button),
- check the chart

Features:
- Include all rows (ignore pagination),
- Download the chart (svg),
- Choose x column and y columns,
- Exclude last line (Rollup)

Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
koha-tmpl/intranet-tmpl/lib/d3c3/c3.min.css [new file with mode: 0644]
koha-tmpl/intranet-tmpl/lib/d3c3/c3.min.js [new file with mode: 0644]
koha-tmpl/intranet-tmpl/lib/d3c3/d3.min.js [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/css/src/staff-global.scss
koha-tmpl/intranet-tmpl/prog/en/includes/chart.inc [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/includes/reports-toolbar.inc
koha-tmpl/intranet-tmpl/prog/en/modules/about.tt
koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt
koha-tmpl/intranet-tmpl/prog/js/charts.js [new file with mode: 0644]
reports/guided_reports.pl