<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=500 border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>
		<A HREF="?name=tkk3&file=tabainperson">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>หนังสือราชการใหม่ ของ สารบรรณกลาง</B>
 <table width="100%"  align=center  cellspacing="2" cellpadding="0" >
	<tr bgcolor="6dbae0">
		<td width="120" align=center ><font color="#FFFFFF"><B>เลขหนังสือ</B></font></td>
		<td  align=center width="350"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="160" align=center  ><font color="#FFFFFF"><B>จาก</B></font></td>
		<td width="150" align=center ><font color="#FFFFFF"><B>ถึง</B></font></td>
		<td  align=center width="90"><font color="#FFFFFF"><B>การปฏิบัติ</B></font></td>
		<td  align=center width="70"><font color="#FFFFFF"><B>จัดการ</B></font></td>
	</tr>  

<?
//CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);

$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK2,"id","$SQLwhere category='B1' ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit); 
$goto = ($page-1)*$limit ;

$res[tkk2] = $db->select_query("SELECT * FROM ".TB_TKK2." WHERE category='B1' ORDER BY post_date DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk2] = $db->fetch($res[tkk2])){

$res[working] = $db->select_query("SELECT * FROM ".TB_WORKING_CAT." WHERE id='".$arr[tkk2][group_ska]."' ");
$arr[working] = $db->fetch($res[working]);
	  if ($i%2==0) 
{
	?><tr bgcolor="#F0FFFF" class="unnamed1"><?
} else {
	?><tr bgcolor="#FFFFFF" class="unnamed2"><?
} ?>
     <td valign="top">&nbsp;<?echo $arr[tkk2][tabain];?></td> 
     <td valign="top"><IMG SRC="myoffice/<? echo $arr[tkk2][praphet];?>.png" Width=10 Height=10>&nbsp;&nbsp;<A HREF="?name=tkk2&file=readtkk2_saraban&id=<?echo $arr[tkk2][id];?>"><?echo $arr[tkk2][topic];?></A>
	 <BR>
<?
		if ($arr[tkk2][full_text]){ 	  
?>

		| <a href="data/tkk2/<?=$arr[tkk2][full_text];?>" target="_blank"><font color=red>หนังสือนำ</font></A> |
<? } else {echo "ไม่มีเอกสาร";}?>
<?
		if($arr[tkk2][full_texts]){ 	  
?>
		<a href="data/tkk2/<?=$arr[tkk2][full_texts];?>" target="_blank"><font color=red>ไฟล์แนบ1</font></A> |
<? } else {echo ""; }?>
<?
		if($arr[tkk2][full_textu]){ 	  
?>
		<a href="data/tkk2/<?=$arr[tkk2][full_textu];?>" target="_blank"><font color=red>ไฟล์แนบ2</font></A> |
<? } else {echo "";}?>
<?
		if($arr[tkk2][full_texto]){ 	  
?>
		<a href="data/tkk2/<?=$arr[tkk2][full_texto];?>" target="_blank"><font color=red>ไฟล์แนบ3</font></A> |
<? } else {echo "";}?>
<?
		if($arr[tkk2][full_texty]){ 	  
?>
		<a href="data/tkk2/<?=$arr[tkk2][full_texty];?>" target="_blank"><font color=red>ไฟล์แนบ4</font></A> |
<? } else {echo "";}?>
	</td>
	<td valign="top"><CENTER><?echo $arr[tkk2][school];?><BR><?echo thai_date_and_time_short($arr[tkk2][post_date],'1','');?></CENTER></td>
	 <td valign="top"align="center">
<?
		if($arr[tkk2][enable_comment ]==1){ 	  
?>
<? echo $arr[working][category_name];?>
<? } else {echo "";}?>
<?
		if($arr[tkk2][enable_comment ]==2){ 	  
?>
หนังสือถูกส่งคืน<BR><!--<? echo $arr[working][category_name];?>-->
<? } else {echo "";}?>
<?
		if($arr[tkk2][edit]==คืน){ 	  
?>
<font color=red>หนังสือถูกส่งคืน<BR><!--<? echo $arr[working][category_name];?>--></font>
<? } else {echo "";}?>
</td>
	<td align="center"valign="top">
<?
		if($arr[tkk2][edit]==นำส่งกลุ่ม){ 	  
?>
		<A HREF="?name=tkk2&file=sentgroup&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>"><? echo $arr[tkk2][edit];?></A>
<? } else {echo "";}?>
 <?
		if($arr[tkk2][edit]==นำส่งเอกสาร){ 	  
?>
		<A HREF="?name=tkk2&file=sent_to1&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>"><? echo $arr[tkk2][edit];?></A>
<? } else {echo "";}?>
<?
		if($arr[tkk2][edit]==จัดเก็บ){ 	  
?>
		<A HREF="?name=tkk2&file=sentperson&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>">นำส่งเจ้าหน้าที่</A>
<? } else {echo "";}?>
 <?
		if($arr[tkk2][edit]==นำส่งเจ้าหน้าที่){ 	  
?>
		<A HREF="?name=tkk2&file=sentperson&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>"><? echo $arr[tkk2][edit];?></A>
<? } else {echo "";}?>
<?
		if($arr[tkk2][edit]==เสนอแฟ้ม){ 	  
?>
		<A HREF="?name=tkk2&file=addlakha&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>">บันทึกเสนอ</A>
<? } else {echo "";}?>
<?
		if($arr[tkk2][edit]==เสนอผู้อำนวยการ){ 	  
?>
		<A HREF="?name=tkk2&file=readod&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>">ดำเนินการต่อ</A>
<? } else {echo "";}?>

<?
		if($arr[tkk2][edit]==คืน){ 	  
?>
<A HREF="?name=tkk2&file=sentgroupedit&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>"><font color=red>จัดการแก้ไข</font></A>
<? } else {echo "";}?>
	 </td>

<td align="center" valign="top">
		<FORM NAME="myform2" METHOD=POST ACTION="?name=tkk2&file=sarabankep&op=tkk2_edit&action=edit&id=<?=$arr[tkk2][id];?>" enctype="multipart/form-data">
			<INPUT TYPE="hidden" NAME="CATEGORY" VALUE="o" readonly style=\"color: #FF0000">
			<INPUT TYPE="hidden" NAME="EDIT" VALUE="จัดเก็บ" readonly style=\"color: #FF0000">
			<INPUT TYPE="hidden" NAME="CAT" VALUE="<?=$arr[user][id];?>" readonly style=\"color: #FF0000">
			<INPUT TYPE="hidden" NAME="NAMECOM" VALUE="<?=$arr[user][id];?>" readonly style=\"color: #FF0000">
			<INPUT TYPE="image" name="submit" value="submit" src="images/save.png" alt="จัดเก็บ">
		</FORM>
<form NAME="myform" METHOD=POST ACTION="?name=tkk2&file=index&op=tkk2_del&op=tkk2_del&id=<?=$arr[tkk2][id];?>">
 <input type="hidden" name="ACTION" value="tkk2_del">
<INPUT TYPE="submit" value="ลบ" name="submit"style="background-color:#FFFF99"> 
 </div>
 </form>	
     </td>
</tr>
<?
$i++;
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
?> 
</table>
 &nbsp; 
        <?
				SplitPage($page,$totalpage,"?name=tkk2&file=sarabanarea&op=tkk2_read&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
      </TD>
        </TR>
      </TBODY>
    </TABLE>