<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<style type="text/css">
<!--
.calendar { 
    width:1000;
    background-color: #FFFFFF;
}
-->
</style>
	<div align='center'><b>ปฏิทินการปฏิบัติงานของศึกษาธิการจังหวัด</b>
						<?
						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]);
?>
	<TABLE cellSpacing=0 cellPadding=0 width=1005 height=450 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="300" align="center"><font color="#FFFFFF">กิจกรรม</td>
		<td bgcolor="#0099CC" width="150" align="center"><font color="#FFFFFF">สถานที่</td>
		<td bgcolor="#0099CC" width="150" 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>
	<?
$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]);
	$mt=date(m);
	$my=date(Y);
$res[calendar] = $db->select_query("SELECT * FROM ".TB_CALENDAR." ");
$count=0;
$Color == 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]);
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] = eregi_replace("\'", "&#039;", $arr[calendar][subject]);
			$arr[calendar][subject] = htmlspecialchars($arr[calendar][subject]);
			$link['title'] = "".stripslashes($arr[calendar][subject])."";

?>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><?=$rank;?></td>
			<TD bgcolor="<?=$ColorFill; ?>"  valign=top align="center"><?echo  "".thai_date_fullmonth(strtotime($arr[calendar][date_event])."" );?></td>
			<TD bgcolor="<?=$ColorFill; ?>" valign=top align="center"><? echo $arr[calendar][timeout]; ?><? echo $arr[user][category_name]; ?></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[calendar][person]; ?></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]=='4')AND($arr[user][status]==1)OR($arr[user][cotton]=='4')AND($arr[user][status]==1)){  // ศธจ.============================================ 
?>
<td width="60" valign="top">
				  <a href="?name=admin&file=editevent&id=<? echo $arr[calendar][id];?>"><img src="images/admin/edit.gif" border="0" alt="แก้ไข" ></a> 
				  <a href="javascript:Confirm('?name=admin&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>