Viewing file: CommitteeList.php (22.39 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(); $row = mysql_fetch_array($result); //$num = mysql_num_rows($result); $sql2 = "Select * From committee_tb WHERE Year_com='$Year_com'"; $result2 = mysql_query($sql2) or die(" Error2").mysql_error(); $num = mysql_num_rows($result2); ?> <html> <head> <title>Show Personal 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="#F5FEE9"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td width="20%" background="../../Image/bart1.jpg" class="table"> <div align="center"><strong><font size="2" face="Tahoma"><a href="../Menu_Develop.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="#AED7FF"> <td height="25" colspan="5" background="../../Image/bIns.jpg"> <div align="center"><font color="#003366" size="4" face="Tahoma"><strong>ข้อมูลการเป็นกรรมการให้บริการวิชาการแก่สังคม ปี พ.ศ <? echo $Year_com ?></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="39" 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%" height="37" 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="PersonalList.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="PersonalList.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="#FDFCEC"> <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> </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="#F0FDE8"> <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> </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="#FCF4E9"> <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> </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>
|