<?php
include ("/usr/share/jpgraph/jpgraph.php");
include ("/usr/share/jpgraph/jpgraph_scatter.php");


$thismonthUJD = mktime(0, 0, 0, date("m")-1, 0,  date("Y")) /(3600*24) ;


// matlab's datenum(1970,1,1) = 719529 # = days from 0000-1-1 to 1970-1-1

$conn=odbc_connect("surapgtest",'webserver','webserver');
$sql="select matlab_datenum, year,yearday, Wind_spd 
  from VB_H2O_active_raw
  where CAST (yearday* 24*60 as int8) % 1 = 0 
  order by matlab_datenum;";
$rs = odbc_exec($conn,$sql);

while (odbc_fetch_row($rs))
{
//$xdata[] =date('z', odbc_result($rs,"matlab_datenum") * 24 * 3600);
//$xdata[] =odbc_result($rs,"matlab_datenum") - $thismonthUJD; 

$xdata[] =mktime(0,0,odbc_result($rs,'yearday')*24*3600,0,
	0,
	odbc_result($rs,'year')) /(24*3600)-$thismonthUJD;

$ydata[] =odbc_result($rs,"Wind_spd");
}


// Create the graph. 
$graph = new Graph(450,350,"auto");	
$graph->SetScale("linlin");
//$graph->img->SetMargin(30,90,40,50);
$graph->xaxis->SetFont(FF_ARIAL,FS_BOLD);
$graph->xscale->ticks->Set(7,1);
$graph->xaxis->SetLabelAngle(45); // 45 deg upwards

//echo $graph->SetTickDensity(TICKD_NORMAL,TICKD_SPARSE);
$graph->title->Set($sql);
$graph->xaxis->title->Set(date("Y-M"));
$graph->yaxis->title->Set("Wind (mph)");
// Create the linear plot
$plot=new ScatterPlot($ydata,$xdata);
$plot->SetLegend("mph");
$plot->mark->SetType(0);
$plot->mark->SetWidth(5);

// $sp1->SetWeight(3);
//$plot->mark->SetWidth(4);
$plot->SetLinkPoints();


// Add the plot to the graph
$graph->Add($plot);

// Display the graph
$graph->Stroke();
?>