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