Revision 2e6fe034
Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt
SL/Controller/CustomerVendorTurnover.pm | ||
---|---|---|
$self->{turnover_statistic} = \@new_stats;
|
||
}
|
||
|
||
if (@{$self->{turnover_statistic}} > 1) {
|
||
my $query = <<SQL;
|
||
SELECT $date_part_select as date_part,
|
||
count(id) as count,
|
||
sum(amount) as amount,
|
||
sum(netamount) as netamount,
|
||
sum(paid) as paid
|
||
FROM $db WHERE $cv_type IS NOT NULL
|
||
GROUP BY $group_by
|
||
ORDER BY $order_by
|
||
SQL
|
||
my $overall_turnover = selectall_hashref_query($::form, $dbh, $query);
|
||
foreach my $stat (@{$self->{turnover_statistic}}) {
|
||
my $overall_stat = first { $_->{date_part} eq $stat->{date_part} } @$overall_turnover;
|
||
$stat->{overall_netamount} = 0;
|
||
$stat->{'overall_' . $_} = $overall_stat->{$_} for keys %$overall_stat;
|
||
}
|
||
}
|
||
|
||
if ($::request->type eq 'json') {
|
||
$self->render(\ SL::JSON::to_json($self->{turnover_statistic}), { layout => 0, type => 'json', process => 0 });
|
Auch abrufbar als: Unified diff
Umsatzstatistik-Chart mit Linie aller Umsätze zum Vergleichen