google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart(result) {
var data = new google.visualization.DataTable();
data.addColumn('date', 'Date');
data.addColumn('timeofday','Time');
data.addColumn({type: 'string', role: 'tooltip'});
var jsonResult = jQuery.parseJSON(result);
var resultQuery = jsonResult.length;
$.each(jsonResult, function(k, v) {
var d = new Date(v.timestart);
data.addRow([new Date(d.getFullYear(), d.getMonth(), d.getDate()), [d.getHours(), d.getMinutes(), d.getSeconds(), d.getMilliseconds()],v.file]);
});
var options = {
legend: 'none',
vAxis: {
title: "Time",
titleTextStyle: {italic: false},
format: 'HH:mm',
gridlines: {
color: 'transparent'
}
},
hAxis: {
title: "Date",
titleTextStyle: {italic: false},
gridlines: {
color: 'transparent'
}
},
explorer: {
actions: ['dragToZoom', 'rightClickToReset']
}
/*explorer: {
maxZoomOut:2,
keepInBounds: true
}*/
};
var chart = new google.visualization.ScatterChart(document.getElementById('chart_div'));
chart.draw(data, options);
return resultQuery;
}