|
";
// Fetch all factory records
//$strQuery = " SELECT DISTINCT(Budget_Year) FROM edu_service_tb where M21=1 and (Budget_Year>='2553' and Budget_Year<='2556') Order BY Budget_Year ASC ";
//$result111 = $dbObj->execQuery($strQuery);
$text1="การเรียนการสอน";
$text2="การงานวิจัย/บทความ";
$text3="การเรียนการสอนและงานวิจัย";
$text4="กิจการนักศึกษา";
$text5="พัฒนาบุคลากรฯ";
$text6="อื่น ๆ";
//Iterate through each factory
//if ($result111) {
// while( $rs111 = $dbObj->fetchArray($result111) ) {
$sql3 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE M21=1 and (AcademicYear>='2553' and AcademicYear<='2556')";
$result3 = $dbObj->execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
$sql4 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE M22=1 and (AcademicYear>='2553' and AcademicYear<='2556')";
$result4 = $dbObj->execQuery($sql4);
$rs4 = $dbObj->fetchArray($result4);
$sql5 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE (M21=1 and M22=1) and (AcademicYear>='2553' and AcademicYear<='2556')";
$result5 = $dbObj->execQuery($sql5);
$rs5 = $dbObj->fetchArray($result5);
$sql6 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE M23=1 and (AcademicYear>='2553' and AcademicYear<='2556')";
$result6 = $dbObj->execQuery($sql6);
$rs6 = $dbObj->fetchArray($result6);
$sql7 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE M24=1 and (AcademicYear>='2553' and AcademicYear<='2556')";
$result7 = $dbObj->execQuery($sql7);
$rs7 = $dbObj->fetchArray($result7);
$sql8 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE M25=1 and (AcademicYear>='2553' and AcademicYear<='2556')";
$result8 = $dbObj->execQuery($sql8);
$rs8 = $dbObj->fetchArray($result8);
$strXML .= "";
$strXML .= "";
$strXML .= "";
$strXML .= "";
$strXML .= "";
$strXML .= "";
//} # while
//} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|