<?
CheckUsersch($_SESSION['usersch_user'], $_SESSION['usersch_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="15%" align=center ><font color="#FFFFFF"><B>เลขหนังสือ</B></font></td>
		<td  align=center width="55%"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="20%" align=center ><font color="#FFFFFF"><B>ถึง</B></font></td>
		<td  align=center width="10%"><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[year] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id DESC LIMIT 1 ");
		$arr[year] = $db->fetch($res[year]);

$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK2,"id","$SQLwhere category='C1' and posted=".$arr[usersch][id]."  ");
$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='C1' and posted=".$arr[usersch][id]." ORDER BY post_date DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk2] = $db->fetch($res[tkk2])){
	  if ($i%2==0) 
{
	?><tr bgcolor="#F0FFFF" class="unnamed1"><?
} else {
	?><tr bgcolor="#FFFFFF" class="unnamed2"><?
} ?>
     <td valign="top">&nbsp;รอบันทึกเลขทะเบียน</td> 
     <td valign="top">&nbsp;&nbsp;รอ</td>
	 <td valign="top"align="center">รอ</td>
	<td align="center"valign="top"><A HREF="?name=tkk2&file=editsent&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>">คลิกนำส่งเอกสาร</a></B></td>
</tr>
<?
$i++;
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
?> 
</table>
 &nbsp; 
        <?
				SplitPage($page,$totalpage,"?name=tkk2&file=sarabanschool&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
      </TD>
        </TR>
      </TBODY>
    </TABLE>