Bonjour,

J'ai besoin d'une piste pour etre capable d'afficher un graphique via Chart.js, en utilisant une requete mysql formattée en JSON.

Voici le resultat de ma requete : depuis la page :

http://localhost/seb/data_pxt_inputs_bday.php

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
 
[{"Date_in":"2018-09-14","Inc_in":"11","Srq_in":"53","Total":"64"},{"Date_in":"2018-09-17","Inc_in":"20","Srq_in":"55","Total":"75"},{"Date_in":"2018-09-18","Inc_in":"12","Srq_in":"52","Total":"64"},{"Date_in":"2018-09-19","Inc_in":"19","Srq_in":"43","Total":"62"},{"Date_in":"2018-09-20","Inc_in":"23","Srq_in":"54","Total":"77"},{"Date_in":"2018-09-21","Inc_in":"17","Srq_in":"58","Total":"75"},{"Date_in":"2018-09-22","Inc_in":"1","Srq_in":"0","Total":"1"},{"Date_in":"2018-09-23","Inc_in":"0","Srq_in":"2","Total":"2"},{"Date_in":"2018-09-24","Inc_in":"19","Srq_in":"61","Total":"80"},{"Date_in":"2018-09-25","Inc_in":"16","Srq_in":"45","Total":"61"},{"Date_in":"2018-09-26","Inc_in":"16","Srq_in":"48","Total":"64"},{"Date_in":"2018-09-27","Inc_in":"15","Srq_in":"53","Total":"70"},{"Date_in":"2018-09-28","Inc_in":"11","Srq_in":"49","Total":"60"},{"Date_in":"2018-09-29","Inc_in":"2","Srq_in":"2","Total":"4"},{"Date_in":"2018-09-30","Inc_in":"1","Srq_in":"0","Total":"1"},{"Date_in":"2018-10-01","Inc_in":"22","Srq_in":"80","Total":"102"},{"Date_in":"2018-10-02","Inc_in":"17","Srq_in":"49","Total":"68"},{"Date_in":"2018-10-03","Inc_in":"11","Srq_in":"47","Total":"58"},{"Date_in":"2018-10-04","Inc_in":"12","Srq_in":"61","Total":"74"},{"Date_in":"2018-10-05","Inc_in":"11","Srq_in":"33","Total":"44"},{"Date_in":"2018-10-07","Inc_in":"2","Srq_in":"0","Total":"2"},{"Date_in":"2018-10-08","Inc_in":"22","Srq_in":"54","Total":"76"},{"Date_in":"2018-10-09","Inc_in":"21","Srq_in":"50","Total":"71"},{"Date_in":"2018-10-10","Inc_in":"20","Srq_in":"43","Total":"63"},{"Date_in":"2018-10-11","Inc_in":"13","Srq_in":"52","Total":"65"},{"Date_in":"2018-10-12","Inc_in":"13","Srq_in":"51","Total":"64"},{"Date_in":"2018-10-13","Inc_in":"0","Srq_in":"1","Total":"1"}]
Voici mon bout de script, qui recupere bien les données

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
 
script  type="text/javascript" > 
 
 
// RECUPERATION DES DONNES JSON GENEREES PAR LA REQUETE MYSQL
var jsonData = $.ajax({
	  method: 'GET',
      url: 'data_pxt_inputs_bday.php',
      dataType: 'json',
    }).done(function (results){
	// AFFICHE DANS LA CONSOLE LE RESULTAT DU SCRIPT
	// console.log(results);
 
var tableau = {
                // Axe x => Dates
                x: [],
                // Axe y1 => incidents
                y1: [],
                 // Axe y2 => Request
                y2: [],
                 // Axe y3 => TOTAL
                y3: []
            };
var len = results.length;
 
for (var i = 0; i < len; i++) {
                tableau.x.push(results[i].Date_in);   	//On place le score Date_in => variable tableau.x
                tableau.y1.push(results[i].Inc_in);   	//On place le score Inc_in => variable tableau.y1
                tableau.y2.push(results[i].Srq_in); 	//On place le score Srq_in => variable tableau.y2
                tableau.y3.push(results[i].Total); 		//On place le score Total => variable tableau.y3
            }
// AFFICHE LE TABLEAU
console.log(tableau);
 
 
 
 
 
 
var data = {
                labels: ["tableau test"],
                datasets: [
                    {
                        label: tableau.x, //Libelle du site
                        backgroundColor: "rgba(255,221,50,0.2)",
                        borderColor: "rgba(255,221,50,1)",
                        data: [{
                                x: tableau.x, //Score 1
                                y: tableau.y1, //Score 2
                                r: 10
                            }]
                    }
                ]
            };
 
 
});
</script>
A partir de là, je seche. Je ne saisi pas comment formater mes données pour l'affichage par Chart.js.
Surement une notion sur les tableaux qui m'echappe.

Merci par avance.