Revision b77889e1
Von Bernd Bleßmann vor fast 2 Jahren hinzugefügt
| SL/ReportGenerator.pm | ||
|---|---|---|
| 55 | 55 |
'encoding' => 'UTF-8', |
| 56 | 56 |
}, |
| 57 | 57 |
'chart_export' => {
|
| 58 |
'assignment_x' => 'x',
|
|
| 59 |
'assignment_y' => 'y1',
|
|
| 58 |
'assignment_x' => '', |
|
| 59 |
'assignments_y' => [],
|
|
| 60 | 60 |
}, |
| 61 | 61 |
}; |
| 62 | 62 |
$self->{export} = {
|
| ... | ... | |
| 876 | 876 |
|
| 877 | 877 |
my $opts = $self->{options};
|
| 878 | 878 |
|
| 879 |
my $assignment_x = $opts->{chart_export}->{assignment_x};
|
|
| 880 |
my $assignment_y = $opts->{chart_export}->{assignment_y};
|
|
| 879 |
my $assignment_x = $opts->{chart_export}->{assignment_x};
|
|
| 880 |
my $assignments_y = $opts->{chart_export}->{assignments_y};
|
|
| 881 | 881 |
|
| 882 |
my @data_x;
|
|
| 883 |
my @data_y;
|
|
| 882 |
my @labels;
|
|
| 883 |
my @datasets;
|
|
| 884 | 884 |
foreach my $row_set (@{ $self->{data} }) {
|
| 885 | 885 |
next if ('ARRAY' ne ref $row_set);
|
| 886 | 886 |
foreach my $row (@{ $row_set }) {
|
| 887 |
my $x = $row->{$assignment_x}->{data}->[0];
|
|
| 888 |
my $y = $row->{$assignment_y}->{data}->[0];
|
|
| 889 |
if ($x) {
|
|
| 890 |
push @data_x, $x; |
|
| 891 |
push @data_y, $y//0; |
|
| 887 |
my $label = $row->{$assignment_x}->{data}->[0];
|
|
| 888 |
if ($label) {
|
|
| 889 |
push @labels, $label; |
|
| 890 |
|
|
| 891 |
my @set; |
|
| 892 |
foreach my $assignment_y (@$assignments_y) {
|
|
| 893 |
my $y = $row->{$assignment_y}->{data}->[0];
|
|
| 894 |
push @set, $y; |
|
| 895 |
} |
|
| 896 |
push @datasets, \@set; |
|
| 892 | 897 |
} |
| 893 | 898 |
} |
| 894 | 899 |
} |
| ... | ... | |
| 912 | 917 |
$::form->header; |
| 913 | 918 |
print $::form->parse_html_template('report_generator/chart_report',
|
| 914 | 919 |
{
|
| 915 |
data_x => to_json(\@data_x), |
|
| 916 |
data_y => to_json(\@data_y), |
|
| 917 |
label_x => $assignment_x, |
|
| 918 |
label_y => $assignment_y, |
|
| 920 |
labels => to_json(\@labels), |
|
| 921 |
datasets => to_json(\@datasets), |
|
| 922 |
data_labels => to_json($assignments_y), |
|
| 919 | 923 |
%$variables, |
| 920 | 924 |
} |
| 921 | 925 |
); |
| js/kivi.ChartReport.js | ||
|---|---|---|
| 3 | 3 |
|
| 4 | 4 |
ns.data = undefined; |
| 5 | 5 |
|
| 6 |
ns.background_colors = function() { return [
|
|
| 7 |
'rgba(255, 0, 0, 0.2)', |
|
| 8 |
'rgba(63, 0, 0, 0.2)', |
|
| 9 |
'rgba(0, 127, 0, 0.2)', |
|
| 10 |
'rgba(0, 0, 191, 0.2)', |
|
| 11 |
'rgba(191, 0, 0, 0.2)', |
|
| 12 |
'rgba(0, 255, 0, 0.2)', |
|
| 13 |
'rgba(0, 63, 0, 0.2)', |
|
| 14 |
'rgba(0, 0, 127, 0.2)', |
|
| 15 |
'rgba(127, 0, 0, 0.2)', |
|
| 16 |
'rgba(0, 191, 0, 0.2)', |
|
| 17 |
'rgba(0, 0, 255, 0.2)', |
|
| 18 |
'rgba(0, 0, 63, 0.2)' |
|
| 19 |
]}; |
|
| 20 |
|
|
| 21 |
ns.border_colors = function() { return [
|
|
| 22 |
'rgba(255, 0, 0, 1.0)', |
|
| 23 |
'rgba(63, 0, 0, 1.0)', |
|
| 24 |
'rgba(0, 127, 0, 1.0)', |
|
| 25 |
'rgba(0, 0, 191, 1.0)', |
|
| 26 |
'rgba(191, 0, 0, 1.0)', |
|
| 27 |
'rgba(0, 255, 0, 1.0)', |
|
| 28 |
'rgba(0, 63, 0, 1.0)', |
|
| 29 |
'rgba(0, 0, 127, 1.0)', |
|
| 30 |
'rgba(127, 0, 0, 1.0)', |
|
| 31 |
'rgba(0, 191, 0, 1.0)', |
|
| 32 |
'rgba(0, 0, 255, 1.0)', |
|
| 33 |
'rgba(0, 0, 63, 1.0)' |
|
| 34 |
]}; |
|
| 35 |
|
|
| 6 | 36 |
ns.chart = function() {
|
| 7 |
$(ns.data.data_y).each(function(idx) {ns.data.data_y[idx] = kivi.parse_amount('' + ns.data.data_y[idx]);});
|
|
| 8 |
console.log("bb: data_y (parsed): "); console.log(ns.data.data_y);
|
|
| 37 |
$(ns.data.datasets).each(function(idx, elt) {
|
|
| 38 |
$(elt).each(function(idx) {elt[idx] = kivi.parse_amount('' + elt[idx]);console.log(elt[idx]);});
|
|
| 39 |
}); |
|
| 40 |
|
|
| 41 |
const datasets = []; |
|
| 42 |
for (let i = 0; i < ns.data.data_labels.length; i++) {
|
|
| 43 |
const set = []; |
|
| 44 |
$(ns.data.datasets).each(function(idx, elt) {set.push(elt[i]);});
|
|
| 45 |
const colots = []; |
|
| 46 |
datasets.push({label: ns.data.data_labels[i],
|
|
| 47 |
data: set, |
|
| 48 |
backgroundColor: ns.background_colors()[i % ns.background_colors().length], |
|
| 49 |
borderColor: ns.border_colors()[i % ns.border_colors().length], |
|
| 50 |
borderWidth: 1 |
|
| 51 |
}); |
|
| 52 |
} |
|
| 9 | 53 |
|
| 10 | 54 |
const ctx = 'chart'; |
| 11 | 55 |
const chart = new Chart(ctx, {
|
| 12 | 56 |
type: 'bar', |
| 13 | 57 |
data: {
|
| 14 |
labels: ns.data.data_x, |
|
| 15 |
datasets: [{
|
|
| 16 |
label: ns.data.label_y, |
|
| 17 |
data: ns.data.data_y, |
|
| 18 |
backgroundColor: [ |
|
| 19 |
'rgba(255, 99, 132, 0.2)', |
|
| 20 |
'rgba(54, 162, 235, 0.2)', |
|
| 21 |
'rgba(255, 206, 86, 0.2)', |
|
| 22 |
'rgba(75, 192, 192, 0.2)', |
|
| 23 |
'rgba(153, 102, 255, 0.2)', |
|
| 24 |
'rgba(255, 159, 64, 0.2)' |
|
| 25 |
], |
|
| 26 |
borderColor: [ |
|
| 27 |
'rgba(255, 99, 132, 1)', |
|
| 28 |
'rgba(54, 162, 235, 1)', |
|
| 29 |
'rgba(255, 206, 86, 1)', |
|
| 30 |
'rgba(75, 192, 192, 1)', |
|
| 31 |
'rgba(153, 102, 255, 1)', |
|
| 32 |
'rgba(255, 159, 64, 1)' |
|
| 33 |
], |
|
| 34 |
borderWidth: 1 |
|
| 35 |
}] |
|
| 58 |
labels: ns.data.labels, |
|
| 59 |
datasets: datasets, |
|
| 36 | 60 |
}, |
| 37 | 61 |
options: {
|
| 38 | 62 |
scales: {
|
| ... | ... | |
| 45 | 69 |
}; |
| 46 | 70 |
|
| 47 | 71 |
ns.debug = function() {
|
| 48 |
console.log("bb: data_x: "); console.log(ns.data.data_x);
|
|
| 49 |
console.log("bb: data_y: "); console.log(ns.data.data_y);
|
|
| 50 |
console.log("bb: label_x: "); console.log(ns.data.label_x);
|
|
| 51 |
console.log("bb: label_y: "); console.log(ns.data.label_y);
|
|
| 72 |
console.log("bb: labels: "); console.log(ns.data.labels);
|
|
| 73 |
console.log("bb: datasets: "); console.log(ns.data.datasets);
|
|
| 74 |
console.log("bb: data_labels: "); console.log(ns.data.data_labels);
|
|
| 52 | 75 |
}; |
| 53 | 76 |
|
| 54 | 77 |
$(function() {
|
| templates/webpages/report_generator/chart_export_options.html | ||
|---|---|---|
| 1 | 1 |
[%- USE T8 %] |
| 2 | 2 |
[%- USE HTML %] |
| 3 | 3 |
[%- USE L %] |
| 4 |
[%- USE P %] |
|
| 5 |
[%- USE LxERP %] |
|
| 4 | 6 |
|
| 5 | 7 |
<h1>[% HTML.escape(title) %]</h1> |
| 6 | 8 |
|
| ... | ... | |
| 13 | 15 |
<input type="hidden" name="report_generator_chart_options_set" value="1"> |
| 14 | 16 |
<input type="hidden" name="report_generator_dispatch_to" value=""> |
| 15 | 17 |
|
| 16 |
<table> |
|
| 18 |
<table id="assigment_table">
|
|
| 17 | 19 |
<tr> |
| 18 | 20 |
<th valign="top" align="right">[% 'Chart assignments' | $T8 %]: [% 'X axis' | $T8 %]</th> |
| 19 | 21 |
<td> |
| ... | ... | |
| 24 | 26 |
title_key = 'text') %] |
| 25 | 27 |
</td> |
| 26 | 28 |
</tr> |
| 27 |
<tr>
|
|
| 29 |
<tr id="y_assignment_row">
|
|
| 28 | 30 |
<th valign="top" align="right">[% 'Chart assignments' | $T8 %]: [% 'Y axis' | $T8 %]</th> |
| 29 | 31 |
<td> |
| 30 |
[% L.select_tag('report_generator_chart_options_assignment_y',
|
|
| 32 |
[% L.select_tag('report_generator_chart_options_assignments_y[]',
|
|
| 31 | 33 |
fields, |
| 32 |
default = SELF.report_generator_chart_options_assignment_y |
|
| 33 | 34 |
value_key = 'name', |
| 34 | 35 |
title_key = 'text') %] |
| 36 |
[% P.link_tag('', "✘", class='remove_data_assignment interact cursor-pointer', onclick='remove_data_assignment(this)', style='display:none') %]
|
|
| 35 | 37 |
</td> |
| 36 |
</tr> |
|
| 38 |
</tr>
|
|
| 37 | 39 |
</table> |
| 38 | 40 |
|
| 41 |
[% L.button_tag('add_data_assignement()', LxERP.t8('Add row')) %]
|
|
| 42 |
|
|
| 39 | 43 |
[%- IF CONTROLLER_DISPATCH %] |
| 40 | 44 |
<input type="hidden" name="CONTROLLER_DISPATCH" value="[% CONTROLLER_DISPATCH | html %]"> |
| 41 | 45 |
[%- ELSE %] |
| ... | ... | |
| 44 | 48 |
|
| 45 | 49 |
|
| 46 | 50 |
</form> |
| 51 |
|
|
| 52 |
<script type="text/javascript"> |
|
| 53 |
<!-- |
|
| 54 |
function add_data_assignement() {
|
|
| 55 |
const new_row = $('#y_assignment_row').clone();
|
|
| 56 |
new_row.removeAttr('id');
|
|
| 57 |
new_row.find('a').show();
|
|
| 58 |
new_row.find('*').removeAttr('id');
|
|
| 59 |
new_row.appendTo("#assigment_table");
|
|
| 60 |
} |
|
| 61 |
function remove_data_assignment(clicked) {
|
|
| 62 |
$(clicked).closest('tr').remove();
|
|
| 63 |
} |
|
| 64 |
--> |
|
| 65 |
</script> |
|
| templates/webpages/report_generator/chart_report.html | ||
|---|---|---|
| 22 | 22 |
|
| 23 | 23 |
|
| 24 | 24 |
<script> |
| 25 |
kivi.ChartReport.data = { data_x: [% data_x %],
|
|
| 26 |
data_y: [% data_y %], |
|
| 27 |
label_y: "[% label_y %]", |
|
| 28 |
label_x: "[% label_x %]" |
|
| 25 |
kivi.ChartReport.data = { labels: [% labels %],
|
|
| 26 |
datasets: [% datasets %], |
|
| 27 |
data_labels: [% data_labels %], |
|
| 29 | 28 |
}; |
| 30 | 29 |
</script> |
Auch abrufbar als: Unified diff
Reports als Chart: mehrere Y-Werte