Revision e92b48eb
Von Bernd Bleßmann vor etwa 2 Jahren hinzugefügt
SL/Controller/CustomerVendor.pm | ||
---|---|---|
1221 | 1221 |
|
1222 | 1222 |
$self->{template_args} ||= {}; |
1223 | 1223 |
|
1224 |
$::request->{layout}->add_javascripts("$_.js") for qw (kivi.CustomerVendor kivi.File kivi.CustomerVendorTurnover ckeditor/ckeditor ckeditor/adapters/jquery follow_up); |
|
1224 |
$::request->{layout}->add_javascripts("$_.js") for qw (kivi.CustomerVendor kivi.File chart kivi.CustomerVendorTurnover ckeditor/ckeditor ckeditor/adapters/jquery follow_up);
|
|
1225 | 1225 |
|
1226 | 1226 |
$self->_setup_form_action_bar; |
1227 | 1227 |
} |
SL/Controller/CustomerVendorTurnover.pm | ||
---|---|---|
8 | 8 |
use SL::DB::EmailJournal; |
9 | 9 |
use SL::DB::Letter; |
10 | 10 |
use SL::DB; |
11 |
use SL::JSON qw(to_json); |
|
11 | 12 |
|
12 | 13 |
__PACKAGE__->run_before('check_auth'); |
13 | 14 |
|
... | ... | |
151 | 152 |
ORDER BY $order_by |
152 | 153 |
SQL |
153 | 154 |
$self->{turnover_statistic} = selectall_hashref_query($::form, $dbh, $query, $cv); |
154 |
$self->render('customer_vendor_turnover/count_turnover', { layout => 0 }); |
|
155 |
|
|
156 |
if ($::request->type eq 'json') { |
|
157 |
$self->render(\ SL::JSON::to_json($self->{turnover_statistic}), { layout => 0, type => 'json', process => 0 }); |
|
158 |
} else { |
|
159 |
$self->render('customer_vendor_turnover/count_turnover', { layout => 0 }); |
|
160 |
} |
|
155 | 161 |
} |
156 | 162 |
|
157 | 163 |
sub action_get_invoices { |
js/kivi.CustomerVendorTurnover.js | ||
---|---|---|
42 | 42 |
$('#turnovers').load(url); |
43 | 43 |
}; |
44 | 44 |
|
45 |
ns.show_turnover_chart = function(period) { |
|
46 |
const html = '<div class="chart-container" style="position: relative;">' |
|
47 |
+ '<canvas id="chart"></canvas>' |
|
48 |
+ '</div>'; |
|
49 |
$('#turnovers').html(html); |
|
50 |
|
|
51 |
let mode = "month"; |
|
52 |
if (period === 'y') { |
|
53 |
mode = "year"; |
|
54 |
} else if (period === 'm') { |
|
55 |
mode = "month"; |
|
56 |
} |
|
57 |
|
|
58 |
const data = { action: 'CustomerVendorTurnover/turnover.json', |
|
59 |
id: $('#cv_id').val(), |
|
60 |
db: $('#db').val(), |
|
61 |
mode: mode |
|
62 |
}; |
|
63 |
$.getJSON('controller.pl', data, function( returned_data ) { |
|
64 |
ns.draw_chart(returned_data); |
|
65 |
$("html, body").animate({ scrollTop: $("#chart").offset().top }, "slow"); |
|
66 |
}); |
|
67 |
}; |
|
68 |
|
|
69 |
ns.draw_chart = function(data) { |
|
70 |
// Todos are most probably better done in the perl backend. |
|
71 |
// Todo: fill holes |
|
72 |
// Todo: show amount/paid in one/each bar |
|
73 |
// data = [ |
|
74 |
// {date_part: 2022, netamount: 1234.4}, |
|
75 |
// {date_part: 2022, netamount: 234.4}, |
|
76 |
// {date_part: 2021, netamount: 234.4}, |
|
77 |
// {date_part: 2021, netamount: 34.4}, |
|
78 |
// {date_part: 2020, netamount: 134.4}, |
|
79 |
// {date_part: 2018, netamount: 34.4} |
|
80 |
// ]; |
|
81 |
|
|
82 |
$(data).each(function(idx, elt) { |
|
83 |
elt.date_part = '' + elt.date_part; |
|
84 |
}); |
|
85 |
|
|
86 |
ns.chart(data); |
|
87 |
}; |
|
88 |
|
|
89 |
ns.chart = function(data) { |
|
90 |
const ctx = 'chart'; |
|
91 |
const myChart = new Chart(ctx, { |
|
92 |
type: 'bar', |
|
93 |
data: { |
|
94 |
datasets: [{ |
|
95 |
label: kivi.t8('Net.Turnover'), |
|
96 |
data: data, |
|
97 |
backgroundColor: [ |
|
98 |
'rgba(255, 99, 132, 0.2)', |
|
99 |
'rgba(54, 162, 235, 0.2)', |
|
100 |
'rgba(255, 206, 86, 0.2)', |
|
101 |
'rgba(75, 192, 192, 0.2)', |
|
102 |
'rgba(153, 102, 255, 0.2)', |
|
103 |
'rgba(255, 159, 64, 0.2)' |
|
104 |
], |
|
105 |
borderColor: [ |
|
106 |
'rgba(255, 99, 132, 1)', |
|
107 |
'rgba(54, 162, 235, 1)', |
|
108 |
'rgba(255, 206, 86, 1)', |
|
109 |
'rgba(75, 192, 192, 1)', |
|
110 |
'rgba(153, 102, 255, 1)', |
|
111 |
'rgba(255, 159, 64, 1)' |
|
112 |
], |
|
113 |
borderWidth: 1 |
|
114 |
}] |
|
115 |
}, |
|
116 |
options: { |
|
117 |
scales: { |
|
118 |
y: { |
|
119 |
beginAtZero: true |
|
120 |
} |
|
121 |
}, |
|
122 |
parsing: { |
|
123 |
xAxisKey: 'date_part', |
|
124 |
yAxisKey: 'netamount' |
|
125 |
} |
|
126 |
} |
|
127 |
}); |
|
128 |
}; |
|
129 |
|
|
130 |
ns.sample_chart = function() { |
|
131 |
const ctx = 'chart'; |
|
132 |
const myChart = new Chart(ctx, { |
|
133 |
type: 'bar', |
|
134 |
data: { |
|
135 |
labels: ['Red', 'Blue', 'Yellow', 'Green', 'Purple', 'Orange'], |
|
136 |
datasets: [{ |
|
137 |
label: '# of Votes', |
|
138 |
data: [12, 19, 3, 5, 2, 3], |
|
139 |
backgroundColor: [ |
|
140 |
'rgba(255, 99, 132, 0.2)', |
|
141 |
'rgba(54, 162, 235, 0.2)', |
|
142 |
'rgba(255, 206, 86, 0.2)', |
|
143 |
'rgba(75, 192, 192, 0.2)', |
|
144 |
'rgba(153, 102, 255, 0.2)', |
|
145 |
'rgba(255, 159, 64, 0.2)' |
|
146 |
], |
|
147 |
borderColor: [ |
|
148 |
'rgba(255, 99, 132, 1)', |
|
149 |
'rgba(54, 162, 235, 1)', |
|
150 |
'rgba(255, 206, 86, 1)', |
|
151 |
'rgba(75, 192, 192, 1)', |
|
152 |
'rgba(153, 102, 255, 1)', |
|
153 |
'rgba(255, 159, 64, 1)' |
|
154 |
], |
|
155 |
borderWidth: 1 |
|
156 |
}] |
|
157 |
}, |
|
158 |
options: { |
|
159 |
scales: { |
|
160 |
y: { |
|
161 |
beginAtZero: true |
|
162 |
} |
|
163 |
} |
|
164 |
} |
|
165 |
}); |
|
166 |
}; |
|
167 |
|
|
45 | 168 |
ns.cv_tabs_init = function () { |
46 | 169 |
$("#customer_vendor_tabs").on('tabsbeforeactivate', function(event, ui){ |
47 | 170 |
if (ui.newPanel.attr('id') == 'quotations') { |
js/locale/de.js | ||
---|---|---|
101 | 101 |
"Mon":"Mo", |
102 | 102 |
"Monday":"Montag", |
103 | 103 |
"More than one file selected, please set only one checkbox!":"Mehr als ein Element selektiert, bitte nur eine Box anklicken", |
104 |
"Net.Turnover":"Netto Umsatz", |
|
104 | 105 |
"Next month":"nächster Monat", |
105 | 106 |
"No":"Nein", |
106 | 107 |
"No article has been selected yet.":"Es wurde noch kein Artikel ausgewählt.", |
js/locale/en.js | ||
---|---|---|
101 | 101 |
"Mon":"", |
102 | 102 |
"Monday":"", |
103 | 103 |
"More than one file selected, please set only one checkbox!":"", |
104 |
"Net.Turnover":"", |
|
104 | 105 |
"Next month":"", |
105 | 106 |
"No":"", |
106 | 107 |
"No article has been selected yet.":"", |
locale/de/all | ||
---|---|---|
2225 | 2225 |
'Monat' => 'Monat', |
2226 | 2226 |
'Monday' => 'Montag', |
2227 | 2227 |
'Month' => 'Monat', |
2228 |
'Month as chart' => 'Monat als Grafik', |
|
2228 | 2229 |
'Month/Year' => 'Monat/Jahr', |
2229 | 2230 |
'Monthly' => 'monatlich', |
2230 | 2231 |
'More than one control file with the tag \'%s\' exist.' => 'Es gibt mehr als eine Kontrolldatei mit dem Tag \'%s\'.', |
... | ... | |
4477 | 4478 |
'X' => 'X', |
4478 | 4479 |
'YYYY' => 'JJJJ', |
4479 | 4480 |
'Year' => 'Jahr', |
4481 |
'Year as chart' => 'Jahr als Grafik', |
|
4480 | 4482 |
'Year-end bookings were successfully completed!' => 'Die Jahresabschlußbuchungen wurden erfolgreich durchgeführt!', |
4481 | 4483 |
'Year-end closing' => 'Jahresabschluß', |
4482 | 4484 |
'Year-end date' => 'Jahresabschlußdatum', |
locale/en/all | ||
---|---|---|
2158 | 2158 |
'Monat' => '', |
2159 | 2159 |
'Monday' => '', |
2160 | 2160 |
'Month' => '', |
2161 |
'Month as chart' => '', |
|
2161 | 2162 |
'Month/Year' => '', |
2162 | 2163 |
'Monthly' => '', |
2163 | 2164 |
'More than one control file with the tag \'%s\' exist.' => '', |
... | ... | |
4346 | 4347 |
'X' => '', |
4347 | 4348 |
'YYYY' => '', |
4348 | 4349 |
'Year' => '', |
4350 |
'Year as chart' => '', |
|
4349 | 4351 |
'Year-end bookings were successfully completed!' => '', |
4350 | 4352 |
'Year-end closing' => '', |
4351 | 4353 |
'Year-end date' => '', |
templates/webpages/customer_vendor_turnover/turnover_statistic.html | ||
---|---|---|
5 | 5 |
<p> |
6 | 6 |
[% L.radio_button_tag('period', value='year', label= LxERP.t8('Year'), onclick='kivi.CustomerVendorTurnover.show_turnover_stat("y");') %] |
7 | 7 |
|
8 |
[% L.radio_button_tag('period', value='year_chart', label= LxERP.t8('Year as chart'), onclick='kivi.CustomerVendorTurnover.show_turnover_chart("y");') %] |
|
9 |
|
|
8 | 10 |
[% L.radio_button_tag('period', value='month', label= LxERP.t8('Month'), onclick='kivi.CustomerVendorTurnover.show_turnover_stat("m");') %] |
11 |
|
|
12 |
[% L.radio_button_tag('period', value='month_chart', label= LxERP.t8('Month as chart'), onclick='kivi.CustomerVendorTurnover.show_turnover_chart("m");') %] |
|
9 | 13 |
</p> |
10 | 14 |
<div id="turnovers"></div> |
Auch abrufbar als: Unified diff
Kunden-/Lieferanten-Umsatzstatistik als Chart (chart.js)