63 lines
2.2 KiB
HTML
63 lines
2.2 KiB
HTML
<html>
|
|
<head>
|
|
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
|
|
<script type="text/javascript">
|
|
google.charts.load('current', {'packages':['gantt']});
|
|
google.charts.setOnLoadCallback(drawChart);
|
|
var refData = new Array()
|
|
{% for job in test4 %}
|
|
refData.push([{{ job[0].session_id }},new Date("{{ job[0].LogDate }}")])
|
|
{% endfor %}
|
|
function drawChart() {
|
|
|
|
var data = new google.visualization.DataTable();
|
|
data.addColumn('string', 'Task ID');
|
|
data.addColumn('string', 'Task Name');
|
|
data.addColumn('string', 'Resource');
|
|
data.addColumn('date', 'Start Date');
|
|
data.addColumn('date', 'End Date');
|
|
data.addColumn('number', 'Duration');
|
|
data.addColumn('number', 'Percent Complete');
|
|
data.addColumn('string', 'Dependencies');
|
|
|
|
data.addRows([
|
|
{% for job in test4 %}
|
|
['{{ job[0].session_id }}','{{ job[0].DatabaseName }}','{{ job[0].DatabaseName }}', new Date("{{ job[0].request_start_time }}"),new Date(new Date("{{ (job[0].request_start_time) }}").setSeconds(new Date("{{ job[0].request_start_time }}").getSeconds()+{{ job[0].ElapsedTimeSec }})),null,null,null],
|
|
{% endfor %}
|
|
]);
|
|
|
|
var paddingHeight = 50;
|
|
|
|
var rowHeight = data.getNumberOfRows() * 25;
|
|
|
|
var chartHeight = rowHeight + paddingHeight;
|
|
var options = {
|
|
height: chartHeight,
|
|
gantt: {
|
|
sortTasks: true,
|
|
trackHeight: 30
|
|
}
|
|
};
|
|
|
|
var chart = new google.visualization.Gantt(document.getElementById('chart_div'));
|
|
google.visualization.events.addListener(chart, 'select', myClickHandler);
|
|
function myClickHandler(){
|
|
var selection = chart.getSelection();
|
|
var ses=refData[selection[0].row][0]
|
|
var ldat=refData[selection[0].row][1].toISOString()
|
|
var turl='{{ url_for('test4_getSession' ,sessionID='ses',logdate='ldat') }}'
|
|
turl = turl.replace('ses', ses);
|
|
turl = turl.replace('ldat', ldat);
|
|
window.location.assign(turl)
|
|
|
|
}
|
|
chart.draw(data, options);
|
|
}
|
|
|
|
</script>
|
|
</head>
|
|
<body>
|
|
<div id="chart_div"></div>
|
|
</body>
|
|
</html>
|