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
68
69
70
71
72
73
74

    const svg = d3.select(div_selector).append("svg")
        .attr("id", "svg")
        .attr("width", width + margin.left + margin.right)
        .attr("height", height + margin.top + margin.bottom)
        .append("g")
        .attr("transform", "translate(" + margin.left + "," + margin.top + ")");

5e6f4e07   hitier   Set Rokotyan Solu...
75
76
77
78
79
    // Create a download button inside the div contaning svg chart
    var dl_btn = d3.select(div_selector).append("button")
        .text('png')
        .on('click', download_png)

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

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

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

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

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

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

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

13c144c8   Anais Amato   Add horizontal le...
157
158
159
160
161
162
163
        legend.append('rect')
            .attr('width', legendRectSize)
            .attr('height', legendRectSize)
            .style('fill', color_scale)
            .style('stroke', color_scale);

        legend.append('text')
f0706d95   hitier   Add color legend
164
            .attr('class', 'legend')
13c144c8   Anais Amato   Add horizontal le...
165
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
            .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
197
198
    }

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

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

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

a48677c4   hitier   Make a draw_categ...
238
239
    }

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

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

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

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

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

    }

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

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

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

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

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

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

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

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

f0706d95   hitier   Add color legend
410
        // Draw Yaxis
68fd83a8   hitier   Add axis
411
412
413
        svg.append("g")
            .attr("class", "y axis")
            .call(yAxis)
68fd83a8   hitier   Add axis
414

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

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

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

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

518c7cc5   hitier   Draw the total ca...
454

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

}