So hier die beiden Skripte für GooogleChart Area.
Ich hoffe das hilft dir weiter. Die Daten lese ich aus der Postgres Datenbank aus.
Skript 1 als externe Webseite aufrufen.
<?php
include ("c:ip-symcon/scripts/10059.ips.php");
$time = time();
$daten = "";
$datenreihe = array();
for($i=0;$i<24;$i++)
{
$j = $i;
$date = time();
$start = date ("d-m-Y ".$j.":00:00",$date);
$end = date ("d-m-Y ".$j.":59:59",$date);
$datum = date ($j.":i d-m-Y",$date);
$Summe1 = AVG_auslesen2("Daten_Steindorf","10100",$start,$end);
$Summe2 = AVG_auslesen2("Daten_Steindorf","36145",$start,$end);
array_push($datenreihe, array($datum, round(floatval($Summe1),2), round(floatval($Summe2),2)));
}
?>
<html>
<head>
<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 = new google.visualization.DataTable();
data.addColumn('string', 'Datum');
data.addColumn('number', 'Rücklauf');
data.addColumn('number', 'Vorlauf');
data.addRows(<?php echo json_encode($datenreihe); ?>);
var chart = new google.visualization.AreaChart(document.getElementById('chart_div'));
chart.draw(data, {width: 1200, height: 600, title: 'Company Performance',hAxis: {title: 'Year', titleTextStyle: {color: '#FF0000'}}});
}
</script>
</head>
<body>
<div id="chart_div"></div>
</body>
</html>
Skript 2 in IPS/Skript-Ordner
<?
//*******************
//Daten_auslesen();
//*******************
//print_r (Daten_auslesen("SteindorfII","value1","1B000801E16C2C10","2011-11-10 00:00:00","2011-11-12 00:00:00"));
print_r (AVG_auslesen2("Daten_Steindorf","10100","2012-04-10 00:00:00","2012-04-16 00:00:00"));
function Daten_auslesen($db,$value,$romid,$time1,$time2)
{
$dbconn = pg_connect("host=127.0.0.1 port=5432 dbname=".$db." user=postgres password=ips") or die ('Verbindungsaufbau fehlgeschlagen: ' . pg_last_error());
// $setSQL = "SELECT variablen.updatezeit, variablen.romid FROM public.variablen ORDER BY variablen.updatezeit DESC;";
$setSQL = "SELECT variablen.updatezeit, variablen.romid, variablen.".$value." FROM public.variablen ";
$setSQL .= "WHERE variablen.romid = '".$romid."' AND variablen.updatezeit < '".$time2."' AND variablen.updatezeit > '".$time1."';";
$result = pg_query($setSQL) or die ('Abfrage fehlgeschlagen: ' .pg_last_error());
$i = 0;
while($data = pg_fetch_assoc($result))
{
//print_r($data);
//echo $data['updatezeit']." ".$data['romid']." ".$data['value1']."<br>";
$dat[$i] =$data['updatezeit'].",".$data['romid'].",".$data['value1'];
$i++;
}
pg_close($dbconn);
return ($dat);
}
//**********
// Summe
//**********
//echo Sum_auslesen("SteindorfII","value2","8F00000009EF241D","2011-11-10 00:00:00","2011-11-13 00:00:00");
function Sum_auslesen($db,$value,$romid,$time1,$time2)
{
$dbconn = pg_connect("host=127.0.0.1 port=5432 dbname=".$db." user=postgres password=ips") or die ('Verbindungsaufbau fehlgeschlagen: ' . pg_last_error());
// $setSQL = "SELECT variablen.updatezeit, variablen.romid FROM public.variablen ORDER BY variablen.updatezeit DESC;";
$setSQL = "SELECT sum(variablen.".$value.") FROM public.variablen ";
$setSQL .= "WHERE variablen.romid = '".$romid."' AND variablen.updatezeit < '".$time2."' AND variablen.updatezeit > '".$time1."';";
$result = pg_query($setSQL) or die ('Abfrage fehlgeschlagen: ' .pg_last_error());
while($data = pg_fetch_assoc($result))
{
//print_r($data);
$dat = $data['sum']."<br>";
}
pg_close($dbconn);
return ($dat);
}
//****************
// Durchschnitt
//****************
//echo AVG_auslesen("SteindorfII","value1","8F00000009EF241D","2011-11-10 00:00:00","2011-11-11 00:00:00");
function AVG_auslesen($db,$value,$romid,$time1,$time2)
{
$dbconn = pg_connect("host=127.0.0.1 port=5432 dbname=".$db." user=postgres password=ips") or die ('Verbindungsaufbau fehlgeschlagen: ' . pg_last_error());
// $setSQL = "SELECT variablen.updatezeit, variablen.romid FROM public.variablen ORDER BY variablen.updatezeit DESC;";
$setSQL = "SELECT avg(variablen.".$value.") FROM public.variablen ";
$setSQL .= "WHERE variablen.romid = '".$romid."' AND variablen.updatezeit < '".$time2."' AND variablen.updatezeit > '".$time1."';";
$result = pg_query($setSQL) or die ('Abfrage fehlgeschlagen: ' .pg_last_error());
while($data = pg_fetch_assoc($result))
{
//print_r($data);
$dat = $data['avg']."<br>";
}
pg_close($dbconn);
return ($dat);
}
function Daten_auslesen2($db,$varid,$time1,$time2)
{
$dbconn = pg_connect("host=127.0.0.1 port=5432 dbname=".$db." user=ips password=ips") or die ('Verbindungsaufbau fehlgeschlagen: ' . pg_last_error());
// $setSQL = "SELECT variablen.updatezeit, variablen.romid FROM public.variablen ORDER BY variablen.updatezeit DESC;";
$setSQL = "SELECT variablen.updatezeit, variablen.varid, variablen.value FROM public.variablen ";
$setSQL .= "WHERE variablen.varid = '".$varid."' AND variablen.updatezeit < '".$time2."' AND variablen.updatezeit > '".$time1."';";
$result = pg_query($setSQL) or die ('Abfrage fehlgeschlagen: ' .pg_last_error());
$i = 0;
while($data = pg_fetch_assoc($result))
{
//print_r($data);
//echo $data['updatezeit']." ".$data['romid']." ".$data['value1']."<br>";
$dat[$i] =$data['updatezeit'].",".$data['varid'].",".$data['value'];
$i++;
}
pg_close($dbconn);
return ($dat);
}
//****************
// Durchschnitt
//****************
//echo AVG_auslesen("SteindorfII","value1","8F00000009EF241D","2011-11-10 00:00:00","2011-11-11 00:00:00");
function AVG_auslesen2($db,$varid,$time1,$time2)
{
$dbconn = pg_connect("host=127.0.0.1 port=5432 dbname=".$db." user=ips password=ips") or die ('Verbindungsaufbau fehlgeschlagen: ' . pg_last_error());
// $setSQL = "SELECT variablen.updatezeit, variablen.romid FROM public.variablen ORDER BY variablen.updatezeit DESC;";
$setSQL = "SELECT avg(variablen.value) FROM public.variablen ";
$setSQL .= "WHERE variablen.varid = '".$varid."' AND variablen.updatezeit < '".$time2."' AND variablen.updatezeit > '".$time1."';";
$result = pg_query($setSQL) or die ('Abfrage fehlgeschlagen: ' .pg_last_error());
while($data = pg_fetch_assoc($result))
{
//print_r($data);
$dat = $data['avg']."<br>";
}
pg_close($dbconn);
return ($dat);
}
?>
Die Umsetzung für deinen Grph sollte so ähnlich funktionieren.:rolleyes:
Echt Klasse Skript.