<style type="text/css">
.calendar { 
    width:1000;
    background-color: #d7fef6;
}

</style>


	<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>

		</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;

$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);

$sql = "SELECT * FROM ".TB_CALENDAR."  ORDER BY date_event  " ;
$res[calendar] = $db->select_query( $sql);
$arr[calendar] = $db->fetch($res[calendar]);
$id=$arr[calendar][id];

//print_r($db) ;
//echo $sql ;

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", "&#039;", $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>
            <? // 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]; ?></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>