<?php    
 
/*// most interesting
SELECT sum(heuristic_value) as sum, CNID
FROM `heuristic_results` group by CNID order by sum DESC limit 30
 
// spread of values
select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) 
as sum FROM heuristic_results group by CNID) as a group by val*/
 
 /* CAT:Spline chart */ 
 
 /* pChart library inclusions */ 
 include("../lib/pChart2.1.0/class/pData.class.php"); 
 include("../lib/pChart2.1.0/class/pDraw.class.php"); 
 include("../lib/pChart2.1.0/class/pImage.class.php"); 
$labels = Array();
$values = Array();
 
  include_once("../lib/common.inc.php");
$query = "select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) 
as sum FROM heuristic_results group by CNID) as a group by val";
$result = mysql_query($query);
if (!$result) echo mysql_error().$query;
while ($r = mysql_fetch_array($result, MYSQL_BOTH)) {
    $labels[] = $r[0];
    $values[] = $r[1];
}
 
 /* Create and populate the pData object */ 
 $MyData = new pData();   
 $MyData->addPoints($values,"Records"); 
 $MyData->setAxisName(0,"# of records"); 
 $MyData->addPoints($labels,"Labels"); 
 $MyData->setSerieDescription("Labels","Bins"); 
 $MyData->setAbscissa("Labels"); 
 
 /* Create the pChart object */ 
 $myPicture = new pImage(700,230,$MyData); 
 
 /* Turn of Antialiasing */ 
 $myPicture->Antialias = FALSE; 
 
 /* Add a border to the picture */ 
 $myPicture->drawRectangle(0,0,699,229,array("R"=>0,"G"=>0,"B"=>0)); 
  
 /* Write the chart title */  
 $myPicture->setFontProperties(array("FontName"=>"../lib/pChart2.1.0/fonts/Forgotte.ttf","FontSize"=>11)); 
 $myPicture->drawText(150,35,"Record distribution",array("FontSize"=>20,"Align"=>TEXT_ALIGN_BOTTOMMIDDLE)); 
 
 /* Set the default font */ 
 $myPicture->setFontProperties(array("FontName"=>"../lib/pChart2.1.0/fonts/pf_arma_five.ttf","FontSize"=>6)); 
 
 /* Define the chart area */ 
 $myPicture->setGraphArea(60,40,650,200); 
 
 /* Draw the scale */ 
 $scaleSettings = array("XMargin"=>10,"YMargin"=>0,"Floating"=>TRUE,"GridR"=>200,"GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE);
 $myPicture->drawScale($scaleSettings); 
 
 /* Turn on Antialiasing */ 
 $myPicture->Antialias = TRUE; 
 
 /* Draw the line chart */ 
 $myPicture->drawSplineChart(); 
 
 /* Write the chart legend */ 
 $myPicture->drawLegend(540,20,array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL)); 
 
 /* Render the picture (choose the best way) */ 
 $myPicture->autoOutput("pictures/example.drawSplineChart.simple.png"); 
?>