<?php
include("../include/FunctionDB.php");
include("admin_menu.php");
 ConnectDB();
$strSQL = "SELECT * FROM  bookmant_tb GROUP By  Year ";
$result = mysql_query($strSQL); 
$num = mysql_num_rows($result );

?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<style type="text/css">
<!--
.style4 {font-size: 14px}
.style6 {color: #FF0000}
.style7 {font-size: 16px}
-->
</style>
<table width="740" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td><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="Book_Acc/addBook.php">เพิ่มข้อมูลหนังสือรับ-ส่ง</a></font></legend>
            <label><div align="center">
              <form id="form1" name="form1" method="post" action="">
                <table width="79%" height="187" border="1" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" style="background-color:#eeeeee; border:1px solid gray"size="12">
                  <tr>
                    <td background="Image/barIns2.jpg" bgcolor="#D1E1F0"><div align="center"><font color="#000000" size="4" face="Tahoma"><strong>สถานะข้อมูล</strong></font></div></td>
                  </tr>
                  <tr>
                    <td height="160" bgcolor="#D1E1F0" ><div align="center">
                        <table width="88%" border="0" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#FFFFFF" style="border:1px solid gray">
                          <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
                            <td width="5%" bgcolor="#E4F3F8"><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="75%" bgcolor="#E4F3F8" class="style4"><font face="Tahoma"><a href="AccByname.php" class="d">ข้อมูลครุภัณฑ์</a></font></td>
                            <td width="20%" bgcolor="#E4F3F8"><div align="center"><strong><font size="4" face="Tahoma">
                                <?php 
                         // $code = $rs["code"];
                          $sql4 = "Select * From accessories_tb ";
                          $result4 = mysql_query($sql4) or die(" Error".mysql_error());
                          $rc1 = mysql_num_rows($result4);
                           if ( $rc1 == 0)
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">";
                               echo"ยังไม่ข้อมูล";
                               echo"</font>";
                              }
                            else if ($rc1  > 0) 
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">";
                               echo"$rc1  <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">ระเบียน</font>";
                               echo"</font>";
                              } 
                          ?>
                            </font></strong></div></td>
                          </tr>
                          <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
                            <td bgcolor="#E4F3F8"><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="#E4F3F8" class="style4"><font face="Tahoma">ข<a href="Book_Acc/Support/building/BuildingList.php" class="d">้</a>อมูลครุภัณฑ์และสิ่งก่อสร้าง</font></td>
                            <td bgcolor="#E4F3F8"><div align="center"><strong><font size="4" face="Tahoma">
                                <?php 
                         // $code = $rs["code"];
                          $sql2 = "Select * From building_tb ";
                          $result2 = mysql_query($sql2) or die(" Error".mysql_error());
                          $rc = mysql_num_rows($result2);
                           if ( $rc == 0)
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">";
                               echo"ยังไม่ข้อมูล";
                               echo"</font>";
                              }
                            else if ($rc  > 0) 
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">";
                               echo"$rc  <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">ระเบียน</font>";
                               echo"</font>";
                              } 
                          ?>
                            </font></strong></div></td>
                          </tr>
                          <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
                            <td bgcolor="#E4F3F8"><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="#E4F3F8" class="style4"><font face="Tahoma">ข้อมูลการส่งเอกสารฝ่ายบริหาร</font></td>
                            <td bgcolor="#E4F3F8"><div align="center"><strong><font size="4" face="Tahoma">
                                <?php 
                          $code = $rs["Teacher_code"];
                           $sql9 = "Select * From committee_tb  Where Teacher_code='$code'";
                          $result9 = mysql_query($sql9) or die(" Error".mysql_error());
                          $r9 = mysql_num_rows($result9);
                           if ( $r9 == 0)
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">";
                               echo"ยังไม่ข้อมูล";
                               echo"</font>";
                              }
                            else if ($r9  > 0) 
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">";
                               echo"$r9  <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">ระเบียน</font>";
                               echo"</font>";
                              } 
                          ?>
                            </font></strong></div></td>
                          </tr>
                          <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
                            <td bgcolor="#E4F3F8"><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 align="left" bgcolor="#E4F3F8" class="style4"><font face="Tahoma">ข้อมูลฝ่ายบริหาร</font></td>
                            <td bgcolor="#E4F3F8"><div align="center"><strong><font size="4" face="Tahoma">
                                <?php 
                          $code = $rs["Teacher_code"];
                           $sql10 = "Select * From edu_product_tb  Where Teacher_code='$code'";
                          $result10 = mysql_query($sql10) or die(" Error".mysql_error());
                          $r10 = mysql_num_rows($result10);
                           if ( $r10 == 0)
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">";
                               echo"ยังไม่ข้อมูล";
                               echo"</font>";
                              }
                            else if ($r10  > 0) 
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">";
                               echo"$r10  <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">ระเบียน</font>";
                               echo"</font>";
                              } 
                          ?>
                            </font></strong></div></td>
                          </tr>
                          
                          <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
                            <td bgcolor="#E4F3F8"><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="#E4F3F8" class="d style4 style6"><font face="Tahoma"><font face="Tahoma">ข้อมูลการขอรถยนต์</font></font></td>
                            <td bgcolor="#E4F3F8"><div align="center"><strong><font size="4" face="Tahoma"> </font></strong></div></td>
                          </tr>
                          <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" >
                            <td bgcolor="#E4F3F8"><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="#E4F3F8" class="d style4 style6"><font face="Tahoma"><span class="style7"><font face="Tahoma"><a href="Book_Acc/BookByYear.php" class="d">ข้อมูลงานสารบรรณ</a></font></span></font></td>
                            <td bgcolor="#E4F3F8"><div align="center"><strong><font size="4" face="Tahoma">
                                <?php 
                          //$code = $rs["Teacher_code"];
                            $sql10 = "Select * From bookmant_tb ";
                            $result10 = mysql_query($sql10) or die(" Error".mysql_error());
                          $r10 = mysql_num_rows($result10);
                           if ( $r10 == 0)
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">";
                               echo"ยังไม่ข้อมูล";
                               echo"</font>";
                              }
                            else if ($r10  > 0) 
                              {
                              echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">";
                               echo"$r10  <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">ระเบียน</font>";
                               echo"</font>";
                              } 
                          ?>
                            </font><font size="4" face="Tahoma"> </font></strong></div></td>
                          </tr>
                        </table>
                    </div></td>
                  </tr>
                </table>
              </form>
              <br>
              <br>
            </div></label>
        </fieldset><br>
        <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ</font></td>
    </tr>
</table>