<?
//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>
<?
if($_SESSION['user_user']==""){
?>
	<div align='center'><font size=4 color=red>รายการจองรถ</font>
						<?
						if(!$_GET['month']){
							$_GET['month'] = date("m");
						}
						if(!$_GET['year']){
							$_GET['year'] = date("Y");
						}
						$cal = new MyCalendar_car;
						
						echo $cal->getmonthView($_GET['month'],$_GET['year'] );

						?>
	</div>

<?

CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
//exit;
}
?>
	<div align='left'>&nbsp;&nbsp;<IMG SRC="images/icon/calendar.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp;<b>E-CAR</b>&nbsp;&nbsp;<IMG SRC="images/add.gif" BORDER="0" ALIGN="absmiddle">&nbsp;&nbsp;<A HREF="popup.php?name=car&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 size=5 color=red>รายการจองรถ</font>
						<?
						if(!$_GET['month']){
							$_GET['month'] = date("m");
						}
						if(!$_GET['year']){
							$_GET['year'] = date("Y");
						}
						$cal = new MyCalendar_car;
						
						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=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_CAR,"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_CAR."  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]);
	if ($count==0) { echo "<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>&nbsp;&nbsp;-&nbsp;<? 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="javascript:Confirm('?name=car&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=car&person=".$_GET[person]."");
				echo $ShowPages ;
				?> 
		  </TD>
        </TR>
      </TBODY>
    </TABLE>