<?php
/**
 * Charts 4 PHP
 *
 * @author Shani <support@chartphp.com> - http://www.chartphp.com
 * @version 2.0
 * @license: see license.txt included in package
 */
 
 require_once ('ftest.php');
 require_once("ChartDirector/lib/phpchartdir.php");
$page = $_SERVER['PHP_SELF'];
$sec = "60";

				 
//Connect to db
$con=GetCon();	

// Your SQL statement
$SQL= "select [Time],[BatteryVoltage],[SolarVoltage]
                from [dbo].[tblSolar]
                 order by Time desc"; 



// Query the DB
$result = sqlsrv_query($con, $SQL);

// Read query result to arrays
$labels = array();
$data1 = array();
$data2 = array();
while ($row = sqlsrv_fetch_array($result))
{
    $labels[] = $row[0];
    $data1[] = $row[1];
	$data2[] = $row[2];
}
		 
# Create a XYChart object of size 600 x 400 pixels
$c = new XYChart(600, 400);
# Add a title box using grey (0x555555) 20pt Arial font
$c->addTitle("    Multi-Line Chart Demonstration", "arial.ttf", 20, 0x555555);

# Set the plotarea at (70, 70) and of size 500 x 300 pixels, with transparent background and border
# and light grey (0xcccccc) horizontal grid lines
$c->setPlotArea(70, 70, 500, 300, Transparent, -1, Transparent, 0xcccccc);

# Add a legend box with horizontal layout above the plot area at (70, 35). Use 12pt Arial font,
# transparent background and border, and line style legend icon.
$b = $c->addLegend(70, 35, false, "arial.ttf", 12);
$b->setBackground(Transparent, Transparent);
$b->setLineStyleKey();

# Add 3 data series to the line layer
$layer = $c->addBarLayer2(Stack);
$layer->addDataSet($data1, 0xee9944, "Beta");
$layer->addDataSet($data2, 0x99bb55, "Gamma");

# The x-coordinates for the line layer
$layer->setXData($labels);
$c->xAxis->setLabels($labels);
# Output the chart

# Set axis label font to 12pt Arial
$c->xAxis->setLabelStyle("arial.ttf", 12);
$c->yAxis->setLabelStyle("arial.ttf", 12);

# Set the x and y axis stems to transparent, and the x-axis tick color to grey (0xaaaaaa)
$c->xAxis->setColors(Transparent, TextColor, TextColor, 0xaaaaaa);
$c->yAxis->setColors(Transparent);

# Set the major/minor tick lengths for the x-axis to 10 and 0.
$c->xAxis->setTickLength(10, 0);

# For the automatic axis labels, set the minimum spacing to 80/40 pixels for the x/y axis.
$c->xAxis->setTickDensity(80);
$c->yAxis->setTickDensity(40);

# Add a title to the y axis using dark grey (0x555555) 14pt Arial font
$c->yAxis->setTitle("Y-Axis Title Placeholder", "arial.ttf", 14, 0x555555);

# Add a line layer to the chart with 3-pixel line width
$layer = $c->addLineLayer2();
$layer->setLineWidth(3);


header("Content-type: image/png");
print($c->makeChart2(PNG));
?>