Viewing file:  MIS104.php (100.09 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../include/Function.php" );
require_once( "../calendar/check.php" );
require_once( "../calendar/cal_func.php" );
require_once( "../link/function.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Chart */
include ("../includes/charts.php");
/** Config Table for This Page */
$myTable = "dev_his";
$Username = $valid_user;
$query = " SELECT * FROM $myTable WHERE Year_std='$Year_std' ";
$result = $dbObj->execQuery($query);
$rs = $dbObj->fetchObject($result);
} # else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="../js/utilities.js"></script>
<script language="Javascript" src="../charts/charts.js"></script>
<title></title>
<script type="text/javascript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include("../templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
<td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="30" background="../images/background/bg-head-topic-w780.gif" style="padding-left:15px;"><strong><a href="index.php">หน้าหลัก</a> » ข้อมูลรายงานผู้บริหาร</strong></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><span class="PADDING-TOP-10"><img src="../images/icons/arrow-circle-225-left.png" width="16" height="16" border="0" align="absmiddle" /> <a href="javascript:;" onclick="window.history.back();"><strong>‹ ย้อนกลับ</strong></a></span></td>
</tr>
<tr>
<td align="center"><table width="99%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center"> </td>
<td height="43" colspan="2" align="left"><table width="226" border="0" align="left" cellpadding="0" cellspacing="1">
<tr>
<td align="center"><select name="jumpMenu" id="jumpMenu" onchange="MM_jumpMenu('parent',this,0)">
<option>
<?php
$strSQL = " SELECT * FROM project_year ORDER by Budget_Year asc ";
$result4 = mysql_query($strSQL);
while( $rs4 = mysql_fetch_array($result4) ) {
?>
</option>
<option value="MIS104.php?Budget_Year=<?=$rs4['Budget_Year'];?>" <?php if( $rs4['Budget_Year']==$Budget_Year ) echo 'selected'; ?>>
<?=$rs4['Budget_Year'];?>
</option>
<?php
} # while
?>
</select>
ค้นหาปีงบประมาณ</td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๑.ปรัชญา/ปณิธาน วิสัยทัศน์ พันธกิจ นโยบาย วัตถุประสงค์และแผนการดำเนินงาน</td>
</tr>
<tr>
<td width="4%" align="center"> </td>
<td width="3%" height="20" align="center"> </td>
<td width="93%">๑.๑. <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">แผนยุทศาสตร์และแผนกลยุทธ์</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๑.๒. <a href="missionByYear.php?Budget_Year=<?=$Budget_Year ;?>">แผนปฏิบัติงานประจำปีของสถาบันการศึกษา</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td><?php
$animateChart = "1";
//$strXML will be used to store the entire XML document generated
//Generate the chart element
$strXML = "<chart caption='แผนภูมิแสดงจำนวนเงินแผนดำเนินการรายปี' subCaption='' pieSliceDepth='30' showBorder='0' formatNumberScale='0' numberSuffix=' ' animation=' " . $animateChart . "'>";
// Fetch all factory records
$strQuery = " SELECT * FROM project_year Order BY Budget_Year ASC ";
$result111 = $dbObj->execQuery($strQuery);
//Iterate through each factory
if ($result111) {
while( $rs111 = $dbObj->fetchArray($result111) ) {
$sql3 = " SELECT SUM(Budget_total) AS SumB1 FROM project_type_tb WHERE Budget_Year='$rs111[Budget_Year]' ";
$result3 = $dbObj->execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
$strXML .= "<set label='ปีงบประมาณ " . $rs111['Budget_Year'] . "' value='" .$rs3['SumB1'] . "' />";
} # while
} # if
//Finally, close <chart> element
$strXML .= "</chart>";
//Create the chart - Pie 3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 550, 300, false, false);
?></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๑.๓. รายงานผลการติดตาม ตรวจสอบและประเมินผลการดำเนินงานของสถาบันตามแผนงานและ โครงการทุกปี</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๑.๔. <a href="Menu_Report.php?Budget_Year=<?=$Budget_Year ;?>">รายงานการใช้เงินตามแผนและพันธกิจปีงบประมาณ</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๒.การจัดการเรียนการสอน</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๒.๑. <a href="CourseByYear.php?Budget_Year=<?=$Budget_Year ;?>">จำนวนรายวิชาที่เปิดการสอนตามปีการศึกษา</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๒.๒. <a href="OutCombyYear.php?Budget_Year=<?=$Budget_Year ;?>">ผลการเรียนรู้รายปีการศึกษาและรายหลักสูตร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๒.๓. แผนการจัดการเรียนการสอนแต่ละชั้นปีตลอดหลักสูตรและมีการดำเนินงานตามแผน </a><a href="OutCombyYear.php??Budget_Year=<?=$Budget_Year ;?>"></a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๒.๔. <a href="course.php">จำนวนรายวิชาที่เปิดสอนตามหลักสูตรจำแนกตามปีการศึกษา</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๒.๕. <a href="CourseList.php">ข้อมูลหลักสูตรที่เปิดสอน</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" colspan="2" align="left">๓.ข้อมูลนักศึกษา</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๓.๑. <a href="StudentByYear.php">จำนวนนักศึกษาจำแนกตามปีการศึกษา</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๓.๒. <a href="StudentByCourse.php?Succ_Status=1">จำนวนนักศึกษาจำแนกตามหลักสูตร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๓.๒. <a href="GraduateYear.php">จำนวนร้อยละผู้สำเร็จการศึกษาตามระยะเวลาที่กำหนดไว้ในหลักสูตร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๓.๓. <a href="NursingExamList.php">จำนวนร้อยละผลสอบสภาการพยาบาลรายปีการศึกษา</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๔ . ข้อมูลบุคลากร</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๔.๑. <a href="PersonalDegree.php?Teacher_type=5">อาจารย์พยาบาลที่มีระยะเวลาทำงานกับสถาบันการศึกษาที่ของรับรองเพียงแห่งเดียวทั้งปีการศึกษา หรือมีระยะเวลาทำงานไม่ต่ำกว่า 9 เดือน ต่อปีการศึกษา </a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๒. <a href="PersonalColl.php?Teacher_type=5">อาจารยที่มีใบอนุญาตประกอบวิชาชีพการพยาบาลชั้นหนึ่ง / การพยาบาล และการผดุงครรภ์ชั้นหนึ่ง</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๓. อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาลไม่น้อยกว่า 1 ปี หลังสำเร็จปริญญาโท, เอกทางการพยาบาลหรือวิทยาศาสตร์สุขภาพหรือไม่น้อยกว่า 2 ปี หลังสำเร็จปริญญาโท, เอก สาขาอื่น หรือไม่น้อยกว่า 3 ปีหลังสำเร็จปริญญาตรีทางการการพยาบาล</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="97%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="20" align="center" bgcolor="#FF9999">อาจารย์ประจำที่วุฒิการศึกษาสูงสุด</td>
<? $query = " SELECT * FROM personal_tb WHERE StatusId='1' AND Teacher_type='5' ";
$result = $dbObj->execQuery($query);
$total = $dbObj->_numrows;
?>
<td width="7%" align="center" bgcolor="#FF9999">จำนวน</td>
</tr>
<tr>
<td height="20" align="left"class="PADDING-LEFT-5">๔.๓.๑.อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาลไม่น้อยกว่า 1 ปี หลังสำเร็จปริญญาโท ทางการพยาบาล</a></td>
<td align="center"><a href="DegreePersonal1.php">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE Type_degree2='3' and StatusId='1' AND Teacher_type='5' and Degree_code='2' and datediff('".((date('Y')+543).date('-m-d'))."',Degree_His2_End_Year) > 360 ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num7'];
?>
</a></td>
</tr>
<tr>
<td height="20" align="left"class="PADDING-LEFT-5">๔.๓.๒.อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาลไม่น้อยกว่า 1 ปี หลังสำเร็จปริญญาเอกทางการพยาบาล</a></td>
<td align="center"><a href="DegreePersonal2.php">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE Type_degree3='3' and StatusId='1' AND Teacher_type='5' and Degree_code='3' and datediff('".((date('Y')+543).date('-m-d'))."',Degree_His3_End_Year) > 360 ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num7'];
?>
</a></td>
</tr>
<tr>
<td height="20" align="left"class="PADDING-LEFT-5">๔.๓.๓.อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาลไม่น้อยกว่า 2 ปี หลังสำเร็จปริญญาโท </a>สาขาวิทยาศาสตร์สุขภาพหรืออื่นๆ</td>
<td align="center"><a href="DegreePersonal3.php">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE (Type_degree2='1' or Type_degree2='2' ) and (StatusId='1' or StatusId='3' ) AND Teacher_type='5' and Degree_code='2' and datediff('".((date('Y')+543).date('-m-d'))."',Degree_His2_End_Year) > 360 ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num7'];
?>
</a></td>
</tr>
<tr>
<td height="20" align="left"class="PADDING-LEFT-5">๔.๓.๔.อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาลไม่น้อยกว่า 2 ปี หลังสำเร็จปริญญาเอก</a>สาขาวิทยาศาสตร์สุขภาพหรืออื่นๆ</td>
<td align="center"><a href="DegreePersonal4.php">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE (Type_degree3='1' or Type_degree3='2' ) and StatusId='1' AND Teacher_type='5' and Degree_code='3' and datediff('".((date('Y')+543).date('-m-d'))."',Degree_His3_End_Year) > 360 ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num7'];
?>
</a></td>
</tr>
<tr>
<td height="20" align="left"class="PADDING-LEFT-5">๔.๓.๕.อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาล ไม่น้อยกว่า 3 ปี ปีหลังสำเร็จปริญญาตรีทางการการพยาบาล</td>
<td align="center"><a href="DegreePersonal5.php">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE Type_degree1='3' and StatusId='1' AND Teacher_type='5' and Degree_code='1' and datediff('".((date('Y')+543).date('-m-d'))."',Degree_His1_End_Year) > 1080 ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num7'];
?>
</a></td>
</tr>
<tr>
<td height="20" align="center"> </td>
<td align="center"> </td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๔. ร้อยละของจำนวนอาจารย์ประจำที่มีวุฒิการศึกษา ระดับปริญญาเอก, ระดับปริญญาโทหรือสูงกว่า,ระดับปริญญาตรี (ทำการสอนไม่น้อยกว่า 3 ปี )</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="97%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2" align="center" bgcolor="#FF99CC">รายการ</td>
<? $query = " SELECT * FROM personal_tb WHERE StatusId='1' AND Teacher_type='5' ";
$result = $dbObj->execQuery($query);
$total = $dbObj->_numrows;
?>
<td width="12%" align="center" bgcolor="#FF99CC">ปริญญาตรี</td>
<td width="12%" align="center" bgcolor="#FF99CC">ปริญญาโท</td>
<td width="11%" align="center" bgcolor="#FF99CC">ปริญญาเอก</td>
<td width="9%" align="center" bgcolor="#FF99CC">จำนวน</td>
</tr>
<tr>
<td height="20" align="center"><img src="../images/icons/arrow2.gif" width="12" height="12" /></td>
<td height="20"><a href="PersonalData.php?Teacher_type=5">อาจารย์พยาบาล</a></td>
<td height="20" align="center"><a href="PersonalDegree1.php?Degree_code=1&Teacher_type=5">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE (StatusId='1' or StatusId='3' ) AND Teacher_type='5' and Degree_code='1' and datediff('".((date('Y')+543).date('-m-d'))."',Degree_His1_End_Year) >=1080 ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num7'];
?>
</a></td>
<td height="20" align="center"><a href="PersonalDegree2.php?Degree_code=2&Teacher_type=5">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE (StatusId='1' or StatusId='3' ) AND Teacher_type='5' and Degree_code='2' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$dbObj->freeresult($result7);
echo $rs2['num7'];
?>
</a></td>
<td align="center"><a href="PersonalDegree3.php?Degree_code=3&Teacher_type=5">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num7 FROM personal_tb WHERE (StatusId='1' or StatusId='3' ) AND Teacher_type='5' and Degree_code='3' ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num7'];
?>
</a></td>
<td align="center"><?php
$sum = $rs1['num7']+ $rs2['num7']+ $rs3['num7']; ;
echo $sum ;
?></td>
</tr>
<tr>
<td width="3%" height="20" align="center"> </td>
<td height="20" align="center">สัดส่วน</td>
<td height="20" align="center"><?php
$per1= ( $rs1['num7'] * 10 ) / $sum;
echo number_format($per1,2,'.','.');
?></td>
<td height="20" align="center"><?php
$per2 = ( $rs2['num7'] * 10 ) / $sum;
echo number_format($per2,2,'.','.');
?></td>
<td align="center"><?php
$per3 = ( $rs3['num7'] * 10 ) / $sum;
echo number_format($per3,2,'.','.');
?></td>
<td align="center"><?php
$per7 = $per1 + $per2 + $per3 ;
//$per7 = ( $rs4['num7'] * 100 ) / $total;
echo number_format($per7,2,'.','.');
?></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๕. จำนวนอาจารย์ใหม่ที่ได้รับการเตรียมความพร้อมตามระบบที่กำหนด</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๑ <a href="PlanPerson.php?Teacher_type=5&Budget_Year=<?=$Budget_Year ;?>">รายงานการอบรม ศึกษา ดูงาน สัมมนา ประชุมวิชาการ ทั้งในและต่างประเทศของอาจารย์ พยาบาลแต่ละบุคคล</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๒.<a href="PlanPerson.php?Teacher_type=2&Budget_Year=<?=$Budget_Year ;?>" >รายงานการอบรม ศึกษา ดูงาน สัมมนา ประชุมวิชาการ ทั้งในและต่างประเทศของวิทยาจารย์ แต่ละบุคคล</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๓.<a href="PlanPerson.php?Teacher_type=6&Budget_Year=<?=$Budget_Year ;?>">รายงานการอบรม ศึกษา ดูงาน สัมมนา ประชุมวิชาการ ทั้งในและต่างประเทศของสายสนับสนุน แต่ละบุคคล</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๔ <a href="SearchTraning.php?Year_std=<?=$Budget_Year ;?>">ค้นหาข้อมูลการอบรม ศึกษา ดูงาน สัมมนา ประชุมวิชาการ ทั้งในและต่างประเทศของอาจารย์ แต่ละบุคคล</a> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๕ <a href="SearchTrain.php?Year_std=<?=$Budget_Year ;?>">ค้นหาข้อมูลเนื้อหาสาระรายด้าน</a> [
<?=$Budget_Year ;?>
]</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๖ <a href="dev_01.php?Budget_Year=<?=$Budget_Year ;?>">สรุปข้อมูลการพัฒนาตามสรรถนะ</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๗ <a href="dev_02.php?Budget_Year=<?=$Budget_Year ;?>" >สรุปข้อมูลการพัฒนาด้านเนื้อหาสาระ</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๖.๘ <a href="dev_03.php?Budget_Year=<?=$Budget_Year ;?>">สรุปข้อมูลการวัตุถุประสงค์การไปราชการ</a> [<?=$Budget_Year ;?>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๗. จำนวนประเภทบุคลากที่ปฏิบัติงานและลาศึกษาต่อ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="97%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td width="4%" height="22" align="center" bgcolor="#FF9999">No</td>
<td width="43%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปฏิบัติงาน</td>
<td width="10%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">อัตราส่วน</td>
<td width="9%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ลาศึกษา</td>
<td width="12%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ไปช่วยราชการ</td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">จำนวน</td>
</tr>
<?php
$sql = " SELECT * FROM person_type_tb " ;
$result9 = $dbObj->execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss3 = $dbObj->fetchArray($result9) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss3['Ptype_name'];?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalDataType.php?StatusId=1&Person_type=<?=$rss3['Ptype_code'];?>">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num1 FROM personal_tb WHERE StatusId='1' and Person_type='$rss3[Ptype_code]' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num1'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) 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($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs1['num1'] * 100 ) / $rs2['sum'] ;
echo number_format($per2,2,'.','.');
?></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalDataType.php?StatusId=3&Person_type=<?=$rss3['Ptype_code'];?>">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num2 FROM personal_tb WHERE StatusId='3' and Person_type='$rss3[Ptype_code]' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$dbObj->freeresult($result7);
echo $rs2['num2'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalDataType.php?StatusId=2&Person_type=<?=$rss3['Ptype_code'];?>">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num3 FROM personal_tb WHERE StatusId='2' and Person_type='$rss3[Ptype_code]' ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num3'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalSumType.php?Person_type=<?=$rss3['Ptype_code'];?>"><?php
$sum = $rs1['num1']+ $rs2['num2']+ $rs3['num3'];
echo $sum ;
?></a></td>
<?php
$no++ ;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFCCFF"> </td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num5 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') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?>
</a></a></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">100%</td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE StatusId='3' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE StatusId='2' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE ( StatusId='1' Or StatusId='2' Or StatusId='3' ) and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
</tr>
</table> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๘. จำนวนสายงานบุคลากรที่ปฏิบัติงานและลาศึกษาต่อ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="97%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td width="5%" height="22" align="center" bgcolor="#FF9999">No</td>
<td width="48%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปฏิบัติงาน</td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ลาศึกษา</td>
<td width="15%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ไปช่วยราชการ</td>
<td width="10%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">จำนวน</td>
</tr>
<?php
$sql = " SELECT * FROM teacher_type_tb Where Flag ='Y' " ;
$result8 = $dbObj->execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss4 = $dbObj->fetchArray($result8) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> <?=$rss4['Ttype_name'];?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalDataEdu.php?StatusId=1&Teacher_type=<?=$rss4['Ttype_code'];?>">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Teacher_type='$rss4[Ttype_code]' ";
$result11 = $dbObj->execQuery($sql);
$rs11 = $dbObj->fetchArray($result11);
$dbObj->freeresult($result11);
echo $rs11['num'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalDataEdu.php?StatusId=3&Teacher_type=<?=$rss4['Ttype_code'];?>">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='3' and Teacher_type='$rss4[Ttype_code]' ";
$result12 = $dbObj->execQuery($sql);
$rs12 = $dbObj->fetchArray($result12);
$dbObj->freeresult($result12);
echo $rs12['num'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="PersonalDataEdu.php?StatusId=2&Teacher_type=<?=$rss4['Ttype_code'];?>">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='2' and Teacher_type='$rss4[Ttype_code]' ";
$result13 = $dbObj->execQuery($sql);
$rs13 = $dbObj->fetchArray($result13);
$dbObj->freeresult($result13);
echo $rs13['num'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sum = $rs11['num']+ $rs12['num']+ $rs13['num']; ;
echo $sum ;
?></td>
<?php
$no++ ;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFCCFF"> </td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='1' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='3' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='2' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and (pt.StatusId='1' Or pt.StatusId='2' Or pt.StatusId='3') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
echo $rs1['num5'];
?></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๙. จำนวนประเภทบุคลากรประจำที่มีวุฒิการศึกษาสูงสุด</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="97%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td width="5%" height="22" align="center" bgcolor="#FF9999">No</td>
<td width="48%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปริญญาตรี</td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปริญญาโท</td>
<td width="15%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปริญญาเอก</td>
<td width="10%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">จำนวน</td>
</tr>
<?php
$sql = " SELECT * FROM person_type_tb " ;
$result19 = $dbObj->execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss13 = $dbObj->fetchArray($result19) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss13['Ptype_name'];?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="DegreeType1.php?Person_type=<?=$rss13['Ptype_code']; ?>&Degree_code=1">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Person_type='$rss13[Ptype_code]' and Degree_code='1' ";
$result11 = $dbObj->execQuery($sql);
$rs11 = $dbObj->fetchArray($result11);
$dbObj->freeresult($result11);
echo $rs11['num'];
?>
</a><a href="PersonalDataType.php?StatusId=1&Person_type=<?=$rss3['Ptype_code'];?>"></a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="DegreeType2.php?Person_type=<?=$rss13['Ptype_code']; ?>&Degree_code=2">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Person_type='$rss13[Ptype_code]' and Degree_code='2' ";
$result12 = $dbObj->execQuery($sql);
$rs12 = $dbObj->fetchArray($result12);
$dbObj->freeresult($result12);
echo $rs12['num'];
?>
</a><a href="PersonalDataType.php?StatusId=3&Person_type=<?=$rss3['Ptype_code'];?>"></a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="DegreeType3.php?Person_type=<?=$rss13['Ptype_code']; ?>&Degree_code=3">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Person_type='$rss13[Ptype_code]' and Degree_code='3' ";
$result13 = $dbObj->execQuery($sql);
$rs13 = $dbObj->fetchArray($result13);
echo $rs13['num'];
?>
</a><a href="PersonalDataType.php?StatusId=2&Person_type=<?=$rss3['Ptype_code'];?>"></a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sum = $rs11['num']+ $rs12['num']+ $rs13['num']; ;
echo $sum ;
?></td>
<?php
$no++ ;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">สรุป</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"></a>
<?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE StatusId='1' and Degree_code='1' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE StatusId='1' and Degree_code='2' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE StatusId='1' and Degree_code='3' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS num5 FROM personal_tb WHERE StatusId='1' and (Degree_code='1' Or Degree_code='2' Or Degree_code='3' ) and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result7);
echo $rs1['num5'];
?></td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFCCFF"> </td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">อัตราส่วน</td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS sum FROM personal_tb WHERE StatusId='1' and Degree_code='1' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ;
echo number_format($per2,2,'.','.');
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS sum FROM personal_tb WHERE StatusId='1' and Degree_code='2' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ;
echo number_format($per2,2,'.','.');
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_type) AS sum FROM personal_tb WHERE StatusId='1' and Degree_code='3' and ( Person_type='1' Or Person_type='2' Or Person_type='3' Or Person_type='4' Or Person_type='5') ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$per2= ( $rs2['sum'] * 100 ) / $rs1['num5'] ;
echo number_format($per2,2,'.','.');
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">100%</td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๑๐. จำนวนสายงานบุคลากรประจำที่มีวุฒิการศึกษาสูงสุด</td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="97%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td width="5%" height="22" align="center" bgcolor="#FF9999">No</td>
<td width="48%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปริญญาตรี</td>
<td width="11%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปริญญาโท</td>
<td width="15%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">ปริญญาเอก</td>
<td width="10%" align="center" bgcolor="#FF9999" class="PADDING-LEFT-5">จำนวน</td>
</tr>
<?php
$sql = " SELECT * FROM teacher_type_tb Where Flag ='Y' " ;
$result8 = $dbObj->execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss4 = $dbObj->fetchArray($result8) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?=$rss4['Ttype_name'];?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="DegreeTeacherType1.php?Teacher_type=<?=$rss4['Ttype_code']; ?>&Degree_code=1">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Teacher_type='$rss4[Ttype_code]' and Degree_code='1' ";
$result21 = $dbObj->execQuery($sql);
$rs21 = $dbObj->fetchArray($result21);
echo $rs21['num'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="DegreeTeacherType2.php?Teacher_type=<?=$rss4['Ttype_code']; ?>&Degree_code=2">
<?php
$sql = " SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Teacher_type='$rss4[Ttype_code]' and Degree_code='2' ";
$result22 = $dbObj->execQuery($sql);
$rs22 = $dbObj->fetchArray($result22);
echo $rs22['num'];
?>
</a><a href="PersonalDataEdu.php?StatusId=3&Teacher_type=<?=$rss4['Ttype_code'];?>"></a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="DegreeTeacherType3.php?Teacher_type=<?=$rss4['Ttype_code']; ?>&Degree_code=3">
<?php
$sql = "SELECT COUNT(Teacher_type) AS num FROM personal_tb WHERE StatusId='1' and Teacher_type='$rss4[Ttype_code]' and Degree_code='3' ";
$result23 = $dbObj->execQuery($sql);
$rs23 = $dbObj->fetchArray($result23);
echo $rs23['num'];
?>
</a><a href="PersonalDataEdu.php?StatusId=2&Teacher_type=<?=$rss4['Ttype_code'];?>"></a></td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$sum = $rs21['num']+ $rs22['num']+ $rs23['num']; ;
echo $sum ;
?></td>
<?php
$no++ ;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFCCFF"> </td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5">สรุป</td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='1' and pt.Degree_code='1' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
echo $rs1['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='1' and pt.Degree_code='2' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
echo $rs2['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sql = " SELECT COUNT(Teacher_code) AS num5 FROM personal_tb pt, teacher_type_tb tt WHERE pt.Teacher_type=tt.Ttype_code and tt.Flag='Y' and pt.StatusId='1' and pt.Degree_code='3' ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
echo $rs3['num5'];
?></td>
<td align="center" bgcolor="#FFCCFF" class="PADDING-LEFT-5"><?php
$sum = $rs1['num5']+ $rs2['num5']+ $rs3['num5']; ;
echo $sum ;
?></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td>๔.๑๑. <a href="personalStatus.php?Year_std=<?=$Budget_Year ;?>">แสดงรายละเอียดกิจกรรมของบุคลากรในวันที่ <strong>
<?php
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
$m = getThaiSubMonth($month);
echo abbreDate(date("d-m-Y"));
?>
</strong></a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td><table width="100%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="#F0F0F0">
<td height="25" colspan="2" align="left" bordercolor="#999966" bgcolor="#FF9999" class="PADDING-LEFT-10"><font color="#000000"> <span class="style22"> รายชื่อผู้ไปราชการ </a><strong>วันที่ </a>
<?php
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
$m = getThaiSubMonth($month);
echo abbreDate(date("d-m-Y"));
?>
</strong></a></span></font></td>
</tr>
<?php
$query1 = " SELECT * FROM formaoffice WHERE ' ".(date("Y")+543)."-".date("m")."-".date("d")." ' BETWEEN Date_start and Date_finish ";
$result1 = $dbObj->execQuery($query1);
$numrows = $dbObj->_numrows;
$Budget_year = $rs->Budget_year;
?>
<?php
$no = 1+($display-1)*$limit;
while( $rs2 = $dbObj->fetchArray($result1) ) {
$Budget_year = $rs2['Budget_year'];
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" align="left" class="BORDER PADDING-LEFT-5"><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" />
<?php
$Teacher_code= $rs2['Teacher_code'] ;
$sql11 = " Select prefixName,Teacher_name,Teacher_lastname From personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId Where Teacher_code='$Teacher_code' ";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[prefixName] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</a></td>
<td width="68%" align="left" class="PADDING-LEFT-5"><?php if( $rs2['Training_name'] != "" ) echo $rs2['Training_name']; else echo " "; ?>
</a><a href="#"></font></a></td>
</tr>
<?php
//$no++;
} # while
?>
<tr>
<td height="22" colspan="2" align="center" bgcolor="#F8F8F8"><strong>ทั้งหมด <span class="NOTE"><?php echo $numrows; ?></span> คน</strong></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="18" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๕. ปัจจัยเกื้อหนุนอาคารสถานที่</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๑. <a href="BuildingList.php?Build_type=1 ">อาคารเรียนและห้องเรียนเอื้อต่อการเรียนการสอนทุกรูปแบบที่กำหนด ไว้ในหลักสูตร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๒. <a href="BuildingList.php?Build_type=1">ห้องทำงานเหมาะสมและเอื้อต่อการทำงานของอาจารย์และบุคลากร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๓. <a href="BuildingList.php?Build_type=6">สถานที่ทำกิจกรรมเสริมหลักสูตรนันทนาการและการกีฬาเหมาะสมเอื้อ ต่อการพัฒนานักศึกษา</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๔. <a href="BuildingList.php?Build_type=4">สถานที่พักนักศึกษาปลอดภัยถูก สุขลักษณะ เอื้อต่อการเรียนและการ ทำกิจกรรมนอกเวลา</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๕. ห้องปฏิบัติการพยาบาลเหมาะสมและมีอุปกรณ์เพียงพอในทุกสาขาการพยาบาล และพร้อมใช้</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๖. ห้องปฏิบัติการวิทยาศาสตร์ / วิทยาศาสตร์สุขภาพเหมาะสมและมีอุปกรณ์จำนวน เพียงพอและพร้อมใช้</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๗. ห้องปฏิบัติการคอมพิวเตอร์</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๘. จำนวนคอมพิวเตอร์สำหรับนักศึกษาไม่น้อยกว่า 1 : 10 และพร้อมใช้</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2" align="center" bgcolor="#FFCC99">รายการ</td>
<? $query = " SELECT * FROM personal_tb WHERE StatusId='1' AND Teacher_type='5' ";
$result = $dbObj->execQuery($query);
$total = $dbObj->_numrows;
?>
<td width="21%" align="center" bgcolor="#FFCC99">ห้องปฏิบัติการคอมพิวเตอร์</td>
<td width="24%" align="center" bgcolor="#FFCC99">เครื่องคอมพิวเตอร์โน๊ตบุค</td>
<td width="7%" align="center" bgcolor="#FFCC99">จำนวน</td>
</tr>
<tr>
<td width="3%" height="20" align="center"><img src="../images/icons/arrow2.gif" width="12" height="12" /></td>
<td width="45%" height="20">จำนวนเครื่องคอมพิวเตอร์</a></td>
<td height="20" align="center"><a href="AccTypeName.php?Acc_type_code=2">
<?php
$sql = " SELECT COUNT(Acc_name ) AS num3 FROM accessories_tb WHERE Acc_type_code='2' ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs3['num3'];
?>
</a></td>
<td height="20" align="center"><a href="ComStudentList.php">
<?php
$sql = " SELECT COUNT(notebookName) AS num4 FROM stu_notebook ";
$result4 = $dbObj->execQuery($sql);
$rs4 = $dbObj->fetchArray($result4);
$dbObj->freeresult($result7);
echo $rs4['num4'];
?>
</a></td>
<td align="center"><?php
$sum = $rs3['num3']+ $rs4['num4']; ;
echo $sum ;
?></td>
</tr>
<tr>
<td height="20" align="center"> </td>
<td height="20" align="center">ร้อยละ</td>
<td height="20" align="center"><?php
$total = 0 ;
$per3= ( $rs3['num3'] * 100 ) / $total;
echo number_format($per3,2,'.','.');
?></td>
<td height="20" align="center"><?php
$per4 = ( $rs4['num4'] * 100 ) / $total;
echo number_format($per4,2,'.','.');
?></td>
<td align="center"><?php
$per7 = $per3 + $per4 ;
//$per7 = ( $rs4['num7'] * 100 ) / $total;
echo number_format($per7,2,'.','.');
?></td>
</tr>
</table> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๙. จำนวนโสตทัศนูปกรณ์เหมาะสมและมีจำนวน เพียงพอและพร้อมใช้</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2" align="center" bgcolor="#FFCC66">รายการ</td>
<? $query = " SELECT * FROM personal_tb WHERE StatusId='1' AND Teacher_type='5' ";
$result = $dbObj->execQuery($query);
$total = $dbObj->_numrows;
?>
<td width="21%" align="center" bgcolor="#FFCC66">ห้องบรรยาย</td>
<td width="24%" align="center" bgcolor="#FFCC66">ห้องประชุม</td>
<td width="7%" align="center" bgcolor="#FFCC66">จำนวน</td>
</tr>
<tr>
<td width="3%" height="20" align="center"><img src="../images/icons/arrow2.gif" width="12" height="12" /></td>
<td width="45%" height="20">จำนวนอุปกรณ์โสต</a>ทัศนูปกรณ์</td>
<td height="20" align="center"><a href="#?Degree_code=1&Teacher_type=5">
<?php
$sql = " SELECT COUNT(Acc_name ) AS num5 FROM accessories_tb WHERE Acc_type_code='16' ";
$result3 = $dbObj->execQuery($sql);
$rs5 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result7);
echo $rs5['num5'];
?>
</a></td>
<td height="20" align="center"><a href="#?Degree_code=2&Teacher_type=5">
<?php
$sql = " SELECT COUNT(Acc_name ) AS num6 FROM accessories_tb WHERE Acc_type_code='16' ";
$result4 = $dbObj->execQuery($sql);
$rs6 = $dbObj->fetchArray($result4);
$dbObj->freeresult($result6);
echo $rs6['num6'];
?>
</a></td>
<td align="center"><?php
$sum = $rs5['num5']+ $rs6['num6']; ;
echo $sum ;
?></td>
</tr>
<tr>
<td height="20" align="center"> </td>
<td height="20" align="center">ร้อยละ</td>
<td height="20" align="center"><?php
$total = 450 ;
$per5= ( $rs5['num5'] * 100 ) / $total;
echo number_format($per5,2,'.','.');
?></td>
<td height="20" align="center"><?php
$per6 = ( $rs6['num6'] * 100 ) / $total;
echo number_format($per6,2,'.','.');
?></td>
<td align="center"><?php
$per7 = $per3 + $per4 ;
//$per7 = ( $rs4['num7'] * 100 ) / $total;
echo number_format($per7,2,'.','.');
?></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๖. ห้องสมุด</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๑. ตำราหลักทางการพยาบาลที่ทันสมัยไม่ต่ำกว่าสาขาวิชาละ 10 ชื่อเรื่อง</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๒. จำนวนตำรา/หนังสือทางการพยาบาล และวิทยาศาสตร์สุขภาพ ในอัตราส่วนนักศึกษา : จำนวนหนังสือ = 1 : 50 </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๓. จำนวนวารสารวิชาชีพการพยาบาลในประเทศไม่น้อยกว่า 10 ชื่อเรียน </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๔. จำนวนวารสารวิชาชีพการพยาบาลต่างประเทศไม่น้อยกว่า 10 ชื่อเรื่อง</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๕. ระบบและเทคโนโลยีการสืบค้นข้อมูลทางวิชาการทั้งภายในและภายนอกประเทศ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๗. เวลาให้บริการไม่น้อยกว่า 60 ชั่วโมง สัปดาห์ </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๗. การวิจัยและผลงาน ทางวิชาการ </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td align="left">๗.๑. มีการผลิตและเผยแพร่ตำรา / หนังสือ / คู่มือ / สื่อ / บทความทางวิชาการ /สิ่งประดิษฐ์ทางวิชาการ เท่ากับ/มากกว่า10% ของจำนวนอาจารย์ทั้งหมด(เฉลี่ยย้อนหลัง 3 ปี)</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td><table width="97%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FF9966">No</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">รายการ ปี พ.ศ</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">2551</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">2552</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">2553</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">2554</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">2555</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">2556</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">จำนวน<br />เรื่อง</td>
<td align="center" bgcolor="#FF9966" class="PADDING-LEFT-5">ร้อยละ</td>
</tr>
<?php
$sql = " SELECT * FROM researchtype_tb " ;
$result = $dbObj->execQuery($sql);
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="3%" height="22" align="center" bgcolor="#FFFFFF"><?=$no;?></td>
<td width="45%" align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="AllResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>" title=" Click to more detail "><?php echo "$rss[ReTyname]"; ?>
</a></td>
<td width="7%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="YearResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>&Year_prop=2551" title=" Click to more detail ">
<?php
$sql = " SELECT COUNT(Research_name ) AS num FROM research_tb rt, research_public_tb rb WHERE rt.Year_prop='2551' and rt.Research_code = rb.Research_code and rb.ReTyId='$rss[ReTyId]' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
$dbObj->freeresult($result1);
echo $rs1['num'];
?>
</a></td>
<td width="6%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="YearResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>&Year_prop=2552" title=" Click to more detail ">
<?php
$sql = " SELECT COUNT(Research_name ) AS num FROM research_tb rt, research_public_tb rb WHERE rt.Year_prop='2552' and rt.Research_code = rb.Research_code and rb.ReTyId='$rss[ReTyId]' ";
$result2 = $dbObj->execQuery($sql);
$rs2 = $dbObj->fetchArray($result2);
$dbObj->freeresult($result2);
echo $rs2['num'];
?>
</a></td>
<td width="6%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="YearResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>&Year_prop=2553" title=" Click to more detail ">
<?php
$sql = " SELECT COUNT(Research_name ) AS num FROM research_tb rt, research_public_tb rb WHERE rt.Year_prop='2553' and rt.Research_code = rb.Research_code and rb.ReTyId='$rss[ReTyId]' ";
$result3 = $dbObj->execQuery($sql);
$rs3 = $dbObj->fetchArray($result3);
$dbObj->freeresult($result3);
echo $rs3['num'];
?>
</a></td>
<td width="6%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="YearResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>&Year_prop=2554" title=" Click to more detail ">
<?php
$sql = " SELECT COUNT(Research_name ) AS num FROM research_tb rt, research_public_tb rb WHERE rt.Year_prop='2554' and rt.Research_code = rb.Research_code and rb.ReTyId='$rss[ReTyId]' ";
$result4 = $dbObj->execQuery($sql);
$rs4 = $dbObj->fetchArray($result4);
$dbObj->freeresult($result4);
echo $rs4['num'];
?>
</a></td>
<td width="6%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="YearResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>&Year_prop=2555" title=" Click to more detail ">
<?php
$sql = " SELECT COUNT(Research_name ) AS num FROM research_tb rt, research_public_tb rb WHERE rt.Year_prop='2555' and rt.Research_code = rb.Research_code and rb.ReTyId='$rss[ReTyId]' ";
$result5 = $dbObj->execQuery($sql);
$rs5 = $dbObj->fetchArray($result5);
$dbObj->freeresult($result5);
echo $rs5['num'];
?>
</a></td>
<td width="6%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><a href="YearResearchType.php?ReTyId=<? echo $rss['ReTyId'];?>&Year_prop=2556" title=" Click to more detail ">
<?php
$sql = " SELECT COUNT(Research_name ) AS num FROM research_tb rt, research_public_tb rb WHERE rt.Year_prop='2556' and rt.Research_code = rb.Research_code and rb.ReTyId='$rss[ReTyId]' ";
$result6 = $dbObj->execQuery($sql);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($result6);
echo $rs6['num'];
?>
</a></td>
<td width="8%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
$countnum = $rs1['num'] + $rs2['num'] + $rs3['num'] + $rs4['num'] + $rs5['num'] +$rs6['num'] ;
echo $countnum;
?></td>
<td width="7%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<?php
$no++;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๗.๒. <a href="PublicResearch.php">จำนวนผลงานวิชาการที่ได้รับการรับรองคุณภาพ </a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๗.๓. <a href="Menu_resport.php">ข้อมูลรายงานฐานวิจัย</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left">๘. การบริการวิชาการแก่สังคม</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๑. มีนโยบาย วัตถุประสงค์และแผนงานการบริการวิชาการแก่สังคมเป็นลายลักษณ์ อักษร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๒. มีหน่วยงาน / กรรมการ / ผู้รับผิดชอบงานบริการวิชาการแก่สังคมระดับสถาบัน</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๓. มีผู้รับผิดชอบแผนงาน / โครงการ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๔. มีกิจกรรมบริการวิชาการแก่สังคมที่เกี่ยวข้องกับวิชาชีพทั้งภายในและภายนอกสถาบัน (ย้อนหลัง 3 ปี)</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td><table width="711" border="1" cellpadding="1" cellspacing="0">
<tr>
<td align="center" bgcolor="#FFCC99">รายการ</td>
<td align="center" bgcolor="#FFCC99">2553</td>
<td align="center" bgcolor="#FFCC99">2554</td>
<td align="center" bgcolor="#FFCC99">2555</td>
<td align="center" bgcolor="#FFCC99">2556</td>
</tr>
<tr>
<td>๘.๔.๑. <a href="MIO101.php?M21=1">จำนวนโครงการที่บูรณาการกับการเรียนการสอน</a></td>
<td align="center">
<?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๔.๒. <a href="MIO102.php?M22=1">จำนวนโครงการที่บูรณาการการกับงานวิจัย/บทความ</a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๔.๓. <a href="MIO103.php?M23=1">จำนวนโครงการที่บูรณาการการกิจการนักศึกษา</a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๔.๔. <a href="MIO104.php?M24=1">จำนวนโครงการที่พัฒนาบุคลากรด้านสุขภาพ</a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๔.๕. โครงการที่แยกตามกลุ่มเป้าหมาย</a></td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td>- ประชาชนทั่วไป</td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>- นักเรียน/นักศึกษา</td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>- พยาบาลวิชาชีพ </td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>- อาจารย์พี่เลี้ยง</td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>- อื่นๆ ระบ</td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td width="393"> </td>
<td width="79"> </td>
<td width="78"> </td>
<td width="62"> </td>
<td width="77"> </td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๕. มีการประเมินแผนงาน / โครงการ / กิจกรรมบริการวิชาการแก่สังคม </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td><table width="712" border="1" cellpadding="1" cellspacing="0">
<tr>
<td align="center" bgcolor="#FFCC66"> รายการประเมิน</td>
<td align="center" bgcolor="#FFCC66">2553</td>
<td align="center" bgcolor="#FFCC66">2554</td>
<td align="center" bgcolor="#FFCC66">2555</td>
<td align="center" bgcolor="#FFCC66">2556</td>
</tr>
<tr>
<td width="398">๘.๕.๑. <a href="MIO03.php?M101=1">การบรรลุเป้าหมายครบทุกข้อ</a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M101='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M101='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M101='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M101='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๕.๒. <a href="MIO02.php?M102=1">คะแนนเฉลี่ยความพึงพอใจของผู้รับบริการมากกว่า ๓.๕๑ ขึ้นไป</a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='1' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๕.๓. <a href="MIO02.php?M102=2">คะแนนเฉลี่ยความพึงพอใจของผู้รับบริการเท่ากับ ๓.๕๑ </a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='2' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='2' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='2' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='2' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๕.๔. <a href="MIO02.php?M102=3">คะแนนเฉลี่ยความพึงพอใจของผู้รับบริการน้อยกว่า ๓.๕๑ </a></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='3' and Budget_Year='25553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='3' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='3' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M102='3' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?> <?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
</tr>
<tr>
<td>๘.๕.๕. การสร้างรายรับให้กับสถาบัน </a> จำนวนเงิน
<?php
$sql1 = " SELECT SUM(Budget_colleg) AS SumB1 FROM edu_service_tb WHERE M105='Y' ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
echo number_format($rss1['SumB1'],2,'.',',');
?>
</a></td>
<td align="right"><?php
$sql1 = " SELECT SUM(Budget_colleg) AS SumB1 FROM edu_service_tb WHERE M105='Y' and Budget_Year='2553' ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
echo number_format($rss1['SumB1'],2,'.',',');
?></td>
<td align="right"><?php
$sql1 = " SELECT SUM(Budget_colleg) AS SumB1 FROM edu_service_tb WHERE M105='Y' and Budget_Year='2554' ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
echo number_format($rss1['SumB1'],2,'.',',');
?></td>
<td align="right"><?php
$sql1 = " SELECT SUM(Budget_colleg) AS SumB1 FROM edu_service_tb WHERE M105='Y' and Budget_Year='2555' ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
echo number_format($rss1['SumB1'],2,'.',',');
?></td>
<td align="right"><?php
$sql1 = " SELECT SUM(Budget_colleg) AS SumB1 FROM edu_service_tb WHERE M105='Y' and Budget_Year='2556' ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
echo number_format($rss1['SumB1'],2,'.',',');
?></td>
</tr>
<tr>
<td> </td>
<td width="76"> </td>
<td width="75"> </td>
<td width="69"> </td>
<td width="72"> </td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2">๙. การทำนุบำรุงศิลปะและวัฒนธรรมของชาติ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๙.๑. มีนโยบาย วัตถุประสงค์และแผนงานการบำรุงศิลปะและวัฒนธรรมเป็น ลายลักษณ์อักษร</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๙.๒. มีผู้รับผิดชอบงานทำนุบำรุงศิลปะและ วัฒนธรรมระดับสถาบัน </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๙.๓. มีโครงการ / กิจกรรมทำนุบำรุงศิลปะและวัฒนธรรม(ย้อนหลัง 3 ปี)</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๙.๔. มีการประเมินผล แผนงาน / โครงการ / กิจกรรมทำนุ บำรุงศิลปะและวัฒนธรรม</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</fieldset></td>
</tr>
</table>
<?php include("../templates/incFooter.php"); ?>
</body>
</html>
<?php
/** Free Resource */
$dbObj->freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|