<?php

    /**  Define Validate Access  */
    define( '_VALID_ACCESS', 1 );
    
    /**  Configuration  */
    include( "configuration.php" );
    require_once( $_Config_absolute_path . "/includes/framework.php" );

    /**  Create Database Object  */
    $dbObj = new DBConn;
    
    /**  Config Table for This Page  */
    $myTable = "formation_tb";
    $myTableFK = "Code";
    
    $sql = " SELECT *  FROM $myTable  WHERE $myTableFK='$Code' ";
    $result = $dbObj->execQuery($sql);
    $rs = $dbObj->fetchArray($result);
    
?>
<html>
<head>
<title>Information ข่าวประชาสัมพันธ์</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="./css/default.css" rel="stylesheet" type="text/css" />

<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <th scope="col"><form name="form1" method="post" action="">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="10"></td>
        </tr>
      </table>
      <fieldset>
        <table width="98%" border="0" align="center">
          <tr>
            <td><table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#006699" style="border:0px solid gray">
              <tr bgcolor="#7CAB84" >
                <td height="5" colspan="2" bgcolor="#FFFFFF"></td>
              </tr>
              <tr bgcolor="#7CAB84" >
                <td height="25" colspan="2" align="center" bgcolor="#F0F0F0" class="NOTE"><strong>ข่าวประชาสัมพันธ์</strong></td>
              </tr>
              <tr bgcolor="#99CCFF">
                <td height="10" valign="top" bordercolor="#003366" bgcolor="#FFFFFF"></td>
                <td height="10" valign="top" bordercolor="#CCCCCC" bgcolor="#FFFFFF"></td>
              </tr>
              <tr bgcolor="#99CCFF">
                <td width="13%" height="20" align="left" valign="top" bordercolor="#003366" bgcolor="#FFFFFF">รายละเอียด</td>
                <td width="87%" valign="top" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"><?php echo htmlspecialchars_decode( nl2br( $rs['InforDetail'] ) ); ?></td>
              </tr>
              <tr bgcolor="#99CCFF">
                <td height="20" align="left" bordercolor="#003366" bgcolor="#FFFFFF">ชื่อผู้แจ้ง</td>
                <td bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="TEXT-GREEN10"><?php
                    $sql = " SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId WHERE Teacher_code='$rs[Teacher_code]' ";
                    $result1 = $dbObj->execQuery($sql);
                    $rss = $dbObj->fetchArray($result1);
                    echo "$rss[First_name] $rss[Teacher_name] &nbsp; $rss[Teacher_lastname]";
                ?></td>
              </tr>
              <tr bgcolor="#99CCFF">
                <td height="20" align="left" bordercolor="#003366" bgcolor="#FFFFFF">วันเลาที่ประกาศ</td>
                <td bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"><?php echo $rs['date_updated']; ?></td>
              </tr>
              <tr bgcolor="#7CAB84">
                <td height="5" colspan="2" bgcolor="#FFFFFF"></td>
              </tr>
          </table></tr>
        </table>
      </fieldset>
      <br />
      <div align="center"><input type="button" name="Submit" value="ปิดหน้าต่าง" onClick="javascript:parent.close();" class="CURSOR-HAND" /></div>
    </form></th>
  </tr>
</table>
</body>
</html>
<?php
    /**  Free Resource */
    $dbObj->freeresult($result);

    /**  Close the Database  */
    $dbObj->disconn();
    
    /**  Unset Class  */
    unset($dbObj);
?>