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; ?>

หน้าหลัก » แผนภูมิแสดงประเภทของบุคลากร   ‹ ย้อนกลับ "; $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 !=0 ){ $sql = " SELECT COUNT(Teacher_code) AS num FROM personal_tb WHERE StatusId='1' and Person_type=$dc and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') "; $result = $dbObj->execQuery($sql); $rs = $dbObj->fetchArray($result); $sql2 = " SELECT COUNT(Teacher_code) AS sum FROM personal_tb WHERE StatusId='1' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') "; $result2 = $dbObj->execQuery($sql2); $rs2 = $dbObj->fetchArray($result2); $per = ( $rs['num'] * 100 ) / $rs2['sum']; $p = number_format($per,2,'.','.'); $strXML .= ""; } } //Finally, close element $strXML .= ""; //Create the chart - Pie 3D Chart with data from strXML echo renderChart("charts/Column3D.swf", "", $strXML, "",650, 375, false, false); ?>   execQuery($sql); $no = 1+($display-1)*$limit; while( $rss3 = $dbObj->fetchArray($result9) ) { $bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF"; ?> No รายการ ปฏิบัติงาน อัตราส่วน ลาศึกษา ไปช่วยราชการ จำนวน execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num1']; ?> execQuery($sql); $rs2 = $dbObj->fetchArray($result2); $per2= ( $rs1['num1'] * 100 ) / $rs2['sum'] ; echo number_format($per2,2,'.','.'); ?> execQuery($sql); $rs2 = $dbObj->fetchArray($result2); $dbObj->freeresult($result7); echo $rs2['num2']; ?> execQuery($sql); $rs3 = $dbObj->fetchArray($result3); $dbObj->freeresult($result7); echo $rs3['num3']; ?>   สรุป execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?> 100% execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?> execQuery($sql); $rs1 = $dbObj->fetchArray($result1); $dbObj->freeresult($result7); echo $rs1['num5']; ?>

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