<?php

include("../includes/FunctionDB.php");
include ("jpgraph/src/jpgraph.php");
include ("jpgraph/src/jpgraph_bar.php");

ConnectDB();

$sql = "SELECT * FROM  StudentMaster  Where  studentStatus='1'   GROUP By   admitAcadYear  ";
$result = mysql_query($sql) ;
$row = mysql_num_rows($result);
$num = mysql_num_rows($result );

while($rs = mysql_fetch_array($result)){
    $admitAcadYear =  $rs["admitAcadYear"];
    
    $sql1= "Select * From  StudentMaster  Where  studentStatus='1'  and  admitAcadYear='$admitAcadYear' and  studentSex ='M' ";
    $result1 = mysql_query($sql1);
    $countnum1 = mysql_num_rows($result1);
    $data1y[] = $countnum1;
        
    $sql2= "Select * From  StudentMaster  Where  studentStatus='1'  and  admitAcadYear='$admitAcadYear' and  studentSex ='F' ";
    $result2 = mysql_query($sql2);
    $countnum2 = mysql_num_rows($result2);    
    $data2y[] = $countnum2;
        
    $xLabels[] = $admitAcadYear;
    
}

// Create the graph. These two calls are always required
$graph = new Graph(650,400,"auto");    
$graph->SetScale("textlin");

$graph->SetShadow();
$graph->img->SetMargin(40,120,20,40);

// Create the bar plots
$b1plot = new BarPlot($data1y);
$b1plot->SetFillColor("orange");
$b1plot->SetLegend("Male");
$b1plot->value->Show();
$b2plot = new BarPlot($data2y);
$b2plot->SetFillColor("blue");
$b2plot->SetLegend("Female");
$b2plot->value->Show();

// Specify X-labels
$graph->xaxis->SetTickLabels($xLabels);

// Create the grouped bar plot
$gbplot = new GroupBarPlot(array($b1plot,$b2plot));

// ...and add it to the graPH
$graph->Add($gbplot);

$graph->title->Set("กราฟแสดงจำนวนนักศึกษาจำแนกตามปีการศึกษา");
//$graph->xaxis->title->Set("X-title");
$graph->yaxis->title->Set("จำนวน(คน)");

$graph->xaxis->SetFont(FF_TAHOMA,FS_NORMAL);
$graph->title->SetFont(FF_COURIER,FS_BOLD);
$graph->yaxis->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);

// Display the graph
$graph->Stroke("student_stat_graph.png");
echo "<img src='student_stat_graph.png'  border=0/>";
?>