| Server IP : 172.67.187.206 / Your IP : 172.71.28.156 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myoffice/2564/modules_22222/tkk4/ |
Upload File : |
<?
CheckUsersch($_SESSION['usersch_user'], $_SESSION['usersch_pwd']);
?>
<TABLE width="1005" align=center cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD align=center 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]);
?>
<form name="form3" method="post" action="?name=tkk4&file=search">
<table width=1005 border="0" align="right" cellpadding="0" cellspacing="0">
<tr class="unnamed1">
<td width="600" class="unnamed2"><A HREF="?name=tkk4&file=rub"> <img src="images/back.png" align="absmiddle" ></A> <B>กลับหน้าทะเบียนรับหนังสือราชการ ของ <? echo $arr[usersch][name];?></B></td>
<td width="240" align="right"><div align="right"><strong>ระบุชื่อหนังสือที่ต้องการคันหา </strong></div></td>
<td width="100" align="right" ><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
<td width="70"><div align="left"> <input type="submit" name="Submit2" value="ค้นหา"></div></td>
</tr>
</table>
</form>
</TD>
</TR>
<TR>
<TD>
<TABLE width="1005" height=500 align=center cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD valign="top">
<TABLE width="100%" align=center cellspacing="1" cellpadding="1" >
<tr bgcolor="#6fd1dc" height=25>
<td width="470" align="center"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
<td width="140" align="center"><font color="#FFFFFF"><B>วันที่ส่ง</B></font></td>
<td width="200" align="center"><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
<td width="40" align="center"><font color="#FFFFFF"><B>ดูเอกสาร</B></font></td>
<td width="40" 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]);
//แสดงบทความ
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK4,"id","$SQLwhere topic like '%$search%' and category like '%,".$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[tkk4] = $db->select_query("SELECT * FROM ".TB_TKK4." WHERE topic like '%$search%' and category like '%,".$arr[usersch][id].",%' ORDER BY id DESC LIMIT $goto, $limit ");
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 LIMIT 1");
$arr[comment] = $db->fetch($res[comment]);
?>
<?
if(($arr[tkk4][id]==$arr[comment][tkk4_id])){
?>
<tr bgcolor="#FFFFFF">
<td valign="top"><img src="images/krut.png" width=15 align="absmiddle"> <?echo $arr[tkk4][topic];?></td>
<td valign="top" align="center" ><?echo ThaiTimeConvert($arr[tkk4][post_date],'','');?></td>
<td valign="top"> <? echo $arr[tkk4][posted];?></td>
<td valign="top" align="center" ><A HREF="popup.php?name=tkk4&file=readtkk4_1&id=<?echo $arr[tkk4][id];?> " onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 400, objectHeight: 600} )" class="highslide"><img src="images/read.png" width=20></A></td>
<td valign="top" align="center" ><font color="#444400"> รับแล้ว</font></td>
</tr>
<tr>
<td colspan="5" height="1" class="dotline" color=FFFF00></td>
</tr>
<? }?>
<?
}
?>
</table>
<?
SplitPage($page,$totalpage,"?name=tkk4&file=search&search=$search");
echo $ShowSumPages ;
echo $ShowPages ;
?>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>