| Server IP : 104.21.80.248 / Your IP : 172.71.28.155 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 : E:/Inetpub/www/myschool/paktho/modules/tkk9/ |
Upload File : |
<link href="style.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function showemotion() {
emotion1.style.display = 'none';
emotion2.style.display = '';
}
function closeemotion() {
emotion1.style.display = '';
emotion2.style.display = 'none';
}
function emoticon(theSmilie) {
document.form2.COMMENT.value += ' ' + theSmilie + ' ';
document.form2.COMMENT.focus();
}
</script>
<?
$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]);
//แสดงข่าวสาร/ประชาสัมพันธ์
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[tkk9] = $db->select_query("SELECT * FROM ".TB_TKK9." WHERE id='".$_GET[id]."' ");
$arr[tkk9] = $db->fetch($res[tkk9]);
$db->closedb ();
?>
<TABLE align=center cellSpacing=0 cellPadding=0 width=1005 height=420 border=0 >
<TR>
<TD valign="top">
<BR>
<TABLE align=center cellSpacing=0 cellPadding=0 width=853 border=0 >
<TR align="left">
<td width=793></td>
<TD width=150 align="right" valign="bottom" colspan="3">
<FORM NAME="Form2" METHOD=POST ACTION="?name=tkk9&file=comment&id=<?echo $arr[tkk9][id];?>">
<INPUT TYPE="hidden" NAME="CATNO" VALUE="<?=$arr[user][id];?> " readonly style=\"color: #FF0000" >
<INPUT TYPE="submit" name="submit" value="ลงทะเบียนรับ"style="background-color:#DFD95E">
</FORM>
</TD>
</TR>
</TABLE>
<?
$_GET['id'] = intval($_GET['id']);
//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]);
//แสดงข่าวสาร/ประชาสัมพันธ์
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[tkk9] = $db->select_query("SELECT * FROM ".TB_TKK9." WHERE id='".$_GET[id]."' ");
$arr[tkk9] = $db->fetch($res[tkk9]);
$db->closedb ();
if(!$arr[tkk9][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{
$Filetkk9Topic = "data/tkk9text/".$arr[tkk9][post_date].".txt";
$file_open = @fopen($Filetkk9Topic, "r");
$content = @fread ($file_open, @filesize($Filetkk9Topic));
$Detail = stripslashes(FixQuotes($content));
//ทำการเพิ่มจำนวนคนเข้าชม
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$q[Pageview] = "UPDATE ".TB_TKK9." SET pageview = pageview+1 WHERE id = '".$_GET[id]."' ";
$sql[Pageview] = mysql_query ( $q[Pageview] ) or sql_error ( "db-query",mysql_error() );
$db->closedb ();
?>
<TABLE align="center" width="853" background="images/124.jpg" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<B><FONT COLOR="#000066">เรื่อง : <?=$arr[tkk9][topic];?> (<?=$arr[tkk9][pageview];?>)</B>
</td>
</tr>
<tr>
<td><?=$Detail;?></td>
</tr>
</table>
<TABLE align="center" width="850" height=150 border="0" cellspacing="1" cellpadding="1">
<tr>
<td valign="top">
<TABLE align="center" width="850" bgcolor=#99FFFF border="0" cellspacing="1" cellpadding="1">
<tr>
<?
if($arr[tkk9][full_text]){
?>
<td width="750" align="center" bgcolor=#99FFFF ><b>รายการ</td>
<td width="100" align="center" bgcolor=#99FFFF align="center">ดาวน์โหลด</B></td>
</tr>
</table>
<TABLE align="center" width="850" bgcolor=#FFFFFF border="0" cellspacing="1" cellpadding="1">
<TR bgcolor=#FFFFC6 >
<td width="750" >
<b><img src="images/attach.gif"> เอกสารแนบฉบับที่ 1</b>
</td>
<td width="100" align="center">
<a href="data/tkk9/<?=$arr[tkk9][full_text];?>" target="_blank"><b><img src="images/yfile1.png" width="30" height="35"></b> </a>
</td>
<? } else {
echo "";
}?>
</tr>
<tr bgcolor=#ECFEE9>
<?
if($arr[tkk9][full_texts]){
?>
<td width="750" >
<b><img src="images/attach.gif"> เอกสารแนบฉบับที่ 2</b>
</td>
<td width="100" align="center">
<a href="data/tkk9/<?=$arr[tkk9][full_texts];?>" target="_blank"><b><img src="images/yfile2.png"width="30" height="35"></b></A>
</td>
<? } else {
echo "";
}?>
</tr>
<tr bgcolor=#FFFFC6>
<?
if($arr[tkk9][full_textu]){
?>
<td width="750" >
<b><img src="images/attach.gif"> เอกสารแนบฉบับที่ 3</b>
</td>
<td width="100" align="center">
<a href="data/tkk9/<?=$arr[tkk9][full_textu];?>" target="_blank"><b><img src="images/yfile3.png"width="30" height="35"></b></A>
</td>
<? } else {
echo "";
}?>
</tr>
<tr bgcolor=#ECFEE9>
<?
if($arr[tkk9][full_texto]){
?>
<td width="750">
<b><img src="images/attach.gif"> เอกสารแนบฉบับที่ 4</b>
</td>
<td width="100" align="center">
<a href="data/tkk9/<?=$arr[tkk9][full_texto];?>" target="_blank"><b><img src="images/yfile4.png"width="30" height="35"></b></A>
</td>
<? } else {
echo "";
}?>
</tr>
</table>
<? }?>
<!-- End tkk9 -->
</TD>
</TR>
<TR>
<TD>
<table width="850" align="center" border="0" cellspacing="1" cellpadding="1">
<tr>
<td valign="top"width="50%" background="images/124.jpg">
<b><FONT COLOR="#000000">บุคลากรที่รับหนังสือรับแล้ว</font></b><br>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK9_COMMENT." WHERE tkk9_id='".$arr[tkk9][id]."' and catno <>'' ORDER BY id ");
$count=0;
$i=0;
while($arr[comment] = $db->fetch($res[comment])){
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[comment][catno]."' ");
$arr[user] = $db->fetch($res[user]);
$count ++;
$i++;
?>
<FONT COLOR="#000000"><?=$i.".".$arr[user][category_name];?></font><br>
<?
}
//$db->closedb ();
?>
<td width=50% valign="top"><FONT COLOR="#990000"><b><u> บุคลากรที่ยังไม่รับหนังสือ<br>
<?
//=======================================================================================================================================
// เริ่มแสดงรายชื่อบุคลากรที่ยังไม่รับหนังสือเวียน
//=======================================================================================================================================
?>
<?
//เรียกชื่อบุคลากรทั้งหมดมาเก็บค่าไว้
$sql="select * from web_user order by category_name";
$dbquery = mysql_db_query($dbname,$sql);
$num_rows = mysql_num_rows($dbquery);
//echo $num_rows;
$i=0;
$j=1;
$tmpschoolname="";
$name="";
while ($i < $num_rows)
{
$result = mysql_fetch_array($dbquery);
$name = $result['category_name'];
$schoolid = $result['id'];
//echo $name." = ";
//เรียกชื่อบุคลากรที่มีชื่อที่ต้องรับหนังสือ
$sql1="select * from web_tkk9 where web_tkk9.id='".$arr[tkk9][id]."' and category like '%,".$schoolid.",%' order by id";
$dbquery1 = mysql_db_query($dbname, $sql1);
$num_rows1 = mysql_num_rows($dbquery1);
$result1 = mysql_fetch_array($dbquery1);
if($num_rows1!=0)
{
//$name2 = $name2.",".$name." ";
//echo "พบในรายการรับ = ";
//เริ่มกระบวนการตรวจสอบว่ารับหนังสือรึยัง
$sql2="select * from web_tkk9_comment where tkk9_id='".$arr[tkk9][id]."' and catno = '".$schoolid."'";
$dbquery2 = mysql_db_query($dbname, $sql2);
$num_rows2 = mysql_num_rows($dbquery2);
$result2 = mysql_fetch_array($dbquery2);
if($num_rows2==0)
{
//echo "ยัง<br>";
$name1 = $name1." ".$j." . ".$name." <br>";
$j++;
} else {
//echo " รับแล้ว<br>";
}
}else{
//echo "no = <br>";
}
$i++;
}
if ($name1!=""){;
?>
<FONT COLOR="#ff0000"><? echo $name1; ?></font>
<?
} else {
?>
<FONT COLOR="#FF0000"><b><u> บุคลากรรับหนังสือครบแล้ว<br></u></b></font>
<?
$db->closedb ();
}
?>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>