<?
CheckUsersch($_SESSION['usersch_user'], $_SESSION['usersch_pwd']);
?>
<TABLE align=center  cellSpacing=0 cellPadding=0 width=100% height="500"border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>
<?
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE username='".$_SESSION['usersch_user']."' ");
		$arr[usersch] = $db->fetch($res[usersch]);
?> 
		  <A HREF="?name=tkk4&file=index&category=<?=$arr[usersch][id];?>"">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>หนังสือเข้าใหม่ของ<? echo $arr[usersch][name];?></B>
<TABLE width="100%" align=center cellSpacing=0 cellPadding=0 border=0>
 <table width="100%" cellspacing="1" cellpadding="0" >
  <tr bgcolor="#336633" height=25>
		<td  align=center width="10%"><font color="#FFFFFF"><B>เลขหนังสือ</B></font></td>
		<td  align=center width="50%"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="20%"  align=center ><font color="#FFFFFF"><B>ผู้ส่ง</B></font></td>
		<td width="10%"  align=center ><font color="#FFFFFF"><B>สถานะ</B></font></td>
  </tr>  
 <?
//	CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE username='".$_SESSION['usersch_user']."' ");
		$arr[usersch] = $db->fetch($res[usersch]);
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[tkk4] = $db->select_query("SELECT * FROM ".TB_TKK4." WHERE category like '%,".$arr[usersch][id].",%' ORDER by update_date DESC  ");

while($arr[tkk4] = $db->fetch($res[tkk4]))
	{
	//Check Comment
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK4_COMMENT." WHERE tkk4_id='".$arr[tkk4][id]."' and catno='".$arr[usersch][id]."' ORDER BY id ");
	$arr[comment] = $db->fetch($res[comment]);
	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[tkk4][cat]."' ORDER BY id ");
	$arr[user] = $db->fetch($res[user]);	
?>
 <?
		if(($arr[tkk4][id]!=$arr[comment][tkk4_id])){ 	  
?>
			<tr bgcolor=#FFFFFF>
			<td valign="top">&nbsp;ศธ <?echo$arr[tkk4][tabain];?></td> 
			<td valign="top">
			<font color="#FF0000"><img src="images/krut.png" width=15 align="absmidd">&nbsp;&nbsp;<?echo $arr[tkk4][topic];?></font>	&nbsp;&nbsp;ลว.<?echo thai_date_fullmonth(strtotime($arr[tkk4][date]),'','');?>
			<BR>
			<?
					if($arr[tkk4][full_text]){ 	  
			?>
			รายการเอกสาร : 
			<a href="data/tkk4/<?=$arr[tkk4][full_text];?>" target="_blank"><FONT COLOR="#0000FF"><b>หนังสือนำ</b></A>
		   <? } else {echo "ไม่มีเอกสาร";}?>
			<?
					 if($arr[tkk4][full_texts]){ 	  
			?>
			, <a href="data/tkk4/<?=$arr[tkk4][full_texts];?>" target="_blank"><FONT COLOR="#0000FF" ><b>แนบฉบับ 1</b></A>
			 <? } else {echo "";}?>
			<?
					 if($arr[tkk4][full_textu]){ 	  
			?>
			, <a href="data/tkk4/<?=$arr[tkk4][full_textu];?>" target="_blank"><FONT COLOR="#0000FF"><b>แนบฉบับ 2</b></A>
			 <? } else {echo "";}?>
			<?
					 if($arr[tkk4][full_texto]){ 	  
			?>
			, <a href="data/tkk4/<?=$arr[tkk4][full_texto];?>" target="_blank"><FONT COLOR="#0000FF" ><b>แนบฉบับ 3</b></A>
			 <? } else {echo "";}?>
			<?
					 if($arr[tkk4][full_texty]){ 	  
			?>
			, <a href="data/tkk4/<?=$arr[tkk4][full_texty];?>" target="_blank"><FONT COLOR="#0000FF"><b>แนบฉบับ 4</b></A>
			 <? } else {echo "";}?>
			</td>
			<td valign="top" align="center">
			<font color="#FF0000"><? echo $arr[tkk4][posted];?>
			<br>
			โทร : <? echo $arr[user][tel];?></font>
			</td>
			<td align="center" >
			<FORM NAME="form2" METHOD=POST ACTION="?name=tkk4&file=comment&id=<?echo $arr[tkk4][id];?>">
			<INPUT TYPE="hidden" NAME="CATNO" style="width:150" VALUE="<?=$arr[usersch][id];?>"  readonly style=\"color: #FF0000" > 
			<INPUT TYPE="image" name="submit" value="submit" src="images/save.png" alt="จัดเก็บ">
			</FORM>
			</td>
		</tr>
        <tr>
             <td colspan="5" height="1" class="dotline" color=FFFF00></td>
        </tr>
<?}?>
<?
}		
$db->closedb ();
//จบการแสดงข่าวสาร
?> 																																	
</table>
 </TR>
 </TD>
 </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>