Changeset 7878 for code/Website/graph_bar.php

Timestamp:

Apr 30, 2010, 4:27:34 PM (15 years ago)

Author:

dennisw

Message:

 

File:

• code/Website/graph_bar.php (modified) (4 diffs)

code/Website/graph_bar.php

@@ -5 +5 @@
 
 
-$result = mysql_query("select AVG(value) AS average FROM tuples LEFT JOIN sensors ON tuples.sensorID=sensors.sensorID WHERE end IS NULL GROUP BY sensors.roomID");
+$result = mysql_query("
+                                          select AVG(`tuples`.value) AS average, `rooms`.name AS xaxis 
+                                          FROM (`save_energy`.`tuples`) 
+                                          JOIN `save_energy`.`sensors` ON (`tuples`.sensorID=`sensors`.sensorID) 
+                                          JOIN `save_energy`.`rooms` ON (`sensors`.roomID=`rooms`.roomID) 
+                                          WHERE `sensors`.name LIKE '%power' 
+                                          AND DATE(`tuples`.start) = CURRENT_DATE() - INTERVAL 1 DAY  
+                                          GROUP BY `rooms`.name;");
 
 $data = array();
@@ -11 +18 @@
 {
   $data[] = intval($row['average']);
+  $xaxis[] = ($row['xaxis']);
 }
 
-$title = new title( 'All rooms' );
+$title = new title( 'Alle kamers' );
 
 $bar = new bar();
 $bar->colour( '#BF3B69');
-$bar->key('Gemiddelde', 14);
+$bar->key('Gemiddelde energieverbruik van gisteren in Watt', 14);
 $bar->set_values( $data );
 $bar->set_on_click("bar_1");
@@ -35 +43 @@
 $x = new x_axis();
 $x->colour('#000000')->grid_colour('#D8D8D8');
-$x_legend = new x_legend( 'Kamer ID' );
+$x_legend = new x_legend( 'Kamer nummer' );
 $x_legend->set_style( '{font-size: 14px; color: #000000}' );
+
+$x_labels = new x_axis_labels();
+$x_labels->set_colour( '#000000' );
+$x_labels->set_labels( $xaxis );
+$x->set_labels( $x_labels );
+
 
 
@@ -50 +64 @@
 //$chart->add_element( $bar2 );
 
+echo $chart->toPrettyString();
+$chartwrite = $chart->toPrettyString();
 
-echo $chart->toString();
+$fh = fopen("graphs/bar.txt", 'w') or die("can't open file");
+fwrite($fh, $chartwrite);
+fclose($fh);
 ?>