| Server IP : 172.67.187.206 / 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/myschool/nongplamor_new/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: #d7fef6;
}
-->
</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><div>
<div align='center'><font color=red>รายการจองห้องประชุม</font>
<?
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>
<TABLE cellSpacing=0 cellPadding=0 width=1005 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<table cellSpacing=1 cellPadding=1 width=1005 border=0>
<tr><td colspan=6 align=center ><font color=#990099><h4><b>การจองห้องประชุมเดือนนี้</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="100" align="center"><font color="#FFFFFF">วัน เดือน ปี</td>
<td bgcolor="#0099CC" width="100" align="center"><font color="#FFFFFF">เวลา</td>
<td bgcolor="#0099CC" width="*" align="center"><font color="#FFFFFF">กิจกรรม</td>
<td bgcolor="#0099CC" width="60" align="center"><font color="#FFFFFF">จำนวน</td>
<td bgcolor="#0099CC" width="180" align="center"><font color="#FFFFFF">ผู้ขอใช้</td>
<?
if (($arr[user][work]=='9')AND($arr[user][status]==1)OR($arr[user][work]=='4')AND($arr[user][status]==1)OR($arr[user][cotton]=='4')AND($arr[user][status]==1)){ // ศธจ.============================================
?>
<td bgcolor="#0099CC" width="60" align="center"><font color="#FFFFFF">แก้ไข/ลบ</td>
<?
}
?>
</tr>
<?
$mt=$_GET['month'];
$my=$_GET['year'];
if($mt=='') $mt=date(m);
if($my=='') $my=date(Y);
$res[calendar] = $db->select_query("SELECT * FROM ".TB_CALENDAR." where date_event between '$my-$mt-01' and '$my-$mt-31' ORDER BY date_event desc ");
$count=0;
$Color == 0;
$rank=1;
$resa[calendar] = $db->select_query("SELECT * FROM ".TB_CALENDAR." where date_event between '$my-$mt-01' and '$my-$mt-31' ORDER BY date_event desc ");
$arrs[calendar] = $db->fetch($resa[calendar]);
$id=$arrs[calendar][id];
if ($id !='') {
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]);
echo "<TR>";
if($Color == 0){
$Color = 1 ;
$ColorFill = "#F0F0F0";
$textfill="#CC3333";
}else{
$Color = 0 ;
$ColorFill = "#FDEAFB";
$textfill="#0066FF";
}
$year=substr($arr[calendar][date_event],0,4);
$month=substr($arr[calendar][date_event],6,2)-1;
$day=substr($arr[calendar][date_event],8,2);
//echo "$day-$month-$year";
// $link = $this->getDateLink($day, $month, $year);
$link['link'] = "popup.php?name=calendar&file=view&id=".$arr[calendar][id]."&dates=".$arr[calendar][date_event]."";
$arr[calendar][subject] = preg_replace("/\'/i", "'", $arr[calendar][subject]);
$arr[calendar][subject] = htmlspecialchars($arr[calendar][subject]);
$link['title'] = "".stripslashes($arr[calendar][subject])."";
$res[person] = $db->select_query("SELECT * FROM ".TB_user." WHERE id ='". $arr[calendar][person] ."' ");
$arr[person] = $db->fetch($res[person]);
?>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?=$rank;?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><? echo $arr[calendar][room]; ?></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><img src="images/a.gif" border="0"><? echo "<a href=\"".$link['link']."\" onclick=\"return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 700, objectHeight: 500} )\" )\">"; ?><font color="<?=$textfill; ?>"><b><? echo $arr[calendar][subject]; ?></a></td>
<TD bgcolor="<?=$ColorFill; ?>"valign=top> <? echo $arr[calendar][detail]; ?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top ><? echo $arr[person][category_name]; ?></td>
<?
$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)OR($arr[user][work]=='4')AND($arr[user][status]==1)OR($arr[user][cotton]=='4')AND($arr[user][status]==1)){ // ศธจ.============================================
?>
<td width="60" valign="top">
<a href="?name=calendar&file=editevent&id=<? echo $arr[calendar][id];?>"><img src="images/admin/edit.gif" border="0" alt="แก้ไข" ></a>
<a href="?name=calendar&file=delevent&id=<? echo $arr[calendar][id];?>"><img src="images/admin/trash.gif" border="0" alt="ลบ" ></a>
</td>
<?
}
?>
</tr>
<tr>
<td height="1" align="left" class="dotline" colspan="5"></td>
</tr>
<?
$rank++;
}
}
else {
echo "<tr><td colspan=5 align=center bgcolor=#FDEAFB><font color=#990000><b><< ไม่มีกิจกรรมในเดือนนี้ >></b></font></td></tr>";
}
?>
</table>
</TD>
</TR>
</TBODY>
</TABLE>
<br>
<?
//////////////////////////////////////////////////////////
$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]);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=200 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<table cellSpacing=1 cellPadding=1 width=100% 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="5%" align="center"><font color="#FFFFFF">ที่</td>
<td bgcolor="#0099CC" width="20%" align="center"><font color="#FFFFFF">ห้อง</td>
<td bgcolor="#0099CC" width="15%" align="center"><font color="#FFFFFF">วัน เดือน ปี</td>
<td bgcolor="#0099CC" width="10%" align="center"><font color="#FFFFFF">เวลา</td>
<td bgcolor="#0099CC" width="45%" align="center"><font color="#FFFFFF">รายการ</td>
<td bgcolor="#0099CC" width="5%" align="center"><font color="#FFFFFF">จำนวน</td>
<td bgcolor="#0099CC" width="5%" 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 = 10 ;
$SUMPAGE = $db->num_rows(TB_CALENDAR,"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[calendar] = $db->select_query("SELECT * FROM ".TB_CALENDAR." WHERE person='".$arr[user][id]."' ORDER BY detail 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]);
?>
<tr>
<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?=$rank;?></td>
<TD bgcolor="<?=$ColorFill; ?>" valign=top ><? echo $arr[calendar][room]; ?></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="?name=calendar&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++;
}
?>
</table>
<?
SplitPage($page,$totalpage,"?name=calendar&person=".$_GET[person]."");
echo $ShowPages ;
?>
</TD>
</TR>
</TBODY>
</TABLE>