Viewing file: CommitteeList.php (23.41 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../../../include/FunctionDB.php");
ConnectDB();
$sql = "Select * From personal_tb";
$result = mysql_query($sql) or die(" Error1").mysql_error();
$num = mysql_num_rows($result);
$sql2 = "Select * From committee_tb";
$result2 = mysql_query($sql2) or die(" Error2").mysql_error();
$num = mysql_num_rows($result2);
?>
<html>
<head>
<title>Show Committee Lists</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link rel="stylesheet" href="../../../css/style1.css" type="text/css">
</head>
<body bgcolor="#FFFFFF">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td colspan="3" bgcolor="#0066CC"><img src="../../../Image/Ponallogo.jpg" width="550" height="71"></td>
</tr>
<tr>
<td width="20%" background="../../../Image/bart1.jpg" class="table">
<div align="center"><strong><font size="2" face="Tahoma"><a href="../Training_Menu.php" class="d">เมนูพัฒนาบุคลากร</a></font></strong></div></td>
<td width="20%" background="../../../Image/bart1.jpg" class="table">
<div align="center"><strong><font size="2" face="Tahoma"><a href="PersonalList.php" class="d">ข้อมูลอาจารย์</a></font></strong></div></td>
<td width="20%" background="../../../Image/bart1.jpg" class="table">
<div align="center" ><strong><font size="2" face="Tahoma"><a href="../../logout.php" class="d">Logout</a></font></strong></div></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#006699" style="border:1px solid gray">
<form action="" method="post">
<tr bgcolor="#DFEBF9">
<td height="21" colspan="5">
<div align="center"><font color="#003366" size="4" face="Tahoma"><strong>ข้อมูลการเป็นกรรมการ
</strong></font></div></td>
</tr>
<tr bordercolor="#0066CC" bgcolor="#CCE6FF">
<td colspan="3" align="center" bgcolor="#CCE6FF" style="border:1px solid gray"> </td>
<td width="171" align="center" bgcolor="#CCE6FF" style="border:1px solid gray"><font size="1" face="Tahoma">แยกประเภทตาม
สมศ. 5.2 (กค 45)</font></td>
<td align="center" style="border:1px solid gray"><font size="1" face="Tahoma">แยกประเภทตามการเป็นกรรมการ</font>
<font size="1" face="Tahoma">ให้บริการวิชาการอื่นฯ</font></td>
</tr>
<tr bordercolor="#0066CC" bgcolor="#CCE6FF">
<td width="34" height="26" align="center" bgcolor="#DFEBF9" style="border:1px solid gray"><font color="#000000" size="1" face="Tahoma">ลำดับ</font></td>
<td width="144" align="center" bgcolor="#DFEBF9" style="border:1px solid gray"><font color="#000000" size="1" face="Tahoma">ชื่อ-นามสกุล</font></td>
<td width="120" align="center" bgcolor="#DFEBF9" style="border:1px solid gray"><font color="#000000" size="1" face="Tahoma">ตำแหน่งการบริหาร</font></td>
<td align="center" style="border:1px solid gray"><table width="100%" height="20" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#DFEBF9">
<td width="25%" height="13"> <div align="center"><font size="1" face="Tahoma">วิชาการ</font></div></td>
<td width="25%"> <div align="center"><font size="1" face="Tahoma">วิชาชีพ</font></div></td>
<td width="25%"> <div align="center"><font size="1" face="Tahoma">วิทยานิพนธ์</font></div></td>
</tr>
</table></td>
<td width="285" align="center" style="border:1px solid gray"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr bgcolor="#DFEBF9">
<td width="20%" style="border:1px solid gray"> <div align="center"><font size="1" face="Tahoma">ตรวจเครื่องมือ</font></div></td>
<td width="20%" style="border:1px solid gray"> <div align="center"><font size="1" face="Tahoma">คปสข.10</font></div></td>
<td width="20%" style="border:1px solid gray"> <div align="center"><font size="1" face="Tahoma">ชมรม
พยบ. ลป.</font></div></td>
<td width="20%" bgcolor="#DFEBF9" style="border:1px solid gray"> <div align="center"><font size="1" face="Tahoma">เครือข่าย
ว. ภาคเหนือ</font></div></td>
<td width="20%" style="border:1px solid gray"> <div align="center"><font size="1" face="Tahoma">กรรมการ
อื่นๆ</font></div></td>
</tr>
</table></td>
</tr>
<?
$i = 1;
$j = 0;
$k = 0;
$m = 0;
$n = 0;
$p = 0;
$q = 0;
while($rs = mysql_fetch_array($result) and $rs2 =mysql_fetch_array($result2) )
{
if($count==0)
{
?>
<tr bgcolor=#F9FEFF>
<td align=center bordercolor="#EBFAFE"><font size="1" face="Tahoma"><?echo $i?></font></td>
<td bordercolor="#EBFAFE"><font size="2" face="Tahoma"><a href="Showpersonal.php?Teacher_code=<?echo $rs[Teacher_code]?>" class="d"><?echo $rs[First_name]?> <?echo $rs[Teacher_name]?> <?echo $rs[Teacher_lastname]?></a></font></td>
<td bordercolor="#EBFAFE"> <div align="center"><font color="#003366" size="2" face="Tahoma"><?echo $rs[Manage_pos]?></font></div></td>
<td bordercolor="#EBFAFE"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%" height="18"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Edu]?></font></div></td>
<td width="25%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Edu_job]?></font></div></td>
<td width="25%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Tsis]?></font></div></td>
</tr>
</table></td>
<td bordercolor="#EBFAFE" bgcolor="#F9FEFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td width="20%" height="18"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Check_tool]?></font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Scp10]?></font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Club_bcnlp]?></font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[North_network]?></font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Else_commit]?></font></div></td>
</tr>
</table></td>
</tr>
<?
$count=1;
}
else
{
?>
<tr bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<td align="center"><font size="1" face="Tahoma"><?echo $i?></font></td>
<td><font size="2" face="Tahoma"><a href="Showpersonal.php?Teacher_code=<? echo $rs[Teacher_code]?>" class="d"><?echo $rs[First_name]?> <?echo $rs[Teacher_name]?> <?echo $rs[Teacher_lastname]?></a></font></td>
<td> <div align="center"><font color="#003366" size="2" face="Tahoma"><?echo $rs[Manage_pos]?></font></div></td>
<td> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Edu]?></font></div></td>
<td width="25%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Edu_job]?></font></div></td>
<td width="25%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Tsis]?></font></div></td>
</tr>
</table></td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Check_tool]?></font></div></td>
<td width="20%"><div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Scp10]?></font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Club_bcnlp]?></font></div></td>
<td width="20%"><div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[North_network]?></font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma"><? echo $rs2[Else_commit]?></font></div></td>
</tr>
</table></td>
</tr>
<?
$count=0;
}
$i++;
}
?>
</form>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" style="border:1px solid gray">
<tr>
<td width="41%" bgcolor="#FCFAA9"> <div align="center"><font color="#003366" size="2" face="Tahoma">จำนวนการเป็นกรรมการ
(แยกตามประเภท)</font></div></td>
<td width="22%"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql1 = "Select Count(Edu) as sum1 From committee_tb Where Edu='Yes' ";
$result1 = mysql_query($sql1);
$rs1 = mysql_fetch_array($result1);
echo $rs1[sum1];
?>
</font></div></td>
<td width="25%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(Edu_job) as sum5 From committee_tb Where Edu_job='Yes' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum5];
?>
</font></div></td>
<td width="25%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Tsis) as sum8 From committee_tb Where Tsis='Yes' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
<td width="25%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
</tr>
</table></td>
<td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="20%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql1 = "Select Count(Check_tool) as sum1 From committee_tb Where Check_tool='Yes' ";
$result1 = mysql_query($sql1);
$rs1 = mysql_fetch_array($result1);
echo $rs1[sum1];
?>
</font></div></td>
<td width="20%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Scp10 ) as sum8 From committee_tb Where Scp10 ='Yes' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
<td width="20%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(Club_bcnlp) as sum5 From committee_tb Where Club_bcnlp='Yes' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum5];
?>
</font></div></td>
<td width="20%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(North_network) as sum5 From committee_tb Where North_network='Yes' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum5];
?>
</font></div></td>
<td width="20%" bgcolor="#FDFCEC"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Else_commit ) as sum8 From committee_tb Where Else_commit ='Yes' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#B8F49D"> <div align="center"><font size="2" face="Tahoma">จำนวนการไม่เป็นกรรมการ
(แยกตามประเภท) </font></div></td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql3 = "Select Count(Edu) as sum2 From committee_tb Where Edu='No' ";
$result3 = mysql_query($sql3);
$rs3 = mysql_fetch_array($result3);
echo $rs3[sum2];
?>
</font></div></td>
<td width="25%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql6 = "Select Count(Edu_job) as sum6 From committee_tb Where Edu_job='No' ";
$result6 = mysql_query($sql6);
$rs6 = mysql_fetch_array($result6);
echo $rs6[sum6];
?>
</font></div></td>
<td width="25%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Tsis) as sum8 From committee_tb Where Tsis='No' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
<td width="25%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
</tr>
</table></td>
<td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="20%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql1 = "Select Count(Check_tool) as sum1 From committee_tb Where Check_tool='No' ";
$result1 = mysql_query($sql1);
$rs1 = mysql_fetch_array($result1);
echo $rs1[sum1];
?>
</font></div></td>
<td width="20%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Scp10 ) as sum8 From committee_tb Where Scp10 ='NO' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
<td width="20%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(Club_bcnlp) as sum6 From committee_tb Where Club_bcnlp='No' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum6];
?>
</font></div></td>
<td width="20%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(North_network) as sum5 From committee_tb Where North_network='No' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum5];
?>
</font></div></td>
<td width="20%" bgcolor="#F0FDE8"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Else_commit ) as sum8 From committee_tb Where Else_commit ='No' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#FAD5BE"> <div align="center"><font size="2" face="Tahoma">จำนวนผู้ลาศึกษา/ไปช่วยราชการ</font></div></td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%" bgcolor="#FCF4E9"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql4 = "Select Count(Edu) as sum4 From committee_tb Where Edu='S' ";
$result4 = mysql_query($sql4);
$rs4 = mysql_fetch_array($result4);
echo $rs4[sum4];
?>
</font></div></td>
<td width="25%" bgcolor="#FCF4E9"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql7 = "Select Count(Edu_job) as sum7 From committee_tb Where Edu_job='S' ";
$result7 = mysql_query($sql7);
$rs7 = mysql_fetch_array($result7);
echo $rs7[sum7];
?>
</font></div></td>
<td width="25%" bgcolor="#FCF4E9"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Tsis) as sum8 From committee_tb Where Tsis='S' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
<td width="25%" bgcolor="#FCF4E9"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
echo"$m";
?>
</font></div></td>
</tr>
</table></td>
<td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#FCF4E9">
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql1 = "Select Count(Check_tool) as sum1 From committee_tb Where Check_tool='S' ";
$result1 = mysql_query($sql1);
$rs1 = mysql_fetch_array($result1);
echo $rs1[sum1];
?>
</font></div></td>
<td width="20%" bgcolor="#FCF4E9"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql8 = "Select Count(Scp10 ) as sum8 From committee_tb Where Scp10 ='S' ";
$result8 = mysql_query($sql8);
$rs8 = mysql_fetch_array($result8);
echo $rs8[sum8];
?>
</font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(Club_bcnlp) as sum6 From committee_tb Where Club_bcnlp='S' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum6];
?>
</font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(North_network) as sum5 From committee_tb Where North_network='S' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum5];
?>
</font></div></td>
<td width="20%"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
$sql5 = "Select Count(North_network) as sum5 From committee_tb Where North_network='S' ";
$result5 = mysql_query($sql5);
$rs5 = mysql_fetch_array($result5);
echo $rs5[sum5];
?>
</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#EEEEEE"> <div align="center"><font size="2" face="Tahoma">จำนวนการเป็นกรรมการวิชาการ/วิชาชีพ/วิทยานิพนธ์</font></div></td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%" bgcolor="#EEEEEE"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
echo"$j";
?>
</font></div></td>
</tr>
</table></td>
<td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#eeeeee"> <div align="center"><font size="2" face="Tahoma">จำนวนการไม่เป็นกรรมการวิชาการ/วิชาชีพ/วิทยานิพนธ์</font></div></td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%"> </td>
<td width="25%" bgcolor="#eeeeee"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
echo"$k";
?>
</font></div></td>
</tr>
</table></td>
<td colspan="2"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#FCF4E9">
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
<td width="20%" bgcolor="#FFFFFF"> <div align="center"><font color="#993333" size="2" face="Tahoma">
<?php
?>
</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="25%" bgcolor="#FFFFFF"> </td>
<td width="25%" bgcolor="#FFFFFF"> </td>
<td width="25%" bgcolor="#FFFFFF"> </td>
<td width="25%" bgcolor="#FFFFFF"> </td>
</tr>
</table></td>
<td width="17%"> </td>
<td width="20%"> </td>
</tr>
<tr>
<td colspan="4" bgcolor="#CCE6FF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">ทั้งหมด</font><font color="#FF0000" size="2" face="Geneva, Arial, Helvetica, sans-serif">
<? echo $num ?><font color="#003399" face="Tahoma"> คน </font> </font></strong>
</div></td>
</tr>
</table>
</body>
</html>
|