<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<style type="text/css">
<!--
.calendars { 
    width:1000;
    height:50;
    background-color: #d7fef6;
}
-->
</style>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=450 border=0>
      <TBODY>
        <TR>
          <TD  align='center' vAlign=top>
<?
$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=1 cellPadding=1 width=100%  border=0>
		<tr>
		<td colspan=6 align=center ><div align='left'>&nbsp;&nbsp;<IMG SRC="images/icon/calendar.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp;<b>E-Note</b>&nbsp;&nbsp;<A HREF="popup.php?name=calendars&file=addevent_od" 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'><b>ปฏิทินปฏิบัติงานของ <?=$arr[user][category_name];?> </b>
						<?
						if(!$_GET['month']){
							$_GET['month'] = date("m");
						}
						if(!$_GET['year']){
							$_GET['year'] = date("Y");
						}
						$cal = new MyCalendard;
						echo $cal->getmonthView($_GET['month'],$_GET['year'] );
						?>
	</div>	
		</td>
		</tr>
		<tr>
		<td bgcolor="#0099CC" width="150" align="center"><font color="#FFFFFF">วัน เดือน ปี</td>
		<td bgcolor="#0099CC" width="650" align="center"><font color="#FFFFFF">รายการ</td>
		<td bgcolor="#0099CC" width="200" align="center"><font color="#FFFFFF">ผู้ปฏิบัติ</td>
<?
if  (($arr[user][work]=='9')AND($arr[user][status]==1)OR($arr[user][work]=='3')AND($arr[user][status]==1)OR($arr[user][work]=='4')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[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);

$limit = 5 ;
$SUMPAGE = $db->num_rows(TB_CALENDARS,"id","person='".$arr[user][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[calendars] = $db->select_query("SELECT * FROM ".TB_CALENDARS." WHERE person='".$arr[user][id]."' ORDER BY date_event DESC LIMIT $goto, $limit");
$count=0;
$rank=1;
while($arr[calendars] = $db->fetch($res[calendars])){

	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[calendars][person]."'  ");
	$arr[user] = $db->fetch($res[user]);
	if ($count==0) { echo "<TR>"; }
?>
			<TD bgcolor="<?=$ColorFill; ?>"  valign=top align="center"><?echo  "".thai_date_fullmonth(strtotime($arr[calendars][date_event])."" );?><br><? echo $arr[calendars][timeout]; ?></td>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top>&nbsp;&nbsp;-&nbsp;<font color="<?=$textfill; ?>"><b><? echo $arr[calendars][subject]; ?><br> - <font color=blue><? echo $arr[calendars][detail]; ?></font></td>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top ><? echo $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)OR($arr[user][work]=='3')AND($arr[user][status]==1)OR($arr[user][work]=='4')AND($arr[user][status]==1)){  // ศธจ.============================================ 
?>
<td width="60" valign="top">
				  <a href="javascript:Confirm('?name=calendars&file=delevent&id=<? echo $arr[calendars][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++;
}
$count++;
?>
		</table>
				<?
				SplitPage($page,$totalpage,"?name=calendars&file=person&person=".$_GET[person]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?> 
		  </TD>
        </TR>
      </TBODY>
    </TABLE>