<?php
/*
This script creates a graph based on the data collected by SMA Bluetooth.
Copyright (C) 2012 Pierre Gorissen

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

*/


// Replace these values with your own!
$myTimezone = "Europe/Amsterdam";
$dbDatabase = "smatool";
$dbUser = "root";
$dbPassword = "secret";

// No need to edit below this line

date_default_timezone_set($myTimezone);
set_time_limit(600);
// error_reporting(E_ALL);

/* Include the pData class */
require_once("pChart/class/pDraw.class.php");
require_once("pChart/class/pImage.class.php");
require_once("pChart/class/pData.class.php");

/* Create the pData object */
$MyData = new pData();  

/* Connect to the MySQL database */
$db = mysql_connect("localhost", $dbUser, $dbPassword); 

mysql_select_db($dbDatabase,$db);

/* Graph date defaults to today */
$select_date = date("Ymd");
/* Check to see if script has been requested from commandline with parameters */
if (PHP_SAPI === 'cli') {
	parse_str(implode('&', array_slice($argv, 1)), $_GET);
}	
/* Check to see if script has been requested with parameters */
if (isset($_GET['date'])) {
	$select_date = $_GET["date"];
}

/* Build the query that will returns the data to graph */
$Requete = "SELECT DATE_FORMAT(t1.DateTime,'%Y%m%d') as DATE, DATE_FORMAT(t1.DateTime,'%H:%i') as TIME, ROUND((t1.ETotalToday - d1.MinVal)*1000) as DayTotal, t1.CurrentPower, t1.DateTime FROM DayData t1 INNER JOIN (SELECT DATE(DateTime) ts_date, MIN(ETotalToday) AS MinVal FROM DayData GROUP BY ts_date) d1 ON DATE(t1.DateTime) = d1.ts_date WHERE DATE_FORMAT(t1.DateTime,'%Y%m%d') = '".mysql_real_escape_string($select_date)."' and t1.CurrentPower>0 ORDER BY t1.DateTime ASC;";

$Result  = mysql_query($Requete,$db);

$date=""; 
$datetime="";
$time=""; 
$daytotal="";
$currentpower="";
while($row = mysql_fetch_array($Result)) {

	/* Push the results of the query in an array */
	$datetime[]			= $row["DateTime"];
	$time[] 			= $row["TIME"];
	$daytotal[] 		= $row["DayTotal"];
	$currentpower[]    	= $row["CurrentPower"];
 }

/* Save the data in the pData array */
$MyData->addPoints($datetime,"Date Time");
$MyData->addPoints($time,"Time");
$MyData->addPoints($daytotal,"Day Total");
$MyData->addPoints($currentpower,"Current Power");

$chartDate = strftime("%d-%m-%Y %H:%M", strtotime($MyData->getMin("Date Time"))). " - ". strftime("%H:%M", strtotime($MyData->getMax("Date Time")));
$maxPower = $MyData->getMax("Current Power");
$maxDayTotal = round($MyData->getMax("Day Total") / 1000);



$MyData->setAbscissa("Time");

/* Associate the "Day Total" data serie to the second axis */
$MyData->setSerieOnAxis("Day Total", 1);
/* Name this axis "Time" */
$MyData->setXAxisName("Time");

/* First Y axis will be dedicated to the current power */
$MyData->setAxisName(0,"Power");
$MyData->setAxisUnit(0,"Watt");
$MyData->setAxisPosition(0,AXIS_POSITION_LEFT);

/* Second Y axis will be dedicated to Day Total */
$MyData->setAxisName(1,"Energy");
$MyData->setAxisUnit(1,"Wh");
$MyData->setAxisPosition(1,AXIS_POSITION_RIGHT);
$MyData->setAxisDisplay(1,AXIS_FORMAT_METRIC); 

/* Create a pChart object and associate your dataset */
$myPicture = new pImage(1000,500,$MyData);

 /* Add a border to the picture */
 $myPicture->drawRectangle(0,0,1000,500,array("R"=>0,"G"=>0,"B"=>0));
 
 /* Draw the scale */
 $myPicture->setFontProperties(array(	"FontName"=>"pChart/fonts/verdana.ttf",
										"FontSize"=>10));
 $myPicture->setGraphArea(100,100,850,460);
 $ScaleSettings = array("XMargin"=>10,
						"YMargin"=>10,
						"Floating"=>TRUE,
						"DrawSubTicks"=>FALSE,
						"CycleBackground"=>FALSE, 
						"LabelSkip"=>10, 
						"Mode"=>SCALE_MODE_START0);
 
 $myPicture->drawScale($ScaleSettings);

 /* Graph title */
 $myPicture->setShadow(TRUE,array("X"=>1,"Y"=>1,"R"=>0,"G"=>0,"B"=>0,"Alpha"=>10));
 $myPicture->drawText(50,52,"Daily Production ".$chartDate,array("FontSize"=>20,"Align"=>TEXT_ALIGN_BOTTOMLEFT));

 /* Draw the area chart chart */
 $myPicture->setFontProperties(array(	"FontName"=>"pChart/fonts/verdana.ttf",
										"FontSize"=>8));
 $MyData->setSerieDrawable("Date Time",FALSE);
 $MyData->setSerieDrawable("Current Power",FALSE);
 $MyData->setSerieDrawable("Day Total",TRUE);
 $serieSettings = array("R"=>0,
						"G"=>204,
						"B"=>0,
						"Alpha"=>50);
 $MyData->setPalette("Day Total",$serieSettings);
 $myPicture->drawFilledSplineChart();
 
 /* Draw the line and plot chart */
 $MyData->setSerieDrawable("Current Power",TRUE);
 $MyData->setSerieDrawable("Day Total",FALSE);
 $MyData->setSerieWeight("Current Power",1);
 $MyData->setSerieWeight("Day Total",1);
 $serieSettings = array("R"=>0,
						"G"=>204,
						"B"=>0,
						"Alpha"=>100);
 $MyData->setPalette("Current Power",$serieSettings);
 $myPicture->drawSplineChart();

 /* Make sure all series are drawable before writing the scale */
 $MyData->setSerieDrawable("Day Total",TRUE);
 
 $myPicture->drawThreshold($maxPower,array(	"WriteCaption"=>FALSE,
											"Caption"=>"Max",
											"Alpha"=>70,
											"Ticks"=>2,
											"R"=>0,
											"G"=>0,
											"B"=>255));

 /* Write the legend */
 /* $myPicture->drawLegend(540,35,array("Style"=>LEGEND_ROUND,
										"Alpha"=>20,
										"Mode"=>LEGEND_HORIZONTAL)); */
 
/* Write the 1st data series statistics */ 
 $Settings = array(	"R"=>0,
					"G"=>0,
					"B"=>0,
					"Align"=>TEXT_ALIGN_BOTTOMLEFT); 
 $myPicture->drawText(50,500,	"Max: ".ceil($MyData->getMax("Current Power"))." Watt, ". 
								"Min: ".ceil($MyData->getMin("Current Power"))." Watt, ".
								"Avg: ".ceil($MyData->getSerieAverage("Current Power"))." Watt, ".
								"Total : ".round($MyData->getMax("Day Total")/1000,4)." kWh.",$Settings);
 
 /* Render the picture (choose the best way) */
 $myPicture->autoOutput("images/sma_".$select_date.".png");

?>