| Server IP : 104.21.80.248 / 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/myschool/benjama/modules/calendar/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<link href="style_p.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.calendar {
width:1000;
background-color: #FFFFFF;
}
</style>
<div align='left'> <IMG SRC="images/icon/calendar.gif" BORDER="0" ALIGN="absmiddle">
<b>E-Meeting</b> <IMG SRC="images/add.gif" BORDER="0" ALIGN="absmiddle">
<A HREF="popup.php?name=calendar&file=addevent" onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 600} )" class="highslide">
<font color=blue><b><u>จองห้องประชุม</u><b></font></A>
<font color=red>รายการจองห้องประชุม</font><div>
<div align='center'>
<?
if(!$_GET['month']){
$_GET['month'] = date("m");
}
if(!$_GET['year']){
$_GET['year'] = date("Y");
}
$cal = new MyCalendar;
echo $cal->getmonthView($_GET['month'],$_GET['year'] );
?>
</div>
<?
$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]);
?>
<?php
$ym = sprintf("%4d-%02d" , $_GET['year'] , $_GET['month']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=1005 height=200 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<table cellSpacing=1 cellPadding=1 width=1005 border=0>
<tr>
<td colspan=8 align=center ><font color=#990099><b>รายการจองห้องประชุมเดือน <? echo $ym; ?></b></font>
</td>
</tr>
<tr>
<td bgcolor="#0099CC" width="20" align="center"><font color="#FFFFFF">ที่</td>
<td bgcolor="#0099CC" width="120" align="center"><font color="#FFFFFF">ห้อง</td>
<td bgcolor="#0099CC" width="120" align="center"><font color="#FFFFFF">วัน เดือน ปี</td>
<td bgcolor="#0099CC" width="100" align="center"><font color="#FFFFFF">เวลา</td>
<td bgcolor="#0099CC" width="450" align="center"><font color="#FFFFFF">รายการ</td>
<td bgcolor="#0099CC" width="60" align="center"><font color="#FFFFFF">จำนวน</td>
</tr>
<?
$res[mcal] = $db->select_query($sql="SELECT * FROM ".TB_CALENDAR." WHERE substr(date_event,1,7)='". $ym ."' ORDER BY date_event " );
//echo $sql ;
$count=0;
$rank=1;
while($arr[mcal] = $db->fetch($res[mcal])){
//print_r($arr[mcal]);
?>
<tr>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?=$rank;?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top >
<A HREF="javascript:NewWindow('popup2.php?name=calendar&file=print&id=<?echo $arr[mcal][id];?>','acepopup','1024','720','center','front');">
<? echo $arr[mcal][room]; ?>
</a>
</td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?echo "".thai_date_short(strtotime($arr[mcal][date_event])."" );?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><? echo $arr[mcal][timein]; ?>-<? echo $arr[mcal][timeout]; ?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top>
<A HREF="javascript:NewWindow('popup2.php?name=calendar&file=print&id=<?echo $arr[mcal][id];?>','acepopup','1024','720','center','front');">
- <? echo $arr[mcal][subject]; ?>
</a></td>
<TD bgcolor="<?=$ColorFill; ?>"align=center valign=top> <? echo $arr[mcal][detail]; ?></td>
</TR>
<?php
$rank++;
}
?>
</TBODY>
</TABLE>
<br>
<TABLE cellSpacing=0 cellPadding=0 width=1005 height=200 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<table cellSpacing=1 cellPadding=1 width=1005 border=0>
<tr>
<td colspan=8 align=center ><font color=#990099><b>รายการจองห้องประชุมของ<? echo $arr[user][category_name]; ?></b></font>
</td>
</tr>
<tr>
<td bgcolor="#0099CC" width="20" align="center"><font color="#FFFFFF">ที่</td>
<td bgcolor="#0099CC" width="120" align="center"><font color="#FFFFFF">ห้อง</td>
<td bgcolor="#0099CC" width="120" align="center"><font color="#FFFFFF">วัน เดือน ปี</td>
<td bgcolor="#0099CC" width="100" align="center"><font color="#FFFFFF">เวลา</td>
<td bgcolor="#0099CC" width="450" align="center"><font color="#FFFFFF">รายการ</td>
<td bgcolor="#0099CC" width="60" align="center"><font color="#FFFFFF">จำนวน</td>
<td bgcolor="#0099CC" width="40" align="center"><font color="#FFFFFF">แก้ไข</td>
<td bgcolor="#0099CC" width="40" align="center"><font color="#FFFFFF">ลบ</td>
</tr>
<?
$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 = 20 ;
$where = "WHERE person='".$arr[user][id]."'";
$where ="";
$SUMPAGE = $db->num_rows(TB_CALENDAR,"id",$where);
$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[calendar] = $db->select_query("SELECT * FROM ".TB_CALENDAR." WHERE person='".$arr[user][id]."' ORDER BY date_event DESC LIMIT $goto, $limit");
$count=0;
$rank=1;
while($arr[calendar] = $db->fetch($res[calendar])){
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[calendar][person]."' ");
$arr[user] = $db->fetch($res[user]);
if ($count==0) { echo "<TR>"; }
?>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?=$rank;?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top >
<A HREF="javascript:NewWindow('popup2.php?name=calendar&file=print&id=<?echo $arr[calendar][id];?>','acepopup','1024','720','center','front');">
<? echo $arr[calendar][room]; ?>
</a>
</td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?echo "".thai_date_short(strtotime($arr[calendar][date_event])."" );?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><? echo $arr[calendar][timein]; ?>-<? echo $arr[calendar][timeout]; ?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top>
<A HREF="javascript:NewWindow('popup2.php?name=calendar&file=print&id=<?echo $arr[calendar][id];?>','acepopup','1024','720','center','front');">
- <? echo $arr[calendar][subject]; ?>
</a></td>
<TD bgcolor="<?=$ColorFill; ?>"align=center valign=top> <? echo $arr[calendar][detail]; ?></td>
<td valign="top"align="center">
<a href="popup.php?name=calendar&file=addevent&op=calendar_edit&id=<? echo $arr[calendar][id];?>"
onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 600} )" class="highslide" style="visibility: visible;"
><img src="images/edit.gif" border="0" alt="แก้ไข" ></a>
</td>
<td valign="top"align="center">
<a href="javascript:Confirm('?name=admin&file=delevent&id=<? echo $arr[calendar][id];?>','คุณมั่นใจในการลบปฏิทินหัวข้อนี้ ?');"><img src="images/delete.gif" border="0" alt="ลบ" ></a>
</td>
</tr>
<tr>
<td height="1" align="left" class="dotline" colspan="5"></td>
</tr>
<?
$rank++;
}
$count++;
?>
</table>
<?
SplitPage($page,$totalpage,"?name=calendar&file=person&person=".$_GET[person]."");
echo $ShowPages ;
?>
</TD>
</TR>
</TBODY>
</TABLE>