<?php require_once('../../../Connections/VirtualZeroConn.php'); ?>
<?php



mysql_select_db($database_VirtualZeroConn, $VirtualZeroConn);
      $query_Recordset1 = "SELECT archive.*
                       FROM archive
                      LIMIT 24";
      $Recordset1 = mysql_query($query_Recordset1, $VirtualZeroConn) or die(mysql_error());
      $row_Recordset1 = mysql_fetch_assoc($Recordset1);
      $totalRows_Recordset1 = mysql_num_rows($Recordset1);

/* Include all the classes */
include("../../pChart/class/pDraw.class.php");
include("../../pChart/class/pImage.class.php");
include("../../pChart/class/pData.class.php");
include("../../pChart/class/pScatter.class.php");


$temperatura = array();

$data = array();

do{
   
    //Push temperatura
    array_push($temperatura,$row_Recordset1['inTemp']);
   
    //push DateTime
    array_push($data,date($row_Recordset1['dateTime']));
   
   
}while($row_Recordset1 = mysql_fetch_assoc($Recordset1));

  $myData = new pData();
$myData->addPoints($data,"X");
$myData->addPoints($temperatura,"Y");


/* Bind the X serie to the X axis */
$myData->setAxisName(0,"Tempo");
$myData->setAxisXY(0,AXIS_X);
$myData->setAxisDisplay(0,AXIS_FORMAT_TIME,"H:i:s");
$myData->setAxisPosition(0,AXIS_POSITION_BOTTOM);

/* Bind the Y serie to the Y axis */
$myData->setAxisName(1,"Temperature");
$myData->setAxisXY(1,AXIS_Y);
$myData->setSerieOnAxis("Y",1);
$myData->setAxisPosition(1,AXIS_POSITION_LEFT);

/* Create the scatter serie */
$myData->setScatterSerie("X","Y",0);
   

$myPicture = new pImage(700,300,$myData);


$myPicture->setFontProperties(array("FontName"=>"../../pChart/fonts/Forgotte.ttf","FontSize"=>10));

$myPicture->setGraphArea(60,40,670,190);


/* Create the Scatter chart object */
$myScatter = new pScatter($myPicture,$myData);
$ScaleSettings = array("GridR"=>50,"GridG"=>50,"GridB"=>50);
$myScatter->drawScatterScale($ScaleSettings);
   
$myScatter->drawScatterPlotChart();


$myScatter->drawScatterLineChart();


$myPicture->Stroke();



?>