Viewing file: MIS104-db.php (135.62 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">๑.ปรัชญา/ปณิธาน วิสัยทัศน์ พันธกิจ นโยบาย วัตถุประสงค์และแผนการดำเนินงาน</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">๒.การจัดการเรียนการสอน</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> </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">อาจารย์ประจำที่วุฒิการศึกษาสูงสุด</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">จำนวน</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' AND Teacher_type='5' and Degree_code='2' 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="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 width="3%" height="20" align="center"><img src="../images/icons/arrow2.gif" width="12" height="12" /></td>
<td width="44%" 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' AND Teacher_type='5' and Degree_code='1' ";
$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' 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' 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 height="20" align="center"> </td>
<td height="20" align="center">ร้อยละ</td>
<td height="20" align="center"><?php
$per1= ( $rs1['num7'] * 100 ) / $total;
echo number_format($per1,2,'.','.');
?></td>
<td height="20" align="center"><?php
$per2 = ( $rs2['num7'] * 100 ) / $total;
echo number_format($per2,2,'.','.');
?></td>
<td align="center"><?php
$per3 = ( $rs3['num7'] * 100 ) / $total;
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=1&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=4&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="PlanPerson.php?Teacher_type=7&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="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">รายการ</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=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">รายการ</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">๖. ห้องสมุด</td>
</tr>
<tr>
<td rowspan="2" align="center"> </td>
<td height="20" rowspan="2" align="center"> </td>
<td>๖.๑. ตำราหลักทางการพยาบาลที่ทันสมัยไม่ต่ำกว่าสาขาวิชาละ 10 ชื่อเรื่อง</td>
</tr>
<tr>
<td><table width="663" border="1" align="left" cellpadding="1" cellspacing="0">
<tr>
<td width="301" align="center">รายการ</td>
<td width="91" align="center">ปกศ. 2553</td>
<td width="82" align="center">ปกศ. 2554</td>
<td width="82" align="center">ปกศ. 2555</td>
<td width="85" align="center">ปกศ. 2556</td>
</tr>
<tr>
<td>๖.๑.๑ สาขาวิชาการพยาบาลเด็ก </td>
<td align="center"><a href="Sub1_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub1_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub1_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub1_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๒ สาขาวิชาการพยาบาลผู้ใหญ่และผู้สูงอายุ </td>
<td align="center"><a href="Sub2_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub2_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub2_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub2_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๓ สาขาวิชาการพยาบาลจิตเวช </td>
<td align="center"><a href="Sub3_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub3_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub3_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub3_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๔ สาขาวิชาการพยาบาลอนามัยชุมชน </td>
<td align="center"><a href="Sub4_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub4_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub4_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub4_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๕ สาขาวิชาการพยาบาลสูติศาสตร์ </td>
<td align="center"><a href="Sub5_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub5_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub5_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub5_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๖ สาขาวิชาพื้นฐานการพยาบาล</td>
<td align="center"><a href="Sub6_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub6_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub6_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub6_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๗ สาขาการบริหารการพยาบาล </td>
<td align="center"><a href="Sub7_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub7_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub7_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub7_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๑.๘ สาขาวิชาวิทยาศาสตร์สุขภาพ </td>
<td align="center"><a href="Sub8_2553.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub8_2554.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub8_2555.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
<td align="center"><a href="Sub8_2556.php"><img src="../images/icons/chart--arrow.png" width="16" height="16" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td rowspan="2" align="center"> </td>
<td height="20" rowspan="2" align="center"> </td>
<td>๖.๒. จำนวนตำรา/หนังสือทางการพยาบาล และวิทยาศาสตร์สุขภาพ ในอัตราส่วนนักศึกษา : จำนวนหนังสือ = 1 : 50 </td>
</tr>
<tr>
<td><table width="745" border="1" cellpadding="1" cellspacing="0">
<tr>
<td width="300" rowspan="2" align="center">รายการ</td>
<td width="90" align="center">ปกศ. 2553</td>
<td width="87" align="center">ปกศ. 2554</td>
<td width="81" align="center">ปกศ. 2555</td>
<td width="84" align="center">ปกศ. 2556</td>
<td width="77" rowspan="2" align="center">รวม</td>
</tr>
<tr>
<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 SUM(amount) AS TotalS FROM library_amountbook_tb WHERE type='1' and (Budget_Year>=2553 and Budget_Year<=2556) " ;
$result3 = $dbObj->execQuery($sql);
$RsTotalS=$dbObj->fetchArray($result3);
//
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='1' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount1=$dbObj->fetchArray($result3);
if( $RsAmount1['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount1['amount'])."</font>"; else echo number_format($RsAmount1['amount']);
?></td>
<td align="center"><?
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='1' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount2=$dbObj->fetchArray($result3);
if( $RsAmount2['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount2['amount'])."</font>"; else echo number_format($RsAmount2['amount']);
?></td>
<td align="center"><?
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='1' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount3=$dbObj->fetchArray($result3);
if( $RsAmount3['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount3['amount'])."</font>"; else echo number_format($RsAmount3['amount']);
?></td>
<td align="center"><?
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='1' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount4=$dbObj->fetchArray($result3);
if( $RsAmount4['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount4['amount'])."</font>"; else echo number_format($RsAmount4['amount']);
?></td>
<td align="center"><a href="AmountBook_Nursing.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๒.๒ จำนวนตำรา/หนังสือทางด้านวิทยาศาสตร์สุขภาพ </td>
<td align="center"><?
//
$sql = " SELECT SUM(amount) AS TotalS FROM library_amountbook_tb WHERE type='2' and (Budget_Year>=2553 and Budget_Year<=2556) " ;
$result3 = $dbObj->execQuery($sql);
$RsTotalS=$dbObj->fetchArray($result3);
//
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='2' and Budget_Year='2553' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount1=$dbObj->fetchArray($result3);
if( $RsAmount1['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount1['amount'])."</font>"; else echo number_format($RsAmount1['amount']);
?></td>
<td align="center"><?
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='2' and Budget_Year='2554' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount2=$dbObj->fetchArray($result3);
if( $RsAmount2['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount2['amount'])."</font>"; else echo number_format($RsAmount2['amount']);
?></td>
<td align="center"><?
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='2' and Budget_Year='2555' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount3=$dbObj->fetchArray($result3);
if( $RsAmount3['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount3['amount'])."</font>"; else echo number_format($RsAmount3['amount']);
?></td>
<td align="center"><?
$sql = " SELECT amount FROM library_amountbook_tb WHERE type='2' and Budget_Year='2556' " ;
$result3 = $dbObj->execQuery($sql);
$RsAmount4=$dbObj->fetchArray($result3);
if( $RsAmount4['amount'] != "0" ) echo "<font color=blue>".number_format($RsAmount4['amount'])."</font>"; else echo number_format($RsAmount4['amount']);
?></td>
<td align="center"><a href="AmountBook_Scn.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td rowspan="2" align="center"> </td>
<td height="20" rowspan="2" align="center"> </td>
<td>๖.๓. จำนวนวารสารวิชาชีพการพยาบาลในประเทศ</td>
</tr>
<tr>
<td><table width="745" border="1" cellpadding="1" cellspacing="0">
<tr>
<td width="301" rowspan="2" align="center">รายการ</td>
<td width="90" align="center">ปกศ. 2553</td>
<td width="87" align="center">ปกศ. 2554</td>
<td width="80" align="center">ปกศ. 2555</td>
<td width="85" align="center">ปกศ. 2556</td>
<td width="76" rowspan="2" align="center">รวม</td>
</tr>
<tr>
<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 library_journal_tb WHERE type='in' and (Budget_Year>='2553' and Budget_Year<='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM library_journal_tb WHERE type='in' 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 library_journal_tb WHERE type='in' 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 library_journal_tb WHERE type='in' 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 library_journal_tb WHERE type='in' 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>
<td align="center"><a href="JournalIn_Country.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center"> </td>
<td height="4" align="center"> </td>
<td>๖.๔. จำนวนวารสารวิชาชีพการพยาบาลต่างประเทศ</td>
</tr>
<tr>
<td align="center"> </td>
<td height="4" align="center"> </td>
<td><table width="745" border="1" cellpadding="1" cellspacing="0">
<tr>
<td width="301" rowspan="2" align="center">รายการ</td>
<td width="91" align="center">ปกศ. 2553</td>
<td width="87" align="center">ปกศ. 2554</td>
<td width="79" align="center">ปกศ. 2555</td>
<td width="85" align="center">ปกศ. 2556</td>
<td width="76" rowspan="2" align="center">รวม</td>
</tr>
<tr>
<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 library_journal_tb WHERE type='out' and (Budget_Year>='2553' and Budget_Year<='2556') " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM library_journal_tb WHERE type='out' 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 library_journal_tb WHERE type='out' 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 library_journal_tb WHERE type='out' 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 library_journal_tb WHERE type='out' 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>
<td align="center"><a href="JournalOut_Country.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td rowspan="2" align="center"> </td>
<td height="10" rowspan="2" align="center"> </td>
<td>๖.๕. จำนวนวารสารวิชาชีพการพยาบาลรวมแต่ละปี</td>
</tr>
<tr>
<td><table width="745" border="1" cellpadding="1" cellspacing="0">
<tr>
<td width="301" rowspan="2" align="center">รายการ</td>
<td width="92" align="center">ปกศ. 2553</td>
<td width="84" align="center">ปกศ. 2554</td>
<td width="80" align="center">ปกศ. 2555</td>
<td width="87" align="center">ปกศ. 2556</td>
<td width="75" rowspan="2" align="center">รวม</td>
</tr>
<tr>
<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 library_journal_tb WHERE Budget_Year>='2553' and Budget_Year<='2556' " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM library_journal_tb WHERE 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 library_journal_tb WHERE 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 library_journal_tb WHERE 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 library_journal_tb WHERE 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>
<td align="center"><a href="Journal_All.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td rowspan="2" align="center"> </td>
<td height="20" rowspan="2" align="center"> </td>
<td>๖.๖ ระบบและเทคโนโลยีการสืบค้นข้อมูลทางวิชาการทั้งภายในและภายนอกประเทศ</td>
</tr>
<tr>
<td><table width="745" border="1" cellpadding="1" cellspacing="0">
<tr>
<td width="301" rowspan="2" align="center">รายการ</td>
<td width="90" align="center">ปกศ. 2553</td>
<td width="85" align="center">ปกศ. 2554</td>
<td width="81" align="center">ปกศ. 2555</td>
<td width="88" align="center">ปกศ. 2556</td>
<td width="74" rowspan="2" align="center">รวม</td>
</tr>
<tr>
<td align="center">ระบบ</td>
<td align="center">ระบบ</td>
<td align="center">ระบบ</td>
<td align="center">ระบบ</td>
</tr>
<tr>
<td>๖.๖.๑ ระบบและเทคโนโลยีการสืบค้น<br />
ข้อมูลทางวิชาการภายในประเทศ</td>
<td align="center"><?
//
$sql = " SELECT * FROM library_technosys_tb WHERE type='in' and Budget_Year>='2553' and Budget_Year<='2556' " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM library_technosys_tb WHERE type='in' 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 library_technosys_tb WHERE type='in' 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 library_technosys_tb WHERE type='in' 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 library_technosys_tb WHERE type='in' 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>
<td align="center"><a href="TechnoSys_In.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๖.๒ ระบบและเทคโนโลยีการสืบค้น<br />
ข้อมูลทางวิชาการภายนอกประเทศ</td>
<td align="center"><?
//
$sql = " SELECT * FROM library_technosys_tb WHERE type='out' and Budget_Year>='2553' and Budget_Year<='2556' " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM library_technosys_tb WHERE type='out' 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 library_technosys_tb WHERE type='out' 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 library_technosys_tb WHERE type='out' 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 library_technosys_tb WHERE type='out' 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>
<td align="center"><a href="TechnoSys_Out.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
<tr>
<td>๖.๖.๓ ระบบและเทคโนโลยีการสืบค้น<br />
ข้อมูลทางวิชาการทั้งภายในและภายนอกประเทศ</td>
<td align="center"><?
//
$sql = " SELECT * FROM library_technosys_tb WHERE Budget_Year>='2553' and Budget_Year<='2556' " ;
$result3 = $dbObj->execQuery($sql);
$numall = $dbObj->_numrows;
$dbObj->freeresult($result3);
//
$sql = " SELECT * FROM library_technosys_tb WHERE 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 library_technosys_tb WHERE 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 library_technosys_tb WHERE 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 library_technosys_tb WHERE 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>
<td align="center"><a href="TechnoSys_All.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></td>
</tr>
</table></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">๗. การวิจัยและผลงาน ทางวิชาการ </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="PersonalOrResearch.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 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="MIO101.php?M21=1">รวมโครงการที่ทั้งหมด</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;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percent=($countnum*100)/$numall;
echo "<font color=red>".number_format( $percent,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;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percent=($countnum*100)/$numall;
echo "<font color=red>".number_format( $percent,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;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percent=($countnum*100)/$numall;
echo "<font color=red>".number_format( $percent,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;
?>
<?php if( $countnum != "0" ) echo "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center" bgcolor="#FFFFCC"><?
$percent=($countnum*100)/$numall;
echo "<font color=red>".number_format( $percent,2 )?></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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall;
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*100)/$numall;
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*100)/$numall;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall1;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall1;
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*100)/$numall1;
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*100)/$numall1;
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="MIO102.php?M22=1">โครงการที่บูรณาการทั้งการเรียนการสอนและงานวิจัย</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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall0;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall0;
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*100)/$numall0;
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*100)/$numall0;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall2;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall2;
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*100)/$numall2;
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*100)/$numall2;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall3;
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*100)/$numall3;
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*100)/$numall3;
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*100)/$numall3;
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="MIO104.php?M24=1">โครงการอื่น ๆ</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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$numall3;
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*100)/$numall3;
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*100)/$numall3;
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*100)/$numall3;
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="MIO104.php?M24=1">โครงการสร้างความเข้มแข็งของชุมชน/องค์กรภายนอก</a></td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"><a href="Sumary_project.php"></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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$allnum;
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*100)/$allnum;
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*100)/$allnum;
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*100)/$allnum;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$allnum1;
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*100)/$allnum1;
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*100)/$allnum1;
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*100)/$allnum1;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$allnum2;
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*100)/$allnum2;
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*100)/$allnum2;
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*100)/$allnum2;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$allnum3;
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*100)/$allnum3;
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*100)/$allnum3;
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*100)/$allnum3;
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 "<font color=blue>".number_format( $countnum )."</font>"; else echo number_format( $countnum ); ?></td>
<td align="center"><?
$percent=($countnum*100)/$allnum4;
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*100)/$allnum4;
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*100)/$allnum4;
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*100)/$allnum4;
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="9" align="right" bgcolor="#FFFFCC"> รวมโครงการที่แยกตามกลุ่มเป้าหมายทั้งหมด</td>
<td align="center" bgcolor="#FFFFCC">
<?
$sumary2=($allnum+$allnum1+$allnum2+$allnum3+$allnum4);
echo "<font color=red>".number_format( $sumary2 )
?>
</td>
<td align="center" bgcolor="#FFFFCC"><a href="Sumary_target.php"><img src="../images/IconCol2D.gif" width="16" height="16" /></a></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">๙. การทำนุบำรุงศิลปะและวัฒนธรรมของชาติ</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);
?>
|