Viewing file:  personal_graph.php (6.48 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include("../include/FunctionDB.php");
include ("jpgraph/src/jpgraph.php");
include ("jpgraph/src/jpgraph_bar.php");
ConnectDB();
$sql1 = "SELECT count(Degree_code) as num1 FROM personal_tb WHERE StatusId='1' and Degree_code=1 ";
$result = mysql_query($sql1) or die(" Error").mysql_error();
$rs1 = mysql_fetch_array($result);
$sql2 = "Select Count(Degree_code) as num2 From personal_tb Where StatusId='1' and Degree_code=2 ";
$result = mysql_query($sql2) or die(" Error").mysql_error();
$rs2 = mysql_fetch_array($result);
$sql3 = "Select Count(Degree_code) as num3 From personal_tb Where StatusId='1' and Degree_code=3 ";
$result = mysql_query($sql3) or die(" Error").mysql_error();
$rs3 = mysql_fetch_array($result);
$sql4 = "Select Count(Teacher_type) as num4 From personal_tb Where StatusId='1' and Teacher_type=1 ";
$result = mysql_query($sql4) or die(" Error").mysql_error();
$rs4 = mysql_fetch_array($result);
$sql5 = "Select Count(Teacher_type) as num5 From personal_tb Where StatusId='1' and Teacher_type=4 ";
$result = mysql_query($sql5) or die(" Error").mysql_error();
$rs5 = mysql_fetch_array($result);
$sql6 = "Select Count(Teacher_type) as num6 From personal_tb Where StatusId='1' and Teacher_type=2 ";
$result = mysql_query($sql6) or die(" Error").mysql_error();
$rs6= mysql_fetch_array($result);
$sql7 = "Select Count(Teacher_type) as num7 From personal_tb Where StatusId='1' and Teacher_type=5 ";
$result = mysql_query($sql7) or die(" Error").mysql_error();
$rs7= mysql_fetch_array($result);
$sql8 = "Select Count(Teacher_type) as num8 From personal_tb Where StatusId='1' and Teacher_type=6 ";
$result = mysql_query($sql8) or die(" Error").mysql_error();
$rs8= mysql_fetch_array($result);
$sql9 = "Select Count(Person_type) as num9 From personal_tb Where StatusId='1' and Person_type=1 ";
$result = mysql_query($sql9) or die(" Error").mysql_error();
$rs9= mysql_fetch_array($result);
$sql10 = "Select Count(Person_type) as num10 From personal_tb Where StatusId='1' and Person_type=3 ";
$result = mysql_query($sql10) or die(" Error").mysql_error();
$rs10= mysql_fetch_array($result);
$sql11 = "Select Count(Person_type) as num11 From personal_tb Where StatusId='1' and Person_type=4 ";
$result = mysql_query($sql11) or die(" Error").mysql_error();
$rs11= mysql_fetch_array($result);
/*------------------------------------graduate------------------------------------------*/
$datay=array($rs1['num1'],$rs2['num2'],$rs3['num3']);
// Create the graph. These two calls are always required
$graph = new Graph(600,300,"auto");
$graph->SetScale("textlin");
// Add a drop shadow
$graph->SetShadow();
// Adjust the margin a bit to make more room for titles
$graph->img->SetMargin(40,30,20,40);
// Create a bar pot
$bplot = new BarPlot($datay);
// Specify X-labels
$graph->xaxis->SetTickLabels(array("ปริญญาตรี","ปริญญาโท","ปริญญาเอก"));
// Adjust fill color
$bplot->SetFillColor('orange');
$bplot->value->Show();
$graph->Add($bplot);
// Setup the titles
$graph->title->Set("กราฟแสดงระดับการศึกษาของบุคลากรทุกสายงานทั้งหมด");
//$graph->xaxis->title->Set("วุฒิการศึกษา");
$graph->yaxis->title->Set("จำนวน(คน)");
$graph->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->SetFont(FF_TAHOMA,FS_NORMAL);
$graph->yaxis->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->title->SetFont(FF_COURIER,FS_BOLD);
// Display the graph
$graph->Stroke("graduate.png");
echo "<img src='graduate.png' border=0/><br><br><br>";
/*-----------------------------------personal type-------------------------------------------*/
$datay=array($rs4['num4'],$rs5['num5'],$rs6['num6'],$rs7['num7'],$rs8['num8']);
// Create the graph. These two calls are always required
$graph = new Graph(600,300,"auto");
$graph->SetScale("textlin");
// Add a drop shadow
$graph->SetShadow();
// Adjust the margin a bit to make more room for titles
$graph->img->SetMargin(40,30,20,40);
// Create a bar pot
$bplot = new BarPlot($datay);
// Specify X-labels
$graph->xaxis->SetTickLabels(array("ทันตแพทย์","เภสัชกร","วิทยาจารย์","พยาบาลวิชาชีพ","สายสนับสนุน"));
// Adjust fill color
$bplot->SetFillColor('orange');
$bplot->value->Show();
$graph->Add($bplot);
// Setup the titles
$graph->title->Set("กราฟแสดงบุคลากรตามประเภทสายงาน");
//$graph->xaxis->title->Set("ประเภทสายงาน");
$graph->yaxis->title->Set("จำนวน(คน)");
$graph->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->SetFont(FF_TAHOMA,FS_NORMAL);
$graph->yaxis->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->title->SetFont(FF_COURIER,FS_BOLD);
// Display the graph
$graph->Stroke("personalType.png");
echo "<img src='personalType.png' border=0/><br><br><br>";
/*-------------------------------------persoanl status-----------------------------------------*/
$datay=array($rs9['num9'],$rs10['num10'],$rs11['num11']);
// Create the graph. These two calls are always required
$graph = new Graph(600,300,"auto");
$graph->SetScale("textlin");
// Add a drop shadow
$graph->SetShadow();
// Adjust the margin a bit to make more room for titles
$graph->img->SetMargin(40,30,20,40);
// Create a bar pot
$bplot = new BarPlot($datay);
// Specify X-labels
$graph->xaxis->SetTickLabels(array("ข้าราชการ","ลูกจ้างประจำ","ลูกจ้างชั่วคราว(เหมาจ่าย)"));
// Adjust fill color
$bplot->SetFillColor('orange');
$bplot->value->Show();
$graph->Add($bplot);
// Setup the titles
$graph->title->Set("กราฟแสดงบุคลากรตามสถานะ");
//$graph->xaxis->title->Set("สถานะบุคลากร");
$graph->yaxis->title->Set("จำนวน(คน)");
$graph->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->SetFont(FF_TAHOMA,FS_NORMAL);
$graph->yaxis->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->title->SetFont(FF_COURIER,FS_BOLD);
// Display the graph
$graph->Stroke("personalStatus.png");
echo "<img src='personalStatus.png' border=0/>";
/*------------------------------------------------------------------------------------------------*/
?>
|