var options = {
title: 'Consumo de Homem x Hora (Grupo 1)',
is3D: true,
};
var chart = new google.visualization.PieChart(document.getElementById('pizza1'));
chart.draw(data, options);
}
</script>
<img src="imagem/PoweredBy.png" align="left"> <br></br>
<div id="pizza1" style="width: 900px; height: 400px;"></div>
<!-- --------------------------------- FIM GRÁFICO PIZZA GRUPO 1------------------------------------------------------------- -->
<?php
}
if ($acompanhamento->getGrupo2() != null) {
$query = mysql_query("SELECT sum(B.qnt_mes) as Medido FROM " . MYSQL_BASE_CONTRATO_ITEM . " A , " . MYSQL_BASE_MEDICAO_ITEM . " B WHERE A.tipo = 1 AND B.id_contrato_item = A.id AND grupo = 2 ");
$total_med = 0;
$total_res = 0;
while ($row = mysql_fetch_array($query)) {
$total_med = $row['Medido'];
$total_res = 1091.15 - $total_med;
}
/* $chart = new PieChart(600, 200);
$dataSet = new XYDataSet();
$dataSet->addPoint(new Point("Total Medido", $total_med));
$dataSet->addPoint(new Point("Total Restante", $total_res));
$chart->setDataSet($dataSet);
$chart->getPlot()->setGraphPadding(new Padding(5, 0, 20, 0));
