<link href="style_web.css" rel="stylesheet" type="text/css" />
<SCRIPT LANGUAGE="JavaScript">
function printPage() {
if (window.print)
window.print()
else
alert("Sorry, your browser doesn't support this feature.");
}
</SCRIPT>
<div align=right><input type="button" name="Button" value="พิมพ์เอกสาร" onclick="javascript:this.style.display='none';printPage();">&nbsp;&nbsp;&nbsp;  </div>
<BR>
	<TABLE cellSpacing=0 cellPadding=0 width=1005 height=500 border=0 align="center">
      <TBODY>
		<TR>
		<TD align=center Valign=top>
				
<?
$_GET['id'] = intval($_GET['id']);
//แสดงข่าวสาร/ประชาสัมพันธ์ 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[supper] = $db->select_query("SELECT * FROM ".TB_SUPPER." WHERE id='$_GET[id]' ");
$arr[supper] = $db->fetch($res[supper]);

$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[supper][cat]."'  ");
$arr[user] = $db->fetch($res[user]);

$res[approval] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE id='".$arr[supper][approval_id]."'  ");
$arr[approval] = $db->fetch($res[approval]);
$db->closedb ();
if(!$arr[supper][id]){
	echo "<BR><BR><BR><BR><CENTER><IMG SRC=\"images/icon/notview.gif\" BORDER=\"0\" ><BR><BR><B>ไม่มีเรื่อง</B></CENTER><BR><BR><BR><BR>";
}else{
	$FilesupperTopic = "data/suppertext/".$arr[supper][post_date].".txt";
	$file_open = @fopen($FilesupperTopic, "r");
	$content = @fread ($file_open, @filesize($FilesupperTopic));
	$Detail = stripslashes(FixQuotes($content));
	//ทำการเพิ่มจำนวนคนเข้าชม
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$q[Pageview] = "UPDATE ".TB_SUPPER." SET pageview = pageview+1 WHERE id = '".$_GET[id]."' ";
	$sql[Pageview] = mysql_query ( $q[Pageview] ) or sql_error ( "db-query",mysql_error() );
	
	$db->closedb ();
?>
<TABLE width="980" align=center cellSpacing=0 cellPadding=0 border=0>
				<TR>
					<TD align=center>บันทึกการนิเทศ ออกตรวจเยี่ยม <?echo thainumDigit($arr[supper][school]);?>
					<table width="980" border="0" cellspacing="0" cellpadding="0">
						<tr>
						<td width="100%" valign="bottom" > 
						<td width="200" valign="top"><B><FONT COLOR="#990000" >

</FONT></B></td>
  </tr>
</table>	
					</TD>
  <tr> 
    <td><FONT size=3><B>เรื่อง&nbsp;&nbsp;</B> <?echo thainumDigit($arr[supper][topic]);?></td>
  </tr> 
 <tr> 
    <td>
	<?
					 if($arr[approval][id]){ 	  
?>
	<FONT size=3><B>อ้างถึง&nbsp;&nbsp;</B> หนังสือ<?echo thainumDigit($arr[approval][topic]);?>&nbsp;&nbsp; ตั้งแต่วันที่ <?echo thainumDigit("".thai_date_fullmonth(strtotime($arr[approval][date]))."" );?>  ถึงวันที่ <?echo thainumDigit("".thai_date_fullmonth(strtotime($arr[approval][date1]))."" );?>
	<? } else {echo "";}?>
	</td>
  </tr> 
  <tr>
  <td><FONT size=3><?echo thainumDigit($Detail);?></FONT></td>
  </tr> 
<tr>
<td width="980"  colspan="3" align="left">
<BR>

	 </td>
	 </tr>

<tr>
    <td width="980" bgcolor="#ffffff" colspan="3" align="center">
	<IMG SRC="laysen/<?=$arr[supper][laysen];?>">
	<BR>
<?
	//ทำการเพิ่มจำนวนคนเข้าชม
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[supper][posted]."'  ");
	$arr[user] = $db->fetch($res[user]);
?>
	(<?=$arr[user][category_name];?>)
	<BR>
	<?=$arr[user][posit];?>
	<BR>
<?echo thainumDigit(ThaiTimeConvert($arr[supper][post_date],'2','1'));?>
<BR>
 <TABLE width="100%" cellspacing="2" cellpadding="1" >
<?
//ทำการเพิ่มจำนวนคนเข้าชม
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[supperfile] = $db->select_query("SELECT * FROM ".TB_SUPPERFILE." WHERE supper_id='".$arr[supper][id]."'  ORDER BY id ASC LIMIT 4");
$count=0;
while($arr[supperfile] = $db->fetch($res[supperfile]))
	{
if ($count==0) { echo "<TR>"; }
?>	
<TD width="50%" align="center" >
<IMG SRC="data/supper/<?=$arr[supperfile][full_text];?>" width=500  height=350>
</TD>
<?
$count++;
if (($count%2) == 0) { echo "</TR><TR><TD colspan=3 height=\"1\" ></TD></TR>"; $count=0; 
} else{
	echo "</TD>";
} 


}
$db->closedb ();

?>
</TR>
</TABLE>
	</td>
  </tr>
<?
}
?>
</TABLE>
</TD>
<TR>
</TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>