javascript - 将数据库中的数据格式化为 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/

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

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

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