| 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 : /Inetpub/www/myoffice/2564_old/modules/calendars/ |
Upload File : |
<TABLE width="100%" align=center cellSpacing=1 cellPadding=1 border=0>
<?
$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]);
?>
<?
$_GET['id'] = intval($_GET['id']);
//$_GET['dates'] = intval($_GET['dates']);
$datess=$_GET['dates'];
//แสดงปฏิทิน
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[event] = $db->select_query("SELECT id, date_event, timeout , subject, detail ,post_date, pageview , UNIX_TIMESTAMP(date_event) AS date_event2 FROM ".TB_CALENDARS." WHERE date_event='".$_GET[dates]."' ");
$arr[event] = $db->fetch($res[event]);
$db->closedb ();
if(!$arr[event][date_event]){
echo "<BR><BR><BR><BR><CENTER><IMG SRC=\"images/icon/notview.gif\" BORDER=\"0\" ><BR><BR><B>ไม่มีรายการปฏิทินกิจกรรมในวัน $datess </B></CENTER><BR><BR><BR><BR>";
}else{
// $FileEventTopic = "calendardata/".$arr[event][date_event].".txt";
// $file_open = @fopen($FileEventTopic, "r");
// $content = @fread ($file_open, @filesize($FileEventTopic));
// $Detail = stripslashes(FixQuotes($content));
$Detail = $arr[event][detail];
$ID=$arr[event][id];
//ทำการเพิ่มจำนวนคนเข้าชม
?>
<TR>
<TD colspan=5>
<B><IMG SRC="images/icon/calendar.gif" WIDTH="16" HEIGHT="15" BORDER="0" ALIGN="absmiddle"> <FONT COLOR="#990000"><?= ThaiTimeConvert($arr[event][date_event2],"1","");?></FONT><BR>
</TD>
</TR>
<tr bgcolor="#0099CC">
<td width="100" align="center"><h5><font color="#FFFFFF">เวลา</td>
<td width="440" align="center"><h5><font color="#FFFFFF">กิจกรรม</td>
<td width="200" align="center"><h5><font color="#FFFFFF">รายละเอียด</td>
<td width="200" align="center"><h5><font color="#FFFFFF">ผู้ปฏิบัติ</td>
<?
if (($arr[user][work]=='9')AND($arr[user][status]==1)){ // ศธจ.============================================
?>
<td bgcolor="#0099CC" width="60" align="center"><font color="#FFFFFF">ลบ</td>
<?
}
?>
</tr>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[events] = $db->select_query("SELECT id, date_event, timeout , subject, detail , person ,post_date, pageview , UNIX_TIMESTAMP(date_event) AS date_event2 FROM ".TB_CALENDARS." WHERE work between 2 and 4 and date_event ='".$_GET[dates]."' ");
//$arr[event] = $db->fetch($res[event]);
while($arr[events] = $db->fetch($res[events])){
$Detail = $arr[events][detail];
$id=$arr[events][id];
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[events][person]."' ");
$arr[user] = $db->fetch($res[user]);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$q[Pageview] = "UPDATE ".TB_CALENDARS." SET pageview = pageview+1 WHERE id = '$id' ";
$sql[Pageview] = mysql_query ( $q[Pageview] ) or sql_error ( "db-query",mysql_error() );
?>
<tr bgcolor="#FFFFDD" >
<td width="100" align="center"valign="top"><? if ($arr[events][timeout]<>'') { echo "<font color=\"#CC0000\">".$arr[events][timeout]." </font>";}?></td>
<td width="300" valign="top"> <?=$arr[events][subject];?></td>
<td width="150" valign="top"> <?=$arr[events][detail];?></td>
<td width="120" valign="top"> <?=$arr[user][category_name];?></td>
<?
$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]);
?>
<?
if (($arr[user][work]=='9')AND($arr[user][status]==1)){ // ศธจ.============================================
?>
<td width="60" align="center"valign="top">
<a href="javascript:Confirm('?name=calendars&file=deleventmy&id=<? echo $arr[events][id];?>','คุณมั่นใจในการลบปฏิทินหัวข้อนี้ ?');"><img src="images/admin/trash.gif" border="0" alt="ลบ" ></a>
</td>
<?
}
?>
</tr>
<?
}
?>
<?
}
?>
</TABLE>