Blame view

app/main/static/js/charges.js 14.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

cfc5bded   hitier   More chart classe...
68
69
70
71
72
73
    // Create a download button inside the div contaning svg chart
    var dl_btn = d3.select(div_selector).append("button")
        .text('png')
        .attr('class', 'export')
        .on('click', download_png)

54e2baa6   hitier   Add charge charts...
74
    const svg = d3.select(div_selector).append("svg")
cfc5bded   hitier   More chart classe...
75
        .attr("class", "svg_chart")
54e2baa6   hitier   Add charge charts...
76
77
78
79
80
        .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
81
    const tooltip = d3.select('html')
f9fef9d0   hitier   Add tooltip
82
83
84
85
86
87
88
89
90
91
92
93
94
        .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...
95
            .duration(900)
f9fef9d0   hitier   Add tooltip
96
97
98
99
100
101
            .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...
102
103
104
105
106
107
108
109
110
        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
111
112
113
114
115
        tooltip
            .transition()
            .duration(200)
            .style("opacity", 1);
        tooltip
582e1ee2   hitier   Change charts leg...
116
            .html("<b>" + category_title + ":</b> " + category_name + "<br>" + "<b>Charge:</b> " + category_charge + " ETP")
f9fef9d0   hitier   Add tooltip
117
118
119
120
            .style("left", (e.pageX - tooltip_offset.dx) + "px")
            .style("top", (e.pageY - tooltip_offset.dy) + "px")
    }

f9c1f568   hitier   Add dot on total ...
121
122
123
124
125
126
    var mouseleavedot = function (e, d) {
        d3.select(this).transition()
            .duration(1)
            .attr("r", dot_radius);
        mouseleave(d);
    }
6b44860d   hitier   Make a draw_line ...
127

f9c1f568   hitier   Add dot on total ...
128
129
130
131
132
133
134
135
136
    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...
137
            .html("<b>" + d.period + ": </b>" + d.total + " ETP")
f9c1f568   hitier   Add dot on total ...
138
139
140
141
            .style("left", (e.pageX - tooltip_offset_dot.dx) + "px")
            .style("top", (e.pageY - tooltip_offset_dot.dy) + "px")
    }

f0706d95   hitier   Add color legend
142
143
    var addlegend = function (color_scale) {

13c144c8   Anais Amato   Add horizontal le...
144
        // add horizontal legend
f0706d95   hitier   Add color legend
145
        let reverse_keys = color_scale.domain().reverse();
13c144c8   Anais Amato   Add horizontal le...
146
        var legendSpacing = 5;
f0706d95   hitier   Add color legend
147

13c144c8   Anais Amato   Add horizontal le...
148
149
150
        var legendWrap = svg.append('g')
            .attr('width', '100%')
            .attr('class', 'legendwrap');
f0706d95   hitier   Add color legend
151

13c144c8   Anais Amato   Add horizontal le...
152
        var legend = svg.select('.legendwrap').selectAll('.legend')
f0706d95   hitier   Add color legend
153
            .data(reverse_keys)
13c144c8   Anais Amato   Add horizontal le...
154
155
156
            .enter()
            .append('g')
            .attr('class', 'legend');
f0706d95   hitier   Add color legend
157

13c144c8   Anais Amato   Add horizontal le...
158
159
160
161
        legend.append('rect')
            .attr('width', legendRectSize)
            .attr('height', legendRectSize)
            .style('fill', color_scale)
cfc5bded   hitier   More chart classe...
162
            .attr('class', 'legend');
13c144c8   Anais Amato   Add horizontal le...
163
164

        legend.append('text')
f0706d95   hitier   Add color legend
165
            .attr('class', 'legend')
13c144c8   Anais Amato   Add horizontal le...
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
            .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
198
199
    }

83d933c9   hitier   New draw_categori...
200
201
    function draw_categories_grouped(data, categories) {

a07df204   hitier   Compute for group...
202
203
        var y_max = d3.max(data, function (d) {
            return d3.max(categories, function (c) {
a5294567   hitier   Rewrite anonymous...
204
                return +d[c]
a07df204   hitier   Compute for group...
205
206
207
208
            })
        });
        y_max = y_max * height_ratio
        yScale.domain([0, y_max])
83d933c9   hitier   New draw_categori...
209
210
211
212
        // Another scale for subgroup position
        var xCategories = d3.scaleBand()
            .domain(categories)
            .range([0, xScale.bandwidth()])
67ab2300   hitier   Fix appearance de...
213
            .padding([0.2])
83d933c9   hitier   New draw_categori...
214
215
216
217
218
219
220

        svg.append("g")
            .selectAll("g")
            // Enter in data = loop group per group
            .data(data)
            .enter()
            .append("g")
a5294567   hitier   Rewrite anonymous...
221
            .attr("transform", d => "translate(" + xScale(d.period) + ",0)")
83d933c9   hitier   New draw_categori...
222
223
224
225
226
227
228
            .selectAll("rect")
            .data(function (d) {
                return categories.map(function (key) {
                    return {key: key, value: d[key]};
                });
            })
            .enter().append("rect")
a5294567   hitier   Rewrite anonymous...
229
230
            .attr("x", d => xCategories(d.key))
            .attr("y", d => yScale(d.value))
83d933c9   hitier   New draw_categori...
231
            .attr("width", xCategories.bandwidth())
a5294567   hitier   Rewrite anonymous...
232
            .attr("height", d => height - yScale(d.value))
22397f43   hitier   Show tooltip on g...
233
            .attr("fill", d => colorScale(d.key))
ec07c812   hitier   Fix hover on grou...
234
            .attr("class", "bar")
22397f43   hitier   Show tooltip on g...
235
236
237
            .on("mouseover", mouseovergrouped)
            .on("mousemove", mousemove)
            .on("mouseleave", mouseleave);
83d933c9   hitier   New draw_categori...
238

a48677c4   hitier   Make a draw_categ...
239
240
    }

83d933c9   hitier   New draw_categori...
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
    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...
261
        // first draw one group for one category containing all bars over periods
a48677c4   hitier   Make a draw_categ...
262
263
264
265
        let groups = svg.selectAll("g.category")
            .data(stacked_data)
            .enter()
            .append("g")
83d933c9   hitier   New draw_categori...
266
            .style("fill", (d) => colorScale(d.key));
a48677c4   hitier   Make a draw_categ...
267

90c7b0e4   hitier   Small comments an...
268
        // then draw each period/category bar
a48677c4   hitier   Make a draw_categ...
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
        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 ...
285
286
    function draw_totalcharge_line(data) {
        // Build the total charge by period;
518c7cc5   hitier   Draw the total ca...
287
288
        // it will be used for the line drawing above bars.
        //
6b44860d   hitier   Make a draw_line ...
289
290
        var periods_total_charge = []

518c7cc5   hitier   Draw the total ca...
291
292
293
294
295
        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...
296
            row['total'] = roundToTwo(d3.sum(period_values))
518c7cc5   hitier   Draw the total ca...
297
298
299
            periods_total_charge.push(row)
        });

6b44860d   hitier   Make a draw_line ...
300
301
302
303
304
305
306
307
308
309
        // 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...
310
311
            .attr("d", line)
            .lower();// set it below bars if called after
6b44860d   hitier   Make a draw_line ...
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326

        // 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...
327
328
            .on("mouseleave", mouseleavedot)
            .lower();// set it below bars if called after
6b44860d   hitier   Make a draw_line ...
329
330
331
332
333
        ;

    }

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

6b44860d   hitier   Make a draw_line ...
338
339
340
        var periods = d3.map(data, d => d.period)
        xScale.domain(periods)

90c7b0e4   hitier   Small comments an...
341
342
        // Filter datas to only keep non zero categories
        // TODO: should be done on server (python/flask) side
518c7cc5   hitier   Draw the total ca...
343
        //
90c7b0e4   hitier   Small comments an...
344
        // 1- Get the charge sum for each category over periods
f0706d95   hitier   Add color legend
345
        // That will leave '0' to categories with no charge at all
a07df204   hitier   Compute for group...
346
        // TODO: to be done with Object.keys, Object.values and d3 filtering methods
ce5f45ea   hitier   Fix data bug
347
        //
6b44860d   hitier   Make a draw_line ...
348
        var categories_total_charge = {}
f0706d95   hitier   Add color legend
349
350
        data.forEach(function (d) {
            Object.keys(d).forEach(function (k) {
04f2b6e8   hitier   Fix period as cat...
351
352
353
                    if (k === 'period') {
                        return;
                    }
f0706d95   hitier   Add color legend
354
355
356
                    if (categories_total_charge.hasOwnProperty(k)) {
                        categories_total_charge[k] += +d[k]
                    } else {
582e1ee2   hitier   Change charts leg...
357
                        categories_total_charge[k] = +d[k]
f0706d95   hitier   Add color legend
358
                    }
966f9b78   hitier   Js Round float be...
359
                    categories_total_charge[k] = roundToTwo(categories_total_charge[k])
f0706d95   hitier   Add color legend
360
361
362
363
                }
            )
        })

518c7cc5   hitier   Draw the total ca...
364
        // 2- Now, filter only categories that have a non-zero charge
a07df204   hitier   Compute for group...
365
        // TODO: to be done with Object.keys, Object.values and d3 filtering methods
90c7b0e4   hitier   Small comments an...
366
        //
f0706d95   hitier   Add color legend
367
368
369
370
371
372
373
        var categories = []
        for (var key in categories_total_charge) {
            if (categories_total_charge[key] > 0) {
                categories.push(key)
            }
        }

518c7cc5   hitier   Draw the total ca...
374
        //
90c7b0e4   hitier   Small comments an...
375
        // Draw the  bars, stacked or grouped
83d933c9   hitier   New draw_categori...
376
377
        //
        draw_categories_bars(data, categories)
54e2baa6   hitier   Add charge charts...
378

518c7cc5   hitier   Draw the total ca...
379
        //
83d933c9   hitier   New draw_categori...
380
381
382
383
384
385
386
387
388
389
        //  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...
390

f0706d95   hitier   Add color legend
391
392
        // Xaxis
        //
518c7cc5   hitier   Draw the total ca...
393
        const xAxis = d3.axisBottom(xScale)
f0706d95   hitier   Add color legend
394

f0706d95   hitier   Add color legend
395
        // Draw Xaxis
68fd83a8   hitier   Add axis
396
        svg.append("g")
cfc5bded   hitier   More chart classe...
397
            .attr("class", "x_axis")
68fd83a8   hitier   Add axis
398
399
400
401
402
403
404
405
            .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...
406
407
408
409
410
        // Yaxis
        //
        const yAxis = d3.axisLeft(yScale)
            .ticks(y_ticks_num)

f0706d95   hitier   Add color legend
411
        // Draw Yaxis
68fd83a8   hitier   Add axis
412
        svg.append("g")
cfc5bded   hitier   More chart classe...
413
            .attr("class", "y_axis")
68fd83a8   hitier   Add axis
414
            .call(yAxis)
68fd83a8   hitier   Add axis
415

ff5fd5bf   hitier   Less and Longer ...
416
417
418
419
420
421
422
423
424
425
        // 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...
426
            .lower();// set it below bars if called after
ff5fd5bf   hitier   Less and Longer ...
427

f0706d95   hitier   Add color legend
428
        // Write Y axis title
68fd83a8   hitier   Add axis
429
430
431
432
433
        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...
434
            .text("Charge en ETP");
54e2baa6   hitier   Add charge charts...
435

6b44860d   hitier   Make a draw_line ...
436
        //
f0706d95   hitier   Add color legend
437
        // Write chart Title
6b44860d   hitier   Make a draw_line ...
438
439
        //

f0706d95   hitier   Add color legend
440
        // part 1
de63cb72   hitier   Add title to proj...
441
        svg.append("text")
3c21ae9f   hitier   Change bar colors
442
443
444
445
            .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...
446
            .text(entity_name);
f0706d95   hitier   Add color legend
447
        // part 2
de63cb72   hitier   Add title to proj...
448
        svg.append("text")
3c21ae9f   hitier   Change bar colors
449
450
451
452
453
            .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...
454

518c7cc5   hitier   Draw the total ca...
455

6b44860d   hitier   Make a draw_line ...
456
    }); // end of d3.csv().then({})
54e2baa6   hitier   Add charge charts...
457
458

}