"; echo "


กรุณาทำการ Login ก่อน

"; echo ""; exit(); } else { /** Configuration */ require_once( "../configuration.php" ); require_once( $_Config_absolute_path . "/includes/framework.php" ); require_once( "../includes/Function.php" ); /** Chart */ include ("../includes/charts.php"); /** Create Database Object */ $dbObj = new DBConn; /** Config Table for This Page */ $myTable = "edu_service_tb"; $myTablePK = "AcademicYear"; //$myTable2 = "project_type_tb"; //$myTable2PK = "ProjectId"; /* $queryUsr = " SELECT * FROM user_tb WHERE Username='$Username' "; $resultUsr = $dbObj->execQuery($queryUsr); $rss = $dbObj->fetchArray($resultUsr); */ $query = " SELECT DISTINCT(AcademicYear) FROM $myTable Order By AcademicYear ASC "; $result = mysql_query($query); $num = mysql_num_rows($result); } # else ?> ข้อมูลแผนดำเนินงานและรายงาน : ข้อมูลแผนดำเนินการ รายปีงบประมาณ
หน้าหลัก »บันทึกโครงการ»บันทึกกิจกรรม/โครงการ »ข้อมูลโครงการบริการวิชาการ
‹ ย้อนกลับ
 
ปีงบประมาณ งบที่กำหนด งบใช้ไป ส่วนต่าง จำนวนโครงการ
โครงการบริการวิชาการ ปีการศึกษา:
  จำนวนปีทั้งหมด ปี       รวม    โครงการ

 
   
"; // Fetch all factory records $strQuery = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result111 = $dbObj->execQuery($strQuery); //Iterate through each factory if ($result111) { while( $rs111 = $dbObj->fetchArray($result111) ) { $sql3 = " SELECT SUM(Budget) AS SumB1 FROM $myTable WHERE AcademicYear='$rs111[AcademicYear]' "; $result3 = $dbObj->execQuery($sql3); $rs3 = $dbObj->fetchArray($result3); $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); ?> "; // Fetch all factory records $strQuery = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result111 = $dbObj->execQuery($strQuery); //Iterate through each factory if ($result111) { while( $rs111 = $dbObj->fetchArray($result111) ) { $sql3 = " SELECT SUM(Budget_use) AS SumB1 FROM $myTable WHERE AcademicYear='$rs111[AcademicYear]' "; $result3 = $dbObj->execQuery($sql3); $rs3 = $dbObj->fetchArray($result3); $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); ?> "; // Fetch all factory records $strQuery = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result111 = $dbObj->execQuery($strQuery); //Iterate through each factory if ($result111) { while( $rs111 = $dbObj->fetchArray($result111) ) { $sql3 = " SELECT count(DISTINCT (proId)) AS SumB1 FROM $myTable WHERE AcademicYear='$rs111[AcademicYear]' "; $result3 = $dbObj->execQuery($sql3); $rs3 = $dbObj->fetchArray($result3); $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); ?> "; // Fetch all factory records $strQuery = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result111 = $dbObj->execQuery($strQuery); //Iterate through each factory if ($result111) { while( $rs111 = $dbObj->fetchArray($result111) ) { $sql3 = " SELECT count(DISTINCT (proId)) AS SumB1 FROM $myTable WHERE AcademicYear='$rs111[AcademicYear]' "; $result3 = $dbObj->execQuery($sql3); $rs3 = $dbObj->fetchArray($result3); $total=number_format(($rs3['SumB1']*100)/$SUM,2); $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); ?>
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>