|
$setdata=$_POST[setdata];
$multi=$_POST[multi];
if($multi==TRUE){
if($setdata=="A"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and Year_prop !='0' GROUP BY rt.Year_prop ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.Year_prop ='$rs1[Year_prop]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="B"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and academic_year_finish !='0' GROUP BY rt.academic_year_finish ";
$result2= mysql_query($strQuery);
//Iterate through each factory
if ($result2) {
while( $rs2 = mysql_fetch_array($result2) ) {
$error_id = $rs2['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.academic_year_finish ='$rs2[academic_year_finish]' ";
$result3 = mysql_query($strQuery);
$numAmt = mysql_num_rows($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);
?>
}
if($setdata=="C"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish !='0' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish='$rs1[fiscal_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="D"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rt.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outreacId ='Y' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rt.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outreacId ='Y' and rt.fiscal_year_finish ='$rs1[fiscal_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="E"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rb.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outSouse ='Y' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * FROM research_tb rt, research_public_tb rb , research_success_tb rst WHERE rt.Research_code = rb.Research_code and rb.Research_code=rst.Research_code and rb.ReTyId='1' and rst.outSouse ='Y' and rt.fiscal_year_finish ='$rs1[fiscal_year_finish]' ";
$result2 = mysql_query($strQuery);
$numAmt = mysql_num_rows($result2);
$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);
?>
}
if($setdata=="F"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt, research_dissemination rd WHERE rt.Research_code = rd.Research_code Group By rd.academic_year_finish ";
$result1 = mysql_query($strQuery);
//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,'.',',');
$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);
?>
}
if($setdata=="G"){
?>
";
// Fetch all factory records
$strQuery = " SELECT * FROM research_tb rt , research_dissemination rd WHERE rt.Research_code = rd.Research_code Group By rd.academic_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if ($result1) {
while( $rs1 = mysql_fetch_array($result1) ) {
$error_id = $rs1['id'];
$strQuery = " SELECT * 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);
$numAmt = mysql_num_rows($result2);
$strXML .= "";
} # while
} # if
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column2D.swf", "", $strXML, "", 750, 375, false, false);
?>
}
if($setdata=="H"){
?>
";
// 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'];
$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);
?>
}
if($setdata=="K"){
?>
$animateChart = "1";
//$strXML will be used to store the entire XML document generated
//Generate the chart element
$strXML = "";
// Fetch all factory records
$strQuery = "SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
$strXML .= "";
while( $rs1 = mysql_fetch_array($result1) ) {
$fiscal_year_finish = $rs1['fiscal_year_finish'];
$strXML .= "";
} # while
$strXML .= "";
}# if
mysql_free_result($result1);
// Fetch all factory records
$strQuery = "SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
$strXML .= "";
while( $rs1 = mysql_fetch_array($result1) ) {
$fiscal_year_finish = $rs1['fiscal_year_finish'];
$strQuery2 = "SELECT SUM(FundIn) AS Fun FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish ='$fiscal_year_finish' ";
$result2 = mysql_query($strQuery2);
$rs2 = mysql_fetch_array($result2);
// $Fun= mysql_num_rows($result2);
mysql_free_result($result2);
$strXML .= "";
} # while
$strXML .= "";
} # if
mysql_free_result($result1);
// Fetch all factory records
$strQuery = "SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
$strXML .= "";
while( $rs1 = mysql_fetch_array($result1) ) {
$fiscal_year_finish = $rs1['fiscal_year_finish'];
$strQuery3 = " SELECT SUM(FundOut) AS Sum FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish ='$fiscal_year_finish' ";
$result3 = mysql_query($strQuery3);
$rs3 = mysql_fetch_array($result3);
// $Fuo = mysql_num_rows($result3);
mysql_free_result($result3);
$strXML .= "";
} # while
$strXML .= "";
} # if
mysql_free_result($result1);
//Finally, close element
$strXML .= "";
//Create the Multi-series Line Chart with data from strXML
echo renderChart("../charts/MSLine.swf", "", $strXML, "", 650, 375, false, false);
?>
}
if($setdata=="J"){
?>
$animateChart = "1";
//$strXML will be used to store the entire XML document generated
//Generate the chart element
$strXML = "";
// Fetch all factory records
$strQuery = "SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
$strXML .= "";
while( $rs1 = mysql_fetch_array($result1) ) {
$fiscal_year_finish = $rs1['fiscal_year_finish'];
$strXML .= "";
} # while
$strXML .= "";
}# if
mysql_free_result($result1);
// Fetch all factory records
$strQuery = "SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
$strXML .= "";
while( $rs1 = mysql_fetch_array($result1) ) {
$fiscal_year_finish = $rs1['fiscal_year_finish'];
$query = " SELECT SUM(rt.FundIn) AS B6 FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish ='$fiscal_year_finish' ";
$result6 = $dbObj->execQuery($query);
$rs6 = $dbObj->fetchArray($result6);
$query = " SELECT SUM(rt.FundUse) AS B7 FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish ='$fiscal_year_finish' ";
$result7 = $dbObj->execQuery($query);
$rs7 = $dbObj->fetchArray($result7);
$per1 = ($rs6['B6'] * 100 ) / $rs7['B7'] ;
$strXML .= "";
} # while
$strXML .= "";
} # if
mysql_free_result($result1);
// Fetch all factory records
$strQuery = "SELECT * FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' GROUP BY rt.fiscal_year_finish ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
$strXML .= "";
while( $rs1 = mysql_fetch_array($result1) ) {
$fiscal_year_finish = $rs1['fiscal_year_finish'];
$query = " SELECT SUM(rt.FundOut) AS B6 FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish ='$fiscal_year_finish' ";
$result6 = $dbObj->execQuery($query);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
$query = " SELECT SUM(rt.FundUse) AS B7 FROM research_tb rt, research_public_tb rb WHERE rt.Research_code = rb.Research_code and rb.ReTyId='1' and rt.fiscal_year_finish ='$fiscal_year_finish' ";
$result7 = $dbObj->execQuery($query);
$rs7 = $dbObj->fetchArray($result7);
$dbObj->freeresult($rs7);
$per2= ( $rs6['B6'] * 100 ) / $rs7['B7'] ;
$strXML .= "";
} # while
$strXML .= "";
} # if
mysql_free_result($result1);
//Finally, close element
$strXML .= "";
//Create the Multi-series Line Chart with data from strXML
echo renderChart("../charts/MSLine.swf", "", $strXML, "", 650, 375, false, false);
?>
}
}
?> |
|
๑.ข้อมูลงานวิจัย |
|
๑.๑.จำนวนผลงานวิจัยจำแนกตามปีงบประมาณ |
|
๑.๒.จำนวนผลงานวิจัยจำแนกตามปีการศึกษา |
|
๑.๓.จำนวนผลงานวิจัยจำแนกตามปีปฏิทิน |
|
๑.๔.จำนวนผลคะแนนงานที่เผยแพร่ตามปีปฏิทิน |
|
๑.๕.จำนวนผลงานวิจัยจำแนกตามลักษณะของผลงาน |
|
๑.๖.จำนวนผลงานวิจัยจำแนกตามรูปแบบงานวิจัย |
|
๑.๗.จำนวนขั้นตอนการทำผลงานวิจัย |
|
๑.๘.จำนวนผลงานวิจัยจำแนกรายรายบุคคล |
|
๑.๙.จำนวนผลงานวิจัยที่ได้รับการรับรองคุณภาพ |
|
๑.๑๐.จำนวนงานวิจัยที่บูรณาการกับโครงการบริการวิชาการ |
|
๑.๑๑.จำนวนงานวิจัยที่บูรณาการกับรายวิชา |
|
๑.๑๒.จำนวนงานวิจัยที่มีความร่วมมืองานวิจัยกับบุคคลภายนอก |
|
๑.๑๓.จำนวนร้อยละของงานวิจัย เปรียบเทียบจำนวนงานวิจัยของอาจารย์ในแต่ละปีการศึกษา |
|
๑.๑๔.จำนวนร้อยละของทุนวิจัยภายในและภายนอกแต่ละปีงบประมาณ |
|
๑.๑๕.ค้นหาวันที่เริ่มต้นและสิ้นสุดทำงานวิจัย |
๒.ข้อมูลประเภทผลงานอื่นๆ |
|
๒.๑.จำนวนประเภทผลงานจำแนกรายบุคคล |
|
๒.๒.จำนวนประเภทผลงาน |
๓.สรุปจำนวนโครงการผลงานจำแนกตามประเภทงาน |
|
No |
รายการ |
จำนวน เรื่อง |
เงินทน ภายใน |
เงินทุน ภายนอก |
จำนวน เงินทั้งหมด |
execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rs1 = $dbObj->fetchArray($result8) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
=$no;?> |
|
execQuery($query2);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result2);
echo $countnum;
?>
|
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum'],2,'.',',') ;
?>
|
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum'],2,'.',',') ;
?>
|
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo number_format($rs6['Sum'],2,'.',',') ;
?> |
|
|