"; 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; $myTable0 = "personal_tb"; //=== salary_repot_tb $query0 = " SELECT * FROM $myTable0 ORDER BY Teacher_name ASC "; $result0 = $dbObj->execQuery($query0); //$rs = $dbObj->fetchArray($result); $total = $dbObj->_numrows; /** Config Table for This Page */ $myTable = "projectstdplan_tb"; $myTablePK = "Budget_Year"; $myTable2 = "project_type_tb"; $myTable2PK = "ProjectId"; /* $queryUsr = " SELECT * FROM user_tb WHERE Username='$Username' "; $resultUsr = $dbObj->execQuery($queryUsr); $rss = $dbObj->fetchArray($resultUsr); */ //=== $query = " SELECT * FROM $myTable GROUP BY $myTablePK "; $result = $dbObj->execQuery($query); $num = $dbObj->_numrows; //$total = $dbObj->_numrows; } #else ?> จำนวนบุคลากรตามสถานะ
หน้าหลัก » จำนวนบุคลากรตามสถานะ

"; $strQ = " SELECT * FROM person_type_tb "; $res = $dbObj->execQuery($strQ); $c = mysql_num_rows($res); while( $rs0 = $dbObj->fetchArray($res) ) { $dc = $rs0['Ptype_code']; if ($dc != 2 ){ $sql = " SELECT COUNT(Person_type) AS num FROM personal_tb WHERE StatusId='1' AND Person_type=$dc "; $result = $dbObj->execQuery($sql); $rs = $dbObj->fetchArray($result); $dbObj->freeresult($result); $per = ( $rs['num'] * 100 ) / $total; $p = number_format($per,2,'.','.'); $strXML .= ""; } } //Finally, close element $strXML .= ""; //Create the chart - Pie 3D Chart with data from strXML echo renderChart("../charts/Pie3D.swf", "", $strXML, "",700, 375, false, false); ?>

 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>