<?php
include "src/jpgraph.php" ;
include "src/jpgraph_pie.php";
include "src/jpgraph_pie3d.php";
include "../include/config.php";
$sumRed = 0;
$sumYel = 0;
$sumGre = 0;
$sql = " SELECT * FROM assistance ";
$sresult = mysql_query($sql);
while($sdata = mysql_fetch_array($sresult)) {
if($sdata ['Status_ID']=='green'){
$sumGre=$sumGre+1;
}else if($sdata ['Status_ID']=='yellow'){
$sumYel=$sumYel+1;
}else if($sdata ['Status_ID']=='red'){
$sumRed=$sumRed+1;}
}
$g = new PieGraph(530, 350,"auto");
$title = iconv("tis-620", "utf-8", "HatyaiFloodHelper Prince of Songkla University");
$g->title->Set($title);
$g->title->SetFont(FF_JASMINE, FS_BOLD, 23);
$subtitle = iconv("tis-620", "utf-8", "กราฟแสดงสรุปผลจำนวนผู้ประสบอุทกภัย");
$g->subtitle->Set($subtitle);
$g->subtitle->SetFont(FF_CORDIA, FS_NORMAL, 20);
$legends = array("Complete","Helping","UnHelp");
$data = array($sumGre, $sumYel, $sumRed);
$pie->SetSliceColors(array('green','yellow','red'));
$pie = new PiePlot3D($data);
$pie->SetLegends($legends);
$g->Add($pie);
$g->Stroke();
?>
