linechart线性图动态数据

tabcolstr=[{"colname":"DESCRIPTION","dataType":"VARCHAR2","description":"地点","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM1","dataType":"NUMBER","description":"2014-05","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM2","dataType":"NUMBER","description":"2014-06","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM3","dataType":"NUMBER","description":"2014-07","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM4","dataType":"NUMBER","description":"2014-08","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"}]

 

jsonarray=[{"colname":"DESCRIPTION","dataType":"VARCHAR2","description":"地点","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM1","dataType":"NUMBER","description":"2014-05","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM2","dataType":"NUMBER","description":"2014-06","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM3","dataType":"NUMBER","description":"2014-07","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"},{"colname":"NUM4","dataType":"NUMBER","description":"2014-08","isshow":0,"tabname":"REPORT_CONFIGQUERY_372"}]

 

<script type="text/javascript">
$(function () {
	var tabcolstr='${tabcollist}';
	var tabcoljson = $.parseJSON(tabcolstr);	
	var tabcoldata =  new Array();
	for(var i=1;i<tabcoljson.length;i++){
		tabcoldata[i-1]=tabcoljson[i].description;
	}	
	var jsonarray='${jsonarray}';
	var arraydata = $.parseJSON(jsonarray);
	var first=tabcoljson[0].description;
	var showdata =  new Array();
	var value="";
	for(var i=0;i<arraydata.length;i++){		
		showdata.push([]);
		var valuearray =  new Array();
		for(j=0;j<tabcoldata.length;j++){
			value=arraydata[i][tabcoldata[j]];
			if(value==""){
				value=0;
			}
			valuearray[j]=Number(value);
		}
		var json = {  
            "name":arraydata[i][first],  
            "data":valuearray  
        };
		showdata[i]=json;
	}
	
    $('#histogramcharshow').highcharts({
        title: {
            text: '${reportConfig.name}',
            x: -20 //center
        },
        exporting:{
            enabled:false
        },
        credits: {
            enabled: false
        },
        xAxis: {
        	categories: tabcoldata
            //categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun','Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        },
        yAxis: {
            title: {
                text: '${reportConfig.unit}'
            },
            plotLines: [{
                value: 0,
                width: 1,
                color: '#808080'
            }]
        },
        tooltip: {
            valueSuffix: '°C'
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle',
            borderWidth: 0
        },
        series:showdata
        /*[{
            name: 'Tokyo',
            data: [7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6]
        }, {
            name: 'New York',
            data: [-0.2, 0.8, 5.7, 11.3, 17.0, 22.0, 24.8, 24.1, 20.1, 14.1, 8.6, 2.5]
        }, {
            name: 'Berlin',
            data: [-0.9, 0.6, 3.5, 8.4, 13.5, 17.0, 18.6, 17.9, 14.3, 9.0, 3.9, 1.0]
        }, {
            name: 'London',
            data: [3.9, 4.2, 5.7, 8.5, 11.9, 15.2, 17.0, 16.6, 14.2, 10.3, 6.6, 4.8]
        }]*/
    });
});
</SCRIPT>