Esempio n. 1
0
function reportStoryIndividualTasks($id)
{
    $connection = connectToDb();
    $output = "";
    $headers = array("Complete", "Incomplete", "Total");
    $items_array = array();
    $items_array[] = "<tr><th>" . $headers[0] . "</th><td>" . ($complete = countTaskCompletion($id, "1", $connection));
    $items_array[] = "<tr><th>" . $headers[1] . "</th><td>" . ($incomplete = countTaskCompletion($id, "0", $connection));
    $items_array[] = '<tr class="success"><th>' . $headers[2] . "</th><td>" . ($complete + $incomplete);
    $items_string = implode("</tr>", $items_array);
    $output .= $items_string . "</td></tr>";
    $connection = null;
    return $output;
}
$connection = connectToDb();
?>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
    google.load("visualization", "1", {packages:["corechart"]});
    google.setOnLoadCallback(drawChart);
    function drawChart() {

        var data = google.visualization.arrayToDataTable([
            ['Task Status','Number of Tasks'],
            ['Complete', <?php 
echo countTaskCompletion($history_id, "1", $connection);
?>
],
            ['Incomplete', <?php 
echo countTaskCompletion($history_id, "0", $connection);
?>
]
        ]);

        var options = {
            title: 'Task Status Statistics'
        };

        var chart = new google.visualization.PieChart(document.getElementById('task-status-piechart'));

        chart.draw(data, options);
    }
</script>
<div id="task-status-piechart"></div>
<?php