function reportStoryIndividualStats($id)
{
$connection = connectToDb();
$output = "";
$headers = array("Accepted", "Finished", "Unscheduled", "Started", "Unstarted", "Rejected", "Delivered", "Total");
$items_array = array();
$items_array[] = "<tr><th>" . $headers[0] . "</th>\n <td>" . ($accepted = countStoryStatusSql($id, "accepted", $connection));
$items_array[] = "<tr><th>" . $headers[1] . "</th>\n <td>" . ($finished = countStoryStatusSql($id, "finished", $connection));
$items_array[] = "<tr><th>" . $headers[2] . "</th>\n <td>" . ($unscheduled = countStoryStatusSql($id, "unscheduled", $connection));
$items_array[] = "<tr><th>" . $headers[3] . "</th>\n <td>" . ($started = countStoryStatusSql($id, "started", $connection));
$items_array[] = "<tr><th>" . $headers[4] . "</th>\n <td>" . ($unstarted = countStoryStatusSql($id, "unstarted", $connection));
$items_array[] = "<tr><th>" . $headers[5] . "</th>\n <td>" . ($rejected = countStoryStatusSql($id, "rejected", $connection));
$items_array[] = "<tr><th>" . $headers[6] . "</th>\n <td>" . ($delivered = countStoryStatusSql($id, "delivered", $connection));
$items_array[] = '<tr class="success"><th>' . $headers[7] . "</th>\n <td>" . ($accepted + $finished + $unscheduled + $started + $unstarted + $rejected + $delivered);
$items_string = implode("</tr>", $items_array);
$output .= $items_string . "</td></tr>";
$connection = null;
return $output;
}
?>
],
['Started', <?php
echo countStoryStatusSql($history_id, "started", $connection);
?>
],
['Unstarted', <?php
echo countStoryStatusSql($history_id, "unstarted", $connection);
?>
],
['Rejected', <?php
echo countStoryStatusSql($history_id, "rejected", $connection);
?>
],
['Delivered', <?php
echo countStoryStatusSql($history_id, "delivered", $connection);
?>
]
]);
var options = {
title: 'Story States Statistics'
};
var chart = new google.visualization.PieChart(document.getElementById('story-state-piechart'));
chart.draw(data, options);
}
</script>
<div id="story-state-piechart"></div>
<?php
