<script type="text/javascript">
google.charts.load('current', {'packages':['table']});
google.charts.setOnLoadCallback(drawTable);
var query, options, container;
sendAndDraw();
function drawTable() {
drawToolbar();
query = new google.visualization.Query(datasource);
data = document.getElementById("table");
options = {'pageSize': 10};
var data = new google.visualization.DataTable();
var data = google.visualization.arrayToDataTable([
['Ticket#','age','Created','Type','Subject','Queue','First Response Time','Solution Time','Sla','Priority','State','Owner'],
<?php
while($row = pg_fetch_assoc($result)){
echo "['".$row["ticket_number"]."','".$row["age"]."','".$row["create_time"]."','".$row["ticket_type"]."', '".$row["subject"]."', '".$row["queue_name"]."', '".$row["response_time"]."', '".$row["solution_time"]."', '".$row["sla"]."','".$row["ticket_priority"]."','".$row["ticket_state"]."','".$row["ticket_agent"]."'],";
}
?>
]);
var table = new google.visualization.Table(document.getElementById('table_div'));
table.draw(data, {page: 'enable',pageSize:'10', width: '100%'});
google.visualization.events.addListener(table, 'select', function() {
var row = table.getSelection()[0].row;
alert('You selected ' + data.getValue(row, 0));
});
/********** function for refresh the page**************/
setTimeout(function(){
window.location.reload(1);
}, 30000);
}
/********** function for refresh the page end**************/
function sendAndDraw() {
query.abort();
var tableQueryWrapper = new TableQueryWrapper(query, container, options);
tableQueryWrapper.sendAndDraw();
}
function setOption(prop, value) {
options[prop] = value;
sendAndDraw();
}
/**********************function for export csv******************/
function drawToolbar() {
var components = [
];
var table_div = document.getElementById('toolbar_div');
google.visualization.drawToolbar(table_div, components);
};
/***************function for export csv end*************/
</script>