将数据从数据库格式化为Highcharts系列格式

Question

我有来自数据库的数据

var data = [{
"plants_ref_id": "1",
"plant_name": "MCW",
"employees_data": "1,1,21,21"
}, {
"plants_ref_id": "2",
"plant_name": "VGU",
"employees_data": "2,3,12,12"
}];

和静态数组

var incidents = ['Near miss', 'High Potential Near miss', 'First-aid cases', 'LTI'];

我正在尝试将此数据转换为特定格式，以便将Highcharts显示为https://jsfiddle.net/94uvmL95/1/

我已经在上面的小提琴链接中手动给出了系列。

如何使用变量数据和事件生成序列

Answer 1

试试这个函数

function like_add(data){
var Nearmiss=[];
var HighPotential=[];
var FirstAid=[];
var LTI=[];
$.each(data,function () {
var values=this.employees_data.split(',');
Nearmiss.push(parseInt(values[0]));
HighPotential.push(parseInt(values[1]));
FirstAid.push(parseInt(values[2]));
LTI.push(parseInt(values[3]));
});
var incidents = [Nearmiss, HighPotential, FirstAid,LTI];
return incidents;
}
var data =[{"plants_ref_id":"1","plant_name":"MCW","employees_data":"1,1,21,21"},{"plants_ref_id":"2","plant_name":"VGU","employees_data":"2,3,12,12"}];
var incidents=like_add(data);
alert(incidents.toSource());

只需查看此处 jsfiddle.net