}
$data_w = array_fill(0, 12, 0);
$data_t = array_fill(0, 12, 0);
$stmt = "SELECT date_format(timestamp,'%c')-1 as m, avg(AMsWatt)+avg(BMsWatt) AS Watt, max(ETotal)-min(ETotal) ETotal FROM solardata " . " WHERE date <> 0" . " GROUP BY date_format(timestamp,'%c') " . " ORDER BY TimeStamp LIMIT 100";
$ok = mysql_query($stmt);
if ($ok) {
while ($row = mysql_fetch_object($ok)) {
$data_w[$row->m] = round((double) $row->Watt, 3);
$data_t[$row->m] = round((double) $row->ETotal, 3);
}
$title = new title("\nJahresueberblick Verteilung");
$title->set_style('{font-size: 20px; color: #778877}');
$vals = array();
for ($i = 0; $i < count($data_w); $i++) {
$tmp = new solid_dot($data_t[$i]);
$tmp->colour('#4d4d4d')->tooltip("{$time_axis[$i]}<br>#val# kWh");
$vals[] = $tmp;
}
$area_w = new area();
$area_w->set_width(1);
$area_w->set_default_dot_style(new hollow_dot('#EFC01D', 5));
$area_w->set_colour('#EFC01D');
$area_w->set_fill_colour('#EFC01D');
$area_w->set_fill_alpha(0.4);
$area_w->set_loop();
$area_w->set_values($vals);
$line_t = new line();
$line_t->set_values($data_t);
$max = max($data_t) * 1.15;
$label = array();
for ($i = 0; $i < $max; $i = $i + round($max * 0.1, -1)) {
protected function getSeries($idx, $type, $colour)
{
$oSeries = new $type();
$oSeries->set_values($this->aData[$idx]);
$oSeries->set_key($this->aLabels[$idx], 10);
$oSeries->set_colour($colour);
if ($type == 'line') {
$dot = new solid_dot();
$dot->colour($colour)->tooltip($this->aTooltips[$idx]);
$oSeries->set_default_dot_style($dot);
} else {
$oSeries->set_tooltip($this->aTooltips[$idx]);
}
return $oSeries;
}
