| |
";
// 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="อื่น ๆ";
//Iterate through each factory
//if ($result111) {
// while( $rs111 = $dbObj->fetchArray($result111) ) {
$sql3 = " SELECT COUNT(outreacId) AS SumB1 FROM edu_service_tb WHERE M3=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 M3=2 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 M3=3 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 M3=4 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 M3=5 and (AcademicYear>='2553' and AcademicYear<='2556')";
$result7 = $dbObj->execQuery($sql7);
$rs7 = $dbObj->fetchArray($result7);
$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);
?> |
|