Blame view

app/main/static/js/charges.js 15.6 KB
5e6f4e07   hitier   Set Rokotyan Solu...
1
/* Round float to two decimals only */
966f9b78   hitier   Js Round float be...
2
3
4
5
function roundToTwo(num) {
    return +(Math.round(num + "e+2")  + "e-2");
}

90c7b0e4   hitier   Small comments an...
6
7
function build_chart(div_selector, data_url, entity_name, category_type) {

5f89fdc7   hitier   Fix color scale: ...
8
    const main_elt = document.getElementById("main")
7c1b38be   hitier   Draw charts to fi...
9

13c144c8   Anais Amato   Add horizontal le...
10
    const margin = {top: 60, right: 150, bottom: 200, left: 90},
5f89fdc7   hitier   Fix color scale: ...
11
        width = main_elt.offsetWidth * 0.95 - margin.left - margin.right,
13c144c8   Anais Amato   Add horizontal le...
12
        height = 600 - margin.top - margin.bottom;
54e2baa6   hitier   Add charge charts...
13

90c7b0e4   hitier   Small comments an...
14
    const height_ratio = 1.2;    // how murch room to give above chart for lisibility
ff5fd5bf   hitier   Less and Longer ...
15

5f89fdc7   hitier   Fix color scale: ...
16
17
    const tooltip_offset = {dx: 0, dy: 100}
    const tooltip_offset_dot = {dx: 20, dy: 60}
f9fef9d0   hitier   Add tooltip
18

90c7b0e4   hitier   Small comments an...
19
    const y_ticks_num = 5        // dont show to many y ticks for lisibility
f0706d95   hitier   Add color legend
20

13c144c8   Anais Amato   Add horizontal le...
21
22
23
24
25
    const legendRectSize = 15; // size of rectangle in legend

    // const legend_cell_size = 15; // size of legend colored scare
    // const legend_x = width + 20; // begin legend a bit after the end of the chart
    // const legend_y = 600 - margin.bottom + 20; // begin legend a bit after the end of the chart
54e2baa6   hitier   Add charge charts...
26

90c7b0e4   hitier   Small comments an...
27
    const dot_radius = 6;        // size of total line dot
f9c1f568   hitier   Add dot on total ...
28

5f89fdc7   hitier   Fix color scale: ...
29
30
    const xScale = d3.scaleBand()
        .range([0, width])
67ab2300   hitier   Fix appearance de...
31
        .padding(0.4);
6b44860d   hitier   Make a draw_line ...
32

5f89fdc7   hitier   Fix color scale: ...
33
    const yScale = d3.scaleLinear()
90c7b0e4   hitier   Small comments an...
34
        .range([height, 0]);
54e2baa6   hitier   Add charge charts...
35

90c7b0e4   hitier   Small comments an...
36
    var colorScale = d3.scaleOrdinal([]); //  Will be really set later by category type
de63cb72   hitier   Add title to proj...
37

90c7b0e4   hitier   Small comments an...
38
39
40
41

    //
    // Configure chart by the category given as arg
    //
83d933c9   hitier   New draw_categori...
42
43
    var chart_title = ""
    var category_title = ""
90c7b0e4   hitier   Small comments an...
44
45
    var draw_total_line = () => void 0;
    var draw_categories_bars = () => void 0;
7d095c38   hitier   One color scale b...
46

90c7b0e4   hitier   Small comments an...
47
    if (category_type == 'capacity') {
83d933c9   hitier   New draw_categori...
48
49
50
51
        chart_title = "Charges par fonction"
        category_title = "Fonction"
        //draw_total_line
        draw_categories_bars = draw_categories_grouped
7d095c38   hitier   One color scale b...
52
        colorScale = d3.scaleOrdinal(d3.schemeSet3);
90c7b0e4   hitier   Small comments an...
53
    } else if (category_type == 'service') {
83d933c9   hitier   New draw_categori...
54
55
56
57
        chart_title = "Charges par service"
        category_title = "Service"
        draw_total_line = draw_totalcharge_line
        draw_categories_bars = draw_categories_stacked
7d095c38   hitier   One color scale b...
58
        colorScale = d3.scaleOrdinal(d3.schemeTableau10);
90c7b0e4   hitier   Small comments an...
59
    } else if (category_type == 'project') {
c8b7caf5   hitier   Agent now uses co...
60
61
62
63
        chart_title = "Charges par projet"
        category_title = "Projet"
        draw_categories_bars = draw_categories_stacked
        colorScale = d3.scaleOrdinal(d3.schemeTableau10);
6b44860d   hitier   Make a draw_line ...
64
65
    } else {
        alert("ALERT ! Every body shall quit the boat, we are sinking ! ALERT !")
de63cb72   hitier   Add title to proj...
66
    }
54e2baa6   hitier   Add charge charts...
67

a30b11ff   Anais Amato   Add an 'export me...
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    // Configure the tooltip to export svg to png or csv
    var update_export_menu = function (e, d) {

        const tooltip_test = document.getElementsByClassName('tooltip_hamburger');

        if (tooltip_test.length == 0) {
            d3.select(".tooltip_hamburger").remove();

            const tooltip_hamburger = hamburger.append("div")
                .style("opacity", 0)
                .attr("class", "tooltip tooltip_hamburger");

            d3.select(this).transition()
                .duration(1)
            tooltip_hamburger
                .transition()
                .duration(200)
                .style("opacity", 1)
            tooltip_hamburger
                .html("<span>Export </span>" +
                    "<li>To CSV</li>" +
                    "<li id='to_png'>To PNG</li>")
            d3.select("#to_png").on("click", download_png);
        } else {
            d3.select(".tooltip_hamburger").remove();
        }

    }
cfc5bded   hitier   More chart classe...
96
    // Create a download button inside the div contaning svg chart
a30b11ff   Anais Amato   Add an 'export me...
97
98
99
100
    const hamburger = d3.select(div_selector).append('i')
        .attr('class', 'fas fa-bars fa-lg export')
        .on("click", update_export_menu);

cfc5bded   hitier   More chart classe...
101

54e2baa6   hitier   Add charge charts...
102
    const svg = d3.select(div_selector).append("svg")
cfc5bded   hitier   More chart classe...
103
        .attr("class", "svg_chart")
54e2baa6   hitier   Add charge charts...
104
105
106
107
108
        .attr("width", width + margin.left + margin.right)
        .attr("height", height + margin.top + margin.bottom)
        .append("g")
        .attr("transform", "translate(" + margin.left + "," + margin.top + ")");

069a5102   hitier   Fixed tooltip
109
    const tooltip = d3.select('html')
f9fef9d0   hitier   Add tooltip
110
111
112
113
114
115
116
117
118
119
120
121
122
        .append("div")
        .style("opacity", 0)
        .attr("class", "tooltip")

    var mousemove = function (e, d) {
        tooltip
            .style("left", (e.pageX - tooltip_offset.dx) + "px")
            .style("top", (e.pageY - tooltip_offset.dy) + "px")
    }

    var mouseleave = function (d) {
        tooltip
            .transition()
67ab2300   hitier   Fix appearance de...
123
            .duration(900)
f9fef9d0   hitier   Add tooltip
124
125
126
127
128
129
            .style("opacity", 0)
    }

    var mouseover = function (e, d) {
        var category_name = d3.select(this.parentNode).datum().key
        var category_charge = d.data[category_name]
22397f43   hitier   Show tooltip on g...
130
131
132
133
134
135
136
137
138
        show_tooltip(e, category_name, category_charge)
    }

    var mouseovergrouped = function (e, d) {
        var category_name = d.key
        var category_charge = d.value
        show_tooltip(e, category_name, category_charge)
    }
    var show_tooltip = function (e, category_name, category_charge) {
f9fef9d0   hitier   Add tooltip
139
140
141
142
143
        tooltip
            .transition()
            .duration(200)
            .style("opacity", 1);
        tooltip
582e1ee2   hitier   Change charts leg...
144
            .html("<b>" + category_title + ":</b> " + category_name + "<br>" + "<b>Charge:</b> " + category_charge + " ETP")
f9fef9d0   hitier   Add tooltip
145
146
147
148
            .style("left", (e.pageX - tooltip_offset.dx) + "px")
            .style("top", (e.pageY - tooltip_offset.dy) + "px")
    }

f9c1f568   hitier   Add dot on total ...
149
150
151
152
153
154
    var mouseleavedot = function (e, d) {
        d3.select(this).transition()
            .duration(1)
            .attr("r", dot_radius);
        mouseleave(d);
    }
6b44860d   hitier   Make a draw_line ...
155

f9c1f568   hitier   Add dot on total ...
156
157
158
159
160
161
162
163
164
    var mouseoverdot = function (e, d) {
        d3.select(this).transition()
            .duration(1)
            .attr("r", dot_radius * 1.5);
        tooltip
            .transition()
            .duration(200)
            .style("opacity", 1)
        tooltip
582e1ee2   hitier   Change charts leg...
165
            .html("<b>" + d.period + ": </b>" + d.total + " ETP")
f9c1f568   hitier   Add dot on total ...
166
167
168
169
            .style("left", (e.pageX - tooltip_offset_dot.dx) + "px")
            .style("top", (e.pageY - tooltip_offset_dot.dy) + "px")
    }

f0706d95   hitier   Add color legend
170
171
    var addlegend = function (color_scale) {

13c144c8   Anais Amato   Add horizontal le...
172
        // add horizontal legend
48613832   hitier   Fix legend keys o...
173
        let legend_keys = color_scale.domain();
13c144c8   Anais Amato   Add horizontal le...
174
        var legendSpacing = 5;
f0706d95   hitier   Add color legend
175

13c144c8   Anais Amato   Add horizontal le...
176
177
178
        var legendWrap = svg.append('g')
            .attr('width', '100%')
            .attr('class', 'legendwrap');
f0706d95   hitier   Add color legend
179

13c144c8   Anais Amato   Add horizontal le...
180
        var legend = svg.select('.legendwrap').selectAll('.legend')
48613832   hitier   Fix legend keys o...
181
            .data(legend_keys)
13c144c8   Anais Amato   Add horizontal le...
182
183
184
            .enter()
            .append('g')
            .attr('class', 'legend');
f0706d95   hitier   Add color legend
185

13c144c8   Anais Amato   Add horizontal le...
186
187
188
189
        legend.append('rect')
            .attr('width', legendRectSize)
            .attr('height', legendRectSize)
            .style('fill', color_scale)
cfc5bded   hitier   More chart classe...
190
            .attr('class', 'legend');
13c144c8   Anais Amato   Add horizontal le...
191
192

        legend.append('text')
f0706d95   hitier   Add color legend
193
            .attr('class', 'legend')
13c144c8   Anais Amato   Add horizontal le...
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
            .attr('x', legendRectSize + legendSpacing * 1.5)
            .attr('y', 13)
            .text(function(d) {
                return d;
            });

        var ypos = 0,
            newxpos = 0,
            maxwidth = 0,
            xpos;

        legend
            .attr("transform", function(d, i) {
                var length = d3.select(this).select("text").node().getComputedTextLength() + 40;
                xpos = newxpos;
                if (width < xpos + length) {
                    newxpos = xpos = 0;
                    ypos += 30;
                }
                newxpos += length;
                if (newxpos > maxwidth) maxwidth = newxpos;

                return 'translate(' + xpos + ',' + ypos + ')';

            });


        legendWrap
            .attr("transform", function(d, i) {
                return "translate(0 ," + (height + 100) + ")";
            });

f0706d95   hitier   Add color legend
226
227
    }

83d933c9   hitier   New draw_categori...
228
229
    function draw_categories_grouped(data, categories) {

a07df204   hitier   Compute for group...
230
231
        var y_max = d3.max(data, function (d) {
            return d3.max(categories, function (c) {
a5294567   hitier   Rewrite anonymous...
232
                return +d[c]
a07df204   hitier   Compute for group...
233
234
235
236
            })
        });
        y_max = y_max * height_ratio
        yScale.domain([0, y_max])
83d933c9   hitier   New draw_categori...
237
238
239
240
        // Another scale for subgroup position
        var xCategories = d3.scaleBand()
            .domain(categories)
            .range([0, xScale.bandwidth()])
67ab2300   hitier   Fix appearance de...
241
            .padding([0.2])
83d933c9   hitier   New draw_categori...
242
243
244
245
246
247
248

        svg.append("g")
            .selectAll("g")
            // Enter in data = loop group per group
            .data(data)
            .enter()
            .append("g")
a5294567   hitier   Rewrite anonymous...
249
            .attr("transform", d => "translate(" + xScale(d.period) + ",0)")
83d933c9   hitier   New draw_categori...
250
251
252
253
254
255
256
            .selectAll("rect")
            .data(function (d) {
                return categories.map(function (key) {
                    return {key: key, value: d[key]};
                });
            })
            .enter().append("rect")
a5294567   hitier   Rewrite anonymous...
257
258
            .attr("x", d => xCategories(d.key))
            .attr("y", d => yScale(d.value))
83d933c9   hitier   New draw_categori...
259
            .attr("width", xCategories.bandwidth())
a5294567   hitier   Rewrite anonymous...
260
            .attr("height", d => height - yScale(d.value))
22397f43   hitier   Show tooltip on g...
261
            .attr("fill", d => colorScale(d.key))
ec07c812   hitier   Fix hover on grou...
262
            .attr("class", "bar")
22397f43   hitier   Show tooltip on g...
263
264
265
            .on("mouseover", mouseovergrouped)
            .on("mousemove", mousemove)
            .on("mouseleave", mouseleave);
83d933c9   hitier   New draw_categori...
266

a48677c4   hitier   Make a draw_categ...
267
268
    }

83d933c9   hitier   New draw_categori...
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
    function draw_categories_stacked(data, categories) {

        // Now build the stacked data for stacked bars
        //
        var stack = d3.stack()
            .keys(categories)
        // .order(d3.stackOrderNone)
        // .offset(d3.stackOffsetNone);
        var stacked_data = stack(data)

        // Get the max y to plot
        var y_max = d3.max(stacked_data[stacked_data.length - 1], d => d[1]);
        if (y_max == 0) {
            y_max = 100
        }
        // Enhance it by %ratio to leave room on the top of the graph
        y_max = y_max * height_ratio

        yScale.domain([0, y_max]);

90c7b0e4   hitier   Small comments an...
289
        // first draw one group for one category containing all bars over periods
a48677c4   hitier   Make a draw_categ...
290
291
292
293
        let groups = svg.selectAll("g.category")
            .data(stacked_data)
            .enter()
            .append("g")
83d933c9   hitier   New draw_categori...
294
            .style("fill", (d) => colorScale(d.key));
a48677c4   hitier   Make a draw_categ...
295

90c7b0e4   hitier   Small comments an...
296
        // then draw each period/category bar
a48677c4   hitier   Make a draw_categ...
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
        let rect = groups.selectAll("rect")
            .data(d => d)
            .enter()
            .append("rect")
            .attr("class", "bar")
            .attr("x", d => xScale(d.data.period))
            .attr("width", xScale.bandwidth())
            // .attr("width", 5)
            .attr("y", d => yScale(d[1]))
            .attr("height", d => height - yScale(d[1] - d[0]))
            .on("mouseover", mouseover)
            .on("mousemove", mousemove)
            .on("mouseleave", mouseleave);

    }

6b44860d   hitier   Make a draw_line ...
313
314
    function draw_totalcharge_line(data) {
        // Build the total charge by period;
518c7cc5   hitier   Draw the total ca...
315
316
        // it will be used for the line drawing above bars.
        //
6b44860d   hitier   Make a draw_line ...
317
318
        var periods_total_charge = []

518c7cc5   hitier   Draw the total ca...
319
320
321
322
323
        data.forEach(function (d) {
            // get the list of values for all columns except the first one which is the period name
            var period_values = Object.values(d).slice(1)
            var row = {}
            row['period'] = d.period
966f9b78   hitier   Js Round float be...
324
            row['total'] = roundToTwo(d3.sum(period_values))
518c7cc5   hitier   Draw the total ca...
325
326
327
            periods_total_charge.push(row)
        });

6b44860d   hitier   Make a draw_line ...
328
329
330
331
332
333
334
335
336
337
        // the line itselet
        //
        const line = d3.line()
            .x(d => (xScale.bandwidth() / 2) + xScale(d.period)) // décalage pour centrer au milieu des barres
            .y(d => yScale(d.total))
            .curve(d3.curveMonotoneX); // Fonction de courbe permettant de l'adoucir

        svg.append("path")
            .datum(periods_total_charge)
            .attr("class", "total-line")
83d933c9   hitier   New draw_categori...
338
339
            .attr("d", line)
            .lower();// set it below bars if called after
6b44860d   hitier   Make a draw_line ...
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354

        // data dots at each point
        //
        svg.selectAll("line-circle")
            .data(periods_total_charge)
            .enter().append("circle")
            .attr("class", "total-circle")
            .attr("r", dot_radius)
            .attr("cx", function (d) {
                return (xScale.bandwidth() / 2) + xScale(d.period)
            })
            .attr("cy", function (d) {
                return yScale(d.total);
            })
            .on("mouseover", mouseoverdot)
83d933c9   hitier   New draw_categori...
355
356
            .on("mouseleave", mouseleavedot)
            .lower();// set it below bars if called after
6b44860d   hitier   Make a draw_line ...
357
358
359
360

    }

    d3.csv(data_url).then(data => {
a07df204   hitier   Compute for group...
361
        // we could get categories that way,
90c7b0e4   hitier   Small comments an...
362
        // but instead we want to filter by non zero, see later
6b44860d   hitier   Make a draw_line ...
363
        // var categories = data.columns.slice(1)
90c7b0e4   hitier   Small comments an...
364

6b44860d   hitier   Make a draw_line ...
365
366
367
        var periods = d3.map(data, d => d.period)
        xScale.domain(periods)

90c7b0e4   hitier   Small comments an...
368
369
        // Filter datas to only keep non zero categories
        // TODO: should be done on server (python/flask) side
518c7cc5   hitier   Draw the total ca...
370
        //
90c7b0e4   hitier   Small comments an...
371
        // 1- Get the charge sum for each category over periods
f0706d95   hitier   Add color legend
372
        // That will leave '0' to categories with no charge at all
a07df204   hitier   Compute for group...
373
        // TODO: to be done with Object.keys, Object.values and d3 filtering methods
ce5f45ea   hitier   Fix data bug
374
        //
6b44860d   hitier   Make a draw_line ...
375
        var categories_total_charge = {}
f0706d95   hitier   Add color legend
376
377
        data.forEach(function (d) {
            Object.keys(d).forEach(function (k) {
04f2b6e8   hitier   Fix period as cat...
378
379
380
                    if (k === 'period') {
                        return;
                    }
f0706d95   hitier   Add color legend
381
382
383
                    if (categories_total_charge.hasOwnProperty(k)) {
                        categories_total_charge[k] += +d[k]
                    } else {
582e1ee2   hitier   Change charts leg...
384
                        categories_total_charge[k] = +d[k]
f0706d95   hitier   Add color legend
385
                    }
966f9b78   hitier   Js Round float be...
386
                    categories_total_charge[k] = roundToTwo(categories_total_charge[k])
f0706d95   hitier   Add color legend
387
388
389
390
                }
            )
        })

518c7cc5   hitier   Draw the total ca...
391
        // 2- Now, filter only categories that have a non-zero charge
a07df204   hitier   Compute for group...
392
        // TODO: to be done with Object.keys, Object.values and d3 filtering methods
90c7b0e4   hitier   Small comments an...
393
        //
f0706d95   hitier   Add color legend
394
395
396
397
398
399
400
        var categories = []
        for (var key in categories_total_charge) {
            if (categories_total_charge[key] > 0) {
                categories.push(key)
            }
        }

518c7cc5   hitier   Draw the total ca...
401
        //
90c7b0e4   hitier   Small comments an...
402
        // Draw the  bars, stacked or grouped
83d933c9   hitier   New draw_categori...
403
404
        //
        draw_categories_bars(data, categories)
54e2baa6   hitier   Add charge charts...
405

518c7cc5   hitier   Draw the total ca...
406
        //
83d933c9   hitier   New draw_categori...
407
408
409
410
411
412
413
414
415
416
        //  Draw the total charge line ( may be)
        //
        draw_total_line(data, categories)

        //
        // This former list we use as color_scale domain.
        // And that allows us to build the legend
        //
        colorScale.domain(categories)
        addlegend(colorScale)
54e2baa6   hitier   Add charge charts...
417

f0706d95   hitier   Add color legend
418
419
        // Xaxis
        //
518c7cc5   hitier   Draw the total ca...
420
        const xAxis = d3.axisBottom(xScale)
f0706d95   hitier   Add color legend
421

f0706d95   hitier   Add color legend
422
        // Draw Xaxis
68fd83a8   hitier   Add axis
423
        svg.append("g")
cfc5bded   hitier   More chart classe...
424
            .attr("class", "x_axis")
68fd83a8   hitier   Add axis
425
426
427
428
429
430
431
432
            .attr("transform", "translate(0," + height + ")")
            .call(xAxis)
            .selectAll("text")
            .style("text-anchor", "end")
            .attr("dx", "-.9em")
            .attr("dy", ".15em")
            .attr("transform", "rotate(-65)");

90c7b0e4   hitier   Small comments an...
433
434
435
436
437
        // Yaxis
        //
        const yAxis = d3.axisLeft(yScale)
            .ticks(y_ticks_num)

f0706d95   hitier   Add color legend
438
        // Draw Yaxis
68fd83a8   hitier   Add axis
439
        svg.append("g")
cfc5bded   hitier   More chart classe...
440
            .attr("class", "y_axis")
68fd83a8   hitier   Add axis
441
            .call(yAxis)
68fd83a8   hitier   Add axis
442

ff5fd5bf   hitier   Less and Longer ...
443
444
445
446
447
448
449
450
451
452
        // Draw horizontal lines
        svg.selectAll("y axis")
            .data(yScale.ticks(y_ticks_num))
            .enter()
            .append("line")
            .attr("class", d => (d == 0 ? "horizontalY0" : "horizontalY"))
            .attr("x1", 0)
            .attr("x2", width)
            .attr("y1", d => yScale(d))
            .attr("y2", d => yScale(d))
83d933c9   hitier   New draw_categori...
453
            .lower();// set it below bars if called after
ff5fd5bf   hitier   Less and Longer ...
454

f0706d95   hitier   Add color legend
455
        // Write Y axis title
68fd83a8   hitier   Add axis
456
457
458
459
460
        svg.append("text")
            .attr("text-anchor", "end")
            .attr("transform", "rotate(-90)")
            .attr("y", -margin.left + 40)
            .attr("x", -margin.top - 70)
582e1ee2   hitier   Change charts leg...
461
            .text("Charge en ETP");
54e2baa6   hitier   Add charge charts...
462

6b44860d   hitier   Make a draw_line ...
463
        //
f0706d95   hitier   Add color legend
464
        // Write chart Title
6b44860d   hitier   Make a draw_line ...
465
466
        //

f0706d95   hitier   Add color legend
467
        // part 1
de63cb72   hitier   Add title to proj...
468
        svg.append("text")
3c21ae9f   hitier   Change bar colors
469
470
471
472
            .attr("x", (width / 2))
            .attr("y", 0 - (margin.top / 2) - 10)
            .attr("text-anchor", "middle")
            .style("font-size", "16px")
c8b7caf5   hitier   Agent now uses co...
473
            .text(entity_name);
f0706d95   hitier   Add color legend
474
        // part 2
de63cb72   hitier   Add title to proj...
475
        svg.append("text")
3c21ae9f   hitier   Change bar colors
476
477
478
479
480
            .attr("x", (width / 2))
            .attr("y", 0 - (margin.top / 2) + 10)
            .attr("text-anchor", "middle")
            .style("font-size", "12px")
            .text(chart_title);
54e2baa6   hitier   Add charge charts...
481

518c7cc5   hitier   Draw the total ca...
482

6b44860d   hitier   Make a draw_line ...
483
    }); // end of d3.csv().then({})
54e2baa6   hitier   Add charge charts...
484
485

}