Viewing file: MIS102-1.php (112.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>
</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="20" colspan="2" align="left" background="../images/background/bg-head-topic-w780.gif">๑.ปรัชญา/ปณิธาน วิสัยทัศน์ พันธกิจ นโยบาย วัตถุประสงค์และแผนการดำเนินงาน <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Mission" id="Mission" />
</a></td>
</tr>
<tr>
<td width="4%" align="center"> </td>
<td width="3%" height="20" align="center"> </td>
<td>๑.๑. <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">แผนยุทศาสตร์และแผนกลยุทธ์
</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๑.๒. <a href="missionByYear.php?Budget_Year=<?=$Budget_Year ;?>">แผนปฏิบัติงานประจำปีของสถาบันการศึกษา </a></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></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" background="../images/background/bg-head-topic-w780.gif">๒.การจัดการเรียนการสอน <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Teach" id="Teach" />
</a></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></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" background="../images/background/bg-head-topic-w780.gif">๓.ข้อมูลนักศึกษา <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Student" id="Student" />
</a></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> </td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left" background="../images/background/bg-head-topic-w780.gif">๔ . ข้อมูลบุคลากร <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Personal" id="Personal" />
</a></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">อาจารย์ประจำที่วุฒิการศึกษาสูงสุด</td>
<? $query = " SELECT * FROM personal_tb WHERE StatusId='1' AND Teacher_type='5' ";
$result = $dbObj->execQuery($query);
$total = $dbObj->_numrows;
?>
<td align="center">จำนวน</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' 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">๔.๓.๒.อาจารย์ที่มีประสบการณ์การสอนภาคทฤษฎี /ภาคปฏิบัติในสาขาการพยาบาลไม่น้อยกว่า 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>๔.๔. ร้อยละของจำนวนอาจารย์ประจำที่มีวุฒิการศึกษา ระดับปริญญาเอก, ระดับปริญญาโทหรือสูงกว่า,ระดับปริญญาตรี</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">รายการ</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">ปริญญาตรี</td>
<td width="12%" align="center">ปริญญาโท</td>
<td width="11%" align="center">ปริญญาเอก</td>
<td width="9%" align="center">จำนวน</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></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></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></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>๔.๗. จำนวนประเภทบุคลากรที่่ปฏิบัติงานและลาศึกษาต่อ</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="#FFFFFF">No</td>
<td width="48%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปฏิบัติงาน</td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ลาศึกษา</td>
<td width="15%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ไปช่วยราชการ</td>
<td width="10%" align="center" bgcolor="#FFFFFF" 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"><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="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"></a></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="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="#FFFFFF"> </td>
<td width="48%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปฏิบัติงาน</td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ลาศึกษา</td>
<td width="15%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ไปช่วยราชการ</td>
<td width="10%" align="center" bgcolor="#FFFFFF" 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>
</tr>
<?php
$no++ ;
} # while
?>
</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="#FFFFFF">No</td>
<td width="48%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปริญญาตรี</td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปริญญาโท</td>
<td width="15%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปริญญาเอก</td>
<td width="10%" align="center" bgcolor="#FFFFFF" 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="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5"></a></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="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="#FFFFFF"> </td>
<td width="48%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">รายการ </td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปริญญาตรี</td>
<td width="11%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปริญญาโท</td>
<td width="15%" align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ปริญญาเอก</td>
<td width="10%" align="center" bgcolor="#FFFFFF" 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>
</tr>
<?php
$no++ ;
} # while
?>
</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="#FFFFFF" 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="8" align="center"> </td>
<td>๔.๑๒ <a href="http://reg.knc.ac.th/showTimeTableT.php" target="new">ค้นหาข้อมูลตารางสอนอาจารย์</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="4" align="center"> </td>
<td>๔.๑๓ <a href="SearchFormAbsentList.php">ค้นหาประวัติการลาบุคลากร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="4" align="center"> </td>
<td>๔.๑๔ <a href="SearchTraningAList.php">ค้นหาประวัติการขอไปราชการ</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" colspan="2" align="left" background="../images/background/bg-head-topic-w780.gif" >๕. ปัจจัยเกื้อหนุนอาคารสถานที่ <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Factor" id="Factor" />
</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๑. <a href="BuildingList.php?Build_type=1&Flag=1">อาคารเรียนและห้องเรียนเอื้อต่อการเรียนการสอนทุกรูปแบบที่กำหนด ไว้ในหลักสูตร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๒. <a href="BuildingList.php?Build_type=1&Flag=5">ห้องทำงานเหมาะสมและเอื้อต่อการทำงานของอาจารย์และบุคลากร</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>๕.๕. <a href="BuildingList.php?Build_type=1&Flag=2">ห้องปฏิบัติการพยาบาลเหมาะสมและมีอุปกรณ์เพียงพอในทุกสาขาการพยาบาล และพร้อมใช้</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๖. <a href="BuildingList.php?Build_type=1&Flag=3">ห้องปฏิบัติการวิทยาศาสตร์ / วิทยาศาสตร์สุขภาพเหมาะสมและมีอุปกรณ์จำนวน เพียงพอและพร้อมใช้</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๕.๗. <a href="BuildingList.php?Build_type=1&Flag=4">ห้องปฏิบัติการคอมพิวเตอร์</a></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">รายการ</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">ห้องปฏิบัติการคอมพิวเตอร์</td>
<td width="24%" align="center">เครื่องคอมพิวเตอร์โน๊ตบุค</td>
<td width="7%" align="center">จำนวน</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=17">
<?php
$sql = " SELECT COUNT(Acc_name ) AS num3 FROM accessories_tb WHERE Acc_type_code='17' ";
$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" colspan="3" align="center">จำนวนนักศึกษา 1 คน ต่อ
<?php
$per7 = 619/$sum ;
//$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">รายการ</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">ห้องบรรยาย</td>
<td width="24%" align="center">ห้องประชุม</td>
<td width="7%" align="center">จำนวน</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" background="../images/background/bg-head-topic-w780.gif" >๖. ห้องสมุด <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Library" id="Library" />
</a></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>๖.๓. จำนวนวารสารวิชาชีพการพยาบาลในประเทศ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="4" align="center"> </td>
<td>๖.๔. จำนวนวารสารวิชาชีพการพยาบาลต่างประเทศ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="10" align="center"> </td>
<td>๖.๕. จำนวนวารสารวิชาชีพการพยาบาลรวมแต่ละปี</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๖.๖ ระบบและเทคโนโลยีการสืบค้นข้อมูลทางวิชาการทั้งภายในและภายนอกประเทศ</td>
</tr>
<tr>
<td rowspan="3" align="center"> </td>
<td height="20" rowspan="3" align="center"> </td>
<td>๖.๗. <a href="http://libraryknc.knc.ac.th/modules.php?name=Content&pa=showpage&pid=4" target="new">เวลาให้บริการไม่น้อยกว่า 60 ชั่วโมง สัปดาห์ </a></td>
</tr>
<tr>
<td>๖.๘. <a href="http://libraryknc.knc.ac.th/modules.php?name=Content&pa=showpage&pid=11" target="new">ห้องสมุด มีหน้าที่จัดหา จัดเก็บ รวบรวมทรัพยากรสารสนเทศประเภทต่างๆ มุ่งเน้นให้ผู้ใช้สามารถศึกษาค้นคว้าด้วยตนเอง<br />
ได้อย่างสะดวกและตรงตามความต้องการ โดยมีบุคลากรปฏิบัติหน้าที่ 3 คน</a></td>
</tr>
<tr>
<td>๖.๙ <a href="http://libraryknc.knc.ac.th/modules.php?name=Content&pa=showpage&pid=2" target="new">บริการของห้องสมุด</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" background="../images/background/bg-head-topic-w780.gif">๗. การวิจัยและผลงานทางวิชาการ <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Research" id="Research" />
</a></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="#FFFFFF">No</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">รายการ ปีปฏิทิน</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">2551</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">2552</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">2553</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">2554</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">2555</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">2556</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">จำนวน<br />เรื่อง</td>
<td align="center" bgcolor="#FFFFFF" 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="ResearchPublic.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" background="../images/background/bg-head-topic-w780.gif">๘. การบริการวิชาการแก่สังคม <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Academic_Services" id="Academic_Services" />
</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๑. <a href="http://webbor.knc.ac.th/pdf55/m2.pdf" target="new">มีนโยบาย วัตถุประสงค์และแผนงานการบริการวิชาการแก่สังคมเป็นลายลักษณ์ อักษร</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๒. <a href="http://webbor.knc.ac.th/staff.html" target="new">มีหน่วยงาน / กรรมการ / ผู้รับผิดชอบงานบริการวิชาการแก่สังคมระดับสถาบัน</a></td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๓. มีผู้รับผิดชอบแผนงาน / โครงการ [<a href="http://webbor.knc.ac.th/pdf/plan51.pdf" target="new">แผนปี 2551</a>] [<a href="http://webbor.knc.ac.th/pdf/plan52.pdf" target="new">แผนปี 2552</a>] [<a href="http://webbor.knc.ac.th/pdf55/m10.pdf" target="new">แผนปี 2553</a>] [<a href="http://webbor.knc.ac.th/pdf55/m11.pdf" target="new">แผนการบูรณาการปี 2553-2554</a>]</td>
</tr>
<tr>
<td align="center"> </td>
<td height="20" align="center"> </td>
<td>๘.๔. มีกิจกรรมบริการวิชาการแก่สังคมที่เกี่ยวข้องกับวิชาชีพทั้งภายในและภายนอกสถาบัน (ย้อนหลัง 3 ปี)</td>
</tr>
<tr>
<td height="20" colspan="3" align="center"><table width="745" border="1" cellpadding="1" cellspacing="0">
<tr>
<td width="361" rowspan="2" align="center">รายการ</td>
<td colspan="2" align="center">ปกศ. 2553</td>
<td colspan="2" align="center">ปกศ. 2554</td>
<td colspan="2" align="center">ปกศ. 2555</td>
<td colspan="2" align="center">ปกศ. 2556</td>
<td colspan="2" rowspan="2" align="center">รวม</td>
</tr>
<tr>
<td width="35" align="center">จำนวน</td>
<td width="23" align="center">%</td>
<td width="35" align="center">จำนวน</td>
<td width="32" align="center">%</td>
<td width="35" align="center">จำนวน</td>
<td width="32" align="center">%</td>
<td width="35" align="center">จำนวน</td>
<td width="32" align="center">%</td>
</tr>
<tr>
<td bgcolor="#FFFFCC">๘.๔.๑. <a href="MIO10101.php">รวมโครงการทั้งหมด</a></td>
<td align="center" bgcolor="#FFFFCC"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE AcademicYear >='2553' and AcademicYear <='2556' " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
$total2553=$countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53All.php'><font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percentA=100;
echo "<font color=red>".number_format( $percentA,2 )?></td>
<td align="center" bgcolor="#FFFFCC"><?
$sql = " SELECT * FROM edu_service_tb WHERE AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
$total2554=$countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_54All.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percentA=100;
echo "<font color=red>".number_format( $percentA,2 )?></td>
<td align="center" bgcolor="#FFFFCC"><?
$sql = " SELECT * FROM edu_service_tb WHERE AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
$total2555=$countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percentA=100;
echo "<font color=red>".number_format( $percentA,2 )?></td>
<td align="center" bgcolor="#FFFFCC"><?
$sql = " SELECT * FROM edu_service_tb WHERE AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
$total2556=$countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"> </td>
<td align="center" bgcolor="#FFFFCC"><?
echo "<font color=red>".number_format( $numall )
?></td>
<td align="center" bgcolor="#FFFFCC"><a href="Sumary_project.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></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 (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M21.php'><font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_54M21.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' and AcademicYear ='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>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td width="37" align="center"><?
echo "<font color=red>".number_format( $numall )
?></td>
<td width="30" align="center"><a href="Integrated_learning.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></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 (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall1 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M22.php'><font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_54M22.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M22='1' and AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $numall1)
?></td>
<td align="center"><a href="Integrated_research.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๘.๔.๔. <a href="MIO10201.php">โครงการที่บูรณาการทั้งการเรียนการสอนและงานวิจัย</a></td>
<td align="center">
<?
//
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' AND M22='1' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall0 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' AND M22='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M2122.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' AND M22='1' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_54M2122.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' AND M22='1' and AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M21='1' AND M22='1' and AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum2 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $numall0)
?></td>
<td align="center"><a href="Integrated_learning_research.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></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 (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall2 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum3 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M23.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum3 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_54M23.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum3 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M23='1' and AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum3 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $numall2 )
?></td>
<td align="center"><a href="Integrated_student_affairs.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></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 (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall3 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M24.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M24='1' and AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $numall3 )
?></td>
<td align="center"><a href="Integrated_develop.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="left">๘.๔.๗. <a href="MIO10401.php">โครงการอื่น ๆ</a></td>
<td align="center"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M25='1' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall3 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M25='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M25.php'><font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M25='1' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M25='1' and AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M25='1' and AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $numall3 )
?></td>
<td align="center"><a href="Integrated_Other.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="5" colspan="11" align="left" bgcolor="#FFFFCC"></td>
</tr>
<tr>
<td>๘.๔.๘. <a href="MIO10402.php">โครงการสร้างความเข้มแข็งของชุมชน/องค์กรภายนอก</a></td>
<td align="center" bgcolor="#FFFFFF"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M4='Y' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall3 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M4='Y' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M4.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFFF"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center" bgcolor="#FFFFFF"><?
$sql = " SELECT * FROM edu_service_tb WHERE M4='Y' and AcademicYear ='2554' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFFF"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center" bgcolor="#FFFFFF"><?
$sql = " SELECT * FROM edu_service_tb WHERE M4='Y' and AcademicYear ='2555' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFFF"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center" bgcolor="#FFFFFF"><?
$sql = " SELECT * FROM edu_service_tb WHERE M4='Y' and AcademicYear ='2556' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum4 += $countnum;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFFF"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center" bgcolor="#FFFFFF"><?
echo "<font color=red>".number_format( $numall3 )
?></td>
<td align="center" bgcolor="#FFFFFF"><a href="Integrated_Other.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td height="5" colspan="11" bgcolor="#FFFFCC"></td>
</tr>
<tr>
<td>๘.๔.๙. โครงการที่แยกตามกลุ่มเป้าหมายประชาชนทั่วไป</td>
<td align="center"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$allnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M3.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and AcademicYear='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"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='1' and AcademicYear ='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>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $allnum)
?></td>
<td align="center"><a href="Target_public.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
<td width="8" align="center"> </td>
</tr>
<tr>
<td>๘.๔.๑๐. โครงการที่แยกตามกลุ่มเป้าหมาย</a>นักเรียน/นักศึกษา</td>
<td align="center"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$allnum1 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M32.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='2' and AcademicYear ='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>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $allnum1 )
?></td>
<td align="center"><a href="Target_student.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๘.๔.๑๑. โครงการที่แยกตามกลุ่มเป้าหมาย</a> พยาบาลวิชาชีพ </td>
<td align="center"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$allnum2 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M33.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='3' and AcademicYear ='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>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $allnum2 )
?></td>
<td align="center"><a href="Target_nursing.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๘.๔.๑๒. โครงการที่แยกตามกลุ่มเป้าหมาย</a> อาจารย์พี่เลี้ยง</td>
<td align="center"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$allnum3 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M34.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='4' and AcademicYear ='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>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $allnum3 )
?></td>
<td align="center"><a href="Target_teacher.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๘.๔.๑๓. โครงการที่แยกตามกลุ่มเป้าหมาย</a> อื่นๆ ระบุ</td>
<td align="center"><?
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and (AcademicYear >='2553' and AcademicYear <='2556') " ;
$result3 = $dbObj->execQuery($sql);
$allnum4 = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and AcademicYear ='2553' " ;
$result3 = $dbObj->execQuery($sql);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result3);
$sum += $countnum;
?>
<?php if( $countnum != "0" ) echo "<a href='Report_53M35.php'<font color=blue>".number_format( $countnum )."</font></a>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*$percentA)/$total2553;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2554;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and AcademicYear ='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"><?
$percent=($countnum*$percentA)/$total2555;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
$sql = " SELECT * FROM edu_service_tb WHERE M3='5' and AcademicYear ='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>
<td align="center"><?
$percent=($countnum*$percentA)/$total2556;
echo "<font color=red>".number_format( $percent,2 )?></td>
<td align="center"><?
echo "<font color=red>".number_format( $allnum4 )
?></td>
<td align="center"><a href="Target_other.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td colspan="11" align="right" bgcolor="#FFFFCC"> </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"> รายการประเมิน</td>
<td align="center">ปกศ. 2553</td>
<td align="center">ปกศ. 2554</td>
<td align="center">ปกศ. 2555</td>
<td align="center">ปกศ. 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 AcademicYear ='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 AcademicYear ='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 AcademicYear ='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 AcademicYear ='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 M101='2' and AcademicYear ='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='2' and AcademicYear ='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='2' and AcademicYear ='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=2">คะแนนเฉลี่ยความพึงพอใจของผู้รับบริการเท่ากับ ๓.๕๑ </a></td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </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"> </td>
<td align="center"> </td>
<td align="center"> </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 AcademicYear ='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 AcademicYear ='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 AcademicYear ='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 AcademicYear ='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" background="../images/background/bg-head-topic-w780.gif" >๙. การทำนุบำรุงศิลปะและวัฒนธรรมของชาติ <a href="missionStrate.php?Budget_Year=<?=$Budget_Year ;?>">
<input type="hidden" name="Minister" id="Minister" />
</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>๙.๓. มีโครงการ / กิจกรรมทำนุบำรุงศิลปะและวัฒนธรรม(ย้อนหลัง 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);
?>
|