|
";
// Fetch all factory records
$sql = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.academic_year_finish ";
$result1 = mysql_query($sql);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
// $strQuery = " SELECT SUM(Results) AS Sum FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code and rd.academic_year_finish='$rs1[academic_year_finish]' ";
// $result2 = mysql_query($strQuery);
//$rs2 = $dbObj->fetchArray($result2);
// $Sum = mysql_num_rows($result2);
// echo number_format($rs6['Sum'],2,'.',',');
$sql = " SELECT COUNT(rt.Research_code) AS RC FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.academic_year_finish='$rs1[academic_year_finish]' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$sql = " SELECT * FROM research_year py, research_tb rt WHERE py.AcademicYear= rt.academic_year_finish and py.AcademicYear ='$rs1[academic_year_finish]' ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$per2= ( $rs2['RC'] * 100 ) / $rs3['Teacheryear'] ;
//echo number_format($per2,'2','.','')." %";
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Pie3D.swf", "", $strXML, "", 650, 375, false, false);
?> |
No. |
ปีการศึกษา |
จำนวนผล งานวิจัย |
จำนวนผู้ร่วม ทำงานวิจัย |
จำนวน อาจารย์ประจำ |
สัดส่วนอาจารย์ ประจำต่องานวิจัย |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
=$no;?> |
&ReTyId==$rs['ReTyId']; ?>" title=" Click to more detail ">=$rs["academic_year_finish"];?> |
execQuery($query2);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result2);
echo $countnum;
?> |
execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$dbObj->freeresult($result2);
echo $rs2['countR'];
?>
|
execQuery($query2);
$rs2 = $dbObj->fetchArray($result2);
echo $rs2['Teacheryear'] ;
?> |
execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$sql = " SELECT * FROM research_year py, research_tb rt WHERE py.AcademicYear= rt.academic_year_finish and py.AcademicYear ='$rs[academic_year_finish]' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs1['RC'] * 100 ) / $rs2['Teacheryear'] ;
echo number_format($per2,'2','.','')." %";
?>
|
|
|