<?php

include("../include/FunctionDB.php");
include("admin_menu.php");
ConnectDB();
$sql = "Select * From personal_tb  Where   Faculty_code='$Faculty_code' and  Person_type='$Person_type' Order By Teacher_id, Teacher_name  ASC";
$result = mysql_query($sql) or die(" Error").mysql_error();
$num = mysql_num_rows($result);
$rs = mysql_fetch_array($result); 
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<style type="text/css">
<!--
.style1 {font-size: 14px}
-->
</style>


<table width="814" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="814"><br />
        <fieldset>
        <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_manage.php" >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="PersonalSalary.php?Faculty_code=<? echo $rs[Faculty_code] ?>&Person_type=1">ค่าตอบแทนข้าราชการ</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="PersonalSalary.php?Faculty_code=<? echo $rs[Faculty_code] ?>&amp;Person_type=3">ค่าตอบแทนลูกจ้างประจำ</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="EducationData.php?Teacher_code=<? echo $rs[Teacher_code] ?>"></a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="PersonalSalary.php?Faculty_code=<? echo $rs[Faculty_code] ?>&amp;Person_type=4">ค่าตอบแทนลูกจ้างชั่วคราว</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="EducationData.php?Teacher_code=<? echo $rs[Teacher_code] ?>"></a></font></legend>
          <label></label>
        <div align="center">
          <form id="form1" name="form1" method="post" action="InsertSalary.php">
            <table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#006699" style="border:1px solid gray">
              <tr bgcolor="#FAEEC0">
                <td width="597" height="21" colspan="4"><div align="center" class="style1"><font color="#003366" face="Tahoma">ค่าตอบแทนบุคลากรจำแนกตามหน่วยงานตามประเภทบุคลากร</font></div></td>
              </tr>
              <tr bgcolor="#FAEEC0">
                <td height="21" colspan="4"><div align="center" class="style1">
                  <div align="center"><font face="Tahoma">หน่วยงาน</font><font size="2" face="Tahoma">
                    <?php
      //$Faculty_code = $rs[Faculty_code];
      $sql1 ="Select * From faculty_tb Where Faculty_code='$Faculty_code'";
      $result2 = mysql_query($sql1);
      $row = mysql_fetch_array($result2);
      echo "$row[Faculty_name]";
      
      ?>
                    </font><font face="Tahoma">ประเภท </font><font size="2" face="Tahoma">
                    <?php
      //$Faculty_code = $rs[Faculty_code];
      $sql1 ="Select * From person_type_tb  Where  Ptype_code='$Person_type'";
      $result3 = mysql_query($sql1);
      $row = mysql_fetch_array($result3);
      echo "$row[Ptype_name]";
      
      ?>
                    </font></div>
                </div></td>
              </tr>
              
              <?
$i = 1;
 while($rs = mysql_fetch_array($result))
 {

     if($count==0)
     {
?>
              <?
    $count=1;
     }
else
{
?>
              <?
$count=0;
}
$i++;
 }    
?>
              <tr bgcolor="#FCF9E2">
                <td height="51" colspan="4" align="center"><table width="99%" height="72" border="1" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="85%" height="33" bgcolor="#E8FAFD"><div align="center"><span class="style1"><font color="#003366" face="Tahoma">ค่าตอบแทนบุคลากรจำแนกตามหน่วยงาน</font><font size="2" face="Tahoma">
                      <?php
      //$Faculty_code = $rs[Faculty_code];
      $sql1 ="Select * From faculty_tb Where Faculty_code='$Faculty_code'";
      $result2 = mysql_query($sql1);
      $row = mysql_fetch_array($result2);
      echo "$row[Faculty_name]";
      
      ?>
                      </font><font color="#003366" face="Tahoma">ตามประเภทบุคลากร<font size="2" face="Tahoma">
                        <?php
      //$Faculty_code = $rs[Faculty_code];
      $sql1 ="Select * From person_type_tb  Where  Ptype_code='$Person_type'";
      $result3 = mysql_query($sql1);
      $row = mysql_fetch_array($result3);
      echo "$row[Ptype_name]";
      
      ?>
                    </font> (เดือน) </font></span></div></td>
                    <td width="15%" bgcolor="#E8FAFD"><div align="right"><strong><font color="#993333" size="2" face="Tahoma"> </font></strong><strong><font color="#993333" size="2" face="Tahoma">
                      <?php
         $sql = "Select Sum(Salary_1) as Sum From personal_tb   Where   Person_type='$Person_type' and  Faculty_code='$Faculty_code'  ";
         $result1 = mysql_query($sql) or die("Error".mysql_error());
         $rss1 = mysql_fetch_array($result1);
         echo number_format($rss1['Sum'],2,'.',','); 
        
        
         ?>
                    </font></strong></div></td>
                  </tr>
                  <tr>
                    <td bgcolor="#E8FAFD"><div align="center"><span class="style1"><font color="#003366" face="Tahoma">ค่าตอบแทนบุคลากรจำแนกตามหน่วยงาน</font><font size="2" face="Tahoma">
                      <?php
      //$Faculty_code = $rs[Faculty_code];
      $sql1 ="Select * From faculty_tb Where Faculty_code='$Faculty_code'";
      $result2 = mysql_query($sql1);
      $row = mysql_fetch_array($result2);
      echo "$row[Faculty_name]";
      
      ?>
                      </font><font color="#003366" face="Tahoma">ตามประเภทบุคลากร <font size="2" face="Tahoma">
                        <?php
      //$Faculty_code = $rs[Faculty_code];
      $sql1 ="Select * From person_type_tb  Where  Ptype_code='$Person_type'";
      $result3 = mysql_query($sql1);
      $row = mysql_fetch_array($result3);
      echo "$row[Ptype_name]";
      
      ?>
                    </font>( ปี )</font></span></div></td>
                    <td bgcolor="#E8FAFD"><div align="right"><strong><font color="#993333" size="2" face="Tahoma"> </font></strong><strong><font color="#993333" size="2" face="Tahoma">
                      <?php
         $sql = "Select Sum(Salary_1*12) as Sum From personal_tb Where   Person_type='$Person_type' and  Faculty_code='$Faculty_code'  ";
         $result1 = mysql_query($sql) or die("Error".mysql_error());
         $rss1 = mysql_fetch_array($result1);
         echo number_format($rss1['Sum'],2,'.',','); 
        
    CloseDB();
         ?>
                    </font></strong></div></td>
                  </tr>
                </table></td>
              </tr>
              <tr bgcolor="#FCF9E2">
                <td height="25" colspan="4" align="center"><div align="center"></div></td>
              </tr>
            </table>
            <p>&nbsp;</p>
          </form>
        </div>
      </fieldset>
      <br />
        <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br />
    </font></td>
  </tr>
</table>