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
Voici mon bout de script, qui recupere bien les données
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"}]
A partir de là, je seche. Je ne saisi pas comment formater mes données pour l'affichage par Chart.js.
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>
Surement une notion sur les tableaux qui m'echappe.
Merci par avance.
Partager