
<?php
    include("../include/FunctionDB.php");
  include("../include/Function.php");
  ConnectDB();
$sql = "Select * From bookmant_tb Where code='$code'";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result)

?>

<html>
<head>
<title>ข้อมูลแผนดำเนินการ</title>
<link href="../source/style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<style type="text/css">
<!--
.style6 {font-size: 14px}
.style17 {font-family: Tahoma; font-size: 16px; }
.style18 {font-family: Tahoma}
.style29 {font-family: Tahoma; font-size: 14px; font-weight: bold; }
.style32 {font-size: 14px; font-family: Tahoma;}
.style15 {color: #003366}
.style1 {    color: #FFFFFF;
    font-weight: bold;
}
.style3 {color: #000000}
-->
</style>
</head>



  <tr>
    <th width="705" scope="col"><form name="form1" method="post" action="">
      <table width="97%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#eeeeee"  style="border:1px solid gray"size="12">
        <tr bgcolor="#6699CC">
          <td height="26" colspan="4"><div align="center" class="style1"><font size="4" face="Tahoma">แสดงรายละเอียด</font></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20"  bordercolor="#D8D2A9"><div align="center"><span class="style3"><font size="2" face="Tahoma">ชนิดของหนังสือ</font></span></div></td>
          <td nowrap bordercolor="#DDF8D1"></td>
          <td nowrap bordercolor="#DDF8D1"><strong><font color="#000000" size="2" face="Tahoma">
            <?php
            echo"$rs[Book_code] ";
      ?>
          </font></strong></td>
          <td width="53" rowspan="10" valign="top" nowrap bordercolor="#DDF8D1"><strong><font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"> </font></strong> <strong><font color="#000000" size="2" face="Tahoma"> </font></strong> <font color="#000000" size="2" face="Tahoma">&nbsp; </font><font color="#003366" size="2" face="Tahoma">&nbsp; </font><font color="#003366" size="2" face="Tahoma">&nbsp; </font> <font color="#000000" size="2" face="Tahoma">&nbsp; </font> </td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20"  bordercolor="#D8D2A9"><div align="center"><font size="2" face="Tahoma">เลขททะเบียนรับ</font></div></td>
          <td nowrap bordercolor="#DDF8D1"></td>
          <td nowrap bordercolor="#DDF8D1"><strong><font color="#000000" size="2" face="Tahoma">
            <?php
            echo"$rs[No]";
      ?>
          </font></strong></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td width="186" height="20"  bordercolor="#D8D2A9"><div align="center"><font size="2" face="Tahoma">วันที่</font></div></td>
          <td nowrap bordercolor="#DDF8D1"></td>
          <td nowrap bordercolor="#DDF8D1"><div align="left"><strong><font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
              <?php 
       $sday = $rs[Date_buy];
    $yearthai = explode("-",$sday);
    $day =      intval($yearthai[2]);
    $month =  intval($yearthai[1]);
    $year =     intval($yearthai[0]);     
          //////////////////
 //   $yearthai =  $day ;
 //    $month = TxtThaiMonth($month);
     echo"$day"."/"."$month"."/"."$year";
    ?>
          </font><font color="#000000" size="2" face="Tahoma"> </font></strong></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20"  bordercolor="#D8D2A9"><div align="center"><font size="2" face="Tahoma">เลขที่หนังสือ</font></div></td>
          <td nowrap bordercolor="#DDF8D1"></td>
          <td nowrap bordercolor="#DDF8D1"><div align="left"><strong><font color="#000000" size="2" face="Tahoma">
              <?php
            echo"$rs[No_in]";
      ?>
          </font></strong></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20"  bordercolor="#D8D2A9" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">เรื่อง</font></div></td>
          <td width="3"  bordercolor="#DDF8D1" bgcolor="#eeeeee"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td width="388" bgcolor="#eeeeee" ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Status]) ?> </font></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20"  bordercolor="#D8D2A9"><div align="center"><font size="2" face="Tahoma"><font size="2" face="Tahoma">ชื่อผู้รับ - ส่งหนังสือ</font></font></div></td>
          <td width="3"  bordercolor="#DDF8D1"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td width="388"  bordercolor="#DDF8D1"><div align="left"><font color="#000000" size="2" face="Tahoma">
              <?php
         $Teacher_code =  $rs["Teacher_code"];
         $sql = "Select * From personal_tb Where Teacher_code='$Teacher_code'";
          $result1 = mysql_query($sql) or die("Error".mysql_error());
          $rss = mysql_fetch_array($result1);
          echo "$rss[Teacher_name] $rss[Teacher_lastname]";
         ?>
          </font></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20" ><div align="center"><font size="2" face="Tahoma"><font size="2" face="Tahoma">ภาค / ฝ่าย </font></font></div></td>
          <td  bordercolor="#DDF8D1"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td  bordercolor="#DDF8D1"><font size="2" face="Tahoma">
            <?php
         $Faculty_code =  $rs["Faculty_code"];
         $sql = "Select * From Faculty_tb Where Faculty_code='$Faculty_code'";
          $result1 = mysql_query($sql) or die("Error".mysql_error());
          $rss = mysql_fetch_array($result1);
          echo "$rss[Faculty_name] ";
         ?>
          </font></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20" ><div align="center"><font size="2" face="Tahoma"><font size="2">ต้องการแจ้งบุคลากรทุกๆ คน</font> </font></div></td>
          <td  bordercolor="#DDF8D1"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td  bordercolor="#DDF8D1"><div align="left"><font color="#003366" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><? echo $rs[Statistic] ?></font><font color="#003366" size="2" face="Tahoma"> </font></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="20"  bordercolor="#D8D2A9"><div align="center"><font size="2" face="Tahoma">จากหน่วยงาน</font></div></td>
          <td  bordercolor="#DDF8D1"><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td  bordercolor="#DDF8D1"><div align="left"><font color="#993333" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><? echo $rs[Store_1] ?></font><font color="#000000" size="2" face="Tahoma"> </font></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="29" nowrap bordercolor="#D8D2A9"><div align="center"><font size="2" face="Tahoma">หมายเหตุ</font></div></td>
          <td ><!--DWLayoutEmptyCell-->&nbsp;</td>
          <td ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></div></td>
        </tr>
        <tr bgcolor="#EEEEEE">
          <td height="26" colspan="4">&nbsp;</td>
        </tr>
      </table>
    </form>
    </th>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>