<?php
session_start();

 if (session_is_registered("valid_user")&&session_is_registered("Priority") )
 {
 $Username = $valid_user;
 $Password = $password;
include("../include/FunctionDB.php");
include("../include/Function.php");
include("admin_menu.php");
 ConnectDB();
$sql = "Select * From personal_tb  Where Teacher_code='$Teacher_code'";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rss = mysql_fetch_array($result);
$sql2 = "Select * FROM   salary_repot_tb  Where  Code='$Code'";
$result2 = mysql_query($sql2) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result2);
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<style type="text/css">
<!--
.style14 {color: #000000}
.style1 {color: #FF0000}
.style2 {color: #0000FF}
.style6 {color: #0000FF; font-size: 14px; }
.style7 {    color: #FF0000;
    font-weight: bold;
}
-->
</style>
<table width="802" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td width="802"><br>
          <fieldset>
            <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_teacher.php " >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="AddMony.php?Teacher_code=<? echo $rs[Teacher_code] ?>">เพิ่มข้อมูลประวัติเงินเดือน</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="PersonalMonyList.php?Teacher_code=<? echo $rs[Teacher_code] ?>">ข้อมูลประวัติเงินเดือนบุคลากร</a></font><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="">
                <table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" style=" border:1px solid gray"size="12">
                  <tr>
                    <td height="29" background="../Image/barIns2.jpg" bgcolor="#D1E1F0"><div align="center"><font size="2" face="Tahoma">ขณะนี้ อ.<font color="#993333"><strong><? echo $rss['Teacher_name'] ?> &nbsp;<? echo $rss['Teacher_lastname'] ?> </strong></font><span class="style14">รหัสประจำตัว</span> <font color="#993333"><strong><? echo $rss['Teacher_id'] ?></strong></font> กำลังใช้งานระบบ</font></div></td>
                  </tr>
                  
                  <tr>
                    <td height="43" ><table width="100%" border="0" align="center" cellpadding="0" cellspacing="2" style="background-color:#eeeeee; border:0px solid gray"size="12">
                      <tr bgcolor="#F3D6F2">
                        <td height="25" colspan="5"><div align="center"><font color="#999999" size="4" face="Tahoma"><strong><font color="#000000">แสดงรายรับและรายจ่ายประจำเดือน</font></strong></font></div></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td height="20" bordercolor="#CCCCCC"><div align="center"><font size="2" face="Tahoma">ชื่อ 
                          - นามสกุล</font></div></td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC"><font color="#003366" size="2" face="Tahoma">&nbsp;</font><font size="2" face="Tahoma">
                          <?php
         $Teacher_code =  $rs["Teacher_code"];
         $sql3 = "Select * From personal_tb Where Teacher_code='$Teacher_code'";
          $result3 = mysql_query($sql3) or die("Error".mysql_error());
          $rs3 = mysql_fetch_array($result3);
          echo "$rs3[First_name] $rs3[Teacher_name] $rs3[Teacher_lastname]";
         ?>
                          &nbsp; &nbsp; &nbsp; <strong>รหัส</strong> </font><font color="#003366" size="2" face="Tahoma">&nbsp;<?php echo $rs[Teacher_id] ;?></font></td>
                        <td width="15%" bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left" class="style14">
                              <div align="center"><font size="2" face="Tahoma">เดือน </font><font color="#003366" size="2" face="Tahoma">&nbsp;<?php echo $rs[Start_mont] ;?></font></div>
                            </div>
                        </div></td>
                        <td width="28%" bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#000000" size="2" face="Tahoma">ปี </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Start_year] ;?></font><font color="#000000" size="2" face="Tahoma">&nbsp; </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center" class="style7"><font size="2" face="Tahoma">รายรับ</font></div></td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่</font></td>
                        <td bordercolor="#CCCCCC" bgcolor="#eeeeee" class="style1"><div align="center" class="style7"><font size="2" face="Tahoma">รายจ่าย</font></div></td>
                        <td bordercolor="#FFFFCC" bgcolor="#eeeeee"><font color="#000000" size="2" face="Tahoma">ี่ </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td width="22%" bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินเดือน</font></div></td>
                        <td width="1%" bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td width="34%" bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Salary_1] ;?></font> บาท <font color="#000000" size="2" face="Tahoma">&nbsp; </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma"> ฌกส </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_10] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินค่าตอบแทน ตำแหน่ง</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Salary_2] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma"> สหกรณ์</font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_11] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินประจำตำแหน่ง</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Salary_3] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma"> ธนาคาร ออมสิน </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_12] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินค่าวิชาชีพ</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_1] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma"> ไฟฟ้า </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_13] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินค่าครองชีพ</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_2] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma">บ้าน</font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_14] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินค่า OT นอกเวลา </font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_3] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma">ส ป จักยานยนต์ </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_15] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินค่าบุตร</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_4] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma">ค่า ธรรมเนียม ธนาคาร </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_16] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">เงินค่าทำคลินิกนอกเวลา</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_5] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma">ค่า ........ </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_17] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">อื่นๆ</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_6] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma">ค่า ........ </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_18] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"><font size="2" face="Tahoma">อื่นๆ</font></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_7] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#CCCCCC" class="style1"><div align="center" class="style1">
                            <div align="left"><font size="2" face="Tahoma">อื่น ๆ ........ </font></div>
                        </div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_19] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC"><div align="left"></div></td>
                        <td bordercolor="#FFFFCC"><div align="center">:</div></td>
                        <td bordercolor="#FFFFCC"><font color="#000000" size="2" face="Tahoma">ี่ </font></td>
                        <td bordercolor="#FFFFCC"><span class="style1"><font size="2" face="Tahoma">หักภาษี ณ ที่จ่าย</font></span></td>
                        <td bordercolor="#FFFFCC"><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_8] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC" class="style1">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC"><span class="style1"><font size="2" face="Tahoma">กบข กสจ </font></span></td>
                        <td bordercolor="#FFFFCC"><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_9] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท</font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td bordercolor="#CCCCCC" class="style1">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                      </tr>
                      <tr bgcolor="#FFCC99">
                        <td height="22" bordercolor="#CCCCCC" class="style1"><font size="2" face="Tahoma"><span class="style2">รวมรายรับสุทธ</span>ิ</font></td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC"><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_salary] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                        <td bordercolor="#FFFFCC"><span class="style6"><font face="Tahoma">รวมรายจ่ายสุทธิ</font></span></td>
                        <td bordercolor="#FFFFCC"><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_to] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#eeeeee">
                        <td height="22" bordercolor="#CCCCCC" class="style1">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC">&nbsp;</td>
                        <td bordercolor="#FFFFCC" bgcolor="#FFCCCC"><font face="Tahoma"><span class="style6">คงเหลือเงินสุทธิ</span></font></td>
                        <td bordercolor="#FFFFCC" bgcolor="#FFCCCC"><font color="#003366" size="2" face="Tahoma"><?php echo $rs[Costt_total] ;?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></td>
                      </tr>
                      <tr bgcolor="#F3D6F2">
                        <td height="25" colspan="5"><div align="center"> </div></td>
                      </tr>
                    </table></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>
<?php 
    }
else
{
       echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
       echo"Please Login ";
}
?>