Problema Google Column Chart
Pessoal tenho o seguinte código:
function drawBasic() {
$.ajax({
type: 'POST',
data: 'ref=drawGraphFinance2&id=' + $('#hidb').val(),
url: '../../assets/server/client/Builds.php',
dataType: 'json',
success: function (data) {
json_events = data;
}
});
var data = google.visualization.arrayToDataTable([
['Element', 'Valor', {role: 'style'}],
['Jan', 8.94, '#fea400'],
['Fev', 10.49, '#fea400'],
['Mar', 19.30, '#fea400'],
['Abr', 21.45, '#fea400'],
['Mai', 50, '#fea400'],
['Jun', 21.45, '#fea400'],
['Jul', 21.45, '#fea400'],
['Ago', 21.45, '#fea400'],
['Set', 21.45, '#fea400'],
['Out', 21.45, '#fea400'],
['Nov', 21.45, '#fea400'],
['Dez', 21.45, '#fea400']
]);
var options = {
title: 'Gastos/mês',
hAxis: {
title: 'Meses'
},
vAxis: {
title: 'Valor (R$)'
},
'height': 350,
'colors': ['#fea400']
};
var chart = new google.visualization.ColumnChart(document.getElementById('chart_div_2'));
chart.draw(data, options);
}
public function drawGraphFinance2($idBuild) {
$data = array($idBuild);
$sql = "SELECT SUM(price) AS totlaPrice, DISTINCT EXTRACT(YEAR_MONTH FROM date) AS data FROM sys_constructions_finance WHERE id_construction = ? GROUP BY date;";
return parent::selectDB($sql, $data);
}
$responseFinance = $b->drawGraphFinance2($_POST['id']);
$rows = array();
foreach ($responseFinance as $dgf2) {
$temp = array();
$temp[] = array('v' => (string) $dgf2->data);
$temp[] = array('v' => (doubleval($dgf2->totalPrice)));
$rows[] = array('c' => $temp);
}
$table['rows'] = $rows;
echo json_encode($table);
Não estou conseguindo montar o gráfico da maneira correta, alguem pode me ajudar?
Discussão (5)
Carregando comentários...