\n"; $out.= "\n"; #THE END! print $out; }; function chartsizeme($val) { #return $val sized to display easily on charts. if ($val > 1000 and $val < 1000001) { $val = number_format($val/1000, 0, '.', ',') . 'k'; } elseif ($val > 1000000 and $val < 1000000001) { $val = number_format($val/1000000, 0, '.', ',') . 'm'; } elseif ($val > 1000000000 and $val < 1000000000001) { $val = number_format($val/1000000000, 0, '.', ',') . 'g'; } elseif ($val > 1000000000000) { $val = number_format($val/1000000000000, 0, '.', ',') . 't'; } else { $val = number_format($val, 2, '.', ','); }; return $val; }; function glconnect() { include ("demodata.inc"); $db = mysql_connect($dbhost, $dblogin, $dbpasswd); mysql_select_db($database, $db); return $db; }; // end function glconnect ; global $db ; $db = glconnect(); #==========================THE COMMAND SYNTAX # juicechart( SQLQUERY TO RUN, notusedyet,notusedyet, TITLE, column | line, width, height, grid size, 0 | 1 label type ) ; # # label type 0 = On the grid marker # label type 1 = On the label change #============================================ if($_REQUEST['demo'] == '1') { $q1 = "select date_format(billingtimestamp,'%b %d') as label,date_format(billingtimestamp,'%h:%m') as sublabel, value * 10 as kWh from meterintervaldata where serialnumber = 'SR000003' limit 100"; juicechart("$q1", "$q2", "$q3", 'kWh', 'column', 900, 300, 50,0); } ; if($_REQUEST['demo'] == '2') { $q1 = "select date_format(billingtimestamp,'%b %d') as label,date_format(billingtimestamp,'%h:%m') as sublabel, value * 10 as kWh from meterintervaldata where serialnumber = 'SR000003' limit 1000"; juicechart("$q1", "$q2", "$q3", 'kWh', 'line', 900, 300, 50,1); } ; if($_REQUEST['demo'] == '3') { $q1 = "select date_format(billingtimestamp,'%b %d') as label, usagediff/1000 as kWh,(usagediff/600) as Foo from meterreads where serialnumber = 'SR000003' and billingtimestamp > '20100101' limit 31"; juicechart("$q1", "$q2", "$q3", 'kWh', 'line', 900, 200, 25,1); } ; if($_REQUEST['demo'] == '') { $q1 = "select date_format(billingtimestamp,'%b %d') as label, usagediff/1000 as kWh,(usagediff/600) as Foo from meterreads where serialnumber = 'SR000003' and billingtimestamp > '20100101' limit 31"; juicechart("$q1", "$q2", "$q3", 'kWh', 'line', 900, 200, 25,1); } ; ?>