Viewing file: SumPesonal_bkp.php (22.58 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../include/FunctionDB.php");
include("admin_menu.php");
ConnectDB();
$sql = "Select Sum(Teacher_name) From personal_tb ";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result);
$sql2 = "Select * From personal_tb Order By Teacher_name ASC";
$result2 = mysql_query($sql2) or die(" Error").mysql_error();
$rs2 = mysql_fetch_array($result2);
$total = mysql_num_rows($result2);
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<style type="text/css">
<!--
.style1 { color: #0000FF;
font-size: 14px;
}
.style2 {color: #003399}
.style3 { font-size: 14px;
font-weight: bold;
}
.style4 {font-size: 14px}
.style6 {color: #FF0000}
.style7 { color: #0000FF;
font-weight: bold;
}
.style10 {color: #0000FF}
.style12 {
color: #0000FF;
font-family: Tahoma;
font-size: 14px;
}
.style13 {font-size: 16px}
.style14 {color: #003399; font-size: 14px; }
-->
</style>
<table width="816" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="816"><br>
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Director_menu.php" >หน้าหลัก</a><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />จำนวนบุคลากรจำแนกตามหน่วยงาน</font></legend>
<label><div align="center">
<form id="form1" name="form1" method="post" action="">
<p align="left"><span class="style7"><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></span></p>
<table width="86%" height="356" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border:0px solid gray"size="12">
<tr>
<td height="27" bgcolor="#FFFFFF"><div align="center" class="style10 style13"><font face="Tahoma">รายงานสรุปสถานะข้อมูลบุคลากร</font>
<table width="92%" height="317" border="0" cellpadding="0" cellspacing="0" style="border:0px solid gray">
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td colspan="4" bgcolor="#FFFFFF" class="style7"> </td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="17" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/FlatBars2.gif" width="17" height="17" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style12">จำนวนระดับการศึกษาของบุคลากรทุกสายงานทั้งหมด</td>
<td bgcolor="#FFFFFF"><div align="center" class="style12">จำนวน</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style12">ร้อยละ</div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td width="4%" height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td width="64%" bgcolor="#FFFFFF" class="style4"><font face="Tahoma"><a href="PersonalData1.php?Page=1&Degree_code=1<? echo $rs[Degree_code]?>" class="d"> ปริญญาตรี</a></font></td>
<td width="19%" bgcolor="#FFFFFF"><div align="center"><font color="#000055" size="2" face="Tahoma"><strong>
<?php
$sql1 = "SELECT count(Degree_code) as num1 FROM personal_tb WHERE StatusId='1' and Degree_code=1 ";
$result = mysql_query($sql1) or die(" Error").mysql_error();
$rs1 = mysql_fetch_array($result);
echo "$rs1[num1]";
?>
</strong></font></div></td>
<td width="19%" bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <a href="DegreeList.php?Degree_code=1"></a>
<?php
$per1 = ($rs1[num1] * 100) / $total;
echo number_format($per1,2,'.','.');
?>
</strong></font></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"> <a href="PersonalData2.php?Page=1&Degree_code=2<? echo $rs[Degree_code]?>" class="d">ปริญญาโท</a></font></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql2 = "Select Count(Degree_code) as num2 From personal_tb Where StatusId='1' and Degree_code=2 ";
$result = mysql_query($sql2) or die(" Error").mysql_error();
$rs2 = mysql_fetch_array($result);
echo "$rs2[num2]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per2 = ($rs2[num2] * 100) / $total;
echo number_format($per2,2,'.','.');
?>
</strong></font></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"><a href="PersonalData3.php?Page=1&Degree_code=3<? echo $rs[Degree_code]?>" class="d"> ปริญญาเอก</a></font></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql3 = "Select Count(Degree_code) as num3 From personal_tb Where StatusId='1' and Degree_code=3 ";
$result = mysql_query($sql3) or die(" Error").mysql_error();
$rs3 = mysql_fetch_array($result);
echo "$rs3[num3]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per3 = ($rs3[num3] * 100) / $total;
echo number_format($per3,2,'.','.');
?>
</strong></font></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="17" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/FlatBars2.gif" width="17" height="17" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style12">จำนวนบุคลากรตามประเภทสายงาน</td>
<td bgcolor="#FFFFFF"><div align="center" class="style12">จำนวน</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style12">ร้อยละ</div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d"><span class="style1"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=1<? echo $rs[Teacher_type]?>" class="d">ทันตแพทย์</a></font></span></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql4 = "Select Count(Teacher_type) as num4 From personal_tb Where StatusId='1' and Teacher_type=1 ";
$result = mysql_query($sql4) or die(" Error").mysql_error();
$rs4 = mysql_fetch_array($result);
echo "$rs4[num4]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per4 = ($rs4[num4] * 100) / $total;
echo number_format($per4,2,'.','.');
?>
</strong></font></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d"><span class="style1"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=4<? echo $rs[Teacher_type]?>" class="d">เภสัชกร</a></font></span></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql5 = "Select Count(Teacher_type) as num5 From personal_tb Where StatusId='1' and Teacher_type=4 ";
$result = mysql_query($sql5) or die(" Error").mysql_error();
$rs5 = mysql_fetch_array($result);
echo "$rs5[num5]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per5 = ($rs5[num5] * 100) / $total;
echo number_format($per5,2,'.','.');
?>
</strong></font></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=2<? echo $rs[Teacher_type]?>" class="d">วิทยาจารย์</a></font><font face="Tahoma"><strong><span class="style3"><a href="PersonalData4.php?Page=1&Teacher_type=2<? echo $rs[Teacher_type]?>" class="d"></a></span></strong></font></font></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql6 = "Select Count(Teacher_type) as num6 From personal_tb Where StatusId='1' and Teacher_type=2 ";
$result = mysql_query($sql6) or die(" Error").mysql_error();
$rs6= mysql_fetch_array($result);
echo "$rs6[num6]";
?>
</strong></font> </strong></div></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per6 = ($rs6[num6] * 100) / $total;
echo number_format($per6,2,'.','.');
?>
</strong></font> </strong></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=5<? echo $rs[Teacher_type]?>"" class="style2">พยาบาลวิชาชีพ</a> </font></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql7 = "Select Count(Teacher_type) as num7 From personal_tb Where StatusId='1' and Teacher_type=5 ";
$result = mysql_query($sql7) or die(" Error").mysql_error();
$rs7= mysql_fetch_array($result);
echo "$rs7[num7]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per7 = ($rs7[num7] * 100) / $total;
echo number_format($per7,2,'.','.');
?>
</strong></font></strong></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=6<? echo $rs[Teacher_type]?>"" class="style2">สายสนับสนุน</a> </font></td>
<td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql8 = "Select Count(Teacher_type) as num8 From personal_tb Where StatusId='1' and Teacher_type=6 ";
$result = mysql_query($sql8) or die(" Error").mysql_error();
$rs8= mysql_fetch_array($result);
echo "$rs8[num8]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per8 = ($rs8[num8] * 100) / $total;
echo number_format($per8,2,'.','.');
?>
</strong></font></strong></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="17" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/FlatBars2.gif" width="17" height="17" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style12">จำนวนบุคลากรตามสถานะ</td>
<td bgcolor="#FFFFFF"><div align="center" class="style12">จำนวน</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style12">ร้อยละ</div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"><font face="Tahoma"><a href="PersonalDatatype.php?Page=1&Person_type=1<? echo $rs[Person_type]?>" class="style2">ข้าราชการ</a></font></font></td>
<td bgcolor="#FFFFFF"><div align="center"> <font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql9 = "Select Count(Person_type) as num9 From personal_tb Where StatusId='1' and Person_type=1 ";
$result = mysql_query($sql9) or die(" Error").mysql_error();
$rs9= mysql_fetch_array($result);
echo "$rs9[num9]";
?>
</strong></font></div></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per9 = ($rs9[num9] * 100) / $total;
echo number_format($per9,2,'.','.');
?>
</strong></font> </strong></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d"><a href="PersonalDatatype.php?Page=1&Person_type=3<? echo $rs[Person_type]?>"><span class="style14"><font face="Tahoma"><font face="Tahoma">ลูกจ้างประจำ</font></font></span></a></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql10 = "Select Count(Person_type) as num10 From personal_tb Where StatusId='1' and Person_type=3 ";
$result = mysql_query($sql10) or die(" Error").mysql_error();
$rs10= mysql_fetch_array($result);
echo "$rs10[num10]";
?>
</strong></font> </strong></div></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per10 = ($rs10[num10] * 100) / $total;
echo number_format($per10,2,'.','.');
?>
</strong></font> </strong></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><span class="style1"><font face="Tahoma"><a href="PersonalDatatype.php?Page=1&Person_type=4<? echo $rs[Person_type]?>" class="d">ลูกจ้างชั่วคราว (เหมาจ่าย) </a></font></span></font></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$sql11 = "Select Count(Person_type) as num11 From personal_tb Where StatusId='1' and Person_type=4 ";
$result = mysql_query($sql11) or die(" Error").mysql_error();
$rs11= mysql_fetch_array($result);
echo "$rs11[num11]";
?>
</strong></font> </strong></div></td>
<td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong>
<?php
$per11 = ($rs11[num11] * 100) / $total;
echo number_format($per11,2,'.','.');
?>
</strong></font> </strong></div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td>
<td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><span class="style4"><font face="Tahoma"><a href="PersonalData.php" class="d">รวมจำนวนบุคลากรทั้งหมด</a></font></span></font></td>
<td colspan="2" bgcolor="#FFFFFF"><div align="center"><strong><font size="4" face="Tahoma">
<?php
// $code = $rs["code"];
$sql5 = "Select * From personal_tb Where StatusId='1' ";
$result5 = mysql_query($sql5) or die(" Error".mysql_error());
$rc5 = mysql_num_rows($result5);
if ( $rc5 == 0)
{
echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">";
echo"ยังไม่ข้อมูล";
echo"</font>";
}
else if ($rc5 > 0)
{
echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">";
echo"$rc5 <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">คน</font>";
echo"</font>";
}
?>
</font> </strong></div>
<div align="center"> </div></td>
</tr>
<tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
<td> </td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="20" ><div align="center">
<p class="style4"><font face="Tahoma"><!--<a href="./graph/reportdegreel.php?num1=<? //echo $rs1[num1]?>&m2=<? //echo $rs2[num2]?>&m3=<? //echo $rs3[num3]?>">--><!--</a>--></font></p>
<?php
//include("personal_graph.php");
?>
</div>
</td>
</tr>
</table>
</form>
</div>
</label>
</fieldset><br>
<font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br>
</font></td>
</tr>
</table>
|